{"id":"https://openalex.org/W4248739752","doi":"https://doi.org/10.1145/276305.276346","title":"Memory management during run generation in external sorting","display_name":"Memory management during run generation in external sorting","alternate_titles":[],"publication_year":1998,"publication_date":"1998-06-01","ids":{"openalex":"https://openalex.org/W4248739752","doi":"https://doi.org/10.1145/276305.276346"},"language":"en","primary_location":{"id":"doi:10.1145/276305.276346","doi":"https://doi.org/10.1145/276305.276346","is_oa":true,"landing_page_url":"https://doi.org/10.1145/276305.276346","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/276305.276346","source":{"id":"https://openalex.org/S47508943","display_name":"ACM SIGMOD Record","issn_l":"0163-5808","issn":["0163-5808","1943-5835"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-c","jufo-1","norway-1","poland-70","russia-white-list-2","vabb-shw"],"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 SIGMOD Record","raw_type":"journal-article"},"parent_works":[],"lineage":["https://openalex.org/W4248739752"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"bronze","oa_url":"https://dl.acm.org/doi/pdf/10.1145/276305.276346","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5109039470","display_name":"Per-\u00c5ke Larson","orcid":"https://orcid.org/0009-0009-5038-7905","observed_orcids":["https://orcid.org/0009-0009-5038-7905"]},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Per-\u00c5ke Larson","raw_affiliation_strings":["Microsoft"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5041862671","display_name":"Goetz Graefe","orcid":"https://orcid.org/0000-0003-0194-6466","observed_orcids":["https://orcid.org/0000-0003-0194-6466"]},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Goetz Graefe","raw_affiliation_strings":["Microsoft"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft","institution_ids":["https://openalex.org/I1290206253"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I1290206253"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":true,"cited_by_count":12,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":96},"biblio":{"volume":"27","issue":"2","first_page":"472","last_page":"483"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9663000106811523,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9663000106811523,"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/T11269","display_name":"Algorithms and Data Compression","score":0.02889999933540821,"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/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.0017000000225380063,"subfield":{"id":"https://openalex.org/subfields/1708","display_name":"Hardware and Architecture"},"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/external-sorting","display_name":"external sorting","score":0.9679999947547913},{"id":"https://openalex.org/keywords/memory-management","display_name":"memory management","score":0.9160000085830688},{"id":"https://openalex.org/keywords/variable-length-records","display_name":"variable-length records","score":0.7820000052452087},{"id":"https://openalex.org/keywords/best-fit-algorithm","display_name":"best-fit algorithm","score":0.8159999847412109},{"id":"https://openalex.org/keywords/workspace-utilization","display_name":"workspace utilization","score":0.5559999942779541},{"id":"https://openalex.org/keywords/i-o-reduction","display_name":"I/O reduction","score":0.7760000228881836},{"id":"https://openalex.org/keywords/database-management-systems","display_name":"database management systems","score":0.4909999966621399}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8418973684310913},{"id":"https://openalex.org/C108094655","wikidata":"https://www.wikidata.org/wiki/Q181593","display_name":"Sorting algorithm","level":3,"score":0.6814597845077515},{"id":"https://openalex.org/C58581272","wikidata":"https://www.wikidata.org/wiki/Q12741163","display_name":"Workspace","level":3,"score":0.6674648523330688},{"id":"https://openalex.org/C88548561","wikidata":"https://www.wikidata.org/wiki/Q347599","display_name":"sort","level":2,"score":0.6220943927764893},{"id":"https://openalex.org/C2779151265","wikidata":"https://www.wikidata.org/wiki/Q1156791","display_name":"Copying","level":2,"score":0.6193442344665527},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.5495719313621521},{"id":"https://openalex.org/C111696304","wikidata":"https://www.wikidata.org/wiki/Q2303697","display_name":"Sorting","level":2,"score":0.5291483998298645},{"id":"https://openalex.org/C176649486","wikidata":"https://www.wikidata.org/wiki/Q2308807","display_name":"Memory management","level":3,"score":0.5226045250892639},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.517192006111145},{"id":"https://openalex.org/C182365436","wikidata":"https://www.wikidata.org/wiki/Q50701","display_name":"Variable (mathematics)","level":2,"score":0.49020296335220337},{"id":"https://openalex.org/C82687282","wikidata":"https://www.wikidata.org/wiki/Q66221","display_name":"Auxiliary memory","level":2,"score":0.44248098134994507},{"id":"https://openalex.org/C35555965","wikidata":"https://www.wikidata.org/wiki/Q189057","display_name":"Merge sort","level":4,"score":0.4368475079536438},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.403395414352417},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.24499401450157166},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.21193230152130127},{"id":"https://openalex.org/C98986596","wikidata":"https://www.wikidata.org/wiki/Q1143031","display_name":"Semiconductor memory","level":2,"score":0.1032441258430481},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.08196911215782166},{"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/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.0},{"id":"https://openalex.org/C90509273","wikidata":"https://www.wikidata.org/wiki/Q11012","display_name":"Robot","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/276305.276346","doi":"https://doi.org/10.1145/276305.276346","is_oa":true,"landing_page_url":"https://doi.org/10.1145/276305.276346","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/276305.276346","source":{"id":"https://openalex.org/S47508943","display_name":"ACM SIGMOD Record","issn_l":"0163-5808","issn":["0163-5808","1943-5835"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-c","jufo-1","norway-1","poland-70","russia-white-list-2","vabb-shw"],"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 SIGMOD Record","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1145/276305.276346","doi":"https://doi.org/10.1145/276305.276346","is_oa":true,"landing_page_url":"https://doi.org/10.1145/276305.276346","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/276305.276346","source":{"id":"https://openalex.org/S47508943","display_name":"ACM SIGMOD Record","issn_l":"0163-5808","issn":["0163-5808","1943-5835"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-c","jufo-1","norway-1","poland-70","russia-white-list-2","vabb-shw"],"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 SIGMOD Record","raw_type":"journal-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4248739752.pdf","grobid_xml":"https://content.openalex.org/works/W4248739752.grobid-xml"},"referenced_works_count":5,"referenced_works":["https://openalex.org/W1899349177","https://openalex.org/W2029849129","https://openalex.org/W2066823629","https://openalex.org/W2158237121","https://openalex.org/W2168329627"],"related_works":["https://openalex.org/W2044261056","https://openalex.org/W1990965815","https://openalex.org/W1527643973","https://openalex.org/W2097349270","https://openalex.org/W2032593616","https://openalex.org/W2036410738","https://openalex.org/W7208775733","https://openalex.org/W2169657819","https://openalex.org/W4306322080","https://openalex.org/W1566251565"],"abstract_inverted_index":{"If":[0],"replacement":[1,45,116],"selection":[2,117],"is":[3,118,145,160,181],"used":[4,55],"in":[5,19,191,217],"an":[6,135],"external":[7,136,169],"mergesort":[8],"to":[9,205],"generate":[10],"initial":[11],"runs,":[12],"individual":[13],"records":[14,25,96],"are":[15],"deleted":[16],"and":[17,34,62,83,97,107,227],"inserted":[18],"the":[20,27,71,155,162,165,175,211],"sort":[21,137,208],"operation's":[22],"workspace.":[23,67],"Variable-length":[24],"introduce":[26],"need":[28],"for":[29,64,102,108,122,127,174,220],"possibly":[30],"complex":[31],"memory":[32,77,113,131,157,231],"management":[33,132,232],"extra":[35,93],"copying":[36,94],"of":[37,79,95,112,154,168,229],"records.":[38,129],"As":[39],"a":[40,109,119,151,201],"result,":[41],"few":[42],"systems":[43],"employ":[44],"selection,":[46],"even":[47,126,178],"though":[48],"it":[49,180],"produces":[50],"longer":[51],"runs":[52],"than":[53,149,188,214],"commonly":[54],"algorithms.":[56,209],"We":[57,68],"experimentally":[58],"compared":[59,204],"several":[60],"algorithms":[61],"variants":[63],"managing":[65],"this":[66],"found":[69],"that":[70,139],"simple":[72],"best":[73],"fit":[74],"algorithm":[75,121,138],"achieves":[76],"utilization":[78],"90%":[80],"or":[81,150],"better":[82],"run":[84],"lengths":[85],"over":[86],"1.8":[87],"times":[88],"workspace":[89],"size,":[90],"with":[91,164],"no":[92],"very":[98],"little":[99,183],"other":[100],"overhead,":[101],"widely":[103],"varying":[104],"record":[105,186],"sizes":[106,223],"wide":[110],"range":[111],"sizes.":[114],"Thus,":[115,190],"viable":[120],"commercial":[123],"database":[124,207],"systems,":[125],"variable-length":[128],"Efficient":[130],"also":[133],"enables":[134],"degrades":[140],"gracefully":[141],"when":[142],"its":[143],"input":[144,177,222],"only":[146],"slightly":[147],"larger":[148,187],"small":[152],"multiple":[153],"available":[156],"size.":[158],"This":[159],"not":[161],"case":[163],"usual":[166],"implementations":[167],"sorting,":[170],"which":[171],"incur":[172],"I/O":[173,198,218],"entire":[176],"if":[179],"as":[182,184],"one":[185],"memory.":[189],"some":[192],"cases,":[193],"our":[194],"techniques":[195],"may":[196],"reduce":[197],"volume":[199,219],"by":[200],"factor":[202],"10":[203],"traditional":[206],"Moreover,":[210],"gradual":[212],"rather":[213],"abrupt":[215],"growth":[216],"increasing":[221],"significantly":[224],"eases":[225],"design":[226],"implementation":[228],"intra-query":[230],"policies.":[233]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W4248739752","counts_by_year":[{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":2},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2022-05-12T00:00:00"}
