DBMS > IBM Db2 warehouse vs. STSdb vs. XTDB
System Properties Comparison IBM Db2 warehouse vs. STSdb vs. XTDB
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||IBM Db2 warehouse formerly named IBM dashDB Xexclude from comparison||STSdb Xexclude from comparison||XTDB formerly named Crux Xexclude from comparison|
|Description||Cloud-based data warehousing service||Key-Value Store with special method for indexing optimized for high performance using a special indexing method||A general purpose database with bitemporal SQL and Datalog and graph queries|
|Primary database model||Relational DBMS||Key-value store||Document store|
|Developer||IBM||STS Soft SC||Juxt Ltd.|
|Current release||4.0.8, September 2015||1.19, September 2021|
|License Commercial or Open Source||commercial||Open Source GPLv2, commercial license available||Open Source MIT License|
|Cloud-based only Only available as a cloud service||yes||no||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Server operating systems||hosted||Windows||All OS with a Java 8 (and higher) VM|
|Typing predefined data types such as float or date||yes||yes primitive types and user defined types (classes)||yes, extensible-data-notation format|
|no Import/export of XML data possible||no|
|SQL Support of SQL||yes||no||limited SQL, making use of Apache Calcite|
|APIs and other access methods||.NET Client API|
|.NET Client API||HTTP REST|
|Supported programming languages||Java|
|Server-side scripts Stored procedures||PL/SQL, SQL PL||no||no|
|Partitioning methods Methods for storing different data on different nodes||Sharding||none||none|
|Replication methods Methods for redundantly storing data on multiple nodes||yes||none||yes, each node contains all data|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency|
|Foreign keys Referential integrity||yes||no||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||no||ACID|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes|
|Durability Support for making data persistent||yes||yes||yes, flexibel persistency by using storage technologies like Apache Kafka, RocksDB or LMDB|
|User concepts Access control||fine grained access rights according to SQL-standard||no|
More information provided by the system vendor
Related products and services
|IBM Db2 warehouse formerly named IBM dashDB||STSdb||XTDB formerly named Crux|
|Recent citations in the news|
IBM Collaborates with AWS to Launch a New Cloud Database ...
In A Parallel Universe, There Is An IBM i Data Warehouse, Too
IBM werkt samen met Amazon Web Services om een nieuw ...
AWS re:Invent 2023, IBM e AWS lanciano Amazon RDS for Db2, per ...
IBM named a Leader in The Forrester Wave™: Data Management ...
provided by Google News
Sr. Solution Architect
Sr. Network Architect
Engineer Architect, SME
Share this page