Materialized Views Selection in a Multidimensional Database.
Elena Baralis, Stefano Paraboschi, Ernest Teniente:
Materialized Views Selection in a Multidimensional Database.
VLDB 1997: 156-165@inproceedings{DBLP:conf/vldb/BaralisPT97,
author = {Elena Baralis and
Stefano Paraboschi and
Ernest Teniente},
editor = {Matthias Jarke and
Michael J. Carey and
Klaus R. Dittrich and
Frederick H. Lochovsky and
Pericles Loucopoulos and
Manfred A. Jeusfeld},
title = {Materialized Views Selection in a Multidimensional Database},
booktitle = {VLDB'97, Proceedings of 23rd International Conference on Very
Large Data Bases, August 25-29, 1997, Athens, Greece},
publisher = {Morgan Kaufmann},
year = {1997},
isbn = {1-55860-470-7},
pages = {156-165},
ee = {db/conf/vldb/BaralisPT97.html},
crossref = {DBLP:conf/vldb/97},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
Abstract
A multidimensional database is a data repository that supports the
efficient execution of complex business decision queries. Query
response can be significantly improved by storing an appropriate set
of materialized views. These views are selected from the
multidimensional lattice whose elements represent the solution space
of the problem.
Several techniques have been proposed in the past to perform the
selection of materialized views for databases with a reduced number of
dimensions. When the number and complexity of dimensions increase,
the proposed techniques do not scale well.
The technique we are proposing reduces the solution space by
considering only the relevant elements of the multidimensional
lattice. An additional statistical analysis allows a further
reduction of the solution space.
Copyright © 1997 by the VLDB Endowment.
Permission to copy without fee all or part of this material is granted provided that the copies are not made or
distributed for direct commercial advantage, the VLDB
copyright notice and the title of the publication and
its date appear, and notice is given that copying
is by the permission of the Very Large Data Base
Endowment. To copy otherwise, or to republish, requires
a fee and/or special permission from the Endowment.
Online Paper
CDROM Version: Load the CDROM "Volume 1 Issue 5, VLDB '89-'97" and ...
DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...
Printed Edition
Matthias Jarke, Michael J. Carey, Klaus R. Dittrich, Frederick H. Lochovsky, Pericles Loucopoulos, Manfred A. Jeusfeld (Eds.):
VLDB'97, Proceedings of 23rd International Conference on Very Large Data Bases, August 25-29, 1997, Athens, Greece.
Morgan Kaufmann 1997, ISBN 1-55860-470-7
Contents
Electronic Edition
From CS Dept.,
University Trier (Germany)
References
- [AAD+96]
- Sameet Agarwal, Rakesh Agrawal, Prasad Deshpande, Ashish Gupta, Jeffrey F. Naughton, Raghu Ramakrishnan, Sunita Sarawagi:
On the Computation of Multidimensional Aggregates.
VLDB 1996: 506-521
- [GBLP96]
- Jim Gray, Adam Bosworth, Andrew Layman, Hamid Pirahesh:
Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Total.
ICDE 1996: 152-159
- [GHRU97]
- Himanshu Gupta, Venky Harinarayan, Anand Rajaraman, Jeffrey D. Ullman:
Index Selection for OLAP.
ICDE 1997: 208-219
- [Gup97]
- Himanshu Gupta:
Selection of Views to Materialize in a Data Warehouse.
ICDT 1997: 98-112
- [HRU96]
- Venky Harinarayan, Anand Rajaraman, Jeffrey D. Ullman:
Implementing Data Cubes Efficiently.
SIGMOD Conference 1996: 205-216
- [Kim96]
- Ralph Kimball:
The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses.
John Wiley 1996, ISBN 0-471-15337-0
- [RSS96]
- Kenneth A. Ross, Divesh Srivastava, S. Sudarshan:
Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time.
SIGMOD Conference 1996: 447-458
- [SDNR96]
- Amit Shukla, Prasad Deshpande, Jeffrey F. Naughton, Karthikeyan Ramasamy:
Storage Estimation for Multidimensional Aggregates in the Presence of Hierarchies.
VLDB 1996: 522-531
- [Wid95]
- ...
- [ZGHW95]
- Yue Zhuge, Hector Garcia-Molina, Joachim Hammer, Jennifer Widom:
View Maintenance in a Warehousing Environment.
SIGMOD Conference 1995: 316-327
Copyright © Tue Mar 16 02:22:06 2010
by Michael Ley (ley@uni-trier.de)