{"id":"https://openalex.org/W1999158264","doi":"https://doi.org/10.1016/0950-5849(92)90122-6","title":"Using an entity model to drive physical database design","display_name":"Using an entity model to drive physical database design","publication_year":1992,"publication_date":"1992-12-01","ids":{"openalex":"https://openalex.org/W1999158264","doi":"https://doi.org/10.1016/0950-5849(92)90122-6","mag":"1999158264"},"language":"en","primary_location":{"id":"doi:10.1016/0950-5849(92)90122-6","is_oa":false,"landing_page_url":"https://doi.org/10.1016/0950-5849(92)90122-6","pdf_url":null,"source":{"id":"https://openalex.org/S205010575","display_name":"Information and Software Technology","issn_l":"0950-5849","issn":["0950-5849","1873-6025"],"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":"Information and Software Technology","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/A5066423042","display_name":"Paul Beynon\u2010Davies","orcid":"https://orcid.org/0000-0003-3229-3234"},"institutions":[{"id":"https://openalex.org/I128993996","display_name":"University of South Wales","ror":"https://ror.org/02mzn7s88","country_code":"GB","type":"education","lineage":["https://openalex.org/I128993996"]}],"countries":["GB"],"is_corresponding":true,"raw_author_name":"P Beynon-Davies","raw_affiliation_strings":["Department of Computer Studies, University of Glamorgan, Pontypridd, Mid-Glamorgan, CF37 1DL, UK","Department of Computer Studies, University of Glamorgan, Pontypridd, Mid Glamorgan, CF37 1DL. UK#TAB#"],"affiliations":[{"raw_affiliation_string":"Department of Computer Studies, University of Glamorgan, Pontypridd, Mid-Glamorgan, CF37 1DL, UK","institution_ids":["https://openalex.org/I128993996"]},{"raw_affiliation_string":"Department of Computer Studies, University of Glamorgan, Pontypridd, Mid Glamorgan, CF37 1DL. UK#TAB#","institution_ids":["https://openalex.org/I128993996"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5066423042"],"corresponding_institution_ids":["https://openalex.org/I128993996"],"apc_list":{"value":3350,"currency":"USD","value_usd":3350},"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.16826554,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"34","issue":"12","first_page":"804","last_page":"812"},"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.9983000159263611,"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.9983000159263611,"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/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9835000038146973,"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/T11106","display_name":"Data Management and Algorithms","score":0.9751999974250793,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.7179177403450012},{"id":"https://openalex.org/keywords/logical-data-model","display_name":"Logical data model","score":0.710806131362915},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6783007383346558},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.6454828977584839},{"id":"https://openalex.org/keywords/conceptual-model","display_name":"Conceptual model","score":0.5758873224258423},{"id":"https://openalex.org/keywords/entity\u2013relationship-model","display_name":"Entity\u2013relationship model","score":0.544318437576294},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.537930428981781},{"id":"https://openalex.org/keywords/database-model","display_name":"Database model","score":0.5245133638381958},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.5156484842300415},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.502246618270874},{"id":"https://openalex.org/keywords/conceptual-design","display_name":"Conceptual design","score":0.4941101372241974},{"id":"https://openalex.org/keywords/design-process","display_name":"Design process","score":0.48718351125717163},{"id":"https://openalex.org/keywords/physical-data-model","display_name":"Physical data model","score":0.4776531457901001},{"id":"https://openalex.org/keywords/physical-design","display_name":"Physical design","score":0.4468756318092346},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.36513763666152954},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.34018760919570923},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.32604697346687317},{"id":"https://openalex.org/keywords/work-in-process","display_name":"Work in process","score":0.29337406158447266},{"id":"https://openalex.org/keywords/human\u2013computer-interaction","display_name":"Human\u2013computer interaction","score":0.23378080129623413},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.17314958572387695},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.15748044848442078},{"id":"https://openalex.org/keywords/database-testing","display_name":"Database testing","score":0.12339699268341064}],"concepts":[{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.7179177403450012},{"id":"https://openalex.org/C203702819","wikidata":"https://www.wikidata.org/wiki/Q17146953","display_name":"Logical data model","level":3,"score":0.710806131362915},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6783007383346558},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6454828977584839},{"id":"https://openalex.org/C13606891","wikidata":"https://www.wikidata.org/wiki/Q2623243","display_name":"Conceptual model","level":2,"score":0.5758873224258423},{"id":"https://openalex.org/C103593891","wikidata":"https://www.wikidata.org/wiki/Q624546","display_name":"Entity\u2013relationship model","level":3,"score":0.544318437576294},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.537930428981781},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.5245133638381958},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.5156484842300415},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.502246618270874},{"id":"https://openalex.org/C120208923","wikidata":"https://www.wikidata.org/wiki/Q5158435","display_name":"Conceptual design","level":2,"score":0.4941101372241974},{"id":"https://openalex.org/C48262172","wikidata":"https://www.wikidata.org/wiki/Q16908765","display_name":"Design process","level":3,"score":0.48718351125717163},{"id":"https://openalex.org/C187959359","wikidata":"https://www.wikidata.org/wiki/Q17113749","display_name":"Physical data model","level":5,"score":0.4776531457901001},{"id":"https://openalex.org/C188817802","wikidata":"https://www.wikidata.org/wiki/Q13426855","display_name":"Physical design","level":3,"score":0.4468756318092346},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.36513763666152954},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.34018760919570923},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.32604697346687317},{"id":"https://openalex.org/C174998907","wikidata":"https://www.wikidata.org/wiki/Q357662","display_name":"Work in process","level":2,"score":0.29337406158447266},{"id":"https://openalex.org/C107457646","wikidata":"https://www.wikidata.org/wiki/Q207434","display_name":"Human\u2013computer interaction","level":1,"score":0.23378080129623413},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.17314958572387695},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.15748044848442078},{"id":"https://openalex.org/C78161392","wikidata":"https://www.wikidata.org/wiki/Q5227414","display_name":"Database testing","level":4,"score":0.12339699268341064},{"id":"https://openalex.org/C190560348","wikidata":"https://www.wikidata.org/wiki/Q3245116","display_name":"Circuit design","level":2,"score":0.0},{"id":"https://openalex.org/C149635348","wikidata":"https://www.wikidata.org/wiki/Q193040","display_name":"Embedded system","level":1,"score":0.0},{"id":"https://openalex.org/C21547014","wikidata":"https://www.wikidata.org/wiki/Q1423657","display_name":"Operations management","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1016/0950-5849(92)90122-6","is_oa":false,"landing_page_url":"https://doi.org/10.1016/0950-5849(92)90122-6","pdf_url":null,"source":{"id":"https://openalex.org/S205010575","display_name":"Information and Software Technology","issn_l":"0950-5849","issn":["0950-5849","1873-6025"],"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":"Information and Software Technology","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":7,"referenced_works":["https://openalex.org/W613222194","https://openalex.org/W618215332","https://openalex.org/W1562400825","https://openalex.org/W1581128883","https://openalex.org/W2008081838","https://openalex.org/W2103028615","https://openalex.org/W2921752748"],"related_works":["https://openalex.org/W4297044271","https://openalex.org/W2356642811","https://openalex.org/W2591891926","https://openalex.org/W1016652228","https://openalex.org/W3023537477","https://openalex.org/W2362965289","https://openalex.org/W2986951121","https://openalex.org/W939747119","https://openalex.org/W2113546482","https://openalex.org/W2064201254"],"abstract_inverted_index":null,"counts_by_year":[{"year":2014,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}