Skip to main content
SpringerLink
Log in

On the normalization in Nested Relational Databases

  • Part IV Database Design
  • Conference paper
  • First Online:
Nested Relations and Complex Objects in Databases (NF2 1987)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 361))

Abstract

In this paper, we address the problem of designing a database with nested relations with respect to semantic integrity constraints. The semantic integrity constraints we consider are functional and multivalued dependencies. We define a normal form for nested relations, called nested normal form, utilizing the functional and multivalued dependencies, and give an algorithm to a obtain such a database scheme. In the nested normal form the relations are structured with respect to a nonredundant set of data dependencies. The semantic differences between functional and multivalued dependencies are distinguished and incorporated in the design method. The properties of the nested normal form, and the other design methods for the nested normal form are also discussed.

This research is supported in part by the NSF grant No-8605554 and an IBM Faculty Development Award.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Abiteboul, S. and Bidoit, N., Non First Normal for Relations to Represent Hierarchically Organized Data, Proc. ACM PODS, 1984 pp. 191–200.

    Google Scholar 

  2. Bancilhon, F. et al, "Verso: A Relational Back End Database Machine", Int. Workshop on Database Machines, 1982.

    Google Scholar 

  3. Bancilhon, F., and Khoshafian, S., A Calculus for Complex Objects, Proc. of the 5th ACM PODS, March 1986, pp 53–59.

    Google Scholar 

  4. Beeri, C., Fagin, R., Maier, D. and Yannakakis, M., "On the Desirability of Acyclic Database Schemes", JACM, July 1983, pp. 479–513.

    Google Scholar 

  5. Beeri, C. and Kifer, M., Comprehensive Approach to the Design of Relational Database Schemes, Proc. VLDB, 1984, pp. 196–207.

    Google Scholar 

  6. Beeri, C., Naqvi, S., Ramakrishnan,R., Shmueli, O., Tsur, S., Sets and Negation in a Logic Database Language (LDL1), Proc. of ACM PODS, 1987, pp. 21–27.

    Google Scholar 

  7. Codd, E., A Relational Model for Large Shared Data Bank, Comm. ACM, June 1970, pp. 377–387.

    Google Scholar 

  8. Dadam, P. et al., A DBMS Prototype to Support Extended NF2 Relations: An Integrated View on Flat Tables and Hierarchies, Proc. of ACM SIGMOD, 1986, pp. 356–367.

    Google Scholar 

  9. Fischer, P.C., Saxton, L., Thomas, S. and Gucht, D.V., "Interactions between Dependencies and Nested Relation Structures", JCSS, (to appear).

    Google Scholar 

  10. Fagin, R., Multivalued Dependencies and a New Normal Form for Relational Databases, ACM TODS, Sept. 1977, pp. 262–278.

    Google Scholar 

  11. Fischer, P.C. and Thomas, S.J., Operations for Non-First-Normal Form Relations, IEEE Computer Software and Applications Conference, Oct. 1983, pp. 464–475.

    Google Scholar 

  12. Fischer, P.C. and Van Gucht, D., Weak Multivalued Dependencies, Proc. ACM PODS, 1984, pp. 266–274.

    Google Scholar 

  13. Fischer, P.C. and Gucht, D.V., Determining When A Structure is a Nested Relation, Proc. of 11th VLBD, 1985, pp. 171–180.

    Google Scholar 

  14. Grahne, G. and Raiha, K.J, "Database Decomposition into Fourth Normal Form", VLDB Conf., 1983.

    Google Scholar 

  15. SQL/Data Systems, Concepts and Facilities. IBM Corp., GH24-5013.

    Google Scholar 

  16. IBM Systems Journal (Special issue on DB2), Vol. 23, No. 2, 1984.

    Google Scholar 

  17. Jaeschke, G. and Scheck, H.J., Remarks on the Algebra of Nonfirst Normal Form Relations, Proc. ACM PODS, 1982, pp. 124–138.

    Google Scholar 

  18. Katsuno, H., An Extension of Conflict Free Multivalued Dependency sets, ACM TODS, June 1984, pp. 309–326.

    Google Scholar 

  19. Katz, R.H., Information Management for Engineering Design, Springer-Verlag, Berlin Heidelberg New York Tokyo, 1985.

    Google Scholar 

  20. Kuper, G.M., Logic Programming with Sets, Proc. of ACM PODS, 1987, pp. 11–20.

    Google Scholar 

  21. Kuspert, K., Dadam, P., Gunauer, J., Cooperative Object Buffer Management in the Advanced Information Management Prototype, Proc. of VLDB Conf., 1987, pp. 483–492.

    Google Scholar 

  22. Lien, Y.E., On the Equivalence of Database Models, JACM, April 1982, pp. 333–362.

    Google Scholar 

  23. Makinouchi, A., A Consideration of Normal Form of Not-Necessarily-Normalized Relations in the Relational Data Model. Proc. of Fifth VLDB, 1977, pp. 447–453.

    Google Scholar 

  24. Ozsoyoglu, Z.M. and Ozsoyoglu, G., An Extension of Relational Algebra for Summary Tables, Proc. Statistical Database Workshop, 1983, pp. 202–211.

    Google Scholar 

  25. Ozsoyoglu, Z.M. and Yuan, L.Y., A Normal Form for Nested Relations, Proc. of the 4th ACM PODS, March, 1985, pp. 251–260, (full version to appear in ACM-TODS).

    Google Scholar 

  26. Ozsoyoglu, Z.M. and Yuan, L.Y., Reduced MVDs and Minimum Covers, Technical Report CES-84-06, Computer Engineering Dept., CWRU, (to appear in ACM-TODS).

    Google Scholar 

  27. Paul, H.-B., Schek, H.-J., Scholl, M.H., Weikum, G., and Deppisch, U., Architecture and Implementation of the Darmstadt Database Kernel System, Proc. of ACM SIGMOD, 1987, pp. 220–226.

    Google Scholar 

  28. Pistor, P. and Traunmueller, R., "A Database Language for Sets, Lists, and Tables", Tech. Report, Heidelberg Scientific Center, IBM, Germany, 1985.

    Google Scholar 

  29. Roth, M.A., Korth, H.F., The Design of non 1NF Databases into Nested Normal Form, Proc. of ACM SIGMOD, 1987, pp. 143–159.

    Google Scholar 

  30. Roth, M.A., Korth, H.F., and Silberschatz, A., Theory of Non-First-Normal Form Relational Databases. TR-84-36, Department of Computer Science, University of Texas at Austin (December 1984).

    Google Scholar 

  31. Stonebraker, M. et al.: The Design and Implementation of INGRES. ACM Tran. on Database Systems, Vol. 1, No. 3, Sept. 1976, pp. 189–222.

    Google Scholar 

  32. Ullman, J.D., Principles of Database Systems, Computer Science Press, Potomac, Maryland, 1983.

    Google Scholar 

  33. Van Gucht, D. and Fischer, P.C., Some Classes of Multilevel Relational Structures, Proc. of the 5th ACM PODS, March 1986, pp. 60–69.

    Google Scholar 

  34. Yuan, L.Y., and Ozsoyoglu, Z.M., Unifying Functional and Multivalued Dependencies For Relational Database Design, Proc. of the 5th ACM PODS, March, 1986, pp. 183–190.

    Google Scholar 

  35. Yuan, L.Y., and Ozsoyoglu, Z.M., Logical Design of Relational Database Schemes, Proc. of 6th ACM PODS, March 1987, pp. 38–47.

    Google Scholar 

  36. Yuan, L.Y., Design Theory for Nested Relational Databases, Ph.D. Dissertation, Case Western Reserve University, 1986.

    Google Scholar 

  37. Zaniola, C., and Melkanoff, M.A., On the Design of Relational Database Schemata, ACM TODS, March 1981, pp. 1–47.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Computer Engineering and Science, Department Case Western Reserve University, 44106, Cleveland, Ohio

    Z. Meral Ozsoyoglu

  2. Department of Computing Science, The University of Alberta, T6G 2H1, Edmonton, Alberta, Canada

    Li-Yan Yuan

Authors
  1. Z. Meral Ozsoyoglu
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Li-Yan Yuan
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

S. Abiteboul P. C. Fischer H. -J. Schek

Rights and permissions

Reprints and permissions

Copyright information

© 1989 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Ozsoyoglu, Z.M., Yuan, LY. (1989). On the normalization in Nested Relational Databases. In: Abiteboul, S., Fischer, P.C., Schek, H.J. (eds) Nested Relations and Complex Objects in Databases. NF2 1987. Lecture Notes in Computer Science, vol 361. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-51171-7_31

Download citation

  • DOI: https://doi.org/10.1007/3-540-51171-7_31

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-51171-7

  • Online ISBN: 978-3-540-46175-3

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation