Sequential dependencies
Authors:
Open Access
- 1 August 2009
- journal article
- Published by Association for Computing Machinery (ACM) in Proceedings of the VLDB Endowment
- Vol. 2 (1) , 574-585
Abstract
We study sequential dependencies that express the semantics of data with ordered domains and help identify quality problems with such data. Given an interval g , we write X → g Y to denote that the difference between the Y -attribute values of any two consecutive records, when sorted on X , must be in g. For example, time → (0,∞) sequence_number indicates that sequence numbers are strictly increasing over time, whereas sequence_number → [4, 5] time means that the time "gaps" between consecutive sequence numbers are between 4 and 5. Sequential dependencies express relationships between ordered attributes, and identify missing (gaps too large), extraneous (gaps too small) and out-of-order data. To make sequential dependencies applicable to real-world data, we relax their requirements and allow them to hold approximately (with some exceptions) and conditionally (on various subsets of the data). This paper proposes the notion of conditional approximate sequential dependencies and provides an efficient framework for discovering pattern tableaux, which are compact representations of the subsets of the data (i.e., ranges of values of the ordered attributes) that satisfy the underlying dependency. We present analyses of our proposed algorithms, and experiments on real data demonstrating the efficiency and utility of our framework.Keywords
This publication has 16 references indexed in Scilit:
- Discovering data quality rulesProceedings of the VLDB Endowment, 2008
- On generating near-optimal tableaux for conditional functional dependenciesProceedings of the VLDB Endowment, 2008
- Longest increasing subsequences in windows based on canonical antichain partitionTheoretical Computer Science, 2007
- Exploiting k -constraints to reduce memory overhead in continuous queries over data streamsACM Transactions on Database Systems, 2004
- Longest increasing subsequences in sliding windowsTheoretical Computer Science, 2004
- Tane: An Efficient Algorithm for Discovering Functional and Approximate DependenciesThe Computer Journal, 1999
- Solving satisfiability and implication problems in database systemsACM Transactions on Database Systems, 1996
- Approximate inference of functional dependencies from relationsTheoretical Computer Science, 1995
- Order dependency in the relational modelTheoretical Computer Science, 1983
- On computing the length of longest increasing subsequencesDiscrete Mathematics, 1975