{"id":"https://openalex.org/W2419855244","doi":"https://doi.org/10.1145/2882903.2915205","title":"Fast Multi-Column Sorting in Main-Memory Column-Stores","display_name":"Fast Multi-Column Sorting in Main-Memory Column-Stores","publication_year":2016,"publication_date":"2016-06-14","ids":{"openalex":"https://openalex.org/W2419855244","doi":"https://doi.org/10.1145/2882903.2915205","mag":"2419855244"},"language":"en","primary_location":{"id":"doi:10.1145/2882903.2915205","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2882903.2915205","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2016 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/A5067642735","display_name":"Wenjian Xu","orcid":"https://orcid.org/0000-0001-8852-2601"},"institutions":[{"id":"https://openalex.org/I14243506","display_name":"Hong Kong Polytechnic University","ror":"https://ror.org/0030zas98","country_code":"HK","type":"education","lineage":["https://openalex.org/I14243506"]}],"countries":["HK"],"is_corresponding":true,"raw_author_name":"Wenjian Xu","raw_affiliation_strings":["The Hong Kong Polytechnic University, Hong Kong, Hong Kong"],"affiliations":[{"raw_affiliation_string":"The Hong Kong Polytechnic University, Hong Kong, Hong Kong","institution_ids":["https://openalex.org/I14243506"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5043332603","display_name":"Ziqiang Feng","orcid":"https://orcid.org/0000-0002-0787-2448"},"institutions":[{"id":"https://openalex.org/I14243506","display_name":"Hong Kong Polytechnic University","ror":"https://ror.org/0030zas98","country_code":"HK","type":"education","lineage":["https://openalex.org/I14243506"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Ziqiang Feng","raw_affiliation_strings":["The Hong Kong Polytechnic University, Hong Kong, Hong Kong"],"affiliations":[{"raw_affiliation_string":"The Hong Kong Polytechnic University, Hong Kong, Hong Kong","institution_ids":["https://openalex.org/I14243506"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5011148671","display_name":"Eric Lo","orcid":"https://orcid.org/0000-0003-2679-3945"},"institutions":[{"id":"https://openalex.org/I177725633","display_name":"Chinese University of Hong Kong","ror":"https://ror.org/00t33hh48","country_code":"CN","type":"education","lineage":["https://openalex.org/I177725633"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Eric Lo","raw_affiliation_strings":["The Chinese University of Hong Kong, Hong Kong, Hong Kong"],"affiliations":[{"raw_affiliation_string":"The Chinese University of Hong Kong, Hong Kong, Hong Kong","institution_ids":["https://openalex.org/I177725633"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5067642735"],"corresponding_institution_ids":["https://openalex.org/I14243506"],"apc_list":null,"apc_paid":null,"fwci":1.822,"has_fulltext":false,"cited_by_count":11,"citation_normalized_percentile":{"value":0.86662151,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"1263","last_page":"1278"},"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.9991000294685364,"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.9991000294685364,"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/T11106","display_name":"Data Management and Algorithms","score":0.9945999979972839,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9919999837875366,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8150264024734497},{"id":"https://openalex.org/keywords/column","display_name":"Column (typography)","score":0.7891297340393066},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.7419264316558838},{"id":"https://openalex.org/keywords/sorting","display_name":"Sorting","score":0.6490033864974976},{"id":"https://openalex.org/keywords/partition","display_name":"Partition (number theory)","score":0.5734362602233887},{"id":"https://openalex.org/keywords/speedup","display_name":"Speedup","score":0.5728604793548584},{"id":"https://openalex.org/keywords/bottleneck","display_name":"Bottleneck","score":0.5574783086776733},{"id":"https://openalex.org/keywords/code","display_name":"Code (set theory)","score":0.5075622797012329},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.2736932635307312},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.21987506747245789},{"id":"https://openalex.org/keywords/embedded-system","display_name":"Embedded system","score":0.15183943510055542},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.11709022521972656}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8150264024734497},{"id":"https://openalex.org/C2780551164","wikidata":"https://www.wikidata.org/wiki/Q2306599","display_name":"Column (typography)","level":3,"score":0.7891297340393066},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.7419264316558838},{"id":"https://openalex.org/C111696304","wikidata":"https://www.wikidata.org/wiki/Q2303697","display_name":"Sorting","level":2,"score":0.6490033864974976},{"id":"https://openalex.org/C42812","wikidata":"https://www.wikidata.org/wiki/Q1082910","display_name":"Partition (number theory)","level":2,"score":0.5734362602233887},{"id":"https://openalex.org/C68339613","wikidata":"https://www.wikidata.org/wiki/Q1549489","display_name":"Speedup","level":2,"score":0.5728604793548584},{"id":"https://openalex.org/C2780513914","wikidata":"https://www.wikidata.org/wiki/Q18210350","display_name":"Bottleneck","level":2,"score":0.5574783086776733},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.5075622797012329},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.2736932635307312},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.21987506747245789},{"id":"https://openalex.org/C149635348","wikidata":"https://www.wikidata.org/wiki/Q193040","display_name":"Embedded system","level":1,"score":0.15183943510055542},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.11709022521972656},{"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/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.0},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/2882903.2915205","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2882903.2915205","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2016 International Conference on Management of Data","raw_type":"proceedings-article"},{"id":"pmh:oai:ira.lib.polyu.edu.hk:10397/74075","is_oa":false,"landing_page_url":"http://hdl.handle.net/10397/74075","pdf_url":null,"source":{"id":"https://openalex.org/S4306400205","display_name":"PolyU Institutional Research Archive (Hong Kong Polytechnic University)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I14243506","host_organization_name":"Hong Kong Polytechnic University","host_organization_lineage":["https://openalex.org/I14243506"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Conference Paper"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":37,"referenced_works":["https://openalex.org/W1521148341","https://openalex.org/W1902965424","https://openalex.org/W1984116073","https://openalex.org/W1991223838","https://openalex.org/W2003515726","https://openalex.org/W2006552857","https://openalex.org/W2011973765","https://openalex.org/W2026965159","https://openalex.org/W2039910065","https://openalex.org/W2054046497","https://openalex.org/W2055774867","https://openalex.org/W2068418796","https://openalex.org/W2081728040","https://openalex.org/W2082695854","https://openalex.org/W2086977914","https://openalex.org/W2091459966","https://openalex.org/W2103670492","https://openalex.org/W2109907545","https://openalex.org/W2113831242","https://openalex.org/W2122048769","https://openalex.org/W2124851765","https://openalex.org/W2125529470","https://openalex.org/W2136083615","https://openalex.org/W2143125604","https://openalex.org/W2146461854","https://openalex.org/W2153952995","https://openalex.org/W2159726625","https://openalex.org/W2163422235","https://openalex.org/W2166955231","https://openalex.org/W2169150396","https://openalex.org/W2278783412","https://openalex.org/W2294316975","https://openalex.org/W2396727930","https://openalex.org/W2406955896","https://openalex.org/W4247913514","https://openalex.org/W6678708722","https://openalex.org/W6712224422"],"related_works":["https://openalex.org/W2058965144","https://openalex.org/W2164382479","https://openalex.org/W2146343568","https://openalex.org/W98480971","https://openalex.org/W2150291671","https://openalex.org/W2013643406","https://openalex.org/W2027972911","https://openalex.org/W2157978810","https://openalex.org/W2891987081","https://openalex.org/W2107967133"],"abstract_inverted_index":{"Sorting":[0],"is":[1],"a":[2,69,76,118],"crucial":[3],"operation":[4],"that":[5,39,62,90,117],"could":[6,67],"be":[7,96],"used":[8],"to":[9,129],"implement":[10],"SQL":[11],"operators":[12],"such":[13],"as":[14],"GROUP":[15],"BY,":[16,18],"ORDER":[17],"and":[19,59,133,140],"SQL:2003":[20],"PARTITION":[21],"BY.":[22],"Queries":[23],"with":[24,121],"multiple":[25],"attributes":[26],"in":[27,32],"those":[28],"clauses":[29],"are":[30],"common":[31],"real":[33,141],"workloads.":[34],"When":[35],"executing":[36],"queries":[37],"of":[38,47,55,64,102,109,127],"kind,":[40],"state-of-the-art":[41],"main-memory":[42,119],"column-stores":[43],"require":[44],"one":[45],"round":[46],"sorting":[48,66,93,103],"per":[49],"input":[50],"column.":[51],"With":[52],"the":[53,84,87,91,107],"advent":[54],"recent":[56],"fast":[57],"scans":[58],"denormalization":[60],"techniques,":[61],"kind":[63],"multi-column":[65],"become":[68],"bottleneck.":[70],"In":[71],"this":[72],"paper,":[73],"we":[74],"propose":[75],"new":[77],"technique":[78],"called":[79],"\"code":[80],"massaging\",":[81],"which":[82],"manipulates":[83],"bits":[85],"across":[86],"columns":[88],"so":[89],"overall":[92],"time":[94],"can":[95,124],"reduced":[97],"by":[98,105],"eliminating":[99],"some":[100],"rounds":[101],"and/or":[104],"improving":[106],"degree":[108],"SIMD":[110],"data":[111],"level":[112],"parallelism.":[113],"Empirical":[114],"results":[115],"show":[116],"column-store":[120],"code":[122],"massaging":[123],"achieve":[125],"speedup":[126],"up":[128],"4.7X,":[130,131],"4X,":[132],"3.2X":[134],"on":[135],"TPC-H,":[136],"TPC-H":[137],"skew,":[138],"TPC-DS,":[139],"workload,":[142],"respectively.":[143]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":1}],"updated_date":"2026-03-20T23:20:44.827607","created_date":"2025-10-10T00:00:00"}