An incremental approach for maintaining functional dependencies

Ghada Gasmi (1) , Lotfi Lakhal (2) , Yahya Slimani (1)

1 INSAT Carthage - Institut National des Sciences Appliquées et de Technologie - Carthage
2 LIF - Laboratoire d'informatique Fondamentale de Marseille

A general assumption in all existing algorithms permitting to mine functional dependencies is that the database is static. However, real life databases are frequently updated. To the best of our knowledge, the discovery of functional dependencies in dynamic databases has never been studied. A naïve solution consists in reapplying one of the existing algorithms to discover functional dependencies holding on the updated database. Nevertheless, in many domains, where response time is crucial, re-executing algorithms from scratch would be inacceptable. In this paper, we propose a new technique that makes use of the previously discovered results to cut down the amount of work that has been done to discover the new set of functional dependencies satisfied by the updated database.

Mots clés: Functional dependencies; evolving databases; data mining; knowledge discover; maintenance

Domaines: Informatique [cs]; Base de données [cs.DB]

Ghada Gasmi, Lotfi Lakhal, Yahya Slimani. An incremental approach for maintaining functional dependencies. Intelligent Data Analysis, 2012, 16 (3), pp.365-381. ⟨10.3233/IDA-2012-0529⟩. ⟨hal-03149314⟩