Average Ratings 0 Ratings
Average Ratings 0 Ratings
Description
Apache DataFusion is a versatile and efficient query engine crafted in Rust, leveraging Apache Arrow for its in-memory data representation. It caters to developers engaged in creating data-focused systems, including databases, data frames, machine learning models, and real-time streaming applications. With its SQL and DataFrame APIs, DataFusion features a vectorized, multi-threaded execution engine that processes data streams efficiently and supports various partitioned data sources. It is compatible with several native formats such as CSV, Parquet, JSON, and Avro, and facilitates smooth integration with popular object storage solutions like AWS S3, Azure Blob Storage, and Google Cloud Storage. The architecture includes a robust query planner and an advanced optimizer that boasts capabilities such as expression coercion, simplification, and optimizations that consider distribution and sorting, along with automatic reordering of joins. Furthermore, DataFusion allows for extensive customization, enabling developers to incorporate user-defined scalar, aggregate, and window functions along with custom data sources and query languages, making it a powerful tool for diverse data processing needs. This adaptability ensures that developers can tailor the engine to fit their unique use cases effectively.
Description
HSQLDB, or HyperSQL DataBase, stands out as a premier SQL relational database system developed in Java. It boasts a compact, efficient multithreaded transactional engine that accommodates both in-memory and disk-based tables, functioning effectively in embedded and server configurations. Users can take advantage of a robust command-line SQL interface along with straightforward GUI query tools. HSQLDB is distinguished by its comprehensive support for a vast array of SQL Standard features, including the core language components from SQL:2016 and an impressive collection of optional features from the same standard. It provides full support for Advanced ANSI-92 SQL, with only two notable exceptions. Additionally, HSQLDB includes numerous enhancements beyond the Standard, featuring compatibility modes and functionalities that align with other widely used database systems. Its versatility and extensive feature set make it a highly adaptable choice for developers and organizations alike.
API Access
Has API
Yes
API Access
Has API
No
Integrations
Amazon S3
Yes
Apache Arrow
Yes
Apache Avro
Yes
Apache Parquet
Yes
Azure Blob Storage
Yes
C
Yes
Data Virtuality
No
DataClarity Unlimited Analytics
No
DataGrip
No
DbVisualizer
No
Integrations
Amazon S3
No
Apache Arrow
No
Apache Avro
No
Apache Parquet
No
Azure Blob Storage
No
C
No
Data Virtuality
Yes
DataClarity Unlimited Analytics
Yes
DataGrip
Yes
DbVisualizer
Yes
Pricing Details
Free
Free Trial
No
Free Version
Yes
Pricing Details
No price information available.
Free Trial
No
Free Version
No
Deployment
Web-Based
Yes
On-Premises
No
iPhone App
No
iPad App
No
Android App
No
Windows
No
Mac
No
Linux
No
Chromebook
No
Deployment
Web-Based
Yes
On-Premises
No
iPhone App
No
iPad App
No
Android App
No
Windows
No
Mac
No
Linux
No
Chromebook
No
Customer Support
Business Hours
Yes
Live Rep (24/7)
No
Online Support
Yes
Customer Support
Business Hours
Yes
Live Rep (24/7)
No
Online Support
Yes
Types of Training
Training Docs
Yes
Webinars
No
Live Training (Online)
No
In Person
Yes
Types of Training
Training Docs
Yes
Webinars
No
Live Training (Online)
No
In Person
Yes
Vendor Details
Company Name
Apache Software Foundation
Founded
2019
Country
United States
Website
datafusion.apache.org
Vendor Details
Company Name
The hsql Development Group
Website
www.hsqldb.org
Product Features
Database
Backup and Recovery
No
Creation / Development
No
Data Migration
No
Data Replication
No
Data Search
No
Data Security
No
Database Conversion
No
Mobile Access
No
Monitoring
No
NOSQL
No
Performance Analysis
No
Queries
No
Relational Interface
No
Virtualization
No
Product Features
Database
Backup and Recovery
Yes
Creation / Development
Yes
Data Migration
No
Data Replication
No
Data Search
Yes
Data Security
Yes
Database Conversion
Yes
Mobile Access
Yes
Monitoring
No
NOSQL
Yes
Performance Analysis
No
Queries
Yes
Relational Interface
Yes
Virtualization
No