{"id":"https://openalex.org/W1963792873","doi":"https://doi.org/10.1016/0020-0255(87)90022-3","title":"A practical approach to transforming extended ER diagrams into the relational model","display_name":"A practical approach to transforming extended ER diagrams into the relational model","publication_year":1987,"publication_date":"1987-07-01","ids":{"openalex":"https://openalex.org/W1963792873","doi":"https://doi.org/10.1016/0020-0255(87)90022-3","mag":"1963792873"},"language":"en","primary_location":{"id":"doi:10.1016/0020-0255(87)90022-3","is_oa":false,"landing_page_url":"https://doi.org/10.1016/0020-0255(87)90022-3","pdf_url":null,"source":{"id":"https://openalex.org/S192650101","display_name":"Information Sciences","issn_l":"0020-0255","issn":["0020-0255","1872-6291"],"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 Sciences","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/A5106446263","display_name":"Dongqing Yang","orcid":null},"institutions":[{"id":"https://openalex.org/I20231570","display_name":"Peking University","ror":"https://ror.org/02v51f717","country_code":"CN","type":"education","lineage":["https://openalex.org/I20231570"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Yang Dongqing","raw_affiliation_strings":["Computer Science and Technology, Peking University, Beijing, The People's Republic of China"],"affiliations":[{"raw_affiliation_string":"Computer Science and Technology, Peking University, Beijing, The People's Republic of China","institution_ids":["https://openalex.org/I20231570"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5000213313","display_name":"Toby J. Teorey","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Toby J. Teorey","raw_affiliation_strings":["Computing Research Laboratory, Electrical Engineering and Computer Science, The University of Michigan, Ann Arbor, Michigan 48109 U.S.A"],"affiliations":[{"raw_affiliation_string":"Computing Research Laboratory, Electrical Engineering and Computer Science, The University of Michigan, Ann Arbor, Michigan 48109 U.S.A","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5020906314","display_name":"James P. Fry","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"James P. Fry","raw_affiliation_strings":["Computer and Information Systems, Graduate School of Business Administration, The University of Michigan, Ann Arbor, Michigan 48109 U.S.A"],"affiliations":[{"raw_affiliation_string":"Computer and Information Systems, Graduate School of Business Administration, The University of Michigan, Ann Arbor, Michigan 48109 U.S.A","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5106446263"],"corresponding_institution_ids":["https://openalex.org/I20231570"],"apc_list":{"value":3330,"currency":"USD","value_usd":3330},"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.13245743,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"42","issue":"2","first_page":"167","last_page":"186"},"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9976999759674072,"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/T11106","display_name":"Data Management and Algorithms","score":0.9957000017166138,"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/normalization","display_name":"Normalization (sociology)","score":0.7390832304954529},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.7093364000320435},{"id":"https://openalex.org/keywords/transformation","display_name":"Transformation (genetics)","score":0.6495547294616699},{"id":"https://openalex.org/keywords/entity\u2013relationship-model","display_name":"Entity\u2013relationship model","score":0.615046501159668},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6079066395759583},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.5716612935066223},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5331684350967407},{"id":"https://openalex.org/keywords/model-transformation","display_name":"Model transformation","score":0.524596631526947},{"id":"https://openalex.org/keywords/dependency","display_name":"Dependency (UML)","score":0.5013833045959473},{"id":"https://openalex.org/keywords/generalization","display_name":"Generalization","score":0.4923642873764038},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3870885372161865},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.34325143694877625},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.2794345021247864},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.2587989568710327}],"concepts":[{"id":"https://openalex.org/C136886441","wikidata":"https://www.wikidata.org/wiki/Q926129","display_name":"Normalization (sociology)","level":2,"score":0.7390832304954529},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.7093364000320435},{"id":"https://openalex.org/C204241405","wikidata":"https://www.wikidata.org/wiki/Q461499","display_name":"Transformation (genetics)","level":3,"score":0.6495547294616699},{"id":"https://openalex.org/C103593891","wikidata":"https://www.wikidata.org/wiki/Q624546","display_name":"Entity\u2013relationship model","level":3,"score":0.615046501159668},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6079066395759583},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.5716612935066223},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5331684350967407},{"id":"https://openalex.org/C2779791154","wikidata":"https://www.wikidata.org/wiki/Q258040","display_name":"Model transformation","level":3,"score":0.524596631526947},{"id":"https://openalex.org/C19768560","wikidata":"https://www.wikidata.org/wiki/Q320727","display_name":"Dependency (UML)","level":2,"score":0.5013833045959473},{"id":"https://openalex.org/C177148314","wikidata":"https://www.wikidata.org/wiki/Q170084","display_name":"Generalization","level":2,"score":0.4923642873764038},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3870885372161865},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.34325143694877625},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.2794345021247864},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.2587989568710327},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C144024400","wikidata":"https://www.wikidata.org/wiki/Q21201","display_name":"Sociology","level":0,"score":0.0},{"id":"https://openalex.org/C19165224","wikidata":"https://www.wikidata.org/wiki/Q23404","display_name":"Anthropology","level":1,"score":0.0},{"id":"https://openalex.org/C2776436953","wikidata":"https://www.wikidata.org/wiki/Q5163215","display_name":"Consistency (knowledge bases)","level":2,"score":0.0},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1016/0020-0255(87)90022-3","is_oa":false,"landing_page_url":"https://doi.org/10.1016/0020-0255(87)90022-3","pdf_url":null,"source":{"id":"https://openalex.org/S192650101","display_name":"Information Sciences","issn_l":"0020-0255","issn":["0020-0255","1872-6291"],"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 Sciences","raw_type":"journal-article"},{"id":"pmh:oai:deepblue.lib.umich.edu:2027.42/26655","is_oa":false,"landing_page_url":"http://hdl.handle.net/2027.42/26655","pdf_url":null,"source":{"id":"https://openalex.org/S4306400393","display_name":"Deep Blue (University of Michigan)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I27837315","host_organization_name":"University of Michigan","host_organization_lineage":["https://openalex.org/I27837315"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.4300000071525574,"id":"https://metadata.un.org/sdg/10","display_name":"Reduced inequalities"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":52,"referenced_works":["https://openalex.org/W8304365","https://openalex.org/W105718829","https://openalex.org/W109080666","https://openalex.org/W118327627","https://openalex.org/W141514111","https://openalex.org/W146964180","https://openalex.org/W172094284","https://openalex.org/W180578187","https://openalex.org/W187620801","https://openalex.org/W243608378","https://openalex.org/W1505165377","https://openalex.org/W1506707603","https://openalex.org/W1518114862","https://openalex.org/W1557293853","https://openalex.org/W1574633204","https://openalex.org/W1579275580","https://openalex.org/W1579617599","https://openalex.org/W1583037893","https://openalex.org/W1587227660","https://openalex.org/W1603987505","https://openalex.org/W2023663289","https://openalex.org/W2035777631","https://openalex.org/W2039601877","https://openalex.org/W2057773300","https://openalex.org/W2088627600","https://openalex.org/W2138635944","https://openalex.org/W2138709157","https://openalex.org/W2144192824","https://openalex.org/W2163944534","https://openalex.org/W2165467455","https://openalex.org/W2173067144","https://openalex.org/W2177126771","https://openalex.org/W2180847728","https://openalex.org/W2185907055","https://openalex.org/W2435152603","https://openalex.org/W2729762226","https://openalex.org/W2921752748","https://openalex.org/W2945526390","https://openalex.org/W6600317650","https://openalex.org/W6604375163","https://openalex.org/W6605819847","https://openalex.org/W6607641123","https://openalex.org/W6609361306","https://openalex.org/W6629020129","https://openalex.org/W6631192993","https://openalex.org/W6631419839","https://openalex.org/W6633175953","https://openalex.org/W6634375542","https://openalex.org/W6635152117","https://openalex.org/W6636133650","https://openalex.org/W6680495390","https://openalex.org/W6740595380"],"related_works":["https://openalex.org/W1510134535","https://openalex.org/W2267077731","https://openalex.org/W2244681254","https://openalex.org/W1489925296","https://openalex.org/W2483382562","https://openalex.org/W3091612633","https://openalex.org/W1577029765","https://openalex.org/W1897774768","https://openalex.org/W1977041410","https://openalex.org/W260106080"],"abstract_inverted_index":null,"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2015,"cited_by_count":1}],"updated_date":"2026-03-20T23:20:44.827607","created_date":"2025-10-10T00:00:00"}