Physical Database Design for Data Warehouses

Velinov, Goran and Kon-Popovska, Margita (2001) Physical Database Design for Data Warehouses. In: Proceedings of the Second Conference on Informatics and Information Technology. Institute of Informatics, Faculty of Natural Sciences and Mathematics, Ss. Cyril and Methodius University in Skopje, Macedonia, Skopje, Macedonia, pp. 318-334. ISBN 9989-668-28-0

[img]
Preview
Text
9989-668-28-0_pp318-334.pdf

Download (222kB) | Preview
Official URL: http://ciit.finki.ukim.mk

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.

Item Type: Book Section
Uncontrolled Keywords: data warehouses, physical database design, data cube, view selection
Subjects: International Conference on Informatics and Information Technologies > Information Technology
Depositing User: Vangel Ajanovski
Date Deposited: 28 Oct 2016 00:15
Last Modified: 28 Oct 2016 00:15
URI: http://eprints.finki.ukim.mk/id/eprint/11115

Actions (login required)

View Item View Item