DB-EnginesExtremeDB: the mission critical dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > HarperDB vs. Hive vs. IBM Db2 warehouse

System Properties Comparison HarperDB vs. Hive vs. IBM Db2 warehouse

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameHarperDB  Xexclude from comparisonHive  Xexclude from comparisonIBM Db2 warehouse infoformerly named IBM dashDB  Xexclude from comparison
DescriptionUltra-low latency distributed database with an intuitive REST API supporting NoSQL and SQL (including joins). Deployment of functions and databases simultaneously with a consolidated node-level architecture.data warehouse software for querying and managing large distributed datasets, built on HadoopCloud-based data warehousing service
Primary database modelDocument storeRelational DBMSRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.40
Rank#258  Overall
#39  Document stores
Score78.66
Rank#17  Overall
#11  Relational DBMS
Score1.73
Rank#133  Overall
#66  Relational DBMS
Websiteharperdb.iohive.apache.orgwww.ibm.com/­products/­db2-warehouse
Technical documentationharperdb.io/­developers/­documentation/­overviewcwiki.apache.org/­confluence/­display/­Hive/­Home
DeveloperHarperDBApache Software Foundation infoinitially developed by FacebookIBM
Initial release201720122014
Current release3.1, August 20213.1.2, August 2019
License infoCommercial or Open Sourcecommercial infofree community edition availableOpen Source infoApache Version 2commercial
Cloud-based only infoOnly available as a cloud servicenonoyes
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageNode.jsJava
Server operating systemsLinux
OS X
All OS with a Java VMhosted
Data schemedynamic schemayesyes
Typing infopredefined data types such as float or dateyes infoJSON data typesyesyes
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.nono infoImport/export of XML data possible
Secondary indexesyesyesyes
SQL infoSupport of SQLSQL-like data manipulation statementsSQL-like DML and DDL statementsyes
APIs and other access methodsJDBC
ODBC
React Hooks
RESTful HTTP/JSON API
WebSocket
JDBC
ODBC
Thrift
.NET Client API
JDBC
ODBC
OLE DB
Supported programming languages.Net
C
C#
C++
ColdFusion
D
Dart
Delphi
Erlang
Go
Haskell
Java
JavaScript (Node.js)
Lisp
MatLab
Objective C
Perl
PHP
PowerShell
Prolog
Python
R
Ruby
Rust
Scala
Swift
C++
Java
PHP
Python
Java
JavaScript (Node.js)
Perl
PHP
Python
R
Ruby
Server-side scripts infoStored proceduresCustom Functions infosince release 3.1yes infouser defined functions and integration of map-reducePL/SQL, SQL PL
Triggersnonoyes
Partitioning methods infoMethods for storing different data on different nodesA table resides as a whole on one (or more) nodes in a clusterShardingSharding
Replication methods infoMethods for redundantly storing data on multiple nodesyes infothe nodes on which a table resides can be definedselectable replication factoryes
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyes infoquery execution via MapReduceno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual ConsistencyImmediate Consistency
Foreign keys infoReferential integritynonoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataAtomic execution of specific operationsnoACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyes, using LMDByesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyes
User concepts infoAccess controlAccess rights for users and rolesAccess rights for users, groups and rolesfine grained access rights according to SQL-standard
More information provided by the system vendor
HarperDBHiveIBM Db2 warehouse infoformerly named IBM dashDB
Specific characteristicsHarperDB is the first distributed database with hybrid SQL & NoSQL functionality...
» more
Competitive advantagesBy combining the functionality of the best SQL, NoSQL, and NewSQL products on the...
» more
Typical application scenariosUse cases where HarperDB is a better fit than other solutions include: Rapid app...
» more
Key customersA few highlighted customers include: US Army, US Airforce, Chelan PUD, TATA, & Lumen....
» more
Market metricsOver 94K total HarperDB users : 16,500+ npm downloads 73,600+ on Docker Hub 4,200+...
» more
Licensing and pricing modelsHarperDB follows a freemium/premium model . A data base is only as powerful as it...
» more

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 partiesSQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
» more

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

More resources
HarperDBHiveIBM Db2 warehouse infoformerly named IBM dashDB
DB-Engines blog posts

Why is Hadoop not listed in the DB-Engines Ranking?
13 May 2013, Paul Andlinger

show all

Recent citations in the news

Jaxon Repp on HarperDB Distributed Database Platform
23 March 2022, InfoQ.com

Build a Hacker News Clone using React and HarperDB
18 October 2021, SitePoint

HarperDB: An underdog SQL / NoSQL database
7 February 2018, ZDNet

JAMstack Radio | Ep. #85, Data Replication at Speed with Jaxon Repp of HarperDB
19 August 2021, Heavybit

HarperDB Releases A Fully Managed & Hosted Cloud Offering
23 April 2020, Analytics India Magazine

provided by Google News

Top 10 Hadoop Analytics Tools Used in Big Data Projects in 2022
31 July 2022, Analytics Insight

Top 10 Big Data Architect Jobs to Apply for in August 2022
2 August 2022, Analytics Insight

How companies can support employees amidst political unrest
8 August 2022, Open Access Government

Compare Hadoop vs. Spark vs. Kafka for your big data strategy
15 November 2021, TechTarget

WANdisco introduces Hive metadata migration to Databricks
24 May 2021, TechTarget

provided by Google News

Review: Snowflake aces Python machine learning
3 August 2022, InfoWorld

Nucleus Research Analyzes Adoption of Modern Data Warehouse Technology in New Value Matrix
15 February 2022, Business Wire

Log4j: Major IT vendors rush out fixes for this flaw and more ahead of Christmas
17 December 2021, ZDNet

Data Warehouse Automation and the Hybrid, Multi-Cloud
29 October 2021, ITPro Today

The 10 Best Cloud Data Warehouse Solutions to Consider in 2022
22 December 2021, Solutions Review

provided by Google News

Job opportunities

Senior Manager IT Infrastructure - Work from Home
Lumen, Broomfield, CO

LEAD IT INFRASTRUCTURE ENGINEER
Lumen, Broomfield, CO

Sr. Data Engineers
GSPANN Technologie, Portland, OR

Software Engineer Specialist - Modernization
Global Payments, Alpharetta, GA

Bigdata with Pyspark
Virtusa, Irving, TX

Data Engineer
Amazon.com Services LLC, Remote

BI Data Engineer-Work from home-eviCore
Cigna, Hartford, CT

Middleware Administrator
Snap IT Solutions, Houston, TX

AWS Redshift Data Engineer with Python
ClearScale, Remote

Data Engineer and Database Administrator, Senior Consultant
Guidehouse, Washington, DC

Technical Sales Specialist- Data and AI- NYC Market
IBM, New York, NY

AWS Redshift Data Engineer
ClearScale, Remote

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.

Vertica logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Redis logo

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

Neo4j logo

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

Present your product here