DB-EnginesExtremeDB for everyone with an RTOSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Amazon Redshift vs. Apache Impala vs. MongoDB vs. RethinkDB vs. Tibero

System Properties Comparison Amazon Redshift vs. Apache Impala vs. MongoDB vs. RethinkDB vs. Tibero

Editorial information provided by DB-Engines
NameAmazon Redshift  Xexclude from comparisonApache Impala  Xexclude from comparisonMongoDB  Xexclude from comparisonRethinkDB  Xexclude from comparisonTibero  Xexclude from comparison
DescriptionLarge scale data warehouse service for use with business intelligence toolsAnalytic DBMS for HadoopOne of the most popular document stores available both as a fully managed cloud service and for deployment on self-managed infrastructureDBMS for the Web with a mechanism to push updated query results to applications in realtime.A secure RDBMS, designed for easy portability from Oracle
Primary database modelRelational DBMSRelational DBMSDocument storeDocument storeRelational DBMS
Secondary database modelsDocument storeSpatial DBMS
Search engine infointegrated Lucene index, currently in MongoDB Atlas only.
Time Series DBMS infoTime Series Collections introduced in Release 5.0
Vector DBMS infocurrently available in the MongoDB Atlas cloud service only
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score17.94
Rank#34  Overall
#21  Relational DBMS
Score13.77
Rank#40  Overall
#24  Relational DBMS
Score421.65
Rank#5  Overall
#1  Document stores
Score2.74
Rank#105  Overall
#19  Document stores
Score1.78
Rank#140  Overall
#64  Relational DBMS
Websiteaws.amazon.com/­redshiftimpala.apache.orgwww.mongodb.comrethinkdb.comus.tmaxsoft.com/­products/­tibero
Technical documentationdocs.aws.amazon.com/­redshiftimpala.apache.org/­impala-docs.htmlwww.mongodb.com/­docs/­manualrethinkdb.com/­docstechnet.tmaxsoft.com/­upload/­download/­online/­tibero/­pver-20150504-000002/­index.html
DeveloperAmazon (based on PostgreSQL)Apache Software Foundation infoApache top-level project, originally developed by ClouderaMongoDB, IncThe Linux Foundation infosince July 2017TmaxSoft
Initial release20122013200920092003
Current release4.1.0, June 20226.0.7, June 20232.4.1, August 20206, April 2015
License infoCommercial or Open SourcecommercialOpen Source infoApache Version 2Open Source infoMongoDB Inc.'s Server Side Public License v1. Prior versions were published under GNU AGPL v3.0. Commercial licenses are also available.Open Source infoApache Version 2commercial
Cloud-based only infoOnly available as a cloud serviceyesnono infoMongoDB available as DBaaS (MongoDB Atlas)nono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
  • MongoDB Flex @ STACKIT offers managed MongoDB Instances with adjustable CPU, RAM, storage amount and speed, in enterprise grade to perfectly match all application requirements. All services are 100% GDPR-compliant.
  • MongoDB Atlas: Global multi-cloud database with unmatched data distribution and mobility across AWS, Azure, and Google Cloud, built-in automation for resource and workload optimization, and so much more.
Implementation languageCC++C++C++C and Assembler
Server operating systemshostedLinuxLinux
OS X
Solaris
Windows
Linux
OS X
Windows
AIX
HP-UX
Linux
Solaris
Windows
Data schemeyesyesschema-free infoAlthough 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.schema-freeyes
Typing infopredefined data types such as float or dateyesyesyes infostring, integer, double, decimal, boolean, date, object_id, geospatialyes infostring, binary, float, bool, date, geometryyes
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.nononoyes
Secondary indexesrestrictedyesyesyesyes
SQL infoSupport of SQLyes infodoes not fully support an SQL-standardSQL-like DML and DDL statementsRead-only SQL queries via the MongoDB Atlas SQL Interfacenoyes
APIs and other access methodsJDBC
ODBC
JDBC
ODBC
GraphQL
HTTP REST
Prisma
proprietary protocol using JSON
JDBC
ODBC
ODP.NET
Oracle Call Interface (OCI)
Tibero CLI
Supported programming languagesAll languages supporting JDBC/ODBCAll languages supporting JDBC/ODBCActionscript infounofficial driver
C
C#
C++
Clojure infounofficial driver
ColdFusion infounofficial driver
D infounofficial driver
Dart infounofficial driver
Delphi infounofficial driver
Erlang
Go
Groovy infounofficial driver
Haskell
Java
JavaScript
Kotlin
Lisp infounofficial driver
Lua infounofficial driver
MatLab infounofficial driver
Perl
PHP
PowerShell infounofficial driver
Prolog infounofficial driver
Python
R infounofficial driver
Ruby
Rust
Scala
Smalltalk infounofficial driver
Swift
C infocommunity-supported driver
C# infocommunity-supported driver
C++ infocommunity-supported driver
Clojure infocommunity-supported driver
Dart infocommunity-supported driver
Erlang infocommunity-supported driver
Go infocommunity-supported driver
Haskell infocommunity-supported driver
Java infoofficial driver
JavaScript (Node.js) infoofficial driver
Lisp infocommunity-supported driver
Lua infocommunity-supported driver
Objective-C infocommunity-supported driver
Perl infocommunity-supported driver
PHP infocommunity-supported driver
Python infoofficial driver
Ruby infoofficial driver
Scala infocommunity-supported driver
C
C#
C++
Cobol
Java
Objective-C
Perl
PHP
Python
Ruby
Visual Basic
Server-side scripts infoStored proceduresuser defined functions infoin Pythonyes infouser defined functions and integration of map-reduceJavaScriptPersistent Stored Procedure (PSM)
Triggersnonoyes infoin MongoDB Atlas onlyClient-side triggers through changefeedsyes
Partitioning methods infoMethods for storing different data on different nodesShardingShardingSharding infoPartitioned by hashed, ranged, or zoned sharding keys. Live resharding allows users to change their shard keys as an online operation with zero downtime.Sharding inforange basedhorizontal partitioning infoby range, hash, list or composite
Replication methods infoMethods for redundantly storing data on multiple nodesyesselectable replication factorMulti-Source deployments with MongoDB Atlas Global Clusters
Source-replica replication
Source-replica replicationMulti-source replication
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyes infoquery execution via MapReduceyesyesno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual ConsistencyEventual Consistency infocan be individually decided for each read operation
Immediate Consistency infodefault behaviour
Immediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyes infoinformational only, not enforced by the systemnono infotypically not used, however similar functionality with DBRef possiblenoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnoMulti-document ACID Transactions with snapshot isolationAtomic single-document operationsACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes infoMVCC basedyes
Durability infoSupport for making data persistentyesyesyes infooptional, enabled by defaultyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesnoyes infoIn-memory storage engine introduced with MongoDB version 3.2nono infoplanned for next version
User concepts infoAccess controlfine grained access rights according to SQL-standardAccess rights for users, groups and roles infobased on Apache Sentry and KerberosAccess rights for users and rolesyes infousers and table-level permissionsfine grained access rights according to SQL-standard (SQL 92, SQL 99)
More information provided by the system vendor
Amazon RedshiftApache ImpalaMongoDBRethinkDBTibero
Specific characteristicsMongoDB provides an integrated suite of cloud database and data services to accelerate...
» more
Competitive advantagesBuilt around the flexible document data model and unified API, MongoDB is a developer...
» more
Typical application scenariosAI-enriched intelligent apps (Continental, Telefonica, Iron Mountain) Internet of...
» more
Key customersADP, Adobe, Amadeus, AstraZeneca, Auto Trader, Barclays, BBVA, Bosch, Cisco, CERN,...
» more
Market metricsHundreds of millions downloads, over 150,000+ Atlas clusters provisioned every month...
» more
Licensing and pricing modelsMongoDB database server: Server-Side Public License (SSPL) . Commercial licenses...
» more

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

Navicat for MongoDB gives you a highly effective GUI interface for MongoDB database management, administration and development.
» more

Studio 3T: The world's favorite IDE for working with MongoDB
» more

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

More resources
Amazon RedshiftApache ImpalaMongoDBRethinkDBTibero
DB-Engines blog posts

Cloud-based DBMS's popularity grows at high rates
12 December 2019, Paul Andlinger

The popularity of cloud-based DBMSs has increased tenfold in four years
7 February 2017, Matthias Gelbmann

Increased popularity for consuming DBMS services out of the cloud
2 October 2015, Paul Andlinger

show all

Snowflake is the DBMS of the Year 2021
3 January 2022, Paul Andlinger, Matthias Gelbmann

PostgreSQL is the DBMS of the Year 2020
4 January 2021, Paul Andlinger, Matthias Gelbmann

PostgreSQL is the DBMS of the Year 2018
2 January 2019, Paul Andlinger, Matthias Gelbmann

show all

Meet some database management systems you are likely to hear more about in the future
4 August 2014, Paul Andlinger

show all

Recent citations in the news

Databricks vs. Redshift: Data Platform Comparison
22 May 2024, eWeek

Amazon Redshift adds new AI capabilities, including Amazon Q, to boost efficiency and productivity | Amazon Web ...
29 November 2023, AWS Blog

Achieve peak performance and boost scalability using multiple Amazon Redshift serverless workgroups and Network ...
9 May 2024, AWS Blog

Breaking barriers in geospatial: Amazon Redshift, CARTO, and H3 | Amazon Web Services
16 May 2024, AWS Blog

Revolutionizing data querying: Amazon Redshift and Visual Studio Code integration | Amazon Web Services
2 May 2024, AWS Blog

provided by Google News

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

Cloudera Bringing Impala to AWS Cloud
28 November 2017, Datanami

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

Apache Doris just 'graduated': Why care about this SQL data warehouse
24 June 2022, InfoWorld

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

provided by Google News

MongoDB Furthers Commitment to Security and Compliance with New Industry Certifications
23 May 2024, PR Newswire

Loss-Making MongoDB, Inc. (NASDAQ:MDB) Expected To Breakeven In The Medium-Term
23 May 2024, Yahoo Finance

Top MongoDB Interview Questions and Answers
21 May 2024, Simplilearn

MongoDB (MDB) to Release Quarterly Earnings on Thursday
23 May 2024, Defense World

MongoDB Stock Sinks As Market Gains: Here's Why
21 May 2024, Markets Insider

provided by Google News

MongoDB: The Popular Database for IoT
15 August 2023, Open Source For You

Stripe acquires team behind NoSQL database startup RethinkDB
5 October 2016, VentureBeat

Realtime App Development with RethinkDB and React Native — SitePoint
17 June 2016, SitePoint

RethinkDB is dead, and MongoDB isn't what killed it
24 January 2017, TechRepublic

How to deploy RethinkDB using Docker
14 February 2018, Packt Hub

provided by Google News

ArkData to Officially Support Domestic Database 'Tibero 7'
23 April 2024, BusinessKorea

How to Succeed at Large-Scale Mainframe Replatforming with TmaxSoft OpenFrame on AWS | Amazon Web Services
2 August 2022, AWS Blog

TmaxSoft database system wins Russia award
15 February 2016, 코리아타임스

ArkData's 'Ark for CDC' supports real-time data extraction and replication for Tibero DBMS.
18 April 2023, BusinessKorea

Daegu Government Integrated Data Center to Propose Open-Source Database Management Systems for Tenant ...
14 April 2021, Etnews

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

Neo4j logo

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

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

RaimaDB logo

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

Present your product here