{"id":"https://openalex.org/W1793644915","doi":"https://doi.org/10.1007/978-1-4471-1525-0_36","title":"Re-engineering Relational Normal Forms in an Object-Oriented Framework","display_name":"Re-engineering Relational Normal Forms in an Object-Oriented Framework","publication_year":1998,"publication_date":"1998-01-01","ids":{"openalex":"https://openalex.org/W1793644915","doi":"https://doi.org/10.1007/978-1-4471-1525-0_36","mag":"1793644915"},"language":"en","primary_location":{"is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4471-1525-0_36","pdf_url":null,"source":{"id":"https://openalex.org/S4306521516","display_name":"OOIS","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_indexed_in_scopus":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false},"type":"book-chapter","type_crossref":"book-chapter","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/A5103294777","display_name":"James L. Johnson","orcid":null},"institutions":[{"id":"https://openalex.org/I52669646","display_name":"Western Washington University","ror":"https://ror.org/05wn7r715","country_code":"US","type":"funder","lineage":["https://openalex.org/I52669646"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"James L. Johnson","raw_affiliation_strings":["Western Washington University, Bellingham, Washington, 98225, USA"],"affiliations":[{"raw_affiliation_string":"Western Washington University, Bellingham, Washington, 98225, USA","institution_ids":["https://openalex.org/I52669646"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5110232028","display_name":"George Fernandez","orcid":"https://orcid.org/0000-0001-6494-9029"},"institutions":[{"id":"https://openalex.org/I1320473756","display_name":"The Royal Melbourne Hospital","ror":"https://ror.org/005bvs909","country_code":"AU","type":"healthcare","lineage":["https://openalex.org/I1320473756","https://openalex.org/I4210158168"]}],"countries":["AU"],"is_corresponding":false,"raw_author_name":"George Fernandez","raw_affiliation_strings":["Royal Melbourne Institute of Technology, Melbourne, Victoria, Australia"],"affiliations":[{"raw_affiliation_string":"Royal Melbourne Institute of Technology, Melbourne, Victoria, Australia","institution_ids":["https://openalex.org/I1320473756"]}]}],"institution_assertions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.468,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.517771,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":63,"max":67},"biblio":{"volume":null,"issue":null,"first_page":"433","last_page":"452"},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998,"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.9998,"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/T11106","display_name":"Data Management and Algorithms","score":0.9978,"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"}},{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9926,"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/entity\u2013relationship-model","display_name":"Entity\u2013relationship model","score":0.556771}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6534384},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6443964},{"id":"https://openalex.org/C103593891","wikidata":"https://www.wikidata.org/wiki/Q624546","display_name":"Entity\u2013relationship model","level":3,"score":0.556771},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.54606473},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.5438798},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.5140263},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.4234953},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3844038},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3302018},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.3283702}],"mesh":[],"locations_count":1,"locations":[{"is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4471-1525-0_36","pdf_url":null,"source":{"id":"https://openalex.org/S4306521516","display_name":"OOIS","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_indexed_in_scopus":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false}],"best_oa_location":null,"sustainable_development_goals":[],"grants":[],"datasets":[],"versions":[],"referenced_works_count":14,"referenced_works":["https://openalex.org/W1515733035","https://openalex.org/W1552830686","https://openalex.org/W1884671243","https://openalex.org/W1985581502","https://openalex.org/W1998046157","https://openalex.org/W2004053047","https://openalex.org/W2018223116","https://openalex.org/W2028222220","https://openalex.org/W2056168203","https://openalex.org/W2085772207","https://openalex.org/W2115162501","https://openalex.org/W2986348978","https://openalex.org/W3189142755","https://openalex.org/W616547823"],"related_works":["https://openalex.org/W73223004","https://openalex.org/W4297044271","https://openalex.org/W4248533530","https://openalex.org/W3085968255","https://openalex.org/W2602282026","https://openalex.org/W2512945146","https://openalex.org/W2483382562","https://openalex.org/W2356642811","https://openalex.org/W2007556552","https://openalex.org/W1491042988"],"abstract_inverted_index":{"In":[0,68,104],"relational":[1,73,118,134,148],"database":[2,52,79,129],"design,":[3],"the":[4,14,47,69,78,90,106,114,128],"normal":[5,122,135,149],"forms":[6,123,150],"have":[7],"long":[8],"served":[9],"as":[10],"a":[11,72,109,117],"guide":[12],"to":[13,29,37,74,126,146,151],"proper":[15],"dispersion":[16],"of":[17,108,116],"application":[18,48,55,92],"attributes":[19,56],"across":[20,57],"multiple":[21],"tables.":[22,130],"These":[23],"canonical":[24],"formats,":[25],"ranging":[26],"from":[27,71],"First":[28],"Fifth":[30],"Normal":[31],"Form,":[32],"enforce":[33],"increasingly":[34],"complex":[35],"constraints":[36],"foreclose":[38],"more":[39,41],"and":[40,143],"subtle":[42],"opportunities":[43],"for":[44],"inconsistency":[45],"in":[46,120,139],"data.":[49],"Although":[50],"object-oriented":[51,76,141,153],"design":[53,119],"disperses":[54],"classes":[58,93],"rather":[59],"than":[60],"tables,":[61],"constraint":[62],"enforcement":[63],"remains":[64],"an":[65,75,140,152],"important":[66],"concern.":[67],"transition":[70],"environment,":[77],"designer":[80],"must":[81],"reconcile":[82],"normalization":[83],"processes":[84],"with":[85],"newer":[86],"approaches":[87],"that":[88],"identify":[89],"core":[91],"(e.g.,":[94],"Jacobson's":[95],"Objectory,":[96],"Rumbaugh's":[97],"Object":[98],"Modeling":[99],"Technique,":[100],"or":[101],"Booch's":[102],"method).":[103],"particular,":[105],"reengineering":[107],"legacy":[110],"system":[111],"may":[112],"involve":[113],"study":[115],"which":[121],"were":[124],"used":[125],"establish":[127],"This":[131],"paper":[132],"reviews":[133],"forms,":[136],"interprets":[137],"them":[138],"context,":[142],"provide":[144],"guidelines":[145],"port":[147],"database.":[154]},"abstract_inverted_index_v3":null,"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W1793644915","counts_by_year":[],"updated_date":"2025-03-24T09:54:04.158657","created_date":"2016-06-24"}