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 > EDB Postgres vs. Kdb vs. Microsoft Azure Synapse Analytics vs. SAP Advantage Database Server vs. YugabyteDB

System Properties Comparison EDB Postgres vs. Kdb vs. Microsoft Azure Synapse Analytics vs. SAP Advantage Database Server vs. YugabyteDB

Editorial information provided by DB-Engines
NameEDB Postgres  Xexclude from comparisonKdb  Xexclude from comparisonMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data Warehouse  Xexclude from comparisonSAP Advantage Database Server infoformer name: Sybase ADS  Xexclude from comparisonYugabyteDB  Xexclude from comparison
SAP Advantage Database Server seems to be discontinued. Therefore it is excluded from the DB-Engines Ranking.
DescriptionThe EDB Postgres Platform is an enterprise-class data management platform based on the open source database PostgreSQL with flexible deployment options and Oracle compatibility features, complemented by tool kits for management, integration, and migration.High performance Time Series DBMSElastic, large scale data warehouse service leveraging the broad eco-system of SQL ServerLow-cost RDBMS with access to ISAM and FoxPro data structuresHigh-performance distributed SQL database for global, internet-scale applications. Wire and feature compatible with PostgreSQL.
Primary database modelRelational DBMSTime Series DBMS
Vector DBMS
Relational DBMSRelational DBMSRelational DBMS
Secondary database modelsDocument store
Spatial DBMS
Relational DBMSDocument store
Wide column store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.90
Rank#135  Overall
#63  Relational DBMS
Score7.55
Rank#53  Overall
#3  Time Series DBMS
#1  Vector DBMS
Score20.56
Rank#31  Overall
#19  Relational DBMS
Score2.91
Rank#102  Overall
#51  Relational DBMS
Websitewww.enterprisedb.comkx.comazure.microsoft.com/­services/­synapse-analyticswww.sap.com/products/advantage-database-server.htmlwww.yugabyte.com
Technical documentationwww.enterprisedb.com/­docscode.kx.comdocs.microsoft.com/­azure/­synapse-analyticsdocs.yugabyte.com
github.com/­yugabyte/­yugabyte-db
DeveloperEnterpriseDBKx Systems, a division of First Derivatives plcMicrosoftSybase, SAPYugabyte Inc.
Initial release20052000 infokdb was released 2000, kdb+ in 2003201619932017
Current release14, December 20213.6, May 20182.19, September 2023
License infoCommercial or Open Sourcecommercial infoBSD for PostgreSQL-componentscommercial infofree 32-bit versioncommercialcommercialOpen Source infoApache 2.0
Cloud-based only infoOnly available as a cloud servicenonoyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
YugabyteDB Managed is the fully managed database-as-a-service offering of YugabyteDB. Get started quickly, and effortlessly ensure continuous availability and limitless scale of your cloud native applications.
Implementation languageCqC++C and C++
Server operating systemsLinux
Windows
Linux
OS X
Solaris
Windows
hostedLinux
Windows
Linux
OS X
Data schemeyesyesyesyesdepending on used data model
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.yes infospecific XML-type available, but no XML query functionality.yesnonono
Secondary indexesyesyes infotable attribute 'grouped'yesyesyes
SQL infoSupport of SQLyes infostandard with numerous extensionsSQL-like query language (q)yesyesyes, PostgreSQL compatible
APIs and other access methodsADO.NET
JDBC
native C library
ODBC
streaming API for large objects
HTTP API
JDBC
Jupyter
Kafka
ODBC
WebSocket
ADO.NET
JDBC
ODBC
.NET Client API
ADO.NET
JDBC
ODBC
OLE DB
JDBC
YCQL, an SQL-based flexible-schema API with its roots in Cassandra Query Language
YSQL - a fully relational SQL API that is wire compatible with the SQL language in PostgreSQL
Supported programming languages.Net
C
C++
Delphi
Java
Perl
PHP
Python
Tcl
C
C#
C++
Go
J
Java
JavaScript
Lua
MatLab
Perl
PHP
Python
R
Scala
C#
Java
PHP
Delphi
Perl
PHP
C
C#
C++
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
Rust
Scala
Server-side scripts infoStored proceduresuser defined functions inforealized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.user defined functionsTransact SQLyesyes infosql, plpgsql, C
Triggersyesyes infowith viewsnoyesyes
Partitioning methods infoMethods for storing different data on different nodeshorizontal partitioning infoby hash, list or rangehorizontal partitioningSharding, horizontal partitioningnoneHash and Range Sharding, row-level geo-partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replicationSource-replica replicationyesMulti-source replication infoCONFLICT Trigger to resolve replication conflicts
Source-replica replication
Based on Raft distributed consensus protocol, minimum 3 replicas for continuous availability
MapReduce infoOffers an API for user-defined Map/Reduce methodsnono infosimilar paradigm used for internal processingnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyStrong consistency on writes and tunable consistency on reads
Foreign keys infoReferential integrityyesyesno infodocs.microsoft.com/­en-us/­azure/­synapse-analytics/­sql-data-warehouse/­sql-data-warehouse-table-constraintsyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnoACIDACIDDistributed ACID with Serializable & Snapshot Isolation. Inspired by Google Spanner architecture.
Concurrency infoSupport for concurrent manipulation of datayes, multi-version concurrency control (MVCC)yesyesyesyes
Durability infoSupport for making data persistentyesyesyesyesyes infobased on RocksDB
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyesno infocaching of (temporary) tables can be configuredno
User concepts infoAccess controlfine grained access rights according to SQL-standardrights management via user accountsyesfine grained access rights according to SQL-standardyes
More information provided by the system vendor
EDB PostgresKdbMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data WarehouseSAP Advantage Database Server infoformer name: Sybase ADSYugabyteDB
Specific characteristicsIntegrated columnar database & programming system for streaming, real time and historical...
» more
YugabyteDB is an open source distributed SQL database for cloud native transactional...
» more
Competitive advantagesprovides seamless scalability; runs on industry standard server platforms; is top-ranked...
» more
PostgreSQL compatible: Get instantly productive with a PostgreSQL compatible RDBMS....
» more
Typical application scenariostick database streaming sensor data massive intelligence applications oil and gas...
» more
Systems of record and engagement for cloud native applications that require resilience,...
» more
Key customersGoldman Sachs Morgan Stanley Merrill Lynch J.P. Morgan Deutsche Bank IEX Securities...
» more
Market metricskdb+ performance and reliability proven by our customers in critical infrastructure...
» more
2 Million+ lifetime clusters deployed, 6.5K+ GitHub stars, 7K YugabyteDB Community...
» more
Licensing and pricing modelsupon request
» more
Apache 2.0 license for the database
» 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
EDB PostgresKdbMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data WarehouseSAP Advantage Database Server infoformer name: Sybase ADSYugabyteDB
Recent citations in the news

EDB unveils EDB Postgres AI
23 May 2024, InfoWorld

Enterprise DB begins rolling AI features into PostgreSQL
23 May 2024, SiliconANGLE News

EDB Postgres AI is a new platform for analytics workloads
23 May 2024, Techzine Europe

Nutanix partners with EDB to fit database service for AI – Blocks and Files
21 May 2024, Blocks & Files

EDB Celebrates 20 Years with Launch of its Innovative Postgres AI Platform
23 May 2024, Travel And Tour World

provided by Google News

Turbocharging the Engine: KX Unleashes AI-First Transformation with kdb+
28 February 2024, Business Wire

McLaren Applied and KX partner to enhance ATLAS software analytics capabilities
9 August 2023, Professional Motorsport World

Introducing Amazon FinSpace with Managed kdb Insights, a fully managed analytics engine, commonly used by capital ...
18 May 2023, AWS Blog

KX ANNOUNCES KDB INSIGHTS AS FULLY MANAGED SERVICE ON AMAZON FINSPACE
18 May 2023, PR Newswire

KX Brings the Power and Performance of kdb+ to Python Developers with PyKX
7 June 2023, Datanami

provided by Google News

Migrate Microsoft Azure Synapse Analytics to Amazon Redshift using AWS SCT | Amazon Web Services
18 October 2023, AWS Blog

Azure Synapse Runtime for Apache Spark 3.2 End of Support | Azure updates
22 March 2024, Microsoft

Azure Synapse Analytics: Everything you need to know about Microsoft's cloud analytics platform
24 September 2023, DataScientest

Azure Synapse vs. Databricks: Data Platform Comparison 2024
26 March 2024, eWeek

Azure Synapse Link for Cosmos DB: New Analytics Capabilities
10 November 2023, InfoQ.com

provided by Google News

SAP Announces Q3 2023 Results: Asia Pacific and Japan View
19 October 2023, SAP News

AIRWORLD PART 15: WORLD'S SECOND BEST AIRPORT TERMINAL
30 September 2005, Ad Age

provided by Google News

YugabyteDB Becomes First Distributed SQL Database Vendor to Complete CIS Benchmark
1 February 2024, Datanami

Yugabyte Achieves PCI DSS Level 1 Compliance, Validating Secure and Scalable Distributed PostgreSQL for ...
14 March 2024, businesswire.com

The surprising link between Formula One and enterprise PostgreSQL optimisation
28 March 2024, The Stack

Yugabyte Embraces 'No Downtime, No Limits,' as the Theme of the Upcoming Distributed SQL Summit Asia
18 April 2024, businesswire.com

Can Yugabyte Become The Defacto Database For Large-Scale, Cloud Native Applications?
19 May 2022, Forbes

provided by Google News



Share this page

Featured Products

RaimaDB logo

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

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

Milvus logo

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

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