DBMS > FoundationDB vs. MySQL vs. OrigoDB vs. TimesTen
System Properties Comparison FoundationDB vs. MySQL vs. OrigoDB vs. TimesTen
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||FoundationDB Xexclude from comparison||MySQL Xexclude from comparison||OrigoDB Xexclude from comparison||TimesTen Xexclude from comparison|
|Created as commercial project in 2013, FoundationDB has been acquired by Apple in March 2015 and was withdrawn from the market. As a consequence, the product was removed from the DB-Engines ranking. In April 2018, Apple open-sourced FoundationDB and it therefore reappears in the ranking.|
|Description||Ordered key-value store. Core features are complimented by layers.||Widely used open source RDBMS||A fully ACID in-memory object graph database||In-Memory RDBMS compatible to Oracle|
|Primary database model||Document store supported via specific layer|
Relational DBMS supported via specific SQL-layer
|Relational DBMS Key/Value like access via memcached API||Document store|
Object oriented DBMS
|Secondary database models||Document store|
|Developer||FoundationDB||Oracle since 2010, originally MySQL AB, then Sun||Robert Friberg et al||Oracle, TimesTen Performance Software, HP originally founded in HP Labs it was acquired by Oracle in 2005|
|Initial release||2013||1995||2009 under the name LiveDB||1998|
|Current release||6.2.28, November 2020||8.0.29, April 2022||11 Release 2 (184.108.40.206.0)|
|License Commercial or Open Source||Open Source Apache 2.0||Open Source GPL version 2. Commercial licenses with extended functionallity are available||Open Source||commercial|
|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.
|ScaleGrid for MySQL: Fully managed MySQL hosting on AWS, Azure and DigitalOcean with high availability and SSH access on the #1 multi-cloud DBaaS.|
|Implementation language||C++||C and C++||C#|
|Server operating systems||Linux|
|Data scheme||schema-free some layers support schemas||yes||yes||yes|
|Typing predefined data types such as float or date||no some layers support typing||yes||User defined using .NET types and collections||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 can be achieved using .NET||no|
|SQL Support of SQL||supported in specific SQL layer only||yes with proprietary extensions||no||yes|
|APIs and other access methods||ADO.NET|
Proprietary native API
|.NET Client API|
Oracle Call Interface (OCI)
|Supported programming languages||.Net|
|Server-side scripts Stored procedures||in SQL-layer only||yes proprietary syntax||yes||PL/SQL|
|Triggers||no||yes||yes Domain Events||no|
|Partitioning methods Methods for storing different data on different nodes||Sharding||horizontal partitioning, sharding with MySQL Cluster or MySQL Fabric||horizontal partitioning client side managed; servers are not synchronized||none|
|Replication methods Methods for redundantly storing data on multiple nodes||yes||Multi-source replication|
|Source-replica replication||Multi-source 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||Linearizable consistency||Immediate Consistency||Immediate Consistency or Eventual Consistency depending on configuration|
|Foreign keys Referential integrity||in SQL-layer only||yes not for MyISAM storage engine||depending on model||yes|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||ACID not for MyISAM storage engine||ACID||ACID|
|Concurrency Support for concurrent manipulation of data||yes||yes table locks or row locks depending on storage engine||yes||yes|
|Durability Support for making data persistent||yes||yes||yes Write ahead log||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||yes||yes|
|User concepts Access control||no||Users with fine-grained authorization concept no user groups or roles||Role based authorization||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,
|Related products and services|
|3rd parties||SQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.|
Navicat for MySQL is the ideal solution for MySQL/MariaDB administration and development.
CData: Connect to Big Data & NoSQL through standard Drivers.
Percona: Database problems? Not on your watch.
Databases run better with Percona.
DbVisualizer is equipping database professionals with the tools they need to build, manage and maintain state-of-the-art database technologies. It has sky-high user satisfaction and is the preferred tool for database professionals around the world. Customers include Tesla, Apple, Facebook, Deutsche Bank, NASA, and 25,000 others in 145 countries.
Arctype: A fast, beautiful database GUI for developers and teams. Download it for free today.
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|DB-Engines blog posts|