DBMS > Apache IoTDB vs. Datastax Enterprise vs. H2
System Properties Comparison Apache IoTDB vs. Datastax Enterprise vs. H2
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines
|Apache IoTDB Xexclude from comparison
|Datastax Enterprise Xexclude from comparison
|H2 Xexclude from comparison
|An IoT native database with high performance for data management and analysis, deployable on the edge and the cloud and integrated with Hadoop, Spark and Flink
|DataStax Enterprise (DSE) is the always-on, scalable data platform built on Apache Cassandra and designed for hybrid Cloud. DSE integrates graph, search, analytics, administration, developer tooling, and monitoring into a unified platform.
|Full-featured RDBMS with a small footprint, either embedded into a Java application or used as a database server.
|Primary database model
|Time Series DBMS
|Wide column store
|Secondary database models
|Apache Software Foundation
|1.1.0, April 2023
|6.8, April 2020
|2.2.220, July 2023
|License Commercial or Open Source
|Open Source Apache Version 2.0
|Open Source dual-licence (Mozilla public license, Eclipse public license)
|Cloud-based only Only available as a cloud service
|DBaaS offerings (sponsored links) Database as a Service
Providers of DBaaS offerings, please contact us to be listed.
|Datastax Astra DB: Astra DB simplifies cloud-native Cassandra application development for your apps, microservices and functions. Deploy in minutes on AWS, Google Cloud, Azure, and have it managed for you by the experts, with serverless, pay-as-you-go pricing.
|Server operating systems
|All OS with a Java VM (>= 1.8)
|All OS with a Java VM
|Typing predefined data types such as float or date
|XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.
|SQL Support of SQL
|SQL-like query language
|SQL-like DML and DDL statements (CQL); Spark SQL
|APIs and other access methods
|Proprietary protocol CQL (Cassandra Query Language)
TinkerPop Gremlin with DSE Graph
|Supported programming languages
|Server-side scripts Stored procedures
|Java Stored Procedures and User-Defined Functions
|Partitioning methods Methods for storing different data on different nodes
|horizontal partitioning (by time range) + vertical partitioning (by deviceId)
|Sharding no "single point of failure"
|Replication methods Methods for redundantly storing data on multiple nodes
|selectable replication methods; using Raft/IoTConsensus algorithm to ensure strong/eventual data consistency among multiple replicas
|configurable replication factor, datacenter aware, advanced replication for edge computing
|With clustering: 2 database servers on different computers operate on identical copies of a database
|MapReduce Offers an API for user-defined Map/Reduce methods
|Integration with Hadoop and Spark
|Consistency concepts Methods to ensure consistency in a distributed system
Strong Consistency with Raft
Tunable Consistency consistency level can be individually decided with each write operation
|Foreign keys Referential integrity
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data
|no Atomicity and isolation are supported for single operations
|Concurrency Support for concurrent manipulation of data
|yes, multi-version concurrency control (MVCC)
|Durability Support for making data persistent
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.
|User concepts Access control
|Access rights for users can be defined per object
|fine grained access rights according to SQL-standard
|More information provided by the system vendor
|DataStax Enterprise is scale-out data infrastructure for enterprises that need to...
|Supporting the following application requirements: Zero downtime - Built on Apache...
|Typical application scenarios
|Applications that must be massively and linearly scalable with 100% uptime and able...
|Capital One, Cisco, Comcast, eBay, McDonald's, Microsoft, Safeway, Sony, UBS, and...
|Among the Forbes 100 Most Innovative Companies, DataStax is trusted by 5 of the top...
|Licensing and pricing models
We invite representatives of system vendors to contact us for updating and extending the system information,
Related products and services
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|Recent citations in the news
Linux 6.5 With AMD P-State EPP Default Brings Performance & Power Efficiency Benefits For Ryzen Servers
IoTDB Provides Data Management for Industrial Edge IT
provided by Google News
DataStax and LlamaIndex Partner to Make Building RAG Applications Easier than Ever for GenAI Developers
DataStax announces vector search capabilities in its on-prem Apache Cassandra database
DataStax goes vector searching with Astra DB – Blocks and Files
DataStax taps ThirdAI to bring generative AI to its database offerings
provided by Google News
Share this page