Recommending materialized views and indexes with the IBM DB2 design advisor

Proceedings - International Conference on Autonomic Computing

Volumn , Issue , 2004, Pages 180-187

  Zilio, Daniel C ^a   Zuzarte, Calisto ^a   Lightstone, Sam ^a   Ma, Wenbin ^a   Lohman, Guy M ^b   Cochrane, Roberta J ^b   Pirahesh, Hamid ^b   Colby, Latha ^b   Gryz, Jarek ^c   Alton, Eric ^c   Liang, Dongming ^c   Valentin, Gary ^d  

^a IBM CANADA LTD   (Canada)

^b IBM ALMADEN RESEARCH CENTER   (United States)

^c YORK UNIVERSITY   (Canada)

^d IBM HAIFA RESEARCH LAB   (Israel)

Author keywords

[No Author keywords available]

Indexed keywords

BASE TABLE; DESIGN ADVISOR; MATERIALIZED VIEWS (MVS); QUERY TABLES;

ALGORITHMS; DATABASE SYSTEMS; HEURISTIC METHODS; ITERATIVE METHODS; MAINTENANCE; PROGRAM PROCESSORS; QUERY LANGUAGES; REAL TIME SYSTEMS;

MAGNETIC DISK STORAGE;

EID: 4544348576     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: None     Document Type: Conference Paper

References (30)

1. [ACN00] S. Agrawal, S. Chaudhuri, V. Narasayya. Automated Selection of Materialized Views and Indexes for SQL Databases. VLDB, 2000.
2. [BDD+] R. G. Bello, K. Dias, A. Downing, et al. Materialized Views In Oracle. In Proc. VLDB, 1998.
3. [BLT86] J. A. Blakeley, P.-A. Larson, and F.W. Tompa. Efficiently updating materialized views. SIGMOD, 1986.
4. [CN99] S. Chaudhuri and V. Narasayya. Index Merging. ICDE, 1999.
5. [GHRU97] H. Gupta, V. Harinarayan, A. Rajaraman, and J. Ullman. Index selection in OLAP. ICDE, 1997
6. [GM95] A. Gupta, and I. S. Mumick. Maintenance of Materialized views: Problems, Techniques, and Applications, Data Engineering Bulletin, June 1995.
7. [GM98] A. Gupta, and I. S. Mumick. Editors. Materialized Views: MIT Press. 1998.
8. [Gup97] H. Gupta. Selection of views to materialize in a data warehouse. ICDT, Delphi, Greece, 1997.
9. [GM99] H. Gupta, and I. S. Mumick. Selection of Views to Materialize under a Maintenance Cost Constraint. ICDT, Jerusalam, January 1999
10. [HGW+95] J. Hammer, H. Carcia-Molina, J.Widom, W. Labio, and Y. Zhuge. The Stanford Data Warehouse Project. IEEE Data Eng. Bulletin, Specail Issue on Materialized Views and Data Warehousing, 1995.
11. [HRU96] V. Harinarayan, A. Rajaraman, and J. Ullman. Implementing data cubes efficiently. SIGMOD, June 1996.
12. [Kim96] Kimball, R., The Data Warehouse Toolkit, Join Wiley, 1996.
13. [KR99] Y. Kotidis and N. Roussopoulos. DynaMat: A Dynamic View Management System for Data Warehouse. SIGMOD, 1999
14. [LCPZ01] W. Lehner, B. Cochrane, H. Pirahesh, M. Zaharioudakis. Applying Mass Query Optimization to Speed up Automatic Summary Table Refresh. ICDE 2001.
15. [LQA97] W. J. Labio, D. Quass, and B. Adelberg. Physical Database Design for Data Warehouse. ICDE, 1997.
16. [MRSR01] H. Mistry, P. Roy, S. Sudarshan, K. Ramamritham. Materialized View Selection and Maintenance Using Multi-Query Optimization. SIGMOD 2001.
17. [Mum95] I. Mumick. The Rejuvenation of Materialized Views. In CISMOD. 1995.
18. [Oracle] http://www.oracle.com/
19. [R+95] N. Roussopoulos, et al. The ADMS project: Views "R" Us. In IEEE Data Engineering Bulletin, June 1995.
20. [RedBrick] http://www.informix.com/informix/solutions/dw/redbrick/vista/
21. [RK86] N. Roussopoulos and H. Kang. Preliminary design of ADMS+-: A workstation-mainframe integrated architecture for database management systems. VLDB, 1986.
22. [Rou91] N. Roussopoulos. An Incremental Access Method for ViewCache: Concept, Algorithms, and Cost Analysis. ACM TODS, 1991.
23. [RSS96] K. A. Ross, Divesh Srivastava, and S. Sudarshan. Materialized view maintenance and integrity constraint checking: Trading space for time. SIGMOD, 1996.
24. [SSV96] P. Scheuermann, J. Shim, and R. Vingrlek. WATCHMAN: A Data Warehouse Intelligent Cache Manager. VLDB, 1996.
25. [TS97] D. Theodoratos and T. Sellis. Data warehouse configuration. VLDB, 1997.
26. [VZZLS00] G. Valentin, M. Zuliani, D. C. Zilio, G. Lohman, and A. Skelley. DB2 Advisor: An Optimizer Smart Enough to Recommend its own Indexes. ICDE, San Diego, CA, Feb. 2000.
27. [WB97] M. C. Wu, A. P. Buchmann. Research Issues in Data Warehousing, BTW'97, Ulm, March 1997.
28. [Wid95] J. Widom. Research problems in data warehousing. In Proc. Of the Intl. Conf. On Information and Knowledge Management, 1995.
29. [YKL97] J. Yang, K. Karlapalem, and Q. Li. Algorithms for materialized view design in data warehousing environment. VLDB, 1997.
30. [ZGHW95] Y. Zhuge, H. Garcia-Molina, J. Hammer, and J. Widom. View maintenance in a warehousing environment. ACM SIGMOD 1995, pages 316-327.