DB-EnginesExtremeDB: mitigate connectivity issues in a DBMSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Apache Druid vs. Axibase vs. Microsoft Azure Synapse Analytics vs. TimescaleDB vs. Tkrzw

System Properties Comparison Apache Druid vs. Axibase vs. Microsoft Azure Synapse Analytics vs. TimescaleDB vs. Tkrzw

Editorial information provided by DB-Engines
NameApache Druid  Xexclude from comparisonAxibase  Xexclude from comparisonMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data Warehouse  Xexclude from comparisonTimescaleDB  Xexclude from comparisonTkrzw infoSuccessor of Tokyo Cabinet and Kyoto Cabinet  Xexclude from comparison
DescriptionOpen-source analytics data store designed for sub-second OLAP queries on high dimensionality and high cardinality dataScalable TimeSeries DBMS based on HBase with integrated rule engine and visualizationElastic, large scale data warehouse service leveraging the broad eco-system of SQL ServerA time series DBMS optimized for fast ingest and complex queries, based on PostgreSQLA 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 modelRelational DBMS
Time Series DBMS
Time Series DBMSRelational DBMSTime Series DBMSKey-value store
Secondary database modelsRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score3.25
Rank#90  Overall
#47  Relational DBMS
#7  Time Series DBMS
Score0.35
Rank#282  Overall
#25  Time Series DBMS
Score19.93
Rank#31  Overall
#19  Relational DBMS
Score4.46
Rank#71  Overall
#5  Time Series DBMS
Score0.07
Rank#372  Overall
#57  Key-value stores
Websitedruid.apache.orgaxibase.com/­docs/­atsd/­financeazure.microsoft.com/­services/­synapse-analyticswww.timescale.comdbmx.net/­tkrzw
Technical documentationdruid.apache.org/­docs/­latest/­designdocs.microsoft.com/­azure/­synapse-analyticsdocs.timescale.com
DeveloperApache Software Foundation and contributorsAxibase CorporationMicrosoftTimescaleMikio Hirabayashi
Initial release20122013201620172020
Current release29.0.1, April 2024155852.15.0, May 20240.9.3, August 2020
License infoCommercial or Open SourceOpen Source infoApache license v2commercial infoCommunity Edition (single node) is free, Enterprise Edition (distributed) is paidcommercialOpen Source infoApache 2.0Open Source infoApache Version 2.0
Cloud-based only infoOnly available as a cloud servicenonoyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaJavaC++CC++
Server operating systemsLinux
OS X
Unix
LinuxhostedLinux
OS X
Windows
Linux
macOS
Data schemeyes infoschema-less columns are supportedyesyesyesschema-free
Typing infopredefined data types such as float or dateyesyes infoshort, integer, long, float, double, decimal, stringyesnumerics, strings, booleans, arrays, JSON blobs, geospatial dimensions, currencies, binary data, other complex data typesno
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.nononoyesno
Secondary indexesyesnoyesyes
SQL infoSupport of SQLSQL for queryingSQL-like query languageyesyes infofull PostgreSQL SQL syntaxno
APIs and other access methodsJDBC
RESTful HTTP/JSON API
JDBC
Proprietary protocol (Network API)
RESTful HTTP API
ADO.NET
JDBC
ODBC
ADO.NET
JDBC
native C library
ODBC
streaming API for large objects
Supported programming languagesClojure
JavaScript
PHP
Python
R
Ruby
Scala
Go
Java
PHP
Python
R
Ruby
C#
Java
PHP
.Net
C
C++
Delphi
Java infoJDBC
JavaScript
Perl
PHP
Python
R
Ruby
Scheme
Tcl
C++
Java
Python
Ruby
Server-side scripts infoStored proceduresnoyesTransact SQLuser defined functions, PL/pgSQL, PL/Tcl, PL/Perl, PL/Python, PL/Java, PL/PHP, PL/R, PL/Ruby, PL/Scheme, PL/Unix shellno
Triggersnoyesnoyesno
Partitioning methods infoMethods for storing different data on different nodesSharding infomanual/auto, time-basedShardingSharding, horizontal partitioningyes, across time and space (hash partitioning) attributesnone
Replication methods infoMethods for redundantly storing data on multiple nodesyes, via HDFS, S3 or other storage enginesSource-replica replicationyesSource-replica replication with hot standby and reads on replicas infonone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyesnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynonono infodocs.microsoft.com/­en-us/­azure/­synapse-analytics/­sql-data-warehouse/­sql-data-warehouse-table-constraintsyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanonoACIDACID
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.nonoyes infousing specific database classes
User concepts infoAccess controlRBAC using LDAP or Druid internals for users and groups for read/write by datasource and systemyesfine grained access rights according to SQL-standardno

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 DruidAxibaseMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data WarehouseTimescaleDBTkrzw infoSuccessor of Tokyo Cabinet and Kyoto Cabinet
Recent citations in the news

Apache Druid Wins Best Big Data Product in the 2023 BigDATAwire Readers' Choice Awards
26 January 2024, Datanami

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

New DDoS malware Attacking Apache big-data stack, Hadoop, & Druid Servers
26 February 2024, GBHackers

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

How to connect DataGrip to Apache Druid | by Zisis Flokas
18 October 2021, Towards Data Science

provided by Google News

The Ultimate ATV Test: Suzuki's King Quad 750 AXI Rugged Package vs. Alaska's Hunting Season
14 October 2020, Outdoor Life

Time Series Databases Software Market - A comprehensive study by Key Players | Warp 10, Amazon Timestream ...
6 February 2020, openPR

provided by Google News

General Available: Azure Synapse Runtime for Apache Spark 3.4 is now GA | Azure updates
8 April 2024, azure.microsoft.com

Azure Synapse Runtime for Apache Spark 3.2 End of Support | Azure updates
22 March 2024, azure.microsoft.com

Azure Synapse Analytics: Everything you need to know about Microsoft's cloud analytics platform
24 September 2023, DataScientest

Migrate Microsoft Azure Synapse Analytics to Amazon Redshift using AWS SCT | Amazon Web Services
18 October 2023, AWS Blog

Azure Synapse vs. Databricks: Data Platform Comparison 2024
26 March 2024, eWeek

provided by Google News

TimescaleDB Is a Vector Database Now, Too
25 September 2023, Datanami

Timescale Acquires PopSQL to Bring a Modern, Collaborative SQL GUI to PostgreSQL Developers
4 April 2024, PR Newswire

Power IoT and time-series workloads with TimescaleDB for Azure Database for PostgreSQL
18 March 2019, azure.microsoft.com

Timescale Valuation Rockets to Over $1B with $110M Round, Marking the Explosive Rise of Time-Series Data
22 February 2022, Business Wire

Timescale announces $15M investment and new enterprise version of TimescaleDB
29 January 2019, TechCrunch

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

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus 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