DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > DolphinDB vs. H2 vs. Microsoft Azure Cosmos DB vs. Snowflake vs. Sqrrl

System Properties Comparison DolphinDB vs. H2 vs. Microsoft Azure Cosmos DB vs. Snowflake vs. Sqrrl

Editorial information provided by DB-Engines
NameDolphinDB  Xexclude from comparisonH2  Xexclude from comparisonMicrosoft Azure Cosmos DB infoformer name was Azure DocumentDB  Xexclude from comparisonSnowflake  Xexclude from comparisonSqrrl  Xexclude from comparison
Sqrrl has been acquired by Amazon and became a part of Amazon Web Services. It has been removed from the DB-Engines ranking.
DescriptionDolphinDB is a high performance Time Series DBMS. It is integrated with an easy-to-use fully featured programming language and a high-volume high-velocity streaming analytics system. It offers operational simplicity, scalability, fault tolerance, and concurrency.Full-featured RDBMS with a small footprint, either embedded into a Java application or used as a database server.Globally distributed, horizontally scalable, multi-model database serviceCloud-based data warehousing service for structured and semi-structured dataAdaptable, secure NoSQL built on Apache Accumulo
Primary database modelTime Series DBMSRelational DBMSDocument store
Graph DBMS
Key-value store
Wide column store
Relational DBMSDocument store
Graph DBMS
Key-value store
Wide column store
Secondary database modelsRelational DBMSSpatial DBMSSpatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.60
Rank#139  Overall
#9  Time Series DBMS
Score9.81
Rank#51  Overall
#31  Relational DBMS
Score41.38
Rank#27  Overall
#4  Document stores
#2  Graph DBMS
#3  Key-value stores
#3  Wide column stores
Score103.12
Rank#13  Overall
#9  Relational DBMS
Websitewww.dolphindb.comwww.h2database.comazure.microsoft.com/­services/­cosmos-dbwww.snowflake.comsqrrl.com
Technical documentationwww.dolphindb.com/­helpwww.h2database.com/­html/­main.htmldocs.microsoft.com/­azure/­cosmos-dbdocs.snowflake.net/­manuals/­index.html
DeveloperDolphinDB, IncThomas MuellerMicrosoftSnowflake Computing Inc.Amazon infooriginally Sqrrl Data, Inc.
Initial release20182005201420142012
Current releasev2.00.4, January 20222.1.210, January 2022
License infoCommercial or Open Sourcecommercial infofree community version availableOpen Source infodual-licence (Mozilla public license, Eclipse public license)commercialcommercialcommercial
Cloud-based only infoOnly available as a cloud servicenonoyesyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++JavaJava
Server operating systemsLinux
Windows
All OS with a Java VMhostedhostedLinux
Data schemeyesyesschema-freeyes infosupport of semi-structured data formats (JSON, XML, Avro)schema-free
Typing infopredefined data types such as float or dateyesyesyes infoJSON typesyesyes
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.nonoyes
Secondary indexesyesyesyes infoAll properties auto-indexed by defaultyes
SQL infoSupport of SQLSQL-like query languageyesSQL-like query languageyesno
APIs and other access methodsJDBC
JSON over HTTP
Kafka
MQTT (Message Queue Telemetry Transport)
ODBC
OPC DA
OPC UA
RabbitMQ
WebSocket
JDBC
ODBC
DocumentDB API
Graph API (Gremlin)
MongoDB API
RESTful HTTP API
Table API
CLI Client
JDBC
ODBC
Accumulo Shell
Java API
JDBC
ODBC
RESTful HTTP API
Thrift
Supported programming languagesC#
C++
Go
Java
JavaScript
MatLab
Python
R
Rust
Java.Net
C#
Java
JavaScript
JavaScript (Node.js)
MongoDB client drivers written for various programming languages
Python
JavaScript (Node.js)
Python
Actionscript
C infousing GLib
C#
C++
Cocoa
Delphi
Erlang
Go
Haskell
Java
JavaScript
OCaml
Perl
PHP
Python
Ruby
Smalltalk
Server-side scripts infoStored proceduresyesJava Stored Procedures and User-Defined FunctionsJavaScriptuser defined functionsno
TriggersnoyesJavaScriptno infosimilar concept for controling cloud resourcesno
Partitioning methods infoMethods for storing different data on different nodeshorizontal partitioningnoneSharding infoImplicit feature of the cloud serviceyesSharding infomaking use of Hadoop
Replication methods infoMethods for redundantly storing data on multiple nodesyesWith clustering: 2 database servers on different computers operate on identical copies of a databaseyes infoImplicit feature of the cloud serviceyesselectable replication factor infomaking use of Hadoop
MapReduce infoOffers an API for user-defined Map/Reduce methodsyesnowith Hadoop integration infoIntegration with Hadoop/HDInsight on Azure*noyes
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyBounded Staleness
Consistent Prefix
Eventual Consistency
Immediate Consistency infoConsistency level configurable on request level
Session Consistency
Immediate ConsistencyImmediate Consistency infoDocument store kept consistent with combination of global timestamping, row-level transactions, and server-side consistency resolution.
Foreign keys infoReferential integritynoyesnoyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datayesACIDMulti-item ACID transactions with snapshot isolation within a partitionACIDAtomic updates per row, document, or graph entity
Concurrency infoSupport for concurrent manipulation of datayesyes, multi-version concurrency control (MVCC)yesyesyes
Durability infoSupport for making data persistentyesyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesno
User concepts infoAccess controlAdministrators, Users, Groupsfine grained access rights according to SQL-standardAccess rights can be defined down to the item levelUsers with fine-grained authorization concept, user roles and pluggable authenticationCell-level Security, Data-Centric Security, Role-Based Access Control (RBAC), Attribute-Based Access Control (ABAC)

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

DBHawk: Secure access to SQL, NoSQL and Cloud databases with an all-in-one solution.
» more

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.
» more

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

More resources
DolphinDBH2Microsoft Azure Cosmos DB infoformer name was Azure DocumentDBSnowflakeSqrrl
DB-Engines blog posts

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

show all

Recent citations in the news

Defender for Azure Cosmos DB Preview Announced by Microsoft
2 March 2022, Redmondmag.com

Researchers discover critical flaw in Azure Cosmos DB
27 August 2021, TechTarget

Xoriant X⋅CELERATE IoT Now Available in the Microsoft Azure Marketplace
25 July 2022, PR Newswire

Hackers manage to smash Microsoft's Azure Cosmos DB database cluster, reveal poor security practices
12 November 2021, MSPoweruser

Microsoft Warns Customers about a Critical Vulnerability in Azure Cosmos DB
31 August 2021, InfoQ.com

provided by Google News

Snowflake Remains The Strongest Overall Data Platform, Analyst Says After Call With Expert
19 August 2022, Benzinga

Review: Snowflake aces Python machine learning
3 August 2022, InfoWorld

Cboe Partners With Snowflake to Move Corporate Data to Cloud
28 July 2022, Bloomberg

Data chess game: Databricks, MongoDB and Snowflake make moves for the enterprise, part 2
26 July 2022, VentureBeat

Snowflake and Databricks Are Building Streaming Data Pipelines
5 August 2022, Business Insider

provided by Google News

SIP is the most preferred investment avenue among millennials: Survey | Mint
16 August 2022, Mint

Being clever cannot be a business model: CASHe chairman V Raman Kumar
31 July 2022, Business Standard

Home TMT CASHe enters wealthtech space with Sqrrl acquisition
10 May 2022, VCCircle

Amazon's cloud business acquires Sqrrl, a security start-up with NSA roots
23 January 2018, CNBC

7 Companies Amazon Should Acquire Next
10 August 2022, Nasdaq

provided by Google News

Job opportunities

Azure Developer
TSN Partners, Remote

Technical Support Engineering - Azure Cosmos DB
Microsoft, Charlotte, NC

Support Engineering - Cosmos DB
Microsoft, Issaquah, WA

.Net Developer
eTeam Inc., Cary, NC

Application Support Specialist
Stefanini Group, Remote

Snowflake Data Modeler
FIIDUS, Remote

Database Engineer
VillageMD, Chicago, IL

Snowflake Admin
Vings Technology, Remote

Data Modeler(SnowFlake)
LumenData, Remote

Senior Database Engineer
Signify Health, Dallas, TX

jobs by Indeed



Share this page

Featured Products

Neo4j logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

The definitive guide for Cassandra

Imagine What You Could Do if Scalability Wasn‘t a Problem!
Download the Cassandra e-book for free!

AllegroGraph logo

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

Redis logo

The world’s most loved real‑time data platform.
Try free

Present your product here