{"id":"https://openalex.org/W2166955459","doi":"https://doi.org/10.1016/s0306-4379(02)00042-x","title":"Extracting the extended entity-relationship model from a legacy relational database","display_name":"Extracting the extended entity-relationship model from a legacy relational database","publication_year":2002,"publication_date":"2002-12-30","ids":{"openalex":"https://openalex.org/W2166955459","doi":"https://doi.org/10.1016/s0306-4379(02)00042-x","mag":"2166955459"},"language":"en","primary_location":{"id":"doi:10.1016/s0306-4379(02)00042-x","doi":"https://doi.org/10.1016/s0306-4379(02)00042-x","is_oa":false,"landing_page_url":"https://doi.org/10.1016/s0306-4379(02)00042-x","pdf_url":null,"source":{"id":"https://openalex.org/S193006928","display_name":"Information Systems","issn_l":"0306-4379","issn":["0306-4379","1873-6076"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["ccf-b","cwts-core","dongbi-b","jufo-2","norway-2","poland-100","russia-white-list-1","vabb-shw"],"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 Systems","raw_type":"journal-article"},"volume":null,"type":"article","is_traditional":true,"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/A5066265052","display_name":"Reda Alhajj","orcid":"https://orcid.org/0000-0001-6657-9738","observed_orcids":["https://orcid.org/0000-0001-6657-9738"]},"institutions":[{"id":"https://openalex.org/I168635309","display_name":"University of Calgary","ror":"https://ror.org/03yjb2x39","country_code":"CA","type":"education","lineage":["https://openalex.org/I168635309"]}],"countries":["CA"],"is_corresponding":true,"raw_author_name":"Reda Alhajj","raw_affiliation_strings":["Department of Computer Science, Advanced database Systems and Applications Laboratory, University of Calgary, Calgary, Alta., Canada T2N 1N4"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science, Advanced database Systems and Applications Laboratory, University of Calgary, Calgary, Alta., Canada T2N 1N4","institution_ids":["https://openalex.org/I168635309"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5066265052"],"corresponding_institution_ids":["https://openalex.org/I168635309"],"apc_list":{"value":3410,"currency":"USD","value_usd":3410},"apc_paid":null,"fwci":3.8584,"has_fulltext":false,"cited_by_count":84,"citation_normalized_percentile":{"value":0.9377327,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":87,"max":99},"biblio":{"volume":"28","issue":"6","first_page":"597","last_page":"618"},"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.5419999957084656,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.5419999957084656,"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/T10260","display_name":"Software Engineering Research","score":0.39719998836517334,"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/T11450","display_name":"Model-Driven Software Engineering Techniques","score":0.038600001484155655,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/extended-entity-relationship-model","display_name":"extended entity-relationship model","score":0.9449999928474426},{"id":"https://openalex.org/keywords/relational-database-schema","display_name":"relational database schema","score":0.4970000088214874},{"id":"https://openalex.org/keywords/candidate-keys","display_name":"candidate keys","score":0.7749999761581421},{"id":"https://openalex.org/keywords/entity-relationship-diagram","display_name":"entity relationship diagram","score":0.640999972820282},{"id":"https://openalex.org/keywords/many-to-many-relationships","display_name":"many-to-many relationships","score":0.8270000219345093},{"id":"https://openalex.org/keywords/n-ary-relationships","display_name":"n-ary relationships","score":0.953000009059906},{"id":"https://openalex.org/keywords/hypernymy","display_name":"hypernymy","score":0.968999981880188},{"id":"https://openalex.org/keywords/database-maintenance","display_name":"database maintenance","score":0.5410000085830688}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8179738521575928},{"id":"https://openalex.org/C103593891","wikidata":"https://www.wikidata.org/wiki/Q624546","display_name":"Entity\u2013relationship model","level":3,"score":0.6820194721221924},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5982741117477417},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5890204906463623},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.5367283821105957},{"id":"https://openalex.org/C56310702","wikidata":"https://www.wikidata.org/wiki/Q2269281","display_name":"Semi-structured model","level":4,"score":0.49123066663742065},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4888969957828522},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4790664613246918},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.47440195083618164},{"id":"https://openalex.org/C65180967","wikidata":"https://www.wikidata.org/wiki/Q130901","display_name":"Binary relation","level":2,"score":0.4723699688911438},{"id":"https://openalex.org/C132525143","wikidata":"https://www.wikidata.org/wiki/Q141488","display_name":"Graph","level":2,"score":0.4622722566127777},{"id":"https://openalex.org/C56666940","wikidata":"https://www.wikidata.org/wiki/Q788790","display_name":"Documentation","level":2,"score":0.4285370111465454},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.40134817361831665},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.39951372146606445},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.38862618803977966},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.12658289074897766},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1016/s0306-4379(02)00042-x","doi":"https://doi.org/10.1016/s0306-4379(02)00042-x","is_oa":false,"landing_page_url":"https://doi.org/10.1016/s0306-4379(02)00042-x","pdf_url":null,"source":{"id":"https://openalex.org/S193006928","display_name":"Information Systems","issn_l":"0306-4379","issn":["0306-4379","1873-6076"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["ccf-b","cwts-core","dongbi-b","jufo-2","norway-2","poland-100","russia-white-list-1","vabb-shw"],"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 Systems","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":40,"referenced_works":["https://openalex.org/W9091155","https://openalex.org/W1483332259","https://openalex.org/W1488880304","https://openalex.org/W1498996471","https://openalex.org/W1534315740","https://openalex.org/W1542384821","https://openalex.org/W1544920330","https://openalex.org/W1571341547","https://openalex.org/W1582340086","https://openalex.org/W1604045430","https://openalex.org/W1628672398","https://openalex.org/W1781748254","https://openalex.org/W1961272277","https://openalex.org/W1998046157","https://openalex.org/W2000739471","https://openalex.org/W2006267758","https://openalex.org/W2010499454","https://openalex.org/W2012235928","https://openalex.org/W2012325011","https://openalex.org/W2050480346","https://openalex.org/W2056168203","https://openalex.org/W2063707360","https://openalex.org/W2077053297","https://openalex.org/W2094407133","https://openalex.org/W2098932141","https://openalex.org/W2100980956","https://openalex.org/W2108968221","https://openalex.org/W2115977203","https://openalex.org/W2118676972","https://openalex.org/W2127172156","https://openalex.org/W2127972622","https://openalex.org/W2135036904","https://openalex.org/W2140037779","https://openalex.org/W2144192824","https://openalex.org/W2164369680","https://openalex.org/W2255298453","https://openalex.org/W2289787335","https://openalex.org/W2945526390","https://openalex.org/W4245628843","https://openalex.org/W6662986780"],"related_works":["https://openalex.org/W1488880304","https://openalex.org/W2153555633","https://openalex.org/W1498996471","https://openalex.org/W1534315740","https://openalex.org/W2361548450","https://openalex.org/W2327322980","https://openalex.org/W1998046157","https://openalex.org/W2343896406","https://openalex.org/W2161769432","https://openalex.org/W1967291753"],"abstract_inverted_index":null,"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":2},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":4},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":9},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":4},{"year":2012,"cited_by_count":7}],"updated_date":"2026-11-07T11:25:07.637180","created_date":"2016-06-24T00:00:00"}