O-O, What Have They Done to DB2?
Michael J. Carey, Donald D. Chamberlin, Srinivasa Narayanan, Bennet Vance, D. Doole, Serge Rielau, Richard Swagerman, Nelson Mendonça Mattos · 1999
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.