DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Informationen zu relationalen und NoSQL DatenbankmanagementsystemenEin Service von solid IT

DBMS > ClickHouse vs. CockroachDB vs. HEAVY.AI vs. OpenTSDB vs. QuestDB

Vergleich der Systemeigenschaften ClickHouse vs. CockroachDB vs. HEAVY.AI vs. OpenTSDB vs. QuestDB

Redaktionelle Informationen bereitgestellt von DB-Engines
NameClickHouse  Xaus Vergleich ausschliessenCockroachDB  Xaus Vergleich ausschliessenHEAVY.AI infoFormerly named 'OmniSci', rebranded to 'HEAVY.AI' in March 2022  Xaus Vergleich ausschliessenOpenTSDB  Xaus Vergleich ausschliessenQuestDB  Xaus Vergleich ausschliessen
KurzbeschreibungA 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.CockroachDB is a distributed database architected for modern cloud applications. It is wire compatible with PostgreSQL and backed by a Key-Value Store, which is either RocksDB or a purpose-built derivative, called Pebble.A high performance, column-oriented RDBMS, specifically developed to harness the massive parallelism of modern CPU and GPU hardwareSkalierbares Timeseries DBMS basierend auf HBaseA high performance open source SQL database for time series data
Primäres DatenbankmodellRelational DBMSRelational DBMSRelational DBMSTime Series DBMSTime Series DBMS
Sekundäre DatenbankmodelleTime Series DBMSSpatial DBMSRelational DBMS
DB-Engines Ranking infomisst die Popularität von Datenbankmanagement- systemenranking trend
Trend Chart
Punkte16,31
Rang#37  Overall
#23  Relational DBMS
Punkte6,39
Rang#60  Overall
#34  Relational DBMS
Punkte2,30
Rang#127  Overall
#60  Relational DBMS
Punkte1,83
Rang#147  Overall
#12  Time Series DBMS
Punkte2,69
Rang#115  Overall
#8  Time Series DBMS
Websiteclickhouse.comwww.cockroachlabs.comgithub.com/­heavyai/­heavydb
www.heavy.ai
opentsdb.netquestdb.io
Technische Dokumentationclickhouse.com/­docswww.cockroachlabs.com/­docsdocs.heavy.aiopentsdb.net/­docs/­build/­html/­index.htmlquestdb.io/­docs
EntwicklerClickhouse Inc.Cockroach LabsHEAVY.AI, Inc.derzeit von Yahoo und anderen gewartetQuestDB Technology Inc
Erscheinungsjahr20162015201620112014
Aktuelle Versionv23.12.1.1368-stable, Dezember 202323.1.1, Mai 20235.10, Jänner 2022
Lizenz infoCommercial or Open SourceOpen Source infoApache 2.0Open Source infoApache 2.0, commercial license availableOpen Source infoApache Version 2; enterprise edition availableOpen Source infoLGPLOpen Source infoApache 2.0
Ausschließlich ein Cloud-Service infoNur als Cloud-Service verfügbarneinneinneinneinnein
DBaaS Angebote (gesponserte Links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
  • 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.
  • DoubleCloud: Fully managed ClickHouse alongside best-in-class managed open-source services to build analytics at scale.
CockroachDB: A cloud-native, distributed SQL database designed for speed, scale, and survival. Get started for free today with a fully-managed CockroachDB cluster -- leave operations behind and get your app to market faster.
ImplementierungsspracheC++GoC++ and CUDAJavaJava (Zero-GC), C++, Rust
Server BetriebssystemeFreeBSD
Linux
macOS
Linux
macOS
Windows
LinuxLinux
Windows
Linux
macOS
Windows
Datenschemajadynamic schemajaschemafreija infoschema-free via InfluxDB Line Protocol
Typisierung infovordefinierte Datentypen, z.B. float oder datejajajanumerische Daten für Metriken, Strings für Tagsja
XML Unterstützung infoVerarbeitung von Daten in XML Format, beispielsweise Speicherung von XML-Strukturen und/oder Unterstützung von XPath, XQuery, XSLTneinneinneinneinnein
Sekundärindizesyesjaneinneinnein
SQL infoSupport of SQLClose to ANSI SQL (SQL/JSON + extensions)yes, wire compatible with PostgreSQLjaneinSQL with time-series extensions
APIs und andere ZugriffskonzeptegRPC
HTTP REST
JDBC
MySQL wire protocol
ODBC
PostgreSQL wire protocol
Proprietäres Protokoll
JDBCJDBC
ODBC
Thrift
Vega
HTTP API
Telnet API
HTTP REST
InfluxDB Line Protocol (TCP/UDP)
JDBC
PostgreSQL wire protocol
Unterstützte ProgrammiersprachenC# 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#
C++
Clojure
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
Rust
All languages supporting JDBC/ODBC/Thrift
Python
Erlang
Go
Java
Python
R
Ruby
C infoPostgreSQL driver
C++
Go
Java
JavaScript (Node.js)
Python
Rust infoover HTTP
Server-seitige Scripts infoStored Proceduresjaneinneinneinnein
Triggersneinneinneinneinnein
Partitionierungsmechanismen infoMethoden zum Speichern von unterschiedlichen Daten auf unterschiedlichen Knotenkey based and customhorizontal partitioning (by key range) infoall tables are translated to an ordered KV store and then broken down into 64MB ranges, which are then used as replicas in RAFTSharding infoRound robinSharding infobasierend auf HBasehorizontal partitioning (by timestamps)
Replikationsmechanismen infoMethoden zum redundanten Speichern von Daten auf mehreren KnotenAsynchronous and synchronous physical replication; geographically distributed replicas; support for object storages.Multi-source replication using RAFTMulti-Source Replikationfrei wählbarer Replikationsfaktor infobasierend auf HBaseSource-replica replication with eventual consistency
MapReduce infoBietet ein API für Map/Reduce Operationenneinneinneinneinnein
Konsistenzkonzept infoMethoden zur Sicherstellung der Konsistenz in einem verteilten SystemImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyImmediate Consistency infobasierend auf HBaseImmediate Consistency
Fremdschlüssel inforeferenzielle Integritätneinjaneinneinnein
Transaktionskonzept infoUnterstützung zur Sicherstellung der Datenintegrität bei nicht-atomaren DatenmanipulationenneinACIDneinneinACID for single-table writes
Concurrency infoUnterstützung von gleichzeitig ausgeführten Datenmanipulationenjajajajaja
Durability infoDauerhafte Speicherung der Datenjajajajaja
In-Memory Unterstützung infoGibt es Möglichkeiten einige oder alle Strukturen nur im Hauptspeicher zu haltenjaneinjaneinja infothrough memory mapped files
Berechtigungskonzept infoZugriffskontrolleAccess 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.Role-based access controlBenutzer mit feingranularem Berechtigungskonzept entsprechend SQL-Standardnein
Weitere Informationen bereitgestellt vom Systemhersteller
ClickHouseCockroachDBHEAVY.AI infoFormerly named 'OmniSci', rebranded to 'HEAVY.AI' in March 2022OpenTSDBQuestDB
Specific characteristicsCockroachDB is a cloud-native, distributed SQL database architected for modern applications....
» mehr
Relational model with native time series support Column-based storage and time partitioned...
» mehr
Competitive advantages- EFFORTLESS SCALE: Scale your applications, not operational complexity. CockroachDB...
» mehr
High ingestion throughput: peak of 4M rows/sec (TSBS Benchmark) Code optimizations...
» mehr
Typical application scenariosPayment processing, user account management, metadata management, identity access...
» mehr
Financial tick data Industrial IoT Application Metrics Monitoring
» mehr
Key customersComcast, DoorDash, Mythical Games, Norfolk Southern, Netflix, LUSH, Bose, Shipt,...
» mehr
Banks & Hedge funds, Yahoo, OKX, Airbus, Aquis Exchange, Net App, Cloudera, Airtel,...
» mehr
Market metrics12K+ long-running clusters 25K+ CockroachDB self-hosted clusters 75K+ CockroachDB...
» mehr
Licensing and pricing models- Apache 2.0 for core features released up to and including the 19.1 release - Time-limited...
» mehr
Open source Apache 2.0 QuestDB Enterprise QuestDB Cloud
» mehr
Neuigkeiten

TimescaleDB vs. QuestDB: Performance benchmarks and overview
27. März 2024

Maximize your SQL efficiency: SELECT best practices
11. März 2024

1BRC merykitty’s Magic SWAR: 8 Lines of Code Explained in 3,000 Words
7. März 2024

Benchmark and comparison: QuestDB vs. InfluxDB
26. Februar 2024

The Billion Row Challenge (1BRC) - Step-by-step from 71s to 1.7s
20. Februar 2024

Wir laden Vertreter der Systemhersteller ein uns zu kontaktieren, um die Systeminformationen zu aktualisieren und zu ergänzen,
sowie um Herstellerinformationen wie Schlüsselkunden, Vorteile gegenüber Konkurrenten und Marktmetriken anzuzeigen.

Zugehörige Produkte und Dienstleistungen
DrittanbieterAiven for Clickhouse: Managed cloud data warehousing with high-speed analytics.
» mehr

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

Wir laden Vertreter von Anbietern von zugehörigen Produkten ein uns zu kontaktieren, um hier Informationen über ihre Angebote zu präsentieren.

Weitere Ressourcen
ClickHouseCockroachDBHEAVY.AI infoFormerly named 'OmniSci', rebranded to 'HEAVY.AI' in March 2022OpenTSDBQuestDB
DB-Engines Blog Posts

Time Series DBMS are the database category with the fastest increase in popularity
4. Juli 2016, Matthias Gelbmann

alle anzeigen

Erwähnungen in aktuellen Nachrichten

Why Clickhouse Should Be Your Next Database
6. Juli 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

What the Heck is Proton?
31. Dezember 2023, hackernoon.com

ClickHouse Announces Launch of ClickPipes
26. September 2023, Datanami

Can LLMs Replace Data Analysts? Getting Answers Using SQL
22. Dezember 2023, Towards Data Science

bereitgestellt von Google News

CockroachDB 23.2 Enhances Enterprise Architectures with Improved Postgres Compatibility and Built-in Resilience
18. Januar 2024, PR Newswire

CockroachDB tempts legacy databases to crawl into the cloud age
29. Januar 2024, The Register

How DoorDash Migrated from Aurora Postgres to CockroachDB
5. Dezember 2023, The New Stack

CockroachDB's Latest Enhancements Focus on Resilience
18. Januar 2024, Database Trends and Applications

How to Unlock Real-Time Data Streams with CockroachDB and Amazon MSK | Amazon Web Services
6. November 2023, AWS Blog

bereitgestellt von Google News

HEAVY.AI Launches HEAVY 7.0, Introducing Real-Time Machine Learning Capabilities
19. April 2023, Business Wire

The insideBIGDATA IMPACT 50 List for Q4 2023
11. Oktober 2023, insideBIGDATA

Making the most of geospatial intelligence
14. April 2023, InfoWorld

Big Data Analytics: A Game Changer for Infrastructure
13. Juli 2023, Spiceworks News and Insights

Metaphysic Deep Fakes TED
3. Mai 2023, Forbes

bereitgestellt von Google News

Pinterest Switches from OpenTSDB to Their Own Time Series Database
16. September 2018, InfoQ.com

Comparing Different Time-Series Databases
10. Februar 2022, hackernoon.com

MapR to help admins peer into dense Hadoop clusters
28. Juni 2016, SiliconANGLE News

Comparing InfluxDB, TimescaleDB, and QuestDB Timeseries Databases
30. Juni 2021, Towards Data Science

The Best 9 Database Platforms Catering to Big Data Requirements
10. März 2020, CIO Africa

bereitgestellt von Google News

QuestDB snares $12M Series A with hosted version coming soon
3. November 2021, TechCrunch

SQL Extensions for Time-Series Data in QuestDB
11. Januar 2021, Towards Data Science

QuestDB gets $12M Series A funding amid growing interest in time-series databases
3. November 2021, SiliconANGLE News

Read the Pitch Deck Database Startup QuestDB Used to Raise $12 Million
11. November 2021, Business Insider

QuestDB launches 'database-as-a-service' with $12M investment
3. November 2021, VentureBeat

bereitgestellt von Google News



Teilen sie diese Seite mit ihrem Netzwerk

Featured Products

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

Ontotext logo

GraphDB allows you to link diverse data, index it for semantic search and enrich it via text analysis to build big knowledge graphs. Get it 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

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Präsentieren Sie hier Ihr Produkt