Title :
Parallel approaches for discovering functional dependencies from data for information system design recovery
Author :
Lim, Wie Ming ; Harrison, John
Author_Institution :
Centre for Software Maintenance, Queensland Univ., Qld., Australia
Abstract :
The extraction of functional dependencies is a fundamental activity in the database design recovery process. Existing algorithms for this task are computationally expensive and appear to be impractical if applied to large legacy database instances, e.g., their performance deteriorates when number of attributes or/and instances is large. This paper presents strategies for parallelising the functional dependencies discovery process. We propose three parallel discovery models which are based on horizontal, vertical, and matrix database table slicing techniques. We exploit both program parallelism and data parallelism in our implementations. The results are discovery approaches that are more applicable to large real world databases
Keywords :
database theory; distributed databases; parallel algorithms; very large databases; data parallelism; database design recovery; database table slicing; functional dependencies; information system design recovery; large legacy database; large real world databases; parallel discovery models; program parallelism; Australia; Data mining; Database systems; Information systems; Information technology; Parallel algorithms; Parallel processing; Process design; Relational databases; Software maintenance;
Conference_Titel :
Parallel Architectures, Algorithms, and Networks, 1997. (I-SPAN '97) Proceedings., Third International Symposium on
Conference_Location :
Taipei
Print_ISBN :
0-8186-8259-6
DOI :
10.1109/ISPAN.1997.645105