Complements for Data Warehouses

Authors: 
Laurent, D.; Lechtenborger, J.; Spyratos, N.; Vossen, G.
Author: 
Laurent, D
Lechtenborger, J
Spyratos, N
Vossen, G
Year: 
1999
Venue: 
15th Intl Conf. on Data Engineering (ICDE'99)
URL: 
http://csdl.computer.org/dl/proceedings/icde/1999/0071/00/00710490.pdf
DOI: 
http://doi.ieeecomputersociety.org/10.1109/ICDE.1999.754965
Citations: 
27
Citations range: 
10 - 49
AttachmentSize
Laurent1999ComplementsforData.pdf169.79 KB

Views over databases have recently regained attention in the context of data warehouses, which are seen as materialized views. In this setting, efficient view maintenance is an important issue, for which the notion of self-maintainability has been identified as desirable. In this paper, we extend self-maintainability to (query and update) independence, and we establish an intuitively appealing connection between warehouse independence and view complements. Moreover, we study minimal complements and show how to compute them in the presence of key constraints and inclusion dependencies in the underlying databases. Taking advantage of these complements, an algorithm is outlined for the specification of independent warehouses.