DB-EnginesExtremeDB: the first and only COTS deterministic embedded database management system for mission- and safety-critical hard real-time applicationsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Alibaba Cloud TSDB vs. Elasticsearch vs. TDSQL for MySQL vs. TimescaleDB

System Properties Comparison Alibaba Cloud TSDB vs. Elasticsearch vs. TDSQL for MySQL vs. TimescaleDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAlibaba Cloud TSDB  Xexclude from comparisonElasticsearch  Xexclude from comparisonTDSQL for MySQL  Xexclude from comparisonTimescaleDB  Xexclude from comparison
DescriptionA stable, reliable, and cost-effective online high-performance time series database serviceA distributed, RESTful modern search and analytics engine based on Apache Lucene infoElasticsearch lets you perform and combine many types of searches such as structured, unstructured, geo, and metricA high-performance distributed database management system with features such as automatic sharding, intelligent operation and maintenance, elastic scalability without downtime, and enterprise-grade security. It is highly compatible with MySQL.A time series DBMS optimized for fast ingest and complex queries, based on PostgreSQL
Primary database modelTime Series DBMSSearch engineRelational DBMSTime Series DBMS
Secondary database modelsDocument store
Spatial DBMS
Document store
Spatial DBMS
Relational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.31
Rank#268  Overall
#21  Time Series DBMS
Score160.75
Rank#8  Overall
#1  Search engines
Score0.54
Rank#236  Overall
#113  Relational DBMS
Score4.22
Rank#82  Overall
#5  Time Series DBMS
Websitewww.alibabacloud.com/­product/­hitsdbwww.elastic.co/­elasticsearchintl.cloud.tencent.com/­product/­dcdbwww.timescale.com
Technical documentationwww.alibabacloud.com/­help/­doc-detail/­55652.htmwww.elastic.co/­guide/­en/­elasticsearch/­reference/­current/­index.htmlintl.cloud.tencent.com/­product/­dcdb#m_developerdocs.timescale.com
DeveloperAlibabaElasticTencentTimescale
Initial release201020132017
Current release7.8.0, June 2020
License infoCommercial or Open SourcecommercialOpen Source infoApache Version 2; Elastic LicensecommercialOpen Source infoApache 2.0
Cloud-based only infoOnly available as a cloud serviceyesnoyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaC
Server operating systemshostedAll OS with a Java VMhostedLinux
OS X
Windows
Data schemeschema-freeschema-free infoFlexible type definitions. Once a type is defined, it is persistentyesyes
Typing infopredefined data types such as float or dateNumeric data and Stringsyesyesnumerics, 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 indexesnoyes infoAll search fields are automatically indexedyesyes
SQL infoSupport of SQLnoSQL-like query languageyesyes infofull PostgreSQL SQL syntax
APIs and other access methodsHTTP RESTJava API
RESTful HTTP/JSON API
JDBC
ODBC
ADO.NET
JDBC
native C library
ODBC
streaming API for large objects
Supported programming languagesJava.Net
Groovy
Community Contributed Clients
Java
JavaScript
Perl
PHP
Python
Ruby
C
C#
C++
Java
PHP
Python
Ruby
.Net
C
C++
Delphi
Java infoJDBC
JavaScript
Perl
PHP
Python
R
Ruby
Scheme
Tcl
Server-side scripts infoStored proceduresnoyesyesuser defined functions, PL/pgSQL, PL/Tcl, PL/Perl, PL/Python, PL/Java, PL/PHP, PL/R, PL/Ruby, PL/Scheme, PL/Unix shell
Triggersnoyes infoby using the 'percolation' featureyesyes
Partitioning methods infoMethods for storing different data on different nodesShardingAutomatic shardingyes, across time and space (hash partitioning) attributes
Replication methods infoMethods for redundantly storing data on multiple nodesyesMulti-source replication
Source-replica replication
Source-replica replication with hot standby and reads on replicas info
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoES-Hadoop Connectornono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual Consistency infoSynchronous doc based replication. Get by ID may show delays up to 1 sec. Configurable write consistency: one, quorum, allImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynononoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanonoACIDACID
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.noMemcached and Redis integrationnono
User concepts infoAccess controlAccess managed on TSDB instance levelUsers with fine-grained authorization conceptfine grained access rights according to SQL-standard

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
Alibaba Cloud TSDBElasticsearchTDSQL for MySQLTimescaleDB
DB-Engines blog posts

PostgreSQL is the DBMS of the Year 2017
2 January 2018, Paul Andlinger, Matthias Gelbmann

Elasticsearch moved into the top 10 most popular database management systems
3 July 2017, Matthias Gelbmann

MySQL, PostgreSQL and Redis are the winners of the March ranking
2 March 2016, Paul Andlinger

show all

Recent citations in the news

Elastic CEO reflects on Amazon spat, license switch, and the principles of open source
27 December 2021, VentureBeat

Elastic shares drop after co-founder of Banon steps down as CEO of software company
12 January 2022, CNBC

Qbox Joins Instaclustr, the Platform for Open Source Data
11 January 2022, GlobeNewswire

Getting Started with Python and InfluxDB – The New Stack
21 January 2022, thenewstack.io

Amazon’s Elasticsearch fork OpenSearch hits prime time
13 July 2021, VentureBeat

provided by Google News

OceanBase Records Over 100% Increase in Number of Customers
13 January 2022, KULR-TV

Tencent Cloud Steps Up Commitment in Indonesia Following Launch of First Internet Data Centre
6 September 2021, Yahoo Finance

Tencent Cloud deploys Tencent Distributed Database in Indonesia
17 November 2020, IBS Intelligence

Tencent Cloud unveils new data centre in Jakarta
12 April 2021, Channel Asia Singapore

provided by Google News

Understanding Hyperfunctions in TimescaleDB
11 August 2021, CDOTrends

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

Timescale launches the new Timescale Cloud, a hosted relational database for time-series
5 October 2021, Business Wire

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

provided by Google News

Job opportunities

ElasticSearch Administrator
AMCHES, INC, Annapolis Junction, MD

ElasticSearch Developer
ArthurPaige, Fort Meade, MD

Splunk Administrator
Excelraise, LLC, Clemson, SC

Software Engineer-All Levels
Comparenetworks Inc, Remote

Staff Software Engineer- Datastores
Slack, San Francisco, CA

Full Stack Engineer
Fox Robotics, Austin, TX

Senior Data Engineer - US Remote
Vyopta, Austin, TX

Staff Software Engineer
Harness.io, Belgrade, MT

QT/QML Software Engineer
Enea, Remote

Software Backend Developer
Plus Power, San Francisco, CA

jobs by Indeed



Share this page

Featured Products

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Datastax Astra logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Couchbase logo

The modern database for enterprise applications. Build fast. Scale Big. Save more.
Get started today.

Present your product here