Digital Symposium Collection 2000  

 
 
 
 
 
 

 



















O-O, What Have They Done to DB2?

Michael J. Carey, Donald D. Chamberlin, Srinivasa Narayanan, Bennet Vance, Doug Doole, Serge Rielau, Richard Swagerman, and Nelson Mendonça Mattos

  View Paper (PDF)  

Return to Extending SQL with User Defined Types

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, 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 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 tradeoffs 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.


References

Note: References link to DBLP on the Web.

[1]
Michael J. Carey , David J. DeWitt : Of Objects and Databases: A Decade of Turmoil. VLDB 1996 : 3-14
[2]
Michael J. Carey , David J. DeWitt , Jeffrey F. Naughton , Mohammad Asgarian , Paul Brown , Johannes Gehrke , Dhaval Shah : The BUCKY Object-Relational Benchmark (Experience Paper). SIGMOD Conference 1997 : 135-146
[3]
Michael J. Carey , David J. DeWitt , Scott L. Vandenberg : A Data Model and Query Language for EXODUS. SIGMOD Conference 1988 : 413-423
[4]
Michael J. Carey , Laura M. Haas , Peter M. Schwarz , Manish Arya , William F. Cody , Ronald Fagin , Myron Flickner , Allen Luniewski , Wayne Niblack , Dragutin Petkovic , Joachim Thomas II , John H. Williams , Edward L. Wimmers : Towards Heterogeneous Multimedia Information Systems: The Garlic Approach. RIDE-DOM 1995 : 124-131
[5]
R. G. G. Cattell (Ed.): The Object Database Standard: ODMG 2.0. Morgan Kaufmann 1997
[6]
E. F. Codd : A Relational Model of Data for Large Shared Data Banks. CACM 13(6) : 377-387(1970)
[7]
David J. DeWitt , Jim Gray : Parallel Database Systems: The Future of High Performance Database Systems. CACM 35(6) : 85-98(1992)
[8]
Laura M. Haas , Walter Chang , Guy M. Lohman , John McPherson , Paul F. Wilms , George Lapis , Bruce G. Lindsay , Hamid Pirahesh , Michael J. Carey , Eugene J. Shekita : Starburst Mid-Flight: As the Dust Clears. TKDE 2(1) : 143-160(1990)
[9]
Sandra Heiler , Stanley B. Zdonik : Object Views: Extending the Vision. ICDE 1990 : 86-93
[10]
Won Kim : Object-Oriented Database Systems: Promises, Reality, and Future. VLDB 1993 : 676-687
[11]
Brian A. Nixon , Lawrence Chung , David Lauzon , Alexander Borgida , John Mylopoulos , Martin Stanley : Implementation of a Compiler for a Semantic Data Model: Experiences with Taxis. SIGMOD Conference 1987 : 118-131
[12]
Raghu Ramakrishnan : Database Management Systems. WCB/McGraw-Hill 1998, ISBN 0-07-050775-9
[13]
Michael Stonebraker , Dorothy Moore: Object-Relational DBMSs: The Next Great Wave. Morgan Kaufmann 1996, ISBN 1-55860-397-2
[14]
Michael Stonebraker , Lawrence A. Rowe , Bruce G. Lindsay , Jim Gray , Michael J. Carey , Michael L. Brodie , Philip A. Bernstein , David Beech : Third-Generation Database System Manifesto - The Committee for Advanced DBMS Function. SIGMOD Record 19(3) : 31-44(1990)
[15]
Shalom Tsur , Carlo Zaniolo : An Implementation of GEM - Supporting a Semantic Data Model on a Relational Back-End. SIGMOD Conference 1984 : 286-295
[16]
Carlo Zaniolo : The Database Language GEM. SIGMOD Conference 1983 : 207-218

Referenced by

  1. You-Chin Fuh , Stefan Deßloch , Weidong Chen , Nelson Mendonça Mattos , Brian T. Tran , Bruce G. Lindsay , Linda DeMichel , Serge Rielau , Danko Mannhaupt : Implementation of SQL3 Structured Types with Inheritance and Value Substitutability. VLDB 1999 : 565-574

BIBTEX

@inproceedings{DBLP:conf/vldb/CareyCNVDRSM99,
  author    = {Michael J. Carey and
                Donald D. Chamberlin and
                Srinivasa Narayanan and
                Bennet Vance and
                Doug Doole and
                Serge Rielau and
                Richard Swagerman and
                Nelson Mendon\c{c}a Mattos},
   editor    = {Malcolm P. Atkinson and
                Maria E. Orlowska and
                Patrick Valduriez and
                Stanley B. Zdonik and
                Michael L. Brodie},
   title     = {O-O, What Have They Done to DB2?},
   booktitle = {VLDB'99, Proceedings of 25th International Conference on Very
                Large Data Bases, September 7-10, 1999, Edinburgh, Scotland,
                UK},
   publisher = {Morgan Kaufmann},
   year      = {1999},
   isbn      = {1-55860-615-5},
   pages     = {542-553},
   crossref  = {DBLP:conf/vldb/99},
   bibsource = {DBLP, http://dblp.uni-trier.de} } },


























Copyright(C) 2000 ACM