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

DBMS > Apache Impala vs. Microsoft Azure Data Explorer vs. MySQL vs. Oracle Berkeley DB

System Properties Comparison Apache Impala vs. Microsoft Azure Data Explorer vs. MySQL vs. Oracle Berkeley DB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameApache Impala  Xexclude from comparisonMicrosoft Azure Data Explorer  Xexclude from comparisonMySQL  Xexclude from comparisonOracle Berkeley DB  Xexclude from comparison
DescriptionAnalytic DBMS for HadoopFully managed big data interactive analytics platformWidely used open source RDBMSWidely used in-process key-value store
Primary database modelRelational DBMSRelational DBMS infocolumn orientedRelational DBMS infoKey/Value like access via memcached APIKey-value store infosupports sorted and unsorted key sets
Native XML DBMS infoin the Oracle Berkeley DB XML version
Secondary database modelsDocument storeDocument store infoIf a column is of type dynamic docs.microsoft.com/­en-us/­azure/­kusto/­query/­scalar-data-types/­dynamic then it's possible to add arbitrary JSON documents in this cell
Event Store infothis is the general usage pattern at Microsoft. Billing, Logs, Telemetry events are stored in ADX and the state of an individual entity is defined by the arg_max(timestamps)
Spatial DBMS
Search engine infosupport for complex search expressions docs.microsoft.com/­en-us/­azure/­kusto/­query/­parseoperator FTS, Geospatial docs.microsoft.com/­en-us/­azure/­kusto/­query/­geo-point-to-geohash-function distributed search -> ADX acts as a distributed search engine
Time Series DBMS infosee docs.microsoft.com/­en-us/­azure/­data-explorer/­time-series-analysis
Document store
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score10.08
Rank#41  Overall
#25  Relational DBMS
Score3.12
Rank#85  Overall
#46  Relational DBMS
Score1022.76
Rank#2  Overall
#2  Relational DBMS
Score1.86
Rank#127  Overall
#21  Key-value stores
#3  Native XML DBMS
Websiteimpala.apache.orgazure.microsoft.com/­services/­data-explorerwww.mysql.comwww.oracle.com/­database/­technologies/­related/­berkeleydb.html
Technical documentationimpala.apache.org/­impala-docs.htmldocs.microsoft.com/­en-us/­azure/­data-explorerdev.mysql.com/­docdocs.oracle.com/­cd/­E17076_05/­html/­index.html
DeveloperApache Software Foundation infoApache top-level project, originally developed by ClouderaMicrosoftOracle infosince 2010, originally MySQL AB, then SunOracle infooriginally developed by Sleepycat, which was acquired by Oracle
Initial release2013201919951994
Current release4.1.0, June 2022cloud service with continuous releases9.0.0, July 202418.1.40, May 2020
License infoCommercial or Open SourceOpen Source infoApache Version 2commercialOpen Source infoGPL version 2. Commercial licenses with extended functionallity are availableOpen Source infocommercial license available
Cloud-based only infoOnly available as a cloud servicenoyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++C and C++C, Java, C++ (depending on the Berkeley DB edition)
Server operating systemsLinuxhostedFreeBSD
Linux
OS X
Solaris
Windows
AIX
Android
FreeBSD
iOS
Linux
OS X
Solaris
VxWorks
Windows
Data schemeyesFixed schema with schema-less datatypes (dynamic)yesschema-free
Typing infopredefined data types such as float or dateyesyes infobool, datetime, dynamic, guid, int, long, real, string, timespan, double: docs.microsoft.com/­en-us/­azure/­kusto/­query/­scalar-data-typesyesno
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.noyesyesyes infoonly with the Berkeley DB XML edition
Secondary indexesyesall fields are automatically indexedyesyes
SQL infoSupport of SQLSQL-like DML and DDL statementsKusto Query Language (KQL), SQL subsetyes infowith proprietary extensionsyes infoSQL interfaced based on SQLite is available
APIs and other access methodsJDBC
ODBC
Microsoft SQL Server communication protocol (MS-TDS)
RESTful HTTP API
ADO.NET
JDBC
ODBC
Proprietary native API
Supported programming languagesAll languages supporting JDBC/ODBC.Net
Go
Java
JavaScript (Node.js)
PowerShell
Python
R
Ada
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
.Net infoFigaro is a .Net framework assembly that extends Berkeley DB XML into an embeddable database engine for .NET
others infoThird-party libraries to manipulate Berkeley DB files are available for many languages
C
C#
C++
Java
JavaScript (Node.js) info3rd party binding
Perl
Python
Tcl
Server-side scripts infoStored proceduresyes infouser defined functions and integration of map-reduceYes, possible languages: KQL, Python, Ryes infoproprietary syntaxno
Triggersnoyes infosee docs.microsoft.com/­en-us/­azure/­kusto/­management/­updatepolicyyesyes infoonly for the SQL API
Partitioning methods infoMethods for storing different data on different nodesShardingSharding infoImplicit feature of the cloud servicehorizontal partitioning, sharding with MySQL Cluster or MySQL Fabricnone
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factoryes infoImplicit feature of the cloud service. Replication either local, cross-facility or geo-redundant.Multi-source replication
Source-replica replication
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsyes infoquery execution via MapReduceSpark connector (open source): github.com/­Azure/­azure-kusto-sparknono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual ConsistencyEventual Consistency
Immediate Consistency
Immediate Consistency
Foreign keys infoReferential integritynonoyes infonot for MyISAM storage engineno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanonoACID infonot for MyISAM storage engineACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes infotable locks or row locks depending on storage engine
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nonoyesyes
User concepts infoAccess controlAccess rights for users, groups and roles infobased on Apache Sentry and KerberosAzure Active Directory AuthenticationUsers with fine-grained authorization concept infono user groups or rolesno

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 ImpalaMicrosoft Azure Data ExplorerMySQLOracle Berkeley DB
DB-Engines blog posts

MySQL is the DBMS of the Year 2019
3 January 2020, Matthias Gelbmann, Paul Andlinger

MariaDB strengthens its position in the open source RDBMS market
5 April 2018, Matthias Gelbmann

The struggle for the hegemony in Oracle's database empire
2 May 2017, 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

We’re retiring Azure Time Series Insights on 7 July 2024 – transition to Azure Data Explorer
31 May 2024, azure.microsoft.com

Update records in a Kusto Database (public preview)
20 February 2024, azure.microsoft.com

Microsoft is closing down another Azure-based feature in the near future
22 July 2024, Neowin

Announcing General Availability of Graph Semantics in Kusto
27 May 2024, azure.microsoft.com

Announcing General Availability to migrate Virtual Network injected Azure Data Explorer Cluster to Private Endpoints
5 February 2024, azure.microsoft.com

provided by Google News

Upgrading Uber’s MySQL Fleet to version 8.0
8 August 2024, Uber

OpenID Connect (Oauth2 - JWT) Authentication Support in MySQL
22 October 2024, blogs.oracle.com

Older PHP & MySQL no longer working in Later Versions
15 May 2024, SitePoint

How to get started with MySQL
31 July 2024, InfoWorld

Amazon RDS for MySQL zero-ETL integration with Amazon Redshift, now generally available, enables near real-time analytics
12 September 2024, AWS Blog

provided by Google News

What is NoSQL (Not Only SQL database)?
28 February 2022, TechTarget

Margo I. Seltzer
18 August 2020, Berkman Klein Center

A complete beginners guide to installing a Bitcoin Full Node on Linux (2018 Edition)
3 May 2018, hackernoon.com

Which Are the Top Local Databases for React Native
15 October 2019, Appinventiv

Oracle buys Sleepycat Software
14 February 2006, MarketWatch

provided by Google News



Share this page

Featured Products

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

SingleStore logo

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

RaimaDB logo

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

Neo4j logo

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

Present your product here