Data-completeness Tailored Database Design with Embedded Functional Dependencies

ResearchSpace/Manakin Repository

Show simple item record Wei, Z en Link, S en 2020-01-10T01:36:47Z en 2020-01-10T01:36:47Z en 2019 en
dc.identifier.citation CDMTCS Research Reports CDMTCS-537 (2019) en
dc.identifier.issn 1178-3540 en
dc.identifier.uri en
dc.description.abstract We establish a robust schema design framework for data with missing values. The framework is based on the new notion of an embedded functional dependency, which is independent of the interpretation of missing values, able to express completeness and integrity requirements on application data, and capable of capturing many redundant data value occurrences. We establish axiomatic, algorithmic, and logical foundations for reasoning about embedded functional dependencies. These foundations allow us to establish generalizations of Boyce-Codd and Third normal forms that do not permit any redundancy in any future application data, or minimize their redundancy across dependency-preserving decompositions, respectively. We show how to transform any given schema into application schemata that meet given completeness and integrity requirements and the conditions of the generalized normal forms. Data over those application schemata are therefore t for purpose by design. Extensive experiments with benchmark schemata and data illustrate our framework, and the effectiveness and efficiency of our algorithms, but also provide quantified insight into database schema design trade-offs. en
dc.publisher Department of Computer Science, The University of Auckland, New Zealand en
dc.relation.ispartofseries CDMTCS Research Report Series en
dc.rights Items in ResearchSpace are protected by copyright, with all rights reserved, unless otherwise indicated. Previously published items are made available in accordance with the copyright policy of the publisher. en
dc.rights.uri en
dc.source.uri en
dc.title Data-completeness Tailored Database Design with Embedded Functional Dependencies en
dc.type Technical Report en
dc.subject.marsden Fields of Research en
dc.rights.holder Copyright: The author(s) en
dc.rights.accessrights en

Full text options

This item appears in the following Collection(s)

Show simple item record


Search ResearchSpace

Advanced Search