DBMS > HBase vs. MongoDB vs. MySQL vs. Oracle vs. Redis
System Properties Comparison HBase vs. MongoDB vs. MySQL vs. Oracle vs. Redis
| Editorial information provided by DB-Engines | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Name | HBase Xexclude from comparison | MongoDB Xexclude from comparison | MySQL Xexclude from comparison | Oracle Xexclude from comparison | Redis Xexclude from comparison | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Description | Wide-column store based on Apache Hadoop and on concepts of BigTable | One of the most popular document stores available both as a fully managed cloud service and for deployment on self-managed infrastructure | Widely used open source RDBMS | Widely used RDBMS | In-memory data structure store, used as database, cache and message broker  Redis focuses on performance so most of its design decisions prioritize high performance and very low latencies. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Primary database model | Wide column store | Document store | Relational DBMS Key/Value like access via memcached API | Relational DBMS | Key-value store Multiple data types and a rich set of operations, as well as configurable data expiration, eviction and persistence | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Secondary database models | Spatial DBMS Search engine integrated Lucene index, currently in MongoDB Atlas only. | Document store Spatial DBMS | Document store Graph DBMS with Oracle Spatial and GraphRDF store with Oracle Spatial and GraphSpatial DBMS with Oracle Spatial and Graph | Document store with Redis Modules Graph DBMS with Redis ModulesSpatial DBMS Search engine with Redis ModulesTime Series DBMS with Redis Modules | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
|
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Website | hbase.apache.org | www.mongodb.com | www.mysql.com | www.oracle.com/database | redis.io | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Technical documentation | hbase.apache.org | docs.mongodb.com/manual | dev.mysql.com/doc | docs.oracle.com/en/database | redis.io/documentation | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Developer | Apache Software Foundation Apache top-level project, originally developed by Powerset | MongoDB, Inc | Oracle since 2010, originally MySQL AB, then Sun | Oracle | Salvatore Sanfilippo Development sponsored by Redis Labs | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Initial release | 2008 | 2009 | 1995 | 1980 | 2009 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Current release | 2.3.4, January 2021 | 4.4.5, April 2021 | 8.0.23 , January 2021 | 19c, February 2019 | 6.2.1 , March 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| License Commercial or Open Source | Open Source Apache version 2 | Open Source MongoDB Inc.'s Server Side Public License v1. Prior versions were published under GNU AGPL v3.0. Commercial licenses are also available. | Open Source GPL version 2. Commercial licenses with extended functionallity are available | commercial restricted free version is available | Open Source BSD 3-Clause, commercial license available | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Cloud-based only Only available as a cloud service | no | no MongoDB available as DBaaS (MongoDB Atlas) | no | no | no | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 language | Java | C++ | C and C++ | C and C++ | C | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Server operating systems | Linux Unix Windows using Cygwin | Linux OS X Solaris Windows | FreeBSD Linux OS X Solaris Windows | AIX HP-UX Linux OS X Solaris Windows z/OS | BSD Linux OS X Windows ported and maintained by Microsoft Open Technologies, Inc. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Data scheme | schema-free, schema definition possible | schema-free Although schema-free, documents of the same collection often follow the same structure. Optionally impose all or part of a schema by defining a JSON schema. | yes | yes Schemaless in JSON and XML columns | schema-free | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Typing predefined data types such as float or date | options to bring your own types, AVRO | yes string, integer, double, decimal, boolean, date, object_id, geospatial | yes | yes | partial Supported data types are strings, hashes, lists, sets and sorted sets, bit arrays, hyperloglogs and geospatial indexes | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT. | no | yes | yes | no | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Secondary indexes | no | yes | yes | yes | yes with RediSearch module | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| SQL Support of SQL | no | Read-only SQL queries via the MongoDB Connector for BI | yes with proprietary extensions | yes with proprietary extensions | no | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| APIs and other access methods | Java API RESTful HTTP API Thrift | proprietary protocol using JSON | ADO.NET JDBC ODBC Proprietary native API | JDBC ODBC ODP.NET Oracle Call Interface (OCI) | proprietary protocol RESP - REdis Serialization Protocol | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Supported programming languages | C C# C++ Groovy Java PHP Python Scala | Actionscript unofficial driver C C# C++ Clojure unofficial driverColdFusion unofficial driverD unofficial driverDart unofficial driverDelphi unofficial driverErlang Go Groovy unofficial driverHaskell Java JavaScript Lisp unofficial driverLua unofficial driverMatLab unofficial driverPerl PHP PowerShell unofficial driverProlog unofficial driverPython R unofficial driverRuby Rust Scala Smalltalk unofficial driverSwift | Ada C C# C++ D Delphi Eiffel Erlang Haskell Java JavaScript (Node.js) Objective-C OCaml Perl PHP Python Ruby Scheme Tcl | C C# C++ Clojure Cobol Delphi Eiffel Erlang Fortran Groovy Haskell Java JavaScript Lisp Objective C OCaml Perl PHP Python R Ruby Scala Tcl Visual Basic | C C# C++ Clojure Crystal D Dart Elixir Erlang Fancy Go Haskell Haxe Java JavaScript (Node.js) Lisp Lua MatLab Objective-C OCaml Pascal Perl PHP Prolog Pure Data Python R Rebol Ruby Rust Scala Scheme Smalltalk Swift Tcl Visual Basic | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Server-side scripts Stored procedures | yes Coprocessors in Java | JavaScript | yes proprietary syntax | PL/SQL also stored procedures in Java possible | Lua | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Triggers | yes | yes in MongoDB Atlas only | yes | yes | no publish/subscribe channels provide limited trigger functionality | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Partitioning methods Methods for storing different data on different nodes | Sharding | Sharding partitioned by hashed, ranged, or zoned sharding keys | horizontal partitioning, sharding with MySQL Cluster or MySQL Fabric | Sharding, horizontal partitioning | Sharding | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Replication methods Methods for redundantly storing data on multiple nodes | Multi-source replication Source-replica replication | Multi-Source deployments with MongoDB Atlas Global Clusters Source-replica replication | Multi-source replication Source-replica replication | Multi-source replication Source-replica replication | Multi-source replication with Redis Enterprise Pack Source-replica replication Chained replication is supported | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| MapReduce Offers an API for user-defined Map/Reduce methods | yes | yes | no | no can be realized in PL/SQL | no | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Consistency concepts Methods to ensure consistency in a distributed system | Immediate Consistency or Eventual Consistency | Eventual Consistency Immediate Consistency can be individually decided for each write operation | Immediate Consistency | Immediate Consistency | Eventual Consistency Strong eventual consistency with CRDTs | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Foreign keys Referential integrity | no | no typically not used, however similar functionality with DBRef possible | yes not for MyISAM storage engine | yes | no | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Transaction concepts Support to ensure data integrity after non-atomic manipulations of data | Single row ACID (across millions of columns) | Multi-document ACID Transactions with snapshot isolation | ACID not for MyISAM storage engine | ACID isolation level can be parameterized | Optimistic locking, atomic execution of commands blocks and scripts | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Concurrency Support for concurrent manipulation of data | yes | yes | yes table locks or row locks depending on storage engine | yes | yes Data access is serialized by the server | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Durability Support for making data persistent | yes | yes optional | yes | yes | yes Configurable mechanisms for persistency via snapshots and/or operations logs | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| In-memory capabilities Is there an option to define some or all structures to be held in-memory only. | yes | yes In-memory storage engine introduced with MongoDB version 3.2 | yes | yes Version 12c introduced the new option 'Oracle Database In-Memory' | yes | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| User concepts Access control | Access Control Lists (ACL) for RBAC, integration with Apache Ranger for RBAC & ABAC | Access rights for users and roles | Users with fine-grained authorization concept no user groups or roles | fine grained access rights according to SQL-standard | Simple password-based access control Access control lists and SSL are available in the commercial version | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| More information provided by the system vendor | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| HBase | MongoDB | MySQL | Oracle | Redis | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Specific characteristics | Apache HBase is the leading NoSQL, distributed database management system, well suited... » more | MongoDB is the leading modern, general purpose data platform, designed to unleash... » more | Redis, benchmarked as the world's fastest database, reduces application complexity,... » more | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Competitive advantages | No single point of failure ensures very high availability with multiple customers... » more | The MongoDB platform can be used by developers building transactional, operational,... » more | Redis is an in-memory database platform offering native support of wide range of... » more | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Typical application scenarios | Internet of Things (IOT), fraud detection applications, recommendation engines, product... » more | Internet of Things and Time Series (Bosch, Jaguar Land Rover) Mobile (The Weather... » more | Redis powers personalization, real-time fraud detection, IoT, e-commerce, real-time... » more | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Key customers | Apple, Salesforce, Cerner, Allegis Group, Bloomberg, Airtel, Thomson Reuters, Dish,... » more | ADP, Adobe, Amadeus, AstraZeneca, Auto Trader, Barclays, BBVA, Bosch, Cisco, CERN,... » more | Verizon, Vodafone, Atlassian, Trip Advisor, Jet.com, Nokia, Samsung, HTC, Docker,... » more | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Market metrics | #1 largest NoSQL database by revenue » more | 125 million downloads (growing at more than 30 thousand downloads per day), over... » more | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Licensing and pricing models | Apache license P ricing for commercial distribution provided by Cloudera and available... » more | MongoDB database server: Server-Side Public License (SSPL) . Commercial licenses... » more | The licensing model is subscription based. Redis Enterprise Cloud is priced according... » more | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
We invite representatives of system vendors to contact us for updating and extending the system information, | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Related products and services | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 3rd parties | Navicat for MongoDB gives you a highly effective GUI interface for MongoDB database management, administration and development. » more ClusterControl: the only management system you’ll ever need to take control of your open source database infrastructure. » more CData: Connect to Big Data & NoSQL through standard Drivers. » more Datadog: Visualize all your MongoDB metrics. » more Studio 3T: The world's favorite IDE for working with MongoDB » more Fivetran: Quickly and easily centralize your on-premise and cloud databases. » more | CData: Connect to Big Data & NoSQL through standard Drivers. » more Navicat for MySQL is the ideal solution for MySQL/MariaDB administration and development. » more Fivetran: Quickly and easily centralize your on-premise and cloud databases. » more ClusterControl: the only management system you’ll ever need to take control of your open source database infrastructure. » 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 | General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products. » more Fivetran: Quickly and easily centralize your on-premise and cloud databases. » more Navicat for Oracle improves the efficiency and productivity of Oracle developers and administrators with a streamlined working environment. » more | CData: Connect to Big Data & NoSQL through standard Drivers. » more Redis Enterprise Cloud: Try with 400$ usage credit. » more Redisson PRO: The ultra-fast Redis Java Client. » more Datadog: Monitor all Redis metrics: hit rates, clients, commands per second, and more. » more | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
We invite representatives of vendors of related products to contact us for presenting information about their offerings here. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| More resources | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| HBase | MongoDB | MySQL | Oracle | Redis | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| DB-Engines blog posts | Why is Hadoop not listed in the DB-Engines Ranking? | PostgreSQL is the DBMS of the Year 2020 PostgreSQL is the DBMS of the Year 2018 PostgreSQL moves up one rank at the expense of MongoDB | MySQL is the DBMS of the Year 2019 MariaDB strengthens its position in the open source RDBMS market The struggle for the hegemony in Oracle's database empire | MySQL is the DBMS of the Year 2019 The struggle for the hegemony in Oracle's database empire Architecting eCommerce Platforms for Zero Downtime on Black Friday and Beyond | PostgreSQL is the DBMS of the Year 2018 MySQL, PostgreSQL and Redis are the winners of the March ranking MongoDB is the DBMS of the year, defending the title from last year An Introduction to MongoDB Query API Key-Value Stores Market SWOT Analysis, Outlook, By Top Key Players: Redis, Azure Redis Cache, ArangoDB, Hbase, Google Cloud Datastore etc. The Apache Software Foundation Announces the 10th Anniversary of Apache® HBase™ Global Key-Value Stores Market 2021: Redis, Azure Redis Cache, ArangoDB, Hbase, Google Cloud Datastore, Aerospike, BoltDB, Couchbase, Memcached, Oracle, DataStax, Infinispan etc Global Key-Value Stores Market Report Provide Analysis about Participants to Improve Their Business Tactics & Ensure Their Long-Term Success Cloudera adds operational database to cloud service provided by Google News How to install the NoSQL database server MongoDB on Linux MongoDB, Inc. (NASDAQ:MDB) Receives Average Rating of "Buy" from Analysts Should You Buy Mongodb Inc (MDB) Stock on Monday? Why MongoDB Stock Is Climbing Today MongoDB - Consensus Indicates Potential 20.8% Upside provided by Google News Rockset Enables Real-Time Analytics for MySQL and PostgreSQL Google Cloud Migration Service for MySQL and PostgreSQL is Now GA Massive Growth of Open-Source Database Software Market by 2027 | SQLite, MySQL, MariaDB, Apache Hive – SoccerNurds Open-Source Database Software Market 2021 – 2025: SQLite, MySQL, MariaDB, Apache Hive, Neo4j – KSU | The Sentinel Newspaper Global NoSQL Market 2025: Microsoft SQL Server, MySQL, MongoDB, PostgreSQL, Oracle Database, MongoLab, MarkLogic, Couchbase, CloudDB, DynamoDB, Basho Technologies, Aerospike, IBM, Neo, Hypertable, Cisco, Objectivity provided by Google News Factory for the cloud: Oracle outlines key differences with database competitors Google will stop using Oracle's finance software and adopt SAP instead Cloud Vendors Confront 'Highest Risk' Projects: Database Migration Oracle Is Shifting to the Cloud. It Won't Be Quick, Analyst Says. Oracle brings Autonomous Data Warehouse to the rest of us provided by Google News Redis demonstrates the power of real-time data at RedisConf 2021 Database Developer Redis Labs Snags $110M In Late-Stage Funding Round $2 Billion Redis Labs CEO Says It's Aiming for an IPO Within a Year Global Key Value Database Market 2021 Future Trend | The Apache Software Foundation, Redis Labs, Aerospike, Couchbase, Amazon Web Services (AWS – KSU | The Sentinel Newspaper Redis Labs raises $110 million provided by Google News Lead Administrator Sr. Technical Lead VP Engineering Senior DevSecOps - Data PostgreSQL DBA Looking for an entry-level or graduate job? MongoDB Jr. QA Analyst Trainee Software Engineer Mongo DBA Traders Software Developer – Entry Level Loss Prevention Manager Accelerator Operator Loss Prevention Specialist Oracle Database 12c Subject Matter Experts - REMOTE Database Administrator III Data Analyst - Apprenticeship - Central AR Payroll Specialist Database Administrator Database Administrator Backend Engineer (Node.js) Redis Database Administrator | Remote Jr. SQL Developer DevOps Engineer | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Share this page
