Dep-Miner: Un Algorithme d'Extraction des Dépendances Fonctionnelles - Archive ouverte HAL
Article Dans Une Revue Revue des Sciences et Technologies de l'Information - Série TSI : Technique et Science Informatiques Année : 2000

Dep-Miner: Un Algorithme d'Extraction des Dépendances Fonctionnelles

Résumé

In this paper, we propose a new efficient algorithm called Dep-Miner for discovering minimal non-trivial functional dependencies from large databases. Based on theoretical foundations, our approach combines the discovery of minimal functional dependencies along with the construction of real-world Armstrong relations (without additional execution time). These relations are small Armstrong relations taking their values in the initial relation. Discovering both minimal functional dependencies and real-world Armstrong relations facilitate the tasks of database administrators when maintaining and analyzing existing databases. We evaluate Dep-Miner performances by using a benchmark database. Experimental results show both the efficiency of our approach compared to the best current algorithm (i.e. Tane) described in a detailed way in this article, and the usefulness of real-world Armstrong relations.
Fichier non déposé

Dates et versions

hal-00271562 , version 1 (09-04-2008)

Identifiants

  • HAL Id : hal-00271562 , version 1

Citer

Stéphane Lopes, Jean-Marc Petit, Lotfi Lakhal. Dep-Miner: Un Algorithme d'Extraction des Dépendances Fonctionnelles. Revue des Sciences et Technologies de l'Information - Série TSI : Technique et Science Informatiques, 2000, 19 (10), pp.1399-1428. ⟨hal-00271562⟩
159 Consultations
0 Téléchargements

Partager

More