DB-EnginesExtremeDB for everyone with an RTOSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > ClickHouse vs. HyperSQL vs. OpenSearch vs. Oracle vs. TerarkDB

System Properties Comparison ClickHouse vs. HyperSQL vs. OpenSearch vs. Oracle vs. TerarkDB

Editorial information provided by DB-Engines
NameClickHouse  Xexclude from comparisonHyperSQL infoalso known as HSQLDB  Xexclude from comparisonOpenSearch  Xexclude from comparisonOracle  Xexclude from comparisonTerarkDB  Xexclude from comparison
DescriptionA high-performance, column-oriented SQL DBMS for online analytical processing (OLAP) that uses all available system resources to their full potential to process each analytical query as fast as possible. It is available as both an open-source software and a cloud offering.Multithreaded, transactional RDBMS written in Java infoalso known as HSQLDBA distributed, RESTful search and analytics engine forked from Elasticsearch and based on Apache LuceneWidely used RDBMSA key-value store forked from RocksDB with advanced compression algorithms. It can be used standalone or as a storage engine for MySQL and MongoDB
Primary database modelRelational DBMSRelational DBMSSearch engineRelational DBMSKey-value store
Secondary database modelsTime Series DBMSVector DBMSDocument store
Graph DBMS infowith Oracle Spatial and Graph
RDF store infowith Oracle Spatial and Graph
Spatial DBMS infowith Oracle Spatial and Graph
Vector DBMS infosince Oracle 23
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score15.55
Rank#38  Overall
#23  Relational DBMS
Score3.23
Rank#93  Overall
#48  Relational DBMS
Score16.03
Rank#37  Overall
#4  Search engines
Score1244.08
Rank#1  Overall
#1  Relational DBMS
Score0.08
Rank#367  Overall
#56  Key-value stores
Websiteclickhouse.comhsqldb.orggithub.com/­opensearch-project
opensearch.org
www.oracle.com/­databasegithub.com/­bytedance/­terarkdb
Technical documentationclickhouse.com/­docshsqldb.org/­web/­hsqlDocsFrame.htmlopensearch.org/­docs/­latestdocs.oracle.com/­en/­databasebytedance.larkoffice.com/­docs/­doccnZmYFqHBm06BbvYgjsHHcKc
DeveloperClickhouse Inc.Amazon Web ServicesOracleByteDance, originally Terark
Initial release20162001202119802016
Current releasev24.4.1.2088-stable, May 20242.7.2, June 20232.5.0, January 202323c, September 2023
License infoCommercial or Open SourceOpen Source infoApache 2.0Open Source infobased on BSD licenseOpen Source infoApache Version 2.0commercial inforestricted free version is availablecommercial inforestricted open source version 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.
  • Aiven for Clickhouse: Managed cloud data warehousing with high-speed analytics.
  • DoubleCloud: Fully managed ClickHouse alongside best-in-class managed open-source services to build analytics at scale.
  • ClickHouse Cloud: Get the performance you love from open source ClickHouse in a serverless offering that takes care of the details so you can spend more time getting insight out of the fastest database on earth.
  • Aiven for OpenSearch: Fully managed open source search and analytics suite. Out-of-the-box integrations get you up and running in a couple of clicks.
  • STACKIT OpenSearch offers OpenSearch in a managed version in enterprise grade, 100% GDPR-compliant, for a wide range of applications like analytics, website search, offering scalability and fast data access.
Implementation languageC++JavaJavaC and C++C++
Server operating systemsFreeBSD
Linux
macOS
All OS with a Java VM infoEmbedded (into Java applications) and Client-Server operating modesAll OS with a Java VMAIX
HP-UX
Linux
OS X
Solaris
Windows
z/OS
Data schemeyesyesschema-free infoFlexible type definitions. Once a type is defined, it is persistentyes infoSchemaless in JSON and XML columnsschema-free
Typing infopredefined data types such as float or dateyesyesyesyesno
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 indexesyesyesyes infoAll search fields are automatically indexedyesno
SQL infoSupport of SQLClose to ANSI SQL (SQL/JSON + extensions)yesSQL-like query languageyes infowith proprietary extensionsno
APIs and other access methodsgRPC
HTTP REST
JDBC
MySQL wire protocol
ODBC
PostgreSQL wire protocol
Proprietary protocol
HTTP API infoJDBC via HTTP
JDBC
ODBC
Java API
RESTful HTTP/JSON API
JDBC
ODBC
ODP.NET
Oracle Call Interface (OCI)
C++ API
Java API
Supported programming languagesC# info3rd party library
C++
Elixir info3rd party library
Go info3rd party library
Java info3rd party library
JavaScript (Node.js) info3rd party library
Kotlin info3rd party library
Nim info3rd party library
Perl info3rd party library
PHP info3rd party library
Python info3rd party library
R info3rd party library
Ruby info3rd party library
Rust
Scala info3rd party library
All languages supporting JDBC/ODBC
Java
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby infoElasticsearch client
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
C++
Java
Server-side scripts infoStored proceduresyesJava, SQLyesPL/SQL infoalso stored procedures in Java possibleno
Triggersnoyesyes infoby using the 'percolation' featureyesno
Partitioning methods infoMethods for storing different data on different nodeskey based and customnoneShardingSharding, horizontal partitioningnone
Replication methods infoMethods for redundantly storing data on multiple nodesAsynchronous and synchronous physical replication; geographically distributed replicas; support for object storages.noneyesMulti-source replication
Source-replica replication
none
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonono infocan be realized in PL/SQLno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyEventual Consistency infoSynchronous doc based replication. Get by ID may show delays up to 1 sec. Configurable write consistency: one, quorum, allImmediate Consistency
Foreign keys infoReferential integritynoyesnoyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACIDnoACID infoisolation level can be parameterizedno
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.yesyesyes infoVersion 12c introduced the new option 'Oracle Database In-Memory'yes
User concepts infoAccess controlAccess rights for users and roles. Column and row based policies. Quotas and resource limits. Pluggable authentication with LDAP and Kerberos. Password based, X.509 certificate, and SSH key authentication.fine grained access rights according to SQL-standardfine grained access rights according to SQL-standardno
More information provided by the system vendor
ClickHouseHyperSQL infoalso known as HSQLDBOpenSearchOracleTerarkDB
Specific characteristicsOpenSearch is a highly scalable and extensible open-source software suite for search,...
» more
Competitive advantagesDistributed as fully open source under Apache License, Version 2.0 (ALv2), OpenSearch...
» more
Typical application scenariosThe OpenSearch platform is used across a broad range of search , analytics, and observability...
» more
Licensing and pricing modelsThe OpenSearch Project offers open source software licensed under Apache License...
» 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
3rd partiesDoubleCloud: Fully managed ClickHouse alongside best-in-class managed open-source services to build analytics at scale.
» more

Aiven for Clickhouse: Managed cloud data warehousing with high-speed analytics.
» more
Aiven for OpenSearch: Fully managed open source search and analytics suite. Out-of-the-box integrations get you up and running in a couple of clicks.
» more
Navicat for Oracle improves the efficiency and productivity of Oracle developers and administrators with a streamlined working environment.
» more

Devart ODBC driver for Oracle accesses Oracle databases from ODBC-compliant reporting, analytics, BI, and ETL tools on both 32 and 64-bit Windows, macOS, and Linux.
» more

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

More resources
ClickHouseHyperSQL infoalso known as HSQLDBOpenSearchOracleTerarkDB
DB-Engines blog posts

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, events and webinars

Oracle Cloud World
Las Vegas, 9-12 September 2024

Recent citations in the news

Why Clickhouse Should Be Your Next Database
6 July 2023, The New Stack

ClickHouse Cloud & Amazon S3 Express One Zone: Making a blazing fast analytical database even faster | Amazon ...
28 November 2023, AWS Blog

Intel Xeon 6766E/6780E Sierra Forest vs. Ampere Altra Performance & Power Efficiency Review
5 June 2024, Phoronix

A 1000x Faster Database Solution: ClickHouse’s Aaron Katz
1 November 2023, GrowthCap

From Open Source to SaaS: the Journey of ClickHouse
16 January 2024, InfoQ.com

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

Optimize storage costs in Amazon OpenSearch Service using Zstandard compression | Amazon Web Services
11 June 2024, AWS Blog

Behind the Scenes: Upgrading OpenSearch efficiency with OCI flexible vertical scaling
13 February 2024, blogs.oracle.com

Amazon OpenSearch Service now supports OpenSearch version 2.13 - AWS
21 May 2024, AWS Blog

OCI Search with OpenSearch 2.11 delivers easy access to latest AI innovations
13 March 2024, blogs.oracle.com

Modernize your data observability with Amazon OpenSearch Service zero-ETL integration with Amazon S3 | Amazon ...
5 June 2024, AWS Blog

provided by Google News

Oracle And Google Partner To Deliver Multicloud Offering To Enterprises
13 June 2024, Forbes

Oracle to colocate database services and network interconnect in Google data centers
12 June 2024, DatacenterDynamics

Blog Theme - Details
14 June 2024, Oracle

Oracle and Google Cloud Announce a Groundbreaking Multicloud Partnership
11 June 2024, PR Newswire

Panasonic Information Systems Selects Oracle Cloud Infrastructure to Drive Modernization of Internal Systems Across ...
13 June 2024, PR Newswire

provided by Google News

A Chinese company is making the cloud 200x faster · TechNode
3 July 2017, TechNode

provided by Google News



Share this page

Featured Products

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

Milvus logo

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

Present your product here