{"id":"https://openalex.org/W4248600945","doi":"https://doi.org/10.1145/500087.500089","title":"Computing joins of relations","display_name":"Computing joins of relations","publication_year":1975,"publication_date":"1975-01-01","ids":{"openalex":"https://openalex.org/W4248600945","doi":"https://doi.org/10.1145/500087.500089"},"language":"en","primary_location":{"id":"doi:10.1145/500087.500089","doi":"https://doi.org/10.1145/500087.500089","is_oa":false,"landing_page_url":"https://doi.org/10.1145/500087.500089","pdf_url":null,"source":{"id":"https://openalex.org/S4393915683","display_name":"ACM SIGMOD International Conference on Management of Data (SIGMOD)","issn_l":"0730-8078","issn":["0730-8078"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":["norway-1"],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 1975 ACM SIGMOD international conference on Management of data - SIGMOD '75","raw_type":"proceedings-article"},"volume":null,"type":"conference-paper","is_traditional":true,"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/A5089596383","display_name":"Leo R. Gotlieb","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I185261750","display_name":"University of Toronto","ror":"https://ror.org/03dbr7087","country_code":"CA","type":"education","lineage":["https://openalex.org/I185261750"]}],"countries":["CA"],"is_corresponding":true,"raw_author_name":"Leo R. Gotlieb","raw_affiliation_strings":["University of Toronto, Toronto, Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Toronto, Toronto, Canada","institution_ids":["https://openalex.org/I185261750"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5089596383"],"corresponding_institution_ids":["https://openalex.org/I185261750"],"apc_list":null,"apc_paid":null,"fwci":1.1496,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.74117647,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":93},"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"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.9970999956130981,"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.9970999956130981,"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.0012000000569969416,"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/T11106","display_name":"Data Management and Algorithms","score":0.00019999999494757503,"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/relational-join","display_name":"relational join","score":0.6539999842643738},{"id":"https://openalex.org/keywords/join-algorithms","display_name":"join algorithms","score":0.843999981880188},{"id":"https://openalex.org/keywords/relational-database-operations","display_name":"relational database operations","score":0.5130000114440918},{"id":"https://openalex.org/keywords/storage-efficiency","display_name":"storage efficiency","score":0.6050000190734863},{"id":"https://openalex.org/keywords/computational-time","display_name":"computational time","score":0.5040000081062317},{"id":"https://openalex.org/keywords/database-model","display_name":"database model","score":0.4830000102519989}],"concepts":[{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.9428960084915161},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8445534110069275},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.6814744472503662},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5904568433761597},{"id":"https://openalex.org/C95916125","wikidata":"https://www.wikidata.org/wiki/Q840540","display_name":"Relational algebra","level":3,"score":0.5417220592498779},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4390376806259155},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.42289072275161743},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.39696067571640015},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.321918249130249},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0718376636505127},{"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":"doi:10.1145/500087.500089","doi":"https://doi.org/10.1145/500087.500089","is_oa":false,"landing_page_url":"https://doi.org/10.1145/500087.500089","pdf_url":null,"source":{"id":"https://openalex.org/S4393915683","display_name":"ACM SIGMOD International Conference on Management of Data (SIGMOD)","issn_l":"0730-8078","issn":["0730-8078"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":["norway-1"],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 1975 ACM SIGMOD international conference on Management of data - SIGMOD '75","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W4248069028","https://openalex.org/W7099276698","https://openalex.org/W3082810423","https://openalex.org/W2015372451","https://openalex.org/W7095371762","https://openalex.org/W7096417493","https://openalex.org/W2740404111","https://openalex.org/W1986353419","https://openalex.org/W180562236","https://openalex.org/W2077316860"],"abstract_inverted_index":{"Little":[0],"has":[1],"appeared":[2],"on":[3],"the":[4,38],"problems":[5],"of":[6,15],"efficiently":[7,42],"storing,":[8],"accessing,":[9],"and":[10,21,47,54],"manipulating":[11],"relations.":[12],"These":[13],"are":[14,45],"considerable":[16],"interest,":[17],"both":[18],"to":[19,51],"implementors":[20],"those":[22],"seeking":[23],"comparison":[24],"with":[25,49],"other":[26],"database":[27],"models.":[28],"In":[29],"this":[30],"paper":[31],"we":[32],"examine":[33],"how":[34],"one":[35],"relational":[36],"operation,":[37],"join,":[39],"can":[40],"be":[41],"computed.":[43],"Algorithms":[44],"presented,":[46],"evaluated":[48],"respect":[50],"storage":[52],"use":[53],"computing":[55],"time.":[56]},"counts_by_year":[{"year":2019,"cited_by_count":1}],"updated_date":"2026-10-26T11:51:55.731654","created_date":"2022-05-12T00:00:00"}