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

DBMS > DolphinDB vs. Microsoft Azure Synapse Analytics vs. SAP Adaptive Server vs. SAP Advantage Database Server vs. Warp 10

System Properties Comparison DolphinDB vs. Microsoft Azure Synapse Analytics vs. SAP Adaptive Server vs. SAP Advantage Database Server vs. Warp 10

Editorial information provided by DB-Engines
NameDolphinDB  Xexclude from comparisonMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data Warehouse  Xexclude from comparisonSAP Adaptive Server infoformer name: Sybase ASE  Xexclude from comparisonSAP Advantage Database Server infoformer name: Sybase ADS  Xexclude from comparisonWarp 10  Xexclude from comparison
DescriptionDolphinDB is a high performance Time Series DBMS. It is integrated with an easy-to-use fully featured programming language and a high-volume high-velocity streaming analytics system. It offers operational simplicity, scalability, fault tolerance, and concurrency.Elastic, large scale data warehouse service leveraging the broad eco-system of SQL ServerThe SAP (Sybase) Adaptive Server Enterprise (ASE) is an enterprise-class RDBMSLow-cost RDBMS with access to ISAM and FoxPro data structuresTimeSeries DBMS specialized on timestamped geo data based on LevelDB or HBase
Primary database modelTime Series DBMSRelational DBMSRelational DBMSRelational DBMSTime Series DBMS
Secondary database modelsRelational DBMSSpatial DBMS infowith Boeing's Spatial Query Server
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.65
Rank#140  Overall
#9  Time Series DBMS
Score20.66
Rank#36  Overall
#22  Relational DBMS
Score47.78
Rank#25  Overall
#17  Relational DBMS
Score3.68
Rank#91  Overall
#47  Relational DBMS
Score0.18
Rank#291  Overall
#26  Time Series DBMS
Websitewww.dolphindb.comazure.microsoft.com/­services/­synapse-analyticswww.sap.com/­products/­sybase-ase.htmlwww.sap.com/­products/­advantage-database-server.htmlwww.warp10.io
Technical documentationwww.dolphindb.com/­helpdocs.microsoft.com/­azure/­synapse-analyticshelp.sap.com/­viewer/­product/­SAP_ASEwww.warp10.io/­content/­02_Getting_started
DeveloperDolphinDB, IncMicrosoftSAP, SybaseSybase, SAPSenX
Initial release20182016198719932015
Current releasev2.00.4, January 202216.0
License infoCommercial or Open Sourcecommercial infofree community version availablecommercialcommercialcommercialOpen Source infoApache License 2.0
Cloud-based only infoOnly available as a cloud servicenoyesnonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++C++C and C++Java
Server operating systemsLinux
Windows
hostedAIX
HP-UX
Linux
Solaris
Unix
Windows
Linux
Windows
Linux
OS X
Windows
Data schemeyesyesyesyesschema-free
Typing infopredefined data types such as float or dateyesyesyesyesyes
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.nonononono
Secondary indexesyesyesyesyesno
SQL infoSupport of SQLSQL-like query languageyesyesyesno
APIs and other access methodsJDBC
JSON over HTTP
Kafka
MQTT (Message Queue Telemetry Transport)
ODBC
OPC DA
OPC UA
RabbitMQ
WebSocket
ADO.NET
JDBC
ODBC
ADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
.NET Client API
ADO.NET
JDBC
ODBC
OLE DB
HTTP API
Jupyter
WebSocket
Supported programming languagesC#
C++
Go
Java
JavaScript
MatLab
Python
R
Rust
C#
Java
PHP
C
C++
Cobol
Java
Java
Perl
PHP
Python
Delphi
Perl
PHP
Server-side scripts infoStored proceduresyesTransact SQLJava and Transact-SQLyesyes infoWarpScript
Triggersnonoyesyesno
Partitioning methods infoMethods for storing different data on different nodeshorizontal partitioningSharding, horizontal partitioninghorizontal partitioningnoneSharding infobased on HBase
Replication methods infoMethods for redundantly storing data on multiple nodesyesyesMulti-source replication
Source-replica replication
Multi-source replication infoCONFLICT Trigger to resolve replication conflicts
Source-replica replication
selectable replication factor infobased on HBase
MapReduce infoOffers an API for user-defined Map/Reduce methodsyesnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyImmediate Consistency infobased on HBase
Foreign keys infoReferential integritynono infodocs.microsoft.com/­en-us/­azure/­synapse-analytics/­sql-data-warehouse/­sql-data-warehouse-table-constraintsyesyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datayesACIDACIDACIDno
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentyesyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesno infocaching of (temporary) tables can be configuredyes
User concepts infoAccess controlAdministrators, Users, Groupsyesfine grained access rights according to SQL-standardfine grained access rights according to SQL-standardMandatory use of cryptographic tokens, containing fine-grained authorizations

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
DolphinDBMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data WarehouseSAP Adaptive Server infoformer name: Sybase ASESAP Advantage Database Server infoformer name: Sybase ADSWarp 10
Recent citations in the news

DolphinDB bags $15m and 14 more deal updates from Greater China
10 December 2021, DealStreetAsia

Sequoia China, 5Y Capital back Huobanyun and 25 more deal updates
20 December 2021, DealStreetAsia

provided by Google News

Microsoft Releases Security Advisory for Azure Data Factory and Azure Synapse Pipelines | CISA
10 May 2022, US-CERT

Sponsored post: Consumers demand personalization. A unified data platform can help.
19 May 2022, TechCrunch

Leading Global Logistics Company Completes Milestone in Data Platform Modernization with Datometry
18 May 2022, PR Newswire

Vulnerability mitigated in the third-party Data Connector used in Azure Synapse pipelines and Azure Data Factory (CVE-2022-29972)
9 May 2022, IT Security News

Microsoft is piloting Azure Data Lake export use cases for Dynamics 365 Business Central
20 April 2022, MSDynamicsWorld

provided by Google News

Partners become central to SAP industry cloud business
16 May 2022, TechTarget

Critical SAP ASE Flaws Allow Complete Control of Databases
3 June 2020, Threatpost

SAP ASE leaves sensitive credentials in installation logs
24 September 2020, CSO Online

What Will Happen After End Of Support For Sybase?
17 December 2019, e3zine.com

New Services In SAP HANA Cloud Lower TCO For Customers In Data-Intensive, Highly Regulated Industries
9 April 2021, MarTech Series

provided by Google News

Job opportunities

Azure Administrator / Data Engineer
Agama Solutions, Las Vegas, NV

Product Marketing Manager, Azure Synapse Analytics
Microsoft, Redmond, WA

Support Engineer - Azure Synapse
Microsoft, Issaquah, WA

Azure Developer – Work from Home
Capgemini Government Solutions, Remote

Data Engineer - Azure
Sun Communities, Inc., Southfield, MI

Sr. Financial Analyst
Super Micro Computer, Inc., San Jose, CA

SAP Hybris Commerce Cloud Developer
Arrow Electronics, Inc., Hawi, HI

SAP Hybris Commerce Cloud Developer
Arrow Electronics, Inc., United, WV

SAP Hybris Commerce Cloud Developer
e-Infochips, Colorado

SAP Hybris Commerce Cloud Developer
Arrow Electronics, Inc., Wallingford, CT

jobs by Indeed



Share this page

Featured Products

Vertica logo

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

Neo4j logo

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

Redis logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

The definitive guide for Cassandra

Imagine What You Could Do if Scalability Wasn‘t a Problem!
Download the Cassandra e-book for free!

Present your product here