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

DBMS > Atos Standard Common Repository vs. ClickHouse vs. HEAVY.AI vs. QuestDB vs. Tkrzw

System Properties Comparison Atos Standard Common Repository vs. ClickHouse vs. HEAVY.AI vs. QuestDB vs. Tkrzw

Editorial information provided by DB-Engines
NameAtos Standard Common Repository  Xexclude from comparisonClickHouse  Xexclude from comparisonHEAVY.AI infoFormerly named 'OmniSci', rebranded to 'HEAVY.AI' in March 2022  Xexclude from comparisonQuestDB  Xexclude from comparisonTkrzw infoSuccessor of Tokyo Cabinet and Kyoto Cabinet  Xexclude from comparison
This system has been discontinued and will be removed from the DB-Engines ranking.
DescriptionHighly scalable database system, designed for managing session and subscriber data in modern mobile communication networksA 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.A high performance, column-oriented RDBMS, specifically developed to harness the massive parallelism of modern CPU and GPU hardwareA high performance open source SQL database for time series dataA concept of libraries, allowing an application program to store and query key-value pairs in a file. Successor of Tokyo Cabinet and Kyoto Cabinet
Primary database modelDocument store
Key-value store
Relational DBMSRelational DBMSTime Series DBMSKey-value store
Secondary database modelsTime Series DBMSSpatial DBMSRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score15.88
Rank#37  Overall
#22  Relational DBMS
Score1.41
Rank#153  Overall
#71  Relational DBMS
Score2.81
Rank#98  Overall
#7  Time Series DBMS
Score0.00
Rank#385  Overall
#61  Key-value stores
Websiteatos.net/en/convergence-creators/portfolio/standard-common-repositoryclickhouse.comgithub.com/­heavyai/­heavydb
www.heavy.ai
questdb.iodbmx.net/­tkrzw
Technical documentationclickhouse.com/­docsdocs.heavy.aiquestdb.io/­docs
DeveloperAtos Convergence CreatorsClickhouse Inc.HEAVY.AI, Inc.QuestDB Technology IncMikio Hirabayashi
Initial release20162016201620142020
Current release1703v24.6.2.17-stable, July 20245.10, January 20220.9.3, August 2020
License infoCommercial or Open SourcecommercialOpen Source infoApache 2.0Open Source infoApache Version 2; enterprise edition availableOpen Source infoApache 2.0Open Source infoApache Version 2.0
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.
  • 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.
  • DoubleCloud: Fully managed ClickHouse alongside best-in-class managed open-source services to build analytics at scale.
Implementation languageJavaC++C++ and CUDAJava (Zero-GC), C++, RustC++
Server operating systemsLinuxFreeBSD
Linux
macOS
LinuxLinux
macOS
Windows
Linux
macOS
Data schemeSchema and schema-less with LDAP viewsyesyesyes infoschema-free via InfluxDB Line Protocolschema-free
Typing infopredefined data types such as float or dateoptionalyesyesyesno
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.yesnononono
Secondary indexesyesyesnono
SQL infoSupport of SQLnoClose to ANSI SQL (SQL/JSON + extensions)yesSQL with time-series extensionsno
APIs and other access methodsLDAPgRPC
HTTP REST
JDBC
MySQL wire protocol
ODBC
PostgreSQL wire protocol
Proprietary protocol
JDBC
ODBC
Thrift
Vega
HTTP REST
InfluxDB Line Protocol (TCP/UDP)
JDBC
PostgreSQL wire protocol
Supported programming languagesAll languages with LDAP bindingsC# 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/Thrift
Python
C infoPostgreSQL driver
C++
Go
Java
JavaScript (Node.js)
Python
Rust infoover HTTP
C++
Java
Python
Ruby
Server-side scripts infoStored proceduresnoyesnonono
Triggersyesnononono
Partitioning methods infoMethods for storing different data on different nodesSharding infocell divisionkey based and customSharding infoRound robinhorizontal partitioning (by timestamps)none
Replication methods infoMethods for redundantly storing data on multiple nodesyesAsynchronous and synchronous physical replication; geographically distributed replicas; support for object storages.Multi-source replicationSource-replica replication with eventual consistencynone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency or Eventual Consistency depending on configurationImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynonononono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataAtomic execution of specific operationsnonoACID for single-table writes
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.yesyesyesyes infothrough memory mapped filesyes infousing specific database classes
User concepts infoAccess controlLDAP bind authenticationAccess 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-standardno
More information provided by the system vendor
Atos Standard Common RepositoryClickHouseHEAVY.AI infoFormerly named 'OmniSci', rebranded to 'HEAVY.AI' in March 2022QuestDBTkrzw infoSuccessor of Tokyo Cabinet and Kyoto Cabinet
News

Combine Java and Rust Code Coverage in a Polyglot Project
10 September 2024

Weather data visualization and forecasting with QuestDB, Kafka and Grafana
4 September 2024

Building a new vector based storage model
22 August 2024

Calibrating VWAP executions with QuestDB and Grafana
16 August 2024

Write Time: a call for community writers
13 August 2024

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

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

More resources
Atos Standard Common RepositoryClickHouseHEAVY.AI infoFormerly named 'OmniSci', rebranded to 'HEAVY.AI' in March 2022QuestDBTkrzw infoSuccessor of Tokyo Cabinet and Kyoto Cabinet
Recent citations in the news

A Beginner’s Guide to ClickHouse Database
13 September 2024, KDnuggets

Real-time database startup ClickHouse acquires PeerDB to expand its Postgres support
30 July 2024, TechCrunch

Azur Games migrates all game analytics data to ClickHouse Cloud on AWS
16 July 2024, AWS Blog

Database startup ClickHouse Announces PeerDB Acquistion
31 July 2024, Tech Times

ClickHouse Acquires PeerDB to Advance Postgres CDC Integration Solutions
1 August 2024, Datanami

provided by Google News

Dr. Mike Flaxman, VP or Product Management at HEAVY.AI – Interview Series
19 September 2024, Unite.AI

5 Q’s for Mike Flaxman, Vice President of Heavy.AI
15 August 2024, Center for Data Innovation

HEAVY.AI Accelerates Big Data Analytics with Vultr's High-Performance GPU Cloud Infrastructure
11 September 2024, insideBIGDATA

HEAVY.AI Accelerates Big Data Analytics with Vultr’s High-Performance GPU Cloud Infrastructure
11 September 2024, insideBIGDATA

Meta delivers strong earnings, but weak guidance and heavy AI spending prompt investors to bail
24 April 2024, SiliconANGLE News

provided by Google News

SQL Extensions for Time-Series Data in QuestDB
11 January 2021, Towards Data Science

QuestDB snares $12M Series A with hosted version coming soon
3 November 2021, TechCrunch

Comparing Different Time-Series Databases
10 February 2022, hackernoon.com

Q&A: Nicolas Hourcard, QuestDB: The advantages of a time-series database
3 December 2020, Developer News

Aquis Exchange Goes Live With QuestDB For Real Time Monitoring
2 November 2022, FinanceFeeds

provided by Google News



Share this page

Featured Products

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.

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.

Present your product here