{"id":"https://openalex.org/W2139018928","doi":"https://doi.org/10.1145/114325.103713","title":"Optimizing equijoin queries in distributed databases where relations are hash partitioned","display_name":"Optimizing equijoin queries in distributed databases where relations are hash partitioned","publication_year":1991,"publication_date":"1991-05-01","ids":{"openalex":"https://openalex.org/W2139018928","doi":"https://doi.org/10.1145/114325.103713","mag":"2139018928"},"language":"en","primary_location":{"id":"doi:10.1145/114325.103713","doi":"https://doi.org/10.1145/114325.103713","is_oa":true,"landing_page_url":"https://doi.org/10.1145/114325.103713","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/114325.103713","source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["ccf-a","cwts-core","dongbi-a","jufo-3","norway-1","poland-100","russia-white-list-2"],"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 Transactions on Database Systems","raw_type":"journal-article"},"parent_works":[],"lineage":["https://openalex.org/W2139018928"],"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/114325.103713","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5055576104","display_name":"Dennis E. Shasha","orcid":"https://orcid.org/0000-0002-7036-3312","observed_orcids":["https://orcid.org/0000-0002-7036-3312"]},"institutions":[{"id":"https://openalex.org/I57206974","display_name":"New York University","ror":"https://ror.org/0190ak572","country_code":"US","type":"education","lineage":["https://openalex.org/I57206974"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Dennis Shasha","raw_affiliation_strings":["New York Univ., New York, NY"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"New York Univ., New York, NY","institution_ids":["https://openalex.org/I57206974"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5009280620","display_name":"Tsong-Li Wang","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I57206974","display_name":"New York University","ror":"https://ror.org/0190ak572","country_code":"US","type":"education","lineage":["https://openalex.org/I57206974"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Tsong-Li Wang","raw_affiliation_strings":["New York Univ., New York, NY"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"New York Univ., New York, NY","institution_ids":["https://openalex.org/I57206974"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I57206974"],"apc_list":null,"apc_paid":null,"fwci":3.2902,"has_fulltext":true,"cited_by_count":62,"citation_normalized_percentile":{"value":0.91571652,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":87,"max":97},"biblio":{"volume":"16","issue":"2","first_page":"279","last_page":"308"},"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.9990000128746033,"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.9990000128746033,"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/T11106","display_name":"Data Management and Algorithms","score":9.999999747378752e-05,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":9.999999747378752e-05,"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/distributed-databases","display_name":"distributed databases","score":0.6449999809265137},{"id":"https://openalex.org/keywords/hash-partitioning","display_name":"hash partitioning","score":0.8709999918937683},{"id":"https://openalex.org/keywords/query-optimization","display_name":"query optimization","score":0.890999972820282},{"id":"https://openalex.org/keywords/repartitioning","display_name":"repartitioning","score":0.7450000047683716},{"id":"https://openalex.org/keywords/np-completeness","display_name":"NP-completeness","score":0.9409999847412109},{"id":"https://openalex.org/keywords/heuristics","display_name":"heuristics","score":0.6990000009536743},{"id":"https://openalex.org/keywords/tree-queries","display_name":"tree queries","score":0.8820000290870667},{"id":"https://openalex.org/keywords/attribute-partitioning","display_name":"attribute partitioning","score":0.7860000133514404}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8926849961280823},{"id":"https://openalex.org/C99138194","wikidata":"https://www.wikidata.org/wiki/Q183427","display_name":"Hash function","level":2,"score":0.5906955003738403},{"id":"https://openalex.org/C127705205","wikidata":"https://www.wikidata.org/wiki/Q5748245","display_name":"Heuristics","level":2,"score":0.5361713171005249},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.4607492685317993},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.45740512013435364},{"id":"https://openalex.org/C70061542","wikidata":"https://www.wikidata.org/wiki/Q989016","display_name":"Distributed database","level":2,"score":0.4136122465133667},{"id":"https://openalex.org/C132525143","wikidata":"https://www.wikidata.org/wiki/Q141488","display_name":"Graph","level":2,"score":0.41321122646331787},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.36985769867897034},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.3391691744327545},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.13812482357025146},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/114325.103713","doi":"https://doi.org/10.1145/114325.103713","is_oa":true,"landing_page_url":"https://doi.org/10.1145/114325.103713","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/114325.103713","source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["ccf-a","cwts-core","dongbi-a","jufo-3","norway-1","poland-100","russia-white-list-2"],"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 Transactions on Database Systems","raw_type":"journal-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.78.6583","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.78.6583","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cis.njit.edu/~jason/publications/ARTICLES/tods91.pdf","raw_type":"text"}],"best_oa_location":{"id":"doi:10.1145/114325.103713","doi":"https://doi.org/10.1145/114325.103713","is_oa":true,"landing_page_url":"https://doi.org/10.1145/114325.103713","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/114325.103713","source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["ccf-a","cwts-core","dongbi-a","jufo-3","norway-1","poland-100","russia-white-list-2"],"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 Transactions on Database Systems","raw_type":"journal-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2139018928.pdf","grobid_xml":"https://content.openalex.org/works/W2139018928.grobid-xml"},"referenced_works_count":42,"referenced_works":["https://openalex.org/W187405143","https://openalex.org/W1492557950","https://openalex.org/W1495330698","https://openalex.org/W1531789027","https://openalex.org/W1567049765","https://openalex.org/W1964111545","https://openalex.org/W1965680834","https://openalex.org/W1969914452","https://openalex.org/W1970196737","https://openalex.org/W1972223681","https://openalex.org/W1975577269","https://openalex.org/W1977735896","https://openalex.org/W1980618802","https://openalex.org/W1986353419","https://openalex.org/W2006562083","https://openalex.org/W2007030756","https://openalex.org/W2007254420","https://openalex.org/W2009020789","https://openalex.org/W2011039300","https://openalex.org/W2014164286","https://openalex.org/W2017927472","https://openalex.org/W2023195086","https://openalex.org/W2034401457","https://openalex.org/W2051244613","https://openalex.org/W2053923570","https://openalex.org/W2059844260","https://openalex.org/W2071697688","https://openalex.org/W2072191579","https://openalex.org/W2080411824","https://openalex.org/W2082004608","https://openalex.org/W2084248338","https://openalex.org/W2111050884","https://openalex.org/W2122789628","https://openalex.org/W2124170481","https://openalex.org/W2149865846","https://openalex.org/W2153329411","https://openalex.org/W2169486917","https://openalex.org/W2200275386","https://openalex.org/W2911503018","https://openalex.org/W2915032613","https://openalex.org/W4245035583","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W2169884383","https://openalex.org/W3161036085","https://openalex.org/W1589440274","https://openalex.org/W4231963327","https://openalex.org/W2020864892","https://openalex.org/W1980618802","https://openalex.org/W4233735114","https://openalex.org/W2053923570","https://openalex.org/W1543406948","https://openalex.org/W4299604338"],"abstract_inverted_index":{"Consider":[0],"the":[1,46,79,85,90,103,118,121],"class":[2],"of":[3,8,11,22,102,105,120,144],"distributed":[4,65],"database":[5,66],"systems":[6,67],"consisting":[7],"a":[9,15,23,25,30,38,55,59,97],"set":[10],"nodes":[12],"connected":[13],"by":[14],"high":[16],"bandwidth":[17],"network.":[18],"Each":[19],"node":[20],"consists":[21],"processor,":[24],"random":[26],"access":[27],"memory,":[28],"and":[29,75,92,127,131,142,158],"slower":[31],"but":[32],"much":[33],"larger":[34],"memory":[35,44],"such":[36],"as":[37],"disk.":[39],"There":[40],"is":[41],"no":[42],"shared":[43],"among":[45],"nodes.":[47],"The":[48],"data":[49],"are":[50],"horizontally":[51],"partitioned":[52,160],"often":[53],"using":[54],"hash":[56],"function.":[57],"Such":[58],"description":[60],"characterizes":[61],"many":[62,143],"parallel":[63],"or":[64],"that":[68,82],"have":[69],"recently":[70],"been":[71],"proposed,":[72],"both":[73],"commercial":[74],"academic.":[76],"We":[77],"study":[78],"optimization":[80,122],"problem":[81,123],"arises":[83],"when":[84],"query":[86],"processor":[87],"must":[88],"repartition":[89],"relations":[91],"intermediate":[93,106],"results":[94,146],"participating":[95],"in":[96],"multijoin":[98],"query.":[99],"Using":[100],"estimates":[101],"sizes":[104],"relations,":[107],"we":[108],"show":[109],"(1)":[110],"optimum":[111],"solutions":[112],"for":[113,124,135,153],"closed":[114],"chain":[115],"queries;":[116,130],"(2)":[117],"NP-completeness":[119],"star,":[125],"tree,":[126],"general":[128,140],"graph":[129],"(3)":[132],"effective":[133],"heuristics":[134],"these":[136],"hard":[137],"cases.":[138],"Our":[139],"approach":[141],"our":[145],"extend":[147],"to":[148,159],"other":[149],"attribute":[150],"partitioning":[151],"schemes,":[152],"example,":[154],"sort-partitioning":[155],"on":[156],"attributes,":[157],"object":[161],"databases.":[162]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2012,"cited_by_count":3}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2016-06-24T00:00:00"}
