DBMS > Dolt vs. EDB Postgres vs. Microsoft Azure Synapse Analytics
System Properties Comparison Dolt vs. EDB Postgres vs. Microsoft Azure Synapse Analytics
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||Dolt Xexclude from comparison||EDB Postgres Xexclude from comparison||Microsoft Azure Synapse Analytics previously named Azure SQL Data Warehouse Xexclude from comparison|
|Description||A MySQL compatible DBMS with Git-like versioning of data and schema||The 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 Server|
|Primary database model||Relational DBMS||Relational DBMS||Relational DBMS|
|Secondary database models||Document store||Document store|
|Current release||14, December 2021|
|License Commercial or Open Source||Open Source Apache Version 2.0||commercial BSD for PostgreSQL-components||commercial|
|Cloud-based only Only available as a cloud service||no||no||yes|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Server operating systems||Linux|
|Typing predefined data types such as float or date||yes||yes||yes|
|no||yes specific XML-type available, but no XML query functionality.||no|
|SQL Support of SQL||yes||yes standard with numerous extensions||yes|
|APIs and other access methods||CLI Client|
native C library
streaming API for large objects
|Supported programming languages||Ada|
|Server-side scripts Stored procedures||yes currently in alpha release||user defined functions realized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.||Transact SQL|
|Partitioning methods Methods for storing different data on different nodes||none||horizontal partitioning by hash, list or range||Sharding, horizontal partitioning|
|Replication methods Methods for redundantly storing data on multiple nodes||A database can be cloned to multiple locations and be used there in isolation. Data/schema changes can be pushed/pulled explicitly between locations.||Multi-source replication||yes|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Immediate Consistency|
|Foreign keys Referential integrity||yes||yes||no docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-table-constraints|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||ACID||ACID|
|Concurrency Support for concurrent manipulation of data||yes||yes, multi-version concurrency control (MVCC)||yes|
|Durability Support for making data persistent||yes||yes||yes|
|User concepts Access control||Only one user is configurable, and must be specified in the config file at startup||fine grained access rights according to SQL-standard||yes|
More information provided by the system vendor
Related products and services
|Dolt||EDB Postgres||Microsoft Azure Synapse Analytics previously named Azure SQL Data Warehouse|
|Recent citations in the news|
Git-for-Data, Version-Controlled Database Dolt Gets PostgreSQL ...
Data Versioning at Scale: Chaos and Chaos Management
Microsoft Announces a New Azure SQL Database Free Offer in ...
Google Releases Cloud SQL Enterprise Plus for MySQL and ...
Cloudflare Hyperdrive: Access PostgreSQL Databases Globally
provided by Google News
EDB Introduces Two New Ways to Get Postgres in AWS Marketplace
EDB Introduces Advanced Tools and Extensions in Postgres 16 Portfolio Release
Kasten by Veeam's Kanister Accepted by Cloud Native Computing ...
EDB Closes the High Availability Gap for Postgres in the Cloud with ...
EDB Announces Postgres Distributed 5.0
provided by Google News
Azure Synapse Link for Cosmos DB: New Analytics Capabilities
Microsoft Fabric Goes GA, Adds Multiple Integrations
SaaS Data Warehouses vs. Data Lakehouses: Blurring the Lines
How AI is being utilised in supply chain risk management
Stelo Enables Mirroring and Streaming Data Replication into Google ...
provided by Google News
INFORMATION SYSTEMS ANALYST II Option A
Telephone Database Administrator (INFORMATION SYSTEMS ANALYST II - OPTION S)
Administrator of Office Automation/Web (Information Systems Analyst II, Option A)
VP of Brand Experiences
Product Manager (Kubernetes)
Customer Success Architect
VP, Product Marketing
Director of Security Operations
Azure Synapse Analytics
Marketing Data Analyst
Data Strategy Leader
Share this page