{"id":"https://openalex.org/W2129509514","doi":"https://doi.org/10.1145/2452376.2452381","title":"Query-aware compression of join results","display_name":"Query-aware compression of join results","publication_year":2013,"publication_date":"2013-03-18","ids":{"openalex":"https://openalex.org/W2129509514","doi":"https://doi.org/10.1145/2452376.2452381","mag":"2129509514"},"language":"en","primary_location":{"id":"doi:10.1145/2452376.2452381","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2452376.2452381","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 16th International Conference on Extending Database Technology","raw_type":"proceedings-article"},"type":"conference-paper","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/A5049550752","display_name":"Christopher M. Mullins","orcid":null},"institutions":[{"id":"https://openalex.org/I117965899","display_name":"University of Hawai\u02bbi at M\u0101noa","ror":"https://ror.org/01wspgy28","country_code":"US","type":"education","lineage":["https://openalex.org/I117965899"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Christopher M. Mullins","raw_affiliation_strings":["University of Hawai'i at M\u0101noa, Honolulu, HI"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Hawai'i at M\u0101noa, Honolulu, HI","institution_ids":["https://openalex.org/I117965899"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5109215836","display_name":"Lipyeow Lim","orcid":null},"institutions":[{"id":"https://openalex.org/I117965899","display_name":"University of Hawai\u02bbi at M\u0101noa","ror":"https://ror.org/01wspgy28","country_code":"US","type":"education","lineage":["https://openalex.org/I117965899"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Lipyeow Lim","raw_affiliation_strings":["University of Hawai'i at M\u0101noa, Honolulu, HI"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Hawai'i at M\u0101noa, Honolulu, HI","institution_ids":["https://openalex.org/I117965899"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5110235377","display_name":"Christian A. Lang","orcid":null},"institutions":[{"id":"https://openalex.org/I4210164055","display_name":"Acelot (United States)","ror":"https://ror.org/05g51bs78","country_code":"US","type":"company","lineage":["https://openalex.org/I4210164055"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Christian A. Lang","raw_affiliation_strings":["Acelot Inc. Santa Barbara, CA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Acelot Inc. Santa Barbara, CA","institution_ids":["https://openalex.org/I4210164055"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.2288,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.51097887,"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":"29","last_page":"40"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11269","display_name":"Algorithms and Data Compression","score":0.9998000264167786,"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"}},"topics":[{"id":"https://openalex.org/T11269","display_name":"Algorithms and Data Compression","score":0.9998000264167786,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9986000061035156,"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.9976999759674072,"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.900957465171814},{"id":"https://openalex.org/keywords/server","display_name":"Server","score":0.6277624368667603},{"id":"https://openalex.org/keywords/redundancy","display_name":"Redundancy (engineering)","score":0.578048825263977},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5622469186782837},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5532057285308838},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.5375589728355408},{"id":"https://openalex.org/keywords/cloud-computing","display_name":"Cloud computing","score":0.5307937264442444},{"id":"https://openalex.org/keywords/exploit","display_name":"Exploit","score":0.5235702395439148},{"id":"https://openalex.org/keywords/data-redundancy","display_name":"Data redundancy","score":0.5040454268455505},{"id":"https://openalex.org/keywords/data-compression","display_name":"Data compression","score":0.4856792688369751},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.45897597074508667},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.4489186108112335},{"id":"https://openalex.org/keywords/query-expansion","display_name":"Query expansion","score":0.438017874956131},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.41629230976104736},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.3571043312549591},{"id":"https://openalex.org/keywords/computer-network","display_name":"Computer network","score":0.2416246235370636},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.22207561135292053},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.15867099165916443},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.1501636803150177},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.11243963241577148}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.900957465171814},{"id":"https://openalex.org/C93996380","wikidata":"https://www.wikidata.org/wiki/Q44127","display_name":"Server","level":2,"score":0.6277624368667603},{"id":"https://openalex.org/C152124472","wikidata":"https://www.wikidata.org/wiki/Q1204361","display_name":"Redundancy (engineering)","level":2,"score":0.578048825263977},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5622469186782837},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5532057285308838},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.5375589728355408},{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.5307937264442444},{"id":"https://openalex.org/C165696696","wikidata":"https://www.wikidata.org/wiki/Q11287","display_name":"Exploit","level":2,"score":0.5235702395439148},{"id":"https://openalex.org/C7545210","wikidata":"https://www.wikidata.org/wiki/Q838123","display_name":"Data redundancy","level":2,"score":0.5040454268455505},{"id":"https://openalex.org/C78548338","wikidata":"https://www.wikidata.org/wiki/Q2493","display_name":"Data compression","level":2,"score":0.4856792688369751},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.45897597074508667},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.4489186108112335},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.438017874956131},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.41629230976104736},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.3571043312549591},{"id":"https://openalex.org/C31258907","wikidata":"https://www.wikidata.org/wiki/Q1301371","display_name":"Computer network","level":1,"score":0.2416246235370636},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.22207561135292053},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.15867099165916443},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.1501636803150177},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.11243963241577148},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/2452376.2452381","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2452376.2452381","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 16th International Conference on Extending Database Technology","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.309.439","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.309.439","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.edbt.org/Proceedings/2013-Genova/papers/edbt/a4-mullins.pdf","raw_type":"text"},{"id":"pmh:oai:scholarspace.manoa.hawaii.edu:10125/100844","is_oa":false,"landing_page_url":"http://hdl.handle.net/10125/100844","pdf_url":null,"source":{"id":"https://openalex.org/S4306401722","display_name":"ScholarSpace (University of Hawaii at Manoa)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I117965899","host_organization_name":"University of Hawai\u02bbi at M\u0101noa","host_organization_lineage":["https://openalex.org/I117965899"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Thesis"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4","score":0.4300000071525574}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":51,"referenced_works":["https://openalex.org/W21419474","https://openalex.org/W151672524","https://openalex.org/W966055004","https://openalex.org/W1513149896","https://openalex.org/W1513521910","https://openalex.org/W1523899591","https://openalex.org/W1528043135","https://openalex.org/W1531483821","https://openalex.org/W1542115042","https://openalex.org/W1558322811","https://openalex.org/W1605699237","https://openalex.org/W1777016212","https://openalex.org/W1846198342","https://openalex.org/W1866610727","https://openalex.org/W1871722334","https://openalex.org/W1924595401","https://openalex.org/W1958354273","https://openalex.org/W2018745370","https://openalex.org/W2060108852","https://openalex.org/W2084618278","https://openalex.org/W2085601491","https://openalex.org/W2104241162","https://openalex.org/W2105326258","https://openalex.org/W2107745473","https://openalex.org/W2108392934","https://openalex.org/W2114474644","https://openalex.org/W2121611671","https://openalex.org/W2122962290","https://openalex.org/W2123686039","https://openalex.org/W2129652681","https://openalex.org/W2140934288","https://openalex.org/W2144361113","https://openalex.org/W2151131744","https://openalex.org/W2156000104","https://openalex.org/W2163370513","https://openalex.org/W2163400087","https://openalex.org/W2167911783","https://openalex.org/W2179478547","https://openalex.org/W2223770714","https://openalex.org/W2248959099","https://openalex.org/W2254153510","https://openalex.org/W2264694187","https://openalex.org/W2270569717","https://openalex.org/W2278064521","https://openalex.org/W2286986840","https://openalex.org/W2337543152","https://openalex.org/W2341510490","https://openalex.org/W6632042279","https://openalex.org/W6637972537","https://openalex.org/W6681444788","https://openalex.org/W6683141764"],"related_works":["https://openalex.org/W2096359267","https://openalex.org/W2901901036","https://openalex.org/W2093300859","https://openalex.org/W2026738364","https://openalex.org/W2150741898","https://openalex.org/W3125756434","https://openalex.org/W185198413","https://openalex.org/W2186703450","https://openalex.org/W4381740310","https://openalex.org/W2970853428"],"abstract_inverted_index":{"Client-server":[0],"database":[1,128,154],"query":[2,65,88,106,124,148],"processing":[3,12,31],"has":[4],"become":[5],"an":[6],"important":[7],"paradigm":[8],"in":[9,80,176,184,218],"many":[10],"data":[11,17,24,58,67,92],"applications":[13],"today.":[14],"In":[15,112],"cloud-based":[16,28,47],"services,":[18],"for":[19,30,109,122],"example,":[20],"queries":[21],"over":[22],"structured":[23],"are":[25,189,236],"sent":[26,126],"to":[27,37,60,130,156,172,193,195,231],"servers":[29,48,129],"and":[32,46,54,150,179],"the":[33,38,55,62,81,105,147,153,185,206],"results":[34,125,224],"relayed":[35],"back":[36],"client":[39,44,85,131],"devices.":[40,86],"Network":[41],"bandwidth":[42,73],"between":[43],"devices":[45],"is":[49,135,213],"often":[50],"a":[51,117,167,177],"limited":[52],"resource":[53],"use":[56,166],"of":[57,64,83,169,187,229,234],"compression":[59,93,120,159,227],"reduce":[61],"amount":[63],"result":[66,89],"transmitted":[68],"would":[69],"not":[70,96],"only":[71],"conserve":[72],"but":[74],"also":[75,190],"help":[76],"with":[77,220],"battery":[78],"lifetime":[79],"case":[82],"mobile":[84],"For":[87],"compression,":[90],"current":[91],"methods":[94],"do":[95],"exploit":[97,142],"redundancy":[98,143],"information":[99,144],"that":[100,210,226,233],"can":[101],"be":[102],"inferred":[103],"from":[104,127,146,152],"structure":[107],"itself":[108],"greater":[110],"compression.":[111],"this":[113,211],"paper":[114],"we":[115],"propose":[116],"novel":[118],"query-aware":[119],"method":[121,134,203],"compressing":[123],"applications.":[132],"Our":[133,223],"based":[136],"on":[137],"two":[138],"key":[139],"ideas.":[140],"We":[141,165,200],"obtained":[145],"plan":[149],"possibly":[151],"schema":[155],"achieve":[157],"better":[158],"than":[160],"standard":[161,221],"non-query":[162],"aware":[163],"compressors.":[164,222],"collection":[168,186],"memory-limited":[170],"dictionaries":[171,188],"encode":[173],"attribute":[174],"values":[175],"lightweight":[178],"efficient":[180],"manner.":[181],"Each":[182],"dictionary":[183],"dynamically":[191],"resized":[192],"adapt":[194],"changing":[196],"temporal":[197],"access":[198],"characteristics.":[199],"evaluated":[201],"our":[202],"empirically":[204],"using":[205],"TPC-H":[207],"benchmark":[208],"show":[209,225],"technique":[212],"effective":[214],"especially":[215],"when":[216],"used":[217],"conjunction":[219],"ratios":[228],"up":[230],"twice":[232],"gzip":[235],"possible.":[237]},"counts_by_year":[{"year":2021,"cited_by_count":1},{"year":2015,"cited_by_count":1}],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}