DB-EnginesExtremeDB: the mission critical dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Apache Doris vs. Microsoft Azure Synapse Analytics vs. TigerGraph vs. ToroDB

System Properties Comparison Apache Doris vs. Microsoft Azure Synapse Analytics vs. TigerGraph vs. ToroDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameApache Doris  Xexclude from comparisonMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data Warehouse  Xexclude from comparisonTigerGraph  Xexclude from comparisonToroDB  Xexclude from comparison
DescriptionAn MPP-based analytics DBMS embracing the MySQL protocolElastic, large scale data warehouse service leveraging the broad eco-system of SQL ServerA complete, distributed, parallel graph computing platform supporting web-scale data analytics in real-timeA MongoDB-compatible JSON document store, built on top of PostgreSQL
Primary database modelRelational DBMSRelational DBMSGraph DBMSDocument store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.58
Rank#247  Overall
#116  Relational DBMS
Score23.10
Rank#34  Overall
#20  Relational DBMS
Score2.31
Rank#127  Overall
#9  Graph DBMS
Score0.17
Rank#327  Overall
#46  Document stores
Websitedoris.apache.org
github.com/­apache/­doris
azure.microsoft.com/­services/­synapse-analyticswww.tigergraph.comwww.torodb.com
Technical documentationgithub.com/­apache/­doris/­wikidocs.microsoft.com/­azure/­synapse-analyticsdocs.tigergraph.comwww.torodb.com/­stampede/­docs
DeveloperApache Software Foundation, originally contributed from BaiduMicrosoft8Kdata
Initial release2017201620172016
Current release0.14, May 2021
License infoCommercial or Open SourceOpen Source infoApache Version 2.0commercialcommercialOpen Source infoAGPL-V3
Cloud-based only infoOnly available as a cloud servicenoyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaC++C++Java
Server operating systemsLinuxhostedLinuxAll OS with a Java 7 VM
Data schemeyesyesyesschema-free
Typing infopredefined data types such as float or dateyesyesyesyes infostring, integer, double, boolean, date, object_id
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.nononono
Secondary indexesyesyes
SQL infoSupport of SQLyesyesSQL-like query language (GSQL)
APIs and other access methodsJDBC
MySQL client
ADO.NET
JDBC
ODBC
GSQL (TigerGraph Query Language)
Kafka
RESTful HTTP/JSON API
Supported programming languagesJavaC#
Java
PHP
C++
Java
Server-side scripts infoStored proceduresuser defined functionsTransact SQLyes
Triggersnononono
Partitioning methods infoMethods for storing different data on different nodeshorizontal partitioningSharding, horizontal partitioningSharding
Replication methods infoMethods for redundantly storing data on multiple nodesnoneyesSource-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoyes
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyEventual Consistency
Immediate Consistency
Foreign keys infoReferential integritynono infodocs.microsoft.com/­en-us/­azure/­synapse-analytics/­sql-data-warehouse/­sql-data-warehouse-table-constraintsyes infoRelationships in graphsno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDno
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nono
User concepts infoAccess controlfine grained access rights according to SQL-standardyesRole-based access controlAccess rights for users and roles
More information provided by the system vendor
Apache DorisMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data WarehouseTigerGraphToroDB
Specific characteristicsTigerGraph is a native graph database, with massively parallel processing and fully...
» more
Competitive advantagesTigerGraph is the fastest and most scalable graph platform, powered by a native parallel...
» more
Typical application scenariosAnti Money Laundering Real-Time Fraud Detection Customer 360 Real-Time Personalized...
» more
Key customersFour out of the top five global banks use TigerGraph for real-time fraud detection....
» more
Market metricsANALYST RESEARCH Nov 2020: TigerGraph Named A Leader For Graph Data Platforms - TigerGraph...
» more
Licensing and pricing modelsTry TigerGraph for Free in the Cloud or On Prem https://www.tigergraph.com/get-tigergraph/...
» 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

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

More resources
Apache DorisMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data WarehouseTigerGraphToroDB
Recent citations in the news

Apache Doris just 'graduated': Why care about this SQL data warehouse
24 June 2022, InfoWorld

Apache Doris Reaches Top-Level Status
30 June 2022, iProgrammer

The Apache Software Foundation Announces Apache® Doris™ as a Top-Level Project
16 June 2022, GlobeNewswire

StarRocks Brings Speedy OLAP Database to the Cloud
14 July 2022, Datanami

Open-Source Vendor Flywheel Tech Bags over CNY 300 Mn Angel and Angel+ Funding
2 May 2022, EqualOcean

provided by Google News

What is Azure Data Factory?
9 September 2022, Petri.com

Building a Data Lakehouse in Azure with Databricks
3 September 2022, Medium

State and Local Agencies Automate Data Analysis with Software as a Service
30 September 2022, StateTech Magazine

AtScale Announces Data Science and Enterprise AI Capabilities Within Semantic Layer Platform
28 September 2022, Business Wire

Azure Synapse vs. Databricks: Data Platform Comparison | eWEEK
20 July 2022, eWeek

provided by Google News

Shifting from Passenger to Driver Mindset
9 September 2022, InfoQ.com

TigerGraph unveils new tool for machine learning modeling
25 May 2022, TechTarget

TigerGraph Cloud update enables easier adoption, deployment
6 July 2022, TechTarget

TigerGraph updates cloud database with new security and productivity features
29 June 2022, SiliconANGLE News

WFIS paces to unveil Indonesia's most advanced FSI show
30 September 2022, Crypto Reporter

provided by Google News

Job opportunities

Azure Synapse Developer
Cognizant, Atlanta, GA

Azure Cloud Engineer
Tek Ninjas, Minneapolis, MN

Digital Sales Representative - Azure Data & AI
Microsoft, Charlotte, NC

Azure Architect
Brillio, Redmond, WA

Sr. Azure Data Engineer
Wolverine Worldwide, Rockford, MI

Data Scientist II
MAPFRE, Boston, MA

Staff Software Engineer, Core Engine (Seattle Area)
TigerGraph, Seattle, WA

Senior Machine Learning Scientist
Wayfair, Boston, MA

Fraud Senior Data Scientist
Bank of America, Newark, DE

Principal Database Software Engineer
JPMorgan Chase Bank, N.A., Chicago, IL

jobs by Indeed



Share this page

Featured Products

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

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.

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

Neo4j logo

Neo4j NODES 2022
Free online conference for developers and data scientists.
November 16/17 2022.
Register now for free!

Redis logo

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

Present your product here