{"id":"https://openalex.org/W2077777521","doi":"https://doi.org/10.1016/0169-023x(88)90014-6","title":"A knowledge-based approach to relational database design","display_name":"A knowledge-based approach to relational database design","publication_year":1988,"publication_date":"1988-11-01","ids":{"openalex":"https://openalex.org/W2077777521","doi":"https://doi.org/10.1016/0169-023x(88)90014-6","mag":"2077777521"},"language":"en","primary_location":{"id":"doi:10.1016/0169-023x(88)90014-6","is_oa":false,"landing_page_url":"https://doi.org/10.1016/0169-023x(88)90014-6","pdf_url":null,"source":{"id":"https://openalex.org/S136993123","display_name":"Data & Knowledge Engineering","issn_l":"0169-023X","issn":["0169-023X","1872-6933"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Data & Knowledge Engineering","raw_type":"journal-article"},"type":"article","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/A5044907002","display_name":"D. Obretenov","orcid":null},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"D. Obretenov","raw_affiliation_strings":["Interprograma, P.O. Box 795, 1000, Sofia, Bulgaria","Interprograma, Sofia, Bulgaria#TAB#"],"affiliations":[{"raw_affiliation_string":"Interprograma, P.O. Box 795, 1000, Sofia, Bulgaria","institution_ids":[]},{"raw_affiliation_string":"Interprograma, Sofia, Bulgaria#TAB#","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5048367125","display_name":"Zh. Angelov","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Zh. Angelov","raw_affiliation_strings":["Interprograma, P.O. Box 795, 1000, Sofia, Bulgaria","Interprograma, Sofia, Bulgaria#TAB#"],"affiliations":[{"raw_affiliation_string":"Interprograma, P.O. Box 795, 1000, Sofia, Bulgaria","institution_ids":[]},{"raw_affiliation_string":"Interprograma, Sofia, Bulgaria#TAB#","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5068080401","display_name":"J. Mihaylov","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"J. Mihaylov","raw_affiliation_strings":["Interprograma, P.O. Box 795, 1000, Sofia, Bulgaria","Interprograma, Sofia, Bulgaria#TAB#"],"affiliations":[{"raw_affiliation_string":"Interprograma, P.O. Box 795, 1000, Sofia, Bulgaria","institution_ids":[]},{"raw_affiliation_string":"Interprograma, Sofia, Bulgaria#TAB#","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5033987903","display_name":"P. Dishlieva","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"P. Dishlieva","raw_affiliation_strings":["Interprograma, P.O. Box 795, 1000, Sofia, Bulgaria","Interprograma, Sofia, Bulgaria#TAB#"],"affiliations":[{"raw_affiliation_string":"Interprograma, P.O. Box 795, 1000, Sofia, Bulgaria","institution_ids":[]},{"raw_affiliation_string":"Interprograma, Sofia, Bulgaria#TAB#","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5062034702","display_name":"\u041d \u041d \u041a\u0438\u0440\u043e\u0432\u0430","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"N. Kirova","raw_affiliation_strings":["Interprograma, P.O. Box 795, 1000, Sofia, Bulgaria","Interprograma, Sofia, Bulgaria#TAB#"],"affiliations":[{"raw_affiliation_string":"Interprograma, P.O. Box 795, 1000, Sofia, Bulgaria","institution_ids":[]},{"raw_affiliation_string":"Interprograma, Sofia, Bulgaria#TAB#","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5044907002"],"corresponding_institution_ids":[],"apc_list":{"value":2590,"currency":"USD","value_usd":2590},"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":6,"citation_normalized_percentile":{"value":0.24172794,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"3","issue":"3","first_page":"173","last_page":"180"},"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.9997000098228455,"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.9997000098228455,"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.9962000250816345,"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"}},{"id":"https://openalex.org/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9954000115394592,"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/computer-science","display_name":"Computer science","score":0.7549253702163696},{"id":"https://openalex.org/keywords/conceptual-schema","display_name":"Conceptual schema","score":0.7397927045822144},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.7100347280502319},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.7004493474960327},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.6298879981040955},{"id":"https://openalex.org/keywords/entity\u2013relationship-model","display_name":"Entity\u2013relationship model","score":0.5733604431152344},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.5371385812759399},{"id":"https://openalex.org/keywords/database-model","display_name":"Database model","score":0.5250344276428223},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.45289602875709534},{"id":"https://openalex.org/keywords/semi-structured-model","display_name":"Semi-structured model","score":0.4358539283275604},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3861563205718994},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.3343767523765564},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.27261799573898315}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7549253702163696},{"id":"https://openalex.org/C29275276","wikidata":"https://www.wikidata.org/wiki/Q2268965","display_name":"Conceptual schema","level":3,"score":0.7397927045822144},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.7100347280502319},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.7004493474960327},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6298879981040955},{"id":"https://openalex.org/C103593891","wikidata":"https://www.wikidata.org/wiki/Q624546","display_name":"Entity\u2013relationship model","level":3,"score":0.5733604431152344},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5371385812759399},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.5250344276428223},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.45289602875709534},{"id":"https://openalex.org/C56310702","wikidata":"https://www.wikidata.org/wiki/Q2269281","display_name":"Semi-structured model","level":4,"score":0.4358539283275604},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3861563205718994},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.3343767523765564},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.27261799573898315},{"id":"https://openalex.org/C165611974","wikidata":"https://www.wikidata.org/wiki/Q5531015","display_name":"Gender schema theory","level":2,"score":0.0},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.0},{"id":"https://openalex.org/C138496976","wikidata":"https://www.wikidata.org/wiki/Q175002","display_name":"Developmental psychology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1016/0169-023x(88)90014-6","is_oa":false,"landing_page_url":"https://doi.org/10.1016/0169-023x(88)90014-6","pdf_url":null,"source":{"id":"https://openalex.org/S136993123","display_name":"Data & Knowledge Engineering","issn_l":"0169-023X","issn":["0169-023X","1872-6933"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Data & Knowledge Engineering","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":18,"referenced_works":["https://openalex.org/W20172365","https://openalex.org/W1480536453","https://openalex.org/W2023663289","https://openalex.org/W2027750453","https://openalex.org/W2028052727","https://openalex.org/W2032068293","https://openalex.org/W2036758891","https://openalex.org/W2037817502","https://openalex.org/W2039601877","https://openalex.org/W2098733151","https://openalex.org/W2130474477","https://openalex.org/W2171658883","https://openalex.org/W2988215627","https://openalex.org/W6600828047","https://openalex.org/W6607966110","https://openalex.org/W6628858255","https://openalex.org/W6634550193","https://openalex.org/W6675249881"],"related_works":["https://openalex.org/W2007556552","https://openalex.org/W73223004","https://openalex.org/W1489925296","https://openalex.org/W4248533530","https://openalex.org/W2460926837","https://openalex.org/W2007986108","https://openalex.org/W25771753","https://openalex.org/W2091588998","https://openalex.org/W2483382562","https://openalex.org/W2083616288"],"abstract_inverted_index":null,"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}