{"id":"https://openalex.org/W1967236789","doi":"https://doi.org/10.1016/s0950-5849(00)00132-4","title":"Enhanced ER to relational mapping and interrelational normalization","display_name":"Enhanced ER to relational mapping and interrelational normalization","publication_year":2000,"publication_date":"2000-12-01","ids":{"openalex":"https://openalex.org/W1967236789","doi":"https://doi.org/10.1016/s0950-5849(00)00132-4","mag":"1967236789"},"language":"en","primary_location":{"id":"doi:10.1016/s0950-5849(00)00132-4","is_oa":false,"landing_page_url":"https://doi.org/10.1016/s0950-5849(00)00132-4","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/A5087327151","display_name":"Manuel Kolp","orcid":"https://orcid.org/0000-0002-4987-672X"},"institutions":[{"id":"https://openalex.org/I185261750","display_name":"University of Toronto","ror":"https://ror.org/03dbr7087","country_code":"CA","type":"education","lineage":["https://openalex.org/I185261750"]}],"countries":["CA"],"is_corresponding":true,"raw_author_name":"M Kolp","raw_affiliation_strings":["University of Toronto, Department of Computer Science, 10 King's College Road, Toronto, Ont., Canada M5S3G4"],"affiliations":[{"raw_affiliation_string":"University of Toronto, Department of Computer Science, 10 King's College Road, Toronto, Ont., Canada M5S3G4","institution_ids":["https://openalex.org/I185261750"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5050401502","display_name":"Esteban Zim\u00e1nyi","orcid":"https://orcid.org/0000-0003-1843-5099"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"E Zim\u00e1nyi","raw_affiliation_strings":["University of Brussels, Department of Informatics, Faculty of Engineering, 50 Av. F.D. Roosevelt, CP 165-15, 1050 Brussels, Belgium"],"affiliations":[{"raw_affiliation_string":"University of Brussels, Department of Informatics, Faculty of Engineering, 50 Av. F.D. Roosevelt, CP 165-15, 1050 Brussels, Belgium","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5087327151"],"corresponding_institution_ids":["https://openalex.org/I185261750"],"apc_list":{"value":3350,"currency":"USD","value_usd":3350},"apc_paid":null,"fwci":0.4342,"has_fulltext":false,"cited_by_count":14,"citation_normalized_percentile":{"value":0.72478673,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":"42","issue":"15","first_page":"1057","last_page":"1073"},"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.9994000196456909,"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.9994000196456909,"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.998199999332428,"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/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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.652152955532074},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.6133590936660767},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.5891227722167969},{"id":"https://openalex.org/keywords/normalization","display_name":"Normalization (sociology)","score":0.5727677941322327},{"id":"https://openalex.org/keywords/prolog","display_name":"Prolog","score":0.5211241841316223},{"id":"https://openalex.org/keywords/entity\u2013relationship-model","display_name":"Entity\u2013relationship model","score":0.49828195571899414},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.49349892139434814},{"id":"https://openalex.org/keywords/schema-migration","display_name":"Schema migration","score":0.4691803753376007},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.45472776889801025},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.4408460557460785},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.40974241495132446},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3649921715259552},{"id":"https://openalex.org/keywords/semi-structured-model","display_name":"Semi-structured model","score":0.35729068517684937},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.2886108160018921},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.27948999404907227},{"id":"https://openalex.org/keywords/database-model","display_name":"Database model","score":0.20794352889060974}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.652152955532074},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6133590936660767},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5891227722167969},{"id":"https://openalex.org/C136886441","wikidata":"https://www.wikidata.org/wiki/Q926129","display_name":"Normalization (sociology)","level":2,"score":0.5727677941322327},{"id":"https://openalex.org/C81721847","wikidata":"https://www.wikidata.org/wiki/Q163468","display_name":"Prolog","level":2,"score":0.5211241841316223},{"id":"https://openalex.org/C103593891","wikidata":"https://www.wikidata.org/wiki/Q624546","display_name":"Entity\u2013relationship model","level":3,"score":0.49828195571899414},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.49349892139434814},{"id":"https://openalex.org/C153440673","wikidata":"https://www.wikidata.org/wiki/Q7431119","display_name":"Schema migration","level":5,"score":0.4691803753376007},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.45472776889801025},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.4408460557460785},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.40974241495132446},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3649921715259552},{"id":"https://openalex.org/C56310702","wikidata":"https://www.wikidata.org/wiki/Q2269281","display_name":"Semi-structured model","level":4,"score":0.35729068517684937},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2886108160018921},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.27948999404907227},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.20794352889060974},{"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}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1016/s0950-5849(00)00132-4","is_oa":false,"landing_page_url":"https://doi.org/10.1016/s0950-5849(00)00132-4","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"},{"id":"pmh:oai:dial.uclouvain.be:boreal:115515","is_oa":false,"landing_page_url":"http://hdl.handle.net/2078.1/115515","pdf_url":null,"source":{"id":"https://openalex.org/S4306400166","display_name":"Digital Access to Libraries","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I2800384882","host_organization_name":"Harris County Public Library","host_organization_lineage":["https://openalex.org/I2800384882"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Information and Software Technology, Vol. 42, no.15, p. 1057-1073 (2000)","raw_type":"info:eu-repo/semantics/article"},{"id":"pmh:oai:dipot.ulb.ac.be:2013/70160","is_oa":false,"landing_page_url":"http://hdl.handle.net/2013/ULB-DIPOT:oai:dipot.ulb.ac.be:2013/70160","pdf_url":null,"source":{"id":"https://openalex.org/S4306401063","display_name":"D\u00e9p\u00f4t institutionnel de l'Universit\u00e9 libre de Bruxelles (Universit\u00e9 Libre de Bruxelles)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I132053463","host_organization_name":"Universit\u00e9 Libre de Bruxelles","host_organization_lineage":["https://openalex.org/I132053463"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Information and software technology, 42 (15","raw_type":"info:ulb-repo/semantics/openurl/article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.7599999904632568,"display_name":"Reduced inequalities","id":"https://metadata.un.org/sdg/10"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":51,"referenced_works":["https://openalex.org/W43035074","https://openalex.org/W601633470","https://openalex.org/W760745830","https://openalex.org/W1487943449","https://openalex.org/W1499704384","https://openalex.org/W1511714305","https://openalex.org/W1524500851","https://openalex.org/W1537432317","https://openalex.org/W1540492331","https://openalex.org/W1572116564","https://openalex.org/W1577431212","https://openalex.org/W1586338668","https://openalex.org/W1614618803","https://openalex.org/W1640669134","https://openalex.org/W1714319973","https://openalex.org/W1747043991","https://openalex.org/W1958555827","https://openalex.org/W1963118906","https://openalex.org/W1963506920","https://openalex.org/W1967236789","https://openalex.org/W1967291753","https://openalex.org/W1977357195","https://openalex.org/W1994410342","https://openalex.org/W2001560228","https://openalex.org/W2023663289","https://openalex.org/W2030551444","https://openalex.org/W2031300469","https://openalex.org/W2049784991","https://openalex.org/W2050480346","https://openalex.org/W2070291209","https://openalex.org/W2098733151","https://openalex.org/W2099293367","https://openalex.org/W2123858323","https://openalex.org/W2140037779","https://openalex.org/W2151165380","https://openalex.org/W2159765281","https://openalex.org/W2232207765","https://openalex.org/W2747076629","https://openalex.org/W2751199251","https://openalex.org/W2788164529","https://openalex.org/W2986348978","https://openalex.org/W3021107827","https://openalex.org/W4244477654","https://openalex.org/W6630120888","https://openalex.org/W6636947980","https://openalex.org/W6640983107","https://openalex.org/W6641196495","https://openalex.org/W6668268138","https://openalex.org/W6675249881","https://openalex.org/W6689392195","https://openalex.org/W6811004269"],"related_works":["https://openalex.org/W2007556552","https://openalex.org/W2091588998","https://openalex.org/W2585596101","https://openalex.org/W1703220383","https://openalex.org/W290184810","https://openalex.org/W2138816667","https://openalex.org/W2460926837","https://openalex.org/W962397878","https://openalex.org/W1978969411","https://openalex.org/W1982714394"],"abstract_inverted_index":null,"counts_by_year":[{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":3},{"year":2014,"cited_by_count":1},{"year":2012,"cited_by_count":3}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}