{"id":"https://openalex.org/W1993226606","doi":"https://doi.org/10.1145/2588555.2610521","title":"Track join","display_name":"Track join","publication_year":2014,"publication_date":"2014-06-18","ids":{"openalex":"https://openalex.org/W1993226606","doi":"https://doi.org/10.1145/2588555.2610521","mag":"1993226606"},"language":"en","primary_location":{"id":"doi:10.1145/2588555.2610521","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2588555.2610521","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2014 ACM SIGMOD 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/A5077806101","display_name":"Orestis Polychroniou","orcid":"https://orcid.org/0000-0002-3164-0137"},"institutions":[{"id":"https://openalex.org/I78577930","display_name":"Columbia University","ror":"https://ror.org/00hj8s172","country_code":"US","type":"education","lineage":["https://openalex.org/I78577930"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Orestis Polychroniou","raw_affiliation_strings":["Columbia University, New York, NY, USA"],"affiliations":[{"raw_affiliation_string":"Columbia University, New York, NY, USA","institution_ids":["https://openalex.org/I78577930"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5069495887","display_name":"Rajkumar Sen","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Rajkumar Sen","raw_affiliation_strings":["Oracle Corporation, Redwood Shores, CA, USA"],"affiliations":[{"raw_affiliation_string":"Oracle Corporation, Redwood Shores, CA, USA","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5021663937","display_name":"Kenneth A. Ross","orcid":"https://orcid.org/0000-0001-9397-6990"},"institutions":[{"id":"https://openalex.org/I78577930","display_name":"Columbia University","ror":"https://ror.org/00hj8s172","country_code":"US","type":"education","lineage":["https://openalex.org/I78577930"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Kenneth A. Ross","raw_affiliation_strings":["Columbia University, New York, NY, USA"],"affiliations":[{"raw_affiliation_string":"Columbia University, New York, NY, USA","institution_ids":["https://openalex.org/I78577930"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5077806101"],"corresponding_institution_ids":["https://openalex.org/I78577930"],"apc_list":null,"apc_paid":null,"fwci":12.1843,"has_fulltext":false,"cited_by_count":73,"citation_normalized_percentile":{"value":0.98766122,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":100},"biblio":{"volume":null,"issue":null,"first_page":"1483","last_page":"1494"},"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.9987999796867371,"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/T12761","display_name":"Data Stream Mining Techniques","score":0.9939000010490417,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8742533922195435},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.8116762638092041},{"id":"https://openalex.org/keywords/hash-join","display_name":"Hash join","score":0.5970516204833984},{"id":"https://openalex.org/keywords/locality","display_name":"Locality","score":0.5950486660003662},{"id":"https://openalex.org/keywords/sort-merge-join","display_name":"Sort-merge join","score":0.535449743270874},{"id":"https://openalex.org/keywords/track","display_name":"Track (disk drive)","score":0.5099717378616333},{"id":"https://openalex.org/keywords/schedule","display_name":"Schedule","score":0.48123717308044434},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.47176554799079895},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.4709502160549164},{"id":"https://openalex.org/keywords/transfer","display_name":"Transfer (computing)","score":0.41802603006362915},{"id":"https://openalex.org/keywords/distributed-database","display_name":"Distributed database","score":0.41123417019844055},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.4100114107131958},{"id":"https://openalex.org/keywords/hash-function","display_name":"Hash function","score":0.37832608819007874},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.35941576957702637},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.33609694242477417},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.32933443784713745},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.13622331619262695},{"id":"https://openalex.org/keywords/computer-security","display_name":"Computer security","score":0.10502058267593384}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8742533922195435},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.8116762638092041},{"id":"https://openalex.org/C188805328","wikidata":"https://www.wikidata.org/wiki/Q4060691","display_name":"Hash join","level":3,"score":0.5970516204833984},{"id":"https://openalex.org/C2779808786","wikidata":"https://www.wikidata.org/wiki/Q6664603","display_name":"Locality","level":2,"score":0.5950486660003662},{"id":"https://openalex.org/C203570394","wikidata":"https://www.wikidata.org/wiki/Q4060688","display_name":"Sort-merge join","level":3,"score":0.535449743270874},{"id":"https://openalex.org/C89992363","wikidata":"https://www.wikidata.org/wiki/Q5961558","display_name":"Track (disk drive)","level":2,"score":0.5099717378616333},{"id":"https://openalex.org/C68387754","wikidata":"https://www.wikidata.org/wiki/Q7271585","display_name":"Schedule","level":2,"score":0.48123717308044434},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.47176554799079895},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.4709502160549164},{"id":"https://openalex.org/C2776175482","wikidata":"https://www.wikidata.org/wiki/Q1195816","display_name":"Transfer (computing)","level":2,"score":0.41802603006362915},{"id":"https://openalex.org/C70061542","wikidata":"https://www.wikidata.org/wiki/Q989016","display_name":"Distributed database","level":2,"score":0.41123417019844055},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.4100114107131958},{"id":"https://openalex.org/C99138194","wikidata":"https://www.wikidata.org/wiki/Q183427","display_name":"Hash function","level":2,"score":0.37832608819007874},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.35941576957702637},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.33609694242477417},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.32933443784713745},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.13622331619262695},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.10502058267593384},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0},{"id":"https://openalex.org/C41895202","wikidata":"https://www.wikidata.org/wiki/Q8162","display_name":"Linguistics","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2588555.2610521","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2588555.2610521","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G4038806553","display_name":null,"funder_award_id":"IIS-0915956","funder_id":"https://openalex.org/F4320337389","funder_display_name":"Division of Information and Intelligent Systems"}],"funders":[{"id":"https://openalex.org/F4320337389","display_name":"Division of Information and Intelligent Systems","ror":"https://ror.org/053a2cp42"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":36,"referenced_works":["https://openalex.org/W150801922","https://openalex.org/W1852059679","https://openalex.org/W1852127287","https://openalex.org/W1967601791","https://openalex.org/W1997020216","https://openalex.org/W1998663979","https://openalex.org/W2003515726","https://openalex.org/W2006552857","https://openalex.org/W2007030756","https://openalex.org/W2023195086","https://openalex.org/W2024462572","https://openalex.org/W2029866183","https://openalex.org/W2039910065","https://openalex.org/W2043934800","https://openalex.org/W2045938805","https://openalex.org/W2061601738","https://openalex.org/W2075620950","https://openalex.org/W2080427212","https://openalex.org/W2082695854","https://openalex.org/W2096496252","https://openalex.org/W2101161250","https://openalex.org/W2104003087","https://openalex.org/W2114303224","https://openalex.org/W2116926680","https://openalex.org/W2122465391","https://openalex.org/W2123845384","https://openalex.org/W2125529470","https://openalex.org/W2136625956","https://openalex.org/W2143108641","https://openalex.org/W2143377704","https://openalex.org/W2146183750","https://openalex.org/W2153485419","https://openalex.org/W2154614053","https://openalex.org/W2406955896","https://openalex.org/W3102704970","https://openalex.org/W3138135046"],"related_works":["https://openalex.org/W2381211091","https://openalex.org/W2091359263","https://openalex.org/W4283362132","https://openalex.org/W4234452035","https://openalex.org/W2469706965","https://openalex.org/W4205996836","https://openalex.org/W1866159721","https://openalex.org/W1589496614","https://openalex.org/W1989231289","https://openalex.org/W54313720"],"abstract_inverted_index":{"Network":[0],"communication":[1,29],"is":[2],"the":[3,55,65,94,138],"slowest":[4],"component":[5],"of":[6,62,119,142],"many":[7],"operators":[8],"in":[9],"distributed":[10,73],"parallel":[11,36],"databases":[12,25],"deployed":[13],"for":[14,42,47,86],"large-scale":[15],"analytics.":[16],"Whereas":[17],"considerable":[18],"work":[19],"has":[20,31],"focused":[21],"on":[22,26,39,104,137],"speeding":[23],"up":[24],"modern":[27],"hardware,":[28],"reduction":[30],"received":[32],"less":[33],"attention.":[34],"Existing":[35],"DBMSs":[37],"rely":[38],"algorithms":[40],"designed":[41],"disks":[43],"with":[44,129],"minor":[45],"modifications":[46],"networks.":[48],"A":[49],"more":[50],"complicated":[51],"algorithm":[52,75],"may":[53],"burden":[54],"CPUs,":[56],"but":[57],"could":[58],"avoid":[59],"redundant":[60],"transfers":[61],"tuples":[63],"across":[64],"network.":[66,100],"We":[67],"introduce":[68],"track":[69,111,132],"join,":[70],"a":[71],"novel":[72],"join":[74,89,92,112,133,136],"that":[76,110],"minimizes":[77],"network":[78,123],"traffic":[79,124],"by":[80],"generating":[81],"an":[82],"optimal":[83],"transfer":[84],"schedule":[85],"each":[87],"distinct":[88],"key.":[90],"Track":[91],"extends":[93],"trade-off":[95],"options":[96],"between":[97],"CPU":[98],"and":[99,106,117,125],"Our":[101],"evaluation":[102],"based":[103],"real":[105,143],"synthetic":[107],"data":[108],"shows":[109],"adapts":[113],"to":[114],"diverse":[115],"cases":[116],"degrees":[118],"locality.":[120],"Considering":[121],"both":[122],"execution":[126],"time,":[127],"even":[128],"no":[130],"locality,":[131],"outperforms":[134],"hash":[135],"most":[139],"expensive":[140],"queries":[141],"workloads.":[144]},"counts_by_year":[{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":5},{"year":2022,"cited_by_count":4},{"year":2021,"cited_by_count":5},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":7},{"year":2018,"cited_by_count":12},{"year":2017,"cited_by_count":11},{"year":2016,"cited_by_count":13},{"year":2015,"cited_by_count":10}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2016-06-24T00:00:00"}