A Uniform Approach for Selecting Views and Indexes in a Data Warehouse (1997)
| Venue: | In Proceedings of the 1997 International Database Engineering and Applications Symposium |
| Citations: | 4 - 3 self |
BibTeX
@INPROCEEDINGS{Ezeife97auniform,
author = {C. I. Ezeife},
title = {A Uniform Approach for Selecting Views and Indexes in a Data Warehouse},
booktitle = {In Proceedings of the 1997 International Database Engineering and Applications Symposium},
year = {1997},
pages = {151--160}
}
Bookmark
 |
 |
 |
 |
 |
 |
OpenURL
Abstract
Careful selection of aggregate views and some of their most used indexes to materialize in a data warehouse reduces the warehouse query response time as well as warehouse maintenance cost under some storage space constraint. Data Warehouses collect and store large amounts of integrated enterprise data from a number of independent data sources over a long period of time. Warehouse data are used for online analytical processing to assist management in making quick and competitive business decisions. Precomputing and storing summary tables (materialized views) reduces the amount of time needed to recompute these views across several source tables in order to answer complex warehouse queries. A data cube is an elegant way for representing aggregate information in a Warehouse and is an n-dimensional view with 2 n subviews. This paper presents a uniform technique for selecting the subviews of the data cube and their indexes to materialize in order to produce the best resultant benefit to t...
Citations
| 630 | Data cube: A relational aggregation operator generalizing group-by, cross-tab, and sub-totals - Gray, Bosworth, et al. - 1996 |
| 425 | Implementing data cubes efficiently - Harinarayan, Rajaraman, et al. - 1996 |
| 422 | Principles of Distributed Database Systems (2nd Edition - Ozsu, Valduriez - 1999 |
| 228 | Research Problems in Data Warehousing - Widom - 1995 |
| 141 | Index selection for OLAP - Gupta, Harinarayan, et al. - 1997 |
| 75 | Vertical partitioning algorithms for database design - Navathe, Ceri, et al. - 1984 |
| 36 | Problem decomposition and data reorganization by a clustering technique - McCormick, Schweitzer, et al. - 1972 |
| 17 | An objective function for vertically partitioning relations in distributed databases and its .... Distributed and parallel databases - Chakravarthy, Muthuraj, et al. - 1994 |
| 13 | Distributed Object Based Design: Vertical Fragmentation of classes - Ezeife, Barker - 1998 |
| 11 | Planning and Designing the Data Warehouse - Barquin, Edelstein |
