Browsing by Subject "Data warehousing"
Now showing items 1-1 of 1
-
Materialized views selection using two-phase optimization algorithm
(National Institute of Development Administration, 2009);
A data warehouse (DW) can be defined as a subject-oriented, integrated, nonvolatile and time-variant collection of data, which has value and role for decisionmaking by querying. Queries to DW are critical regarding to their complexity and length. They often access millions of tuples, and involve joins between relations and aggregations. To avoid accessing base tables and increase the speed of queries posed to a DW, we can use some intermediate results from the query processing stored in the DW called materialized views. However, these views have ...