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.
Similar content being viewed by others
References
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.
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.
F. Bancilhon, S. Khoshafian, “A Calculus for Complex Objects” Proc. Fifth ACM SIGACT-SIGMOD Symposium on Principles of Database Systems, 1986, 53–59.
F. Bancilhon, P. Richard, M. School, “On Line Processing of Compacted Relations”, Proc.8th VLDB, 1982, 263–269.
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.
N. Bidoit, “Efficient Evaluation of Relational Queries Using Nested Realtions”, Rapports de Recherche, no 480, INRIA, 1986
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.
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.
A. Deshpande, D. Van Gucht, “Storage Structures for Nested Relational Databases”, Technical Report No. 234, Indiana University, Computer Science Department, Bloomington, November 1987
A. Deshpande, D. Van Gucht, “An Implementation for Nested Relational Databases”, Technical Report No. 243, Indiana University, Computer Science Department, Bloomington, February 1988
A. Deshpande, D. Van Gucht, “An Implementation for Nested Relational Databases”, Proceedings of the 14th VLDB, Los Angeles, 1988, pp.76–87
V. Deshpande, P. Larson “An Algebra for Nested Relational Databases” Waterloo Technical Report
G. Houben, J. Paredaens, “The R2-Algebra: An Extension of an Algebra for Nested Relations”, Tech. Rep., Tech. University, Eindhoven, 1987
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.
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.
“Non First Normal Form Relations and Recursive Queries: An SQL-Based Approach”, Proc. 3rd IEEE Int. Conf. on Data Engineering, Los Angeles, 1987
M. Missikoff, “A Domain Based Internal Schema for Relational Database Machines”, Proc. ACM SIGMOD Int'l Conf. on Management of Data, 1982, 215–224.
M. Missikoff and M. Scholl, “Relational Queries in Domain Based DBMS”, Proc. ACM SIGMOD Int'l Conf. on Management of Data, 1983, 219–227.
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.
P. Pistor, F. Andersen, “Designing a Generalizied NF2 Model with an SQL-Type Language Interface”, Proc. 12th VLDB, Kyoto, Japan, 1986, pp. 278–288.
P. Pistor, R. Traunmueller, “A Database Language for Sets, Lists and Tables”, Information Systems 11:4, 1986, pp. 323–336
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.
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.
H.J. Schek, “Towards a Basic Relational NF2 Algebra Processor”, Proc. of the International Conference of Data Organization, Kyoto, Japan, 1985, 173–182.
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.
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.
H.-J. Schek, M.H. Scholl, “The Relational Model with Relation-Valued Attributes”, Information Systems (11:2), 1986
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.
M.H. Scholl, H.-B. Paul, H.-J. Schek “Supporting Flat Relations by a Nested Relational Kernel” Proc. 13th VLDB, London, 87.
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.
D. Van Gucht, “Theory of Unnormalized Relational Structures”, Ph.D. Dissertation, Vanderbilt University, 1985.
D. Van Gucht, P.C. Fischer, “MVDs, Weak MVDs and Nested Relational Structures”, Technical Report CS-84-19, Vanderbilt University, 1984.
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.
D. Van Gucht, P.C. Fischer, “High Level Data Manipulation Languages for Unnormalized Relational Database Models”, Tech. Report, Indiana University, 1986.
Author information
Authors and Affiliations
Editor information
Rights 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