DB-EnginesextremeDB - Data management wherever you need itEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

DBMS > Apache Impala vs. BoltDB vs. Greenplum vs. IBM Db2 Event Store vs. Microsoft Azure Cosmos DB

System Properties Comparison Apache Impala vs. BoltDB vs. Greenplum vs. IBM Db2 Event Store vs. Microsoft Azure Cosmos DB

Editorial information provided by DB-Engines
NameApache Impala  Xexclude from comparisonBoltDB  Xexclude from comparisonGreenplum  Xexclude from comparisonIBM Db2 Event Store  Xexclude from comparisonMicrosoft Azure Cosmos DB infoformer name was Azure DocumentDB  Xexclude from comparison
DescriptionAnalytic DBMS for HadoopAn embedded key-value store for Go.Analytic Database platform built on PostgreSQL. Full name is Pivotal Greenplum Database infoA logical database in Greenplum is an array of individual PostgreSQL databases working together to present a single database image.Distributed Event Store optimized for Internet of Things use casesGlobally distributed, horizontally scalable, multi-model database service
Primary database modelRelational DBMSKey-value storeRelational DBMSEvent Store
Time Series DBMS
Document store
Graph DBMS
Key-value store
Wide column store
Secondary database modelsDocument storeDocument store
Spatial DBMS
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score10.63
Rank#40  Overall
#24  Relational DBMS
Score0.70
Rank#225  Overall
#31  Key-value stores
Score7.71
Rank#46  Overall
#29  Relational DBMS
Score0.18
Rank#315  Overall
#2  Event Stores
#26  Time Series DBMS
Score24.97
Rank#27  Overall
#4  Document stores
#2  Graph DBMS
#3  Key-value stores
#3  Wide column stores
Websiteimpala.apache.orggithub.com/­boltdb/­boltgreenplum.orgwww.ibm.com/­products/­db2-event-storeazure.microsoft.com/­services/­cosmos-db
Technical documentationimpala.apache.org/­impala-docs.htmldocs.greenplum.orgwww.ibm.com/­docs/­en/­db2-event-storelearn.microsoft.com/­azure/­cosmos-db
DeveloperApache Software Foundation infoApache top-level project, originally developed by ClouderaPivotal Software Inc.IBMMicrosoft
Initial release20132013200520172014
Current release4.1.0, June 20227.0.0, September 20232.0
License infoCommercial or Open SourceOpen Source infoApache Version 2Open Source infoMIT LicenseOpen Source infoApache 2.0commercial infofree developer edition availablecommercial
Cloud-based only infoOnly available as a cloud servicenonononoyes
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++GoC and C++
Server operating systemsLinuxBSD
Linux
OS X
Solaris
Windows
LinuxLinux infoLinux, macOS, Windows for the developer additionhosted
Data schemeyesschema-freeyesyesschema-free
Typing infopredefined data types such as float or dateyesnoyesyesyes infoJSON types
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.nonoyes infosince Version 4.2no
Secondary indexesyesnoyesnoyes infoAll properties auto-indexed by default
SQL infoSupport of SQLSQL-like DML and DDL statementsnoyesyes infothrough the embedded Spark runtimeSQL-like query language
APIs and other access methodsJDBC
ODBC
JDBC
ODBC
ADO.NET
DB2 Connect
JDBC
ODBC
RESTful HTTP API
DocumentDB API
Graph API (Gremlin)
MongoDB API
RESTful HTTP API
Table API
Supported programming languagesAll languages supporting JDBC/ODBCGoC
Java
Perl
Python
R
C
C#
C++
Cobol
Delphi
Fortran
Go
Java
JavaScript (Node.js)
Perl
PHP
Python
R
Ruby
Scala
Visual Basic
.Net
C#
Java
JavaScript
JavaScript (Node.js)
MongoDB client drivers written for various programming languages
Python
Server-side scripts infoStored proceduresyes infouser defined functions and integration of map-reducenoyesyesJavaScript
TriggersnonoyesnoJavaScript
Partitioning methods infoMethods for storing different data on different nodesShardingnoneShardingShardingSharding infoImplicit feature of the cloud service
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factornoneSource-replica replicationActive-active shard replicationyes infoImplicit feature of the cloud service
MapReduce infoOffers an API for user-defined Map/Reduce methodsyes infoquery execution via MapReducenoyesnowith Hadoop integration infoIntegration with Hadoop/HDInsight on Azure*
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual ConsistencynoneImmediate ConsistencyEventual ConsistencyBounded Staleness
Consistent Prefix
Eventual Consistency
Immediate Consistency infoConsistency level configurable on request level
Session Consistency
Foreign keys infoReferential integritynonoyesnono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoyesACIDnoMulti-item ACID transactions with snapshot isolation within a partition
Concurrency infoSupport for concurrent manipulation of datayesyesyesNo - written data is immutableyes
Durability infoSupport for making data persistentyesyesyesYes - Synchronous writes to local disk combined with replication and asynchronous writes in parquet format to permanent shared storageyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nononoyes
User concepts infoAccess controlAccess rights for users, groups and roles infobased on Apache Sentry and Kerberosnofine grained access rights according to SQL-standardfine grained access rights according to SQL-standardAccess rights can be defined down to the item level

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 partiesCData: Connect to Big Data & NoSQL through standard Drivers.
» more

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

More resources
Apache ImpalaBoltDBGreenplumIBM Db2 Event StoreMicrosoft Azure Cosmos DB infoformer name was Azure DocumentDB
Recent citations in the news

Apache Impala becomes Top-Level Project
28 November 2017, SDTimes.com

Apache Impala 4 Supports Operator Multi-Threading
29 July 2021, iProgrammer

Hudi: Uber Engineering’s Incremental Processing Framework on Apache Hadoop
12 March 2017, Uber

Updates & Upserts in Hadoop Ecosystem with Apache Kudu
27 October 2017, KDnuggets

StarRocks Brings Speedy OLAP Database to the Cloud
14 July 2022, Datanami

provided by Google News

What I learnt from building 3 high traffic web applications on an embedded key value store.
21 February 2018, hackernoon.com

4 Instructive Postmortems on Data Downtime and Loss
1 March 2024, The Hacker News

Roblox’s cloud-native catastrophe: A post mortem
31 January 2022, InfoWorld

How to Put a GUI on Ansible, Using Semaphore
22 April 2023, The New Stack

Grafana Loki: Architecture Summary and Running in Kubernetes
14 March 2023, hackernoon.com

provided by Google News

Chapter 1. Introducing the Greenplum Database
6 December 2018, O'Reilly Media

VMware Greenplum on AWS: Parallel Postgres for Enterprise Analytics at Scale
9 September 2019, AWS Blog

Greenplum 6 ventures outside the analytic box
19 March 2019, ZDNet

RSA: EMC integrates Hadoop with Greenplum database
26 February 2013, DatacenterDynamics

EMC Introduces Breakthrough 'Big Data' Computing System
13 October 2010, PR Newswire

provided by Google News

Mudhakar Srivatsa
11 December 2023, IBM Research

Best cloud databases of 2022
4 October 2022, ITPro

Why a robust data management strategy is essential today | IBM HDM
19 September 2019, Express Computer

How IBM Is Turning Db2 into an ‘AI Database’
3 June 2019, Datanami

provided by Google News

Start your AI journey with Microsoft Azure Cosmos DB—compete for $10K
9 May 2024, azure.microsoft.com

Public Preview: DiskANN vector indexing and search in Azure Cosmos DB NoSQL
21 May 2024, azure.microsoft.com

Public preview: Filtered vector search in vCore-based Azure Cosmos DB for MongoDB
24 April 2024, azure.microsoft.com

Public Preview: vCore-based Azure Cosmos DB for MongoDB cross-region disaster recovery (DR)
21 May 2024, azure.microsoft.com

General availability: Azure Cosmos DB for PostgreSQL geo-redundant backup and restore
24 April 2024, azure.microsoft.com

provided by Google News



Share this page

Featured Products

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB for 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

Milvus logo

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

Neo4j logo

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

SingleStore logo

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

Present your product here