DBMS > EDB Postgres vs. Google BigQuery vs. JSqlDb
System Properties Comparison EDB Postgres vs. Google BigQuery vs. JSqlDb
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||EDB Postgres Xexclude from comparison||Google BigQuery Xexclude from comparison||JSqlDb Xexclude from comparison|
|JSqlDB seems to be discontinued. Therefore it is excluded from the DB-Engines ranking.|
|Primary database model||Relational DBMS||Relational DBMS||Document store|
Object oriented DBMS
|Secondary database models||Document store|
|Developer||EnterpriseDB||Konrad von Backstrom|
|Current release||14, December 2021||0.8, December 2018|
|License Commercial or Open Source||commercial BSD for PostgreSQL-components||commercial||Open Source|
|Cloud-based only Only available as a cloud service||no||yes||no|
|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||no|
|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.||yes specific XML-type available, but no XML query functionality.||no||no|
|SQL Support of SQL||yes standard with numerous extensions||yes||no|
|APIs and other access methods||ADO.NET|
native C library
streaming API for large objects
|RESTful HTTP/JSON API|
|Supported programming languages||.Net|
|Partitioning methods Methods for storing different data on different nodes||horizontal partitioning by hash, list or range||none||none|
|Replication methods Methods for redundantly storing data on multiple nodes||Multi-source replication||none|
|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||no||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||no Since BigQuery is designed for querying data|
|Concurrency Support for concurrent manipulation of data||yes, multi-version concurrency control (MVCC)||yes|
|Durability Support for making data persistent||yes||yes||yes using RocksDB|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||no||no|
|User concepts Access control||fine grained access rights according to SQL-standard||Access privileges (owner, writer, reader) on dataset, table or view level Google Cloud Identity & Access Management (IAM)|
More information provided by the system vendor
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services|
|3rd parties||CData: Connect to Big Data & NoSQL through standard Drivers.|
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|EDB Postgres||Google BigQuery||JSqlDb|
|DB-Engines blog posts|
Snowflake is the DBMS of the Year 2022, defending the title from last year Cloud-based DBMS's popularity grows at high rates The popularity of cloud-based DBMSs has increased tenfold in four years
Cloud-based DBMS's popularity grows at high rates The popularity of cloud-based DBMSs has increased tenfold in four years
The popularity of cloud-based DBMSs has increased tenfold in four years
|Recent citations in the news|
UPDATE -- EDB Open Sources Powerful Tool to Automate and ...
EDB Closes the High Availability Gap for Postgres in the Cloud with ...
4 key new features in PostgreSQL 16
EnterpriseDB releases PostgreSQL cluster deployment tool to open ...
Storage news ticker – September 4 – Blocks and Files
provided by Google News
Hightouch Announces $38M in Funding and Launches New ...
Salesforce en Google Cloud integreren nog meer AI-features
Как использовать Google BigQuery с помощью Python
Google Cloud, Band Protocol'ü Entegre Ederek BAND Değerini %40 ...
provided by Google News
PostgreSQL DBA/Green card only/Remote
“AWS-RDS with Postgres DBA Engineer” on C2C at Las Vegas, NV-(Day1 Onsite)
Sr Oracle Database Admin
Manager II, Business Analysis and Insights, eComm
Share this page