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. Hypertable vs. NebulaGraph vs. YDB

System Properties Comparison Amazon Redshift vs. ClickHouse vs. Hypertable vs. NebulaGraph vs. YDB

Editorial information provided by DB-Engines
NameAmazon Redshift  Xexclude from comparisonClickHouse  Xexclude from comparisonHypertable  Xexclude from comparisonNebulaGraph  Xexclude from comparisonYDB  Xexclude from comparison
Hypertable has stopped its further development with March 2016 and is removed from the DB-Engines ranking.
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.An open source BigTable implementation based on distributed file systems such as HadoopA distributed, linear scalable, high perfomant Graph DBMSA 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 DBMSWide column storeGraph 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
Score2.23
Rank#116  Overall
#10  Graph DBMS
Score0.33
Rank#287  Overall
#43  Document stores
#132  Relational DBMS
Websiteaws.amazon.com/­redshiftclickhouse.comgithub.com/­vesoft-inc/­nebula
www.nebula-graph.io
github.com/­ydb-platform/­ydb
ydb.tech
Technical documentationdocs.aws.amazon.com/­redshiftclickhouse.com/­docsdocs.nebula-graph.ioydb.tech/­en/­docs
DeveloperAmazon (based on PostgreSQL)Clickhouse Inc.Hypertable Inc.Vesoft Inc.Yandex
Initial release20122016200920192019
Current releasev24.4.1.2088-stable, May 20240.9.8.11, March 2016
License infoCommercial or Open SourcecommercialOpen Source infoApache 2.0Open Source infoGNU version 3. Commercial license availableOpen Source infoApache Version 2.0 + Common Clause 1.0Open Source infoApache 2.0; commercial license available
Cloud-based only infoOnly available as a cloud serviceyesnononono
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++C++C++
Server operating systemshostedFreeBSD
Linux
macOS
Linux
OS X
Windows infoan inofficial Windows port is available
LinuxLinux
Data schemeyesyesschema-freeStrong typed schemaFlexible Schema (defined schema, partial schema, schema free)
Typing infopredefined data types such as float or dateyesyesnoyesyes
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.nononono
Secondary indexesrestrictedyesrestricted infoonly exact value or prefix value scansyes infoNebula Graph internally uses the Key-Value store RocksDB for persistency. The vertices, edges, and their properties are stored as Key while their values are stored as Value. The primary indexes are per Key and secondary indexes are per Value.yes
SQL infoSupport of SQLyes infodoes not fully support an SQL-standardClose to ANSI SQL (SQL/JSON + extensions)noSQL-like 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
C++ API
Thrift
Browser interface
console (shell)
Cypher Query Language
GO Object Graph Mapper
Java Object Graph Mapper
NGBatis infoORM framework for NebulaGraph and Spring-Boot
Proprietary native API
Python Object Graph Mapper
Query language nGQL
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
C++
Java
Perl
PHP
Python
Ruby
.Net
C++
Go
Java
PHP
Python
Go
Java
JavaScript (Node.js)
PHP
Python
Server-side scripts infoStored proceduresuser defined functions infoin Pythonyesnouser defined functionsno
Triggersnonono
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.selectable replication factor on file system levelCausal Clustering using Raft protocolActive-passive shard replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoyesnono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyes infoinformational only, not enforced by the systemnonoyes infoRelationships in graphsno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnonoACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentyesyesyesyes infousing RocksDByes
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.noRole-based access controlAccess rights defined for Yandex Cloud users
More information provided by the system vendor
Amazon RedshiftClickHouseHypertableNebulaGraphYDB
Specific characteristicsNebulaGraph is a truly distributed, linearly scalable, lightning-fast graph database,...
» more
Competitive advantagesNebulaGraph boasts the world's only graph database solution that is able to host...
» more
Typical application scenariosSocial networking Fraud detection Knowledge graph Data warehouse management Anti...
» more
Key customersCompanies from a variety of industries have implemented NebulaGraph Database in production,...
» more
Market metricsAt our very early stage, NebulaGraph has already received over 10,000 stars on GitHub...
» more
Licensing and pricing modelsNebulaGraph is open source and free to use under Apache 2.0 license.
» 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
Aiven for Clickhouse: Managed cloud data warehousing with high-speed analytics.
» more

DoubleCloud: Fully managed ClickHouse alongside best-in-class managed open-source services to build analytics at scale.
» more

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

More resources
Amazon RedshiftClickHouseHypertableNebulaGraphYDB
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

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

TimescaleDB goes distributed; implements ‘Chunking’ over ‘Sharding’ for scaling-out
22 August 2019, Packt Hub

SQL and TimescaleDB. This article takes a closer look into… | by Alibaba Cloud
31 July 2019, DataDrivenInvestor

Decorate your Windows XP with Hyperdesk
30 July 2008, CNET

The Collective: Customize Your Computer & Your Phone With Star Trek
18 March 2009, TrekMovie

5 Free NoSQL Database Certification Courses in 2024 – AIM
31 January 2024, Analytics India Magazine

provided by Google News

Vesoft (NebulaGraph) Recognized in the Gartner® Market Guide for Graph Database Management Systems
15 November 2023, PR Newswire

NebulaGraph reaps from China's growing appetite for graph databases
16 September 2022, TechCrunch

NebulaGraph Completes Series A to Scale Its Distributed Graph Database
16 September 2022, Datanami

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

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