EUVIMEDEUVIMED entdecken
Crossref

ClickHouse - Lightning Fast Analytics for Everyone

Robert Schulze, Tom Schreiber, Ilya Yatsishin, Ryadh Dahimene, Alexey Milovidov

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.

AbstractBibliografische AngabenZitierenVerwandte Studien

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}
}
Kostenlos starten →