skip to main content
article
Free Access

On the Structure of Armstrong Relations for Functional Dependencies

Authors Info & Claims
Published:01 January 1984Publication History
First page image

References

  1. 1 ARMSTRONG, W.W.l_~penoency structures ot oataoase relallonsBily& lrl /'TOe. 11"11" /4, !~Ol'tll Holland, Amsterdam, 1974, pp. 580-583.Google ScholarGoogle Scholar
  2. 2 ARMSTRONG, W.W., AND DELOBEL, C.Decomposition and functional dependencies in relations. ACM Trans Database Syst 5, 4 (Dec. 1980), 404-430. Google ScholarGoogle Scholar
  3. 3 BEERI, C., AND BERNSTEIN, P A Computational problems related to the design of normal form relational schemas. ACM Trans. Database,.,Cyst 4, 1 (Mar. 1979), 30-59. Google ScholarGoogle Scholar
  4. 4 BEERI, C., FAGIN, R., AND HOWARD, J.H.A complete axiomatization for functional and multivalued dependencies m database relations. In Proc ACM-SIGMOD Int. Conf. on Management of Data (Toronto, Aug, 1977), ACM, New York, pp. 47-61. Google ScholarGoogle Scholar
  5. 5 CASANOVA, M.A., FAON, R., AND PAPADIMITRIOU, C.Inclusion dependencies and their interaction w~th functional dependencies. SlAM ~ Comput (to appear); extended abstract appeared in Proc. 1st ACM SIGACT-SIGMOD Principles of Database Systems (Los Angeles, Calif., 1982), ACM, New York, pp. 171-176. Google ScholarGoogle Scholar
  6. 6 CODD, E.F.Further normalization of the database relational model. In Data Base Systems, Courant Computer Soence Symposia 6, R. Rustin, Ed., Prentice Hall, Englewood Cliffs, N.J., pp. 65-98.Google ScholarGoogle Scholar
  7. 7 DEMETROVICS, J,On the number of candidate keys. Inf Proc Lett 7, 6 (Oct. 1978), 266-269.Google ScholarGoogle Scholar
  8. 8 DEMETROVICS, J., AND GYEPESI, G. On the functional dependency and some generalizations of it. Acta Cyberne 5, 3 (1981), 295-305.Google ScholarGoogle Scholar
  9. 9 ERDOS, P., AND KLEITMAN, D.Extremal problems among subsets of a given set. In Paul Erdos: The Art ofCount:ng---Selected Wrtttngs, J. Spencer, Ed., MIT Press, 1973, pp. 482-506.Google ScholarGoogle Scholar
  10. 10 FAGIN, R.Probabilities on finite models. J Symb Logic 41. 1 (Mar. 1976), 50-58.Google ScholarGoogle Scholar
  11. 11 FAGIN, R. Multivalued dependencies and a new normal form for relaUonal databases. ACM Trans. Database Syst. Z 3 (Sept. 1977), 262-278. Google ScholarGoogle Scholar
  12. 12 FAGIN, R.Functional dependencies tn a relational database and propositional logic. IBM ~ Res Devel 21, 6 (Nov. 1977), 534-544.Google ScholarGoogle Scholar
  13. 13 FAGeN, R.Armstrong databases. In Proc 7th IBM Syrup. on Mathematical Foundations of Compuler Scrence (Kanagawa, Japan, May 1982); also appeared as Res. Rep. ILI3440, IBM Resoareh Lab., San Jose, Calif., Apr. 1982.Google ScholarGoogle Scholar
  14. 14 FAGIN, R. Horn clauses and database dependencies. J. ACM 29, 4 (Oct. 1982), 952-985; extended abstract appeared in Proc. 12th Ann A CM Syrup. on Theory of Computing (Los Angeles, Calif., 1980), ACM, New York, pp. 123-134. Google ScholarGoogle Scholar
  15. 15 GAREY, M.R., AND JOHNSON, D.S.Computers and lntractibility: A Guide to the Theory of NP- Completeness, Freeman, San Francisco, 1979. Google ScholarGoogle Scholar
  16. 16 GINSBURG, S., AND HULL, R.Characterizations for functional dependency and Boyee-Codd normal form families. Tech. Rep., Univ. of Southern California, Los Angeles, Calif., Feb. 1982.Google ScholarGoogle Scholar
  17. 17 GINSBURG, S., AND ZAIDDAN, S.M.Properties of functional-dependency families. J. ACM 29, 3 (July 1982), 678-698. Google ScholarGoogle Scholar
  18. 18 GOLD, E.M. Axiomatization of attribute dependencies. Publ. # 173, Drpartemenf d'lnformauque, Universit6 de Montrral, May 1974.Google ScholarGoogle Scholar
  19. 19 GRATZER, G.UniversalAlgebra, 2nd ed. Springer-Verlag, New York, 1979.Google ScholarGoogle Scholar
  20. 20 LUCCHESl, C.L., AND OSBORN, S.L.Candidate keys for relations, J. Comput Syst. ScL 17, 2 (Oct. 1978), 270-279.Google ScholarGoogle Scholar
  21. 21 SAGIV, Y., DELOBEL, C., PARKER, D.S., AND FAGIN, R. An equivalence between relaUonal database dependenctes and a fragment of propositional logic. J. ACM 28, 3 (July 1981), 435=453. Google ScholarGoogle Scholar
  22. 22 SILVA, A,M., AND MELKANOFF, M.A. A method for helping discover the dependencies of a relatton. In Advances m Database Theory, Itol. 1, H. Gallaire, J. Minker, and J-M. Nwolas, Eds., Plenum Pubhshing, New York, 1981.Google ScholarGoogle Scholar
  23. 23 SPERNER, E., Eine Satz uber Untermensen einer endlichen Menge. Math. Zeu. 27 (1928), 544-548.Google ScholarGoogle Scholar
  24. 24 ~TATMAN, R. Worst case exponential lower bounds for input resolution with paramodulation. SIAM J Comput. (to appear).Google ScholarGoogle Scholar
  25. 25 ULLMAN, J.D.Prtnc~ples of Database Systems, 2rid ed. Computer Science Press, Rockville, Md., 1982.Google ScholarGoogle Scholar
  26. 26 ZANIOLO, C. Analysis and design of relational schemata for database systems. Ph.D. Dissertation, Tech. Rep. UCLA-ENG-7669, Univ. of California, Los Angeles, Calif., July 1976. Google ScholarGoogle Scholar
  27. 27 ZLOOF, M.M. Query-by-example. In Proc. 1975 National Computer Conf. 44, AFIPS Press, Arlington, Va., pp. 431-438.Google ScholarGoogle Scholar

Index Terms

  1. On the Structure of Armstrong Relations for Functional 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 31, Issue 1
        Jan. 1984
        188 pages
        ISSN:0004-5411
        EISSN:1557-735X
        DOI:10.1145/2422
        Issue’s Table of Contents

        Copyright © 1984 ACM

        Publisher

        Association for Computing Machinery

        New York, NY, United States

        Publication History

        • Published: 1 January 1984
        Published in jacm Volume 31, Issue 1

        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