DB-EnginesEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

DBMS > Apache Impala vs. H2 vs. LevelDB vs. NuoDB vs. TerarkDB

System Properties Comparison Apache Impala vs. H2 vs. LevelDB vs. NuoDB vs. TerarkDB

Editorial information provided by DB-Engines
NameApache Impala  Xexclude from comparisonH2  Xexclude from comparisonLevelDB  Xexclude from comparisonNuoDB  Xexclude from comparisonTerarkDB  Xexclude from comparison
DescriptionAnalytic DBMS for HadoopFull-featured RDBMS with a small footprint, either embedded into a Java application or used as a database server.Embeddable fast key-value storage library that provides an ordered mapping from string keys to string valuesNuoDB is a webscale distributed database that supports SQL and ACID transactionsA key-value store forked from RocksDB with advanced compression algorithms. It can be used standalone or as a storage engine for MySQL and MongoDB
Primary database modelRelational DBMSRelational DBMSKey-value storeRelational DBMSKey-value store
Secondary database modelsDocument storeSpatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score10.08
Rank#41  Overall
#25  Relational DBMS
Score7.32
Rank#49  Overall
#31  Relational DBMS
Score2.39
Rank#110  Overall
#18  Key-value stores
Score0.85
Rank#206  Overall
#98  Relational DBMS
Score0.00
Rank#388  Overall
#62  Key-value stores
Websiteimpala.apache.orgwww.h2database.comgithub.com/­google/­leveldbwww.3ds.com/­nuodb-distributed-sql-databasegithub.com/­bytedance/­terarkdb
Technical documentationimpala.apache.org/­impala-docs.htmlwww.h2database.com/­html/­main.htmlgithub.com/­google/­leveldb/­blob/­main/­doc/­index.mddoc.nuodb.combytedance.larkoffice.com/­docs/­doccnZmYFqHBm06BbvYgjsHHcKc
DeveloperApache Software Foundation infoApache top-level project, originally developed by ClouderaThomas MuellerGoogleDassault Systèmes infooriginally NuoDB, Inc.ByteDance, originally Terark
Initial release20132005201120132016
Current release4.1.0, June 20222.2.220, July 20231.23, February 2021
License infoCommercial or Open SourceOpen Source infoApache Version 2Open Source infodual-licence (Mozilla public license, Eclipse public license)Open Source infoBSDcommercial infolimited edition freecommercial inforestricted open source version available
Cloud-based only infoOnly available as a cloud servicenonononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++JavaC++C++C++
Server operating systemsLinuxAll OS with a Java VMIllumos
Linux
OS X
Windows
hosted infoAmazon EC2, Windows Azure, SoftLayer
Linux
OS X
Windows
Data schemeyesyesschema-freeyesschema-free
Typing infopredefined data types such as float or dateyesyesnoyesno
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.nonononono
Secondary indexesyesyesnoyesno
SQL infoSupport of SQLSQL-like DML and DDL statementsyesnoyesno
APIs and other access methodsJDBC
ODBC
JDBC
ODBC
ADO.NET
JDBC
ODBC
C++ API
Java API
Supported programming languagesAll languages supporting JDBC/ODBCJavaC++
Go
Java info3rd party binding
JavaScript (Node.js) info3rd party binding
Python info3rd party binding
.Net
C
C++
Go
Java
JavaScript
JavaScript (Node.js)
PHP
Python
Ruby
C++
Java
Server-side scripts infoStored proceduresyes infouser defined functions and integration of map-reduceJava Stored Procedures and User-Defined FunctionsnoJava, SQLno
Triggersnoyesnoyesno
Partitioning methods infoMethods for storing different data on different nodesShardingnonenonedata is dynamically stored/cached on the nodes where it is read/writtennone
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factorWith clustering: 2 database servers on different computers operate on identical copies of a databasenoneyes infoManaged transparently by NuoDBnone
MapReduce infoOffers an API for user-defined Map/Reduce methodsyes infoquery execution via MapReducenononono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual ConsistencyImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyesnoyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACIDnoACID infotunable commit protocolno
Concurrency infoSupport for concurrent manipulation of datayesyes, multi-version concurrency control (MVCC)yesyes infoMVCCyes
Durability infoSupport for making data persistentyesyesyes infowith automatic compression on writesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyesyes infoTemporary tableyes
User concepts infoAccess controlAccess rights for users, groups and roles infobased on Apache Sentry and Kerberosfine grained access rights according to SQL-standardnoStandard SQL roles/ privileges, Administrative Usersno

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
Apache ImpalaH2LevelDBNuoDBTerarkDB
DB-Engines blog posts

Meet some database management systems you are likely to hear more about in the future
4 August 2014, Paul Andlinger

show all

Recent citations in the news

Cloudera brings Apache Iceberg data lake format to its Data Platform
30 June 2022, SiliconANGLE News

Building a Large-scale Transactional Data Lake at Uber Using Apache Hudi
9 June 2020, Uber

Apache Iceberg Changes Everything: What's Underneath?
28 August 2023, Spiceworks News and Insights

Apache Doris just 'graduated': Why care about this SQL data warehouse
24 June 2022, InfoWorld

Query your (big) data with the power of Python, Dask, and SQL
7 December 2020, Towards Data Science

provided by Google News

Pliops unveils XDP-Rocks for RocksDB
19 October 2022, Blocks & Files

Inside the "Fallguys" malware that steals your browsing data and gaming IMs; continued attack on open source software
2 September 2020, Sonatype Blog

RocksDB - Facebook's Database Now Open Source
21 November 2013, iProgrammer

New ransomware encrypts files, then steals your Discord account
20 November 2022, BleepingComputer

GIFShell - New Attack Method That Allows Attackers to Steal Data Using Microsoft Teams GIFs
9 September 2022, CybersecurityNews

provided by Google News

NuoDB 4.0 Expands Cloud-native and Cloud-agnostic Capabilities of Distributed SQL Database
29 July 2019, GlobeNewswire

Deploy the NuoDB Database in Docker Containers
16 October 2017, The New Stack

NuoDB Raises $14.2M Round Led By Dassault Systèmes For Its Distributed Database Management System
26 February 2014, TechCrunch

NuoDB Cloud Database System Could Spark A SaaS Boom
10 January 2013, ChannelBiz UK

70 new job as NuoDB Launches Development Centre for EMEA in Ireland - Irish Tech News
5 December 2017, Irish Tech News

provided by Google News



Share this page

Featured Products

Neo4j logo

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

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB for free.

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

SingleStore logo

The data platform to build your intelligent applications.
Try it free.

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

Present your product here