DBMS > BigchainDB vs. FoundationDB vs. Microsoft Access

System Properties Comparison BigchainDB vs. FoundationDB vs. Microsoft Access

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
Name	BigchainDB  Xexclude from comparison	FoundationDB  Xexclude from comparison	Microsoft Access  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	BigchainDB is scalable blockchain database offering decentralization, immutability and native assets	Ordered key-value store. Core features are complimented by layers.	Microsoft Access combines a backend RDBMS (JET / ACE Engine) with a GUI frontend for data manipulation and queries. The Access frontend is often used for accessing other datasources (DBMS, Excel, etc.)
Primary database model	Document store	Document store supported via specific layer Key-value store Relational DBMS supported via specific SQL-layer	Relational DBMS
DB-Engines Ranking measures the popularity of database management systems Trend Chart	Score 0.77 Rank #199   Overall #32   Document stores	Score 1.48 Rank #142   Overall #24   Document stores #27   Key-value stores #70   Relational DBMS	Score 141.82 Rank #9   Overall #6   Relational DBMS
Website	www.bigchaindb.com	www.foundationdb.org	www.microsoft.com/­en-us/­microsoft-365/­access
Technical documentation	bigchaindb.readthedocs.io/­en/­latest	apple.github.io/­foundationdb	developer.microsoft.com/­en-us/­access
Developer		FoundationDB	Microsoft
Initial release	2016	2013	1992
Current release		6.2.28, November 2020	1902 (16.0.11328.20222), March 2019
License Commercial or Open Source	Open Source AGPL v3	Open Source Apache 2.0	commercial Bundled with Microsoft Office
Cloud-based only Only available as a cloud service	no	no	no
DBaaS offerings (sponsored links) Database as a Service Providers of DBaaS offerings, please contact us to be listed.
Implementation language	Python	C++	C++
Server operating systems	Linux	Linux OS X Windows	Windows Not a real database server, but making use of DLLs
Data scheme	schema-free	schema-free some layers support schemas	yes
Typing predefined data types such as float or date	no	no some layers support typing	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.	no
Secondary indexes		no	yes
SQL Support of SQL	no	supported in specific SQL layer only	yes but not compliant to any SQL standard
APIs and other access methods	CLI Client RESTful HTTP API		ADO.NET DAO ODBC OLE DB
Supported programming languages	Go Haskell Java JavaScript Python Ruby	.Net C C++ Go Java JavaScript Node.js PHP Python Ruby Swift	C C# C++ Delphi Java (JDBC-ODBC) VBA Visual Basic.NET
Server-side scripts Stored procedures		in SQL-layer only	yes since Access 2010 using the ACE-engine
Triggers		no	yes since Access 2010 using the ACE-engine
Partitioning methods Methods for storing different data on different nodes	Sharding	Sharding	none
Replication methods Methods for redundantly storing data on multiple nodes	selectable replication factor	yes	none
MapReduce Offers an API for user-defined Map/Reduce methods	no	no	no
Consistency concepts Methods to ensure consistency in a distributed system		Linearizable consistency
Foreign keys Referential integrity	no	in SQL-layer only	yes
Transaction concepts Support to ensure data integrity after non-atomic manipulations of data		ACID	ACID but no files for transaction logging
Concurrency Support for concurrent manipulation of data	yes	yes	yes
Durability Support for making data persistent	yes,with MongoDB ord RethinkDB	yes	yes but no files for transaction logging
User concepts Access control	yes	no	no a simple user-level security was built in till version Access 2003
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
	BigchainDB	FoundationDB	Microsoft Access
DB-Engines blog posts