Abstract
In this paper, we describe the design and implementation of object views in IBM’s DB2 Universal Database system. We first describe the object-oriented aspects of DB2’s type system, their implications for views, and our design requirements. We then describe DB2’s object view facility, showing its use to create object views of object data and of legacy relational data. We discuss key aspects of its implementation, explaining how the correctness of object view definitions is checked and how we ensure that queries against object views are translated into efficient queries against the underlying stored database. We close by discussing the current status of object views in DB2.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
S. Abiteboul and T. Bonner. Objects and views. In Proceedings SIGMOD Conference, Denver, Colorado, pages 238–247, 1991.
R. Agrawal and L. DeMichiel. Type derivation using the projection operation. In Proceedings EDBT Conference, Cambridge, UK, pages 7–14, 1994.
M. Carey and D. DeWitt. Of objects and databases: A decade of turmoil. In Proceedings VLDB Conference, Mumbai (Bombay), India, pages 3–14, 1996.
M. Carey et al. O-O, what have they done to DB2? In Proceedings VLDB Conference, Edinburgh, Scotland, 1999.
M. Carey, L. Haas, P. Schwarz, et al. Towards heterogeneous multimedia information systems: The Garlic approach. In Proceedings IEEE RIDE-DOM Workshop, Taipei, Taiwan, pages 124–131, 1995.
M. Carey and J. Kiernan. Extending SQL-92 for OODB access: Design and implementation experience. In Proceedings ACM OOPSLA Conference, Austin, Texas, pages 467–480, 1995.
E. Codd. A relational model of data for large shared data banks. Commun. ACM, 13(6):377–387, 1970.
A. Eisenberg and J. Melton. SQL:1999, formerly known as SQL3. ACM SIGMOD Record, 28(1):131–138, 1999.
Y. Fuh et al. Implementation of SQL3 structured types with inheritance and value substitutability. In Proceedings VLDB Conference, Edinburgh, Scotland, 1999.
S. Heiler and S. Zdonik. Object views: Extending the vision. In Proceedings ICDE, Los Angeles, California, pages 86–93, 1990.
M. Kifer, W. Kim, and S. Sagiv. Querying object-oriented databases. In Proceedings SIGMOD Conference, San Diego, California, pages 393–402, 1992.
W. Kim. Object-oriented database systems: Promises, reality, and future. In Proceedings VLDB Conference, Dublin, Ireland, pages 676–687, 1993.
R. Ramakrishnan. Database Management Systems. McGraw-Hill, 1997.
M. Scholl, C. Laasch, and M. Tresch. Updatable views in object-oriented databases. In Proceedings DOOD-91 Conference, Munich, Germany, pages 189–207, 1991.
M. Stonebraker and P. Brown. Object-Relational DBMSs (2nd Edition). Morgan Kaufmann, 1998.
M. Stonebraker et al. Third-generation database system manifesto. ACM SIGMOD Record, 19(3):31–44, 1990.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2000 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Carey, M., Rielau, S., Vance, B. (2000). Object View Hierarchies in DB2 UDB. In: Zaniolo, C., Lockemann, P.C., Scholl, M.H., Grust, T. (eds) Advances in Database Technology — EDBT 2000. EDBT 2000. Lecture Notes in Computer Science, vol 1777. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-46439-5_33
Download citation
DOI: https://doi.org/10.1007/3-540-46439-5_33
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-67227-2
Online ISBN: 978-3-540-46439-6
eBook Packages: Springer Book Archive