DBMS > Apache IoTDB vs. Atos Standard Common Repository vs. SiteWhere vs. YottaDB

System Properties Comparison Apache IoTDB vs. Atos Standard Common Repository vs. SiteWhere vs. YottaDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
Name	Apache IoTDB  Xexclude from comparison	Atos Standard Common Repository  Xexclude from comparison	SiteWhere  Xexclude from comparison	YottaDB  Xexclude from comparison
		This system has been discontinued and will be removed from the DB-Engines ranking.
Description	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	Highly scalable database system, designed for managing session and subscriber data in modern mobile communication networks	M2M integration platform for persisting/querying time series data	A fast and solid embedded Key-value store
Primary database model	Time Series DBMS	Document store Key-value store	Time Series DBMS	Key-value store
Secondary database models				Relational DBMS using the Octo plugin
DB-Engines Ranking measures the popularity of database management systems Trend Chart	Score 1.31 Rank #164   Overall #14   Time Series DBMS		Score 0.06 Rank #383   Overall #43   Time Series DBMS	Score 0.28 Rank #306   Overall #44   Key-value stores
Website	iotdb.apache.org	atos.net/en/convergence-creators/portfolio/standard-common-repository	github.com/­sitewhere/­sitewhere	yottadb.com
Technical documentation	iotdb.apache.org/­UserGuide/­Master/­QuickStart/­QuickStart.html		sitewhere1.sitewhere.io/­index.html	yottadb.com/­resources/­documentation
Developer	Apache Software Foundation	Atos Convergence Creators	SiteWhere	YottaDB, LLC
Initial release	2018	2016	2010	2001
Current release	1.1.0, April 2023	1703
License Commercial or Open Source	Open Source Apache Version 2.0	commercial	Open Source Common Public Attribution License Version 1.0	Open Source AGPL 3.0
Cloud-based only Only available as a cloud service	no	no	no	no
DBaaS offerings (sponsored links) Database as a Service Providers of DBaaS offerings, please contact us to be listed.
Implementation language	Java	Java	Java	C
Server operating systems	All OS with a Java VM (>= 1.8)	Linux	Linux OS X Windows	Docker Linux
Data scheme	yes	Schema and schema-less with LDAP views	predefined scheme	schema-free
Typing predefined data types such as float or date	yes	optional	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
Secondary indexes	yes	yes	no	no
SQL Support of SQL	SQL-like query language	no	no	by using the Octo plugin
APIs and other access methods	JDBC Native API	LDAP	HTTP REST	PostgreSQL wire protocol using the Octo plugin Proprietary protocol
Supported programming languages	C C# C++ Go Java Python Scala	All languages with LDAP bindings		C Go JavaScript (Node.js) Lua M Perl Python Rust
Server-side scripts Stored procedures	yes	no
Triggers	yes	yes
Partitioning methods Methods for storing different data on different nodes	horizontal partitioning (by time range) + vertical partitioning (by deviceId)	Sharding cell division	Sharding based on HBase
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	yes	selectable replication factor based on HBase	yes
MapReduce Offers an API for user-defined Map/Reduce methods	Integration with Hadoop and Spark		no	no
Consistency concepts Methods to ensure consistency in a distributed system	Eventual Consistency Strong Consistency with Raft	Immediate Consistency or Eventual Consistency depending on configuration	Immediate Consistency
Foreign keys Referential integrity	no	no	no
Transaction concepts Support to ensure data integrity after non-atomic manipulations of data	no	Atomic execution of specific operations	no	optimistic locking
Concurrency Support for concurrent manipulation of data	yes	yes	yes
Durability Support for making data persistent	yes	yes	yes	yes
In-memory capabilities Is there an option to define some or all structures to be held in-memory only.	yes	yes	no	yes
User concepts Access control	yes	LDAP bind authentication	Users with fine-grained authorization concept	Users and groups based on OS-security mechanisms
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
	Apache IoTDB	Atos Standard Common Repository	SiteWhere	YottaDB
Recent citations in the news	AMD EPYC 4364P & 4564P @ DDR5-4800 / DDR5-5200 vs. Intel Xeon E-2488 Review 6 June 2024, Phoronix TsFile: A Standard Format for IoT Time Series Data 27 February 2024, The New Stack Linux 6.5 With AMD P-State EPP Default Brings Performance & Power Efficiency Benefits For Ryzen Servers 21 September 2023, Phoronix Apache Promotes IoT Database Project 25 September 2020, Datanami AMD EPYC 8324P / 8324PN Siena 32-Core Siena Linux Server Performance Review 10 October 2023, Phoronix provided by Google News		SiteWhere: An open platform for connected devices 11 July 2017, Open Source For You 11 Best Open source IoT Platforms To Develop Smart Projects 9 March 2023, H2S Media provided by Google News

Share this page