Skip to main content
SpringerLink
Log in

A storage structure for Nested Relational Databases

  • Part I System 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

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.

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. 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. 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. 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. F. Bancilhon, P. Richard, M. School, “On Line Processing of Compacted Relations”, Proc.8th VLDB, 1982, 263–269.

    Google Scholar 

  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. N. Bidoit, “Efficient Evaluation of Relational Queries Using Nested Realtions”, Rapports de Recherche, no 480, INRIA, 1986

    Google Scholar 

  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. 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. A. Deshpande, D. Van Gucht, “Storage Structures for Nested Relational Databases”, Technical Report No. 234, Indiana University, Computer Science Department, Bloomington, November 1987

    Google Scholar 

  10. A. Deshpande, D. Van Gucht, “An Implementation for Nested Relational Databases”, Technical Report No. 243, Indiana University, Computer Science Department, Bloomington, February 1988

    Google Scholar 

  11. A. Deshpande, D. Van Gucht, “An Implementation for Nested Relational Databases”, Proceedings of the 14th VLDB, Los Angeles, 1988, pp.76–87

    Google Scholar 

  12. V. Deshpande, P. Larson “An Algebra for Nested Relational Databases” Waterloo Technical Report

    Google Scholar 

  13. G. Houben, J. Paredaens, “The R2-Algebra: An Extension of an Algebra for Nested Relations”, Tech. Rep., Tech. University, Eindhoven, 1987

    Google Scholar 

  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. 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. “Non First Normal Form Relations and Recursive Queries: An SQL-Based Approach”, Proc. 3rd IEEE Int. Conf. on Data Engineering, Los Angeles, 1987

    Google Scholar 

  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. 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. 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. 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. P. Pistor, R. Traunmueller, “A Database Language for Sets, Lists and Tables”, Information Systems 11:4, 1986, pp. 323–336

    Google Scholar 

  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. 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. 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. 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. 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. H.-J. Schek, M.H. Scholl, “The Relational Model with Relation-Valued Attributes”, Information Systems (11:2), 1986

    Google Scholar 

  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. 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. 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. D. Van Gucht, “Theory of Unnormalized Relational Structures”, Ph.D. Dissertation, Vanderbilt University, 1985.

    Google Scholar 

  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. 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. D. Van Gucht, P.C. Fischer, “High Level Data Manipulation Languages for Unnormalized Relational Database Models”, Tech. Report, Indiana University, 1986.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Computer Science Department, Indiana University, 47405, Bloomington, IN, USA

    Anand Deshpande & Dirk Van Gucht

Authors
  1. Anand Deshpande
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Dirk Van Gucht
    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

Deshpande, A., Van Gucht, D. (1989). A storage structure for 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_21

Download citation

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

  • 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