O-O, What Have They Done to DB2? (1999)
Popular Tags
No tags have been applied to this document.
BibTeX | Add To MetaCart
author = {Michael Carey Don and Michael Carey and Don Chamberlin and Srinivasa Narayanan and Bennet Vance and Doug Doole and Serge Rielau and Richard Swagerman},
title = {O-O, What Have They Done to DB2?},
booktitle = {In VLDB’99, Proceedings of 25th International Conference on Very Large Data Bases},
year = {1999},
pages = {7--10},
publisher = {Morgan Kaufmann}
}
Bookmarks
OpenURL
Abstract:
In this paper, we describe our recent experiences in adding a number of object-relational extensions to the DB2 Universal Database #UDB# system as part of a research and development project at the IBM Almaden Research Center. In particular, wehave enhanced DB2 UDB with support for structured types and tables of these types, type and table hierarchies, references, path expressions, and object views. In doing so, wehave taken care to design and implement the extensions in sucha way as to retain DB2's ability to fully optimize queries and #in our next step# to support business rules and procedures through the provision of constraints and triggers. We describe each of the SQL language extensions that we have made, discuss the key performance tradeo #s related to the design and implementation of these features, and explain the approach that we ended up choosing #and why#. Most of the features described here are currently shipping as part of Version 5.2 of the DB2 UDB product. We end this paper with a summary of the current status of our work and a discussion of what we plan to tackle next.
