乐胖代购免代理版

{"id":"https://openalex.org/W2015372451","doi":"https://doi.org/10.1145/128762.128764","title":"Join processing in relational databases","display_name":"Join processing in relational databases","publication_year":1992,"publication_date":"1992-03-01","ids":{"openalex":"https://openalex.org/W2015372451","doi":"https://doi.org/10.1145/128762.128764","mag":"2015372451"},"language":"en","primary_location":{"is_oa":false,"landing_page_url":"https://doi.org/10.1145/128762.128764","pdf_url":null,"source":{"id":"https://openalex.org/S157921468","display_name":"ACM Computing Surveys","issn_l":"0360-0300","issn":["0360-0300","1557-7341"],"is_oa":false,"is_in_doaj":false,"is_core":true,"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":null,"is_accepted":false,"is_published":false},"type":"review","type_crossref":"journal-article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://www.eecs.umich.edu/~jag/eecs584/papers/joins.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5071568269","display_name":"Priti Mishra","orcid":"https://orcid.org/0000-0002-8094-4065"},"institutions":[{"id":"https://openalex.org/I178169726","display_name":"Southern Methodist University","ror":"https://ror.org/042tdr378","country_code":"US","type":"education","lineage":["https://openalex.org/I178169726"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Priti Mishra","raw_affiliation_strings":["Southern Methodist University , Dallas , TX"],"affiliations":[{"raw_affiliation_string":"Southern Methodist University , Dallas , TX","institution_ids":["https://openalex.org/I178169726"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5085008687","display_name":"Margaret H. Eich","orcid":null},"institutions":[{"id":"https://openalex.org/I178169726","display_name":"Southern Methodist University","ror":"https://ror.org/042tdr378","country_code":"US","type":"education","lineage":["https://openalex.org/I178169726"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Margaret H. Eich","raw_affiliation_strings":["Southern Methodist University , Dallas , TX"],"affiliations":[{"raw_affiliation_string":"Southern Methodist University , Dallas , TX","institution_ids":["https://openalex.org/I178169726"]}]}],"institution_assertions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":7.736,"has_fulltext":true,"fulltext_origin":"ngrams","cited_by_count":411,"citation_normalized_percentile":{"value":0.818182,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":99,"max":100},"biblio":{"volume":"24","issue":"1","first_page":"63","last_page":"113"},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9999,"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.9999,"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.9997,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9926,"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/relational-algebra","display_name":"Relational algebra","score":0.7504442},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.7047585},{"id":"https://openalex.org/keywords/sort-merge-join","display_name":"Sort-merge join","score":0.6750552},{"id":"https://openalex.org/keywords/cartesian-product","display_name":"Cartesian product","score":0.66763437},{"id":"https://openalex.org/keywords/conjunctive-query","display_name":"Conjunctive query","score":0.47711828},{"id":"https://openalex.org/keywords/hash-join","display_name":"Hash join","score":0.41724667}],"concepts":[{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.90008247},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8481536},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.8388437},{"id":"https://openalex.org/C95916125","wikidata":"https://www.wikidata.org/wiki/Q840540","display_name":"Relational algebra","level":3,"score":0.7504442},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.7047585},{"id":"https://openalex.org/C203570394","wikidata":"https://www.wikidata.org/wiki/Q4060688","display_name":"Sort-merge join","level":3,"score":0.6750552},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6708496},{"id":"https://openalex.org/C65236422","wikidata":"https://www.wikidata.org/wiki/Q173740","display_name":"Cartesian product","level":2,"score":0.66763437},{"id":"https://openalex.org/C42812","wikidata":"https://www.wikidata.org/wiki/Q1082910","display_name":"Partition (number theory)","level":2,"score":0.6067449},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.47711828},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.46960104},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.46248394},{"id":"https://openalex.org/C25343380","wikidata":"https://www.wikidata.org/wiki/Q277521","display_name":"Relation (database)","level":2,"score":0.45207077},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.45103535},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.44564664},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.42179066},{"id":"https://openalex.org/C188805328","wikidata":"https://www.wikidata.org/wiki/Q4060691","display_name":"Hash join","level":3,"score":0.41724667},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.35292542},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.17547032},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.10808453},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"is_oa":false,"landing_page_url":"https://doi.org/10.1145/128762.128764","pdf_url":null,"source":{"id":"https://openalex.org/S157921468","display_name":"ACM Computing Surveys","issn_l":"0360-0300","issn":["0360-0300","1557-7341"],"is_oa":false,"is_in_doaj":false,"is_core":true,"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":null,"is_accepted":false,"is_published":false},{"is_oa":true,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.111.9787","pdf_url":"http://www.eecs.umich.edu/~jag/eecs584/papers/joins.pdf","source":{"id":"https://openalex.org/S4306400349","display_name":"CiteSeer X (The Pennsylvania State University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I130769515","host_organization_name":"Pennsylvania State University","host_organization_lineage":["https://openalex.org/I130769515"],"host_organization_lineage_names":["Pennsylvania State University"],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false}],"best_oa_location":{"is_oa":true,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.111.9787","pdf_url":"http://www.eecs.umich.edu/~jag/eecs584/papers/joins.pdf","source":{"id":"https://openalex.org/S4306400349","display_name":"CiteSeer X (The Pennsylvania State University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I130769515","host_organization_name":"Pennsylvania State University","host_organization_lineage":["https://openalex.org/I130769515"],"host_organization_lineage_names":["Pennsylvania State University"],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false},"sustainable_development_goals":[],"grants":[],"datasets":[],"versions":[],"referenced_works_count":182,"referenced_works":["https://openalex.org/W10894918","https://openalex.org/W119652905","https://openalex.org/W125826589","https://openalex.org/W147240463","https://openalex.org/W1481270797","https://openalex.org/W1484813121","https://openalex.org/W1485717436","https://openalex.org/W1487286","https://openalex.org/W1490731164","https://openalex.org/W1494984586","https://openalex.org/W1495330263","https://openalex.org/W1497748148","https://openalex.org/W1500547548","https://openalex.org/W1504621172","https://openalex.org/W1511014465","https://openalex.org/W1511620743","https://openalex.org/W1514871965","https://openalex.org/W1517578330","https://openalex.org/W1523264362","https://openalex.org/W1525824505","https://openalex.org/W1535369866","https://openalex.org/W1540077166","https://openalex.org/W1540926161","https://openalex.org/W1542571610","https://openalex.org/W1546885003","https://openalex.org/W1549212411","https://openalex.org/W1551935098","https://openalex.org/W1553031737","https://openalex.org/W1554228447","https://openalex.org/W1555210865","https://openalex.org/W1556803256","https://openalex.org/W1560319744","https://openalex.org/W156275508","https://openalex.org/W1574862731","https://openalex.org/W1581406059","https://openalex.org/W1585614323","https://openalex.org/W1585853635","https://openalex.org/W1588933040","https://openalex.org/W1604887486","https://openalex.org/W165150115","https://openalex.org/W172224151","https://openalex.org/W1748095660","https://openalex.org/W1754860248","https://openalex.org/W1774916018","https://openalex.org/W1804205637","https://openalex.org/W180578187","https://openalex.org/W1852059679","https://openalex.org/W1878777455","https://openalex.org/W1964111545","https://openalex.org/W1964883612","https://openalex.org/W1968829657","https://openalex.org/W1969914452","https://openalex.org/W1970196737","https://openalex.org/W1974610458","https://openalex.org/W1978220611","https://openalex.org/W1978775628","https://openalex.org/W1979912584","https://openalex.org/W1983959468","https://openalex.org/W1988391412","https://openalex.org/W1989002177","https://openalex.org/W1992810975","https://openalex.org/W1995023909","https://openalex.org/W2000391493","https://openalex.org/W2002045271","https://openalex.org/W2002171029","https://openalex.org/W2003758875","https://openalex.org/W2004883947","https://openalex.org/W2006564766","https://openalex.org/W2007030756","https://openalex.org/W2012534139","https://openalex.org/W2012619249","https://openalex.org/W2012802704","https://openalex.org/W2013255770","https://openalex.org/W2014164286","https://openalex.org/W2014820311","https://openalex.org/W2018223116","https://openalex.org/W2020174888","https://openalex.org/W2020646533","https://openalex.org/W202269996","https://openalex.org/W2023467128","https://openalex.org/W2026896584","https://openalex.org/W2031138923","https://openalex.org/W2032386524","https://openalex.org/W2034067146","https://openalex.org/W2042328301","https://openalex.org/W2043934800","https://openalex.org/W2048954306","https://openalex.org/W2049416518","https://openalex.org/W2051157329","https://openalex.org/W2051244613","https://openalex.org/W2055255408","https://openalex.org/W2056485317","https://openalex.org/W2063663576","https://openalex.org/W2064102738","https://openalex.org/W2064204544","https://openalex.org/W2064582900","https://openalex.org/W2064727958","https://openalex.org/W2066799613","https://openalex.org/W2066932","https://openalex.org/W2067021215","https://openalex.org/W2071697688","https://openalex.org/W2072191579","https://openalex.org/W2074753105","https://openalex.org/W2078528123","https://openalex.org/W2082004608","https://openalex.org/W2084011265","https://openalex.org/W2084248338","https://openalex.org/W2084674736","https://openalex.org/W2085338088","https://openalex.org/W2089827328","https://openalex.org/W2091339716","https://openalex.org/W2095557522","https://openalex.org/W2097737823","https://openalex.org/W2102607950","https://openalex.org/W2103585798","https://openalex.org/W2105665085","https://openalex.org/W2105899030","https://openalex.org/W2109565851","https://openalex.org/W2110605895","https://openalex.org/W2111050884","https://openalex.org/W2115822498","https://openalex.org/W2115919907","https://openalex.org/W2120705397","https://openalex.org/W2121755579","https://openalex.org/W2122789628","https://openalex.org/W2123565672","https://openalex.org/W2123845384","https://openalex.org/W2124170481","https://openalex.org/W2125965251","https://openalex.org/W2126583885","https://openalex.org/W2127872176","https://openalex.org/W2130429998","https://openalex.org/W2132254404","https://openalex.org/W2132692154","https://openalex.org/W2133794755","https://openalex.org/W2134999672","https://openalex.org/W2135738441","https://openalex.org/W2137768017","https://openalex.org/W2138709157","https://openalex.org/W2139238107","https://openalex.org/W2146183750","https://openalex.org/W2146884585","https://openalex.org/W2147491059","https://openalex.org/W2150272974","https://openalex.org/W2150503034","https://openalex.org/W2151817724","https://openalex.org/W2153248017","https://openalex.org/W2153248796","https://openalex.org/W2153329411","https://openalex.org/W2153485419","https://openalex.org/W2153524094","https://openalex.org/W2153550557","https://openalex.org/W2154220864","https://openalex.org/W2159209233","https://openalex.org/W2161653104","https://openalex.org/W2162621793","https://openalex.org/W2162641124","https://openalex.org/W2165467455","https://openalex.org/W2165558283","https://openalex.org/W2165876198","https://openalex.org/W2169486917","https://openalex.org/W2170207233","https://openalex.org/W2170918251","https://openalex.org/W2185907055","https://openalex.org/W2186799393","https://openalex.org/W2295596515","https://openalex.org/W2296139130","https://openalex.org/W23033777","https://openalex.org/W2337288897","https://openalex.org/W2561675875","https://openalex.org/W2751199251","https://openalex.org/W2912197441","https://openalex.org/W2914534446","https://openalex.org/W30928333","https://openalex.org/W4247110681","https://openalex.org/W4285719527","https://openalex.org/W49753673","https://openalex.org/W50914958","https://openalex.org/W597759811","https://openalex.org/W640676965","https://openalex.org/W69694827","https://openalex.org/W982577171"],"related_works":["https://openalex.org/W4283362132","https://openalex.org/W2404915542","https://openalex.org/W2381211091","https://openalex.org/W2154412972","https://openalex.org/W2126624503","https://openalex.org/W2091359263","https://openalex.org/W2074890970","https://openalex.org/W2015372451","https://openalex.org/W2003874303","https://openalex.org/W1603474531"],"abstract_inverted_index":{"The":[0,31,61],"join":[1,32,62,100],"operation":[2,68],"is":[3,33,63,84,88],"one":[4,34,137],"of":[5,16,27,35,73,99,108],"the":[6,14,28,36,64,71,97,105,111],"fundamental":[7],"relational":[8,66],"database":[9],"query":[10],"operations.":[11],"It":[12],"facilitates":[13],"retrieval":[15],"information":[17],"from":[18,76,128,136,143,151],"two":[19,29],"different":[20,79,106,118,129],"relations":[21,48,77],"based":[22,122],"on":[23,78,123],"a":[24],"Cartesian":[25],"product":[26],"relations.":[30,130],"most":[37],"diffidult":[38],"operations":[39],"to":[40,51,96,140],"implement":[41],"efficiently,":[42],"as":[43],"no":[44],"predefined":[45],"links":[46],"between":[47],"are":[49,55,115,120,163],"required":[50],"exist":[52],"(as":[53],"they":[54,125],"with":[56],"network":[57],"and":[58,87,110],"hierarchical":[59],"systems).":[60],"only":[65,147],"algebra":[67],"that":[69,133],"allows":[70],"combining":[72],"related":[74],"tuples":[75,127,135,142,150],"attribute":[80],"schemes.":[81],"Since":[82],"it":[83],"executed":[85],"frequently":[86],"expensive,":[89],"much":[90],"research":[91],"effort":[92],"has":[93],"been":[94],"applied":[95],"optimization":[98],"processing.":[101],"In":[102,153],"this":[103],"paper,":[104],"kinds":[107],"joins":[109],"various":[112],"implementation":[113],"techniques":[114,156],"surveyed.":[116],"These":[117],"methods":[119],"classified":[121],"how":[124],"partition":[126],"Some":[131],"require":[132],"all":[134,141],"be":[138],"compared":[139],"another;":[144],"other":[145],"algorithms":[146],"compare":[148],"some":[149,155],"each.":[152],"addition,":[154],"perform":[157],"an":[158],"explicit":[159],"partitioning,":[160],"whereas":[161],"others":[162],"implicit.":[164]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2015372451","counts_by_year":[{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":5},{"year":2022,"cited_by_count":7},{"year":2021,"cited_by_count":5},{"year":2020,"cited_by_count":8},{"year":2019,"cited_by_count":11},{"year":2018,"cited_by_count":24},{"year":2017,"cited_by_count":22},{"year":2016,"cited_by_count":13},{"year":2015,"cited_by_count":13},{"year":2014,"cited_by_count":5},{"year":2013,"cited_by_count":18},{"year":2012,"cited_by_count":5}],"updated_date":"2025-01-08T02:52:19.944433","created_date":"2016-06-24"}