Editorial information provided by DB-Engines
NameImpala Xexclude from comparisonMySQL Xexclude from comparisonOracle NoSQL Xexclude from comparison
DescriptionAnalytic DBMS for HadoopWidely used open source RDBMSA multi-model, scalable, distributed NoSQL database, designed to provide highly reliable, flexible, and available data management across a configurable set of storage nodes
DeveloperClouderaOracle
since 2010, originally MySQL AB, then SunOracle
Initial release201319952011
Current release3.3.0, August 20198.0.23 , January 202120.3, December 2020
LicenseCommercial or Open SourceOpen SourceApache Version 2Open SourceGPL version 2. Commercial licenses with extended functionallity are availableOpen SourceProprietary for Enterprise Edition (Oracle Database EE license has Oracle NoSQL database EE covered: details)
Cloud-based onlyOnly available as a cloud servicenonono
DBaaS offerings (sponsored links)Database as a Service
Providers of DBaaS offerings, please contact us to be listed.ScaleGrid for MySQL: Fully managed MySQL hosting on AWS, Azure and DigitalOcean with high availability and SSH access on the #1 multi-cloud DBaaS.
Implementation languageC++C and C++Java
Server operating systemsLinuxFreeBSD
Linux
OS X
Solaris
WindowsLinux
Solaris SPARC/x86
Data schemeyesyesSupport Fixed schema and Schema-less deployment with the ability to interoperate between them.
Typingpredefined data types such as float or dateyesyesoptional
XML supportSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.noyesno
Secondary indexesyesyesyes
SQLSupport of SQLSQL-like DML and DDL statementsyeswith proprietary extensionsSQL-like DML and DDL statements
APIs and other access methodsJDBC
ODBCADO.NET
JDBC
ODBC
Proprietary native APIRESTful HTTP API
Supported programming languagesAll languages supporting JDBC/ODBCAda
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
TclC
C#
Go
Java
JavaScript (Node.js)
Python
Server-side scriptsStored proceduresyesuser defined functions and integration of map-reduceyesproprietary syntaxno
Triggersnoyesno
Partitioning methodsMethods for storing different data on different nodesShardinghorizontal partitioning, sharding with MySQL Cluster or MySQL FabricSharding
Replication methodsMethods for redundantly storing data on multiple nodesselectable replication factorMulti-source replication
Source-replica replicationElectable source-replica replication per shard. Support distributed global deployment with Multi-region table feature
MapReduceOffers an API for user-defined Map/Reduce methodsyesquery execution via MapReducenowith Hadoop integration
Consistency conceptsMethods to ensure consistency in a distributed systemEventual ConsistencyImmediate ConsistencyEventual Consistency
Immediate Consistencydepending on configuration
Foreign keysReferential integritynoyesnot for MyISAM storage engineno
Transaction conceptsSupport to ensure data integrity after non-atomic manipulations of datanoACIDnot for MyISAM storage engineconfigurableACID within a storage node (=shard)
ConcurrencySupport for concurrent manipulation of datayesyestable locks or row locks depending on storage engineyes
DurabilitySupport for making data persistentyesyesyes
In-memory capabilitiesIs there an option to define some or all structures to be held in-memory only.noyesyesoff heap cache
User conceptsAccess controlAccess rights for users, groups and rolesbased on Apache Sentry and KerberosUsers with fine-grained authorization conceptno user groups or rolesAccess rights for users and roles
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
ClusterControl: the only management system you’ll ever need to take control of your open source database infrastructure.
» more
Navicat for MySQL is the ideal solution for MySQL/MariaDB administration and development.
» more
General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
» more
Datadog: Improve MySQL performance by visualizing and identifying errors fast using granular, out-of-the-box dashboards.
» more
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
More resources
ImpalaMySQLOracle NoSQL