Advertisement

A storage structure for Nested Relational Databases

  • Anand Deshpande
  • Dirk Van Gucht
Part I System Design
Part of the Lecture Notes in Computer Science book series (LNCS, volume 361)

Abstract

We propose a storage structure for hierarchical structures in Nested Relational Databases. In particular, we define a combination of two data structures: a record-list structure and a tree storing all the atomic values present in the tuples and sub-tuples of the database. This storage structure allows for efficient execution of updates and queries expressed in the extended relational algebra of the nested relational database model.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 1.
    S. Abiteboul, N. Bidoit, “Non First Normal Form Relations to Represent Hierarchically Organized Data”, Proc. Third ACM SIGACT-SIGMOD Symposium on Principles of Database Systems, 1984, 191–200.Google Scholar
  2. 2.
    Francois Bancilhon, “Object-Oriented Database Systems,” Proceedings of the Seventh ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems, Austin, Texas, March 21–23, 1988, pp. 152–162.Google Scholar
  3. 3.
    F. Bancilhon, S. Khoshafian, “A Calculus for Complex Objects” Proc. Fifth ACM SIGACT-SIGMOD Symposium on Principles of Database Systems, 1986, 53–59.Google Scholar
  4. 4.
    F. Bancilhon, P. Richard, M. School, “On Line Processing of Compacted Relations”, Proc.8th VLDB, 1982, 263–269.Google Scholar
  5. 5.
    C. Beeri, S. Naqvi, R. Ramakrishnan, O. Shmueli, S. Tsur, “Sets and Negation in Logic Database Language (LDL1)” Proc. 6th PODS, San Diego, 1987, pp. 21–37.Google Scholar
  6. 6.
    N. Bidoit, “Efficient Evaluation of Relational Queries Using Nested Realtions”, Rapports de Recherche, no 480, INRIA, 1986Google Scholar
  7. 7.
    P. Dadam, K. Kuespert, F. Andersen, H. Blanken, R. Erbe, J. Guenauer, V. Lum, P. Pistor, G. Walch, “A DBMS Prototype to Support Extended NF2 Relations: An Integrated View on Flat Tables and Hierarchies”, Proc. ACM SIGMOD Int'l Conf. on Management of Data, Washington, D.C., 1986, 356–366.Google Scholar
  8. 8.
    U. Deppisch, H.-B. Paul, H.-J. Schek, “A Storage System for Complex Objects”, Proc. of the Int'l Workshop on Object-Oriented Database System, Pacific Grove, 1986, pp. 183–195.Google Scholar
  9. 9.
    A. Deshpande, D. Van Gucht, “Storage Structures for Nested Relational Databases”, Technical Report No. 234, Indiana University, Computer Science Department, Bloomington, November 1987Google Scholar
  10. 10.
    A. Deshpande, D. Van Gucht, “An Implementation for Nested Relational Databases”, Technical Report No. 243, Indiana University, Computer Science Department, Bloomington, February 1988Google Scholar
  11. 11.
    A. Deshpande, D. Van Gucht, “An Implementation for Nested Relational Databases”, Proceedings of the 14th VLDB, Los Angeles, 1988, pp.76–87Google Scholar
  12. 12.
    V. Deshpande, P. Larson “An Algebra for Nested Relational Databases” Waterloo Technical ReportGoogle Scholar
  13. 13.
    G. Houben, J. Paredaens, “The R2-Algebra: An Extension of an Algebra for Nested Relations”, Tech. Rep., Tech. University, Eindhoven, 1987Google Scholar
  14. 14.
    G. Jaeschke, H.-J. Schek, “Remarks on the the Algebra on Non First Normal Form Relations”, Proc. ACM SIGACT-SIGMOD Symposium on Principles of Database Systems, 1982, 124–138.Google Scholar
  15. 15.
    A. Makinouchi, “A Consideration of Normal Form of Not-Necessarily-Normalized Relations in the Relational Data Model”, Proc. 5th Int'l Conf. on Very Large Data Bases, 1977, 447–453.Google Scholar
  16. 16.
    “Non First Normal Form Relations and Recursive Queries: An SQL-Based Approach”, Proc. 3rd IEEE Int. Conf. on Data Engineering, Los Angeles, 1987Google Scholar
  17. 17.
    M. Missikoff, “A Domain Based Internal Schema for Relational Database Machines”, Proc. ACM SIGMOD Int'l Conf. on Management of Data, 1982, 215–224.Google Scholar
  18. 18.
    M. Missikoff and M. Scholl, “Relational Queries in Domain Based DBMS”, Proc. ACM SIGMOD Int'l Conf. on Management of Data, 1983, 219–227.Google Scholar
  19. 19.
    H.-B. Paul, H.-J. Schek, M.H. Scholl, G. Weikum, U. Deppisch, “Architecture and Implementation of Darmstadt Database Kernel System” Proc. Ann SIGMOD Conf., San Fransisco, 1987, pp. 196–207.Google Scholar
  20. 20.
    P. Pistor, F. Andersen, “Designing a Generalizied NF2 Model with an SQL-Type Language Interface”, Proc. 12th VLDB, Kyoto, Japan, 1986, pp. 278–288.Google Scholar
  21. 21.
    P. Pistor, R. Traunmueller, “A Database Language for Sets, Lists and Tables”, Information Systems 11:4, 1986, pp. 323–336Google Scholar
  22. 22.
    M.A. Roth, H.F. Korth, D.S. Batory, “SQL/NF: A Query Language for ⌌1NF Relational Databases”, Information Systems 12:1, 1987, pp. 99–114.Google Scholar
  23. 23.
    M.A. Roth, H.F. Korth, A. Silberschatz, “Theory of Non-First-Normal-Form Relational Databases”, Tech. Report TR-84-36 (Revised January 1986), University of Texas at Austin, 1984.Google Scholar
  24. 24.
    H.J. Schek, “Towards a Basic Relational NF2 Algebra Processor”, Proc. of the International Conference of Data Organization, Kyoto, Japan, 1985, 173–182.Google Scholar
  25. 25.
    H.-J. Schek, P.Pistor, “Data Structures for an Integrated Data Base Management and Information Retrieval System”, Proc. 8th Int'l Conf. on Very Large Data Bases, Mexico, 1982, 197–207.Google Scholar
  26. 26.
    H.-J. Schek, M.H. Scholl, “An Algebra for the Relational Model with Relation-Valued Attributes”, TR DVSI-1984-T1, Technical University of Darmstadt, West Germany, 1984.Google Scholar
  27. 27.
    H.-J. Schek, M.H. Scholl, “The Relational Model with Relation-Valued Attributes”, Information Systems (11:2), 1986Google Scholar
  28. 28.
    M.H. Scholl, “Theoretical Foundations of Algebraic Optimization Utilizing Unnormalized Relations” Proc. 1st ICDT, Rome, Italy, Sept. 1986, in Lecture Notes in Computer Science, 243, G. Ausiello and P. Atzeni, eds., Springer Verlag, pp. 380–396.Google Scholar
  29. 29.
    M.H. Scholl, H.-B. Paul, H.-J. Schek “Supporting Flat Relations by a Nested Relational Kernel” Proc. 13th VLDB, London, 87.Google Scholar
  30. 30.
    S.J. Thomas, P.C. Fischer, “Nested Relational Structures”, Advances in Computing Research III, The Theory of Databases, P.C. Kanellakis, ed., JAI Press, 1986, pp. 269–307.Google Scholar
  31. 31.
    D. Van Gucht, “Theory of Unnormalized Relational Structures”, Ph.D. Dissertation, Vanderbilt University, 1985.Google Scholar
  32. 32.
    D. Van Gucht, P.C. Fischer, “MVDs, Weak MVDs and Nested Relational Structures”, Technical Report CS-84-19, Vanderbilt University, 1984.Google Scholar
  33. 33.
    D. Van Gucht, P.C. Fischer, “Some Classes of Multilevel Relational Structures”, Proc. of the Fifth ACM SIGACT-SIGMOD Symposium on Principles of Database Systems, 1986, 60–69.Google Scholar
  34. 34.
    D. Van Gucht, P.C. Fischer, “High Level Data Manipulation Languages for Unnormalized Relational Database Models”, Tech. Report, Indiana University, 1986.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1989

Authors and Affiliations

  • Anand Deshpande
    • 1
  • Dirk Van Gucht
    • 1
  1. 1.Computer Science DepartmentIndiana UniversityBloomingtonUSA

Personalised recommendations