DB-EnginesExtremeDB Active Replication featuresEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > ClickHouse vs. EXASOL vs. TempoIQ vs. TimescaleDB

System Properties Comparison ClickHouse vs. EXASOL vs. TempoIQ vs. TimescaleDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameClickHouse  Xexclude from comparisonEXASOL  Xexclude from comparisonTempoIQ infoformerly TempoDB  Xexclude from comparisonTimescaleDB  Xexclude from comparison
TempoIQ seems to be decommissioned. It will be removed from the DB-Engines ranking.
DescriptionColumn-oriented Relational DBMS powering YandexHigh-performance, in-memory, MPP database specifically designed for in-memory analytics.Scalable analytics DBMS for sensor data, provided as a service (SaaS)A time series DBMS optimized for fast ingest and complex queries, based on PostgreSQL
Primary database modelRelational DBMSRelational DBMSTime Series DBMSTime Series DBMS
Secondary database modelsTime Series DBMSRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score9.26
Rank#49  Overall
#29  Relational DBMS
Score3.89
Rank#83  Overall
#45  Relational DBMS
Score3.24
Rank#93  Overall
#5  Time Series DBMS
Websiteclickhouse.techwww.exasol.comtempoiq.com (offline)www.timescale.com
Technical documentationclickhouse.tech/­docswww.exasol.com/­resourcesdocs.timescale.com
DeveloperYandex LLCExasolTempoIQTimescale
Initial release2016200020122017
Current releasev20.11.3.3-stable, November 2020
License infoCommercial or Open SourceOpen Source infoApache 2.0commercialcommercialOpen Source infoApache 2.0
Cloud-based only infoOnly available as a cloud servicenonoyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++C
Server operating systemsFreeBSD
Linux
macOS
Linux
OS X
Windows
Data schemeyesyesschema-freeyes
Typing infopredefined data types such as float or dateyesyesyesnumerics, strings, booleans, arrays, JSON blobs, geospatial dimensions, currencies, binary data, other complex data types
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.nononoyes
Secondary indexesnoyesyes
SQL infoSupport of SQLClose to ANSI SQLyesnoyes infofull PostgreSQL SQL syntax
APIs and other access methodsHTTP REST
JDBC
ODBC
Proprietary protocol
.Net
JDBC
ODBC
WebSocket
HTTP APIADO.NET
JDBC
native C library
ODBC
streaming API for large objects
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
Scala info3rd party library
Java
Lua
Python
R
C#
Java
JavaScript infoNode.js
Python
Ruby
.Net
C
C++
Delphi
Java infoJDBC
JavaScript
Perl
PHP
Python
R
Ruby
Scheme
Tcl
Server-side scripts infoStored proceduresnouser defined functionsnouser defined functions, PL/pgSQL, PL/Tcl, PL/Perl, PL/Python, PL/Java, PL/PHP, PL/R, PL/Ruby, PL/Scheme, PL/Unix shell
Triggersnoyesyes infoRealtime Alertsyes
Partitioning methods infoMethods for storing different data on different nodesShardingyes, across time and space (hash partitioning) attributes
Replication methods infoMethods for redundantly storing data on multiple nodesSource-replica replication with hot standby and reads on replicas info
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyes infoHadoop integrationnono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyesnoyes
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
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesnono
User concepts infoAccess controlAccess rights for users and rolesAccess rights for users, groups and roles according to SQL-standardsimple authentication-based access controlfine grained access rights according to SQL-standard
More information provided by the system vendor
ClickHouseEXASOLTempoIQ infoformerly TempoDBTimescaleDB
Specific characteristicsTimescale is the creator of TimescaleDB , the first open-source relational database...
» more
Competitive advantagesTimescaleDB is purpose-built to scale and handle time-series data workloads and is...
» more
Typical application scenariosDevOps and Infrastructure Monitoring All monitoring data is time-series data. Efficiently...
» more
Key customersTransferWise, Maersk, AppDynamics, Walmart, Comcast, LaunchDarkly, IBM, NOV, Cisco,...
» more
Market metricsWith over 9,000 GitHub stars and growing, 600,000 active databases, and an active...
» more
Licensing and pricing modelsTimescaleDB comes in 3 versions, including fully managed Cloud-hosted solutions*,...
» 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 partiesClusterControl: the only management system you’ll ever need to take control of your open source database infrastructure.
» more

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

More resources
ClickHouseEXASOLTempoIQ infoformerly TempoDBTimescaleDB
Recent citations in the news

Altinity grabs $4M seed to build cloud version of ClickHouse open-source data warehouse
1 October 2020, TechCrunch

Alibaba Cloud Launches New Livestreaming E-commerce Solution at Its Cloud Summit
9 June 2021, Al-Bawaba

Aiven set to grow open source database-as-a-service platform
30 March 2021, TechTarget

Open source product analytics platform PostHog raises $15M
10 June 2021, VentureBeat

Machine Learning Capabilities Come to the Majority of Open Source Databases with MindsDB AI-Tables
20 October 2020, PR Web

provided by Google News

Exasol Appoints Jan-Dirk Henrich as Chief Financial Officer
14 June 2021, Business Wire

Exasol Becomes Carbon Neutral with Planetly
25 May 2021, Business Wire

Exasol Beats Own TPC-H Benchmark Performance Records
2 June 2021, StreetInsider.com

In-memory OLAP Database Market Size and Growth 2021-2027 | Major Players – Altibase, IBM, Microsoft, Oracle, SAP SE, Exasol, Jedox, Kognitio – The Manomet Current
9 June 2021, The Manomet Current

In-Memory Database Market – Major Technology Giants in Buzz Again | Redis Labs, Tibco Software Inc., Centrum Wiskunde And Informatica – The Manomet Current
24 May 2021, The Manomet Current

provided by Google News

Global IIoT and Cloud Computing Market 2021 to 2026 Research Covers Top Players XMPro, Siemens AG, Bosch, IBM – The Courier
3 June 2021, The Courier

Big Data and Analytics Market Quality & Quantity Analysis | Microsoft, MongoDB, Predikto, Informatica – KSU | The Sentinel Newspaper
15 June 2021, KSU | The Sentinel Newspaper

Cloud Computing in Industrial IoT Market COVID 19 Impacted In-Depth Analysis including key players AWS, XMPro, Siemens AG, Bosch – KSU | The Sentinel Newspaper
19 June 2021, KSU | The Sentinel Newspaper

Cloud Computing in Industrial IoT Market – increasing demand with Industry Professionals: AWS, XMPro, Siemens AG, Bosch – KSU | The Sentinel Newspaper
14 June 2021, KSU | The Sentinel Newspaper

Global Cloud Computing in Industrial IoT Market 2021 Study By Regions, Type and Product Forecast 2026 – The Courier
11 June 2021, The Courier

provided by Google News

Timescale scales out and sets its sights on analytics
17 June 2021, ZDNet

Timescale Launches Industry's First Multi-Node Relational Database for Time-Series Data, Giving Organizations Unprecedented Scale
29 October 2020, Business Wire

Timescale grabs $40M Series B as it goes all in on cloud version of time series database
5 May 2021, TechCrunch

TimescaleDB Delivers Another Option for Time-Series Analytics
17 October 2019, Datanami

Digging under the covers of AWS' Timestream database with Amazon CTO Werner Vogels
7 June 2021, SiliconANGLE News

provided by Google News

Job opportunities

Senior Database Engineer
PingCAP, Remote

Senior Database Engineer (Runtime)
PingCAP, Remote

Sr Member of Technical Staff, SDWAN & SASE - Opportunity for Working Remotely Milwaukee, WI
VMware, Milwaukee, WI

Senior Distributed Database Architect - Factory Systems
Rivian Automotive, Remote

Data Engineering Manager
Sony Interactive Entertainment PlayStation, San Diego, CA

Senior Reporting Analyst
Bumble, Austin, TX

Service Delivery Manager
Exasol, Atlanta, GA

BI Data Analyst/Developer
DJO Global, Dallas, TX

Principal Business Systems Analyst
Equinix, Frisco, TX

Senior Business System Analyst
Equinix, Frisco, TX

Software Engineers I/II/III - Remote Work Options Available
UNAVCO, Inc., Boulder, CO

Software Engineer II: Cloud Storage Platforms
DigitalOcean, New York State

C++ Engineer
MachineMetrics, Massachusetts

Senior Engineer-Observability Platforms
Digital Ocean Jobs, Colorado

Data Analyst
KW Engineering, San Diego, CA

jobs by Indeed




Share this page

Featured Products

Neo4j logo

Get your free copy of the new O'Reilly book Graph Algorithms with 20+ examples for
machine learning, graph analytics and more.

AllegroGraph logo

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

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 5 GB free..

Couchbase logo

SQL + JSON + NoSQL.
Power, flexibility & scale.
All open source.
Get started now.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Present your product here