Advertisement

γ-Acyclic database schemes and nested relations

  • M. Levene
  • G. Loizou
Part IV Database Design
Part of the Lecture Notes in Computer Science book series (LNCS, volume 361)

Abstract

Nested relations have been put forward as a way of extending the applicability of the classical relational model. In this model acyclic database schemes have attracted a lot of interest because of the desirable properties they enjoy. Herein we characterize those γ-acyclic database schemes that are equivalent to nested relation schemes, and present an algorithm to restructure a γ-acyclic database scheme into a nested database scheme. This is desirable, since nested relations minimize redundancy and improve efficiency.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. [AB]
    ABITEBOUL S., and BIDOIT N. 1986. Non first normal form relations: an algebra allowing data restructuring. JCSS 33, pp. 361–393.Google Scholar
  2. [Ba]
    BACHMAN C. W. 1969. Data structure diagrams. Data Base 1, pp. 4–10.Google Scholar
  3. [Be]
    BERGE C. 1973. Graphs and Hypergraphs. Amsterdam, North-Holland.Google Scholar
  4. [BBSK]
    BISKUP J., BRÜGGEMANN H. H., SCHNETGÖKE L., AND KRAMER M. 1986. One flavor assumption and γ-acyclicity for universal relation views. Proc. ACM PODS, pp. 148–159.Google Scholar
  5. [BFMY]
    BEERI C., FAGIN R., MAIER D., and YANNAKAKIS M. 1983. On the desirability of acyclic database schemes. JACM 30, pp. 479–513.Google Scholar
  6. [BV]
    BEERI C., and VARDI M. Y. 1981. On the properties of join dependencies. In Advances in Databases Vol. 1 (Gallaire H., Minker J., and Nicholas J. M. Eds.). New York, Plenum Press, pp. 25–72.Google Scholar
  7. [De]
    DELOBEL C. 1978. Normalization and hierarchical dependencies in the relational data model. ACM TODS 3, pp. 201–222.Google Scholar
  8. [Fa1]
    FAGIN R. 1977. Multivalued dependencies and a new normal form for relational databases. ACM TODS 2, pp. 262–278.Google Scholar
  9. [Fa2]
    FAGIN R. 1983. Degrees of acyclicity for hypergraphs and relational database systems. JACM 30, pp. 514–550.Google Scholar
  10. [FMU]
    FAGIN R., MENDELZON A. O., and ULLMAN J. D. 1982. A simplified universal relation assumption and its properties. ACM TODS 7, pp. 343–360.Google Scholar
  11. [FV]
    FAGIN R., AND VARDI M. Y. 1984. The theory of data dependencies — A survey. IBM research report RJ 4321 (47149), San Jose, CA.Google Scholar
  12. [FSTV]
    FISCHER P. C., SAXTON L. V., THOMAS S. J., and van GUCHT D. 1985. Interactions between dependencies and nested relational structures. JCSS 31, pp. 343–354.Google Scholar
  13. [GR]
    GRAHNE G., AND RÄIHÄ K.-J. 1984. Dependency characterizations for acyclic database schemes. Proc. ACM PODS, pp. 9–18.Google Scholar
  14. [Ja]
    JAJODIA S. (1985). On the equivalence of relational and network database models. Information Processing Letters 20, pp. 51–54.Google Scholar
  15. [Li]
    LIEN Y. E. 1982. On the equivalence of database models. JACM 29, pp. 333–362.Google Scholar
  16. [LL1]
    LEVENE M., AND LOIZOU G. 1987. Project-join constructibility for NF2 relational databases. Bases De Données Advancées, BD3, pp. 143–163.Google Scholar
  17. [LL2]
    LEVENE M., AND LOIZOU G. 1987. An optimized fourth normal form utilizing nested relations. Research Report LL-87-01, Department of Computer Science, Birkbeck College, University of London, UK.Google Scholar
  18. [LL3]
    LEVENE M., AND LOIZOU G. 1988. A universal relation model for nested relations. Proceedings of International Conference on Extending Database Technology, Venice, pp. 294–308.Google Scholar
  19. [Mai]
    MAIER D. 1983. The Theory of Relational Databases. Rockville, Maryland, Computer Science Press.Google Scholar
  20. [MUV]
    MAIER D., ULLMAN J. D., and VARDI M. Y. 1984. On the foundations of the universal relation model. ACM TODS 9, pp. 283–308.Google Scholar
  21. [OY1]
    OZSOYOGLU Z. M., and YUAN L.-Y. 1987. A new normal form for nested relations. ACM TODS 12, pp. 111–136.Google Scholar
  22. [OY2]
    OZSOYOGLU Z. M., AND YUAN L.-Y. 1987. A design method for nested relational databases. Proc. 3rd IEEE Conference on Data Engineering, pp. 599–608.Google Scholar
  23. [RKS]
    ROTH M. A., KORTH H. F., AND SILBERSCHATZ A. 1985. Null values in — 1NF relational databases. Research report TR-85-32, Department of Computer Science, University of Texas at Austin, USA.Google Scholar
  24. [Ul]
    ULLMAN J. D. 1983. Principles of Database Systems. Rockville, Maryland, Computer Science Press.Google Scholar
  25. [VF]
    van GUCHT D., and FISCHER P. C. 1988. Multilevel nested relational structures. JCSS 36, pp. 77–105.Google Scholar
  26. [Ya]
    YANNAKAKIS M. 1981. Algorithms for acyclic database schemes. Proc. VLDB, pp. 82–94.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1989

Authors and Affiliations

  • M. Levene
    • 1
  • G. Loizou
    • 1
  1. 1.Department of Computer Science, Birkbeck CollegeUniversity of LondonLondonUK

Personalised recommendations