Abstract:Functional dependencies (FDs) are widely applied in data management tasks. Since FDs on data are usually unknown, FD discovery techniques are studied for automatically finding hidden FDs from data. In this paper, we develop techniques to dynamically discover FDs in response to changes on data. Formally, given the complete set Sigma of minimal and valid FDs on a relational instance r, we aim to find the complete set Sigma' of minimal and valid FDs on r circle plus Delta r, where Delta r is a set of tuple insertions and deletions. Different from the batch approaches that compute Sigma' on r circle plus Delta r from scratch, our dynamic method computes Sigma' in response to Delta r by leveraging the known Sigma on r, and avoids processing the whole of r for each update from Delta r We tackle dynamic FD discovery on r circle plus Delta r by dynamic hitting set enumeration on the difference-set of r circle plus Delta r Specifically, (1) leveraging auxiliary structures built on r, we first present an efficient algorithm to update the difference-set of r to that of r circle plus Delta r. (2) We then compute Sigma', by recasting dynamic FD discovery as dynamic hitting set enumeration on the difference-set of r circle plus Delta r and developing novel techniques for dynamic hitting set enumeration. (3) We finally experimentally verify the effectiveness and efficiency of our approaches, using real-life and synthetic data. The results show that our dynamic FD discovery method outperforms the batch counterparts on most tested data, even when Delta r is up to 30% of r.

External closure and its application in relational database

On data dependency structures of relational databases

Mixed Covers of Keys and Functional Dependencies for Maintaining the Integrity of Data under Updates

An Extension Of Classical Functional Dependency: Rough Functional Dependency And Its Inference Rules

A Computational Algorithm for the Ffd Transitive Closure and A Complete Axiomatization of Fuzzy Functional Dependence (Ffd)

Dynamic Functional Dependency Discovery with Dynamic Hitting Set Enumeration

Discovery of Field Functional Dependencies

Efficient Relaxed Functional Dependency Discovery with Minimal Set Cover

A minimal base or a direct base? That is the question!

Embedded functional dependencies and data-completeness tailored database design

Computing Optimal Repairs for Functional Dependencies

Reasoning About Micro Dependencies

Fuzzy Functional Dependency and a Series of Design Issues of Fuzzy Relational Databases

How to extend closure and interior operations to more modules

A General Treatment Of Date Redundancy In A Fuzzy Relational Data Model

A New Algorithm of Minimum Irregular Closure Retrieving

Normalization Based On Fuzzy Functional Dependency In A Fuzzy Relational Data Model

Approximate Functional Dependencies Based Query Evaluation Improvement

OPTIMIZED ALGORITHM OF DISCOVERING FUNCTIONAL DEPENDENCIES WITH DEGREES OF SATISFACTION

Incorporating cardinality constraints and synonym rules into conditional functional dependencies

EulerFD: an Efficient Double-Cycle Approximation of Functional Dependencies