DBMS > BigchainDB vs. Microsoft Access vs. Riak KV

System Properties Comparison BigchainDB vs. Microsoft Access vs. Riak KV

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
Name	BigchainDB  Xexclude from comparison	Microsoft Access  Xexclude from comparison	Riak KV  Xexclude from comparison
Description	BigchainDB is scalable blockchain database offering decentralization, immutability and native assets	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.)	Distributed, fault tolerant key-value store
Primary database model	Document store	Relational DBMS	Key-value store with links between data sets and object tags for the creation of secondary indexes
DB-Engines Ranking measures the popularity of database management systems Trend Chart	Score 0.77 Rank #199   Overall #32   Document stores	Score 145.09 Rank #9   Overall #6   Relational DBMS	Score 6.31 Rank #67   Overall #10   Key-value stores
Website	www.bigchaindb.com	www.microsoft.com/­en-us/­microsoft-365/­access	riak.com/­products/­riak-kv
Technical documentation	bigchaindb.readthedocs.io/­en/­latest	developer.microsoft.com/­en-us/­access
Developer		Microsoft	Basho Technologies
Initial release	2016	1992	2009
Current release		1902 (16.0.11328.20222), March 2019	2.1.0, April 2015
License Commercial or Open Source	Open Source AGPL v3	commercial Bundled with Microsoft Office	Open Source Apache version 2, commercial enterprise edition
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++	Erlang
Server operating systems	Linux	Windows Not a real database server, but making use of DLLs	Linux OS X
Data scheme	schema-free	yes	schema-free
Typing predefined data types such as float or date	no	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		no
Secondary indexes		yes	restricted
SQL Support of SQL	no	yes but not compliant to any SQL standard	no
APIs and other access methods	CLI Client RESTful HTTP API	ADO.NET DAO ODBC OLE DB	HTTP API Native Erlang Interface
Supported programming languages	Go Haskell Java JavaScript Python Ruby	C C# C++ Delphi Java (JDBC-ODBC) VBA Visual Basic.NET	C unofficial client library C# C++ unofficial client library Clojure unofficial client library Dart unofficial client library Erlang Go unofficial client library Groovy unofficial client library Haskell unofficial client library Java JavaScript unofficial client library Lisp unofficial client library Perl unofficial client library PHP Python Ruby Scala unofficial client library Smalltalk unofficial client library
Server-side scripts Stored procedures		yes since Access 2010 using the ACE-engine	JavaScript and Erlang
Triggers		yes since Access 2010 using the ACE-engine	yes pre-commit hooks and post-commit hooks
Partitioning methods Methods for storing different data on different nodes	Sharding	none	Sharding no "single point of failure"
Replication methods Methods for redundantly storing data on multiple nodes	selectable replication factor	none	selectable replication factor
MapReduce Offers an API for user-defined Map/Reduce methods	no	no	yes
Consistency concepts Methods to ensure consistency in a distributed system			Eventual Consistency
Foreign keys Referential integrity	no	yes	no links between data sets can be stored
Transaction concepts Support to ensure data integrity after non-atomic manipulations of data		ACID but no files for transaction logging	no
Concurrency Support for concurrent manipulation of data	yes	yes	yes
Durability Support for making data persistent	yes,with MongoDB ord RethinkDB	yes but no files for transaction logging	yes
User concepts Access control	yes	no a simple user-level security was built in till version Access 2003	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
	BigchainDB	Microsoft Access	Riak KV
DB-Engines blog posts