{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,7,18]],"date-time":"2026-07-18T02:42:56Z","timestamp":1784342576361,"version":"3.55.0"},"reference-count":80,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2024,8]]},"abstract":"<jats:p>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).<\/jats:p>\n          <jats:p>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.<\/jats:p>","DOI":"10.14778\/3685800.3685802","type":"journal-article","created":{"date-parts":[[2024,11,8]],"date-time":"2024-11-08T17:25:21Z","timestamp":1731086721000},"page":"3731-3744","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":35,"title":["ClickHouse - Lightning Fast Analytics for Everyone"],"prefix":"10.14778","volume":"17","author":[{"given":"Robert","family":"Schulze","sequence":"first","affiliation":[{"name":"ClickHouse Inc."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Tom","family":"Schreiber","sequence":"additional","affiliation":[{"name":"ClickHouse Inc."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Ilya","family":"Yatsishin","sequence":"additional","affiliation":[{"name":"ClickHouse Inc."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Ryadh","family":"Dahimene","sequence":"additional","affiliation":[{"name":"ClickHouse Inc."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Alexey","family":"Milovidov","sequence":"additional","affiliation":[{"name":"ClickHouse Inc."}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"320","published-online":{"date-parts":[[2024,11,8]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"publisher","unstructured":"Daniel Abadi Peter Boncz Stavros Harizopoulos Stratos Idreaos and Samuel Madden. 2013. The Design and Implementation of Modern Column-Oriented Database Systems. 10.1561\/9781601987556","DOI":"10.1561\/9781601987556"},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1145\/1142473.1142548"},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.5555\/645927.672367"},{"key":"e_1_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1145\/3514221.3526045"},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1145\/3514221.3526054"},{"key":"e_1_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1145\/356842.356846"},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.1145\/1989323.1989328"},{"key":"e_1_2_1_8_1","doi-asserted-by":"crossref","unstructured":"Daniel Gomez Blanco. 2023. Practical OpenTelemetry. Springer Nature.","DOI":"10.1007\/978-1-4842-9075-0"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1145\/362686.362692"},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","unstructured":"Peter Boncz Thomas Neumann and Orri Erling. 2014. TPC-H Analyzed: Hidden Messages and Lessons Learned from an Influential Benchmark. In Performance Characterization and Benchmarking. 61--76. 10.1007\/978-3-319-04936-6_5","DOI":"10.1007\/978-3-319-04936-6_5"},{"key":"e_1_2_1_11_1","unstructured":"Peter Boncz Marcin Zukowski and Niels Nes. 2005. MonetDB\/X100: Hyper-Pipelining Query Execution. In CIDR."},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1109\/DCC.2007.44"},{"key":"e_1_2_1_13_1","volume-title":"Cassandra: The Definitive Guide","author":"Carpenter Jeff","year":"2016","unstructured":"Jeff Carpenter and Eben Hewitt. 2016. Cassandra: The Definitive Guide (2nd ed.). O'Reilly Media, Inc.","edition":"2"},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.5555\/2172338"},{"key":"e_1_2_1_15_1","unstructured":"chDB. 2024. chDB - an embedded OLAP SQL Engine. Retrieved 2024-06-20 from https:\/\/github.com\/chdb-io\/chdb"},{"key":"e_1_2_1_16_1","unstructured":"ClickHouse. 2024. ClickBench: a Benchmark For Analytical Databases. Retrieved 2024-06-20 from https:\/\/github.com\/ClickHouse\/ClickBench"},{"key":"e_1_2_1_17_1","unstructured":"ClickHouse. 2024. ClickBench: Comparative Measurements. Retrieved 2024-06-20 from https:\/\/benchmark.clickhouse.com"},{"key":"e_1_2_1_18_1","unstructured":"ClickHouse. 2024. ClickHouse Roadmap 2024 (GitHub). Retrieved 2024-06-20 from https:\/\/github.com\/ClickHouse\/ClickHouse\/issues\/58392"},{"key":"e_1_2_1_19_1","unstructured":"ClickHouse. 2024. ClickHouse Versions Benchmark. Retrieved 2024-06-20 from https:\/\/github.com\/ClickHouse\/ClickBench\/tree\/main\/versions"},{"key":"e_1_2_1_20_1","unstructured":"ClickHouse. 2024. ClickHouse Versions Benchmark Results. Retrieved 2024-06-20 from https:\/\/benchmark.clickhouse.com\/versions\/"},{"key":"e_1_2_1_21_1","unstructured":"Andrew Crotty. 2022. MgBench. Retrieved 2024-06-20 from https:\/\/github.com\/andrewcrotty\/mgbench"},{"key":"e_1_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2903741"},{"key":"e_1_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1145\/3323991"},{"key":"e_1_2_1_24_1","doi-asserted-by":"publisher","DOI":"10.1145\/3093742.3093908"},{"key":"e_1_2_1_25_1","unstructured":"LLVM documentation. 2024. Auto-Vectorization in LLVM. Retrieved 2024-06-20 from https:\/\/llvm.org\/docs\/Vectorizers.html"},{"key":"e_1_2_1_26_1","doi-asserted-by":"publisher","DOI":"10.1145\/3483840"},{"key":"e_1_2_1_27_1","doi-asserted-by":"publisher","DOI":"10.14778\/3389133.3389138"},{"key":"e_1_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.simpa.2020.100049"},{"key":"e_1_2_1_29_1","doi-asserted-by":"publisher","unstructured":"Martin Faust Martin Boissier Marvin Keller David Schwalb Holger Bischoff Katrin Eisenreich Franz F\u00e4rber and Hasso Plattner. 2016. Footprint Reduction and Uniqueness Enforcement with Hash Indices in SAP HANA. In Database and Expert Systems Applications. 137--151. 10.1007\/978-3-319-44406-2_11","DOI":"10.1007\/978-3-319-44406-2_11"},{"key":"e_1_2_1_30_1","doi-asserted-by":"publisher","DOI":"10.46298\/dmtcs.3545"},{"key":"e_1_2_1_31_1","unstructured":"Hector Garcia-Molina Jeffrey D. Ullman and Jennifer Widom. 2009. Database Systems - The Complete Book (2. Ed.)."},{"key":"e_1_2_1_32_1","doi-asserted-by":"publisher","DOI":"10.1145\/248157.248171"},{"key":"e_1_2_1_33_1","doi-asserted-by":"publisher","DOI":"10.1145\/152610.152611"},{"key":"e_1_2_1_34_1","doi-asserted-by":"publisher","DOI":"10.1145\/3183713.3190661"},{"key":"e_1_2_1_35_1","volume-title":"Information technology --- Database language --- SQL --- Part 9: Management of External Data (SQL\/MED). Standard","author":"IEC","unstructured":"ISO\/IEC 9075-9:2001 2001. Information technology --- Database language --- SQL --- Part 9: Management of External Data (SQL\/MED). Standard. International Organization for Standardization."},{"key":"e_1_2_1_36_1","volume-title":"Tathagata Das, Ion Stoica, and Matei Zaharia.","author":"Jain Paras","year":"2023","unstructured":"Paras Jain, Peter Kraft, Conor Power, Tathagata Das, Ion Stoica, and Matei Zaharia. 2023. Analyzing and Comparing Lakehouse Storage Systems. CIDR."},{"key":"e_1_2_1_37_1","unstructured":"Project Jupyter. 2024. Jupyter Notebooks. Retrieved 2024-06-20 from https:\/\/jupyter.org\/"},{"key":"e_1_2_1_38_1","doi-asserted-by":"publisher","DOI":"10.14778\/3275366.3284966"},{"key":"e_1_2_1_39_1","doi-asserted-by":"publisher","DOI":"10.1145\/1807167.1807206"},{"key":"e_1_2_1_40_1","volume-title":"The Art of Computer Programming, Volume III: Sorting and Searching","author":"Knuth Donald E.","unstructured":"Donald E. Knuth. 1973. The Art of Computer Programming, Volume III: Sorting and Searching. Addison-Wesley."},{"key":"e_1_2_1_41_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2018.00027"},{"key":"e_1_2_1_42_1","doi-asserted-by":"publisher","DOI":"10.14778\/2367502.2367518"},{"key":"e_1_2_1_43_1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2882925"},{"key":"e_1_2_1_44_1","doi-asserted-by":"publisher","DOI":"10.1145\/2588555.2610507"},{"key":"e_1_2_1_45_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2013.6544812"},{"key":"e_1_2_1_46_1","doi-asserted-by":"publisher","DOI":"10.14778\/3611479.3611507"},{"key":"e_1_2_1_47_1","doi-asserted-by":"publisher","DOI":"10.1145\/3448016.3457562"},{"key":"e_1_2_1_48_1","doi-asserted-by":"publisher","DOI":"10.1016\/B978-012088469-8.50111-X"},{"key":"e_1_2_1_49_1","doi-asserted-by":"publisher","DOI":"10.14778\/3415478.3415568"},{"key":"e_1_2_1_50_1","unstructured":"Microsoft. 2024. Kusto Query Language. Retrieved 2024-06-20 from https:\/\/github.com\/microsoft\/Kusto-Query-Language"},{"key":"e_1_2_1_51_1","volume-title":"Proceedings of the 24rd International Conference on Very Large Data Bases (VLDB '98)","author":"Moerkotte Guido","year":"1998","unstructured":"Guido Moerkotte. 1998. Small Materialized Aggregates: A Light Weight Index Structure for Data Warehousing. In Proceedings of the 24rd International Conference on Very Large Data Bases (VLDB '98). 476--487."},{"key":"e_1_2_1_52_1","doi-asserted-by":"publisher","DOI":"10.1145\/3538712.3538723"},{"key":"e_1_2_1_53_1","doi-asserted-by":"publisher","DOI":"10.14778\/2002938.2002940"},{"key":"e_1_2_1_54_1","volume-title":"Freitag","author":"Neumann Thomas","year":"2020","unstructured":"Thomas Neumann and Michael J. Freitag. 2020. Umbra: A Disk-Based System with In-Memory Performance. In 10th Conference on Innovative Data Systems Research, CIDR 2020, Amsterdam, The Netherlands, January 12--15, 2020, Online Proceedings. www.cidrdb.org. http:\/\/cidrdb.org\/cidr2020\/papers\/p29-neumanncidr20.pdf"},{"key":"e_1_2_1_55_1","doi-asserted-by":"publisher","DOI":"10.1145\/2723372.2749436"},{"key":"e_1_2_1_56_1","unstructured":"LevelDB on GitHub. 2024. LevelDB. Retrieved 2024-06-20 from https:\/\/github.com\/google\/leveldb"},{"key":"e_1_2_1_57_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-642-10424-4_17"},{"key":"e_1_2_1_58_1","doi-asserted-by":"publisher","DOI":"10.1007\/s002360050048"},{"key":"e_1_2_1_59_1","doi-asserted-by":"publisher","DOI":"10.5555\/2643634.2643666"},{"key":"e_1_2_1_60_1","doi-asserted-by":"publisher","DOI":"10.1007\/s002360050048"},{"key":"e_1_2_1_61_1","unstructured":"Pandas. 2024. Pandas Dataframes. Retrieved 2024-06-20 from https:\/\/pandas.pydata.org\/"},{"key":"e_1_2_1_62_1","doi-asserted-by":"publisher","DOI":"10.14778\/3554821.3554829"},{"key":"e_1_2_1_63_1","doi-asserted-by":"publisher","DOI":"10.14778\/2824032.2824078"},{"key":"e_1_2_1_64_1","doi-asserted-by":"publisher","DOI":"10.1145\/2723372.2747645"},{"key":"e_1_2_1_65_1","unstructured":"PostgreSQL. 2024. PostgreSQL - Foreign Data Wrappers. Retrieved 2024-06-20 from https:\/\/wiki.postgresql.org\/wiki\/Foreign_data_wrappers"},{"key":"e_1_2_1_66_1","doi-asserted-by":"publisher","DOI":"10.1145\/3209950.3209955"},{"key":"e_1_2_1_67_1","doi-asserted-by":"publisher","DOI":"10.1145\/3299869.3320212"},{"key":"e_1_2_1_68_1","volume-title":"Proceedings of the 25th International Conference on Very Large Data Bases (VLDB '99)","author":"Rao Jun","unstructured":"Jun Rao and Kenneth A. Ross. 1999. Cache Conscious Indexing for Decision-Support in Main Memory. In Proceedings of the 25th International Conference on Very Large Data Bases (VLDB '99). San Francisco, CA, USA, 78--89."},{"key":"e_1_2_1_69_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-1-4842-6216-0_5"},{"key":"e_1_2_1_70_1","unstructured":"Todd W. Schneider. 2022. New York City Taxi and For-Hire Vehicle Data. Retrieved 2024-06-20 from https:\/\/github.com\/toddwschneider\/nyc-taxi-data"},{"key":"e_1_2_1_71_1","volume-title":"Proceedings of the 31st International Conference on Very Large Data Bases (VLDB '05)","author":"Stonebraker Mike","year":"2005","unstructured":"Mike Stonebraker, Daniel J. Abadi, Adam Batkin, Xuedong Chen, Mitch Cherniack, Miguel Ferreira, Edmond Lau, Amerson Lin, Sam Madden, Elizabeth O'Neil, Pat O'Neil, Alex Rasin, Nga Tran, and Stan Zdonik. 2005. C-Store: A Column-Oriented DBMS. In Proceedings of the 31st International Conference on Very Large Data Bases (VLDB '05). 553--564."},{"key":"e_1_2_1_72_1","unstructured":"Teradata. 2024. Teradata Database. Retrieved 2024-06-20 from https:\/\/www.teradata.com\/resources\/datasheets\/teradata-database"},{"key":"e_1_2_1_74_1","doi-asserted-by":"publisher","DOI":"10.1145\/3209950.3209952"},{"key":"e_1_2_1_75_1","unstructured":"LZ4 website. 2024. LZ4. Retrieved 2024-06-20 from https:\/\/lz4.org\/"},{"key":"e_1_2_1_76_1","unstructured":"PRQL website. 2024. PRQL. Retrieved 2024-06-20 from https:\/\/prql-lang.org"},{"key":"e_1_2_1_77_1","doi-asserted-by":"publisher","DOI":"10.1145\/362084.362137"},{"key":"e_1_2_1_78_1","doi-asserted-by":"publisher","DOI":"10.1145\/2588555.2595631"},{"key":"e_1_2_1_79_1","doi-asserted-by":"publisher","DOI":"10.3390\/app10061915"},{"key":"e_1_2_1_80_1","doi-asserted-by":"publisher","DOI":"10.1145\/564691.564709"},{"key":"e_1_2_1_81_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2006.150"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3685800.3685802","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2024,12,31]],"date-time":"2024-12-31T05:24:45Z","timestamp":1735622685000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3685800.3685802"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2024,8]]},"references-count":80,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2024,8]]}},"alternative-id":["10.14778\/3685800.3685802"],"URL":"https:\/\/doi.org\/10.14778\/3685800.3685802","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2024,8]]},"assertion":[{"value":"2024-11-08","order":3,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}