{"id":"https://openalex.org/W1991223838","doi":"https://doi.org/10.1145/2723372.2737787","title":"A Padded Encoding Scheme to Accelerate Scans by Leveraging Skew","display_name":"A Padded Encoding Scheme to Accelerate Scans by Leveraging Skew","publication_year":2015,"publication_date":"2015-05-27","ids":{"openalex":"https://openalex.org/W1991223838","doi":"https://doi.org/10.1145/2723372.2737787","mag":"1991223838"},"language":"en","primary_location":{"id":"doi:10.1145/2723372.2737787","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2723372.2737787","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2015 ACM SIGMOD International Conference on Management of Data","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/A5100599394","display_name":"Yinan Li","orcid":"https://orcid.org/0000-0001-7137-7823"},"institutions":[{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yinan Li","raw_affiliation_strings":["University of Wisconsin-Madison, Madison, WI, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Wisconsin-Madison, Madison, WI, USA","institution_ids":["https://openalex.org/I135310074"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5037764759","display_name":"Craig Chasseur","orcid":null},"institutions":[{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Craig Chasseur","raw_affiliation_strings":["University of Wisconsin-Madison, Madison, WI, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Wisconsin-Madison, Madison, WI, USA","institution_ids":["https://openalex.org/I135310074"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5069237428","display_name":"Jignesh M. Patel","orcid":"https://orcid.org/0000-0003-3653-2538"},"institutions":[{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jignesh M. Patel","raw_affiliation_strings":["University of Wisconsin-Madison, Madison, WI, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Wisconsin-Madison, Madison, WI, USA","institution_ids":["https://openalex.org/I135310074"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I135310074"],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":19,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"1509","last_page":"1524"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9987999796867371,"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.9987999796867371,"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.9973000288009644,"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.9873999953269958,"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/encoding","display_name":"Encoding (memory)","score":0.8254783153533936},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7591952681541443},{"id":"https://openalex.org/keywords/skew","display_name":"Skew","score":0.6965802907943726},{"id":"https://openalex.org/keywords/encode","display_name":"ENCODE","score":0.6002854108810425},{"id":"https://openalex.org/keywords/overhead","display_name":"Overhead (engineering)","score":0.561704158782959},{"id":"https://openalex.org/keywords/computation","display_name":"Computation","score":0.5117497444152832},{"id":"https://openalex.org/keywords/code","display_name":"Code (set theory)","score":0.46667635440826416},{"id":"https://openalex.org/keywords/decoding-methods","display_name":"Decoding methods","score":0.4572063088417053},{"id":"https://openalex.org/keywords/scheme","display_name":"Scheme (mathematics)","score":0.4195970892906189},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.4172601103782654},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.3466529846191406},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.33341461420059204},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.20743492245674133},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.14103561639785767},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.0788792073726654}],"concepts":[{"id":"https://openalex.org/C125411270","wikidata":"https://www.wikidata.org/wiki/Q18653","display_name":"Encoding (memory)","level":2,"score":0.8254783153533936},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7591952681541443},{"id":"https://openalex.org/C43711488","wikidata":"https://www.wikidata.org/wiki/Q7534783","display_name":"Skew","level":2,"score":0.6965802907943726},{"id":"https://openalex.org/C66746571","wikidata":"https://www.wikidata.org/wiki/Q1134833","display_name":"ENCODE","level":3,"score":0.6002854108810425},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.561704158782959},{"id":"https://openalex.org/C45374587","wikidata":"https://www.wikidata.org/wiki/Q12525525","display_name":"Computation","level":2,"score":0.5117497444152832},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.46667635440826416},{"id":"https://openalex.org/C57273362","wikidata":"https://www.wikidata.org/wiki/Q576722","display_name":"Decoding methods","level":2,"score":0.4572063088417053},{"id":"https://openalex.org/C77618280","wikidata":"https://www.wikidata.org/wiki/Q1155772","display_name":"Scheme (mathematics)","level":2,"score":0.4195970892906189},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.4172601103782654},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.3466529846191406},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.33341461420059204},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.20743492245674133},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.14103561639785767},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.0788792073726654},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2723372.2737787","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2723372.2737787","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2015 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G5398065212","display_name":null,"funder_award_id":"IIS-0963993,IIS-1110948,IIS-1250886","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":false,"pdf":false},"content_urls":null,"referenced_works_count":48,"referenced_works":["https://openalex.org/W100509257","https://openalex.org/W1495007564","https://openalex.org/W1520750340","https://openalex.org/W1597532222","https://openalex.org/W1608665031","https://openalex.org/W1967601791","https://openalex.org/W1967983783","https://openalex.org/W1981988185","https://openalex.org/W1988325634","https://openalex.org/W1995302096","https://openalex.org/W2006296837","https://openalex.org/W2019485818","https://openalex.org/W2024463287","https://openalex.org/W2031780529","https://openalex.org/W2037027334","https://openalex.org/W2043099794","https://openalex.org/W2054046497","https://openalex.org/W2055774867","https://openalex.org/W2060108852","https://openalex.org/W2065954102","https://openalex.org/W2068373264","https://openalex.org/W2074935284","https://openalex.org/W2091459966","https://openalex.org/W2096496252","https://openalex.org/W2100542992","https://openalex.org/W2105326258","https://openalex.org/W2111967617","https://openalex.org/W2123686039","https://openalex.org/W2126711987","https://openalex.org/W2132846504","https://openalex.org/W2136083615","https://openalex.org/W2140509629","https://openalex.org/W2143125604","https://openalex.org/W2145269645","https://openalex.org/W2146461854","https://openalex.org/W2147076738","https://openalex.org/W2149640878","https://openalex.org/W2150606131","https://openalex.org/W2150630976","https://openalex.org/W2151487638","https://openalex.org/W2171669671","https://openalex.org/W2182331413","https://openalex.org/W2396727930","https://openalex.org/W2401640580","https://openalex.org/W4236538089","https://openalex.org/W4255327858","https://openalex.org/W6629777733","https://openalex.org/W6635650928"],"related_works":["https://openalex.org/W2368824897","https://openalex.org/W1508050556","https://openalex.org/W1910862367","https://openalex.org/W2372020181","https://openalex.org/W2156531654","https://openalex.org/W4378714697","https://openalex.org/W2379365082","https://openalex.org/W2370747590","https://openalex.org/W1581723585","https://openalex.org/W2294330161"],"abstract_inverted_index":{"In-memory":[0],"data":[1,30],"analytic":[2],"systems":[3],"that":[4,16,43,68,75,124],"use":[5,11],"vertical":[6],"bit-parallel":[7],"scan":[8,129,185],"methods":[9],"generally":[10,197],"encoding":[12,57,101,133,151,163,202],"techniques.":[13],"We":[14],"observe":[15],"in":[17,27,89,113,136],"such":[18,165],"environments,":[19],"there":[20],"is":[21,196],"an":[22],"opportunity":[23],"to":[24,47,59,73,145,176],"turn":[25],"skew":[26],"both":[28],"the":[29,49,90,99,106,111,114,118,148,174,178,184,192,200],"and":[31,121,199],"predicate":[32],"distributions":[33],"(usually":[34],"a":[35,41,55,86,137],"problem":[36],"for":[37],"query":[38],"processing)":[39],"into":[40],"benefit":[42],"can":[44,76,103],"be":[45,78],"leveraged":[46],"encode":[48],"column":[50],"values.":[51],"This":[52,169],"paper":[53],"proposes":[54],"padded":[56,100,132,150,201],"scheme":[58,65,102,203],"address":[60],"this":[61],"opportunity.":[62],"The":[63],"proposed":[64,149],"creates":[66],"encodings":[67,142],"map":[69],"common":[70],"attribute":[71],"values":[72],"codes":[74,82,156],"easily":[77],"distinguished":[79],"from":[80,180],"other":[81],"by":[83,160],"only":[84],"examining":[85,109],"few":[87],"bits":[88,112],"full":[91],"code.":[92],"Consequently,":[93],"scans":[94],"on":[95],"columns":[96],"stored":[97],"using":[98],"safely":[104],"prune":[105],"computation":[107],"without":[108],"all":[110],"code,":[115],"thereby":[116],"reducing":[117],"memory":[119],"bandwidth":[120],"CPU":[122],"cycles":[123],"are":[125,143],"consumed":[126],"when":[127],"evaluating":[128],"queries.":[130],"Our":[131],"method":[134],"results":[135],"fixed-length":[138,141],"encoding,":[139],"as":[140,166,188],"easier":[144],"manage.":[146],"However,":[147,187],"may":[152],"produce":[153],"longer":[154],"(fixed-length)":[155],"than":[157],"those":[158],"produced":[159],"popular":[161],"order-preserving":[162],"methods,":[164],"dictionary-based":[167],"encoding.":[168],"additional":[170,193],"space":[171,194],"overhead":[172,195],"has":[173],"potential":[175],"negate":[177],"gains":[179],"early":[181],"pruning":[182],"of":[183],"computation.":[186],"we":[189],"demonstrate":[190],"empirically,":[191],"small,":[198],"provides":[204],"significant":[205],"performance":[206],"improvements.":[207]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":6},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":2}],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2025-10-10T00:00:00"}