{"id":"https://openalex.org/W2171042068","doi":"https://doi.org/10.1016/0169-023x(93)90043-o","title":"On the design and maintenance of optimized relational representations of entity-relationship schemas","display_name":"On the design and maintenance of optimized relational representations of entity-relationship schemas","publication_year":1993,"publication_date":"1993-08-01","ids":{"openalex":"https://openalex.org/W2171042068","doi":"https://doi.org/10.1016/0169-023x(93)90043-o","mag":"2171042068"},"language":"en","primary_location":{"id":"doi:10.1016/0169-023x(93)90043-o","is_oa":false,"landing_page_url":"https://doi.org/10.1016/0169-023x(93)90043-o","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/A5077506036","display_name":"Marco A. Casanova","orcid":"https://orcid.org/0000-0003-0765-9636"},"institutions":[{"id":"https://openalex.org/I4210113516","display_name":"IBM Research - Brazil","ror":"https://ror.org/01fxqdx25","country_code":"BR","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210113516","https://openalex.org/I4210114115"]}],"countries":["BR"],"is_corresponding":true,"raw_author_name":"Marco A. Casanova","raw_affiliation_strings":["Rio Scientific Center, IBM Brazil, Av. Pres. Vargas, 824/22 andar, 20.071-001 Rio de Janeiro RJ, Brazil"],"affiliations":[{"raw_affiliation_string":"Rio Scientific Center, IBM Brazil, Av. Pres. Vargas, 824/22 andar, 20.071-001 Rio de Janeiro RJ, Brazil","institution_ids":["https://openalex.org/I4210113516"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5005544448","display_name":"Luiz Tucherman","orcid":null},"institutions":[{"id":"https://openalex.org/I4210113516","display_name":"IBM Research - Brazil","ror":"https://ror.org/01fxqdx25","country_code":"BR","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210113516","https://openalex.org/I4210114115"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Luiz Tucherman","raw_affiliation_strings":["Rio Scientific Center, IBM Brazil, Av. Pres. Vargas, 824/22 andar, 20.071-001 Rio de Janeiro RJ, Brazil"],"affiliations":[{"raw_affiliation_string":"Rio Scientific Center, IBM Brazil, Av. Pres. Vargas, 824/22 andar, 20.071-001 Rio de Janeiro RJ, Brazil","institution_ids":["https://openalex.org/I4210113516"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5045978751","display_name":"Alberto H. F. Laender","orcid":"https://orcid.org/0000-0001-5032-2233"},"institutions":[{"id":"https://openalex.org/I110200422","display_name":"Universidade Federal de Minas Gerais","ror":"https://ror.org/0176yjw32","country_code":"BR","type":"education","lineage":["https://openalex.org/I110200422"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Alberto H.F. Laender","raw_affiliation_strings":["Computer Science Department, Federal University of Minas Gerais, P.O. Box 702, 30. 161-970 Belo Horizonte MG, Brazil"],"affiliations":[{"raw_affiliation_string":"Computer Science Department, Federal University of Minas Gerais, P.O. Box 702, 30. 161-970 Belo Horizonte MG, Brazil","institution_ids":["https://openalex.org/I110200422"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5077506036"],"corresponding_institution_ids":["https://openalex.org/I4210113516"],"apc_list":{"value":2590,"currency":"USD","value_usd":2590},"apc_paid":null,"fwci":1.4361,"has_fulltext":false,"cited_by_count":17,"citation_normalized_percentile":{"value":0.85192241,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":97},"biblio":{"volume":"11","issue":"1","first_page":"1","last_page":"20"},"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.9995999932289124,"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.9995999932289124,"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.9983999729156494,"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.9936000108718872,"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/computer-science","display_name":"Computer science","score":0.6648982167243958},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.6635349988937378},{"id":"https://openalex.org/keywords/entity\u2013relationship-model","display_name":"Entity\u2013relationship model","score":0.6304131746292114},{"id":"https://openalex.org/keywords/heuristics","display_name":"Heuristics","score":0.6260864734649658},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.5547908544540405},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.5350464582443237},{"id":"https://openalex.org/keywords/conceptual-schema","display_name":"Conceptual schema","score":0.5309371948242188},{"id":"https://openalex.org/keywords/representation","display_name":"Representation (politics)","score":0.48007112741470337},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.45687711238861084},{"id":"https://openalex.org/keywords/plan","display_name":"Plan (archaeology)","score":0.41813716292381287},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.38524097204208374},{"id":"https://openalex.org/keywords/cognitive-psychology","display_name":"Cognitive psychology","score":0.11354154348373413},{"id":"https://openalex.org/keywords/psychology","display_name":"Psychology","score":0.11232316493988037},{"id":"https://openalex.org/keywords/recall","display_name":"Recall","score":0.0703328549861908}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6648982167243958},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6635349988937378},{"id":"https://openalex.org/C103593891","wikidata":"https://www.wikidata.org/wiki/Q624546","display_name":"Entity\u2013relationship model","level":3,"score":0.6304131746292114},{"id":"https://openalex.org/C127705205","wikidata":"https://www.wikidata.org/wiki/Q5748245","display_name":"Heuristics","level":2,"score":0.6260864734649658},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5547908544540405},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.5350464582443237},{"id":"https://openalex.org/C29275276","wikidata":"https://www.wikidata.org/wiki/Q2268965","display_name":"Conceptual schema","level":3,"score":0.5309371948242188},{"id":"https://openalex.org/C2776359362","wikidata":"https://www.wikidata.org/wiki/Q2145286","display_name":"Representation (politics)","level":3,"score":0.48007112741470337},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.45687711238861084},{"id":"https://openalex.org/C2776505523","wikidata":"https://www.wikidata.org/wiki/Q4785468","display_name":"Plan (archaeology)","level":2,"score":0.41813716292381287},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.38524097204208374},{"id":"https://openalex.org/C180747234","wikidata":"https://www.wikidata.org/wiki/Q23373","display_name":"Cognitive psychology","level":1,"score":0.11354154348373413},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.11232316493988037},{"id":"https://openalex.org/C100660578","wikidata":"https://www.wikidata.org/wiki/Q18733","display_name":"Recall","level":2,"score":0.0703328549861908},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C94625758","wikidata":"https://www.wikidata.org/wiki/Q7163","display_name":"Politics","level":2,"score":0.0},{"id":"https://openalex.org/C95457728","wikidata":"https://www.wikidata.org/wiki/Q309","display_name":"History","level":0,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C166957645","wikidata":"https://www.wikidata.org/wiki/Q23498","display_name":"Archaeology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1016/0169-023x(93)90043-o","is_oa":false,"landing_page_url":"https://doi.org/10.1016/0169-023x(93)90043-o","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":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":34,"referenced_works":["https://openalex.org/W86497608","https://openalex.org/W109080666","https://openalex.org/W146473550","https://openalex.org/W165875069","https://openalex.org/W172094284","https://openalex.org/W174180747","https://openalex.org/W286127917","https://openalex.org/W1499274542","https://openalex.org/W1499704384","https://openalex.org/W1505294616","https://openalex.org/W1511348662","https://openalex.org/W1518114862","https://openalex.org/W1538609262","https://openalex.org/W1577880763","https://openalex.org/W1597408892","https://openalex.org/W1967291753","https://openalex.org/W2012619249","https://openalex.org/W2067171475","https://openalex.org/W2087518386","https://openalex.org/W2090365014","https://openalex.org/W2113827629","https://openalex.org/W2140037779","https://openalex.org/W2144192824","https://openalex.org/W2751199251","https://openalex.org/W2945526390","https://openalex.org/W4301507461","https://openalex.org/W6603509622","https://openalex.org/W6605998016","https://openalex.org/W6606598371","https://openalex.org/W6606984338","https://openalex.org/W6607072452","https://openalex.org/W6630120888","https://openalex.org/W6630589125","https://openalex.org/W6634425381"],"related_works":["https://openalex.org/W2483382562","https://openalex.org/W2512945146","https://openalex.org/W2007556552","https://openalex.org/W2363790562","https://openalex.org/W2101197724","https://openalex.org/W2007986108","https://openalex.org/W325713583","https://openalex.org/W2102952102","https://openalex.org/W2366387924","https://openalex.org/W2403346309"],"abstract_inverted_index":null,"counts_by_year":[{"year":2018,"cited_by_count":3},{"year":2016,"cited_by_count":1},{"year":2012,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}