DBMS > EventStoreDB vs. IBM Db2 Event Store vs. Postgres-XL vs. SAP Adaptive Server

System Properties Comparison EventStoreDB vs. IBM Db2 Event Store vs. Postgres-XL vs. SAP Adaptive Server

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
Name	EventStoreDB  Xexclude from comparison	IBM Db2 Event Store  Xexclude from comparison	Postgres-XL  Xexclude from comparison	SAP Adaptive Server former name: Sybase ASE  Xexclude from comparison
Description	Industrial-strength, open-source database solution built from the ground up for event sourcing.	Distributed Event Store optimized for Internet of Things use cases	Based on PostgreSQL enhanced with MPP and write-scale-out cluster features	The SAP (Sybase) Adaptive Server Enterprise (ASE) is an enterprise-class RDBMS
Primary database model	Event Store	Event Store Time Series DBMS	Relational DBMS	Relational DBMS
Secondary database models			Document store Spatial DBMS	Spatial DBMS with Boeing's Spatial Query Server
DB-Engines Ranking measures the popularity of database management systems Trend Chart	Score 1.19 Rank #173   Overall #1   Event Stores	Score 0.27 Rank #309   Overall #2   Event Stores #28   Time Series DBMS	Score 0.53 Rank #254   Overall #117   Relational DBMS	Score 35.09 Rank #25   Overall #17   Relational DBMS
Website	www.eventstore.com	www.ibm.com/­products/­db2-event-store	www.postgres-xl.org	www.sap.com/­products/­technology-platform/­sybase-ase.html
Technical documentation	developers.eventstore.com	www.ibm.com/­docs/­en/­db2-event-store	www.postgres-xl.org/­documentation	help.sap.com/­docs/­SAP_ASE
Developer	Event Store Limited	IBM		SAP, Sybase
Initial release	2012	2017	2014 since 2012, originally named StormDB	1987
Current release	21.2, February 2021	2.0	10 R1, October 2018	16.0
License Commercial or Open Source	Open Source	commercial free developer edition available	Open Source Mozilla public license	commercial
Cloud-based only Only available as a cloud service	no	no	no	no
DBaaS offerings (sponsored links) Database as a Service Providers of DBaaS offerings, please contact us to be listed.
Implementation language		C and C++	C	C and C++
Server operating systems	Linux Windows	Linux Linux, macOS, Windows for the developer addition	Linux macOS	AIX HP-UX Linux Solaris Unix Windows
Data scheme		yes	yes	yes
Typing predefined data types such as float or date		yes	yes	yes
XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.		no	yes XML type, but no XML query functionality	no
Secondary indexes		no	yes	yes
SQL Support of SQL		yes through the embedded Spark runtime	yes distributed, parallel query execution	yes
APIs and other access methods		ADO.NET DB2 Connect JDBC ODBC RESTful HTTP API	ADO.NET JDBC native C library ODBC streaming API for large objects	ADO.NET JDBC ODBC OLE DB Tabular Data Stream (TDS)
Supported programming languages		C C# C++ Cobol Delphi Fortran Go Java JavaScript (Node.js) Perl PHP Python R Ruby Scala Visual Basic	.Net C C++ Delphi Erlang Java JavaScript (Node.js) Perl PHP Python Tcl	C C++ Cobol Java Java Perl PHP Python
Server-side scripts Stored procedures		yes	user defined functions	Java and Transact-SQL
Triggers		no	yes	yes
Partitioning methods Methods for storing different data on different nodes		Sharding	horizontal partitioning	horizontal partitioning
Replication methods Methods for redundantly storing data on multiple nodes		Active-active shard replication		Multi-source replication Source-replica replication
MapReduce Offers an API for user-defined Map/Reduce methods		no	no	no
Consistency concepts Methods to ensure consistency in a distributed system		Eventual Consistency	Immediate Consistency	Immediate Consistency
Foreign keys Referential integrity		no	yes	yes
Transaction concepts Support to ensure data integrity after non-atomic manipulations of data		no	ACID MVCC	ACID
Concurrency Support for concurrent manipulation of data		No - written data is immutable	yes	yes
Durability Support for making data persistent		Yes - Synchronous writes to local disk combined with replication and asynchronous writes in parquet format to permanent shared storage	yes	yes
In-memory capabilities Is there an option to define some or all structures to be held in-memory only.		yes	no
User concepts Access control		fine grained access rights according to SQL-standard	fine grained access rights according to SQL-standard	fine 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
	EventStoreDB	IBM Db2 Event Store	Postgres-XL	SAP Adaptive Server former name: Sybase ASE
Recent citations in the news		Advancements in streaming data storage, real-time analysis and machine learning 25 July 2019, ibm.com IBM Builds New Ultra-Fast Platform for Hoovering Up and Analyzing Data from Anywhere 31 May 2018, Data Center Knowledge How IBM Is Turning Db2 into an 'AI Database' 3 June 2019, Datanami Best cloud databases of 2022 4 October 2022, ITPro provided by Google News		Achieve zero RPO for your SAP ASE (Sybase) databases with Amazon FSx for NetApp ONTAP | Amazon Web Services 7 May 2024, AWS Blog New Services for SAP HANA Cloud Database 7 April 2021, SAP News Install latest SAP Adaptive Server Enterprise patches, experts urge 3 June 2020, CSO Online Patch SAP Adaptive Server Enterprise now to avoid takeover risk 3 June 2020, BleepingComputer AWS Launch Wizard is now available in Melbourne, Spain, and Zurich Regions 26 January 2024, AWS Blog provided by Google News

Share this page