{"id":"https://openalex.org/W1601072612","doi":"https://doi.org/10.1007/3-540-11214-6_8","title":"Problems of relational database design","display_name":"Problems of relational database design","publication_year":1982,"publication_date":"1982-01-01","ids":{"openalex":"https://openalex.org/W1601072612","doi":"https://doi.org/10.1007/3-540-11214-6_8","mag":"1601072612"},"language":"en","primary_location":{"id":"doi:10.1007/3-540-11214-6_8","is_oa":false,"landing_page_url":"https://doi.org/10.1007/3-540-11214-6_8","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/A5103702858","display_name":"Yahiko Kambayashi","orcid":null},"institutions":[{"id":"https://openalex.org/I22299242","display_name":"Kyoto University","ror":"https://ror.org/02kpeqv85","country_code":"JP","type":"education","lineage":["https://openalex.org/I22299242"]},{"id":"https://openalex.org/I4210129581","display_name":"Kyoto University of Education","ror":"https://ror.org/03zhhr656","country_code":"JP","type":"education","lineage":["https://openalex.org/I4210129581"]}],"countries":["JP"],"is_corresponding":true,"raw_author_name":"Yahiko Kambayashi","raw_affiliation_strings":["Department of Information Science, Kyoto University, 606, Sakyo, Kyoto, Japan","Kyoto univ"],"affiliations":[{"raw_affiliation_string":"Department of Information Science, Kyoto University, 606, Sakyo, Kyoto, Japan","institution_ids":["https://openalex.org/I22299242"]},{"raw_affiliation_string":"Kyoto univ","institution_ids":["https://openalex.org/I22299242","https://openalex.org/I4210129581"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101943741","display_name":"Katsumi Tanaka","orcid":"https://orcid.org/0000-0003-1731-931X"},"institutions":[{"id":"https://openalex.org/I65837984","display_name":"Kobe University","ror":"https://ror.org/03tgsfw79","country_code":"JP","type":"education","lineage":["https://openalex.org/I65837984"]}],"countries":["JP"],"is_corresponding":false,"raw_author_name":"Katsumi Tanaka","raw_affiliation_strings":["College of Liberal Arts, Kobe University, 657, Nada, Kobe, Japan","Kobe University"],"affiliations":[{"raw_affiliation_string":"College of Liberal Arts, Kobe University, 657, Nada, Kobe, Japan","institution_ids":["https://openalex.org/I65837984"]},{"raw_affiliation_string":"Kobe University","institution_ids":["https://openalex.org/I65837984"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5054859202","display_name":"Shuzo Yajima","orcid":null},"institutions":[{"id":"https://openalex.org/I22299242","display_name":"Kyoto University","ror":"https://ror.org/02kpeqv85","country_code":"JP","type":"education","lineage":["https://openalex.org/I22299242"]},{"id":"https://openalex.org/I4210129581","display_name":"Kyoto University of Education","ror":"https://ror.org/03zhhr656","country_code":"JP","type":"education","lineage":["https://openalex.org/I4210129581"]}],"countries":["JP"],"is_corresponding":false,"raw_author_name":"Shuzo Yajima","raw_affiliation_strings":["Department of Information Science, Kyoto University, 606, Sakyo, Kyoto, Japan","Kyoto univ"],"affiliations":[{"raw_affiliation_string":"Department of Information Science, Kyoto University, 606, Sakyo, Kyoto, Japan","institution_ids":["https://openalex.org/I22299242"]},{"raw_affiliation_string":"Kyoto univ","institution_ids":["https://openalex.org/I22299242","https://openalex.org/I4210129581"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5103702858"],"corresponding_institution_ids":["https://openalex.org/I22299242","https://openalex.org/I4210129581"],"apc_list":{"value":5000,"currency":"EUR","value_usd":5392},"apc_paid":null,"fwci":1.627,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.83374083,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"172","last_page":"218"},"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.9998000264167786,"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.9998000264167786,"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.9988999962806702,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9962999820709229,"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/functional-dependency","display_name":"Functional dependency","score":0.805757462978363},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7713207602500916},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.679561972618103},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.5324080586433411},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.5259276032447815},{"id":"https://openalex.org/keywords/relation","display_name":"Relation (database)","score":0.5227758288383484},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.48429957032203674},{"id":"https://openalex.org/keywords/database-theory","display_name":"Database theory","score":0.47809168696403503},{"id":"https://openalex.org/keywords/relational-calculus","display_name":"Relational calculus","score":0.4305681884288788},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.42552247643470764},{"id":"https://openalex.org/keywords/data-integrity","display_name":"Data integrity","score":0.4219288229942322},{"id":"https://openalex.org/keywords/scheme","display_name":"Scheme (mathematics)","score":0.4124802350997925},{"id":"https://openalex.org/keywords/property","display_name":"Property (philosophy)","score":0.4107057452201843},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.29158294200897217},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.19276157021522522},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.18612873554229736}],"concepts":[{"id":"https://openalex.org/C26320393","wikidata":"https://www.wikidata.org/wiki/Q597053","display_name":"Functional dependency","level":3,"score":0.805757462978363},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7713207602500916},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.679561972618103},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.5324080586433411},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.5259276032447815},{"id":"https://openalex.org/C25343380","wikidata":"https://www.wikidata.org/wiki/Q277521","display_name":"Relation (database)","level":2,"score":0.5227758288383484},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.48429957032203674},{"id":"https://openalex.org/C12439846","wikidata":"https://www.wikidata.org/wiki/Q4809258","display_name":"Database theory","level":3,"score":0.47809168696403503},{"id":"https://openalex.org/C99436015","wikidata":"https://www.wikidata.org/wiki/Q1722436","display_name":"Relational calculus","level":4,"score":0.4305681884288788},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.42552247643470764},{"id":"https://openalex.org/C33762810","wikidata":"https://www.wikidata.org/wiki/Q461671","display_name":"Data integrity","level":2,"score":0.4219288229942322},{"id":"https://openalex.org/C77618280","wikidata":"https://www.wikidata.org/wiki/Q1155772","display_name":"Scheme (mathematics)","level":2,"score":0.4124802350997925},{"id":"https://openalex.org/C189950617","wikidata":"https://www.wikidata.org/wiki/Q937228","display_name":"Property (philosophy)","level":2,"score":0.4107057452201843},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.29158294200897217},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.19276157021522522},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.18612873554229736},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"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-11214-6_8","is_oa":false,"landing_page_url":"https://doi.org/10.1007/3-540-11214-6_8","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":67,"referenced_works":["https://openalex.org/W43035074","https://openalex.org/W52829598","https://openalex.org/W59130053","https://openalex.org/W77593117","https://openalex.org/W82574028","https://openalex.org/W162406708","https://openalex.org/W182312985","https://openalex.org/W196062972","https://openalex.org/W1495302482","https://openalex.org/W1505165377","https://openalex.org/W1545822194","https://openalex.org/W1547830959","https://openalex.org/W1566656512","https://openalex.org/W1590469553","https://openalex.org/W1971475250","https://openalex.org/W1978775628","https://openalex.org/W1981061652","https://openalex.org/W1981597405","https://openalex.org/W1992305137","https://openalex.org/W1997739709","https://openalex.org/W1998512182","https://openalex.org/W1999133515","https://openalex.org/W2000773957","https://openalex.org/W2007964756","https://openalex.org/W2010272308","https://openalex.org/W2011368623","https://openalex.org/W2015611106","https://openalex.org/W2023663289","https://openalex.org/W2024200923","https://openalex.org/W2032386524","https://openalex.org/W2032660825","https://openalex.org/W2039445786","https://openalex.org/W2071678949","https://openalex.org/W2074023317","https://openalex.org/W2083752106","https://openalex.org/W2089210350","https://openalex.org/W2091581556","https://openalex.org/W2092792739","https://openalex.org/W2099054631","https://openalex.org/W2103717773","https://openalex.org/W2109669378","https://openalex.org/W2110810394","https://openalex.org/W2111869173","https://openalex.org/W2125223317","https://openalex.org/W2131327062","https://openalex.org/W2132490332","https://openalex.org/W2135105491","https://openalex.org/W2138709157","https://openalex.org/W2139238107","https://openalex.org/W2162068127","https://openalex.org/W2162715748","https://openalex.org/W2165467455","https://openalex.org/W2232207765","https://openalex.org/W2293278495","https://openalex.org/W3147536033","https://openalex.org/W6600364518","https://openalex.org/W6603341373","https://openalex.org/W6607717458","https://openalex.org/W6646581684","https://openalex.org/W6650072120","https://openalex.org/W6658436191","https://openalex.org/W6680456638","https://openalex.org/W6684239258","https://openalex.org/W6684937125","https://openalex.org/W6689392195","https://openalex.org/W6692753582","https://openalex.org/W7036610960"],"related_works":["https://openalex.org/W2049150522","https://openalex.org/W2490753959","https://openalex.org/W2126493028","https://openalex.org/W1579443643","https://openalex.org/W2397160827","https://openalex.org/W1573614767","https://openalex.org/W2155293462","https://openalex.org/W1504218574","https://openalex.org/W2035327096","https://openalex.org/W3037882457"],"abstract_inverted_index":null,"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}