• 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