Embedded Functional Dependencies and Data-completeness Tailored Database Design

ResearchSpace/Manakin Repository

Show simple item record

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


Full text options

Find Full text

This item appears in the following Collection(s)

Show simple item record

https://creativecommons.org/licenses/by-nc-nd/4.0/ Except where otherwise noted, this item's license is described as https://creativecommons.org/licenses/by-nc-nd/4.0/

Share

Search ResearchSpace


Advanced Search

Browse