DB-EnginesExtremeDB for everyone with an RTOSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Amazon Redshift vs. ClickHouse vs. Google Cloud Firestore vs. Weaviate vs. YDB

System Properties Comparison Amazon Redshift vs. ClickHouse vs. Google Cloud Firestore vs. Weaviate vs. YDB

Editorial information provided by DB-Engines
NameAmazon Redshift  Xexclude from comparisonClickHouse  Xexclude from comparisonGoogle Cloud Firestore  Xexclude from comparisonWeaviate  Xexclude from comparisonYDB  Xexclude from comparison
DescriptionLarge scale data warehouse service for use with business intelligence toolsA high-performance, column-oriented SQL DBMS for online analytical processing (OLAP) that uses all available system resources to their full potential to process each analytical query as fast as possible. It is available as both an open-source software and a cloud offering.Cloud Firestore is an auto-scaling document database for storing, syncing, and querying data for mobile and web apps. It offers seamless integration with other Firebase and Google Cloud Platform products.An AI-native realtime vector database engine that integrates scalable machine learning models.A distributed fault-tolerant database service, with high availability, scalability, immediate consistency and ACID transactions and providing an Amazon DynamoDB compatible API
Primary database modelRelational DBMSRelational DBMSDocument storeVector DBMSDocument store
Relational DBMS
Secondary database modelsTime Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score16.88
Rank#35  Overall
#22  Relational DBMS
Score15.55
Rank#38  Overall
#23  Relational DBMS
Score7.36
Rank#53  Overall
#9  Document stores
Score1.52
Rank#153  Overall
#6  Vector DBMS
Score0.33
Rank#287  Overall
#43  Document stores
#132  Relational DBMS
Websiteaws.amazon.com/­redshiftclickhouse.comfirebase.google.com/­products/­firestoregithub.com/­weaviate/­weaviate
weaviate.io
github.com/­ydb-platform/­ydb
ydb.tech
Technical documentationdocs.aws.amazon.com/­redshiftclickhouse.com/­docsfirebase.google.com/­docs/­firestoreweaviate.io/­developers/­weaviateydb.tech/­en/­docs
DeveloperAmazon (based on PostgreSQL)Clickhouse Inc.GoogleWeaviate B.V.Yandex
Initial release20122016201720192019
Current releasev24.4.1.2088-stable, May 20241.19, May 2023
License infoCommercial or Open SourcecommercialOpen Source infoApache 2.0commercialOpen Source infocommercial license available with Weaviate EnterpriseOpen Source infoApache 2.0; commercial license available
Cloud-based only infoOnly available as a cloud serviceyesnoyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
  • DoubleCloud: Fully managed ClickHouse alongside best-in-class managed open-source services to build analytics at scale.
  • Aiven for Clickhouse: Managed cloud data warehousing with high-speed analytics.
  • ClickHouse Cloud: Get the performance you love from open source ClickHouse in a serverless offering that takes care of the details so you can spend more time getting insight out of the fastest database on earth.
Implementation languageCC++Go
Server operating systemshostedFreeBSD
Linux
macOS
hostedLinux
Data schemeyesyesschema-freeyes, maps to GraphQL interfaceFlexible Schema (defined schema, partial schema, schema free)
Typing infopredefined data types such as float or dateyesyesyesyes infostring, int, float, geo point, date, cross reference, fuzzy referencesyes
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.nonononono
Secondary indexesrestrictedyesyesyes infoall data objects are indexed in a semantic vector space (the Contextionary), all primitive fields are indexedyes
SQL infoSupport of SQLyes infodoes not fully support an SQL-standardClose to ANSI SQL (SQL/JSON + extensions)noGraphQL is used as query languageSQL-like query language (YQL)
APIs and other access methodsJDBC
ODBC
gRPC
HTTP REST
JDBC
MySQL wire protocol
ODBC
PostgreSQL wire protocol
Proprietary protocol
Android
gRPC (using protocol buffers) API
iOS
JavaScript API
RESTful HTTP API
GraphQL query language
RESTful HTTP/JSON API
RESTful HTTP API (DynamoDB compatible)
Supported programming languagesAll languages supporting JDBC/ODBCC# info3rd party library
C++
Elixir info3rd party library
Go info3rd party library
Java info3rd party library
JavaScript (Node.js) info3rd party library
Kotlin info3rd party library
Nim info3rd party library
Perl info3rd party library
PHP info3rd party library
Python info3rd party library
R info3rd party library
Ruby info3rd party library
Rust
Scala info3rd party library
Go
Java
JavaScript
JavaScript (Node.js)
Objective-C
Python
JavaScript / TypeScript
Python
Go
Java
JavaScript (Node.js)
PHP
Python
Server-side scripts infoStored proceduresuser defined functions infoin Pythonyesyes, Firebase Rules & Cloud Functionsnono
Triggersnonoyes, with Cloud Functionsno
Partitioning methods infoMethods for storing different data on different nodesShardingkey based and customShardingShardingSharding
Replication methods infoMethods for redundantly storing data on multiple nodesyesAsynchronous and synchronous physical replication; geographically distributed replicas; support for object storages.Multi-source replicationyesActive-passive shard replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoUsing Cloud Dataflownono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyEventual ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyes infoinformational only, not enforced by the systemnononono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnoyesnoACID
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.yesyesyesno
User concepts infoAccess controlfine grained access rights according to SQL-standardAccess rights for users and roles. Column and row based policies. Quotas and resource limits. Pluggable authentication with LDAP and Kerberos. Password based, X.509 certificate, and SSH key authentication.Access rights for users, groups and roles based on Google Cloud Identity and Access Management. Security Rules for 3rd party authentication using Firebase Auth.API Keys
OpenID Connect Discovery
Access rights defined for Yandex Cloud users
More information provided by the system vendor
Amazon RedshiftClickHouseGoogle Cloud FirestoreWeaviateYDB
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
DoubleCloud: Fully managed ClickHouse alongside best-in-class managed open-source services to build analytics at scale.
» more

Aiven for Clickhouse: Managed cloud data warehousing with high-speed analytics.
» more

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

More resources
Amazon RedshiftClickHouseGoogle Cloud FirestoreWeaviateYDB
DB-Engines blog posts

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

The popularity of cloud-based DBMSs has increased tenfold in four years
7 February 2017, Matthias Gelbmann

Increased popularity for consuming DBMS services out of the cloud
2 October 2015, Paul Andlinger

show all

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

show all

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

show all

Recent citations in the news

How Swisscom automated Amazon Redshift as part of their One Data Platform solution using AWS CDK – Part 1 ...
12 June 2024, AWS Blog

Amazon Redshift Serverless is now available in the AWS Middle East (UAE) region - AWS
7 June 2024, AWS Blog

Amazon Redshift Serverless is now generally available in the AWS China (Ningxia) Region - AWS
28 May 2024, AWS Blog

Integrate Tableau and Okta with Amazon Redshift using AWS IAM Identity Center | Amazon Web Services
3 June 2024, AWS Blog

Amazon Redshift adds new AI capabilities, including Amazon Q, to boost efficiency and productivity | Amazon Web ...
29 November 2023, AWS Blog

provided by Google News

Why Clickhouse Should Be Your Next Database
6 July 2023, The New Stack

ClickHouse Cloud & Amazon S3 Express One Zone: Making a blazing fast analytical database even faster | Amazon ...
28 November 2023, AWS Blog

Intel Xeon 6766E/6780E Sierra Forest vs. Ampere Altra Performance & Power Efficiency Review
5 June 2024, Phoronix

A 1000x Faster Database Solution: ClickHouse’s Aaron Katz
1 November 2023, GrowthCap

From Open Source to SaaS: the Journey of ClickHouse
16 January 2024, InfoQ.com

provided by Google News

Google's AI-First Strategy Brings Vector Support To Cloud Databases
1 March 2024, Forbes

Realtime vs Cloud Firestore: Which Firebase Database to go?
8 March 2024, Appinventiv

Google's Cloud Firestore is now generally available
31 January 2019, ZDNet

Google launches Cloud Firestore, a new document database for app developers
3 October 2017, TechCrunch

Google's Cloud-Native NoSQL Database Cloud Firestore Is Now Generally Available
8 February 2019, InfoQ.com

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

Personal Data Protection Service Initiates Probe into Yandex.Go App’s Data Processing
10 August 2023, Civil Georgia

Data leak from Russian delivery app shows dining habits of the secret police
3 April 2022, The Verge

Yandex code leak: Why hack of ‘Russian Google’s’ ranking factors has spooked the SEO industry
1 February 2023, The Indian Express

Russian Court Sues Yandex CEO For LGBT Propaganda Case
5 July 2023, VOI English

Russian secret police data leaked by food delivery app including where they live and what they eat...
4 April 2022, The US Sun

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