DB-EnginesextremeDB - solve IoT connectivity disruptionsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

DBMS > Apache Druid vs. HyperSQL vs. OpenEdge vs. Oracle NoSQL vs. RavenDB

System Properties Comparison Apache Druid vs. HyperSQL vs. OpenEdge vs. Oracle NoSQL vs. RavenDB

Editorial information provided by DB-Engines
NameApache Druid  Xexclude from comparisonHyperSQL infoalso known as HSQLDB  Xexclude from comparisonOpenEdge  Xexclude from comparisonOracle NoSQL  Xexclude from comparisonRavenDB  Xexclude from comparison
DescriptionOpen-source analytics data store designed for sub-second OLAP queries on high dimensionality and high cardinality dataMultithreaded, transactional RDBMS written in Java infoalso known as HSQLDBApplication development environment with integrated database management systemA multi-model, scalable, distributed NoSQL database, designed to provide highly reliable, flexible, and available data management across a configurable set of storage nodesOpen Source Operational and Transactional Enterprise NoSQL Document Database
Primary database modelRelational DBMS
Time Series DBMS
Relational DBMSRelational DBMSDocument store
Key-value store
Relational DBMS
Document store
Secondary database modelsGraph DBMS
Spatial DBMS
Time Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score2.85
Rank#96  Overall
#50  Relational DBMS
#6  Time Series DBMS
Score3.14
Rank#85  Overall
#46  Relational DBMS
Score3.69
Rank#78  Overall
#42  Relational DBMS
Score3.07
Rank#86  Overall
#15  Document stores
#11  Key-value stores
#47  Relational DBMS
Score2.68
Rank#102  Overall
#19  Document stores
Websitedruid.apache.orghsqldb.orgwww.progress.com/­openedgewww.oracle.com/­database/­nosql/­technologies/­nosqlravendb.net
Technical documentationdruid.apache.org/­docs/­latest/­designhsqldb.org/­web/­hsqlDocsFrame.htmldocumentation.progress.com/­output/­ua/­OpenEdge_latestdocs.oracle.com/­en/­database/­other-databases/­nosql-database/­index.htmlravendb.net/­docs
DeveloperApache Software Foundation and contributorsProgress Software CorporationOracleHibernating Rhinos
Initial release20122001198420112010
Current release30.0.0, June 20242.7.2, June 2023OpenEdge 12.2, March 202024.1, May 20245.4, July 2022
License infoCommercial or Open SourceOpen Source infoApache license v2Open Source infobased on BSD licensecommercialOpen Source infoProprietary for Enterprise Edition (Oracle Database EE license has Oracle NoSQL database EE covered: details)Open Source infoAGPL version 3, commercial license available
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 languageJavaJavaJavaC#
Server operating systemsLinux
OS X
Unix
All OS with a Java VM infoEmbedded (into Java applications) and Client-Server operating modesAIX
HP-UX
Linux
Solaris
Windows
Linux
Solaris SPARC/x86
Linux
macOS
Raspberry Pi
Windows
Data schemeyes infoschema-less columns are supportedyesyesSupport Fixed schema and Schema-less deployment with the ability to interoperate between them.schema-free
Typing infopredefined data types such as float or dateyesyesyesoptionalno
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.nonoyesno
Secondary indexesyesyesyesyesyes
SQL infoSupport of SQLSQL for queryingyesyes infoclose to SQL 92SQL-like DML and DDL statementsSQL-like query language (RQL)
APIs and other access methodsJDBC
RESTful HTTP/JSON API
HTTP API infoJDBC via HTTP
JDBC
ODBC
JDBC
ODBC
RESTful HTTP API.NET Client API
F# Client API
Go Client API
Java Client API
NodeJS Client API
PHP Client API
Python Client API
RESTful HTTP API
Supported programming languagesClojure
JavaScript
PHP
Python
R
Ruby
Scala
All languages supporting JDBC/ODBC
Java
Progress proprietary ABL (Advanced Business Language)C
C#
Go
Java
JavaScript (Node.js)
Python
.Net
C#
F#
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
Server-side scripts infoStored proceduresnoJava, SQLyesnoyes
Triggersnoyesyesnoyes
Partitioning methods infoMethods for storing different data on different nodesSharding infomanual/auto, time-basednonehorizontal partitioning infosince Version 11.4ShardingSharding
Replication methods infoMethods for redundantly storing data on multiple nodesyes, via HDFS, S3 or other storage enginesnoneSource-replica replicationElectable source-replica replication per shard. Support distributed global deployment with Multi-region table featureMulti-source replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononowith Hadoop integrationyes
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyEventual Consistency
Immediate Consistency infodepending on configuration
Default ACID transactions on the local node (eventually consistent across the cluster). Atomic operations with cluster-wide ACID transactions. Eventual consistency for indexes and full-text search indexes.
Foreign keys infoReferential integritynoyesyesnono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACIDACIDconfigurable infoACID within a storage node (=shard)ACID, Cluster-wide transaction available
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
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.noyesnoyes infooff heap cache
User concepts infoAccess controlRBAC using LDAP or Druid internals for users and groups for read/write by datasource and systemfine grained access rights according to SQL-standardUsers and groupsAccess rights for users and rolesAuthorization levels configured per client per database

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 DruidHyperSQL infoalso known as HSQLDBOpenEdgeOracle NoSQLRavenDB
Recent citations in the news

ApacheĀ® Druid Wins Best Big Data Product in the 2023 BigDATAwire Readersā€™ Choice Awards
26 January 2024, businesswire.com

Imply Announces the Availability of Imply Polaris, a Database-as-a-Service Built from Apache Druid, on Microsoft Azure
26 June 2024, Yahoo Finance

'Lucifer' Botnet Turns Up the Heat on Apache Hadoop Servers
21 February 2024, Dark Reading

Apache Druid Takes Its Place In The Pantheon Of Databases
16 June 2022, The Next Platform

How to connect DataGrip to Apache Druid
18 October 2021, Towards Data Science

provided by Google News

HyperSQL DataBase flaw leaves library vulnerable to RCE
24 October 2022, The Daily Swig

Introduction to JDBC with HSQLDB tutorial
14 November 2022, TheServerSide.com

provided by Google News

What's New in OpenEdge 12.8
15 April 2024, release.nl

4 sources of latency and how to avoid them
1 November 2017, InfoWorld

provided by Google News

Cloud database comparison: AWS, Microsoft, Google and Oracle
24 July 2024, TechTarget

Top 8 Best NoSQL Databases in 2024
9 September 2024, AIM

Explore Oracle Database Solutions for Maximum Efficiency
4 September 2018, oracle.com

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

Oracle Releases Big Data Appliance with Cloudera Distribution for Hadoop
10 January 2012, SiliconANGLE News

provided by Google News

RavenDB Launches Version 6.0 Lightning Fast Queries, Data Integrations, Corax Indexing Engine, and Sharding
3 October 2023, PR Newswire

Install the NoSQL RavenDB Data System
14 May 2021, The New Stack

RavenDB Welcomes David Baruc as Chief Revenue Officer: Seasoned Tech Leader to Drive Global Sales and Accelerate Growth
13 June 2023, PR Newswire

Get To Know: Oren Eini, CEO, RavenDB
22 October 2019, Intelligent CIO

RavenDB Adds Graph Queries
15 May 2019, Datanami

provided by Google News



Share this page

Featured Products

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

SingleStore logo

The data platform to build your intelligent applications.
Try it 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

Neo4j logo

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

Present your product here