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. Microsoft Azure Synapse Analytics vs. RocksDB vs. Tarantool

System Properties Comparison EDB Postgres vs. Microsoft Azure Synapse Analytics vs. RocksDB vs. Tarantool

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameEDB Postgres  Xexclude from comparisonMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data Warehouse  Xexclude from comparisonRocksDB  Xexclude from comparisonTarantool  Xexclude from comparison
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.Elastic, large scale data warehouse service leveraging the broad eco-system of SQL ServerEmbeddable persistent key-value store optimized for fast storage (flash and RAM)In-memory computing platform with a flexible data schema for efficiently building high-performance applications
Primary database modelRelational DBMSRelational DBMSKey-value storeDocument store
Key-value store
Relational DBMS
Secondary database modelsDocument store
Spatial DBMS
Spatial DBMS infowith Tarantool/GIS extension
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.91
Rank#130  Overall
#60  Relational DBMS
Score19.93
Rank#31  Overall
#19  Relational DBMS
Score3.41
Rank#86  Overall
#11  Key-value stores
Score1.67
Rank#143  Overall
#25  Document stores
#25  Key-value stores
#65  Relational DBMS
Websitewww.enterprisedb.comazure.microsoft.com/­services/­synapse-analyticsrocksdb.orgwww.tarantool.io
Technical documentationwww.enterprisedb.com/­docsdocs.microsoft.com/­azure/­synapse-analyticsgithub.com/­facebook/­rocksdb/­wikiwww.tarantool.io/­en/­doc
DeveloperEnterpriseDBMicrosoftFacebook, Inc.VK
Initial release2005201620132008
Current release14, December 20219.2.1, May 20242.10.0, May 2022
License infoCommercial or Open Sourcecommercial infoBSD for PostgreSQL-componentscommercialOpen Source infoBSDOpen Source infoBSD-2, source-available extensions (modules), commercial licenses for Tarantool Enterprise
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 languageCC++C++C and C++
Server operating systemsLinux
Windows
hostedLinuxBSD
Linux
macOS
Data schemeyesyesschema-freeFlexible data schema: relational definition for tables with ability to store json-like documents in columns
Typing infopredefined data types such as float or dateyesyesnostring, double, decimal, uuid, integer, blob, boolean, datetime
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.nonono
Secondary indexesyesyesnoyes
SQL infoSupport of SQLyes infostandard with numerous extensionsyesnoFull-featured ANSI SQL support
APIs and other access methodsADO.NET
JDBC
native C library
ODBC
streaming API for large objects
ADO.NET
JDBC
ODBC
C++ API
Java API
Open binary protocol
Supported programming languages.Net
C
C++
Delphi
Java
Perl
PHP
Python
Tcl
C#
Java
PHP
C
C++
Go
Java
Perl
Python
Ruby
C
C#
C++
Erlang
Go
Java
JavaScript
Lua
Perl
PHP
Python
Rust
Server-side scripts infoStored proceduresuser defined functions inforealized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.Transact SQLnoLua, C and SQL stored procedures
Triggersyesnoyes, before/after data modification events, on replication events, client session events
Partitioning methods infoMethods for storing different data on different nodeshorizontal partitioning infoby hash, list or rangeSharding, horizontal partitioninghorizontal partitioningSharding, partitioned with virtual buckets by user defined affinity key. Live resharding for scale up and scale down without maintenance downtime.
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replicationyesyesAsynchronous replication with multi-master option
Configurable replication topology (full-mesh, chain, star)
Synchronous quorum replication (with Raft)
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyCasual consistency across sharding partitions
Eventual consistency within replicaset partition infowhen using asyncronous replication
Immediate Consistency within single instance
Sequential consistency including linearizable read within replicaset partition infowhen using Raft
Foreign keys infoReferential integrityyesno infodocs.microsoft.com/­en-us/­azure/­synapse-analytics/­sql-data-warehouse/­sql-data-warehouse-table-constraintsnoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDyesACID, with serializable isolation and linearizable read (within partition); Configurable MVCC (within partition); No cross-shard distributed transactions
Concurrency infoSupport for concurrent manipulation of datayes, multi-version concurrency control (MVCC)yesyesyes, cooperative multitasking
Durability infoSupport for making data persistentyesyesyesyes, write ahead logging
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyesyes, full featured in-memory storage engine with persistence
User concepts infoAccess controlfine grained access rights according to SQL-standardyesnoAccess Control Lists
Mutual TLS authentication for Tarantol Enterprise
Password based authentication
Role-based access control (RBAC) and LDAP for Tarantol Enterprise
Users and Roles

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
3rd partiesSpeedb: A high performance RocksDB-compliant key-value store optimized for write-intensive workloads.
» more

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
EDB PostgresMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data WarehouseRocksDBTarantool
DB-Engines blog posts

Data processing speed and reliability: in-memory synchronous replication
9 November 2021,  Vladimir Perepelytsya, Tarantool (sponsor) 

show all

Recent citations in the news

4 highlights from EDB Postgres AI
13 June 2024, InfoWorld

EDB Puts Postgres in the Middle of Analytics Workflow with New Lakehouse Stack
22 April 2024, Datanami

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

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

EDB Announces EDB Postgres® AI, an Intelligent Platform for Transactional, Analytical and AI Workloads
23 May 2024, GlobeNewswire

provided by Google News

General Available: Azure Synapse Runtime for Apache Spark 3.4 is now GA | Azure updates
8 April 2024, azure.microsoft.com

Azure Synapse Runtime for Apache Spark 3.2 End of Support | Azure updates
22 March 2024, azure.microsoft.com

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

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

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

provided by Google News

Did Rockset Just Solve Real-Time Analytics?
25 August 2021, Datanami

Meta’s Velox Means Database Performance Is Not Subject To Interpretation
31 August 2022, The Next Platform

Linux 6.9 Drives AMD 4th Gen EPYC Performance Even Higher For Some Workloads
29 March 2024, Phoronix

Facebook's MyRocks Truly Rocks!
21 September 2020, Open Source For You

Power your Kafka Streams application with Amazon MSK and AWS Fargate | Amazon Web Services
10 August 2021, AWS Blog

provided by Google News

Tarantool Announces New Enterprise Version With Enhanced Scaling and Monitoring Capabilities
18 May 2018, Newswire

Deploying Tarantool Cartridge applications with zero effort (Part 1)
16 December 2019, Хабр

VShard — horizontal scaling in Tarantool
7 March 2019, Хабр

Accelerating PHP connectors for Tarantool using Async, Swoole, and Parallel
18 December 2019, Хабр

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

Neo4j logo

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

Milvus logo

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

Present your product here