DB-EnginesExtremeDB: the mission critical dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Datomic vs. Firebase Realtime Database vs. Hypertable vs. Oracle

System Properties Comparison Datomic vs. Firebase Realtime Database vs. Hypertable vs. Oracle

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameDatomic  Xexclude from comparisonFirebase Realtime Database  Xexclude from comparisonHypertable  Xexclude from comparisonOracle  Xexclude from comparison
Hypertable has stopped its further development with March 2016 and is removed from the DB-Engines ranking.
DescriptionDatomic builds on immutable values, supports point-in-time queries and uses 3rd party systems for durabilityCloud-hosted realtime document store. iOS, Android, and JavaScript clients share one Realtime Database instance and automatically receive updates with the newest data.An open source BigTable implementation based on distributed file systems such as HadoopWidely used RDBMS
Primary database modelRelational DBMSDocument storeWide column storeRelational DBMS
Secondary database modelsDocument store
Graph DBMS infowith Oracle Spatial and Graph
RDF store infowith Oracle Spatial and Graph
Spatial DBMS infowith Oracle Spatial and Graph
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.92
Rank#129  Overall
#63  Relational DBMS
Score19.08
Rank#38  Overall
#6  Document stores
Score1238.25
Rank#1  Overall
#1  Relational DBMS
Websitewww.datomic.comfirebase.google.com/­products/­realtime-databasewww.oracle.com/­database
Technical documentationdocs.datomic.comfirebase.google.com/­docs/­databasedocs.oracle.com/­en/­database
DeveloperCognitectGoogle infoacquired by Google 2014Hypertable Inc.Oracle
Initial release2012201220091980
Current release1.0.6362, January 20220.9.8.11, March 201619c, February 2019
License infoCommercial or Open Sourcecommercial infolimited edition freecommercialOpen Source infoGNU version 3. Commercial license availablecommercial inforestricted free version is available
Cloud-based only infoOnly available as a cloud servicenoyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJava, ClojureC++C and C++
Server operating systemsAll OS with a Java VMhostedLinux
OS X
Windows infoan inofficial Windows port is available
AIX
HP-UX
Linux
OS X
Solaris
Windows
z/OS
Data schemeyesschema-freeschema-freeyes infoSchemaless in JSON and XML columns
Typing infopredefined data types such as float or dateyesyesnoyes
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.nonoyes
Secondary indexesyesyesrestricted infoonly exact value or prefix value scansyes
SQL infoSupport of SQLnononoyes infowith proprietary extensions
APIs and other access methodsRESTful HTTP APIAndroid
iOS
JavaScript API
RESTful HTTP API
C++ API
Thrift
JDBC
ODBC
ODP.NET
Oracle Call Interface (OCI)
Supported programming languagesClojure
Java
Java
JavaScript
Objective-C
C++
Java
Perl
PHP
Python
Ruby
C
C#
C++
Clojure
Cobol
Delphi
Eiffel
Erlang
Fortran
Groovy
Haskell
Java
JavaScript
Lisp
Objective C
OCaml
Perl
PHP
Python
R
Ruby
Scala
Tcl
Visual Basic
Server-side scripts infoStored proceduresyes infoTransaction Functionslimited functionality with using 'rules'noPL/SQL infoalso stored procedures in Java possible
TriggersBy using transaction functionsCallbacks are triggered when data changesnoyes
Partitioning methods infoMethods for storing different data on different nodesnone infoBut extensive use of caching in the application peersShardingSharding, horizontal partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesnone infoBut extensive use of caching in the application peersselectable replication factor on file system levelMulti-source replication
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoyesno infocan be realized in PL/SQL
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual Consistency infoif the client is offline
Immediate Consistency infoif the client is online
Immediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynononoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDyesnoACID infoisolation level can be parameterized
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyes infousing external storage systems (e.g. Cassandra, DynamoDB, PostgreSQL, Couchbase and others)yesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yes inforecommended only for testing and developmentyes infoVersion 12c introduced the new option 'Oracle Database In-Memory'
User concepts infoAccess controlnoyes, based on authentication and database rulesnofine grained access rights according to SQL-standard

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
3rd partiesNavicat for Oracle improves the efficiency and productivity of Oracle developers and administrators with a streamlined working environment.
» more

SQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
» more

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
DatomicFirebase Realtime DatabaseHypertableOracle
DB-Engines blog posts

Cloud-based DBMS's popularity grows at high rates
12 December 2019, Paul Andlinger

show all

MySQL is the DBMS of the Year 2019
3 January 2020, Matthias Gelbmann, Paul Andlinger

The struggle for the hegemony in Oracle's database empire
2 May 2017, Paul Andlinger

Architecting eCommerce Platforms for Zero Downtime on Black Friday and Beyond
25 November 2016, Tony Branson (guest author)

show all

Conferences and events

Oracle Cloud World
Las Vegas, 17-20 October 2022

Recent citations in the news

The Architecture of Datomic
2 November 2012, InfoQ.com

Rich Hickey on Datomic: Datalog, Databases, Persistent Data Structures
4 April 2012, InfoQ.com

Brazil’s Nubank Acquires US Software Firm Cognitect
30 July 2020, Nearshore Americas

Lucas Cavalcanti on Using Clojure, Microservices, Hexagonal Architecture and Public Cloud at Nubank
16 August 2021, InfoQ.com

Architecting Software for Leverage
13 November 2021, InfoQ.com

provided by Google News

Android apps leak hard-coded secrets
1 September 2022, CyberNews.com

Misconfigured Firebase Databases Exposing Data in Mobile Apps
17 March 2022, Threatpost

Creating a Todo App with NextJs & Firebase
25 August 2022, hackernoon.com

How to Use Complex Firebase Queries in Angular - MUO
9 August 2022, MakeUseOf

Introduction to Firebase
9 March 2020, Database Journal

provided by Google News

Non-relational SQL Market Size, share 2022 Global Industry Trends, Growth Drivers, Demands, Business Opportunities and Demand Forecast to 2028 | 101 Report Pages
7 September 2022, Digital Journal

NoSQL Market Share, Size, Industry Trends, Key Players, Growth and Opportunity 2022-2027
15 September 2022, EIN News

TimescaleDB goes distributed; implements ‘Chunking’ over ‘Sharding’ for scaling-out
22 August 2019, Packt Hub

NoSQL Databases | When to Use NoSQL vs SQL
19 January 2022, Server Watch

provided by Google News

Oracle - Oracle Announces Fiscal 2023 First Quarter Financial Results - Oracle
12 September 2022, Investor Relations

How to Migrate an Oracle Database to MySQL Using AWS Database Migration Service
7 September 2022, InfoQ.com

Inside Oracle’s partnership with AMD to boost MySQL HeatWave performance
22 September 2022, SiliconANGLE News

Why Oracle and Google Will Do the Multi-Cloud Boogaloo
20 September 2022, Acceleration Economy

Oracle brings MySQL Heatwave cloud database service to AWS
13 September 2022, TechTarget

provided by Google News

Job opportunities

Clojure and React Software Developer
Medical Database, Inc, Irvine, CA

Senior Software Engineer (Clojure Developer)
symplr, Remote

Sr Database Administrator (6199)
Altera Digital Health, New Hyde Park, NY

Database Engineer
Dr Alok Trivedi, Crystal Lake, IL

Data Analyst
Cognizant, New York, NY

Website Marketing Analyst (Tableau)
Virtuoso, Ltd., Remote

Software Engineer -Android Developer
Lowe's, Charlotte, NC

Oracle Database Administrator
California Public Employees' Retirement System (CalPERS), Sacramento, CA

Database Administrator
SAIC, El Paso, TX

Oracle Database Administrator
CVS Health, Texas

Data Analyst (Remote)
Home Depot / THD, Atlanta, GA

Database Management Specialist - Oracle 19c
ManTech International Corporation, Herndon, VA

jobs by Indeed



Share this page

Featured Products

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

Redis logo

The world’s most loved real‑time data platform.
Try free

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

The definitive guide for Cassandra

Imagine What You Could Do if Scalability Wasn‘t a Problem!
Download the Cassandra e-book for free!

Neo4j logo

Neo4j NODES 2022
Free online conference for developers and data scientists.
November 16/17 2022.
Register now for free!

Present your product here