DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Drizzle vs. Hive vs. IBM Db2 Event Store

System Properties Comparison Drizzle vs. Hive vs. IBM Db2 Event Store

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameDrizzle  Xexclude from comparisonHive  Xexclude from comparisonIBM Db2 Event Store  Xexclude from comparison
Drizzle has published its last release in September 2012. The open-source project is discontinued and Drizzle is excluded from the DB-Engines ranking.
DescriptionMySQL fork with a pluggable micro-kernel and with an emphasis of performance over compatibility.data warehouse software for querying and managing large distributed datasets, built on HadoopDistributed Event Store optimized for Internet of Things use cases
Primary database modelRelational DBMSRelational DBMSEvent Store
Time Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score70.91
Rank#17  Overall
#11  Relational DBMS
Score0.14
Rank#370  Overall
#3  Event Stores
#37  Time Series DBMS
Websitehive.apache.orgwww.ibm.com/­products/­db2-event-store
Technical documentationcwiki.apache.org/­confluence/­display/­Hive/­Homewww.ibm.com/­support/­knowledgecenter/­en/­SSGNPV_2.0.0/­welcome.html
DeveloperDrizzle project, originally started by Brian AkerApache Software Foundation infoinitially developed by FacebookIBM
Initial release200820122017
Current release7.2.4, September 20123.1.3, April 20222.0
License infoCommercial or Open SourceOpen Source infoGNU GPLOpen Source infoApache Version 2commercial infofree developer edition available
Cloud-based only infoOnly available as a cloud servicenonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++JavaC and C++
Server operating systemsFreeBSD
Linux
OS X
All OS with a Java VMLinux infoLinux, macOS, Windows for the developer addition
Data schemeyesyesyes
Typing infopredefined data types such as float or dateyesyesyes
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 indexesyesyesno
SQL infoSupport of SQLyes infowith proprietary extensionsSQL-like DML and DDL statementsyes infothrough the embedded Spark runtime
APIs and other access methodsJDBCJDBC
ODBC
Thrift
ADO.NET
DB2 Connect
JDBC
ODBC
RESTful HTTP API
Supported programming languagesC
C++
Java
PHP
C++
Java
PHP
Python
C
C#
C++
Cobol
Delphi
Fortran
Go
Java
JavaScript (Node.js)
Perl
PHP
Python
R
Ruby
Scala
Visual Basic
Server-side scripts infoStored proceduresnoyes infouser defined functions and integration of map-reduceyes
Triggersno infohooks for callbacks inside the server can be used.nono
Partitioning methods infoMethods for storing different data on different nodesShardingShardingSharding
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication
Source-replica replication
selectable replication factorActive-active shard replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyes infoquery execution via MapReduceno
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual ConsistencyEventual Consistency
Foreign keys infoReferential integrityyesnono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnono
Concurrency infoSupport for concurrent manipulation of datayesyesNo - written data is immutable
Durability infoSupport for making data persistentyesyesYes - Synchronous writes to local disk combined with replication and asynchronous writes in parquet format to permanent shared storage
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yes
User concepts infoAccess controlPluggable authentication mechanisms infoe.g. LDAP, HTTPAccess rights for users, groups and rolesfine 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

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

More resources
DrizzleHiveIBM Db2 Event Store
DB-Engines blog posts

MySQL won the April ranking; did its forks follow?
1 April 2015, Paul Andlinger

Has MySQL finally lost its mojo?
1 July 2013, Matthias Gelbmann

show all

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

show all

Recent citations in the news

What Is Apache Hive? (Definition, Benefits, Challenges)
19 December 2022, Built In

Iceberg Data Services Emerge from Tabular, Dremio
1 March 2023, Datanami

What Is a Data Engineer? Salary, Responsibilities, & Roadmap
7 March 2023, Unite.AI

Top 10 Data Catalogue Software Tools to Know in The Year 2023
6 March 2023, Analytics Insight

YTsaurus: Exabyte-Scale Storage and Processing System Is Now ...
20 March 2023, Medium

provided by Google News

Best cloud databases of 2022
4 October 2022, IT PRO

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

IBM Builds New Ultra-Fast Platform for Hoovering Up and Analyzing ...
31 May 2018, Data Center Knowledge

IBM Advances 'Watson Anywhere' with New Clients and Innovations ...
22 October 2019, AiThority

provided by Google News

Job opportunities

Sales Engineer
Bluesky, San Francisco Bay Area, CA

Senior Data Engineer (Remote Option*)
Nike, Beaverton, OR

Sr. Data Engineers
GSPANN Technologie, Portland, OR

Senior Data Engineer, Analytics
Standard AI, San Francisco, CA

Privacy Engineer, Big Data Privacy and Security
TikTok, Seattle, WA

jobs by Indeed



Share this page

Featured Products

Neo4j logo

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

Cassandra Forward online event

Want to level up your Cassandra game?
If you missed the event or would like to re-watch a session, replays are available now. Watch now!

Redis logo

The world’s most loved real‑time data platform.
Try 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!

Present your product here