skip to main content
article
Free Access

On the Complexity of Testing Implications of Functional and Join Dependencies

Authors Info & Claims
Published:01 October 1981Publication History
First page image

References

  1. 1 AHO, A V., BEERI, C, AND ULLMAN, J.D The theory of joins in relational databases ACM Trans Database Syst. 4, 3 (Sept 1979), 297-314. Google ScholarGoogle Scholar
  2. 2 AHO, A V, SAGIV, Y, AND ULLMAN, J D Eqmvalences among relational expressaons SlAM J Comput 8, 2 (May 1979), 218-246Google ScholarGoogle Scholar
  3. 3 ARMSTRONG, W W Dependency structures of database relauonshaps Proc IFIP 74, North Halland, Amsterdam, 1974, pp. 580-583Google ScholarGoogle Scholar
  4. 4 BEERI, RI, C On the membership problem for functional and multivalued dependencies in relational databases. ACM Trans Database Syst 5, 3 (Sept 1980), 241-259 Google ScholarGoogle Scholar
  5. 5 BEERI, C, AND BERNSTEIN, P A Computational problems related to the design of normal form relational schemas A CM Trans. Database Syst 4, 1 (March 1979), 30--59. Google ScholarGoogle Scholar
  6. 6 BEERI, C, FAGIN, R, AND HOWARD, J H A complete axlomaUzat~on for functional and multivalued dependencies in database relauons Proc ACM-SIGMOD Int Conf on Management of Data, Toronto, Aug 1977, pp 47-61 Google ScholarGoogle Scholar
  7. 7 BEERI, C, AND VARDI, M Y On the properues of joan dependenoes. In Advances m Data Base Theory, Vol 1, H Gallmre, J Mlnker, and J.M. Nicolas, Eds, Plenum Press, New York, 1981, pp 25-71.Google ScholarGoogle Scholar
  8. 7a BEERI, C., AND VARDI, M Y On the complexaty of testing lmphcauons of data dependenoes Res Rep, Dep. of Computer Science, The Hebrew Umv. of Jerusalem, Jerusalem, Israel, Dec 1980.Google ScholarGoogle Scholar
  9. 8 CODD, E.F. A relational model for large shared data banks. Commun ACM 13, 6 (June 1970), 377-387. Google ScholarGoogle Scholar
  10. 9 COOK, S A The complexity of theorem proving procedures Proc 3rd Ann ACM Symp on Theory of Computmg, Shaker Heights, Ohao, May 1971, pp 151-158 Google ScholarGoogle Scholar
  11. 10 FAGIN, R Multlvalued dependencaes and a new normal form for relational databases A CM Trans Database Syst 2, 3 (Sept. 1977), 262-278 Google ScholarGoogle Scholar
  12. 11 GALIL, Z An almost hnear time algorithm for computing the dependency bas~s m a relauonal database J A CM (to appear) Google ScholarGoogle Scholar
  13. 12 GAREY, M.R., AND JOHNSON, D S Computers and lntractabthty. A Crutde to the Theory of NP- Completeness. Freeman, San Franosco, 1979 Google ScholarGoogle Scholar
  14. 13 HAGIHARA, K, ITO, M, TANIGUCHI, K, AND KASAMI, T Decision problems for multlvalued dependencies m relational databases SlAM ~ Comput. 8, 2 (May 1979), 247-264.Google ScholarGoogle Scholar
  15. 14 HONEYMAN, P., LADNER, R.E., AND YANNAKAKIS, M Testing the umversal instance assumption. Inf. Proc Lett 10, 1 (Feb 1980), 14-19.Google ScholarGoogle Scholar
  16. 15 KARP, R M Reduobdity among combinatorial problems In Complemty of Computer Computations, R E Mdler and J W Thatcher, Eds, Plenum Press, New York, 1972, pp 85-104.Google ScholarGoogle Scholar
  17. 16 MAIER, D, MENDELZON, A O, AND SAGIV, Y Testing implicataons of data dependencms A CM Trans Database Syst 4, 4 (Dec 1979), 455--469. Google ScholarGoogle Scholar
  18. 17 RISSANEN, J Theory of relations for databases--a tutorial survey Proc 7th Symp on Mathematical Foundattons of Computer Science, Lecture Notes m Computer Soence 64, Sprmger-Verlag, Berlin, Headelberg, 1978, pp. 536-551Google ScholarGoogle Scholar
  19. 18 SAGIV, Y. An algorithm for mfemng multwalued dependencies with an application to propositional logic. J. ACM 27, 2 (April 1980), 250-262 Google ScholarGoogle Scholar
  20. 19 SAGIV, Y., DFJ.OBEL, C., PARKER, D.S, AND FAGIN, R. An equivalence between relational database dependencies and a subclass of propositional logic. J ACM 28, 3 (July 1981), 435-453. Google ScholarGoogle Scholar
  21. 20 VARDI, M.Y Inferrmg multlvalued dependencies from functional and join dependencies. Res. Rep., Dep. of Applied Mathematics, Wemmann Institute of Science, Rehovot, Israel, March 1980.Google ScholarGoogle Scholar
  22. 21 ZANIOLO, C. Analysis and destgn of relational schemata for database systems. Tech. Rep. UCLA- ENG-7669, Dep. of Computer Science, Umversity of Califonua, Los Angeles, Calif., July 1976.Google ScholarGoogle Scholar

Index Terms

  1. On the Complexity of Testing Implications of Functional and Join Dependencies

      Recommendations

      Comments

      Login options

      Check if you have access through your login credentials or your institution to get full access on this article.

      Sign in

      Full Access

      • Published in

        cover image Journal of the ACM
        Journal of the ACM  Volume 28, Issue 4
        Oct. 1981
        155 pages
        ISSN:0004-5411
        EISSN:1557-735X
        DOI:10.1145/322276
        Issue’s Table of Contents

        Copyright © 1981 ACM

        Publisher

        Association for Computing Machinery

        New York, NY, United States

        Publication History

        • Published: 1 October 1981
        Published in jacm Volume 28, Issue 4

        Permissions

        Request permissions about this article.

        Request Permissions

        Check for updates

        Qualifiers

        • article

      PDF Format

      View or Download as a PDF file.

      PDF

      eReader

      View online with eReader.

      eReader