DB-EngineseXtremeDB Telecom and Networking featuresEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Hypertable vs. IBM Db2

System Properties Comparison Hypertable vs. IBM Db2

Please select another system to include it in the comparison.

Our visitors often compare Hypertable and IBM Db2 with MongoDB, Cassandra and PostgreSQL.

Editorial information provided by DB-Engines
NameHypertable  Xexclude from comparisonIBM Db2 infoformerly named DB2 or IBM Database 2  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 HadoopCommon in IBM host environments, 2 different versions for host and Windows/Linux
Primary database modelWide column storeRelational DBMS infoSince Version 10.5 support for JSON/BSON documents compatible with MongoDB
Secondary database modelsDocument store
RDF store infoin DB2 LUW (Linux, Unix, Windows)
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score160.43
Rank#6  Overall
#5  Relational DBMS
Websitewww.ibm.com/­analytics/­db2
Technical documentationwww.ibm.com/­support/­knowledgecenter/­SSEPGG
DeveloperHypertable Inc.IBM
Initial release20091983 infohost version
Current release0.9.8.11, March 201612.1, October 2016
License infoCommercial or Open SourceOpen Source infoGNU version 3. Commercial license availablecommercial infofree version is available
Cloud-based only infoOnly available as a cloud servicenono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++C and C++
Server operating systemsLinux
OS X
Windows infoan inofficial Windows port is available
AIX
HP-UX
Linux
Solaris
Windows
z/OS
Data schemeschema-freeyes
Typing infopredefined data types such as float or datenoyes
Secondary indexesrestricted infoonly exact value or prefix value scansyes
SQL infoSupport of SQLnoyes
APIs and other access methodsC++ API
Thrift
ADO.NET
JDBC
JSON style queries infoMongoDB compatible
ODBC
XQuery
Supported programming languagesC++
Java
Perl
PHP
Python
Ruby
C
C#
C++
Cobol
Delphi
Fortran
Java
Perl
PHP
Python
Ruby
Visual Basic
Server-side scripts infoStored proceduresnoyes
Triggersnoyes
Partitioning methods infoMethods for storing different data on different nodesShardingSharding infoonly with Windows/Unix/Linux Version
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factor on file system levelyes infowith separate tools (MQ, InfoSphere)
MapReduce infoOffers an API for user-defined Map/Reduce methodsyesno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate 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 controlnofine 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
3rd partiesGeneral SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
» more

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

More resources
HypertableIBM Db2 infoformerly named DB2 or IBM Database 2
Recent citations in the news

Global NoSQL Databasess Market Size, Demand, Growth, Trends, Segmentation and Forecasts Research to 2025
2 December 2020, The Haitian-Caribbean News Network

Global Nosql Market 2026 Growth Analysis by Manufacturers, Regions, Type and Application, Forecast Analysis
28 November 2020, The Market Feed

Impact of Covid 19 On NoSQL Market 2020 Industry Challenges Business Overview And Forecast Research Study 2026
4 December 2020, Factory Maintenance

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

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

provided by Google News

IBM Positioned as a Leader In 2020 Gartner Magic Quadrant for Cloud Database Management Systems
3 December 2020, AiThority

Who's Winning the Cloud Database War
2 December 2020, Datanami

IBM to deliver refurbished Db2 for the AI and cloud era
24 November 2020, TechTarget

Trinity Guard Unveils New Tools for Linux, Db2 for i
18 November 2020, IT Jungle

IBM urges infosec pros to patch DB2 for Windows, Cisco urges patches for Webex Meetings
20 November 2020, IT World Canada

provided by Google News

Job opportunities

Jr. SQL Database Administrator
GOLDEN WOLF LLC, Remote

Data Analyst - Apprenticeship - Central AR
Arkansas Center for Data Sciences, Little Rock, AR

Intermediate Database Administrator - Denver, CO (remote)
Hosting, Denver, CO

DB2-DBA
Celandyne Software Solutions, Santa Clara, CA

Mainframe DB2 Support Technician
State of Wisconsin, Dane County, WI

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.

Vertica logo

The fastest unified analytical warehouse at extreme scale with in-database Machine Learning. Try Vertica for free with no time limit.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Datastax Astra logo

Cassandra made easy in the cloud. Build cloud-native applications faster with CQL, REST and GraphQL APIs.
Try for Free.

Couchbase logo

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

Present your product here