Sciweavers

Share
APWEB
2004
Springer

Using Relational Database Constraints to Design Materialized Views in Data Warehouses

9 years 3 months ago
Using Relational Database Constraints to Design Materialized Views in Data Warehouses
Queries to data warehouses often involve hundreds of complex aggregations over large volumes of data, and so it is infeasible to compute these queries by scanning the data sources each time. Data warehouses therefore build a large number of materialized views to increase system performance. However, materialized views need to be immediately updated when its sources are changed, leading to a possible decrease in system performance. The goal of the materialized view selection problem is to select an appropriate set of views that minimize total query response time as well as the view maintenance cost. In this paper, we develop a solution for identifying the candidate view space of materialization. In particular, we present algorithms for generating a unionview and a partial-view, both of which are good candidates for materialization. The proposed candidate view space guarantees to find a polynomial bounded set of optimal views, and any selection algorithm from previous research, e.g. gree...
Taehee Lee, Jae-young Chang, Sang-goo Lee
Added 30 Jun 2010
Updated 30 Jun 2010
Type Conference
Year 2004
Where APWEB
Authors Taehee Lee, Jae-young Chang, Sang-goo Lee
Comments (0)
books