{"id":"https://openalex.org/W2139000699","doi":"https://doi.org/10.1145/2338626.2338633","title":"Reordering rows for better compression: Beyond the lexicographic order","display_name":"Reordering rows for better compression: Beyond the lexicographic order","alternate_titles":[],"publication_year":2012,"publication_date":"2012-08-01","ids":{"openalex":"https://openalex.org/W2139000699","doi":"https://doi.org/10.1145/2338626.2338633","mag":"2139000699"},"language":"en","primary_location":{"id":"doi:10.1145/2338626.2338633","doi":"https://doi.org/10.1145/2338626.2338633","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2338626.2338633","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["ccf-a","cwts-core","dongbi-a","jufo-3","norway-1","poland-100","russia-white-list-2"],"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":"ACM Transactions on Database Systems","raw_type":"journal-article"},"parent_works":[],"lineage":["https://openalex.org/W2139000699"],"child_works_count":0,"type":"article","is_traditional":true,"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/A5045561693","display_name":"Daniel Lemire","orcid":"https://orcid.org/0000-0003-3306-6922","observed_orcids":["https://orcid.org/0000-0003-3306-6922"]},"institutions":[{"id":"https://openalex.org/I200745827","display_name":"Universit\u00e9 T\u00c9LUQ","ror":"https://ror.org/007y6q934","country_code":"CA","type":"education","lineage":["https://openalex.org/I200745827","https://openalex.org/I49663120"]}],"countries":["CA"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Daniel Lemire","raw_affiliation_strings":["TELUQ"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"TELUQ","institution_ids":["https://openalex.org/I200745827"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5058730847","display_name":"Owen Kaser","orcid":"https://orcid.org/0000-0001-6204-5085","observed_orcids":["https://orcid.org/0000-0001-6204-5085"]},"institutions":[{"id":"https://openalex.org/I106938459","display_name":"University of New Brunswick","ror":"https://ror.org/05nkf0n29","country_code":"CA","type":"education","lineage":["https://openalex.org/I106938459"]}],"countries":["CA"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Owen Kaser","raw_affiliation_strings":["University of New Brunswick, Saint John"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of New Brunswick, Saint John","institution_ids":["https://openalex.org/I106938459"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5080667387","display_name":"Eduardo Gutarra","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I106938459","display_name":"University of New Brunswick","ror":"https://ror.org/05nkf0n29","country_code":"CA","type":"education","lineage":["https://openalex.org/I106938459"]}],"countries":["CA"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Eduardo Gutarra","raw_affiliation_strings":["University of New Brunswick, Saint John"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of New Brunswick, Saint John","institution_ids":["https://openalex.org/I106938459"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":3.8586,"has_fulltext":false,"cited_by_count":42,"citation_normalized_percentile":{"value":0.93092622,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":87,"max":98},"biblio":{"volume":"37","issue":"3","first_page":"1","last_page":"29"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11269","display_name":"Algorithms and Data Compression","score":0.788100004196167,"subfield":{"id":"https://openalex.org/subfields/2614","display_name":"Theoretical Computer Science"},"field":{"id":"https://openalex.org/fields/26","display_name":"Mathematics"},"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.788100004196167,"subfield":{"id":"https://openalex.org/subfields/2614","display_name":"Theoretical Computer Science"},"field":{"id":"https://openalex.org/fields/26","display_name":"Mathematics"},"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.1988999992609024,"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"}},{"id":"https://openalex.org/T10901","display_name":"Advanced Data Compression Techniques","score":0.004800000227987766,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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/run-length-encoding","display_name":"run-length encoding","score":0.9850000143051147},{"id":"https://openalex.org/keywords/nearest-neighbor-heuristic","display_name":"nearest neighbor heuristic","score":0.9089999794960022},{"id":"https://openalex.org/keywords/large-tables","display_name":"large tables","score":0.3240000009536743}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8040201663970947},{"id":"https://openalex.org/C68339613","wikidata":"https://www.wikidata.org/wiki/Q1549489","display_name":"Speedup","level":2,"score":0.7586024403572083},{"id":"https://openalex.org/C159254197","wikidata":"https://www.wikidata.org/wiki/Q1144915","display_name":"Lexicographical order","level":2,"score":0.6946136951446533},{"id":"https://openalex.org/C135598885","wikidata":"https://www.wikidata.org/wiki/Q1366302","display_name":"Row","level":2,"score":0.6468938589096069},{"id":"https://openalex.org/C111696304","wikidata":"https://www.wikidata.org/wiki/Q2303697","display_name":"Sorting","level":2,"score":0.6136951446533203},{"id":"https://openalex.org/C180016635","wikidata":"https://www.wikidata.org/wiki/Q2712821","display_name":"Compression (physics)","level":2,"score":0.5392317771911621},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.5329846739768982},{"id":"https://openalex.org/C78548338","wikidata":"https://www.wikidata.org/wiki/Q2493","display_name":"Data compression","level":2,"score":0.523724377155304},{"id":"https://openalex.org/C173801870","wikidata":"https://www.wikidata.org/wiki/Q201413","display_name":"Heuristic","level":2,"score":0.5031000971794128},{"id":"https://openalex.org/C127705205","wikidata":"https://www.wikidata.org/wiki/Q5748245","display_name":"Heuristics","level":2,"score":0.4970703423023224},{"id":"https://openalex.org/C46900642","wikidata":"https://www.wikidata.org/wiki/Q2647","display_name":"Huffman coding","level":3,"score":0.4957798421382904},{"id":"https://openalex.org/C25797200","wikidata":"https://www.wikidata.org/wiki/Q828137","display_name":"Compression ratio","level":3,"score":0.454770565032959},{"id":"https://openalex.org/C125411270","wikidata":"https://www.wikidata.org/wiki/Q18653","display_name":"Encoding (memory)","level":2,"score":0.4357868432998657},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.3610789179801941},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.15805551409721375},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.1073523461818695},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.10484969615936279},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.07608914375305176},{"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/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"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/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"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/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2338626.2338633","doi":"https://doi.org/10.1145/2338626.2338633","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2338626.2338633","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["ccf-a","cwts-core","dongbi-a","jufo-3","norway-1","poland-100","russia-white-list-2"],"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":"ACM Transactions on Database Systems","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[{"id":"https://openalex.org/G8839536931","display_name":null,"funder_award_id":"261437 and 155967","funder_id":"https://openalex.org/F4320334593","funder_display_name":"Natural Sciences and Engineering Research Council of Canada"}],"funders":[{"id":"https://openalex.org/F4320334593","display_name":"Natural Sciences and Engineering Research Council of Canada","ror":"https://ror.org/01h531d29"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":80,"referenced_works":["https://openalex.org/W13798402","https://openalex.org/W199215620","https://openalex.org/W240216500","https://openalex.org/W1502916507","https://openalex.org/W1533886078","https://openalex.org/W1559631118","https://openalex.org/W1559839959","https://openalex.org/W1578512165","https://openalex.org/W1704989917","https://openalex.org/W1717440967","https://openalex.org/W1832597858","https://openalex.org/W1965255372","https://openalex.org/W1965473122","https://openalex.org/W1966612958","https://openalex.org/W1966678916","https://openalex.org/W1975663164","https://openalex.org/W1976231547","https://openalex.org/W1978010829","https://openalex.org/W1978177608","https://openalex.org/W1979021998","https://openalex.org/W1992730709","https://openalex.org/W1992923105","https://openalex.org/W1996358566","https://openalex.org/W1998964210","https://openalex.org/W2001964584","https://openalex.org/W2003421875","https://openalex.org/W2005112390","https://openalex.org/W2007993174","https://openalex.org/W2011015278","https://openalex.org/W2017708378","https://openalex.org/W2022179164","https://openalex.org/W2037455079","https://openalex.org/W2038652993","https://openalex.org/W2038807029","https://openalex.org/W2042986967","https://openalex.org/W2050749090","https://openalex.org/W2054046497","https://openalex.org/W2063368144","https://openalex.org/W2080600916","https://openalex.org/W2086323458","https://openalex.org/W2090815306","https://openalex.org/W2091299439","https://openalex.org/W2095946447","https://openalex.org/W2102076751","https://openalex.org/W2103126020","https://openalex.org/W2106378689","https://openalex.org/W2109626831","https://openalex.org/W2111581650","https://openalex.org/W2114977680","https://openalex.org/W2115440939","https://openalex.org/W2115613939","https://openalex.org/W2117226423","https://openalex.org/W2121084172","https://openalex.org/W2122962290","https://openalex.org/W2123686039","https://openalex.org/W2126683703","https://openalex.org/W2133639780","https://openalex.org/W2136070674","https://openalex.org/W2136529208","https://openalex.org/W2139445729","https://openalex.org/W2140425706","https://openalex.org/W2143037347","https://openalex.org/W2146043654","https://openalex.org/W2147717514","https://openalex.org/W2151131744","https://openalex.org/W2153084230","https://openalex.org/W2157953951","https://openalex.org/W2164715417","https://openalex.org/W2165025417","https://openalex.org/W2166996723","https://openalex.org/W2229915657","https://openalex.org/W2752853835","https://openalex.org/W2956015669","https://openalex.org/W3106392330","https://openalex.org/W3118260104","https://openalex.org/W3120740533","https://openalex.org/W4248948635","https://openalex.org/W4249653116","https://openalex.org/W4285719527","https://openalex.org/W4300005723"],"related_works":["https://openalex.org/W2951897045","https://openalex.org/W3032251503","https://openalex.org/W1998964210","https://openalex.org/W2097290024","https://openalex.org/W2087137892","https://openalex.org/W20640642","https://openalex.org/W2144361113","https://openalex.org/W2063540853"],"abstract_inverted_index":{"Sorting":[0],"database":[1],"tables":[2],"before":[3],"compressing":[4],"them":[5],"improves":[6],"the":[7,15,20,30,137,143,148,158],"compression":[8,28,67,84],"rate.":[9],"Can":[10],"we":[11,110,122],"do":[12],"better":[13],"than":[14,95],"lexicographical":[16],"order?":[17],"For":[18,98],"minimizing":[19,157],"number":[21],"of":[22,119,136,160],"runs":[23,93,159],"in":[24,165],"a":[25,44,59,69,74,117,166],"run-length":[26,113],"encoding":[27,114],"scheme,":[29],"best":[31],"approaches":[32],"to":[33,90,116,129,140],"row-ordering":[34],"are":[35,133],"derived":[36],"from":[37],"traveling":[38],"salesman":[39],"heuristics,":[40],"although":[41],"there":[42],"is":[43,58,73,87,105,152],"significant":[45],"trade-off":[46],"between":[47],"running":[48],"time":[49],"and":[50],"compression.":[51],"A":[52],"new":[53,149],"heuristic,":[54,103],"Multiple":[55],"Lists,":[56],"which":[57],"variant":[60],"on":[61,134],"Nearest":[62],"Neighbor":[63],"that":[64,109,147],"trades":[65],"off":[66],"for":[68,77,82],"major":[70],"running-time":[71],"speedup,":[72],"good":[75],"option":[76],"very":[78],"large":[79],"tables.":[80],"However,":[81],"some":[83],"schemes,":[85],"it":[86],"more":[88],"important":[89],"generate":[91],"long":[92],"rather":[94],"few":[96,167],"runs.":[97],"this":[99],"case,":[100],"another":[101],"novel":[102],"Vortex,":[104],"promising.":[106],"We":[107,145],"find":[108],"can":[111,123],"improve":[112,124],"up":[115,128],"factor":[118],"3":[120],"whereas":[121],"prefix":[125],"coding":[126],"by":[127],"80%:":[130],"these":[131],"gains":[132,138],"top":[135],"due":[139],"lexicographically":[141],"sorting":[142],"table.":[144],"prove":[146],"row":[150],"reordering":[151],"optimal":[153],"(within":[154],"10%)":[155],"at":[156],"identical":[161],"values":[162],"within":[163],"columns,":[164],"cases.":[168]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2139000699","counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":5},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":4},{"year":2020,"cited_by_count":3},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":4},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":5},{"year":2015,"cited_by_count":6},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":3},{"year":2012,"cited_by_count":1}],"updated_date":"2026-11-18T13:11:19.462570","created_date":"2016-06-24T00:00:00"}
