{"id":"https://openalex.org/W4404181190","doi":"https://doi.org/10.14778/3685800.3685802","title":"ClickHouse - Lightning Fast Analytics for Everyone","display_name":"ClickHouse - Lightning Fast Analytics for Everyone","publication_year":2024,"publication_date":"2024-08-01","ids":{"openalex":"https://openalex.org/W4404181190","doi":"https://doi.org/10.14778/3685800.3685802"},"language":"en","primary_location":{"id":"doi:10.14778/3685800.3685802","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3685800.3685802","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5004526505","display_name":"R.H. Schulze","orcid":null},"institutions":[{"id":"https://openalex.org/I4210100547","display_name":"Springhouse","ror":"https://ror.org/00y8jqa74","country_code":"US","type":"nonprofit","lineage":["https://openalex.org/I4210100547"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Robert Schulze","raw_affiliation_strings":["ClickHouse Inc"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"ClickHouse Inc","institution_ids":["https://openalex.org/I4210100547"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Tom Schreiber","orcid":null},"institutions":[{"id":"https://openalex.org/I4210100547","display_name":"Springhouse","ror":"https://ror.org/00y8jqa74","country_code":"US","type":"nonprofit","lineage":["https://openalex.org/I4210100547"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Tom Schreiber","raw_affiliation_strings":["ClickHouse Inc"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"ClickHouse Inc","institution_ids":["https://openalex.org/I4210100547"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5114567525","display_name":"Ilya Yatsishin","orcid":null},"institutions":[{"id":"https://openalex.org/I4210100547","display_name":"Springhouse","ror":"https://ror.org/00y8jqa74","country_code":"US","type":"nonprofit","lineage":["https://openalex.org/I4210100547"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ilya Yatsishin","raw_affiliation_strings":["ClickHouse Inc"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"ClickHouse Inc","institution_ids":["https://openalex.org/I4210100547"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5060389771","display_name":"Ryadh Dahimene","orcid":null},"institutions":[{"id":"https://openalex.org/I4210100547","display_name":"Springhouse","ror":"https://ror.org/00y8jqa74","country_code":"US","type":"nonprofit","lineage":["https://openalex.org/I4210100547"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ryadh Dahimene","raw_affiliation_strings":["ClickHouse Inc"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"ClickHouse Inc","institution_ids":["https://openalex.org/I4210100547"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5114567526","display_name":"Alexey Milovidov","orcid":null},"institutions":[{"id":"https://openalex.org/I4210100547","display_name":"Springhouse","ror":"https://ror.org/00y8jqa74","country_code":"US","type":"nonprofit","lineage":["https://openalex.org/I4210100547"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Alexey Milovidov","raw_affiliation_strings":["ClickHouse Inc"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"ClickHouse Inc","institution_ids":["https://openalex.org/I4210100547"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I4210100547"],"apc_list":null,"apc_paid":null,"fwci":7.405,"has_fulltext":false,"cited_by_count":34,"citation_normalized_percentile":{"value":0.97835146,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":99,"max":100},"biblio":{"volume":"17","issue":"12","first_page":"3731","last_page":"3744"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9965999722480774,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9965999722480774,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9896000027656555,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T12016","display_name":"Web Data Mining and Analysis","score":0.9890000224113464,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/lightning","display_name":"Lightning (connector)","score":0.6864691972732544},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.6123219132423401},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.4595235288143158},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.43646252155303955},{"id":"https://openalex.org/keywords/meteorology","display_name":"Meteorology","score":0.3553306460380554},{"id":"https://openalex.org/keywords/geography","display_name":"Geography","score":0.21423640847206116},{"id":"https://openalex.org/keywords/physics","display_name":"Physics","score":0.1401025950908661}],"concepts":[{"id":"https://openalex.org/C69398868","wikidata":"https://www.wikidata.org/wiki/Q129052","display_name":"Lightning (connector)","level":3,"score":0.6864691972732544},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.6123219132423401},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.4595235288143158},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.43646252155303955},{"id":"https://openalex.org/C153294291","wikidata":"https://www.wikidata.org/wiki/Q25261","display_name":"Meteorology","level":1,"score":0.3553306460380554},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.21423640847206116},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.1401025950908661},{"id":"https://openalex.org/C163258240","wikidata":"https://www.wikidata.org/wiki/Q25342","display_name":"Power (physics)","level":2,"score":0.0},{"id":"https://openalex.org/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3685800.3685802","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3685800.3685802","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9","score":0.6200000047683716}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":51,"referenced_works":["https://openalex.org/W585560688","https://openalex.org/W1547206386","https://openalex.org/W1578512165","https://openalex.org/W1993505169","https://openalex.org/W1993819379","https://openalex.org/W2006296837","https://openalex.org/W2020129682","https://openalex.org/W2030062409","https://openalex.org/W2057714068","https://openalex.org/W2068739275","https://openalex.org/W2086977914","https://openalex.org/W2097880677","https://openalex.org/W2099035968","https://openalex.org/W2104242181","https://openalex.org/W2106771621","https://openalex.org/W2123686039","https://openalex.org/W2123845384","https://openalex.org/W2140453381","https://openalex.org/W2144982963","https://openalex.org/W2147076738","https://openalex.org/W2151224499","https://openalex.org/W2158237121","https://openalex.org/W2164030956","https://openalex.org/W2294581520","https://openalex.org/W2430301697","https://openalex.org/W2439390339","https://openalex.org/W2476218384","https://openalex.org/W2621452375","https://openalex.org/W2794632349","https://openalex.org/W2798611317","https://openalex.org/W2806056912","https://openalex.org/W2806617922","https://openalex.org/W2949054050","https://openalex.org/W2950461515","https://openalex.org/W3011835131","https://openalex.org/W3022398217","https://openalex.org/W3085940077","https://openalex.org/W3089521661","https://openalex.org/W3117786929","https://openalex.org/W3136655632","https://openalex.org/W3160544573","https://openalex.org/W3167346145","https://openalex.org/W3207452942","https://openalex.org/W4233550397","https://openalex.org/W4249653116","https://openalex.org/W4281715865","https://openalex.org/W4281718197","https://openalex.org/W4282585030","https://openalex.org/W4312292115","https://openalex.org/W4323024553","https://openalex.org/W4386128176"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W4391913857","https://openalex.org/W1516442247","https://openalex.org/W2009005855","https://openalex.org/W2508104662","https://openalex.org/W763284094","https://openalex.org/W154198252"],"abstract_inverted_index":{"Over":[0],"the":[1,5,82,136,181,197,202],"past":[2],"several":[3],"decades,":[4],"amount":[6],"of":[7,66,72,90,132,163],"data":[8,26,38,52,103,114,134,170,174],"being":[9],"stored":[10],"and":[11,19,32,50,56,69,146],"analyzed":[12],"has":[13],"increased":[14],"exponentially.":[15],"Businesses":[16],"across":[17],"industries":[18],"sectors":[20],"have":[21,40,45],"begun":[22],"relying":[23],"on":[24,81,117,201],"this":[25],"to":[27,47,166],"improve":[28],"products,":[29],"evaluate":[30],"performance,":[31],"make":[33],"business-critical":[34],"decisions.":[35],"However,":[36],"as":[37],"volumes":[39],"increasingly":[41],"become":[42],"internet-scale,":[43],"businesses":[44],"needed":[46],"manage":[48],"historical":[49,133],"new":[51],"in":[53,135,141,171],"a":[54,63,92,113,142,149],"cost-effective":[55],"scalable":[57],"manner,":[58],"while":[59],"analyzing":[60],"it":[61],"using":[62],"high":[64,106],"number":[65],"concurrent":[67],"queries":[68],"an":[70,88],"expectation":[71],"real-time":[73],"latencies":[74],"(e.g.":[75,129],"less":[76],"than":[77],"one":[78],"second,":[79],"depending":[80],"use":[83,162],"case).":[84],"This":[85],"paper":[86],"presents":[87],"overview":[89],"ClickHouse,":[91],"popular":[93],"open-source":[94],"OLAP":[95],"database":[96,187],"designed":[97],"for":[98,126],"high-performance":[99],"analytics":[100],"over":[101],"petabyte-scale":[102],"sets":[104],"with":[105,123,155],"ingestion":[107],"rates.":[108],"Its":[109],"storage":[110],"layer":[111],"combines":[112],"format":[115],"based":[116],"traditional":[118],"log-structured":[119],"merge":[120],"(LSM)":[121],"trees":[122],"novel":[124],"techniques":[125,165],"continuous":[127],"transformation":[128],"aggregation,":[130],"archiving)":[131],"background.":[137],"Queries":[138],"are":[139],"written":[140],"convenient":[143],"SQL":[144],"dialect":[145],"processed":[147],"by":[148],"state-of-the-art":[150],"vectorized":[151],"query":[152],"execution":[153],"engine":[154,188],"optional":[156],"code":[157],"compilation.":[158],"ClickHouse":[159,194],"makes":[160],"aggressive":[161],"pruning":[164],"avoid":[167],"evaluating":[168],"irrelevant":[169],"queries.":[172],"Other":[173],"management":[175],"systems":[176],"can":[177],"be":[178],"integrated":[179],"at":[180],"table":[182,184],"function,":[183],"engine,":[185],"or":[186],"level.":[189],"Real-world":[190],"benchmarks":[191],"demonstrate":[192],"that":[193],"is":[195],"amongst":[196],"fastest":[198],"analytical":[199],"databases":[200],"market.":[203]},"counts_by_year":[{"year":2026,"cited_by_count":10},{"year":2025,"cited_by_count":24}],"updated_date":"2026-07-18T07:39:51.176621","created_date":"2025-10-10T00:00:00"}