DB-EnginesextremeDB - Data management wherever you need itEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

DBMS > AlaSQL vs. EXASOL vs. IBM Db2 Event Store vs. Oracle vs. SAP SQL Anywhere

System Properties Comparison AlaSQL vs. EXASOL vs. IBM Db2 Event Store vs. Oracle vs. SAP SQL Anywhere

Editorial information provided by DB-Engines
NameAlaSQL  Xexclude from comparisonEXASOL  Xexclude from comparisonIBM Db2 Event Store  Xexclude from comparisonOracle  Xexclude from comparisonSAP SQL Anywhere infoformerly called Adaptive Server Anywhere  Xexclude from comparison
DescriptionJavaScript DBMS libraryHigh-performance, in-memory, MPP database specifically designed for in-memory analytics.Distributed Event Store optimized for Internet of Things use casesWidely used RDBMSRDBMS database and synchronization technologies for server, desktop, remote office, and mobile environments
Primary database modelDocument store
Relational DBMS
Relational DBMSEvent Store
Time Series DBMS
Relational DBMSRelational DBMS
Secondary database modelsDocument store
Graph DBMS infowith Oracle Spatial and Graph
RDF store infowith Oracle Spatial and Graph
Spatial DBMS infowith Oracle Spatial and Graph
Vector DBMS infosince Oracle 23
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.35
Rank#268  Overall
#42  Document stores
#123  Relational DBMS
Score1.52
Rank#140  Overall
#63  Relational DBMS
Score0.17
Rank#316  Overall
#2  Event Stores
#26  Time Series DBMS
Score1254.82
Rank#1  Overall
#1  Relational DBMS
Score2.87
Rank#88  Overall
#48  Relational DBMS
Websitealasql.orgwww.exasol.comwww.ibm.com/­products/­db2-event-storewww.oracle.com/­databasewww.sap.com/­products/­technology-platform/­sql-anywhere.html
Technical documentationgithub.com/­AlaSQL/­alasqlwww.exasol.com/­resourceswww.ibm.com/­docs/­en/­db2-event-storedocs.oracle.com/­en/­databasehelp.sap.com/­docs/­SAP_SQL_Anywhere
DeveloperAndrey Gershun & Mathias R. WulffExasolIBMOracleSAP infoformerly Sybase
Initial release20142000201719801992
Current release2.023c, September 202317, July 2015
License infoCommercial or Open SourceOpen Source infoMIT-Licensecommercialcommercial infofree developer edition availablecommercial inforestricted free version is availablecommercial
Cloud-based only infoOnly available as a cloud servicenonononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaScriptC and C++C and C++
Server operating systemsserver-less, requires a JavaScript environment (browser, Node.js)Linux infoLinux, macOS, Windows for the developer additionAIX
HP-UX
Linux
OS X
Solaris
Windows
z/OS
AIX
HP-UX
Linux
OS X
Solaris
Windows
Data schemeschema-freeyesyesyes infoSchemaless in JSON and XML columnsyes
Typing infopredefined data types such as float or datenoyesyesyesyes
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.nononoyesyes
Secondary indexesnoyesnoyesyes
SQL infoSupport of SQLClose to SQL99, but no user access control, stored procedures and host language bindings.yesyes infothrough the embedded Spark runtimeyes infowith proprietary extensionsyes
APIs and other access methodsJavaScript API.Net
JDBC
ODBC
WebSocket
ADO.NET
DB2 Connect
JDBC
ODBC
RESTful HTTP API
JDBC
ODBC
ODP.NET
Oracle Call Interface (OCI)
ADO.NET
HTTP API
JDBC
ODBC
Supported programming languagesJavaScriptJava
Lua
Python
R
C
C#
C++
Cobol
Delphi
Fortran
Go
Java
JavaScript (Node.js)
Perl
PHP
Python
R
Ruby
Scala
Visual Basic
C
C#
C++
Clojure
Cobol
Delphi
Eiffel
Erlang
Fortran
Groovy
Haskell
Java
JavaScript
Lisp
Objective C
OCaml
Perl
PHP
Python
R
Ruby
Scala
Tcl
Visual Basic
C
C#
C++
Delphi
Java
JavaScript (Node.js)
Perl
PHP
Python
Ruby
Server-side scripts infoStored proceduresnouser defined functionsyesPL/SQL infoalso stored procedures in Java possibleyes, in C/C++, Java, .Net or Perl
Triggersyesyesnoyesyes
Partitioning methods infoMethods for storing different data on different nodesnoneShardingShardingSharding, horizontal partitioningnone
Replication methods infoMethods for redundantly storing data on multiple nodesnoneActive-active shard replicationMulti-source replication
Source-replica replication
Source-replica replication infoDatabase mirroring
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyes infoHadoop integrationnono infocan be realized in PL/SQLno
Consistency concepts infoMethods to ensure consistency in a distributed systemnoneImmediate ConsistencyEventual ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesyesnoyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datayes infoonly for local storage and DOM-storageACIDnoACID infoisolation level can be parameterizedACID
Concurrency infoSupport for concurrent manipulation of datayesNo - written data is immutableyesyes
Durability infoSupport for making data persistentyes infoby using IndexedDB, SQL.JS or proprietary FileStorageyesYes - Synchronous writes to local disk combined with replication and asynchronous writes in parquet format to permanent shared storageyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesyesyes infoVersion 12c introduced the new option 'Oracle Database In-Memory'yes
User concepts infoAccess controlnoAccess rights for users, groups and roles according to SQL-standardfine grained access rights according to SQL-standardfine grained access rights according to SQL-standardfine grained access rights according to SQL-standard

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
AlaSQLEXASOLIBM Db2 Event StoreOracleSAP SQL Anywhere infoformerly called Adaptive Server Anywhere
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

Architecting eCommerce Platforms for Zero Downtime on Black Friday and Beyond
25 November 2016, Tony Branson (guest author)

show all

Recent citations in the news

Scrape any Website/Service/API with a single SQL Select Statement
18 January 2017, hackernoon.com

provided by Google News

WashTec: Data Analytics for optimizing car wash systems.
27 May 2024, All-About-Industries

Exasol Accelerates Customers’ Migration to Cloud with Support of AWS SaaS Factory
4 February 2022, AWS Blog

Exasol: 93% say data storytelling helps increase revenue
13 July 2021, VentureBeat

Many employees still resist data-driven culture
31 March 2020, TechTarget

Exasol Appoints Jan-Dirk Henrich as Chief Financial Officer
14 June 2021, citybiz

provided by Google News

Oracle and Google Cloud Expand Regional Availability and Add Powerful New Capabilities to Oracle Database@Google Cloud
30 January 2025, oracle.com

Oracle Database@AWS Available in Limited Preview
2 December 2024, oracle.com

Oracle Database@Azure Adds New Regions and Services to Meet Global Demand
19 November 2024, oracle.com

Larry Ellison wants to put all America's data, including DNA, in one big Oracle system for AI to study
12 February 2025, The Register

Multicloud strategies help enterprises improve workload optimisation: Oracle - Cloud - Data and Analytics
18 February 2025, iTnews Asia

provided by Google News

Rimini Street expands support beyond SAP and Oracle
11 June 2022, InsideSAP

Securing SAP with AWS Network Firewall: Part 2 – Managed Rules
17 July 2023, AWS Blog

SAP vulnerabilities Let Attacker Inject OS Commands—Patch Now!
11 July 2023, CybersecurityNews

Gartner’s Magic Quadrant for Cloud Database Management Systems
9 December 2020, CRN

Data Integration Tools – Market Study
21 October 2016, Data Science Central

provided by Google News



Share this page

Featured Products

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB for free.

Neo4j logo

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

SingleStore logo

The data platform to build your intelligent applications.
Try it free.

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

Present your product here