{"id":"https://openalex.org/W3032745107","doi":"https://doi.org/10.1145/3318464.3389729","title":"External Merge Sort for Top-K Queries","display_name":"External Merge Sort for Top-K Queries","publication_year":2020,"publication_date":"2020-05-29","ids":{"openalex":"https://openalex.org/W3032745107","doi":"https://doi.org/10.1145/3318464.3389729","mag":"3032745107"},"language":"en","primary_location":{"id":"doi:10.1145/3318464.3389729","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3318464.3389729","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3318464.3389729","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-article"},"type":"conference-paper","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3318464.3389729","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5035128721","display_name":"Yannis Chronis","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":"Yannis Chronis","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/A5101511221","display_name":"Thanh Do","orcid":"https://orcid.org/0000-0001-9893-5725"},"institutions":[{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Thanh Do","raw_affiliation_strings":["Google Inc, Madison, WI, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Google Inc, Madison, WI, USA","institution_ids":["https://openalex.org/I1291425158"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5041862671","display_name":"Goetz Graefe","orcid":"https://orcid.org/0000-0003-0194-6466"},"institutions":[{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Goetz Graefe","raw_affiliation_strings":["Google Inc, Madison, WI, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Google Inc, Madison, WI, USA","institution_ids":["https://openalex.org/I1291425158"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5041543460","display_name":"Keith Peters","orcid":null},"institutions":[{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Keith Peters","raw_affiliation_strings":["Google Inc, Mountain View, CA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Google Inc, Mountain View, CA, USA","institution_ids":["https://openalex.org/I1291425158"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":true,"cited_by_count":3,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"2423","last_page":"2437"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998999834060669,"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.9998999834060669,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9991999864578247,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9962999820709229,"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.8730368614196777},{"id":"https://openalex.org/keywords/sort","display_name":"sort","score":0.7152231335639954},{"id":"https://openalex.org/keywords/sorting-algorithm","display_name":"Sorting algorithm","score":0.6409969329833984},{"id":"https://openalex.org/keywords/merge","display_name":"Merge (version control)","score":0.6254807710647583},{"id":"https://openalex.org/keywords/merge-sort","display_name":"Merge sort","score":0.6034896373748779},{"id":"https://openalex.org/keywords/sorting","display_name":"Sorting","score":0.5687898397445679},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.5434250831604004},{"id":"https://openalex.org/keywords/auxiliary-memory","display_name":"Auxiliary memory","score":0.5060169100761414},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.4707178473472595},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.30730485916137695},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.22405478358268738}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8730368614196777},{"id":"https://openalex.org/C88548561","wikidata":"https://www.wikidata.org/wiki/Q347599","display_name":"sort","level":2,"score":0.7152231335639954},{"id":"https://openalex.org/C108094655","wikidata":"https://www.wikidata.org/wiki/Q181593","display_name":"Sorting algorithm","level":3,"score":0.6409969329833984},{"id":"https://openalex.org/C197129107","wikidata":"https://www.wikidata.org/wiki/Q1921621","display_name":"Merge (version control)","level":2,"score":0.6254807710647583},{"id":"https://openalex.org/C35555965","wikidata":"https://www.wikidata.org/wiki/Q189057","display_name":"Merge sort","level":4,"score":0.6034896373748779},{"id":"https://openalex.org/C111696304","wikidata":"https://www.wikidata.org/wiki/Q2303697","display_name":"Sorting","level":2,"score":0.5687898397445679},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.5434250831604004},{"id":"https://openalex.org/C82687282","wikidata":"https://www.wikidata.org/wiki/Q66221","display_name":"Auxiliary memory","level":2,"score":0.5060169100761414},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.4707178473472595},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.30730485916137695},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.22405478358268738}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3318464.3389729","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3318464.3389729","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3318464.3389729","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/3318464.3389729","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3318464.3389729","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3318464.3389729","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3032745107.pdf","grobid_xml":"https://content.openalex.org/works/W3032745107.grobid-xml"},"referenced_works_count":30,"referenced_works":["https://openalex.org/W106849758","https://openalex.org/W1495007564","https://openalex.org/W1968625547","https://openalex.org/W1974796034","https://openalex.org/W1996641400","https://openalex.org/W2009688537","https://openalex.org/W2021090050","https://openalex.org/W2029131452","https://openalex.org/W2037390831","https://openalex.org/W2058124204","https://openalex.org/W2084538728","https://openalex.org/W2097880677","https://openalex.org/W2103709927","https://openalex.org/W2110160586","https://openalex.org/W2119558533","https://openalex.org/W2133900260","https://openalex.org/W2147722789","https://openalex.org/W2158237121","https://openalex.org/W2161971058","https://openalex.org/W2440109901","https://openalex.org/W2572539223","https://openalex.org/W2798445803","https://openalex.org/W2888971921","https://openalex.org/W2948936239","https://openalex.org/W2962771342","https://openalex.org/W3009408579","https://openalex.org/W3103362336","https://openalex.org/W3198160809","https://openalex.org/W4255327858","https://openalex.org/W6732108346"],"related_works":["https://openalex.org/W2994182992","https://openalex.org/W2765396134","https://openalex.org/W2350549588","https://openalex.org/W2908348257","https://openalex.org/W2977813765","https://openalex.org/W3038595913","https://openalex.org/W2267918355","https://openalex.org/W4281648223","https://openalex.org/W2945185559","https://openalex.org/W2993603424"],"abstract_inverted_index":{"Business":[0],"intelligence":[1],"and":[2,27,193,218,225],"web":[3],"log":[4],"analysis":[5],"workloads":[6],"often":[7],"use":[8],"queries":[9,115,202],"with":[10,203],"top-k":[11,50,114,136,201,216],"clauses":[12],"to":[13,24,121,141,152,229],"produce":[14],"the":[15,29,33,36,41,46,61,68,72,80,89,96,126,145,158,163,179,207],"most":[16],"relevant":[17],"results.":[18],"Values":[19],"ofk":[20],"range":[21],"from":[22],"small":[23],"rather":[25],"large":[26],"sometimes":[28],"requested":[30,42,69,159],"output":[31,43,70,160],"exceeds":[32,71],"capacity":[34,98],"of":[35,110,112,125,144,156,178,190],"available":[37,47,164,208],"main":[38,73],"memory.":[39,165,209],"When":[40,67],"fits":[44,161],"in":[45,92,102,162,196],"memory":[48,74,97],"existing":[49,76,215],"algorithms":[51,77,217],"are":[52],"efficient,":[53],"as":[54,188],"they":[55],"can":[56,84,226],"eliminate":[57,142],"almost":[58],"all":[59],"but":[60],"topk":[62],"results":[63,101],"before":[64,147],"sorting":[65,148],"them.":[66],"capacity,":[75],"externally":[78],"sort":[79,124],"entire":[81],"input,":[82],"which":[83],"be":[85,227],"very":[86],"expensive.":[87],"Furthermore,":[88],"drastic":[90],"difference":[91],"execution":[93,170],"cost":[94],"when":[95],"is":[99,139,186,194],"exceeded":[100],"an":[103,122],"unpleasant":[104],"user":[105],"experience.":[106],"Every":[107],"day,":[108],"tens":[109],"thousands":[111],"production":[113],"executed":[116],"on":[117],"F1":[118,191],"Query":[119,192],"resort":[120],"external":[123],"input.":[127],"To":[128,166],"address":[129],"these":[130],"challenges,":[131],"we":[132],"introduce":[133],"a":[134,175],"new":[135],"algorithm":[137,173,185,213],"that":[138,220],"able":[140],"parts":[143],"input":[146,180],"or":[149],"writing":[150],"them":[151],"secondary":[153],"storage,":[154],"regardless":[155],"whether":[157],"achieve":[167],"this,":[168],"at":[169],"time":[171],"our":[172,212],"creates":[174],"concise":[176],"model":[177],"using":[181],"histograms.":[182],"The":[183],"proposed":[184],"implemented":[187],"part":[189],"used":[195],"production,":[197],"where":[198],"significantly":[199],"accelerates":[200],"outputs":[204],"larger":[205],"than":[206],"We":[210],"evaluate":[211],"against":[214],"show":[219],"it":[221],"reduces":[222],"I/O":[223],"traffic":[224],"up":[228],"11":[230],"times":[231],"faster.":[232]},"counts_by_year":[{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":1}],"updated_date":"2026-07-15T18:14:33.161393","created_date":"2025-10-10T00:00:00"}