DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Apache Phoenix vs. Oracle Coherence vs. Realm vs. STSdb

System Properties Comparison Apache Phoenix vs. Oracle Coherence vs. Realm vs. STSdb

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameApache Phoenix  Xexclude from comparisonOracle Coherence  Xexclude from comparisonRealm  Xexclude from comparisonSTSdb  Xexclude from comparison
DescriptionA scale-out RDBMS with evolutionary schema built on Apache HBaseOracles in-memory data grid solutionA DBMS built for use on mobile devices that’s a fast, easy to use alternative to SQLite and Core DataKey-Value Store with special method for indexing infooptimized for high performance using a special indexing method
Primary database modelRelational DBMSKey-value storeDocument storeKey-value store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score3.20
Rank#96  Overall
#50  Relational DBMS
Score2.64
Rank#108  Overall
#20  Key-value stores
Score9.80
Rank#48  Overall
#7  Document stores
Score0.08
Rank#306  Overall
#45  Key-value stores
Websitephoenix.apache.orgwww.oracle.com/­middleware/­technologies/­coherence.htmlrealm.iogithub.com/­STSSoft/­STSdb4
Technical documentationphoenix.apache.orgdocs.oracle.com/­en/­middleware/­standalone/­coherencerealm.io/­docs
DeveloperApache Software FoundationOracleRealm, acquired by MongoDB in May 2019STS Soft SC
Initial release2014200720142011
Current release5.0-HBase2, July 2018 and 4.15-HBase1, December 201912c, September 20164.0.8, September 2015
License infoCommercial or Open SourceOpen Source infoApache Version 2.0commercialOpen SourceOpen Source infoGPLv2, commercial license available
Cloud-based only infoOnly available as a cloud servicenononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaJavaC#
Server operating systemsLinux
Unix
Windows
All OS with a Java VMAndroid
Backend: server-less
iOS
Windows
Windows
Data schemeyes infolate-bound, schema-on-read capabilitiesschema-freeyesyes
Typing infopredefined data types such as float or dateyesyesyesyes infoprimitive types and user defined types (classes)
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.nonono
Secondary indexesyesnoyesno
SQL infoSupport of SQLyesnonono
APIs and other access methodsJDBCJCache
JPA
RESTful HTTP API
.NET Client API
Supported programming languagesC
C#
C++
Go
Groovy
Java
PHP
Python
Scala
.Net
C++
Java
.Net
Java infowith Android only
Objective-C
React Native
Swift
C#
Java
Server-side scripts infoStored proceduresuser defined functionsnono inforuns within the applications so server-side scripts are unnecessaryno
Triggersnoyes infoLive Eventsyes infoChange Listenersno
Partitioning methods infoMethods for storing different data on different nodesShardingShardingnonenone
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication
Source-replica replication
yes, with selectable consistency levelnonenone
MapReduce infoOffers an API for user-defined Map/Reduce methodsHadoop integrationnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency or Eventual ConsistencyEventual Consistency
Immediate Consistency
Immediate Consistency
Foreign keys infoReferential integritynononono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDconfigurableACIDno
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyesyes infooptionallyyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesyes infoIn-Memory realm
User concepts infoAccess controlAccess Control Lists (using HBase ACL) for RBAC, integration with Apache Ranger for RBAC & ABAC, multi-tenancyauthentification to access the cache via certificates or http basic authenticationyesno
More information provided by the system vendor
Apache PhoenixOracle CoherenceRealmSTSdb
Specific characteristicsNow a part of MongoDB Data Platform , Realm Database is the fast, easy to use, and...
» more
Competitive advantagesRealm ensures offline-first functionality, meaning apps run smoothly and deliver...
» more
Typical application scenariosMobile Consumer Apps First-Line Worker Apps
» more
Key customersCathay Pacific Royal Carribbean Cruise Lines Open Source Database powers apps built...
» more
Market metricsUsed by 100,000+ developers 2 bn installs Currently used in 40k+ applications in...
» more
Licensing and pricing modelsRealm database is licensed under the Apache License v2.0.
» more

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 PhoenixOracle CoherenceRealmSTSdb
DB-Engines blog posts

Cloudera's HBase PaaS offering now supports Complex Transactions
11 August 2021,  Krishna Maheshwari (sponsor) 

show all

MySQL, PostgreSQL and Redis are the winners of the March ranking
2 March 2016, Paul Andlinger

show all

Recent citations in the news

Apache Phoenix Now HBase 2.0 Compatible
20 July 2018, iProgrammer

Developing Python Applications Against Apache Phoenix (HBase)
30 September 2016, DZone News

Apache Calcite, FreeMarker, Gora, Phoenix, and Solr updated
27 March 2017, SDTimes.com

HPE gobbles up Ampool to add SQL grunt to Ezmeral
9 July 2021, The Register

The Apache Software Foundation Announces the 10th Anniversary of Apache® HBase
13 May 2020, GlobeNewswire

provided by Google News

Coherence Community Edition Now Available
1 July 2020, Database Trends and Applications

Oracle Unveils Unified Container Deployment and Management Platform
3 August 2021, Container Journal

Oracle launches 5G Converged Charging System
12 February 2021, Capacity Media

Micro Focus Announces Visual COBOL 7.0 and Enterprise Suite 7.0
20 September 2021, Database Trends and Applications

SL Corporation Launches RTView Oracle Coherence Monitor 6.0 with Advanced Analytics and Alerting; Integration with RTView Enterprise Monitor
9 May 2013, Business Wire

provided by Google News

Realm Makes PostgreSQL Real-Time with New Connector
21 March 2017, Database Trends and Applications

MongoDB Extends Cloud Lineup With New Database Release, Search And Mobile Tools
12 June 2020, CRN: Technology news for channel partners and solution providers

MongoDB Cloud brings developers and edge together
10 June 2020, TechRadar

MongoDB Cloud Gives Developers An Escape From Data Silos With First-Ever Unified Cloud-To-Mobile Experience
9 June 2020, PRNewswire

provided by Google News

Job opportunities

OpDB & HBase Field Specialist
Cloudera, New York, NY

Solutions Architect
Cloudera, New York, NY

Senior Developer
Epsilon, Irving, TX

Manager Data Analytics & Insights
Generac Power Systems, Waukesha, WI

Senior Solutions Consultant
Cloudera, Illinois

Sr. Oracle Fusion Developer (Remote / Work From Home)
Travel + Leisure Co., Orlando, FL

Java Developer
PruTech Solutions, Charlotte, NC

VP- Senior Java Developer
Barclays, Whippany, NJ

JPC - 443 - Server Side Java Developer
Promantis Inc, Charlotte, NC

Atlas Trade Senior Developer
Barclays, New York, NY

Software Engineer - iOS
Lyft, Seattle, WA

iOS Architecture Engineer
Lyft, San Francisco, CA

jobs by Indeed



Share this page

Featured Products

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 80GB free.

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

Couchbase logo

The modern database for enterprise applications. Build fast. Scale Big. Save more.
Get started today.

Present your product here