dc.contributor.author |
Wei, Ziheng |
en |
dc.contributor.author |
Link, Sebastian |
en |
dc.date.accessioned |
2019-11-21T21:04:46Z |
en |
dc.date.issued |
2019-07 |
en |
dc.identifier.citation |
Proceedings of the VLDB Endowment (PVLDB) 12(11):1458-1470 Jul 2019 |
en |
dc.identifier.issn |
2150-8097 |
en |
dc.identifier.uri |
http://hdl.handle.net/2292/49019 |
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 and algorithmic 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 fit 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.relation.ispartofseries |
Proceedings of the VLDB Endowment (PVLDB) |
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 |
https://researchspace.auckland.ac.nz/docs/uoa-docs/rights.htm |
en |
dc.rights.uri |
https://creativecommons.org/licenses/by-nc-nd/4.0/ |
en |
dc.rights.uri |
http://www.vldb.org/pvldb/policies.html |
en |
dc.title |
Embedded Functional Dependencies and Data-completeness Tailored Database Design |
en |
dc.type |
Journal Article |
en |
dc.identifier.doi |
10.14778/3342263.3342626 |
en |
pubs.issue |
11 |
en |
pubs.begin-page |
1458 |
en |
pubs.volume |
12 |
en |
dc.rights.holder |
Copyright: The authors |
en |
pubs.end-page |
1470 |
en |
dc.rights.accessrights |
http://purl.org/eprint/accessRights/OpenAccess |
en |
pubs.subtype |
Article |
en |
pubs.elements-id |
784602 |
en |
pubs.org-id |
Science |
en |
pubs.org-id |
School of Computer Science |
en |
pubs.record-created-at-source-date |
2019-10-25 |
en |