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