Abstract
Recent research in extending the standard algebra for nested relations of Thomas and Fischer follows two lines. One is concerned with expressing queries which involve deeply nested information in a flexible way, avoiding the need for explicit restructuring through nesting and unnesting, another deals with extending the expressive power of the nested algebra by providing iteration or recursion constructs, such as fixpoints. These two lines are studied and combined in a natural and general framework.
Similar content being viewed by others
Explore related subjects
Discover the latest articles, news and stories from top researchers in related subjects.References
S. Abiteboul and C. Beeri, On the power of languages for the manipulation of complex objects, Technical Report 846, INRIA (1988).
S. Abiteboul, C. Beeri, M. Gyssens and D. Van Gucht, An introduction to the completeness of languages for complex objects and nested relations, in: ref. [4] pp. 115–138.
S. Abiteboul and N. Bidoit, Non first normal relations: An algebra allowing data restructuring, J. Comput. Syst. Sci. 33(1986)361–393.
S. Abiteboul, P. Fischer and H.-J. Schek (eds.),Nested Relations and Complex Objects in Databases, Lecture Notes in Computer Science 361 (Springer, 1989).
F. Bancilhon and S. Khoshafian, A calculus for complex objects, J. Comput. Syst. Sci., 38(1989)326.
N. Bidoit, The Vero algebra or how to answer queries with fewer joins, J. Comput. Syst. Sci. 35(1987)321–364.
H. Boral and P.A. Larson (eds.),1988 Proc. SIGMOD Int. Conf. on the Management of Data (ACM Press, 1988).
E. Codd, A relational model for large shared databanks, Commun. ACM 13(1970)377–387.
L.S. Colby, A recursive algebra and query optimization for nested relations, in:Proc. 1989 ACM SIGMOD Int. Conf. on the Management of Data, ed. J. Clifford, B. Lindsay and D. Maier (ACM Press, 1989) pp. 273–283.
L.S. Colby, A recursive algebra for nested relations, Inf. Syst. 15(1990)567–582.
P. Fischer, L. Saxton, S. Thomas and D. Van Gucht, Interactions between dependencies and nested relational structures, J. Comput. Syst. Sci. 31(1986)343–354.
M. Gyssens, J. Paredaens and D. Van Gucht, A uniform approach towards handling atomic and structured information in the nested relational database model, J. ACM 36(1989)790–825.
M. Gyssens and D. Van Gucht, The powerset operator as a natural tool to handle nested database relations, J. Comput. Syst, Sci., to appear. An extended abstract appeared under a different title in ref. [7] pp. 225–232.
R. Hull and J. Su, On bulk data type constructors and manipulation primitives: a framework for analyzing expressive power and complexity, in:Proc. 2nd Int. Workshop on Database Programming Languages, ed. R. Hull, R. Morrison and D. Stemple, The Morgan Kaufmann Series in Data Management Systems (Morgan Kaufmann, 1989) pp. 396–410.
G. Jaeshke and H.-J. Schek, Remarks on the algebra of non-first normal form relations, in:1st ACM Sym. on Principles of Database Systems (ACM Press, 1982) pp. 124–138.
J. Paredaens, P. De Bra, M. Gyssens and D. Van Gucht,The Structure of the Relational Database Model, EATCS Monographs on Theoretical Computer Science 17 (Springer, 1989).
M. Roth, H. Korth and A. Silberschatz, Extended algebra and calculus for nested relational databases, ACM Trans. Database Systems 13(1988)389–417.
H.-J. Schek and M.H. Scholl, The relational model with relation-valued attributes, Inf. Syst. 11(1986)137–147.
M.H. Scholl, Theoretical foundations of algebraic optimization utilizing unnormalized relations, in:Proc. Int. Conf. on Database Theory, Lecture Notes in Computer Science 243 (Springer, 1986) pp. 408–420.
S. Thomas and P. Fischer, Nested relational structures, in:The Theory of Databases, ed. P. Kanellakis (JAI Press, 1986) pp. 269–307.
J. Ullman,Principles of Database and Knowledge-Base Systems, Vol. 1 (Computer Science Press, 1988).
J. Ullman,Principles of Database and Knowledge-Base Systems, Vol. 2 (Computer Science Press, 1989).
J. Van den Bussche, Complex object multi-level fixpoint queries, in:Proc. 3rd Symp. on Mathematical Fundamentals of Database and Knowledge Base Systems, Lecture Notes in Computer Science 495 (Springer, 1991) pp. 1–13.
J. Van den Bussche, Evaluation and optimization of complex object selections, in:Proc. 2nd Int. Conf. on Deductive and Object-Oriented Databases, Lecture Notes in Computer Science 566 (Springer, 1991) pp. 226–243.
Author information
Authors and Affiliations
Additional information
A preliminary version of this article appeared as [23]. The work reported in this article was supported by the IWONL and the NFWO.
Rights and permissions
About this article
Cite this article
Van den Bussche, J. Complex object multi-level fixpoint queries. Ann Math Artif Intell 7, 41–62 (1993). https://doi.org/10.1007/BF01556349
Issue Date:
DOI: https://doi.org/10.1007/BF01556349