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 > Heroic vs. Microsoft Azure Synapse Analytics vs. SAP Advantage Database Server vs. ScyllaDB

System Properties Comparison Heroic vs. Microsoft Azure Synapse Analytics vs. SAP Advantage Database Server vs. ScyllaDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameHeroic  Xexclude from comparisonMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data Warehouse  Xexclude from comparisonSAP Advantage Database Server infoformer name: Sybase ADS  Xexclude from comparisonScyllaDB  Xexclude from comparison
DescriptionTime Series DBMS built at Spotify based on Cassandra or Google Cloud Bigtable, and ElasticSearchElastic, large scale data warehouse service leveraging the broad eco-system of SQL ServerLow-cost RDBMS with access to ISAM and FoxPro data structuresCassandra and DynamoDB compatible wide column store
Primary database modelTime Series DBMSRelational DBMSRelational DBMSKey-value store
Wide column store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.15
Rank#304  Overall
#26  Time Series DBMS
Score15.75
Rank#40  Overall
#24  Relational DBMS
Score3.88
Rank#85  Overall
#47  Relational DBMS
Score3.17
Rank#92  Overall
#15  Key-value stores
#8  Wide column stores
Websitespotify.github.io/­heroic/­#!/­indexazure.microsoft.com/­services/­synapse-analyticswww.sap.com/­products/­advantage-database-server.htmlwww.scylladb.com
Technical documentationspotify.github.io/­heroic/­#!/­docs/­overviewdocs.microsoft.com/­azure/­synapse-analyticsdocs.scylladb.com
DeveloperSpotifyMicrosoftSybase, SAPScyllaDB
Initial release2014201619932015
Current releaseScylla Open Source 4.3, January 2021
License infoCommercial or Open SourceOpen Source infoApache 2.0commercialcommercialOpen Source infoOpen Source (AGPL), commercial license available
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.
Scylla Cloud: Create real-time applications that run at global scale with Scylla Cloud, the industry’s most powerful NoSQL DBaaS
Implementation languageJavaC++C++
Server operating systemshostedLinux
Windows
Linux
Data schemeschema-freeyesyesschema-free
Typing infopredefined data types such as float or dateyesyesyesyes
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 indexesyes infovia Elasticsearchyesyesyes infocluster global secondary indices
SQL infoSupport of SQLnoyesyesSQL-like DML and DDL statements (CQL)
APIs and other access methodsHQL (Heroic Query Language, a JSON-based language)
HTTP API
ADO.NET
JDBC
ODBC
.NET Client API
ADO.NET
JDBC
ODBC
OLE DB
Proprietary protocol (CQL) infocompatible with CQL (Cassandra Query Language, an SQL-like language)
RESTful HTTP API (DynamoDB compatible)
Thrift
Supported programming languagesC#
Java
PHP
Delphi
Perl
PHP
For CQL interface: C#, C++, Clojure, Erlang, Go, Haskell, Java, JavaScript, Node.js, Perl, PHP, Python, Ruby, Rust, Scala
For DynamoDB interface: .Net, ColdFusion, Erlang, Groovy, Java, JavaScript, Perl, PHP, Python, Ruby
Server-side scripts infoStored proceduresnoTransact SQLyesyes, Lua
Triggersnonoyesno
Partitioning methods infoMethods for storing different data on different nodesShardingSharding, horizontal partitioningnoneSharding
Replication methods infoMethods for redundantly storing data on multiple nodesyesyesMulti-source replication infoCONFLICT Trigger to resolve replication conflicts
Source-replica replication
selectable replication factor infoRepresentation of geographical distribution of servers is possible
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Immediate Consistency
Immediate ConsistencyImmediate ConsistencyEventual Consistency
Tunable Consistency infocan be individually decided for each write operation
Foreign keys infoReferential integritynono infodocs.microsoft.com/­en-us/­azure/­synapse-analytics/­sql-data-warehouse/­sql-data-warehouse-table-constraintsyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACIDACIDno infoAtomicity and isolation are supported for single operations
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 infocaching of (temporary) tables can be configuredyes infoin-memory tables
User concepts infoAccess controlyesfine grained access rights according to SQL-standardAccess rights for users can be defined per object
More information provided by the system vendor
HeroicMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data WarehouseSAP Advantage Database Server infoformer name: Sybase ADSScyllaDB
Specific characteristicsScylla is a highly-available, highly-scalable, highly-performant NoSQL database....
» more
Competitive advantagesHighly-performant (efficiently utilizes full resources of a node and network; millions...
» more
Typical application scenariosAdTech ( AdGear , AppMonet , Dstillery , FullContact , MediaMath , Numberly , SAS...
» more
Key customersComcast, Grab, OlaCabs, Yahoo! Japan, IMVU, Adgear, Xandr, Zenly, Natura, Snapfish,...
» more
Licensing and pricing modelsScylla Open Source - free open source software (AGPL) Scylla Enterprise - subscription-based...
» 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
HeroicMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data WarehouseSAP Advantage Database Server infoformer name: Sybase ADSScyllaDB
Conferences and events

Scylla Virtual Workshop
Interactive Session, 10 AM ET / 11 AM BRT / 3 PM BST, 23 July 2021

Scylla University LIVE (EMEA and APAC)
12PM-4PM GMT / 2PM-6PM CEST / 5:30PM-9:30PM IST, 28 July 2021

Scylla University LIVE (AMERICAS)
9AM-1PM PT / 12PM-4PM ET / 1PM-5PM BRT, 29 July 2021

Recent citations in the news

Review: Google Bigtable scales with ease
7 September 2016, InfoWorld

provided by Google News

Microsoft Azure receives new features and enhanced migration services
14 July 2021, VentureBeat

Highlights of Microsoft Inspire 2021, Satya Nadella's Microsoft Cloud Keynote
23 July 2021, IDM.net.au

Five Practical Tips to Limitless Data Integration Using Azure Data Factory - Microsoft
8 July 2021, Channel 9

Qlik Recognized as a Finalist of 2021 Microsoft Analytics Partner of the Year Award
8 July 2021, The Bakersfield Californian

New intelligent data management cloud on azure bolsters cloud momentum in Europe
21 July 2021, VanillaPlus

provided by Google News

Depression and Alcoholism: Five Tips for Recovery
17 December 2020, PsychCentral.com

provided by Google News

There's a NoSQL Database for That
22 July 2021, Datanami

Maitri Health Technologies Chooses ScyllaDB to Scale Big Data Health-Tech Platform
24 June 2021, PRNewswire

ScyllaDB Announces Scylla Enterprise 2021 NoSQL Database
20 May 2021, GlobeNewswire

ScyllaDB Unveils 'Monstrous' New Capabilities for Its NoSQL
12 January 2021, GlobeNewswire

ScyllaDB Announces Scylla Enterprise 2020 NoSQL Database
19 August 2020, GlobeNewswire

provided by Google News

Job opportunities

Azure Data Engineer- Synapse & ADF
nFolks Ltd, Dallas, TX

Azure Project Manager
Orion Inc., Woodcliff Lake, NJ

Azure Data Engineer
Keasis Inc., Las Vegas, NV

Sr MS Azure Developer
Scientiam Technologies, Remote

Azure Data Engineer
Avancer Corporation, Remote

Developer Advocate
ScyllaDB, California

Senior Systems Engineer
SpotX, Broomfield, CO

Field Engineer (USA or Remote)
ScyllaDB, Remote

Digital Solutions Senior Platform Engineer
MidAmerican Energy, Las Vegas, NV

Senior Infrastructure Engineer (Remote CA, NY, TX)
OneSignal, San Mateo, CA

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 5 GB free..

Couchbase logo

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

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

Present your product here