View materialization vs. indexing: Balancing space constraints in data warehouse design

Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

Volumn 2681, Issue , 2003, Pages 502-519

  Rizzi, Stefano ^a   Saltarelli, Ettore ^a  

^a UNIVERSITY OF BOLOGNA   (Italy)

Author keywords

[No Author keywords available]

Indexed keywords

ECONOMIC AND SOCIAL EFFECTS; INDEXING (OF INFORMATION);

COMPARATIVE EVALUATIONS; DISK SPACE; INDEXING ALGORITHMS; QUERY PERFORMANCE; SPACE CONSTRAINTS; TRADE OFF; VIEW MATERIALIZATIONS; WAREHOUSE DESIGN;

DATA WAREHOUSES;

EID: 35248812451     PISSN: 03029743     EISSN: 16113349     Source Type: Book Series    
DOI: 10.1007/3-540-45017-3_34     Document Type: Review

References (16)

1. S. Agrawal, S. Chaudhuri, and V. Narasayya. Automated selection of materialized views and indexes for SQL databases. In Proc. 26th VLDB, pages 496-501, Cairo, Egypt, 2000.
2. E. Baralis, S. Paraboschi, and E. Teniente. Materialized view selection in multidimensional database. In Proc. 23rd VLDB, pages 156-165, Athens, 1997.
3. A.F. Cardenas. Analysis and performance of inverted database structures. Communications of the ACM, 18(5):253-263, 1975.
4. M. Golfarelli, S. Rizzi, and E. Saltarelli. Index selection for data warehousing. In Proc. DMDW, Toronto, 2002.
5. A. Gupta, V. Harinarayan, and D. Quass. Aggregate-query processing in data warehousing environments. In Proc. 21st VLDB, Zurich, 1995.
6. H. Gupta. Selection of views to materialize in a data warehouse. In Proc. ICDT, pages 98-112, 1997.
7. H. Gupta, V. Harinarayan, A. Rajaraman, and J.D. Ullman. Index selection for OLAP. In Proc. ICDE, pages 208-219, 1997.
8. H. Gupta and I.S. Mumick. Selection of views to materialize under a maintenance cost constraint. In Proc. ICDT, Jerusalem, Israel, 1999.
9. V. Harinarayan, A. Rajaraman, and J. Ullman. Implementing data cubes efficiently. In Proc. ACM SIGMOD Conf., Montreal, 1996.
10. Informix. Informix Red Brick Decision Server administrator's guide, Version 6.0, November 1999.
11. W.J. Labio, D. Quass, and B. Adelberg. Physical database design for data warehouses. In Proc. ICDE, pages 277-288, 1997.
12. V. Markl, F. Ramsak, and R. Pieringer. The TransBase HyperCube RDBMS: multi-dimensional indexing of relational tables. In Proc. 17th ICDE, Heidelberg, Germany, 2001.
13. P. O'Neil and G. Graefe. Multi-table joins through bitmapped join indices. SIGMOD Record, 24(3):8-11, 1995.
14. P. O'Neil and D. Quass. Improved query performance with variant indexes. In Proc. ACM SIGMOD Int. Conf. on Management of Data, Tucson, AZ, 1997.
15. M. Poess and C. Floyd. New tpc benchmarks for decision support and web commerce. ACM SIGMOD Record, 29(4), 2000.
16. D. Theodoratos and M. Bouzeghoub. A general framework for the view selection problem for data warehouse design and evolution. In Proc. DOLAP, McLean, 2000.