DBMS > MongoDB vs. Oracle NoSQL vs. Snowflake
System Properties Comparison MongoDB vs. Oracle NoSQL vs. Snowflake
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||MongoDB Xexclude from comparison||Oracle NoSQL Xexclude from comparison||Snowflake Xexclude from comparison|
|Description||One of the most popular document stores available both as a fully managed cloud service and for deployment on self-managed infrastructure||A multi-model, scalable, distributed NoSQL database, designed to provide highly reliable, flexible, and available data management across a configurable set of storage nodes||Cloud-based data warehousing service for structured and semi-structured data|
|Primary database model||Document store||Document store|
|Secondary database models||Spatial DBMS|
Search engine integrated Lucene index, currently in MongoDB Atlas only.
Time Series DBMS Time Series Collections introduced in Release 5.0
|Developer||MongoDB, Inc||Oracle||Snowflake Computing Inc.|
|Current release||5.0.9, May 2022||22.1, May 2022|
|License Commercial or Open Source||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 Proprietary for Enterprise Edition (Oracle Database EE license has Oracle NoSQL database EE covered: details)||commercial|
|Cloud-based only Only available as a cloud service||no MongoDB available as DBaaS (MongoDB Atlas)||no||yes|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Server operating systems||Linux|
|Data scheme||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.||Support Fixed schema and Schema-less deployment with the ability to interoperate between them.||yes support of semi-structured data formats (JSON, XML, Avro)|
|Typing predefined data types such as float or date||yes string, integer, double, decimal, boolean, date, object_id, geospatial||optional||yes|
|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|
|SQL Support of SQL||Read-only SQL queries via the MongoDB Connector for BI||SQL-like DML and DDL statements||yes|
|APIs and other access methods||proprietary protocol using JSON||RESTful HTTP API||CLI Client|
|Supported programming languages||Actionscript unofficial driver|
Clojure unofficial driver
ColdFusion unofficial driver
D unofficial driver
Dart unofficial driver
Delphi unofficial driver
Groovy unofficial driver
Lisp unofficial driver
Lua unofficial driver
MatLab unofficial driver
PowerShell unofficial driver
Prolog unofficial driver
R unofficial driver
Smalltalk unofficial driver
|Triggers||yes in MongoDB Atlas only||no||no similar concept for controling cloud resources|
|Partitioning methods Methods for storing different data on different nodes||Sharding Partitioned by hashed, ranged, or zoned sharding keys. Live resharding allows users to change their shard keys as an online operation with zero downtime.||Sharding||yes|
|Replication methods Methods for redundantly storing data on multiple nodes||Multi-Source deployments with MongoDB Atlas Global Clusters|
|Electable source-replica replication per shard. Support distributed global deployment with Multi-region table feature||yes|
|MapReduce Offers an API for user-defined Map/Reduce methods||yes||with Hadoop integration||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Eventual Consistency|
Immediate Consistency can be individually decided for each write operation
Immediate Consistency depending on configuration
|Foreign keys Referential integrity||no typically not used, however similar functionality with DBRef possible||no||yes|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||Multi-document ACID Transactions with snapshot isolation||configurable ACID within a storage node (=shard)||ACID|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes|
|Durability Support for making data persistent||yes optional, enabled by default||yes||yes|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||yes In-memory storage engine introduced with MongoDB version 3.2||yes off heap cache||no|
|User concepts Access control||Access rights for users and roles||Access rights for users and roles||Users with fine-grained authorization concept, user roles and pluggable authentication|
|More information provided by the system vendor|
|Specific characteristics||MongoDB’s application data platform provides developers a unified interface to power...|
|Competitive advantages||The MongoDB platform can be used by developers building transactional, operational,...|
|Typical application scenarios||Internet of Things and Time Series (Bosch, Jaguar Land Rover) Mobile (The Weather...|
|Key customers||ADP, Adobe, Amadeus, AstraZeneca, Auto Trader, Barclays, BBVA, Bosch, Cisco, CERN,...|
|Market metrics||200+ million downloads, over 1.5M Atlas database clusters under management handling...|
|Licensing and pricing models||MongoDB database server: Server-Side Public License (SSPL) . Commercial licenses...|
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services|
|3rd parties||CData: Connect to Big Data & NoSQL through standard Drivers.|
Percona: Database problems? Not on your watch.
Databases run better with Percona.
Navicat for MongoDB gives you a highly effective GUI interface for MongoDB database management, administration and development.
|SQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.|
DBHawk: Secure access to SQL, NoSQL and Cloud databases with an all-in-one solution.
CData: Connect to Big Data & NoSQL through standard Drivers.
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|DB-Engines blog posts|
Snowflake is the DBMS of the Year 2021