O-O, What Have They Done to DB2?

11 years 5 months ago
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...
Michael J. Carey, Donald D. Chamberlin, Srinivasa
Added 05 Aug 2010
Updated 05 Aug 2010
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
Comments (0)