{"id":"https://openalex.org/W1759724348","doi":"https://doi.org/10.1007/bfb0035011","title":"Redundancy elimination and a new normal form for relational database design","display_name":"Redundancy elimination and a new normal form for relational database design","publication_year":1997,"publication_date":"1997-01-01","ids":{"openalex":"https://openalex.org/W1759724348","doi":"https://doi.org/10.1007/bfb0035011","mag":"1759724348"},"language":"en","primary_location":{"id":"doi:10.1007/bfb0035011","is_oa":false,"landing_page_url":"https://doi.org/10.1007/bfb0035011","pdf_url":null,"source":{"id":"https://openalex.org/S106296714","display_name":"Lecture notes in computer science","issn_l":"0302-9743","issn":["0302-9743","1611-3349"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Lecture Notes in Computer Science","raw_type":"book-chapter"},"type":"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/A5068367622","display_name":"Millist W. Vincent","orcid":null},"institutions":[{"id":"https://openalex.org/I170239107","display_name":"University of South Australia","ror":"https://ror.org/01p93h210","country_code":"AU","type":"education","lineage":["https://openalex.org/I170239107"]}],"countries":["AU"],"is_corresponding":true,"raw_author_name":"Millist W. Vincent","raw_affiliation_strings":["Advanced Computing Research Centre, School of Computer and Information Science, University of South Australia, 5095, Adelaide, Australia","Advanced Computing Research Centre School of Computer and Information Science, University of South Australia, Adelaide, Australia"],"affiliations":[{"raw_affiliation_string":"Advanced Computing Research Centre, School of Computer and Information Science, University of South Australia, 5095, Adelaide, Australia","institution_ids":["https://openalex.org/I170239107"]},{"raw_affiliation_string":"Advanced Computing Research Centre School of Computer and Information Science, University of South Australia, Adelaide, Australia","institution_ids":["https://openalex.org/I170239107"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5068367622"],"corresponding_institution_ids":["https://openalex.org/I170239107"],"apc_list":{"value":5000,"currency":"EUR","value_usd":5392},"apc_paid":null,"fwci":0.48,"has_fulltext":false,"cited_by_count":17,"citation_normalized_percentile":{"value":0.66961377,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"247","last_page":"264"},"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.9997000098228455,"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.9997000098228455,"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.9986000061035156,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9855999946594238,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/redundancy","display_name":"Redundancy (engineering)","score":0.7720859050750732},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7367268204689026},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.656217098236084},{"id":"https://openalex.org/keywords/functional-dependency","display_name":"Functional dependency","score":0.5999530553817749},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.5525625944137573},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4223659634590149},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.36760056018829346},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.2905126214027405}],"concepts":[{"id":"https://openalex.org/C152124472","wikidata":"https://www.wikidata.org/wiki/Q1204361","display_name":"Redundancy (engineering)","level":2,"score":0.7720859050750732},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7367268204689026},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.656217098236084},{"id":"https://openalex.org/C26320393","wikidata":"https://www.wikidata.org/wiki/Q597053","display_name":"Functional dependency","level":3,"score":0.5999530553817749},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.5525625944137573},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4223659634590149},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.36760056018829346},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2905126214027405},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1007/bfb0035011","is_oa":false,"landing_page_url":"https://doi.org/10.1007/bfb0035011","pdf_url":null,"source":{"id":"https://openalex.org/S106296714","display_name":"Lecture notes in computer science","issn_l":"0302-9743","issn":["0302-9743","1611-3349"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Lecture Notes in Computer Science","raw_type":"book-chapter"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.44.7693","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.44.7693","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cis.unisa.edu.au/~cismwv/papers/new5NF.ps","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.62.611","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.62.611","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cis.unisa.edu.au/~cismwv/papers/new5NF.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":34,"referenced_works":["https://openalex.org/W9257641","https://openalex.org/W115595067","https://openalex.org/W1496627318","https://openalex.org/W1497921804","https://openalex.org/W1503312825","https://openalex.org/W1505165377","https://openalex.org/W1526843800","https://openalex.org/W1558832481","https://openalex.org/W1575734298","https://openalex.org/W1768010221","https://openalex.org/W1774916018","https://openalex.org/W1887796988","https://openalex.org/W1968137129","https://openalex.org/W1975714036","https://openalex.org/W1985581502","https://openalex.org/W1994410342","https://openalex.org/W2000773957","https://openalex.org/W2006564766","https://openalex.org/W2008396232","https://openalex.org/W2039601877","https://openalex.org/W2052228631","https://openalex.org/W2054735497","https://openalex.org/W2063141664","https://openalex.org/W2080688238","https://openalex.org/W2086065621","https://openalex.org/W2110810394","https://openalex.org/W2115822498","https://openalex.org/W2117671567","https://openalex.org/W2139238107","https://openalex.org/W2172013957","https://openalex.org/W4244057779","https://openalex.org/W6633513001","https://openalex.org/W6637960317","https://openalex.org/W6689392195"],"related_works":["https://openalex.org/W2039445786","https://openalex.org/W2267077731","https://openalex.org/W2185054849","https://openalex.org/W2126493028","https://openalex.org/W2361244046","https://openalex.org/W1504218574","https://openalex.org/W1629972737","https://openalex.org/W3111672439","https://openalex.org/W2154239691","https://openalex.org/W2807313188"],"abstract_inverted_index":null,"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":2}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}