Object View Hierarchies in DB2 UDB

In this paper, we describe the design and implementation of object views in IBM's DB2 Universal Database system. We first describe the object-oriented aspects of DB2's type system, their implications for views, and our design requirements. We then describe DB2's object view facility, showing its use to create object views of object data and of legacy relational data. We discuss key aspects of its implementation, explaining how the correctness of object view definitions is checked and how we ensure that queries against object views are translated into efficient queries against the underlying stored database. We close by discussing the current status of object views in DB2.

[1]  Jim Melton,et al.  SQL: 1999, formerly known as SQL3 , 1999, SGMD.

[2]  Stanley B. Zdonik,et al.  Object views: Extending the vision , 1990, [1990] Proceedings. Sixth International Conference on Data Engineering.

[3]  Michael Kifer,et al.  Querying object-oriented databases , 1992, SIGMOD '92.

[4]  Rakesh Agrawal,et al.  Type derivation using the projection operation , 1994, Inf. Syst..

[5]  Markus Tresch,et al.  Updatable Views in Object-Oriented Databases , 1991, DOOD.

[6]  Michael Stonebraker,et al.  Object-Relational DBMSs: Tracking the Next Great Wave , 1998 .

[7]  Bruce G. Lindsay,et al.  Implementation of SQL3 Structured Types with Inheritance and Value Substitutability , 1999, VLDB.

[8]  Laura M. Haas,et al.  Towards heterogeneous multimedia information systems: the Garlic approach , 1995, Proceedings RIDE-DOM'95. Fifth International Workshop on Research Issues in Data Engineering-Distributed Object Management.

[9]  Raghu Ramakrishnan,et al.  Database Management Systems , 1976 .

[10]  Serge Abiteboul,et al.  Objects and views , 1991, SIGMOD '91.

[11]  Won Kim.  Object-Oriented Database Systems: Promises, Reality, and Future , 1995, Modern Database Systems.

[12]  Michael Stonebraker,et al.  Third-generation database system manifesto , 1990, SGMD.

[13]  Michael J. Carey,et al.  O-O, What Have They Done to DB2? , 1999, VLDB.

[14]  David J. DeWitt,et al.  Of Objects and Databases: A Decade of Turmoil , 1996, VLDB.

[15]  Michael J. Carey,et al.  Extending SQL-92 for OODB access: design and implementation experience , 1995, OOPSLA.

[16]  E. F. Codd,et al.  A relational model of data for large shared data banks , 1970, CACM.