DBMS > Hypertable vs. Microsoft Access vs. OrientDB

System Properties Comparison Hypertable vs. Microsoft Access vs. OrientDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
Name	Hypertable  Xexclude from comparison	Microsoft Access  Xexclude from comparison	OrientDB  Xexclude from comparison
	Hypertable has stopped its further development with March 2016 and is removed from the DB-Engines ranking.
Description	An open source BigTable implementation based on distributed file systems such as Hadoop	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.)	Multi-model DBMS (Document, Graph, Key/Value)
Primary database model	Wide column store	Relational DBMS	Document store Graph DBMS Key-value store
DB-Engines Ranking measures the popularity of database management systems Trend Chart		Score 141.82 Rank #9   Overall #6   Relational DBMS	Score 4.86 Rank #80   Overall #14   Document stores #5   Graph DBMS #12   Key-value stores
Website		www.microsoft.com/­en-us/­microsoft-365/­access	orientdb.org
Technical documentation		developer.microsoft.com/­en-us/­access	www.orientdb.com/­docs/­last/­index.html
Developer	Hypertable Inc.	Microsoft	OrientDB LTD; CallidusCloud; SAP
Initial release	2009	1992	2010
Current release	0.9.8.11, March 2016	1902 (16.0.11328.20222), March 2019	3.1.9, February 2021
License Commercial or Open Source	Open Source GNU version 3. Commercial license available	commercial Bundled with Microsoft Office	Open Source Apache version 2
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	C++	C++	Java
Server operating systems	Linux OS X Windows an inofficial Windows port is available	Windows Not a real database server, but making use of DLLs	All OS with a Java JDK (>= JDK 6)
Data scheme	schema-free	yes	schema-free Schema can be enforced for whole record ("schema-full") or for some fields only ("schema-hybrid")
Typing predefined data types such as float or date	no	yes	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	restricted only exact value or prefix value scans	yes	yes
SQL Support of SQL	no	yes but not compliant to any SQL standard	SQL-like query language, no joins
APIs and other access methods	C++ API Thrift	ADO.NET DAO ODBC OLE DB	Tinkerpop technology stack with Blueprints, Gremlin, Pipes Java API RESTful HTTP/JSON API
Supported programming languages	C++ Java Perl PHP Python Ruby	C C# C++ Delphi Java (JDBC-ODBC) VBA Visual Basic.NET	.Net C C# C++ Clojure Java JavaScript JavaScript (Node.js) PHP Python Ruby Scala
Server-side scripts Stored procedures	no	yes since Access 2010 using the ACE-engine	Java, Javascript
Triggers	no	yes since Access 2010 using the ACE-engine	Hooks
Partitioning methods Methods for storing different data on different nodes	Sharding	none	Sharding
Replication methods Methods for redundantly storing data on multiple nodes	selectable replication factor on file system level	none	Multi-source replication
MapReduce Offers an API for user-defined Map/Reduce methods	yes	no	no could be achieved with distributed queries
Consistency concepts Methods to ensure consistency in a distributed system	Immediate Consistency
Foreign keys Referential integrity	no	yes	yes relationship in graphs
Transaction concepts Support to ensure data integrity after non-atomic manipulations of data	no	ACID but no files for transaction logging	ACID
Concurrency Support for concurrent manipulation of data	yes	yes	yes
Durability Support for making data persistent	yes	yes but no files for transaction logging	yes
User concepts Access control	no	no a simple user-level security was built in till version Access 2003	Access rights for users and roles; record level security configurable
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
	Hypertable	Microsoft Access	OrientDB
DB-Engines blog posts