English
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Microsoft SQL Server vs. MongoDB vs. MySQL vs. Percona Server vs. PostgreSQL

System Properties Comparison Microsoft SQL Server vs. MongoDB vs. MySQL vs. Percona Server vs. PostgreSQL

Editorial information provided by DB-Engines
NameMicrosoft SQL Server  Xexclude from comparisonMongoDB  Xexclude from comparisonMySQL  Xexclude from comparisonPercona Server  Xexclude from comparisonPostgreSQL  Xexclude from comparison
DescriptionMicrosofts relational DBMSOne of the most popular document storesWidely used open source RDBMSEnhanced drop-in replacement for MySQL based on XtraDB or TokuDB storage engines with improved performance and additional diagnostic and management features.Based on the object relational DBMS Postgres Developed as objectoriented DBMS, gradually enhanced with 'standards' like SQL
Database modelRelational DBMSDocument storeRelational DBMS Key/Value like access via memcached APIRelational DBMSRelational DBMS with object oriented extensions, e.g.: user defined types/functions and inheritance. Handling of key/value pairs with hstore module.
DB-Engines Ranking measures the popularity of database management systems
Trend Chart
Score1213.80
Rank#3  Overall
#3  Relational DBMS
Score331.58
Rank#5  Overall
#1  Document stores
Score1340.03
Rank#2  Overall
#2  Relational DBMS
Score1.97
Rank#95  Overall
#46  Relational DBMS
Score365.91
Rank#4  Overall
#4  Relational DBMS
Websitewww.microsoft.com/­en-us/­sql-serverwww.mongodb.comwww.mysql.comwww.percona.com/­software/­mysql-database/­percona-serverwww.postgresql.org
Technical documentationtechnet.microsoft.com/­library/­dn237258docs.mongodb.com/­manualdev.mysql.com/­docwww.percona.com/­docs/­wiki/­percona-server:startwww.postgresql.org/­docs/­manuals
DeveloperMicrosoftMongoDB, IncOracle since 2010, originally MySQL AB, then SunPerconaPostgreSQL Global Development Group www.postgresql.org/­developer
Initial release19892009199520081989 1989: Postgres, 1996: PostgreSQL
Current releaseSQL Server 2016, June 20163.4.4, April 20175.7.18, April 20175.7.17-13, April 20179.6.3, May 2017
License Commercial or Open Sourcecommercial restricted free version is availableOpen Source AGPL version 3, commercial license availableOpen Source GPL version 2. Commercial licenses with extended functionallity are availableOpen Source GPL version 2Open Source BSD
Cloud-based Only available as a cloud servicenonononono
Implementation languageC++C++C and C++C and C++C
Server operating systemsWindowsLinux
OS X
Solaris
Windows
FreeBSD
Linux
OS X
Solaris
Windows
LinuxFreeBSD
HP-UX
Linux
NetBSD
OpenBSD
OS X
Solaris
Unix
Windows
Data schemeyesschema-free Although schema-free, documents of the same collection often follow the same structureyesyesyes
Typing predefined data types such as float or dateyesyes string, integer, double, boolean, date, object_idyesyesyes
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.yesyesyes specific XML-type available, but no XML query functionality.
Secondary indexesyesyesyesyesyes
SQL Support of (almost entire) SQL standard (DML, DDL and DCL statements)yesnoyes with proprietary extensionsyesyes standard with numerous extensions
APIs and other access methodsOLE DB
Tabular Data Stream (TDS)
ADO.NET
JDBC
ODBC
proprietary protocol using JSONADO.NET
JDBC
ODBC
ADO.NET
JDBC
ODBC
native C library
streaming API for large objects
ADO.NET
JDBC
ODBC
Supported programming languagesC++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic
Actionscript inofficial driver
C
C#
C++
Clojure inofficial driver
ColdFusion inofficial driver
D inofficial driver
Dart inofficial driver
Delphi inofficial driver
Erlang
Go inofficial driver
Groovy inofficial driver
Haskell
Java
JavaScript
Lisp inofficial driver
Lua inofficial driver
MatLab inofficial driver
Perl
PHP
PowerShell inofficial driver
Prolog inofficial driver
Python
R inofficial driver
Ruby
Scala
Smalltalk inofficial driver
Ada
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
Ada
C
C#
C++
D
Eiffel
Erlang
Haskell
Java
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
.Net
C
C++
Delphi
Java JDBC
Perl
Python
Tcl
Server-side scripts Stored proceduresTransact SQL and .NET languagesJavaScriptyes proprietary syntaxyesuser defined functions realized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.
Triggersyesnoyesyesyes
Partitioning methods Methods for storing different data on different nodestables can be distributed across several files (horizontal partitioning); sharding through federationShardinghorizontal partitioning, sharding with MySQL Cluster or MySQL Fabricno, but can be realized using table inheritance for each partition a subtable, inserts are controlled with triggers
Replication methods Methods for redundantly storing data on multiple nodesyes, but depending on the SQL-Server EditionMaster-slave replicationMaster-master replication
Master-slave replication
Master-master replication
Master-slave replication
XtraDB Cluster
Master-slave replication other methods possible by using 3rd party extensions
MapReduce Offers an API for user-defined Map/Reduce methodsnoyesnonono
Consistency concepts Methods to ensure consistency in a distributed systemImmediate ConsistencyEventual Consistency
Immediate Consistency can be individually decided for each write operation
Immediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys Referential integrityyesno typically not used, however similar functionality with DBRef possibleyes not for MyISAM storage engineyesyes
Transaction concepts Support to ensure data integrity after non-atomic manipulations of dataACIDno atomic operations within a single document possibleACID not for MyISAM storage engineACIDACID
Concurrency Support for concurrent manipulation of datayesyesyes table locks or row locks depending on storage engineyesyes
Durability Support for making data persistentyesyes optionalyesyesyes
In-memory capabilities Is there an option to define some or all structures to be held in-memory only.yesyes In-memory storage engine introduced with MongoDB version 3.2yesno
User concepts Access controlfine grained access rights according to SQL-standardAccess rights for users and rolesUsers with fine-grained authorization concept no user groups or rolesUsers with fine-grained authorization concept no user groups or rolesfine grained access rights according to SQL-standard
More information provided by the system vendor
Microsoft SQL ServerMongoDBMySQLPercona ServerPostgreSQL
Specific characteristicsMongoDB is the next-generation database that helps businesses transform their industries...
» more
Competitive advantagesBy offering the best of traditional databases as well as the flexibility, scale,...
» more
Typical application scenariosInternet of Things (Bosch, Silver Spring Networks) Mobile (The Weather Channel, ADP,...
» more
Key customersADP, Adobe, AstraZeneca, BBVA, Bosch, Cisco, CERN, Department of Veteran Affairs,...
» more
Market metrics20 million downloads (growing at thousands downloads per day). 2,000+ customers including...
» more
Licensing and pricing modelsMongoDB database server: Free Software Foundation’s GNU AGPL v3.0. 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.

3rd party products and services
3rd partiesProgress DataDirect: Data connectivity across standard SQL and REST
» more

Devart: Any SQL Server Tool you Need
» more
CData: Connect to Big Data & NoSQL through standard Drivers.
» more

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

Progress DataDirect: Data connectivity across standard SQL and REST
» more
CData: Connect to Big Data & NoSQL through standard Drivers.
» more
Progress DataDirect: Data connectivity across standard SQL and REST
» more

We invite representatives of 3rd party vendors to contact us for presenting information about their offerings here.

More resources
Microsoft SQL ServerMongoDBMySQLPercona ServerPostgreSQL
DB-Engines blog posts

The struggle for the hegemony in Oracle's database empire
2 May 2017, Paul Andlinger

Microsoft SQL Server is the DBMS of the Year
4 January 2017, Matthias Gelbmann, Paul Andlinger

Architecting eCommerce Platforms for Zero Downtime on Black Friday and Beyond
25 November 2016, Tony Branson (guest author)

show all

PostgreSQL moves up one rank at the expense of MongoDB
1 September 2016, Paul Andlinger

Oracle is the DBMS of the Year
5 January 2016, Paul Andlinger, Matthias Gelbmann

Winners, losers and an attractive newcomer in Novembers DB-Engines ranking
2 November 2015, Paul Andlinger

show all

The struggle for the hegemony in Oracle's database empire
2 May 2017, Paul Andlinger

Microsoft SQL Server is the DBMS of the Year
4 January 2017, Matthias Gelbmann, Paul Andlinger

Architecting eCommerce Platforms for Zero Downtime on Black Friday and Beyond
25 November 2016, Tony Branson (guest author)

show all

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

Microsoft SQL Server is the DBMS of the Year
4 January 2017, Matthias Gelbmann, Paul Andlinger

PostgreSQL moves up one rank at the expense of MongoDB
1 September 2016, Paul Andlinger

MySQL, PostgreSQL and Redis are the winners of the March ranking
2 March 2016, Paul Andlinger

show all

Conferences and events

PASS Summit 2017
Seattle, Washington, USA, 31 October 2017 - 3 November 2017

MongoDB World 2017
Chicago, Illinois, USA, 20-21 June 2017

PGCon 2017
Ottawa, Canada, 25-26 May 2017 (finished)

Recent citations in the news

SQL Server Data Tools in your DevOps pipeline - Microsoft
24 May 2017, Channel 9

Capacity Planning Done Right for SQL Server
23 May 2017, SQL Server Pro

Automate SQL Server Docker container configuration via Dockerfiles
18 May 2017, TechTarget

Quest Sharpens Tools for Hybrid SQL Server Environments
24 May 2017, Database Trends and Applications

Identifying and Solving Common SQL Server Performance Problems
12 May 2017, WindowsItPro (subscription)

provided by Google News

MongoDB Atlas Expands AWS Footprint
2 May 2017, InfoQ.com

Over 560 Million Passwords Discovered in Anonymous Online Database
16 May 2017, Gizmodo

NoSQL, no problem: Why MySQL is still king
10 May 2017, InfoWorld

Level-3 customizable training programs offered by Aurelius Corporate Solutions on MongoDB tool for database ...
5 May 2017, MENAFN.COM

Does Microsoft's Cosmos DB promise too much?
23 May 2017, ITworld

provided by Google News

How to install mycli for suggestion-based MySQL typing
23 May 2017, TechRepublic

Microsoft launches Azure Database for MySQL and PostgreSQL
10 May 2017, TechCrunch

NoSQL, no problem: Why MySQL is still king
10 May 2017, InfoWorld

Microsoft announces MySQL as a Service
10 May 2017, TechTarget

WordPress Hosting: Does it Really Matter Where You Host?
26 May 2017, Business 2 Community

provided by Google News

How much disk space should I allocate for Percona Monitoring and Management?
4 May 2017, Intelligent Aerospace

Percona Server for MongoDB 3.4 Product Bundle Released
6 March 2017, insideBIGDATA

Percona Delivers Open Source In-Memory Storage Engine for Percona Server for MongoDB
11 August 2016, Marketwired (press release)

Introducing the Percona Memory Engine for MongoDB
12 August 2016, DZone News

ObjectRocket Now Offers Percona Server for MongoDB
26 April 2017, WireUpdate

provided by Google News

Microsoft launches Azure Database for MySQL and PostgreSQL
10 May 2017, TechCrunch

GSA Adds Crunchy Data's PostgreSQL Enterprise Support, Professional Services to Schedule 70
4 May 2017, ExecutiveBiz (blog)

Mobilizing PostgreSQL Databases for Realtime Applications ...
8 May 2017, insideBIGDATA

Crunchy Data Awarded GSA IT Schedule 70 Contract For Certified ...
3 May 2017, Benzinga

AWS enables use of SQL to map users, roles, and grants from Oracle to PostgreSQL
16 May 2017, CTR (blog)

provided by Google News

Job opportunities

Data Architect (Remote)
First San Francisco Partners, Remote

Database Developer
American College Of Cardiology, Washington, DC

DevOps Engineer - Full Time Perm Telework (Remote)
Council of Better Business Bureaus, Inc., Arlington, VA

SQL Server DBA/Developer
Commissions Inc., Marietta, GA

Developer I/II Job Family - SQL
Anthem, Inc., Norfolk, VA

MongoDB Developer
Tana Consultancy Services, Boca Raton, FL

MongoDB Database Server Engineer
MongoDB, New York, NY

MongoDB Developer
First Soft Solutions [ Direct], Jersey City, NJ

MongoDB Developer
Astir Technologies, LLC, Orlando, FL

MongoDB Developer
Mindboard, Inc., Columbia, MD

PHP Developer
ClientSolv Technologies, Kirkland, WA

Fron End Development Intern
Siemens, Princeton, NJ

IT - Technology Lead | Java | J2EE
XDuce, San Francisco, CA

Sr. iOS Engineer
Kinect, Venice, CA

IT and Database Administrator
Zoological Society of Milwaukee, Milwaukee, WI

MySQL SME (Remote )
Akima, LLC, United States

MySQL SME
Akima, LLC, Alexandria, VA

MySQL DBA
Tollfreeforwarding.com, Los Angeles, CA

Linux and MySQL Engineer
West Monroe Partners, Chicago, IL

Systems Engineer
Rockstar New York, New York, NY

PHP Developer
ClientSolv Technologies, Kirkland, WA

Postgres Database Administrator
Science System and Applications, Inc., Pasadena, CA

Database Administrator
Squaretrade, San Francisco, CA

Database Administrator
Renaissance, Wisconsin Rapids, WI

Database Admin (PostGreSQL)
Damco Solutions, Houston, TX

jobs by Indeed




Share this page

Featured Products

Datastax delivers Apache Cassandra as part of a database platform purpose built for IOT, Web and Mobile Apps. Download now.

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

OrientDB Logo The power of a Distributed Graph Database engine
with the flexibility of a Document Database.

Get your step-by-step guide comparing RDBMS to graph databases, including data models, query languages, and deployment strategies.

Present your product here