DBMS > Atos Standard Common Repository vs. Firebase Realtime Database vs. Heroic vs. SwayDB vs. TimesTen

System Properties Comparison Atos Standard Common Repository vs. Firebase Realtime Database vs. Heroic vs. SwayDB vs. TimesTen

Editorial information provided by DB-Engines
Name	Atos Standard Common Repository  Xexclude from comparison	Firebase Realtime Database  Xexclude from comparison	Heroic  Xexclude from comparison	SwayDB  Xexclude from comparison	TimesTen  Xexclude from comparison
	This system has been discontinued and will be removed from the DB-Engines ranking.
Description	Highly scalable database system, designed for managing session and subscriber data in modern mobile communication networks	Cloud-hosted realtime document store. iOS, Android, and JavaScript clients share one Realtime Database instance and automatically receive updates with the newest data.	Time Series DBMS built at Spotify based on Cassandra or Google Cloud Bigtable, and ElasticSearch	An embeddable, non-blocking, type-safe key-value store for single or multiple disks and in-memory storage	In-Memory RDBMS compatible to Oracle
Primary database model	Document store Key-value store	Document store	Time Series DBMS	Key-value store	Relational DBMS
DB-Engines Ranking measures the popularity of database management systems Trend Chart		Score 13.64 Rank #39   Overall #6   Document stores	Score 0.46 Rank #265   Overall #22   Time Series DBMS	Score 0.04 Rank #387   Overall #61   Key-value stores	Score 1.36 Rank #161   Overall #75   Relational DBMS
Website	atos.net/en/convergence-creators/portfolio/standard-common-repository	firebase.google.com/­products/­realtime-database	github.com/­spotify/­heroic	swaydb.simer.au	www.oracle.com/­database/­technologies/­related/­timesten.html
Technical documentation		firebase.google.com/­docs/­database	spotify.github.io/­heroic		docs.oracle.com/­database/­timesten-18.1
Developer	Atos Convergence Creators	Google acquired by Google 2014	Spotify	Simer Plaha	Oracle, TimesTen Performance Software, HP originally founded in HP Labs it was acquired by Oracle in 2005
Initial release	2016	2012	2014	2018	1998
Current release	1703				11 Release 2 (11.2.2.8.0)
License Commercial or Open Source	commercial	commercial	Open Source Apache 2.0	Open Source GNU Affero GPL V3.0	commercial
Cloud-based only Only available as a cloud service	no	yes	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	Scala
Server operating systems	Linux	hosted			AIX HP-UX Linux OS X Solaris SPARC/x86 Windows
Data scheme	Schema and schema-less with LDAP views	schema-free	schema-free	schema-free	yes
Typing predefined data types such as float or date	optional	yes	yes	no	yes
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.	yes	no	no	no	no
Secondary indexes	yes	yes	yes via Elasticsearch	no	yes
SQL Support of SQL	no	no	no	no	yes
APIs and other access methods	LDAP	Android iOS JavaScript API RESTful HTTP API	HQL (Heroic Query Language, a JSON-based language) HTTP API		JDBC ODBC ODP.NET Oracle Call Interface (OCI)
Supported programming languages	All languages with LDAP bindings	Java JavaScript Objective-C		Java Kotlin Scala	C C++ Java PL/SQL
Server-side scripts Stored procedures	no	limited functionality with using 'rules'	no	no	PL/SQL
Triggers	yes	Callbacks are triggered when data changes	no	no	no
Partitioning methods Methods for storing different data on different nodes	Sharding cell division		Sharding	none	none
Replication methods Methods for redundantly storing data on multiple nodes	yes		yes	none	Multi-source replication Source-replica replication
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 or Eventual Consistency depending on configuration	Eventual Consistency if the client is offline Immediate Consistency if the client is online	Eventual Consistency Immediate Consistency	Immediate Consistency	Immediate Consistency or Eventual Consistency depending on configuration
Foreign keys Referential integrity	no	no	no	no	yes
Transaction concepts Support to ensure data integrity after non-atomic manipulations of data	Atomic execution of specific operations	yes	no	Atomic execution of operations	ACID
Concurrency Support for concurrent manipulation of data	yes	yes	yes	yes	yes
Durability Support for making data persistent	yes	yes	yes	yes	yes by means of logfiles and checkpoints
In-memory capabilities Is there an option to define some or all structures to be held in-memory only.	yes		no	yes	yes
User concepts Access control	LDAP bind authentication	yes, based on authentication and database rules		no	fine grained access rights according to SQL-standard
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
	Atos Standard Common Repository	Firebase Realtime Database	Heroic	SwayDB	TimesTen
DB-Engines blog posts		Cloud-based DBMS's popularity grows at high rates 12 December 2019, Paul Andlinger show all
Recent citations in the news		Realtime vs Cloud Firestore: Which Firebase Database to go? 8 March 2024, Appinventiv Atos cybersecurity blog: Misconfigured Firebase: A real-time cyber threat 18 January 2024, Atos Don't be like these 900+ websites and expose millions of passwords via Firebase 18 March 2024, The Register Google Firebase may have exposed 125M records from misconfigurations 19 March 2024, SC Media Hundreds of Google Firebase websites might have leaked data online 19 March 2024, TechRadar provided by Google News

Share this page