O-O, What Have They Done to DB2?

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 developmentproject at the IBM AlmadenResearch Center. In particular, we have 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, we have taken care to design and implement the extensions in such a wayas toretain DB2's abilitytofullyoptimize 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 havemade,discuss the key performancetradeo s related to the design and implementation of these features, and explain the approach that we ended up choosingand 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...

• Type: Conference
• Year: 1999
• Where: VLDB
• Authors: Michael J. Carey, Donald D. Chamberlin, Srinivasa Narayanan, Bennet Vance, Doug Doole, Serge Rielau, Richard Swagerman, Nelson Mendonça Mattos
• Keywords: Database, DB2 UDB, DB2 UDB Product, DB2's Abilitytofullyoptimize Queries, VLDB 1999