Skip to Main content Skip to Navigation
Conference papers

Informative Armstrong Relations: Application to Database Analysis

Abstract : Given a set F of functional dependencies (FDs), Armstrong relations for F are example relations satisfying exactly F. Instead of starting from F, an interesting issue is to consider an existing relation, say r, and compute Armstrong relations for dep(r), the set of FDs satisfied in r. In this setting, the main contribution of this paper is to define so ­called Infor­mative Armstrong Relations (IAR), say s, for r such that s is a subset of r and s is an Armstrong relation for dep(r). Such a relation always exists since r itself is obviously an IAR for dep(r), but the challenge is to compute IAR whose size is as small as possible. First, we proof that generating the smallest IAR is NP­complete. Then, we give an heuristic to construct small IARs for a given relation. Some expe­riments have been performed on relations available in the KDD archive; they point out the interest of IARs to sample existing relations.
Document type :
Conference papers
Complete list of metadatas

https://hal.archives-ouvertes.fr/hal-00286636
Contributor : Stéphane Lopes <>
Submitted on : Tuesday, June 10, 2008 - 10:53:10 AM
Last modification on : Monday, January 20, 2020 - 12:12:05 PM

Identifiers

  • HAL Id : hal-00286636, version 1

Citation

Fabien de Marchi, Stéphane Lopes, Jean-Marc Petit. Informative Armstrong Relations: Application to Database Analysis. Journées Bases de Données Avancées (BDA), Oct 2001, Agadir, Morocco. pp.211-217. ⟨hal-00286636⟩

Share

Metrics

Record views

179