{"id":"https://openalex.org/W1540926161","doi":null,"title":"An adaptive hash join algorithm for multiuser environments","display_name":"An adaptive hash join algorithm for multiuser environments","alternate_titles":[],"publication_year":1990,"publication_date":"1990-08-13","ids":{"openalex":"https://openalex.org/W1540926161","mag":"1540926161"},"language":"en","primary_location":{"id":"mag:1540926161","doi":null,"is_oa":false,"landing_page_url":"https://dblp.uni-trier.de/db/conf/vldb/vldb90.html#ZellerG90","pdf_url":null,"source":{"id":"https://openalex.org/S4306421142","display_name":"Very Large Data Bases","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Very Large Data Bases","raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W1540926161"],"child_works_count":0,"type":"conference-paper","is_traditional":true,"indexed_in":[],"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/A5111444673","display_name":"H. Zeller","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"H. Zeller","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5106823925","display_name":"Jim Gray","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Jim Gray","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":3.4289,"has_fulltext":false,"cited_by_count":96,"reviewed_by_count":0,"citation_normalized_percentile":{"value":0.90434783,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":86,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"186","last_page":"197"},"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.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/T11269","display_name":"Algorithms and Data Compression","score":0.0003000000142492354,"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":9.999999747378752e-05,"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/hash-join","display_name":"hash join","score":0.9440000057220459},{"id":"https://openalex.org/keywords/equi-join","display_name":"equi-join","score":0.9200000166893005},{"id":"https://openalex.org/keywords/main-memory","display_name":"main memory","score":0.6470000147819519},{"id":"https://openalex.org/keywords/multi-user-environments","display_name":"multi-user environments","score":0.5379999876022339},{"id":"https://openalex.org/keywords/dynamic-memory-allocation","display_name":"dynamic memory allocation","score":0.5799999833106995},{"id":"https://openalex.org/keywords/i-o-controller","display_name":"I/O controller","score":0.7210000157356262},{"id":"https://openalex.org/keywords/join-performance","display_name":"join performance","score":0.5109999775886536}],"concepts":[{"id":"https://openalex.org/C188805328","wikidata":"https://www.wikidata.org/wiki/Q4060691","display_name":"Hash join","level":3,"score":0.8753533363342285},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.8619768619537354},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8533416390419006},{"id":"https://openalex.org/C99138194","wikidata":"https://www.wikidata.org/wiki/Q183427","display_name":"Hash function","level":2,"score":0.6668784022331238},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.5998576283454895},{"id":"https://openalex.org/C1306188","wikidata":"https://www.wikidata.org/wiki/Q4060687","display_name":"Nested loop join","level":2,"score":0.4599764347076416},{"id":"https://openalex.org/C67388219","wikidata":"https://www.wikidata.org/wiki/Q207440","display_name":"Hash table","level":3,"score":0.456196129322052},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.4341789484024048},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.3822740912437439},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.3452725410461426},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.20309332013130188},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"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":1,"locations":[{"id":"mag:1540926161","doi":null,"is_oa":false,"landing_page_url":"https://dblp.uni-trier.de/db/conf/vldb/vldb90.html#ZellerG90","pdf_url":null,"source":{"id":"https://openalex.org/S4306421142","display_name":"Very Large Data Bases","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Very Large Data Bases","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":11,"referenced_works":["https://openalex.org/W14629651","https://openalex.org/W201134449","https://openalex.org/W1484813121","https://openalex.org/W1497748148","https://openalex.org/W1552081212","https://openalex.org/W1970196737","https://openalex.org/W2007030756","https://openalex.org/W2043934800","https://openalex.org/W2051244613","https://openalex.org/W2078528123","https://openalex.org/W2169486917"],"related_works":["https://openalex.org/W7099528677","https://openalex.org/W7098303230","https://openalex.org/W7095932370","https://openalex.org/W2169486917","https://openalex.org/W4391096507","https://openalex.org/W50914958","https://openalex.org/W7097937828","https://openalex.org/W2143933637"],"abstract_inverted_index":{"As":[0],"main":[1,94],"memory":[2],"becomes":[3],"a":[4,27,59,63,80,92,110,115],"cheaper":[5],"resource,":[6],"hash":[7,30,60],"joins":[8],"are":[9],"an":[10],"alternative":[11],"to":[12,36,54,68,87],"the":[13,42,51],"traditional":[14],"methods":[15],"of":[16,44,50,58,83],"performing":[17],"equi-joins:":[18],"nested":[19],"loop":[20],"and":[21,96],"merge":[22],"joins.":[23],"This":[24],"paper":[25],"introduces":[26],"modified,":[28],"adaptive":[29],"join":[31,61,88],"method":[32],"that":[33,65],"is":[34,53],"designed":[35],"work":[37],"with":[38,71,101],"dynamic":[39],"changes":[40],"in":[41,62,91,112],"amount":[43],"available":[45],"memory.":[46],"The":[47,74],"general":[48],"idea":[49],"algorithm":[52,75],"regulate":[55],"resource":[56],"usage":[57],"way":[64],"allows":[66,86],"it":[67],"run":[69],"concurrently":[70],"other":[72],"applications.":[73],"provides":[76],"good":[77],"performance":[78],"for":[79],"broad":[81],"range":[82],"problem":[84],"sizes,":[85],"large":[89],"tables":[90],"small":[93],"memory,":[95],"uses":[97],"advanced":[98],"I/O":[99,103],"controllers":[100],"tracksize":[102],"transfers.":[104],"It":[105],"has":[106],"been":[107],"implemented":[108],"as":[109],"prototype":[111],"Nonstop":[113],"SQL,":[114],"DBMS":[116],"running":[117],"on":[118],"Tandem":[119],"machines.":[120]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W1540926161","counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":2},{"year":2013,"cited_by_count":6},{"year":2012,"cited_by_count":1}],"updated_date":"2026-11-17T12:49:18.490984","created_date":"2016-06-24T00:00:00"}
