{"id":"https://openalex.org/W2798926543","doi":"https://doi.org/10.1145/3183713.3196911","title":"Column Sketches","display_name":"Column Sketches","publication_year":2018,"publication_date":"2018-05-25","ids":{"openalex":"https://openalex.org/W2798926543","doi":"https://doi.org/10.1145/3183713.3196911","mag":"2798926543"},"language":"en","primary_location":{"id":"doi:10.1145/3183713.3196911","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3183713.3196911","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3183713.3196911","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2018 International Conference on Management of Data","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3183713.3196911","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5050007378","display_name":"Brian Hentschel","orcid":"https://orcid.org/0000-0001-8609-7904"},"institutions":[{"id":"https://openalex.org/I2801851002","display_name":"Harvard University Press","ror":"https://ror.org/006v7bf86","country_code":"US","type":"other","lineage":["https://openalex.org/I136199984","https://openalex.org/I2801851002"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Brian Hentschel","raw_affiliation_strings":["Harvard University, Cambridge, MA, USA"],"affiliations":[{"raw_affiliation_string":"Harvard University, Cambridge, MA, USA","institution_ids":["https://openalex.org/I2801851002"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5078048551","display_name":"Michael S. Kester","orcid":null},"institutions":[{"id":"https://openalex.org/I2801851002","display_name":"Harvard University Press","ror":"https://ror.org/006v7bf86","country_code":"US","type":"other","lineage":["https://openalex.org/I136199984","https://openalex.org/I2801851002"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Michael S. Kester","raw_affiliation_strings":["Harvard University, Cambridge, MA, USA"],"affiliations":[{"raw_affiliation_string":"Harvard University, Cambridge, MA, USA","institution_ids":["https://openalex.org/I2801851002"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5026905380","display_name":"Stratos Idreos","orcid":"https://orcid.org/0000-0002-8271-9187"},"institutions":[{"id":"https://openalex.org/I2801851002","display_name":"Harvard University Press","ror":"https://ror.org/006v7bf86","country_code":"US","type":"other","lineage":["https://openalex.org/I136199984","https://openalex.org/I2801851002"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Stratos Idreos","raw_affiliation_strings":["Harvard University, Cambridge, MA, USA"],"affiliations":[{"raw_affiliation_string":"Harvard University, Cambridge, MA, USA","institution_ids":["https://openalex.org/I2801851002"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5050007378"],"corresponding_institution_ids":["https://openalex.org/I2801851002"],"apc_list":null,"apc_paid":null,"fwci":4.1037,"has_fulltext":true,"cited_by_count":36,"citation_normalized_percentile":{"value":0.94304206,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"857","last_page":"872"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9995999932289124,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9995999932289124,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9995999932289124,"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/T11269","display_name":"Algorithms and Data Compression","score":0.9991000294685364,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/column","display_name":"Column (typography)","score":0.8163091540336609},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7714164853096008},{"id":"https://openalex.org/keywords/search-engine-indexing","display_name":"Search engine indexing","score":0.6384600400924683},{"id":"https://openalex.org/keywords/sketch","display_name":"Sketch","score":0.6021904349327087},{"id":"https://openalex.org/keywords/lossy-compression","display_name":"Lossy compression","score":0.5841053128242493},{"id":"https://openalex.org/keywords/memory-footprint","display_name":"Memory footprint","score":0.5173165798187256},{"id":"https://openalex.org/keywords/predicate","display_name":"Predicate (mathematical logic)","score":0.4771929979324341},{"id":"https://openalex.org/keywords/database-index","display_name":"Database index","score":0.46517300605773926},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.4507841169834137},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.43788477778434753},{"id":"https://openalex.org/keywords/data-structure","display_name":"Data structure","score":0.43549636006355286},{"id":"https://openalex.org/keywords/data-compression","display_name":"Data compression","score":0.4212878942489624},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.3963738977909088},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.35923266410827637},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.2781055271625519},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.25726020336151123},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.1150827407836914},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.10050398111343384}],"concepts":[{"id":"https://openalex.org/C2780551164","wikidata":"https://www.wikidata.org/wiki/Q2306599","display_name":"Column (typography)","level":3,"score":0.8163091540336609},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7714164853096008},{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.6384600400924683},{"id":"https://openalex.org/C2779231336","wikidata":"https://www.wikidata.org/wiki/Q7534724","display_name":"Sketch","level":2,"score":0.6021904349327087},{"id":"https://openalex.org/C165021410","wikidata":"https://www.wikidata.org/wiki/Q55564","display_name":"Lossy compression","level":2,"score":0.5841053128242493},{"id":"https://openalex.org/C74912251","wikidata":"https://www.wikidata.org/wiki/Q6815727","display_name":"Memory footprint","level":2,"score":0.5173165798187256},{"id":"https://openalex.org/C140146324","wikidata":"https://www.wikidata.org/wiki/Q1144319","display_name":"Predicate (mathematical logic)","level":2,"score":0.4771929979324341},{"id":"https://openalex.org/C59276292","wikidata":"https://www.wikidata.org/wiki/Q580427","display_name":"Database index","level":3,"score":0.46517300605773926},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.4507841169834137},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.43788477778434753},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.43549636006355286},{"id":"https://openalex.org/C78548338","wikidata":"https://www.wikidata.org/wiki/Q2493","display_name":"Data compression","level":2,"score":0.4212878942489624},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.3963738977909088},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.35923266410827637},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2781055271625519},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.25726020336151123},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.1150827407836914},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.10050398111343384},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0},{"id":"https://openalex.org/C126042441","wikidata":"https://www.wikidata.org/wiki/Q1324888","display_name":"Frame (networking)","level":2,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3183713.3196911","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3183713.3196911","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3183713.3196911","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2018 International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/3183713.3196911","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3183713.3196911","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3183713.3196911","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2018 International Conference on Management of Data","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G4096930039","display_name":null,"funder_award_id":"IIS-1452595","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G4462275839","display_name":"CAREER: Evolutionary Data Systems","funder_award_id":"1452595","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G848032724","display_name":null,"funder_award_id":"Science","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2798926543.pdf","grobid_xml":"https://content.openalex.org/works/W2798926543.grobid-xml"},"referenced_works_count":44,"referenced_works":["https://openalex.org/W1494049834","https://openalex.org/W1701312224","https://openalex.org/W1791987072","https://openalex.org/W1958304026","https://openalex.org/W1967601791","https://openalex.org/W1981988185","https://openalex.org/W1988645907","https://openalex.org/W1991223838","https://openalex.org/W1993819379","https://openalex.org/W1993892970","https://openalex.org/W2006296837","https://openalex.org/W2014180767","https://openalex.org/W2025533349","https://openalex.org/W2054046497","https://openalex.org/W2055774867","https://openalex.org/W2075345089","https://openalex.org/W2086977914","https://openalex.org/W2096496252","https://openalex.org/W2100542992","https://openalex.org/W2106867122","https://openalex.org/W2112735105","https://openalex.org/W2113831242","https://openalex.org/W2116420167","https://openalex.org/W2117546628","https://openalex.org/W2123686039","https://openalex.org/W2136083615","https://openalex.org/W2139072600","https://openalex.org/W2140453381","https://openalex.org/W2143125604","https://openalex.org/W2147076738","https://openalex.org/W2161694911","https://openalex.org/W2163422235","https://openalex.org/W2167911783","https://openalex.org/W2394680079","https://openalex.org/W2396727930","https://openalex.org/W2401640580","https://openalex.org/W2430301697","https://openalex.org/W2431462601","https://openalex.org/W2439390339","https://openalex.org/W2605843372","https://openalex.org/W3002580249","https://openalex.org/W3102704970","https://openalex.org/W6677064796","https://openalex.org/W6712120708"],"related_works":["https://openalex.org/W1995805316","https://openalex.org/W2387503788","https://openalex.org/W2059658550","https://openalex.org/W50067980","https://openalex.org/W2803920876","https://openalex.org/W2999957348","https://openalex.org/W2964219139","https://openalex.org/W4287903946","https://openalex.org/W3042625184","https://openalex.org/W2168653783"],"abstract_inverted_index":{"While":[0],"numerous":[1],"indexing":[2,47],"and":[3,36,89,134,152],"storage":[4,154],"schemes":[5,74],"have":[6],"been":[7],"developed":[8],"to":[9,32,110],"address":[10],"the":[11,55,69,80,125,131,139,143],"core":[12],"functionality":[13],"of":[14,46,57,61,71,113,128],"predicate":[15,58],"evaluation":[16,59],"in":[17,38],"data":[18,28,30,83,109,141],"systems,":[19],"they":[20],"all":[21],"require":[22],"specific":[23],"workload":[24,62],"properties":[25],"(query":[26],"selectivity,":[27],"distribution,":[29],"clustering)":[31],"provide":[33],"good":[34],"performance":[35,56],"fail":[37],"other":[39],"cases.":[40],"We":[41],"present":[42],"a":[43,50,104,111],"new":[44],"class":[45],"scheme,":[48],"termed":[49],"Column":[51,64,95,146],"Sketch,":[52],"which":[53,75],"improves":[54],"independently":[60],"properties.":[63],"Sketches":[65,147],"work":[66,148],"primarily":[67],"through":[68],"use":[70],"lossy":[72,101],"compression":[73,102],"are":[76,119],"designed":[77],"so":[78],"that":[79],"index":[81],"ingests":[82],"quickly,":[84],"evaluates":[85],"any":[86],"query":[87],"performantly,":[88],"has":[90],"small":[91],"memory":[92],"footprint.":[93],"A":[94],"Sketch":[96],"works":[97],"by":[98],"applying":[99],"this":[100],"on":[103],"value-by-value":[105],"basis,":[106],"mapping":[107],"base":[108,140],"representation":[112],"smaller":[114],"fixed":[115],"width":[116],"codes.":[117],"Queries":[118],"evaluated":[120],"affirmatively":[121],"or":[122],"negatively":[123],"for":[124,142],"vast":[126],"majority":[127],"values":[129],"using":[130],"compressed":[132],"data,":[133],"only":[135],"if":[136],"needed":[137],"check":[138],"remaining":[144],"values.":[145],"over":[149],"column,":[150],"row,":[151],"hybrid":[153],"layouts.":[155]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":4},{"year":2023,"cited_by_count":4},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":6},{"year":2020,"cited_by_count":9},{"year":2019,"cited_by_count":5},{"year":2018,"cited_by_count":1}],"updated_date":"2026-04-10T15:06:20.359241","created_date":"2018-05-07T00:00:00"}