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 > Heroic vs. Hypertable vs. IBM Cloudant vs. Microsoft Azure Synapse Analytics

System Properties Comparison Heroic vs. Hypertable vs. IBM Cloudant vs. Microsoft Azure Synapse Analytics

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameHeroic  Xexclude from comparisonHypertable  Xexclude from comparisonIBM Cloudant  Xexclude from comparisonMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data Warehouse  Xexclude from comparison
Hypertable has stopped its further development with March 2016 and is removed from the DB-Engines ranking.
DescriptionTime Series DBMS built at Spotify based on Cassandra or Google Cloud Bigtable, and ElasticSearchAn open source BigTable implementation based on distributed file systems such as HadoopDatabase as a Service offering based on Apache CouchDBElastic, large scale data warehouse service leveraging the broad eco-system of SQL Server
Primary database modelTime Series DBMSWide column storeDocument storeRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.25
Rank#280  Overall
#22  Time Series DBMS
Score3.26
Rank#95  Overall
#17  Document stores
Score21.33
Rank#36  Overall
#22  Relational DBMS
Websitespotify.github.io/­heroic/­#!/­indexwww.ibm.com/­cloud/­cloudantazure.microsoft.com/­services/­synapse-analytics
Technical documentationspotify.github.io/­heroic/­#!/­docs/­overviewcloud.ibm.com/­docs/­Cloudantdocs.microsoft.com/­azure/­synapse-analytics
DeveloperSpotifyHypertable Inc.IBM, Apache Software Foundation infoIBM acquired Cloudant in February 2014Microsoft
Initial release2014200920102016
Current release0.9.8.11, March 2016
License infoCommercial or Open SourceOpen Source infoApache 2.0Open Source infoGNU version 3. Commercial license availablecommercialcommercial
Cloud-based only infoOnly available as a cloud servicenonoyesyes
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaC++ErlangC++
Server operating systemsLinux
OS X
Windows infoan inofficial Windows port is available
hostedhosted
Data schemeschema-freeschema-freeschema-freeyes
Typing infopredefined data types such as float or dateyesnonoyes
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.nonono
Secondary indexesyes infovia Elasticsearchrestricted infoonly exact value or prefix value scansyesyes
SQL infoSupport of SQLnononoyes
APIs and other access methodsHQL (Heroic Query Language, a JSON-based language)
HTTP API
C++ API
Thrift
RESTful HTTP/JSON APIADO.NET
JDBC
ODBC
Supported programming languagesC++
Java
Perl
PHP
Python
Ruby
C#
Java
JavaScript
Objective-C
PHP
Ruby
C#
Java
PHP
Server-side scripts infoStored proceduresnonoView functions (Map-Reduce) in JavaScriptTransact SQL
Triggersnonoyesno
Partitioning methods infoMethods for storing different data on different nodesShardingShardingShardingSharding, horizontal partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesyesselectable replication factor on file system levelMulti-source replication
Source-replica replication
yes
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyesyesno
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Immediate Consistency
Immediate ConsistencyEventual ConsistencyImmediate Consistency
Foreign keys infoReferential integritynononono infodocs.microsoft.com/­en-us/­azure/­synapse-analytics/­sql-data-warehouse/­sql-data-warehouse-table-constraints
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanonono infoatomic operations within a document possibleACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes infoOptimistic lockingyes
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.nono
User concepts infoAccess controlnoAccess rights for users can be defined per databaseyes

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
HeroicHypertableIBM CloudantMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data Warehouse
Recent citations in the news

NoSQL Market In-Depth Insights, Revenue Details, Regional Analysis By 2030 | Aerospike, Neo4j, InfiniteGraph – Designer Women
13 June 2022, Designer Women

Non-relational SQL Market 2022: Industry Analysis, Opportunities, Demand, Top Players and Growth Forecast 2029 |Microsoft SQL Server, MySQL – Designer Women
23 June 2022, Designer Women

Columnar Databases Software Research & Clinical Advancements by 2030 – Designer Women
17 June 2022, Designer Women

Global Columnar Databases Software Market 2022 – Industry Size and Share, Business Strategies, Growth Analysis, Regional Demand by 2028 Key Drivers – MariaDB Corporation, Microsoft, Yandex, Crate.io – Designer Women
15 June 2022, Designer Women

NoSQL Database Market Share, Size Global Historical Analysis, Industry Key Strategies, Segmentation, Application, Technology, Trends and Growth Opportunities Forecasts to 2029
23 June 2022, Digital Journal

provided by Google News

IBM Expands Cloud Database Services with Kubernetes
26 September 2019, EnterpriseAI

IBM extends Call for Code for Racial Justice program
24 February 2021, TechTarget

Cloudant Upgrades Cloud Database Service With Integrated Text Indexing and Search Based on Apache Lucene
9 October 2012, PR Newswire

Indian water safety platform named winner of IBM Call for Code challenge
16 November 2021, ZDNet

Cloudant Merges BigCouch Into Apache CouchDB
22 July 2013, eWeek

provided by Google News

SynLapse: Orca Security Publishes Details for Critical Azure Synapse Vulnerability
25 June 2022, InfoQ.com

Microsoft takes months to fix critical Azure Synapse bug
15 June 2022, TechTarget

Researchers criticize Oracle's vulnerability disclosure process
24 June 2022, TechTarget

A New Microsoft Platform in Town: the Microsoft Intelligent Data Platform
8 June 2022, InfoQ.com

6 'nightmare' cloud security flaws were found in Azure in the last year. Does Microsoft have work to do?
1 June 2022, Protocol

provided by Google News

Job opportunities

Azure Administrator / Data Engineer
Agama Solutions, Las Vegas, NV

Azure Data Engineer
Agama Solutions, Houston, TX

Data Engineer - Azure
Intone Networks, Remote

Azure Architect
Triune Infomatics Inc, Oakland, CA

Support Engineer - Azure Synapse
Microsoft, Issaquah, WA

jobs by Indeed



Share this page

Featured Products

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!

Neo4j logo

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

Vertica logo

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

Redis logo

The world’s most loved real‑time data platform.
Try free

Present your product here