DB-EnginesCrateDB bannerEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Hypertable vs. Microsoft Azure SQL Data Warehouse

System Properties Comparison Hypertable vs. Microsoft Azure SQL Data Warehouse

Please select another system to include it in the comparison.

Our visitors often compare Hypertable and Microsoft Azure SQL Data Warehouse with MongoDB, Cassandra and PostgreSQL.

Editorial information provided by DB-Engines
NameHypertable  Xexclude from comparisonMicrosoft Azure SQL Data Warehouse  Xexclude from comparison
Hypertable has stopped its further development with March 2016 and is removed from the DB-Engines ranking.
DescriptionAn open source BigTable implementation based on distributed file systems such as HadoopElastic, large scale data warehouse service leveraging the broad eco-system of SQL Server
Primary database modelWide column storeRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score9.21
Rank#42  Overall
#26  Relational DBMS
Websiteazure.microsoft.com/­services/­sql-data-warehouse
Technical documentationdocs.microsoft.com/­azure/­sql-data-warehouse
DeveloperHypertable Inc.Microsoft
Initial release20092016
Current release0.9.8.11, March 2016
License infoCommercial or Open SourceOpen Source infoGNU version 3. Commercial license availablecommercial
Cloud-based only infoOnly available as a cloud servicenoyes
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++C++
Server operating systemsLinux
OS X
Windows infoan inofficial Windows port is available
hosted
Data schemeschema-freeyes
Typing infopredefined data types such as float or datenoyes
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.no
Secondary indexesrestricted infoonly exact value or prefix value scansyes
SQL infoSupport of SQLnoyes
APIs and other access methodsC++ API
Thrift
ADO.NET
JDBC
ODBC
Supported programming languagesC++
Java
Perl
PHP
Python
Ruby
C#
Java
PHP
Server-side scripts infoStored proceduresnoTransact SQL
Triggersnono
Partitioning methods infoMethods for storing different data on different nodesShardingSharding, horizontal partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factor on file system levelyes
MapReduce infoOffers an API for user-defined Map/Reduce methodsyesno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACID
Concurrency infoSupport for concurrent manipulation of datayesyes
Durability infoSupport for making data persistentyesyes
User concepts infoAccess controlnoyes

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
HypertableMicrosoft Azure SQL Data Warehouse
DB-Engines blog posts

Azure SQL Data Warehouse, the hub for a trusted and performance optimized cloud data warehouse
1 November 2017,  Arnaud Comet, Microsoft (sponsor) 

show all

Recent citations in the news

Global NoSQL Market 2019 by Manufacturers, Countries, Type and Application, Forecast to 2025
10 December 2019, World Industry Reports

TimescaleDB goes distributed; implements ‘Chunking’ over ‘Sharding’ for scaling-out
22 August 2019, Packt Hub

NoSQL Market with Future Prospects, Key Player SWOT Analysis and Forecast To 2024
5 December 2019, Exponent Online

Global NoSQL Market 2019-2025 MongoLab, MarkLogic, Couchbase, CloudDB, DynamoDB, Basho Technologies
10 December 2019, Global Industry Analysis

NoSQL Market Growth 2025: including key players Microsoft SQL Server, MySQL, MongoDB, PostgreSQL, Oracle Database, MongoLab
18 November 2019, Med News Ledger

provided by Google News

A first look at Azure Synapse
10 December 2019, InfoWorld

Microsoft Announces Azure Synapse for Data Warehousing and Analytics
20 November 2019, InfoQ.com

How to share SQL tables and views using Azure Data Share - Microsoft
29 November 2019, Channel 9

Microsoft shows off hybrid cloud management and cloud analytics tools at Ignite
14 November 2019, CIO

Microsoft Azure Synapse Analytics Torches Google and Amazon
12 November 2019, Cloud Wars

provided by Google News

Job opportunities

Senior Infrastructure Engineer
Phone Greetings, Orlando, FL

Data Engineers
ARK Solutions, Woonsocket, RI

Data Engineer (Contract)
Capgemini, Woonsocket, RI

Data Architect (Azure)
Bloomin' Brands, Tampa, FL

Data Analyst
Mastery Logistics Systems, Chicago, IL

Entry Level Software Developer - Data Analytics
BDO, Oak Brook, IL

jobs by Indeed




Share this page

Featured Products

Redis logo

Hosted, serverless DBaaS
in 3 steps.

30MB Free!
Start now.

RavenDB logo

Setup a fully managed RavenDB Cloud Database in minutes. Enjoy hosting, management, backups all in one place.
Grab a Free Instance

Couchbase logo

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

Neo4j logo

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


Datastax logo

Build data-driven applications that set the standard for performance, availability,
& scale with DataStax.
Learn more.

Present your product here