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. OpenTenBase vs. Snowflake vs. Weaviate

System Properties Comparison Google BigQuery vs. Google Cloud Datastore vs. OpenTenBase vs. Snowflake vs. Weaviate

Editorial information provided by DB-Engines
NameGoogle BigQuery  Xexclude from comparisonGoogle Cloud Datastore  Xexclude from comparisonOpenTenBase  Xexclude from comparisonSnowflake  Xexclude from comparisonWeaviate  Xexclude from comparison
DescriptionLarge scale data warehouse service with append-only tablesAutomatically scaling NoSQL Database as a Service (DBaaS) on the Google Cloud PlatformAn enterprise-level distributed HTAP open source database based on PostgreSQLCloud-based data warehousing service for structured and semi-structured dataAn AI-native realtime vector database engine that integrates scalable machine learning models.
Primary database modelRelational DBMSDocument storeRelational DBMSRelational DBMSVector 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
Score0.08
Rank#370  Overall
#156  Relational DBMS
Score130.36
Rank#8  Overall
#5  Relational DBMS
Score1.52
Rank#153  Overall
#6  Vector DBMS
Websitecloud.google.com/­bigquerycloud.google.com/­datastoregithub.com/­OpenTenBase/­OpenTenBase
www.opentenbase.org
www.snowflake.comgithub.com/­weaviate/­weaviate
weaviate.io
Technical documentationcloud.google.com/­bigquery/­docscloud.google.com/­datastore/­docsdocs.opentenbase.org
docs.opentenbase.org/­en
docs.snowflake.net/­manuals/­index.htmlweaviate.io/­developers/­weaviate
DeveloperGoogleGoogleOpenAtom Foundation, previously TencentSnowflake Computing Inc.Weaviate B.V.
Initial release2010200820142019
Current release2.5, January 20241.19, May 2023
License infoCommercial or Open SourcecommercialcommercialOpen Source infoBSD-3commercialOpen Source infocommercial license available with Weaviate Enterprise
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 languageGo
Server operating systemshostedhostedLinuxhosted
Data schemeyesschema-freeyesyes infosupport of semi-structured data formats (JSON, XML, Avro)yes, maps to GraphQL interface
Typing infopredefined data types such as float or dateyesyes, details hereyesyesyes infostring, int, float, geo point, date, cross reference, fuzzy references
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.nonoyesno
Secondary indexesnoyesyesyes infoall data objects are indexed in a semantic vector space (the Contextionary), all primitive fields are indexed
SQL infoSupport of SQLyesSQL-like query language (GQL)yesyesGraphQL is used as query language
APIs and other access methodsRESTful HTTP/JSON APIgRPC (using protocol buffers) API
RESTful HTTP/JSON API
CLI Client
JDBC
ODBC
GraphQL query language
RESTful HTTP/JSON API
Supported programming languages.Net
Java
JavaScript
Objective-C
PHP
Python
Ruby
.Net
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
C
Go
Java
PHP
Python
JavaScript (Node.js)
Python
JavaScript / TypeScript
Python
Server-side scripts infoStored proceduresuser defined functions infoin JavaScriptusing Google App Engineuser defined functionsno
TriggersnoCallbacks using the Google Apps Engineyesno infosimilar concept for controling cloud resourcesno
Partitioning methods infoMethods for storing different data on different nodesnoneShardingShardingyesSharding
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication using Paxosyesyesyes
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyes infousing Google Cloud Dataflownono
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 ConsistencyEventual Consistency
Foreign keys infoReferential integritynoyes infovia ReferenceProperties or Ancestor pathsyesyesno
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 TransactionsACIDACIDno
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
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.nononoyes
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)Access rights for users, groups and roles according to SQL-standardUsers with fine-grained authorization concept, user roles and pluggable authenticationAPI Keys
OpenID Connect Discovery
More information provided by the system vendor
Google BigQueryGoogle Cloud DatastoreOpenTenBaseSnowflakeWeaviate
Specific characteristicsWeaviate is an open source vector database that is robust, scalable, cloud-native,...
» more
Competitive advantagesFlexible deployment - Free, open source or fully-managed cloud vector database service...
» more
Typical application scenariosAs a database supporting the development of generative AI and semantic search applications...
» more
Key customersAll companies that have data. ​
» more
Market metricsAs of mid 2023: Over 2 million open source downloads 3500+ Weaviate Slack community...
» more
Licensing and pricing modelsWeaviate is open-source, and free to use. Weaviate is also available as a fully managed...
» 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
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 DatastoreOpenTenBaseSnowflakeWeaviate
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

Weaviate, an ANN Database with CRUD support
2 February 2021,  Etienne Dilocker, SeMI Technologies (sponsor) 

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, O'Reilly Media

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

Best cloud storage of 2024
4 June 2024, TechRadar

Inside Google’s strategic move to eliminate customer cloud data transfer fees
12 January 2024, Network World

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

provided by Google News

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

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

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

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

Hackers steal “significant volume” of data from hundreds of Snowflake customers
10 June 2024, Ars Technica

provided by Google News

Build enterprise-ready generative AI solutions with Cohere foundation models in Amazon Bedrock and Weaviate vector ...
24 January 2024, AWS Blog

Weaviate Partners with Snowflake to Bring Secure GenAI to Snowpark Container Services
8 February 2024, Datanami

Weaviate Partners with Snowflake to Bring Secure GenAI to Snowpark Container Services
9 February 2024, AiThority

Foley Represents Cortical Ventures in $50M Series B Round for Weaviate
17 December 2023, Foley & Lardner LLP

Getting Started with Weaviate: A Beginner's Guide to Search with Vector Databases
18 July 2023, Towards Data Science

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.

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus 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

Present your product here