DB-EnginesInfluxDB download bannerEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > EXASOL vs. Microsoft Azure Synapse Analytics vs. NCache vs. SAP Adaptive Server

System Properties Comparison EXASOL vs. Microsoft Azure Synapse Analytics vs. NCache vs. SAP Adaptive Server

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameEXASOL  Xexclude from comparisonMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data Warehouse  Xexclude from comparisonNCache  Xexclude from comparisonSAP Adaptive Server infoformer name: Sybase ASE  Xexclude from comparison
DescriptionHigh-performance, in-memory, MPP database specifically designed for in-memory analytics.Elastic, large scale data warehouse service leveraging the broad eco-system of SQL ServerNCache is a 100% .NET / .NET Core Open Source in-memory distributed cache.The SAP (Sybase) Adaptive Server Enterprise (ASE) is an enterprise-class RDBMS
Primary database modelRelational DBMSRelational DBMSKey-value storeRelational DBMS
Secondary database modelsDocument store
Search engine infoUsing distributed Lucene
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score3.42
Rank#93  Overall
#46  Relational DBMS
Score8.69
Rank#49  Overall
#30  Relational DBMS
Score1.08
Rank#163  Overall
#28  Key-value stores
Score54.61
Rank#18  Overall
#12  Relational DBMS
Websitewww.exasol.comazure.microsoft.com/­services/­synapse-analyticswww.alachisoft.com/­ncachewww.sap.com/­products/­sybase-ase.html
Technical documentationwww.exasol.com/­resourcesdocs.microsoft.com/­azure/­synapse-analyticswww.alachisoft.com/­resources/­docshelp.sap.com/­viewer/­product/­SAP_ASE
DeveloperExasolMicrosoftAlachisoftSAP, Sybase
Initial release2000201620051987
Current release5.0, May 201916.0
License infoCommercial or Open SourcecommercialcommercialOpen Source infoEnterprise Edition availablecommercial
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 languageC++C#, .NET, .NET CoreC and C++
Server operating systemshostedLinux
Windows
AIX
HP-UX
Linux
Solaris
Unix
Windows
Data schemeyesyesschema-freeyes
Typing infopredefined data types such as float or dateyesyespartial infoSupported data types are Lists, Queues, Hashsets, Dictionary and Counteryes
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 indexesyesyesyesyes
SQL infoSupport of SQLyesyesSQL-like query syntax and LINQ for searching the cache. Cache Synchronization with SQL Server using SQL dependency.yes
APIs and other access methods.Net
JDBC
ODBC
WebSocket
ADO.NET
JDBC
ODBC
IDistributedCache
JCache
LINQ
Proprietary native API
ADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
Supported programming languagesJava
Lua
Python
R
C#
Java
PHP
.Net
.Net Core
C#
Java
Visual Basic.NET
C
C++
Cobol
Java
Java
Perl
PHP
Python
Server-side scripts infoStored proceduresuser defined functionsTransact SQLno infosupport for stored procedures with SQL-Server CLRJava and Transact-SQL
Triggersyesnoyes infoNotificationsyes
Partitioning methods infoMethods for storing different data on different nodesShardingSharding, horizontal partitioningyeshorizontal partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesyesyes, with selectable consistency levelMulti-source replication
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsyes infoHadoop integrationnoyesno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyEventual Consistency
Immediate Consistency
Strong Eventual Consistency over WAN with Conflict Resolution using Bridge Topology
Immediate Consistency
Foreign keys infoReferential integrityyesyesnoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDoptimistic locking and pessimistic lockingACID
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.yesyes
User concepts infoAccess controlAccess rights for users, groups and roles according to SQL-standardyesAuthentication to access the cache via Active Directory/LDAP (possible roles: user, administrator)fine grained access rights according to SQL-standard
More information provided by the system vendor
EXASOLMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data WarehouseNCacheSAP Adaptive Server infoformer name: Sybase ASE
Specific characteristicsNCache has been the market leader in .NET Distributed Caching since 2005 . NCache...
» more
Competitive advantagesNCache is 100% .NET/ .NET Core based which fully supports ASP.NET Core Sessions ,...
» more
Typical application scenariosNCache enables industries like retail, finance, banking IoT, travel, ecommerce, healthcare...
» more
Key customersBank of America, Citi, Natures Way, Charter Spectrum, Barclays, Henry Schein, GBM,...
» more
Market metricsMarket Leader in .NET Distributed Caching since 2005.
» more
Licensing and pricing modelsNCache Open Source is free on an as-is basis without any support. NCache Enterprise...
» more
News

Try NCache Live without Download and Setup
22 January 2021

Create Read Intensive Applications using NCache
28 December 2020

Remote Monitoring of Cache Clusters with NCache
21 December 2020

Keep your Cache in Sync with PostgreSQL
21 December 2020

Backup and Restore your Data with NCache
15 December 2020

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
EXASOLMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data WarehouseNCacheSAP Adaptive Server infoformer name: Sybase ASE
Recent citations in the news

Dubai-based VAD Technologies, Exasol team up to empower Middle East firms with analytics
21 January 2021, ITP.net

Exasol and VAD Technologies partner on analytics solutions
20 January 2021, Tahawul Tech

Main Memory Database System Market Witness High Growth And Manufacturing Analysis By 2027| SAP, MenSQL, EXASOL
20 January 2021, Reviewindependent

2021 Trending Now: Main Memory Database System Market Estimated To Experience A Hike in Growth | Global Industry Size, Growth, Segments, Revenue, Manufacturers| SAP, MenSQL, EXASOL, Oracle
22 January 2021, Jumbo News

Augmented data preparation the next step for self-service BI
21 January 2021, TechTarget

provided by Google News

These Microsoft Azure tools can help you unlock the secrets lurking in your business data
18 January 2021, TechRepublic

Quorum announces re-platforming of data resources on Microsoft Azure to enable the future delivery of advanced analytics and artificial intelligence Project will provide additional value and scale to Quorum's popular Q Analytics Enterprise Reporting solution
19 January 2021, Financial Post

Microsoft Previews New Azure Purview Data Governance Service, Goes Live with Azure Synapse Analytics
3 December 2020, Redmondmag.com

Synapse Analytics Spark Example 1 – Group By from Blog Posts – SQLServerCentral
19 January 2021, Packt Hub

Microsoft Azure Synapse Aims to Ease Data Collaboration With Latest Features
9 October 2020, CMSWire

provided by Google News

Custom Response Caching Using NCache in ASP.NET Core
22 April 2020, InfoQ.com

How to use NCache in ASP.Net Core
25 February 2019, InfoWorld

NCache Distributed Cache for .NET Gets Open Sourced
28 January 2015, Visual Studio Magazine

Basic NCache is Now Open Source
10 March 2015, InfoQ.com

Velocity: Microsoft's Distributed In-Memory Cache
4 June 2008, InfoQ.com

provided by Google News

Install latest SAP Adaptive Server Enterprise patches, experts urge
3 June 2020, CSO Online

A closer look at SAP HANA Cloud
19 January 2021, ZDNet

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

Critical SAP Sybase ASE bugs allowed full system takeover
4 June 2020, iTnews

Survey Reveals Strategic Plans of SAP Sybase and ASE Customers as Product Support Nears End
10 October 2019, PRNewswire

provided by Google News

Job opportunities

Help Desk Specialist - Atlanta
Exasol, Atlanta, GA

Senior Product Designer
Exasol, San Francisco, CA

HR Manager
Exasol, San Francisco, CA

Account Executive, US
Exasol, United States

Database Administrator
Trilliant, Cary, NC

Azure Data Engineer (Minimum 2 years experience)
Nuvento Systems LLC, Remote

Business Intelligence Analyst
Bluetooth SIG, Inc., Kirkland, WA

SENIOR ANALYTICS RESOURCE
Fully Staffed, Atlanta, GA

Customer Engineer, Azure Data & AI
Microsoft, United States

Azure Datawarehouse Power BI Architect
Saisystems Technology, Remote

Inside Sales & Biz Dev
Alachisoft, Dallas, TX

Sr. Technology Marketing & Biz Dev Executive
Alachisoft, Dallas, TX

Enterprise Software Sales Executive
Alachisoft, Dallas, TX

Technical Project Manager
Alachisoft, Dallas, TX

Director of Enterprise Sales
Alachisoft, Dallas, TX

Financial Analyst
NCA - NEC Corporation of America, Rancho Cordova, CA

Senior SAP ASE Database Administrator
Versa Integrated Solutions, Calverton, MD

Senior SAP ASE Database Administrator
Buchanan & Edwards, Austin, TX

ERP Implementation Consultant
Acumatica, Westerville, OH

Cloud Engineer
BlueCat Networks, United States

jobs by Indeed




Share this page

Featured Products

Couchbase logo

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

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..

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

AllegroGraph logo

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

Neo4j logo

Get your free copy of the new O'Reilly book Graph Algorithms with 20+ examples for
machine learning, graph analytics and more.

Present your product here