{"id":"https://openalex.org/W2101161250","doi":"https://doi.org/10.1109/icde.2014.6816684","title":"Locality-sensitive operators for parallel main-memory database clusters","display_name":"Locality-sensitive operators for parallel main-memory database clusters","publication_year":2014,"publication_date":"2014-03-01","ids":{"openalex":"https://openalex.org/W2101161250","doi":"https://doi.org/10.1109/icde.2014.6816684","mag":"2101161250"},"language":"en","primary_location":{"id":"doi:10.1109/icde.2014.6816684","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2014.6816684","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2014 IEEE 30th International Conference on Data Engineering","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/A5066944444","display_name":"Wolf R\u00f6diger","orcid":null},"institutions":[{"id":"https://openalex.org/I62916508","display_name":"Technical University of Munich","ror":"https://ror.org/02kkvpp62","country_code":"DE","type":"education","lineage":["https://openalex.org/I62916508"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Wolf Rodiger","raw_affiliation_strings":["Technische Universitat Munchen Munich, Germany","Technische Universit\u00e4t M\u00fcnchen Munich Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Technische Universitat Munchen Munich, Germany","institution_ids":["https://openalex.org/I62916508"]},{"raw_affiliation_string":"Technische Universit\u00e4t M\u00fcnchen Munich Germany","institution_ids":["https://openalex.org/I62916508"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5023235581","display_name":"Tobias M\u00fchlbauer","orcid":"https://orcid.org/0000-0002-1843-198X"},"institutions":[{"id":"https://openalex.org/I62916508","display_name":"Technical University of Munich","ror":"https://ror.org/02kkvpp62","country_code":"DE","type":"education","lineage":["https://openalex.org/I62916508"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Tobias Muhlbauer","raw_affiliation_strings":["Technische Universitat Munchen Munich, Germany","Technische Universit\u00e4t M\u00fcnchen Munich Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Technische Universitat Munchen Munich, Germany","institution_ids":["https://openalex.org/I62916508"]},{"raw_affiliation_string":"Technische Universit\u00e4t M\u00fcnchen Munich Germany","institution_ids":["https://openalex.org/I62916508"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5057096772","display_name":"Philipp Unterbrunner","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Philipp Unterbrunner","raw_affiliation_strings":["Snowflake Computing, Inc., San Mateo, CA","Snowflake Computing, Inc., San Mateo, CA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Snowflake Computing, Inc., San Mateo, CA","institution_ids":[]},{"raw_affiliation_string":"Snowflake Computing, Inc., San Mateo, CA, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5026572127","display_name":"Angelika Reiser","orcid":null},"institutions":[{"id":"https://openalex.org/I62916508","display_name":"Technical University of Munich","ror":"https://ror.org/02kkvpp62","country_code":"DE","type":"education","lineage":["https://openalex.org/I62916508"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Angelika Reiser","raw_affiliation_strings":["Technische Universitat Munchen Munich, Germany","Technische Universit\u00e4t M\u00fcnchen Munich Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Technische Universitat Munchen Munich, Germany","institution_ids":["https://openalex.org/I62916508"]},{"raw_affiliation_string":"Technische Universit\u00e4t M\u00fcnchen Munich Germany","institution_ids":["https://openalex.org/I62916508"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5105817801","display_name":"Alfons Kemper","orcid":"https://orcid.org/0009-0003-9066-271X"},"institutions":[{"id":"https://openalex.org/I62916508","display_name":"Technical University of Munich","ror":"https://ror.org/02kkvpp62","country_code":"DE","type":"education","lineage":["https://openalex.org/I62916508"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Alfons Kemper","raw_affiliation_strings":["Technische Universitat Munchen Munich, Germany","Technische Universit\u00e4t M\u00fcnchen Munich Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Technische Universitat Munchen Munich, Germany","institution_ids":["https://openalex.org/I62916508"]},{"raw_affiliation_string":"Technische Universit\u00e4t M\u00fcnchen Munich Germany","institution_ids":["https://openalex.org/I62916508"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5101880157","display_name":"Thomas Neumann","orcid":"https://orcid.org/0000-0001-5787-142X"},"institutions":[{"id":"https://openalex.org/I62916508","display_name":"Technical University of Munich","ror":"https://ror.org/02kkvpp62","country_code":"DE","type":"education","lineage":["https://openalex.org/I62916508"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Thomas Neumann","raw_affiliation_strings":["Technische Universitat Munchen Munich, Germany","Technische Universit\u00e4t M\u00fcnchen Munich Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Technische Universitat Munchen Munich, Germany","institution_ids":["https://openalex.org/I62916508"]},{"raw_affiliation_string":"Technische Universit\u00e4t M\u00fcnchen Munich Germany","institution_ids":["https://openalex.org/I62916508"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":6,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":8.5509,"has_fulltext":false,"cited_by_count":54,"citation_normalized_percentile":{"value":0.98293282,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"592","last_page":"603"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9993000030517578,"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.9993000030517578,"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/T11478","display_name":"Caching and Content Delivery","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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9983999729156494,"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/locality","display_name":"Locality","score":0.8171731233596802},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8124837875366211},{"id":"https://openalex.org/keywords/shuffling","display_name":"Shuffling","score":0.7238183617591858},{"id":"https://openalex.org/keywords/skew","display_name":"Skew","score":0.6217061877250671},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.5398504137992859},{"id":"https://openalex.org/keywords/partition","display_name":"Partition (number theory)","score":0.526988685131073},{"id":"https://openalex.org/keywords/distributed-database","display_name":"Distributed database","score":0.44388431310653687},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.3371008038520813},{"id":"https://openalex.org/keywords/computer-network","display_name":"Computer network","score":0.323144793510437},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.10024383664131165}],"concepts":[{"id":"https://openalex.org/C2779808786","wikidata":"https://www.wikidata.org/wiki/Q6664603","display_name":"Locality","level":2,"score":0.8171731233596802},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8124837875366211},{"id":"https://openalex.org/C167927819","wikidata":"https://www.wikidata.org/wiki/Q1930567","display_name":"Shuffling","level":2,"score":0.7238183617591858},{"id":"https://openalex.org/C43711488","wikidata":"https://www.wikidata.org/wiki/Q7534783","display_name":"Skew","level":2,"score":0.6217061877250671},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.5398504137992859},{"id":"https://openalex.org/C42812","wikidata":"https://www.wikidata.org/wiki/Q1082910","display_name":"Partition (number theory)","level":2,"score":0.526988685131073},{"id":"https://openalex.org/C70061542","wikidata":"https://www.wikidata.org/wiki/Q989016","display_name":"Distributed database","level":2,"score":0.44388431310653687},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.3371008038520813},{"id":"https://openalex.org/C31258907","wikidata":"https://www.wikidata.org/wiki/Q1301371","display_name":"Computer network","level":1,"score":0.323144793510437},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.10024383664131165},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"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/C41895202","wikidata":"https://www.wikidata.org/wiki/Q8162","display_name":"Linguistics","level":1,"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/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1109/icde.2014.6816684","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2014.6816684","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2014 IEEE 30th International Conference on Data Engineering","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.645.6798","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.645.6798","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www-db.in.tum.de/~roediger/papers/roediger2014locality.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320321114","display_name":"Bundesministerium f\u00fcr Bildung und Forschung","ror":"https://ror.org/04pz7b180"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":44,"referenced_works":["https://openalex.org/W150801922","https://openalex.org/W1560473542","https://openalex.org/W1900515362","https://openalex.org/W1975577269","https://openalex.org/W1992730709","https://openalex.org/W2003515726","https://openalex.org/W2007030756","https://openalex.org/W2011039300","https://openalex.org/W2024462572","https://openalex.org/W2043099794","https://openalex.org/W2043934800","https://openalex.org/W2055176966","https://openalex.org/W2075620950","https://openalex.org/W2076164405","https://openalex.org/W2080427212","https://openalex.org/W2093229192","https://openalex.org/W2102729946","https://openalex.org/W2103670492","https://openalex.org/W2109149785","https://openalex.org/W2111519186","https://openalex.org/W2116435146","https://openalex.org/W2120276090","https://openalex.org/W2122048769","https://openalex.org/W2123845384","https://openalex.org/W2125529470","https://openalex.org/W2128912667","https://openalex.org/W2139072600","https://openalex.org/W2143108641","https://openalex.org/W2143377704","https://openalex.org/W2154614053","https://openalex.org/W2155070484","https://openalex.org/W2159726625","https://openalex.org/W2170289748","https://openalex.org/W2171922437","https://openalex.org/W2172913381","https://openalex.org/W2178463917","https://openalex.org/W2188889839","https://openalex.org/W4248948635","https://openalex.org/W6633588563","https://openalex.org/W6639841889","https://openalex.org/W6676390144","https://openalex.org/W6679046037","https://openalex.org/W6685860923","https://openalex.org/W6687139329"],"related_works":["https://openalex.org/W4213239787","https://openalex.org/W2045745654","https://openalex.org/W2114337652","https://openalex.org/W4377131110","https://openalex.org/W4388857216","https://openalex.org/W4294559962","https://openalex.org/W2046590706","https://openalex.org/W4387423656","https://openalex.org/W4389136702","https://openalex.org/W4281381431"],"abstract_inverted_index":{"The":[0],"growth":[1,8],"in":[2,9,74,173],"compute":[3],"speed":[4],"has":[5,17,34],"outpaced":[6],"the":[7,13,37,58,75,90,112,138,174],"network":[10,115,139,171],"bandwidth":[11,146],"over":[12],"last":[14],"decades.":[15],"This":[16],"led":[18],"to":[19,35,45,49,52,64,72,87,136,149,200],"an":[20],"increasing":[21],"performance":[22,197],"gap":[23],"between":[24],"local":[25],"and":[26,69,123,161,166,207],"distributed":[27,118],"processing.":[28,41],"A":[29,42],"parallel":[30],"database":[31],"cluster":[32],"thus":[33],"maximize":[36],"locality":[38,135,157],"of":[39,77,114,176,183,202,210],"query":[40],"common":[43],"technique":[44],"this":[46,61,101],"end":[47],"is":[48,62,70],"co-partition":[50],"relations":[51],"avoid":[53],"expensive":[54,71],"data":[55,106,159],"shuffling":[56],"across":[57],"network.":[59],"However,":[60],"limited":[63],"one":[65],"attribute":[66],"per":[67],"relation":[68],"maintain":[73],"face":[76],"updates.":[78],"Other":[79],"attributes":[80],"often":[81],"exhibit":[82],"a":[83,208],"fuzzy":[84,205],"co-location":[85,206],"due":[86,148],"correlations":[88],"with":[89,214],"distribution":[91],"key":[92],"but":[93],"current":[94],"approaches":[95],"do":[96],"not":[97],"leverage":[98],"this.":[99],"In":[100],"paper,":[102],"we":[103],"introduce":[104],"locality-sensitive":[105],"shuffling,":[107],"which":[108,190],"can":[109,195],"dramatically":[110],"reduce":[111,137],"amount":[113],"communication":[116,143,172],"for":[117,204,212],"operators":[119],"such":[120],"as":[121],"join":[122],"aggregation.":[124],"We":[125,185],"present":[126,186],"four":[127],"novel":[128],"techniques:":[129],"(i)":[130],"optimal":[131],"partition":[132],"assignment":[133],"exploits":[134],"phase":[140],"duration;":[141],"(ii)":[142],"scheduling":[144],"avoids":[145],"underutilization":[147],"cross":[150],"traffic;":[151],"(iii)":[152],"adaptive":[153],"radix":[154],"partitioning":[155],"retains":[156],"during":[158],"repartitioning":[160],"handles":[162],"value":[163,178,215],"skew":[164,179],"gracefully;":[165],"(iv)":[167],"selective":[168],"broadcast":[169],"reduces":[170],"presence":[175],"extreme":[177],"or":[180],"large":[181],"numbers":[182],"duplicates.":[184],"comprehensive":[187],"experimental":[188],"results,":[189],"show":[191],"that":[192],"our":[193],"techniques":[194],"improve":[196],"by":[198],"up":[199],"factor":[201,209],"5":[203],"3":[211],"inputs":[213],"skew.":[216]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":2},{"year":2021,"cited_by_count":4},{"year":2020,"cited_by_count":3},{"year":2019,"cited_by_count":4},{"year":2018,"cited_by_count":9},{"year":2017,"cited_by_count":7},{"year":2016,"cited_by_count":8},{"year":2015,"cited_by_count":10},{"year":2014,"cited_by_count":4}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}