Physical database design for data warehouses
Date Issued
2001
Author(s)
Kon-Popovska, Margita
Abstract
Data warehousing has quickly evolved into a unique and popular
business application class. A data warehouse stores materialized views of data
from one or more remote sources, with the purpose of efficiently implementing
decision support or OLAP (On-Line Analytical Processing) queries. One of more
important decisions in designing data warehouse is the selection of materialized
views to be maintained at the warehouse.
The first part of this paper briefly introduces key concepts surrounding data
warehousing system. The second part studies how to select the set of supporting
views and indexes to materialize to minimize the total query response time and
cost of maintaining the selected views.
business application class. A data warehouse stores materialized views of data
from one or more remote sources, with the purpose of efficiently implementing
decision support or OLAP (On-Line Analytical Processing) queries. One of more
important decisions in designing data warehouse is the selection of materialized
views to be maintained at the warehouse.
The first part of this paper briefly introduces key concepts surrounding data
warehousing system. The second part studies how to select the set of supporting
views and indexes to materialize to minimize the total query response time and
cost of maintaining the selected views.
Subjects
File(s)![Thumbnail Image]()
Loading...
Name
10.1.1.109.2842.pdf
Size
217.48 KB
Format
Adobe PDF
Checksum
(MD5):81653e7915a294b94895eb005731a41b