ClickHouse - Lightning Fast Analytics for Everyone
Proceedings of the VLDB Endowment · 2024-08 · 17 (12) · 3731-3744
DOI: 10.14778/3685800.3685802 ↗Kurz gefasst
Fachartikel in der Zeitschrift Proceedings of the VLDB Endowment, online erschienen am 08.11.2024. Verfasst von Robert Schulze und 4 weiteren Autor:innen. Die Arbeit wurde bisher 56-mal zitiert (Crossref) und nennt 80 Literaturangaben.
Abstract (Originalsprache)
Over the past several decades, the amount of data being stored and analyzed has increased exponentially. Businesses across industries and sectors have begun relying on this data to improve products, evaluate performance, and make business-critical decisions. However, as data volumes have increasingly become internet-scale, businesses have needed to manage historical and new data in a cost-effective and scalable manner, while analyzing it using a high number of concurrent queries and an expectation of real-time latencies (e.g. less than one second, depending on the use case). This paper presents an overview of ClickHouse, a popular open-source OLAP database designed for high-performance analytics over petabyte-scale data sets with high ingestion rates. Its storage layer combines a data format based on traditional log-structured merge (LSM) trees with novel techniques for continuous transformation (e.g. aggregation, archiving) of historical data in the background. Queries are written in a convenient SQL dialect and processed by a state-of-the-art vectorized query execution engine with optional code compilation. ClickHouse makes aggressive use of pruning techniques to avoid evaluating irrelevant data in queries. Other data management systems can be integrated at the table function, table engine, or database engine level. Real-world benchmarks demonstrate that ClickHouse is amongst the fastest analytical databases on the market.
Zitieren
APA
Schulze, R., Schreiber, T., Yatsishin, I., Dahimene, R., & Milovidov, A. (2024). ClickHouse - Lightning Fast Analytics for Everyone. Proceedings of the VLDB Endowment, 17(12), 3731-3744. https://doi.org/10.14778/3685800.3685802
Vancouver
Schulze R, Schreiber T, Yatsishin I, Dahimene R, Milovidov A. ClickHouse - Lightning Fast Analytics for Everyone. Proceedings of the VLDB Endowment. 2024;17(12):3731-3744. doi:10.14778/3685800.3685802
BibTeX
@article{Schulze2024,
author = {Schulze, Robert and Schreiber, Tom and Yatsishin, Ilya and Dahimene, Ryadh and Milovidov, Alexey},
title = {ClickHouse - Lightning Fast Analytics for Everyone},
journal = {Proceedings of the VLDB Endowment},
year = {2024},
volume = {17},
number = {12},
pages = {3731--3744},
doi = {10.14778/3685800.3685802}
}
EUVIMED