Sword: Views in Ode 

We have been working on implementing a variety of views methodologies on top of the Ode database system since before the breakup as part of the Sword project.

While many high-level view maintenance algorithms have been proposed, little has been published on nuts-and-bolts implementation details. One aspect of our work has been to develop efficient implementation techniques for materialized views on top of Ode (our SIGMOD 1997 work). Our technique has been extended to allow it to handle nested sets (our Workshop on Materialized Views 1996 work). We also have proposed simple extensions to two-phase locking (2PL) for materialized views to guarantee consistency in the presence of deferred view maintenance (our ICDT 97 work). An implementation of these extensions to 2PL is on-going.

The Views in Ode Team (in alphabetical order):

• Latha Colby
• Akira Kawaguchi
• Daniel Lieuwen
• Inderpal Singh Mumick (AT&T La bs)
• Dallan Quass (Stanford University)
• Ken Ross (Columbia University)

Publications

• A. Kawaguchi, D. Lieuwen, I. S. Mumick, K. Ross. Implementing Incremental View Maintenance in Nested Data Models. Proc. Database Programming Languages, Estes Park, CO, August 18-20, 1997.
• L. Colby, A. Kawaguchi, D. Lieuwen, I. Mumick, and K. Ross. Supporting Multiple View Maintenance Policies. Proc. SIGMOD, May 1997.
• A. Kawaguchi, D. Lieuwen, I. Mumick, D. Quass, and K. Ross. Concurrency Control Theory for Deferred Materialized Views Proc. International Conferance on Database Theory, January 1997.
• A. Kawaguchi, D. Lieuwen, I. Mumick, and K. Ross. View Maintenance in Nested Data Models. Proc. Workshop on Materialized Views, June 1996, (associated with SIGMOD 1996).