{"id":"https://openalex.org/W2951446960","doi":"https://doi.org/10.1145/3299869.3300094","title":"Fingerprints for Compressed Columnar Data Search","display_name":"Fingerprints for Compressed Columnar Data Search","publication_year":2019,"publication_date":"2019-06-18","ids":{"openalex":"https://openalex.org/W2951446960","doi":"https://doi.org/10.1145/3299869.3300094","mag":"2951446960"},"language":"en","primary_location":{"id":"doi:10.1145/3299869.3300094","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3299869.3300094","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2019 International Conference on Management of Data","raw_type":"proceedings-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/A5112966191","display_name":"Carmen Kwan","orcid":null},"institutions":[{"id":"https://openalex.org/I151746483","display_name":"University of Waterloo","ror":"https://ror.org/01aff2v68","country_code":"CA","type":"education","lineage":["https://openalex.org/I151746483"]}],"countries":["CA"],"is_corresponding":true,"raw_author_name":"Carmen Kwan","raw_affiliation_strings":["University of Waterloo, Waterloo, ON, Canada"],"affiliations":[{"raw_affiliation_string":"University of Waterloo, Waterloo, ON, Canada","institution_ids":["https://openalex.org/I151746483"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5112966191"],"corresponding_institution_ids":["https://openalex.org/I151746483"],"apc_list":null,"apc_paid":null,"fwci":0.1659,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.4275807,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"1835","last_page":"1837"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/T11106","display_name":"Data Management and Algorithms","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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.9991999864578247,"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"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9984999895095825,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7852936387062073},{"id":"https://openalex.org/keywords/overhead","display_name":"Overhead (engineering)","score":0.7379993200302124},{"id":"https://openalex.org/keywords/block","display_name":"Block (permutation group theory)","score":0.6449600458145142},{"id":"https://openalex.org/keywords/data-compression","display_name":"Data compression","score":0.5775437355041504},{"id":"https://openalex.org/keywords/volume","display_name":"Volume (thermodynamics)","score":0.5693013668060303},{"id":"https://openalex.org/keywords/compression","display_name":"Compression (physics)","score":0.5480287075042725},{"id":"https://openalex.org/keywords/column","display_name":"Column (typography)","score":0.5333265066146851},{"id":"https://openalex.org/keywords/memory-management","display_name":"Memory management","score":0.5310336351394653},{"id":"https://openalex.org/keywords/compression-ratio","display_name":"Compression ratio","score":0.5009627342224121},{"id":"https://openalex.org/keywords/auxiliary-memory","display_name":"Auxiliary memory","score":0.4607554078102112},{"id":"https://openalex.org/keywords/data-structure","display_name":"Data structure","score":0.4504849910736084},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.42620334029197693},{"id":"https://openalex.org/keywords/minimax","display_name":"Minimax","score":0.4236799478530884},{"id":"https://openalex.org/keywords/data-compression-ratio","display_name":"Data compression ratio","score":0.41987258195877075},{"id":"https://openalex.org/keywords/computer-hardware","display_name":"Computer hardware","score":0.3091426491737366},{"id":"https://openalex.org/keywords/semiconductor-memory","display_name":"Semiconductor memory","score":0.24077895283699036},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.23362338542938232},{"id":"https://openalex.org/keywords/image-compression","display_name":"Image compression","score":0.1604558229446411},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.1470520794391632},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.10854914784431458},{"id":"https://openalex.org/keywords/computer-network","display_name":"Computer network","score":0.09120145440101624},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.08108898997306824},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.07173055410385132}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7852936387062073},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.7379993200302124},{"id":"https://openalex.org/C2777210771","wikidata":"https://www.wikidata.org/wiki/Q4927124","display_name":"Block (permutation group theory)","level":2,"score":0.6449600458145142},{"id":"https://openalex.org/C78548338","wikidata":"https://www.wikidata.org/wiki/Q2493","display_name":"Data compression","level":2,"score":0.5775437355041504},{"id":"https://openalex.org/C20556612","wikidata":"https://www.wikidata.org/wiki/Q4469374","display_name":"Volume (thermodynamics)","level":2,"score":0.5693013668060303},{"id":"https://openalex.org/C180016635","wikidata":"https://www.wikidata.org/wiki/Q2712821","display_name":"Compression (physics)","level":2,"score":0.5480287075042725},{"id":"https://openalex.org/C2780551164","wikidata":"https://www.wikidata.org/wiki/Q2306599","display_name":"Column (typography)","level":3,"score":0.5333265066146851},{"id":"https://openalex.org/C176649486","wikidata":"https://www.wikidata.org/wiki/Q2308807","display_name":"Memory management","level":3,"score":0.5310336351394653},{"id":"https://openalex.org/C25797200","wikidata":"https://www.wikidata.org/wiki/Q828137","display_name":"Compression ratio","level":3,"score":0.5009627342224121},{"id":"https://openalex.org/C82687282","wikidata":"https://www.wikidata.org/wiki/Q66221","display_name":"Auxiliary memory","level":2,"score":0.4607554078102112},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.4504849910736084},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.42620334029197693},{"id":"https://openalex.org/C149728462","wikidata":"https://www.wikidata.org/wiki/Q751319","display_name":"Minimax","level":2,"score":0.4236799478530884},{"id":"https://openalex.org/C94835093","wikidata":"https://www.wikidata.org/wiki/Q3113333","display_name":"Data compression ratio","level":5,"score":0.41987258195877075},{"id":"https://openalex.org/C9390403","wikidata":"https://www.wikidata.org/wiki/Q3966","display_name":"Computer hardware","level":1,"score":0.3091426491737366},{"id":"https://openalex.org/C98986596","wikidata":"https://www.wikidata.org/wiki/Q1143031","display_name":"Semiconductor memory","level":2,"score":0.24077895283699036},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.23362338542938232},{"id":"https://openalex.org/C13481523","wikidata":"https://www.wikidata.org/wiki/Q412438","display_name":"Image compression","level":4,"score":0.1604558229446411},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.1470520794391632},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.10854914784431458},{"id":"https://openalex.org/C31258907","wikidata":"https://www.wikidata.org/wiki/Q1301371","display_name":"Computer network","level":1,"score":0.09120145440101624},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.08108898997306824},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.07173055410385132},{"id":"https://openalex.org/C9417928","wikidata":"https://www.wikidata.org/wiki/Q1070689","display_name":"Image processing","level":3,"score":0.0},{"id":"https://openalex.org/C115961682","wikidata":"https://www.wikidata.org/wiki/Q860623","display_name":"Image (mathematics)","level":2,"score":0.0},{"id":"https://openalex.org/C171146098","wikidata":"https://www.wikidata.org/wiki/Q124192","display_name":"Automotive engineering","level":1,"score":0.0},{"id":"https://openalex.org/C126255220","wikidata":"https://www.wikidata.org/wiki/Q141495","display_name":"Mathematical optimization","level":1,"score":0.0},{"id":"https://openalex.org/C511840579","wikidata":"https://www.wikidata.org/wiki/Q12757","display_name":"Internal combustion engine","level":2,"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/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"score":0.0},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"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.1145/3299869.3300094","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3299869.3300094","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2019 International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":8,"referenced_works":["https://openalex.org/W1494049834","https://openalex.org/W2055774867","https://openalex.org/W2112735105","https://openalex.org/W2156930555","https://openalex.org/W2214686917","https://openalex.org/W2431462601","https://openalex.org/W2753023756","https://openalex.org/W2790185691"],"related_works":["https://openalex.org/W2768628697","https://openalex.org/W1973200086","https://openalex.org/W1965503293","https://openalex.org/W2388481516","https://openalex.org/W2088378984","https://openalex.org/W2356662348","https://openalex.org/W2386366915","https://openalex.org/W4220868150","https://openalex.org/W2141840609","https://openalex.org/W2352008669"],"abstract_inverted_index":{"To":[0],"enhance":[1],"performance":[2,39],"in":[3],"main":[4],"memory":[5,37,79],"databases,":[6],"compression":[7,31,110],"techniques":[8],"have":[9],"been":[10],"suggested":[11],"to":[12,21,46,96],"keep":[13],"large":[14],"volume":[15],"of":[16,107],"data":[17,23,44,61,73,100],"in-memory,":[18],"as":[19],"opposed":[20],"loading":[22],"on":[24,71],"demand":[25],"from":[26],"slower":[27],"media":[28],"storage.":[29],"High":[30],"ratio,":[32],"however,":[33],"comes":[34],"with":[35],"both":[36],"and":[38,102],"overhead":[40,106],"for":[41,82,98],"queries;":[42],"packed":[43],"needs":[45],"be":[47],"decompressed":[48],"into":[49],"vectors":[50],"before":[51],"applying":[52],"optimized":[53],"scan":[54],"algorithms.":[55],"In":[56],"this":[57],"work,":[58],"we":[59],"propose":[60],"summaries":[62],"at":[63],"column":[64],"block":[65,86],"level.":[66],"Our":[67],"preliminary":[68],"experimental":[69],"studies":[70],"TPC-H":[72],"confirm":[74],"that":[75],"under":[76],"the":[77,90,105],"same":[78],"budget":[80],"used":[81],"MinMax":[83],"synopsis,":[84],"our":[85],"headers":[87],"can":[88,103],"lower":[89],"false":[91],"positive":[92],"rates":[93],"by":[94],"up":[95],"30%":[97],"compressed":[99],"scans":[101],"reduce":[104],"employing":[108],"advanced":[109],"schemes.":[111]},"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2021,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}