{"id":"https://openalex.org/W1492719567","doi":"https://doi.org/10.1007/3-540-54029-6_175","title":"On designing relational database schemes for efficient query processing","display_name":"On designing relational database schemes for efficient query processing","publication_year":1991,"publication_date":"1991-01-01","ids":{"openalex":"https://openalex.org/W1492719567","doi":"https://doi.org/10.1007/3-540-54029-6_175","mag":"1492719567"},"language":"en","primary_location":{"id":"doi:10.1007/3-540-54029-6_175","is_oa":false,"landing_page_url":"https://doi.org/10.1007/3-540-54029-6_175","pdf_url":null,"source":{"id":"https://openalex.org/S106296714","display_name":"Lecture notes in computer science","issn_l":"0302-9743","issn":["0302-9743","1611-3349"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Lecture Notes in Computer Science","raw_type":"book-chapter"},"type":"book-chapter","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/A5102114247","display_name":"Michio Nakanishi","orcid":null},"institutions":[{"id":"https://openalex.org/I98285908","display_name":"The University of Osaka","ror":"https://ror.org/035t8zc32","country_code":"JP","type":"education","lineage":["https://openalex.org/I98285908"]}],"countries":["JP"],"is_corresponding":false,"raw_author_name":"Michio Nakanishi","raw_affiliation_strings":["Faculty of Engineering Science, Osaka University, 560, Toyonaka, Osaka, Japan","Osaka University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Engineering Science, Osaka University, 560, Toyonaka, Osaka, Japan","institution_ids":["https://openalex.org/I98285908"]},{"raw_affiliation_string":"Osaka University","institution_ids":["https://openalex.org/I98285908"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5040467863","display_name":"Yoshiki Katsuyama","orcid":null},"institutions":[{"id":"https://openalex.org/I171494771","display_name":"Shiga University","ror":"https://ror.org/01vvhy971","country_code":"JP","type":"education","lineage":["https://openalex.org/I171494771"]}],"countries":["JP"],"is_corresponding":false,"raw_author_name":"Yoshiki Katsuyama","raw_affiliation_strings":["Faculty of Economics, Shiga University, 522, Hikone, Shiga, Japan","Shiga University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Economics, Shiga University, 522, Hikone, Shiga, Japan","institution_ids":["https://openalex.org/I171494771"]},{"raw_affiliation_string":"Shiga University","institution_ids":["https://openalex.org/I171494771"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5113923123","display_name":"Minoru Ito","orcid":null},"institutions":[{"id":"https://openalex.org/I98285908","display_name":"The University of Osaka","ror":"https://ror.org/035t8zc32","country_code":"JP","type":"education","lineage":["https://openalex.org/I98285908"]}],"countries":["JP"],"is_corresponding":false,"raw_author_name":"Minoru Ito","raw_affiliation_strings":["Faculty of Engineering Science, Osaka University, 560, Toyonaka, Osaka, Japan","Osaka University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Engineering Science, Osaka University, 560, Toyonaka, Osaka, Japan","institution_ids":["https://openalex.org/I98285908"]},{"raw_affiliation_string":"Osaka University","institution_ids":["https://openalex.org/I98285908"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5102947671","display_name":"Akihiro Hashimoto","orcid":"https://orcid.org/0000-0002-8409-1688"},"institutions":[{"id":"https://openalex.org/I98285908","display_name":"The University of Osaka","ror":"https://ror.org/035t8zc32","country_code":"JP","type":"education","lineage":["https://openalex.org/I98285908"]}],"countries":["JP"],"is_corresponding":false,"raw_author_name":"Akihiro Hashimoto","raw_affiliation_strings":["Faculty of Engineering Science, Osaka University, 560, Toyonaka, Osaka, Japan","Osaka University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Engineering Science, Osaka University, 560, Toyonaka, Osaka, Japan","institution_ids":["https://openalex.org/I98285908"]},{"raw_affiliation_string":"Osaka University","institution_ids":["https://openalex.org/I98285908"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":{"value":5000,"currency":"EUR","value_usd":5392},"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.1694463,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"264","last_page":"275"},"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.9983999729156494,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9983999729156494,"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/T11106","display_name":"Data Management and Algorithms","score":0.9973999857902527,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9869999885559082,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8234727382659912},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.7845349907875061},{"id":"https://openalex.org/keywords/scheme","display_name":"Scheme (mathematics)","score":0.6841927170753479},{"id":"https://openalex.org/keywords/merge","display_name":"Merge (version control)","score":0.6467496156692505},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.6438510417938232},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6074009537696838},{"id":"https://openalex.org/keywords/relation","display_name":"Relation (database)","score":0.5845486521720886},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.5650753974914551},{"id":"https://openalex.org/keywords/functional-dependency","display_name":"Functional dependency","score":0.5459203124046326},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.521561861038208},{"id":"https://openalex.org/keywords/database-theory","display_name":"Database theory","score":0.5046068429946899},{"id":"https://openalex.org/keywords/relational-algebra","display_name":"Relational algebra","score":0.47646641731262207},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.47190314531326294},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.45394283533096313},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3813754916191101},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.33662641048431396},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3013564348220825},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.12932398915290833},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.09255325794219971}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8234727382659912},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.7845349907875061},{"id":"https://openalex.org/C77618280","wikidata":"https://www.wikidata.org/wiki/Q1155772","display_name":"Scheme (mathematics)","level":2,"score":0.6841927170753479},{"id":"https://openalex.org/C197129107","wikidata":"https://www.wikidata.org/wiki/Q1921621","display_name":"Merge (version control)","level":2,"score":0.6467496156692505},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6438510417938232},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6074009537696838},{"id":"https://openalex.org/C25343380","wikidata":"https://www.wikidata.org/wiki/Q277521","display_name":"Relation (database)","level":2,"score":0.5845486521720886},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.5650753974914551},{"id":"https://openalex.org/C26320393","wikidata":"https://www.wikidata.org/wiki/Q597053","display_name":"Functional dependency","level":3,"score":0.5459203124046326},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.521561861038208},{"id":"https://openalex.org/C12439846","wikidata":"https://www.wikidata.org/wiki/Q4809258","display_name":"Database theory","level":3,"score":0.5046068429946899},{"id":"https://openalex.org/C95916125","wikidata":"https://www.wikidata.org/wiki/Q840540","display_name":"Relational algebra","level":3,"score":0.47646641731262207},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.47190314531326294},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.45394283533096313},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3813754916191101},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.33662641048431396},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3013564348220825},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.12932398915290833},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.09255325794219971},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/3-540-54029-6_175","is_oa":false,"landing_page_url":"https://doi.org/10.1007/3-540-54029-6_175","pdf_url":null,"source":{"id":"https://openalex.org/S106296714","display_name":"Lecture notes in computer science","issn_l":"0302-9743","issn":["0302-9743","1611-3349"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Lecture Notes in Computer Science","raw_type":"book-chapter"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":3,"referenced_works":["https://openalex.org/W1583037893","https://openalex.org/W2115822498","https://openalex.org/W2138709157"],"related_works":["https://openalex.org/W2049150522","https://openalex.org/W2476511644","https://openalex.org/W3022423983","https://openalex.org/W1601072612","https://openalex.org/W2085161971","https://openalex.org/W2397160827","https://openalex.org/W2044875608","https://openalex.org/W118670021","https://openalex.org/W2155293462","https://openalex.org/W2001595204"],"abstract_inverted_index":null,"counts_by_year":[],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}