Research Article
Delta Extraction Optimization for View Maintenance in a Limited Collaborative Environment
@INPROCEEDINGS{10.4108/icst.collaboratecom.2012.250533, author={Zheng Lu and Haijun Liu and Peter Hyland}, title={Delta Extraction Optimization for View Maintenance in a Limited Collaborative Environment}, proceedings={International Workshop on Collaborative Big Data}, publisher={IEEE}, proceedings_a={C-BIG}, year={2012}, month={12}, keywords={delta extraction view maintenance limited collaborative environment}, doi={10.4108/icst.collaboratecom.2012.250533} }- Zheng Lu
Haijun Liu
Peter Hyland
Year: 2012
Delta Extraction Optimization for View Maintenance in a Limited Collaborative Environment
C-BIG
ICST
DOI: 10.4108/icst.collaboratecom.2012.250533
Abstract
This work considers maintaining materialized view in a distributed environment where the collaboration from highly autonomous operational database management systems is limited to granting read only access on a set of selected relational tables. In addition, due to possibly large volumes of remote source data involved in the view maintenance process, and consequently enormous overhead associated with data transfer, efficiency issues must been taken into the consideration. This proposal is based on the observation that usually, there is a large amount of static data in relational tables. It is proposed to use some statistical techniques at data warehouse system to helps us understand the essential characteristics of raw data at remote sites. Based on the characteristics of raw data, some optimization techniques are presented.