DB-EnginesCrateDB bannerEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Drizzle vs. FaunaDB vs. Memgraph vs. Microsoft Azure SQL Data Warehouse

System Properties Comparison Drizzle vs. FaunaDB vs. Memgraph vs. Microsoft Azure SQL Data Warehouse

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameDrizzle  Xexclude from comparisonFaunaDB  Xexclude from comparisonMemgraph  Xexclude from comparisonMicrosoft Azure SQL Data Warehouse  Xexclude from comparison
Drizzle has published its last release in September 2012. The open-source project is discontinued and Drizzle is excluded from the DB-Engines ranking.
DescriptionMySQL fork with a pluggable micro-kernel and with an emphasis of performance over compatibility.Strongly consistent database capable of global horizontal scale with a focus on operational simplicityA hybrid, in-memory first, distributed graph DBMS delivering high-performance on analytical and transactional workloads at enterprise scaleElastic, large scale data warehouse service leveraging the broad eco-system of SQL Server
Primary database modelRelational DBMSDocument store
Graph DBMS
Relational DBMS
Time Series DBMS
Graph DBMSRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.19
Rank#143  Overall
#23  Document stores
#10  Graph DBMS
#70  Relational DBMS
#9  Time Series DBMS
Score0.09
Rank#285  Overall
#25  Graph DBMS
Score8.99
Rank#43  Overall
#27  Relational DBMS
Websitefauna.commemgraph.comazure.microsoft.com/­services/­sql-data-warehouse
Technical documentationdocs.fauna.comdocs.memgraph.comdocs.microsoft.com/­azure/­sql-data-warehouse
DeveloperDrizzle project, originally started by Brian AkerFauna, Inc.Memgraph LtdMicrosoft
Initial release2008201420172016
Current release7.2.4, September 2012
License infoCommercial or Open SourceOpen Source infoGNU GPLcommercialcommercial infoFree license availablecommercial
Cloud-based only infoOnly available as a cloud servicenononoyes
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++ScalaC and C++C++
Server operating systemsFreeBSD
Linux
OS X
LinuxLinuxhosted
Data schemeyesschema-freeschema-free and schema-optionalyes
Typing infopredefined data types such as float or dateyesnoyesyes
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.nonono
Secondary indexesyesyesyes
SQL infoSupport of SQLyes infowith proprietary extensionsnonoyes
APIs and other access methodsJDBCRESTful HTTP APIBolt protocol
Cypher query language
ADO.NET
JDBC
ODBC
Supported programming languagesC
C++
Java
PHP
C#
Go
Java
JavaScript
Python
Ruby
Scala
Swift
.Net
C
C++
Elixir
Go
Haskell
Java
JavaScript
PHP
Python
Ruby
Scala
C#
Java
PHP
Server-side scripts infoStored proceduresnouser defined functionsTransact SQL
Triggersno infohooks for callbacks inside the server can be used.nono
Partitioning methods infoMethods for storing different data on different nodesShardinghorizontal partitioning infoconsistent hashingSharding infodynamic graph partitioningSharding, horizontal partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesMaster-master replication
Master-slave replication
MasterlessMulti-Master replication using RAFTyes
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesyesyes inforelationships in graphsyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDACID infowith snapshot isolationACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes, multi-version concurrency control (MVCC)yes
Durability infoSupport for making data persistentyesyesyes infowith periodic snapshot and write-ahead logging (WAL) of changesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyes
User concepts infoAccess controlPluggable authentication mechanisms infoe.g. LDAP, HTTPIdentity management, authentication, and access controlUsers, roles and permissionsyes

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

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

More resources
DrizzleFaunaDBMemgraphMicrosoft Azure SQL Data Warehouse
DB-Engines blog posts

MySQL won the April ranking; did its forks follow?
1 April 2015, Paul Andlinger

Has MySQL finally lost its mojo?
1 July 2013, Matthias Gelbmann

show all

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

Azure SQL Data Warehouse, the hub for a trusted and performance optimized cloud data warehouse
1 November 2017,  Arnaud Comet, Microsoft (sponsor) 

show all

Recent citations in the news

FaunaDB review: Fast NoSQL database for global scale
12 December 2019, InfoWorld

5 common problems FaunaDB indexes solve for you
20 November 2019, InfoWorld

FaunaDB now offers a “Managed Serverless” service combining Fauna’s serverless database with a managed solution
22 August 2019, Packt Hub

No more n+1 problems with FaunaDB's GraphQL API
12 December 2019, JAXenter

GraphCMS, content distribution software, adds €2.5 million to its seed round
4 May 2020, EU-Startups

provided by Google News

COVID-19 Impact on Graph Database Market Research | Trends | Recovery
26 May 2020, Cole of Duty

Europe Graph database Market Insights and Forecast 2020 to 2025
27 May 2020, 3rd Watch News

FactGem and Memgraph Partner to Give Clients Access to Real-Time, Transaction Based Analytics
1 February 2019, PRNewswire

Global Graph Database Market 2020 by Product, Application, Manufacturer, Sales and Segmentation 2025
27 May 2020, 3rd Watch News

Impact of Covid-19 Global Graph Database Market (2020 To 2027) | IBM, Microsoft, Oracle, AWS, Neo4j
31 May 2020, NJ MMA News

provided by Google News

A closer look at Azure Synapse Link
28 May 2020, ZDNet

Microsoft launches Azure Synapse Link to help enterprises get faster insights from their data
19 May 2020, TechCrunch

Microsoft Azure Synapse v1.0
5 May 2020, Gigaom

The Register calls for aid, and Microsoft's Rohan Kumar will answer... our questions about SQL Edge and Azure Synapse
21 May 2020, The Register

Teradata switches CEOs mid-flight while being eaten alive in the cloud, but it's not game over yet for data warehouser
13 May 2020, The Register

provided by Google News

Job opportunities

NodeJS /Front End Developer - Remote
Fauna, Inc., Remote

Vice President of Engineering - US Remote
Fauna, Inc., Remote

Sr. Developer Advocate - Remote
Fauna, Inc., Remote

Software Engineer, Database - Scala - Remote
Fauna, Inc., Remote

Site Reliability Engineer - Infrastructure Automation - Remote
Fauna, Inc., Remote

Azure Data Architect
Perficient, Inc, Irvine, CA

Data Warehouse DataStage Developer
DXC, El Paso, TX

Cloud Data Engineer
Applied Information Sciences, United States

Database Administrator
Hi-Tech Bangla Information Systems, United States

Data Modeler
DeVry University, Naperville, IL

jobs by Indeed




Share this page

Featured Products

Datastax Luna logo

Simple, subscription-based support for open source
Apache Cassandra™ from the Cassandra experts.
Learn more.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Couchbase logo

SQL + JSON + NoSQL.
Power, flexibility & scale.
All open source.
Get started now.

Neo4j logo

Get your free copy of the new O'Reilly book Graph Algorithms with 20+ examples for
machine learning, graph analytics and more.

RavenDB logo

Setup a fully managed RavenDB Cloud Database in minutes. Enjoy hosting, management, backups all in one place.
Grab a Free Instance

Present your product here