DB-EnginesExtremeDB: mitigate connectivity issues in a DBMSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Google BigQuery vs. Google Cloud Datastore vs. Oracle Berkeley DB vs. Snowflake vs. SQream DB

System Properties Comparison Google BigQuery vs. Google Cloud Datastore vs. Oracle Berkeley DB vs. Snowflake vs. SQream DB

Editorial information provided by DB-Engines
NameGoogle BigQuery  Xexclude from comparisonGoogle Cloud Datastore  Xexclude from comparisonOracle Berkeley DB  Xexclude from comparisonSnowflake  Xexclude from comparisonSQream DB  Xexclude from comparison
DescriptionLarge scale data warehouse service with append-only tablesAutomatically scaling NoSQL Database as a Service (DBaaS) on the Google Cloud PlatformWidely used in-process key-value storeCloud-based data warehousing service for structured and semi-structured dataa GPU-based, columnar RDBMS for big data analytics workloads
Primary database modelRelational DBMSDocument storeKey-value store infosupports sorted and unsorted key sets
Native XML DBMS infoin the Oracle Berkeley DB XML version
Relational DBMSRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score58.10
Rank#19  Overall
#13  Relational DBMS
Score4.36
Rank#72  Overall
#12  Document stores
Score2.01
Rank#126  Overall
#21  Key-value stores
#3  Native XML DBMS
Score130.36
Rank#8  Overall
#5  Relational DBMS
Score0.74
Rank#224  Overall
#103  Relational DBMS
Websitecloud.google.com/­bigquerycloud.google.com/­datastorewww.oracle.com/­database/­technologies/­related/­berkeleydb.htmlwww.snowflake.comsqream.com
Technical documentationcloud.google.com/­bigquery/­docscloud.google.com/­datastore/­docsdocs.oracle.com/­cd/­E17076_05/­html/­index.htmldocs.snowflake.net/­manuals/­index.htmldocs.sqream.com
DeveloperGoogleGoogleOracle infooriginally developed by Sleepycat, which was acquired by OracleSnowflake Computing Inc.SQream Technologies
Initial release20102008199420142017
Current release18.1.40, May 20202022.1.6, December 2022
License infoCommercial or Open SourcecommercialcommercialOpen Source infocommercial license availablecommercialcommercial
Cloud-based only infoOnly available as a cloud serviceyesyesnoyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC, Java, C++ (depending on the Berkeley DB edition)C++, CUDA, Haskell, Java, Scala
Server operating systemshostedhostedAIX
Android
FreeBSD
iOS
Linux
OS X
Solaris
VxWorks
Windows
hostedLinux
Data schemeyesschema-freeschema-freeyes infosupport of semi-structured data formats (JSON, XML, Avro)yes
Typing infopredefined data types such as float or dateyesyes, details herenoyesyes, ANSI Standard SQL Types
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.nonoyes infoonly with the Berkeley DB XML editionyes
Secondary indexesnoyesyesno
SQL infoSupport of SQLyesSQL-like query language (GQL)yes infoSQL interfaced based on SQLite is availableyesyes
APIs and other access methodsRESTful HTTP/JSON APIgRPC (using protocol buffers) API
RESTful HTTP/JSON API
CLI Client
JDBC
ODBC
.Net
JDBC
ODBC
Supported programming languages.Net
Java
JavaScript
Objective-C
PHP
Python
Ruby
.Net
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
.Net infoFigaro is a .Net framework assembly that extends Berkeley DB XML into an embeddable database engine for .NET
others infoThird-party libraries to manipulate Berkeley DB files are available for many languages
C
C#
C++
Java
JavaScript (Node.js) info3rd party binding
Perl
Python
Tcl
JavaScript (Node.js)
Python
C++
Java
JavaScript (Node.js)
Python
Server-side scripts infoStored proceduresuser defined functions infoin JavaScriptusing Google App Enginenouser defined functionsuser defined functions in Python
TriggersnoCallbacks using the Google Apps Engineyes infoonly for the SQL APIno infosimilar concept for controling cloud resourcesno
Partitioning methods infoMethods for storing different data on different nodesnoneShardingnoneyeshorizontal and vertical partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication using PaxosSource-replica replicationyesnone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyes infousing Google Cloud Dataflownonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency or Eventual Consistency depending on type of query and configuration infoStrong Consistency is default for entity lookups and queries within an Entity Group (but can instead be made eventually consistent). Other queries are always eventual consistent.Immediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyes infovia ReferenceProperties or Ancestor pathsnoyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datano infoSince BigQuery is designed for querying dataACID infoSerializable Isolation within Transactions, Read Committed outside of TransactionsACIDACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nonoyesno
User concepts infoAccess controlAccess privileges (owner, writer, reader) on dataset, table or view level infoGoogle Cloud Identity & Access Management (IAM)Access rights for users, groups and roles based on Google Cloud Identity and Access Management (IAM)noUsers with fine-grained authorization concept, user roles and pluggable authentication

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 partiesCData: Connect to Big Data & NoSQL through standard Drivers.
» more
CData: Connect to Big Data & NoSQL through standard Drivers.
» more

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

More resources
Google BigQueryGoogle Cloud DatastoreOracle Berkeley DBSnowflakeSQream DB
DB-Engines blog posts

PostgreSQL is the DBMS of the Year 2023
2 January 2024, Matthias Gelbmann, Paul Andlinger

Snowflake is the DBMS of the Year 2022, defending the title from last year
3 January 2023, Matthias Gelbmann, Paul Andlinger

Cloud-based DBMS's popularity grows at high rates
12 December 2019, Paul Andlinger

show all

Snowflake is the DBMS of the Year 2022, defending the title from last year
3 January 2023, Matthias Gelbmann, Paul Andlinger

Snowflake is the DBMS of the Year 2021
3 January 2022, Paul Andlinger, Matthias Gelbmann

show all

Recent citations in the news

Winning the 2020 Google Cloud Technology Partner of the Year – Infrastructure Modernization Award
22 December 2021, CIO

Google Cloud partners Coinbase to accept crypto payments
11 October 2022, Ledger Insights

Hightouch Raises $38M in Funding
19 July 2023, FinSMEs

provided by Google News

Google Cloud Platform: Professional Data Engineer certification prep
11 June 2024, oreilly.com

Google Cloud Stops Exit Fees
12 January 2024, Spiceworks News and Insights

Best cloud storage of 2024
4 June 2024, TechRadar

BigID Data Intelligence Platform Now Available on Google Cloud Marketplace
6 November 2023, PR Newswire

Google says it'll stop charging fees to transfer data out of Google Cloud
11 January 2024, TechCrunch

provided by Google News

Margo Seltzer Named ACM Athena Lecturer for Technical and Mentoring Contributions
26 April 2023, HPCwire

ACM recognizes far-reaching technical achievements with special awards
26 May 2021, EurekAlert

Margo I. Seltzer | Berkman Klein Center
18 August 2020, Berkman Klein Center

Oracle buys Sleepycat Software
14 February 2006, MarketWatch

How to store financial market data for backtesting
26 January 2019, Towards Data Science

provided by Google News

Lessons from the Snowflake Breaches
12 June 2024, The Hacker News

Mandiant Report: Snowflake Users Targeted for Data Theft and Extortion
12 June 2024, TechRepublic

Truist Bank says breach of customer data is unrelated to Snowflake
14 June 2024, SC Media

Pure Storage pwned, claims data plundered by crims who broke into Snowflake workspace
11 June 2024, The Register

The Snowflake Attack May Be Turning Into One of the Largest Data Breaches Ever
6 June 2024, WIRED

provided by Google News

I SQream, you SQream, we all SQream for … data analytics?
5 October 2023, Fierce Network

SQream Announces Strategic Integration for Powerful Big Data Analytics with Dataiku
9 February 2024, insideBIGDATA

SQream Joins Samsung Cloud Platform Ecosystem
26 July 2023, Datanami

GPU data warehouse startup SQream lands $39.4M funding round
24 June 2020, SiliconANGLE News

SQream Technologies raises $39.4 million for GPU-accelerated databases
24 June 2020, VentureBeat

provided by Google News



Share this page

Featured Products

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online 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

Present your product here