Home | Repositories | Statistics | About



Subject: data warehouses, physical database design, data cube, view selection


Year: 2001


Type: Proceedings



Title: Physical database design for data warehouses


Author: Velinov, Goran
Author: 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.


Publisher: Institute of Informatics, Faculty of Natural Sciences and Mathematics, Ss. Cyril and Methodius University in Skopje, Macedonia


Relation: Second International Conference on Informatics and Information Technology



Identifier: oai:repository.ukim.mk:20.500.12188/23300
Identifier: http://hdl.handle.net/20.500.12188/23300



TitleDateViews
Physical database design for data warehouses200130