Abstract
Traditional database query algebras usually have only one special sort to describe database and result structures, for example the sort ‘relation’ in relational algebra. For the new developments concerning object-oriented and extensible database systems, it seems to be more appropriate to define a many-sorted algebra based on several primitive domain algebras and type constructors like sets or lists. In this paper, we present the denotational semantics of QUAL expressions using an abstract data type framework. QUAL is a many-sorted query algebra defined as a query formalism for the structural part of the OBLOG object model. The abstract data type semantics of QUAL allows easy extension of the structural part of OBLOG models by new domain data types and new type constructors.
This work was partially supported by CEC under ESPRIT-II Basic Research Action Working Group No. 3023 IS-CORE (Information Systems — COrrectness and REusability). The work of Ralf Jungclaus is supported by Deutsche Forschungsgemeinschaft under Sa 465/1-1.
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Abiteboul, S., Bidoit, N.: Non First Normal Form Relations: An Algebra Allowing Data Restructuring. J. of Computer and System Science. Vol. 33, 1986, 361–393.
Atkinson, M., Bancilhon, F., DeWitt, D., Dittrich, K., Maier, D., Zdonik, S.: The Object-Oriented Database System Manifesto. Proc. DOOD'89 (W.Kim, J.-M.Nicolas, S.Nishio, eds.). Kyoto, 1989, 40–57.
Banerjee, J., Kim, W., Kim, K.-C.: Queries in Object-Oriented Databases. Proc. IEEE Data Engineering. Los Angeles, 1988, 31–38.
Beeri, C.: A Formal Approach to Object Oriented Databases. Data & Knowledge Engineering. Vol. 5, No. 4, 1990, 353–382.
Ceri, S., et al: The Algres Project. Proc. EDBT'88. Springer-Verlag, 1988, 551–555.
Cluet, S., Delobel, C., Lécluse, C., Richard, P.: Reloop, an Algebra Based Query Language for an Object-Oriented Database System. Data & Knowledge Engineering. Vol. 5, No. 4, 1990, 333–352.
Codd, E. F.: A Relational Model of Data for Large Shared Data Banks. Communications ACM. Vol. 13, No. 6, 67–89.
Codd, E. F.: Extending the Database Relational Model to Capture More Meaning. ACM Transactions on Database Systems. Vol. 4, No. 4, 1979, 397–434.
Dadam, P., Küspert, K., et al: A DBMS Prototype to Support Extended NF2-Relations: An Integrated View on Flat Tables and Hierarchies. Proc. SIGMOD Conf. on Management of Data. Washington, D.C. 1986, 356–367.
Dadam, P., Linnemann, V.: Advanced Information Management (AIM): Advanced Database Technology for Integrated Applications. IBM Systems Journal. Vol. 28, No. 4, 1989, 661–681.
Deshpande, V., Larson, P.: An Algebra for Nested Relational Databases. Techn. Report CS-87-65, Univ. of Waterloo, 1987.
Ehrig, H., Mahr, B.: Fundamentals of Algebraic Specification 1. Equations and Initial Semantics. Springer-Verlag, Berlin 1985.
Ehrich, H.-D., Sernadas, A., Sernadas, C.: From Data Types to Object Types. Journal on Information Processing and Cybernetics EIK. Vol. 26, No. 1/2, 1990, 33–48.
Fiadeiro, J., Sernadas, C., Maibaum, T., Saake, G.: Proof-Theoretic Semantics of Object-Oriented Specification Constructs. In:
Fischer, P. C., Thomas, S. J.: Operators for Non First Normal Form Relations. Proc. IEEE Computer Software and Applications Conf. 1983. IEEE 1983, 464–475.
Güting, R. H.: Geo-Relational Algebra: A Model and Query Language for Geometric Database Systems. Proc. EDBT'88. Springer Verlag, 1988, 506–527.
Güting, R. H., Zicari, R., Choy, D. M.: An Algebra for Structured Office Documents. ACM Transactions on Information Systems. Vol. 7, Nr. 2, 1989, 123–157.
Gyssens, M., Van Gucht, D.: The Powerset Algebra as a Result of Adding Programming Constructs to the Nested Relational Algebra. Proc. SIGMOD Conf. on Management of Data 1988. Chicago 1988, 225–232.
Heuer, A., Scholl, M.H.: Principles of Object-Oriented Query Languages. Proc. BTW'91, Kaiserslautern 1991. Springer-Verlag, 1991. (In print).
Hohenstein, U., Gogolla, M.: A Calculus for an Extended Entity-Relationship Model Incorporating Abitrary Data Operations and Aggregate Functions. Proc. 7th Int. Conf. on the ER Approach, Rome 1988. North-Holland, 1988, 129–148.
Jaeschke, G.: Nonrecursive Algebra for Relations with Relation Valued Attributes. TR 85.003.001, IBM Scientific Center Heidelberg, 1985.
Jaeschke, G., Schek, H.-J.: Remarks on the Algebra on Non First Normal Form Relations. Proc. Symp. on Princ. of Database Systems 1982. Los Angeles 1982, 124–138.
Jungclaus, R., Saake, G., Sernadas, C.: Using Active Objects for Query Processing. In:
Jungclaus, R., Saake, G., Sernadas, C.: Formal Specification of Object Systems. Proc. TAPSOFT'91. Brighton, 1991, Springer-Verlag (In print).
Khoshafian, S., Copeland, G. P.: Object Identity. Proc. OOPSLA'86. (ACM SIGPLAN Notices, Vol. 21, No. 11, 1986), 406–416.
Makinouchi, A.: A Consideration of Normal Form of Not-Necessarily-Normalized Relations. Proc. VLDB'77. Tokyo, 1977, 447–453.
Meersman, R., Kent, W. (eds.): Proc. IFIP TC2 Work. Conf. on Object-Oriented Databases (DS-4). Windermere 1990, North-Holland, Amsterdam (In print).
Milner, R.: A Theory of Type-Polymorphism in Programming. Journal of Computer and System Science. Vol. 17, 1978, 348–375.
Özsoyoğlu, G., Özsoyoğlu, Z. M., Matos, V.: Extending Relational Algebra and Relational Calculus with Set-Valued Attributes and Aggregate Functions. ACM Transactions on Database Systems. Vol. 12, No. 4, 1987, 566–592.
Pistor, P., Andersen, F.: Designing a Generalized NF2 Model with an SQL-Type Interface. Proc. VLDB'86. Kyoto, 1986, 278–288.
Pistor, P., Traunmüller, R.: A Database Language for Sets, Lists, and Tables. Information Systems. Vol. 11, 1986, 323–336.
Roth, M. A., Korth, H. F., Silberschatz, A.: Extended Algebra and Calculus for ¬1NF Relational Databases. ACM ToDS. Vol. 13, No. 4, 1988, 389–417.
Saake, G., Jungclaus, R.: Information about Objects versus Derived Objects. Proc. 2nd Workshop on Foundations of Models and Languages for Data and Objects, Aigen (J.Göers, A.Heuer, eds.). Informatik-Bericht 90/3, TU Clausthal, 1990, 59–70.
Schek, H.J., Scholl, M.: An Algebra for the Relational Model with Relation-Valued Attributes. Information Systems. Vol. 11, 1986, 137–147.
Sernadas, A., Ehrich, H.-D.: What is an Object, After All? In:
Sernadas, A., Sernadas, C., Ehrich, H.-D.: Object-Oriented Specification of Databases: An Algebraic Approach. Proc. VLDB'87. Brighton 1987, 107–116.
Sernadas, A., Fiadeiro, J., Sernadas, C., Ehrich, H.-D.: The Basic Building Blocks of Information Systems Information Systems Concepts: In-Depth Analysis (Falkenberg, E., Lindgreen, P. (eds.)). North-Holland, Amsterdam 1989, 225–246.
Shaw, G., Zdonik, S.: An Object-Oriented Query Algebra. Proc. 2nd Int. Workshop on Database Programming Languages. Portland, 1989.
Saake, G., Linnemann, V., Pistor, P., Wegner, L.: Sorting, Grouping, and Duplicate Elimination in the Advanced Information Management Prototype. Proc. VLDB'89 (P.M.G. Apers, G. Wiederhold, eds.). Amsterdam 1989, 307–316.
Zdonik, S. B., Maier, D. (eds.): Readings in Object-Oriented Database Systems. Morgan-Kaufmann, Palo Alto 1989.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1991 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Saake, G., Jungclaus, R., Sernadas, C. (1991). Abstract data type semantics for many-sorted object query algebras. In: Thalheim, B., Demetrovics, J., Gerhardt, H.D. (eds) MFDBS 91. MFDBS 1991. Lecture Notes in Computer Science, vol 495. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-54009-1_21
Download citation
DOI: https://doi.org/10.1007/3-540-54009-1_21
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-54009-0
Online ISBN: 978-3-540-47348-0
eBook Packages: Springer Book Archive