DBMS > Apache Phoenix vs. HugeGraph vs. Oracle Coherence

System Properties Comparison Apache Phoenix vs. HugeGraph vs. Oracle Coherence

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
Name	Apache Phoenix  Xexclude from comparison	HugeGraph  Xexclude from comparison	Oracle Coherence  Xexclude from comparison
Description	A scale-out RDBMS with evolutionary schema built on Apache HBase	A fast-speed and highly-scalable Graph DBMS	Oracles in-memory data grid solution
Primary database model	Relational DBMS	Graph DBMS	Key-value store
DB-Engines Ranking measures the popularity of database management systems Trend Chart	Score 2.81 Rank #108   Overall #56   Relational DBMS	Score 0.20 Rank #288   Overall #22   Graph DBMS	Score 2.56 Rank #114   Overall #21   Key-value stores
Website	phoenix.apache.org	github.com/­hugegraph	www.oracle.com/­middleware/­technologies/­coherence.html
Technical documentation	phoenix.apache.org	hugegraph.github.io/­hugegraph-doc	docs.oracle.com/­en/­middleware/­standalone/­coherence
Developer	Apache Software Foundation	Baidu	Oracle
Initial release	2014	2018	2007
Current release	5.0-HBase2, July 2018 and 4.15-HBase1, December 2019	0.9	12c, September 2016
License Commercial or Open Source	Open Source Apache Version 2.0	Open Source Apache Version 2.0	commercial
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	Java	Java	Java
Server operating systems	Linux Unix Windows	Linux macOS Unix	All OS with a Java VM
Data scheme	yes late-bound, schema-on-read capabilities	yes	schema-free
Typing predefined data types such as float or date	yes	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	no	no
Secondary indexes	yes	yes also supports composite index and range index	no
SQL Support of SQL	yes	no	no
APIs and other access methods	JDBC	Java API RESTful HTTP API TinkerPop Gremlin	JCache JPA RESTful HTTP API
Supported programming languages	C C# C++ Go Groovy Java PHP Python Scala	Groovy Java Python	.Net C++ Java
Server-side scripts Stored procedures	user defined functions	asynchronous Gremlin script jobs	no
Triggers	no	no	yes Live Events
Partitioning methods Methods for storing different data on different nodes	Sharding	yes depending on used storage backend, e.g. Cassandra and HBase	Sharding
Replication methods Methods for redundantly storing data on multiple nodes	Multi-source replication Source-replica replication	yes depending on used storage backend, e.g. Cassandra and HBase	yes, with selectable consistency level
MapReduce Offers an API for user-defined Map/Reduce methods	Hadoop integration	via hugegraph-spark	no
Consistency concepts Methods to ensure consistency in a distributed system	Immediate Consistency or Eventual Consistency	Eventual Consistency	Eventual Consistency Immediate Consistency
Foreign keys Referential integrity	no	yes edges in graph	no
Transaction concepts Support to ensure data integrity after non-atomic manipulations of data	ACID	ACID	configurable
Concurrency Support for concurrent manipulation of data	yes	yes	yes
Durability Support for making data persistent	yes	yes	yes optionally
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	Access Control Lists (using HBase ACL) for RBAC, integration with Apache Ranger for RBAC & ABAC, multi-tenancy	Users, roles and permissions	authentification to access the cache via certificates or http basic authentication
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
	Apache Phoenix	HugeGraph	Oracle Coherence
DB-Engines blog posts	Cloudera's HBase PaaS offering now supports Complex Transactions 11 August 2021,  Krishna Maheshwari (sponsor)  show all