Enhancing Existing Incremental View Maintenance Algorithms Using the Multi-Relation Encapsulation Wrapper

Data warehouses (DW) are built by gathering information from several information sources (ISs) and integrating and materializing it into one repository customized to user's needs. Some of the most recently proposed algorithms for the incremental maintenance of such materialized DWs, such as SWEEP and PSWEEP, ooer several signiicant advantages over previous solutions, such as high-performance, no potential for innnite waits and reduced remote queries and thus reduced network and IS loads. However, similar to many other algorithms, they still have the restricting assumption that each IS can be composed of just one single relation. This is unrealistic in practice. In this paper, we hence propose a solution to overcome this restriction. The Multi-Relation Encapsulation (MRE) Wrapper supports multiple relations in information sources in a manner transparent to the rest of the environment. The Multi-Relation Encapsulation Wrapper treats one IS composed of multiple relations as if it were a single relation from the DW point of view; thus it can easily be plugged into existing incremental view maintenance algorithms without any change. Hence, our method maintains all the advantages ooered by existing algorithms in the literature in particular SWEEP and PSWEEP, while also achieving the additional desired features of being non-intrusive, eecient, exible and well-behaved.

[1]  Alejandro P. Buchmann,et al.  Research Issues in Data Warehousing , 1997, BTW.

[2]  D. Agrawal,et al.  E cient View Maintenance at Data Warehouses , 1997 .

[3]  Mukesh K. Mohania,et al.  Incremental Maintenance of Materialized Views , 1997, DEXA.

[4]  Elke A. Rundensteiner,et al.  Psweep: Parallel View Maintenance under Concurrent Data Updates of Distributed Sources Psweep: Parallel View Maintenance under Concurrent Data Updates of Distributed Sources , 1999 .

[5]  Kenneth A. Ross,et al.  Implementing Incremental View Maintenance in Nested Data Models , 1997, DBPL.

[6]  Yue Zhuge,et al.  Distributed and parallel computing issues in data warehousing (abstract) , 1998, SPAA '98.

[7]  Surajit Chaudhuri,et al.  An overview of data warehousing and OLAP technology , 1997, SGMD.

[8]  Mukesh K. Mohania,et al.  Concurrent maintenance of views using multiple versions , 1999, Proceedings. IDEAS'99. International Database Engineering and Applications Symposium (Cat. No.PR00265).

[9]  Inderpal Singh Mumick,et al.  What is the Data Warehousing Problem? (Are Materialized Views the Answer?) , 1996, VLDB.

[10]  Jennifer Widom,et al.  View maintenance in a warehousing environment , 1995, SIGMOD '95.

[11]  Yue Zhuge,et al.  The Strobe algorithms for multi-source warehouse consistency , 1996, Fourth International Conference on Parallel and Distributed Information Systems.

[12]  Jennifer Widom,et al.  Research problems in data warehousing , 1995, CIKM '95.

[13]  Yue Zhuge,et al.  Multiple view consistency for data warehousing , 1997, Proceedings 13th International Conference on Data Engineering.