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 > Hive vs. Ingres vs. Oracle NoSQL vs. Realm vs. VelocityDB

System Properties Comparison Hive vs. Ingres vs. Oracle NoSQL vs. Realm vs. VelocityDB

Editorial information provided by DB-Engines
NameHive  Xexclude from comparisonIngres  Xexclude from comparisonOracle NoSQL  Xexclude from comparisonRealm  Xexclude from comparisonVelocityDB  Xexclude from comparison
Descriptiondata warehouse software for querying and managing large distributed datasets, built on HadoopWell established RDBMSA multi-model, scalable, distributed NoSQL database, designed to provide highly reliable, flexible, and available data management across a configurable set of storage nodesA DBMS built for use on mobile devices that’s a fast, easy to use alternative to SQLite and Core DataA .NET Object Database that can be embedded/distributed and extended to a graph data model (VelocityGraph)
Primary database modelRelational DBMSRelational DBMSDocument store
Key-value store
Relational DBMS
Document storeGraph DBMS
Object oriented DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score61.17
Rank#18  Overall
#12  Relational DBMS
Score4.11
Rank#81  Overall
#44  Relational DBMS
Score2.95
Rank#100  Overall
#17  Document stores
#17  Key-value stores
#50  Relational DBMS
Score7.60
Rank#52  Overall
#9  Document stores
Score0.05
Rank#358  Overall
#36  Graph DBMS
#16  Object oriented DBMS
Websitehive.apache.orgwww.actian.com/­databases/­ingreswww.oracle.com/­database/­nosql/­technologies/­nosqlrealm.iovelocitydb.com
Technical documentationcwiki.apache.org/­confluence/­display/­Hive/­Homedocs.actian.com/­ingresdocs.oracle.com/­en/­database/­other-databases/­nosql-database/­index.htmlrealm.io/­docsvelocitydb.com/­UserGuide
DeveloperApache Software Foundation infoinitially developed by FacebookActian CorporationOracleRealm, acquired by MongoDB in May 2019VelocityDB Inc
Initial release20121974 infooriginally developed at University Berkely in early 1970s201120142011
Current release3.1.3, April 202211.2, May 202223.3, December 20237.x
License infoCommercial or Open SourceOpen Source infoApache Version 2commercialOpen Source infoProprietary for Enterprise Edition (Oracle Database EE license has Oracle NoSQL database EE covered: details)Open Sourcecommercial
Cloud-based only infoOnly available as a cloud servicenonononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaCJavaC#
Server operating systemsAll OS with a Java VMAIX
HP Open VMS
HP-UX
Linux
Solaris
Windows
Linux
Solaris SPARC/x86
Android
Backend: server-less
iOS
Windows
Any that supports .NET
Data schemeyesyesSupport Fixed schema and Schema-less deployment with the ability to interoperate between them.yesyes
Typing infopredefined data types such as float or dateyesyesoptionalyesyes
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.no infobut tools for importing/exporting data from/to XML-files availablenonono
Secondary indexesyesyesyesyesyes
SQL infoSupport of SQLSQL-like DML and DDL statementsyesSQL-like DML and DDL statementsnono
APIs and other access methodsJDBC
ODBC
Thrift
.NET Client API
JDBC
ODBC
proprietary protocol (OpenAPI)
RESTful HTTP API.Net
Supported programming languagesC++
Java
PHP
Python
C
C#
Go
Java
JavaScript (Node.js)
Python
.Net
Java infowith Android only
Objective-C
React Native
Swift
.Net
Server-side scripts infoStored proceduresyes infouser defined functions and integration of map-reduceyesnono inforuns within the applications so server-side scripts are unnecessaryno
Triggersnoyesnoyes infoChange ListenersCallbacks are triggered when data changes
Partitioning methods infoMethods for storing different data on different nodesShardinghorizontal partitioning infoIngres Star to access multiple databases simultaneouslyShardingnoneSharding
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factorIngres ReplicatorElectable source-replica replication per shard. Support distributed global deployment with Multi-region table featurenone
MapReduce infoOffers an API for user-defined Map/Reduce methodsyes infoquery execution via MapReducenowith Hadoop integrationnono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual ConsistencyImmediate ConsistencyEventual Consistency
Immediate Consistency infodepending on configuration
Immediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyesnonono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACIDconfigurable infoACID within a storage node (=shard)ACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyes infoMVCCyesyes
Durability infoSupport for making data persistentyesyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyes infooff heap cacheyes infoIn-Memory realmyes
User concepts infoAccess controlAccess rights for users, groups and rolesfine grained access rights according to SQL-standardAccess rights for users and rolesyesBased on Windows 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
HiveIngresOracle NoSQLRealmVelocityDB
DB-Engines blog posts

Why is Hadoop not listed in the DB-Engines Ranking?
13 May 2013, Paul Andlinger

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 Software Foundation Announces Apache® Hive 4.0
30 April 2024, GlobeNewswire

ASF Unveils the Next Evolution of Big Data Processing With the Launch of Hive 4.0
2 May 2024, Datanami

Run Apache Hive workloads using Spark SQL with Amazon EMR on EKS | Amazon Web Services
18 October 2023, AWS Blog

18 Top Big Data Tools and Technologies to Know About in 2024
24 January 2024, TechTarget

DataCentral: Uber's Observability and Chargeback Platform
1 February 2024, Uber

provided by Google News

Postgres pioneer Michael Stonebraker promises to upend the database once more
26 December 2023, The Register

New startup from Postgres creator puts the database at heart of software stack
12 March 2024, TechCrunch

Actian Launches Ingres as a Fully-Managed Cloud Service
24 September 2021, Integration Developers

PostgreSQL now top developer choice ahead of MySQL, according to massive new survey • DEVCLASS
13 June 2023, DevClass

Dr. Michael Stonebraker: A Short History of Database Systems
1 February 2019, The New Stack

provided by Google News

Oracle NoSQL database comes to the cloud
2 April 2020, TechTarget

Database Technologies
4 September 2018, oracle.com

Oracle Defends Relational DBs Against NoSQL Competitors
25 November 2015, eWeek

Oracle Adds New AI-Enabling Features To MySQL HeatWave
23 March 2023, Forbes

NoSQL Rebels Aim Missile at Larry Ellison's Yacht
20 July 2012, WIRED

provided by Google News

MongoDB aims to unify developer experience with launch of MongoDB Cloud
9 June 2020, diginomica

Is Swift the Future of Server-side Development?
12 September 2017, Solutions Review

Java Synthetic Methods — What are these? | by Vaibhav Singh
27 February 2021, DataDrivenInvestor

Kotlin Programming Language Will Surpass Java On Android Next Year
15 October 2017, Fossbytes

Pyramid Analytics Appoints Spencer Johnson as Vice President of North America Sales
31 March 2020, businesswire.com

provided by Google News



Share this page

Featured Products

AllegroGraph logo

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

Neo4j logo

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

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB for free.

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

Present your product here