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 > Microsoft SQL Server vs. MySQL vs. Qdrant vs. SiteWhere vs. YugabyteDB

System Properties Comparison Microsoft SQL Server vs. MySQL vs. Qdrant vs. SiteWhere vs. YugabyteDB

Editorial information provided by DB-Engines
NameMicrosoft SQL Server  Xexclude from comparisonMySQL  Xexclude from comparisonQdrant  Xexclude from comparisonSiteWhere  Xexclude from comparisonYugabyteDB  Xexclude from comparison
DescriptionMicrosofts flagship relational DBMSWidely used open source RDBMSA high-performance vector database with neural network or semantic-based matchingM2M integration platform for persisting/querying time series dataHigh-performance distributed SQL database for global, internet-scale applications. Wire and feature compatible with PostgreSQL.
Primary database modelRelational DBMSRelational DBMS infoKey/Value like access via memcached APIVector DBMSTime Series DBMSRelational DBMS
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
Document store
Spatial DBMS
Document store
Wide column store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score824.29
Rank#3  Overall
#3  Relational DBMS
Score1083.74
Rank#2  Overall
#2  Relational DBMS
Score1.16
Rank#175  Overall
#6  Vector DBMS
Score0.06
Rank#356  Overall
#35  Time Series DBMS
Score2.91
Rank#102  Overall
#51  Relational DBMS
Websitewww.microsoft.com/­en-us/­sql-serverwww.mysql.comgithub.com/­qdrant/­qdrant
qdrant.tech
github.com/­sitewhere/­sitewherewww.yugabyte.com
Technical documentationlearn.microsoft.com/­en-US/­sql/­sql-serverdev.mysql.com/­docqdrant.tech/­documentationsitewhere1.sitewhere.io/­index.htmldocs.yugabyte.com
github.com/­yugabyte/­yugabyte-db
DeveloperMicrosoftOracle infosince 2010, originally MySQL AB, then SunQdrantSiteWhereYugabyte Inc.
Initial release19891995202120102017
Current releaseSQL Server 2022, November 20228.4.0, April 20242.19, September 2023
License infoCommercial or Open Sourcecommercial inforestricted free version is availableOpen Source infoGPL version 2. Commercial licenses with extended functionallity are availableOpen Source infoApache Version 2.0Open Source infoCommon Public Attribution License Version 1.0Open Source infoApache 2.0
Cloud-based only infoOnly available as a cloud servicenonononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
SQLServer Flex @ STACKIT offers a managed version of SQL Server with adjustable CPU, RAM, storage amount and speed, in enterprise grade to perfectly match all application requirements. All services are 100% GDPR-compliant.Aiven for MySQL: Fully managed MySQL, deployable in the cloud of your choice, with seamless integrations and lightning-fast setup.YugabyteDB Managed is the fully managed database-as-a-service offering of YugabyteDB. Get started quickly, and effortlessly ensure continuous availability and limitless scale of your cloud native applications.
Implementation languageC++C and C++RustJavaC and C++
Server operating systemsLinux
Windows
FreeBSD
Linux
OS X
Solaris
Windows
Docker
Linux
macOS
Windows
Linux
OS X
Windows
Linux
OS X
Data schemeyesyesschema-freepredefined schemedepending on used data model
Typing infopredefined data types such as float or dateyesyesNumbers, Strings, Geo, Booleanyesyes
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.yesyesnonono
Secondary indexesyesyesyes infoKeywords, numberic ranges, geo, full-textnoyes
SQL infoSupport of SQLyesyes infowith proprietary extensionsnonoyes, PostgreSQL compatible
APIs and other access methodsADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
ADO.NET
JDBC
ODBC
Proprietary native API
gRPC
OpenAPI 3.0
RESTful HTTP/JSON API infoOpenAPI 3.0
HTTP RESTJDBC
YCQL, an SQL-based flexible-schema API with its roots in Cassandra Query Language
YSQL - a fully relational SQL API that is wire compatible with the SQL language in PostgreSQL
Supported programming languagesC#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic
Ada
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
.Net
Go
Java
JavaScript (Node.js)
Python
Rust
C
C#
C++
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
Rust
Scala
Server-side scripts infoStored proceduresTransact SQL, .NET languages, R, Python and (with SQL Server 2019) Javayes infoproprietary syntaxyes infosql, plpgsql, C
Triggersyesyesyes
Partitioning methods infoMethods for storing different data on different nodestables can be distributed across several files (horizontal partitioning); sharding through federationhorizontal partitioning, sharding with MySQL Cluster or MySQL FabricShardingSharding infobased on HBaseHash and Range Sharding, row-level geo-partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesyes, but depending on the SQL-Server EditionMulti-source replication
Source-replica replication
Collection-level replicationselectable replication factor infobased on HBaseBased on Raft distributed consensus protocol, minimum 3 replicas for continuous availability
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyEventual Consistency, tunable consistencyImmediate ConsistencyStrong consistency on writes and tunable consistency on reads
Foreign keys infoReferential integrityyesyes infonot for MyISAM storage enginenoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACID infonot for MyISAM storage enginenoDistributed ACID with Serializable & Snapshot Isolation. Inspired by Google Spanner architecture.
Concurrency infoSupport for concurrent manipulation of datayesyes infotable locks or row locks depending on storage engineyesyesyes
Durability infoSupport for making data persistentyesyesyesyesyes infobased on RocksDB
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesyesnono
User concepts infoAccess controlfine grained access rights according to SQL-standardUsers with fine-grained authorization concept infono user groups or rolesKey-based authenticationUsers with fine-grained authorization conceptyes
More information provided by the system vendor
Microsoft SQL ServerMySQLQdrantSiteWhereYugabyteDB
Specific characteristicsYugabyteDB is an open source distributed SQL database for cloud native transactional...
» more
Competitive advantagesPostgreSQL compatible: Get instantly productive with a PostgreSQL compatible RDBMS....
» more
Typical application scenariosSystems of record and engagement for cloud native applications that require resilience,...
» more
Market metrics2 Million+ lifetime clusters deployed, 6.5K+ GitHub stars, 7K YugabyteDB Community...
» more
Licensing and pricing modelsApache 2.0 license for the database
» 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 partiesNavicat Monitor is a safe, simple and agentless remote server monitoring tool for SQL Server and many other database management systems.
» more

Navicat for SQL Server gives you a fully graphical approach to database management and development.
» more
Navicat for MySQL is the ideal solution for MySQL/MariaDB administration and development.
» more

Aiven for MySQL: Fully managed MySQL, deployable in the cloud of your choice, with seamless integrations and lightning-fast setup.
» more

CData: Connect to Big Data & NoSQL through standard Drivers.
» more

Navicat Monitor is a safe, simple and agentless remote server monitoring tool for MySQL and many other database management systems.
» more

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

More resources
Microsoft SQL ServerMySQLQdrantSiteWhereYugabyteDB
DB-Engines blog posts

MySQL is the DBMS of the Year 2019
3 January 2020, Matthias Gelbmann, Paul Andlinger

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

show all

MySQL is the DBMS of the Year 2019
3 January 2020, Matthias Gelbmann, Paul Andlinger

MariaDB strengthens its position in the open source RDBMS market
5 April 2018, Matthias Gelbmann

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

show all

Recent citations in the news

A generative AI use case using Amazon RDS for SQL Server as a vector data store | Amazon Web Services
22 May 2024, AWS Blog

SQL Server vNext: When and What Is Coming
16 May 2024, Redmondmag.com

Data Virtualization in SQL Server 2022
7 May 2024, Visual Studio Magazine

SQL Server 2014 end of support: Keep your customers secure
28 March 2024, Microsoft

How to Know When It's Time for a Microsoft SQL Server Upgrade
31 October 2023, BizTech Magazine

provided by Google News

Amazon Aurora MySQL version 2 (with MySQL 5.7 compatibility) to version 3 (with MySQL 8.0 compatibility) upgrade ...
18 March 2024, AWS Blog

Enterprise Manager: How Comcast enhanced monitoring for MySQL InnoDB Clusters
22 April 2024, blogs.oracle.com

Ultimate MySQL Workbench Installation Guide [2024 Edition]
15 February 2024, Simplilearn

Zendesk Moves from DynamoDB to MySQL and S3 to Save over 80% in Costs
29 December 2023, InfoQ.com

How to Create a MySQL 8 Database User With Remote Access
4 January 2024, TechRepublic

provided by Google News

Open source vector database startup Qdrant raises $28M
23 January 2024, TechCrunch

Qdrant offers managed vector database for hybrid clouds
16 April 2024, InfoWorld

Qdrant Announces an Industry-First Hybrid Cloud Offering For Enterprise AI Applications
16 April 2024, businesswire.com

Qdrant Hybrid Cloud is Now Available for OCI Customers: Managed Vector Search Engine for Data-Sensitive AI ...
16 April 2024, blogs.oracle.com

Why Vector Data Services For AI Are A Moveable Feast
17 April 2024, Forbes

provided by Google News

SiteWhere: An open platform for connected devices
11 July 2017, Open Source For You

Ten Popular IoT Platforms You Should be Aware of
27 March 2023, Open Source For You

11 Best Open source IoT Platforms To Develop Smart Projects
9 March 2023, H2S Media

provided by Google News

YugabyteDB Becomes First Distributed SQL Database Vendor to Complete CIS Benchmark
1 February 2024, Datanami

Yugabyte Achieves PCI DSS Level 1 Compliance, Validating Secure and Scalable Distributed PostgreSQL for ...
14 March 2024, businesswire.com

The surprising link between Formula One and enterprise PostgreSQL optimisation
28 March 2024, The Stack

Yugabyte Embraces 'No Downtime, No Limits,' as the Theme of the Upcoming Distributed SQL Summit Asia
18 April 2024, businesswire.com

Can Yugabyte Become The Defacto Database For Large-Scale, Cloud Native Applications?
19 May 2022, Forbes

provided by Google News



Share this page

Featured Products

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

RaimaDB logo

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

Neo4j logo

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

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

AllegroGraph logo

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

Present your product here