DBMS > Alibaba Cloud TSDB vs. Atos Standard Common Repository vs. Heroic vs. IBM Db2 warehouse vs. SwayDB

System Properties Comparison Alibaba Cloud TSDB vs. Atos Standard Common Repository vs. Heroic vs. IBM Db2 warehouse vs. SwayDB

Editorial information provided by DB-Engines
Name	Alibaba Cloud TSDB  Xexclude from comparison	Atos Standard Common Repository  Xexclude from comparison	Heroic  Xexclude from comparison	IBM Db2 warehouse formerly named IBM dashDB  Xexclude from comparison	SwayDB  Xexclude from comparison
		This system has been discontinued and will be removed from the DB-Engines ranking.
Description	A stable, reliable, and cost-effective online high-performance time series database service	Highly scalable database system, designed for managing session and subscriber data in modern mobile communication networks	Time Series DBMS built at Spotify based on Cassandra or Google Cloud Bigtable, and ElasticSearch	Cloud-based data warehousing service	An embeddable, non-blocking, type-safe key-value store for single or multiple disks and in-memory storage
Primary database model	Time Series DBMS	Document store Key-value store	Time Series DBMS	Relational DBMS	Key-value store
DB-Engines Ranking measures the popularity of database management systems Trend Chart	Score 0.29 Rank #301   Overall #26   Time Series DBMS		Score 0.46 Rank #265   Overall #22   Time Series DBMS	Score 1.37 Rank #160   Overall #74   Relational DBMS	Score 0.04 Rank #387   Overall #61   Key-value stores
Website	www.alibabacloud.com/­product/­hitsdb	atos.net/en/convergence-creators/portfolio/standard-common-repository	github.com/­spotify/­heroic	www.ibm.com/­products/­db2/­warehouse	swaydb.simer.au
Technical documentation	www.alibabacloud.com/­help/­en/­time-series-database/­latest/­what-is-tsdb		spotify.github.io/­heroic
Developer	Alibaba	Atos Convergence Creators	Spotify	IBM	Simer Plaha
Initial release		2016	2014	2014	2018
Current release		1703
License Commercial or Open Source	commercial	commercial	Open Source Apache 2.0	commercial	Open Source GNU Affero GPL V3.0
Cloud-based only Only available as a cloud service	yes	no	no	yes	no
DBaaS offerings (sponsored links) Database as a Service Providers of DBaaS offerings, please contact us to be listed.
Implementation language		Java	Java		Scala
Server operating systems	hosted	Linux		hosted
Data scheme	schema-free	Schema and schema-less with LDAP views	schema-free	yes	schema-free
Typing predefined data types such as float or date	Numeric data and Strings	optional	yes	yes	no
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.	no	yes	no	no Import/export of XML data possible	no
Secondary indexes	no	yes	yes via Elasticsearch	yes	no
SQL Support of SQL	no	no	no	yes	no
APIs and other access methods	HTTP REST	LDAP	HQL (Heroic Query Language, a JSON-based language) HTTP API	.NET Client API JDBC ODBC OLE DB
Supported programming languages	Java	All languages with LDAP bindings		Java JavaScript (Node.js) Perl PHP Python R Ruby	Java Kotlin Scala
Server-side scripts Stored procedures	no	no	no	PL/SQL, SQL PL	no
Triggers	no	yes	no	yes	no
Partitioning methods Methods for storing different data on different nodes		Sharding cell division	Sharding	Sharding	none
Replication methods Methods for redundantly storing data on multiple nodes		yes	yes	yes	none
MapReduce Offers an API for user-defined Map/Reduce methods	no		no	no	no
Consistency concepts Methods to ensure consistency in a distributed system	Immediate Consistency	Immediate Consistency or Eventual Consistency depending on configuration	Eventual Consistency Immediate Consistency	Immediate Consistency	Immediate Consistency
Foreign keys Referential integrity	no	no	no	yes	no
Transaction concepts Support to ensure data integrity after non-atomic manipulations of data	no	Atomic execution of specific operations	no	ACID	Atomic execution of operations
Concurrency Support for concurrent manipulation of data	yes	yes	yes	yes	yes
Durability Support for making data persistent	yes	yes	yes	yes	yes
In-memory capabilities Is there an option to define some or all structures to be held in-memory only.	no	yes	no	yes	yes
User concepts Access control	Access managed on TSDB instance level	LDAP bind authentication		fine grained access rights according to SQL-standard	no
More information provided by the system vendor We invite representatives of system vendors to contact us for updating and extending the system information, and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.
Related products and services We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
More resources
	Alibaba Cloud TSDB	Atos Standard Common Repository	Heroic	IBM Db2 warehouse formerly named IBM dashDB	SwayDB
Recent citations in the news				Announcing the deprecation of prior generation Db2 Warehouse plans on AWS 16 October 2023, IBM Introducing the next generation of Db2 Warehouse: Our cost-effective, cloud-native data warehouse built for always-on ... 11 July 2023, IBM The 10 Best Cloud Data Warehouse Solutions to Consider in 2024 22 October 2023, Solutions Review Db2 Warehouse delivers 4x faster query performance than previously, while cutting storage costs by 34x 11 July 2023, IBM Data mining in Db2 Warehouse: the basics 23 June 2020, Towards Data Science provided by Google News

Share this page