On the normalization in Nested Relational Databases

  • Z. Meral Ozsoyoglu
  • Li-Yan Yuan
Part IV Database Design
Part of the Lecture Notes in Computer Science book series (LNCS, volume 361)


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.


Leaf Node Relation Scheme Normal Scheme Database Scheme Redundant Node 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [AB]
    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. [B+]
    Bancilhon, F. et al, "Verso: A Relational Back End Database Machine", Int. Workshop on Database Machines, 1982.Google Scholar
  3. [BaK]
    Bancilhon, F., and Khoshafian, S., A Calculus for Complex Objects, Proc. of the 5th ACM PODS, March 1986, pp 53–59.Google Scholar
  4. [BFMY]
    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. [BK]
    Beeri, C. and Kifer, M., Comprehensive Approach to the Design of Relational Database Schemes, Proc. VLDB, 1984, pp. 196–207.Google Scholar
  6. [BNRST]
    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. [Co]
    Codd, E., A Relational Model for Large Shared Data Bank, Comm. ACM, June 1970, pp. 377–387.Google Scholar
  8. [D+]
    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. [F+]
    Fischer, P.C., Saxton, L., Thomas, S. and Gucht, D.V., "Interactions between Dependencies and Nested Relation Structures", JCSS, (to appear).Google Scholar
  10. [Fa]
    Fagin, R., Multivalued Dependencies and a New Normal Form for Relational Databases, ACM TODS, Sept. 1977, pp. 262–278.Google Scholar
  11. [FT]
    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. [FV1]
    Fischer, P.C. and Van Gucht, D., Weak Multivalued Dependencies, Proc. ACM PODS, 1984, pp. 266–274.Google Scholar
  13. [FV2]
    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. [GR]
    Grahne, G. and Raiha, K.J, "Database Decomposition into Fourth Normal Form", VLDB Conf., 1983.Google Scholar
  15. [IBM1]
    SQL/Data Systems, Concepts and Facilities. IBM Corp., GH24-5013.Google Scholar
  16. [IBM2]
    IBM Systems Journal (Special issue on DB2), Vol. 23, No. 2, 1984.Google Scholar
  17. [JS]
    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. [Kat]
    Katsuno, H., An Extension of Conflict Free Multivalued Dependency sets, ACM TODS, June 1984, pp. 309–326.Google Scholar
  19. [Ka]
    Katz, R.H., Information Management for Engineering Design, Springer-Verlag, Berlin Heidelberg New York Tokyo, 1985.Google Scholar
  20. [Ku]
    Kuper, G.M., Logic Programming with Sets, Proc. of ACM PODS, 1987, pp. 11–20.Google Scholar
  21. [KDG]
    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. [Li]
    Lien, Y.E., On the Equivalence of Database Models, JACM, April 1982, pp. 333–362.Google Scholar
  23. [Ma]
    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. [OO]
    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. [OY1]
    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. [OY2]
    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. [PSSWD]
    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. [PT]
    Pistor, P. and Traunmueller, R., "A Database Language for Sets, Lists, and Tables", Tech. Report, Heidelberg Scientific Center, IBM, Germany, 1985.Google Scholar
  29. [RK]
    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. [RKS]
    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. [St-]
    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. [Ul]
    Ullman, J.D., Principles of Database Systems, Computer Science Press, Potomac, Maryland, 1983.Google Scholar
  33. [VF]
    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. [YO]
    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. [YO2]
    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]
    Yuan, L.Y., Design Theory for Nested Relational Databases, Ph.D. Dissertation, Case Western Reserve University, 1986.Google Scholar
  37. [ZM]
    Zaniola, C., and Melkanoff, M.A., On the Design of Relational Database Schemata, ACM TODS, March 1981, pp. 1–47.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1989

Authors and Affiliations

  • Z. Meral Ozsoyoglu
    • 1
  • Li-Yan Yuan
    • 2
  1. 1.Computer Engineering and ScienceDepartment Case Western Reserve UniversityCleveland
  2. 2.Department of Computing ScienceThe University of AlbertaEdmontonCanada

Personalised recommendations