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. Stardog vs. TiDB

System Properties Comparison Microsoft SQL Server vs. Stardog vs. TiDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameMicrosoft SQL Server  Xexclude from comparisonStardog  Xexclude from comparisonTiDB  Xexclude from comparison
DescriptionMicrosofts flagship relational DBMSEnterprise Knowledge Graph platform and graph DBMS with high availability, high performance reasoning, and virtualizationTiDB is an open source distributed Hybrid Transactional/Analytical Processing (HTAP) database that supports MySQL and Spark SQL syntaxes.
Primary database modelRelational DBMSGraph DBMS
RDF store
Relational DBMS
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
Document store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score929.09
Rank#3  Overall
#3  Relational DBMS
Score1.63
Rank#163  Overall
#14  Graph DBMS
#6  RDF stores
Score3.01
Rank#108  Overall
#54  Relational DBMS
Websitewww.microsoft.com/­en-us/­sql-serverwww.stardog.compingcap.com
Technical documentationdocs.microsoft.com/­en-US/­sql/­sql-serverdocs.stardog.comdocs.pingcap.com/­tidb/­stable
DeveloperMicrosoftStardog-UnionPingCAP, Inc.
Initial release198920102016
Current releaseSQL Server 2022, November 20227.3.0, May 20206.5.0, December 2022
License infoCommercial or Open Sourcecommercial inforestricted free version is availablecommercial info60-day fully-featured trial license; 1-year fully-featured non-commercial use license for academics/studentsOpen Source infoApache 2.0
Cloud-based only infoOnly available as a cloud servicenonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
TiDB Cloud: Fully-managed TiDB Service. Bring everything great about TiDB to the cloud.
Implementation languageC++JavaGo, Rust
Server operating systemsLinux
Windows
Linux
macOS
Windows
Linux
Data schemeyesschema-free and OWL/RDFS-schema supportyes
Typing infopredefined data types such as float or dateyesyesyes
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.yesno infoImport/export of XML data possibleno
Secondary indexesyesyes infosupports real-time indexing in full-text and geospatialyes
SQL infoSupport of SQLyesYes, compatible with all major SQL variants through dedicated BI/SQL Serveryes
APIs and other access methodsADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
GraphQL query language
HTTP API
Jena RDF API
OWL
RDF4J API
Sesame REST HTTP Protocol
SNARL
SPARQL
Spring Data
Stardog Studio
TinkerPop 3
JDBC
ODBC
Proprietary protocol
Supported programming languagesC#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic
.Net
Clojure
Groovy
Java
JavaScript
Python
Ruby
Ada
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
Server-side scripts infoStored proceduresTransact SQL, .NET languages, R, Python and (with SQL Server 2019) Javauser defined functions and aggregates, HTTP Server extensions in Javano
Triggersyesyes infovia event handlersno
Partitioning methods infoMethods for storing different data on different nodestables can be distributed across several files (horizontal partitioning); sharding through federationnonehorizontal partitioning (by key range)
Replication methods infoMethods for redundantly storing data on multiple nodesyes, but depending on the SQL-Server EditionMulti-source replication in HA-ClusterUsing Raft consensus algorithm to ensure data replication with strong consistency among multiple replicas.
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoyes infowith TiSpark Connector
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency in HA-ClusterImmediate Consistency
Foreign keys infoReferential integrityyesyes inforelationships in graphsno infocurrently only supported in syntax
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesno
User concepts infoAccess controlfine grained access rights according to SQL-standardAccess rights for users and rolesUsers with fine-grained authorization concept. No user groups or roles.
More information provided by the system vendor
Microsoft SQL ServerStardogTiDB
Specific characteristicsStardog is an Enterprise Knowledge Graph platform, uniquely combining graph storage...
» more
TiDB is an open-source NewSQL database built by PingCAP. TiDB supports Hybrid Transactional...
» more
Competitive advantagesStardog provides a full featureset to aid in data integration for your complex data....
» more
In the current database landscape, infrastructure engineers often have to use one...
» more
Typical application scenariosStardog is frequently used for: Supply chain optimization Operational Risk Digital...
» more
TiDB is designed to support both OLTP and OLAP scenarios. You can use TiDB , the...
» more
Key customersBosch, NASA, Boehringer Ingelheim, Cisco, Schneider Electric, FINRA and more — https://www.stardog.com/customers/
» more
Shopee (E-commerce) BookMyShow.com (E-commerce) Yiguo.com (E-commerce) JD Cloud &...
» more
Market metricsStardog's technology is based on ground-breaking research by our founders cited 10,000+...
» more
25K+ GitHub Stars for TiDB, and 8K+ GitHub Stars for TiKV 1.6K+ members in TiDB Community...
» more
Licensing and pricing modelsYou can start for free! It’s easy to get started using Stardog’s leading Enterprise...
» more
Open Source Apache 2.0 with either commercial licensing or fully-hosted DB-as-a-service...
» 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 partiesSQLFlow: 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

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

SQL Complete: An advanced IntelliSense-style code completion add-in for SSMS and Visual Studio. Write, beautify, refactor your SQL code and give your productivity a dramatic boost.
» more

Navicat for SQL Server gives you a fully graphical approach to database management and development.
» more

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

More resources
Microsoft SQL ServerStardogTiDB
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

Recent citations in the news

Amazon RDS Supports Custom SQL Server Images | Petri IT
16 January 2023, Petri.com

An Expert Guide to SQL Server Performance Tuning
7 February 2023, Redmondmag.com

How the latest SQL injection attacks threaten web application firewalls
6 February 2023, SC Media

Local Event: Earn in six figures With SQL Server Certification in 2023 ?
20 January 2023, Patch

SQL Data Types | DatabaseJounral.com
3 February 2023, Database Journal

provided by Google News

PingCAP Announces TiDB Cloud Serverless Tier, Delivering ...
1 November 2022, GlobeNewswire

PingCAP’s Innovative TiDB Database – Techstrong.TV
20 October 2022, DevOps.com

Data management trends: Convergence and more money
19 January 2023, TechTarget

PingCAP Named a Strong Performer among Translytical Data ...
6 December 2022, GlobeNewswire

PingCAP Introduces its New Developer Tier to Boost Application ...
9 November 2021, PR Newswire

provided by Google News

Job opportunities

SSBN/SSGN Missile Technician
BAE Systems, Washington, DC

Senior Demand Generation Marketing Manager
PingCAP, Sunnyvale, CA

Staff Software Engineer - Cash Cards
Cash App, New York, NY

Staff Software Engineer - Cash Cards
Cash App, San Francisco, CA

Staff Software Engineer, Distributed Systems
Zilliz, San Francisco, CA

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.

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

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 80GB free.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Present your product here