DocumentCode :
2710661
Title :
Efficient parallel algorithms for functional dependency manipulations
Author :
Sridhar, Radhakrishnan ; Iyengar, Sitharama S.
Author_Institution :
Dept. of Comput. Sci., Louisiana State Univ., Baton Rouge, LA, USA
fYear :
1990
fDate :
2-4 Jul 1990
Firstpage :
126
Lastpage :
137
Abstract :
Given a set of functional dependencies Σ and a single dependency σ, it is shown that the algorithm to test whether Σ implies σ is log-space complete in P. The functional dependencies Σ are represented as a directed hypergraph HΣ. A parallel algorithm is presented which solves the above implication problem using P processors on an exclusive-read, exclusive-write parallel random access machine (EREW-PRAM) in O(e/P+n log P) time and on a concurrent-read, concurrent-write PRAM (CRCW-PRAM) in O(e/P+n) time, where e and n are the number of arcs and nodes of the graph HΣ. For graphs HΣ with fixed degree and diameter, it is shown that the closure H Σ+ can be computed in NC. NC algorithms are presented to obtain a nonredundant and a LR-minimum cover for the set of functional dependencies Σ. All the algorithms on an n-node directed hypergraph with fixed degree and diameter can be implemented to run in O(log2 n) time with M(n) processors on a CREW-PRAM model, where M (n) is the cost of multiplying two binary matrices. The algorithms are efficient based on the transitive closure bottleneck phenomenon
Keywords :
computational complexity; directed graphs; parallel algorithms; random-access storage; CRCW-PRAM; EREW-PRAM; LR-minimum cover; NC algorithms; arcs; binary matrices; closure; concurrent-read; concurrent-write PRAM; diameter; exclusive-read; exclusive-write parallel random access machine; fixed degree; functional dependencies; functional dependency manipulations; implication problem; log-space complete; n-node directed hypergraph; nodes; parallel algorithm; single dependency; transitive closure bottleneck phenomenon; Chromium; Computer science; Concurrent computing; Cost function; Maintenance; Parallel algorithms; Redundancy; Relational databases; Testing; Zirconium;
fLanguage :
English
Publisher :
ieee
Conference_Titel :
Databases in Parallel and Distributed Systems, 1990, Proceedings. Second International Symposium on
Conference_Location :
Dublin
Print_ISBN :
0-8186-2052-8
Type :
conf
DOI :
10.1109/DPDS.1990.113704
Filename :
113704
Link To Document :
بازگشت