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 > ClickHouse vs. Derby vs. GeoMesa vs. JSqlDb vs. XTDB

System Properties Comparison ClickHouse vs. Derby vs. GeoMesa vs. JSqlDb vs. XTDB

Editorial information provided by DB-Engines
NameClickHouse  Xexclude from comparisonDerby infooften called Apache Derby, originally IBM Cloudscape; contained in the Java SDK as JavaDB  Xexclude from comparisonGeoMesa  Xexclude from comparisonJSqlDb  Xexclude from comparisonXTDB infoformerly named Crux  Xexclude from comparison
JSqlDB seems to be discontinued. Therefore it is excluded from the DB-Engines ranking.
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.Full-featured RDBMS with a small footprint, either embedded into a Java application or used as a database server.GeoMesa is a distributed spatio-temporal DBMS based on various systems as storage layer.JavaScript Query Language Database, stores JavaScript objects and primitivesA general purpose database with bitemporal SQL and Datalog and graph queries
Primary database modelRelational DBMSRelational DBMSSpatial DBMSDocument store
Object oriented DBMS
Document store
Secondary database modelsTime Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score15.55
Rank#38  Overall
#23  Relational DBMS
Score4.60
Rank#70  Overall
#38  Relational DBMS
Score0.86
Rank#205  Overall
#4  Spatial DBMS
Score0.18
Rank#332  Overall
#46  Document stores
Websiteclickhouse.comdb.apache.org/­derbywww.geomesa.orgjsqldb.org (offline)github.com/­xtdb/­xtdb
www.xtdb.com
Technical documentationclickhouse.com/­docsdb.apache.org/­derby/­manuals/­index.htmlwww.geomesa.org/­documentation/­stable/­user/­index.htmlwww.xtdb.com/­docs
DeveloperClickhouse Inc.Apache Software FoundationCCRi and othersKonrad von BackstromJuxt Ltd.
Initial release20161997201420182019
Current releasev24.4.1.2088-stable, May 202410.17.1.0, November 20235.0.0, May 20240.8, December 20181.19, September 2021
License infoCommercial or Open SourceOpen Source infoApache 2.0Open Source infoApache version 2Open Source infoApache License 2.0Open SourceOpen Source infoMIT License
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.
  • 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 Clickhouse: Managed cloud data warehousing with high-speed analytics.
Implementation languageC++JavaScalaClojure
Server operating systemsFreeBSD
Linux
macOS
All OS with a Java VMLinux
macOS
Windows
All OS with a Java 8 (and higher) VM
Linux
Data schemeyesyesyesschema-freeschema-free
Typing infopredefined data types such as float or dateyesyesyesnoyes, extensible-data-notation format
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.noyesnonono
Secondary indexesyesyesyesnoyes
SQL infoSupport of SQLClose to ANSI SQL (SQL/JSON + extensions)yesnonolimited SQL, making use of Apache Calcite
APIs and other access methodsgRPC
HTTP REST
JDBC
MySQL wire protocol
ODBC
PostgreSQL wire protocol
Proprietary protocol
JDBCHTTP REST
JDBC
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
JavaJavaScriptClojure
Java
Server-side scripts infoStored proceduresyesJava Stored Proceduresnofunctions in JavaScriptno
Triggersnoyesnonono
Partitioning methods infoMethods for storing different data on different nodeskey based and customnonedepending on storage layernonenone
Replication methods infoMethods for redundantly storing data on multiple nodesAsynchronous and synchronous physical replication; geographically distributed replicas; support for object storages.Source-replica replicationdepending on storage layernoneyes, each node contains all data
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoyesnono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistencydepending on storage layer
Foreign keys infoReferential integritynoyesnonono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACIDnoACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyesyes infousing RocksDByes, flexibel persistency by using storage technologies like Apache Kafka, RocksDB or LMDB
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesdepending on storage layer
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-standardyes infodepending on the DBMS used for storage

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 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

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

More resources
ClickHouseDerby infooften called Apache Derby, originally IBM Cloudscape; contained in the Java SDK as JavaDBGeoMesaJSqlDbXTDB infoformerly named Crux
DB-Engines blog posts

Spatial database management systems
6 April 2021, Matthias Gelbmann

show all

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

JDBC tutorial: Easy installation and setup with Apache Derby
20 December 2019, TheServerSide.com

Installing Apache Hive 3.1.2 on Windows 10 | by Hadi Fadlallah
3 May 2020, Towards Data Science

The Arrival of Java 20
21 March 2023, blogs.oracle.com

The Ultimate Open Source Database List Profiling 16 Software Tools
30 May 2019, Solutions Review

The Apache® Software Foundation Announces 18 Years of Open Source Leadership
28 March 2017, GlobeNewswire

provided by Google News



Share this page

Featured Products

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.

Milvus logo

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

Present your product here