Detection and Correction of Conflicting Source Updates for View Maintenance

Data integration over multiple heterogeneous data sources has become increasingly important for modern applications. The integrated data is usually stored in materialized views for better access, performance and high availability. Such views must be maintained after the data sources change. In a loosely-coupled environment, such as the Data Grid, the source updates are autonomous and may cause erroneous maintenance results. State-of-the-art maintenance strategies apply compensating queries to correct such errors. However, they assume that the source schema remain static. This is an unrealistic assumption for such dynamic environments, where the data sources may change not only their data but also their schema, query capabilities or semantics. Consequently, either the maintenance or compensating queries may fail. In this paper, first, we analyze the maintenance errors and classify them into different classes of dependencies. We then propose Dyno, a two-pronged strategy composed of depe...

• Type: Conference
• Year: 2004
• Where: ICDE
• Authors: Songting Chen, Jun Chen, Xin Zhang, Elke A. Rundensteiner
• Keywords: Database, Heterogeneous Data Sources, ICDE 2004, Maintenance Concurrency Problems, Specific Maintenance Algorithms