Recommending materialized views and indexes with the IBM DB2 design advisor
暂无分享,去创建一个
Hamid Pirahesh | Sam Lightstone | Daniel C. Zilio | Calisto Zuzarte | Wenbin Ma | Guy M. Lohman | Roberta Cochrane | Latha S. Colby | Jarek Gryz | Eric Alton | Dongming Liang | Gary Valentin | H. Pirahesh | C. Zuzarte | R. Cochrane | D. Zilio | S. Lightstone | G. Lohman | Jarek Gryz | Wenbin Ma | G. Valentin | Dongmin Liang | E. Alton
[1] Inderpal Singh Mumick,et al. Maintenance of Materialized Views: Problems, Techniques, and Applications , 1999, IEEE Data Eng. Bull..
[2] Hamid Pirahesh,et al. fAST refresh using mass query optimization , 2001, Proceedings 17th International Conference on Data Engineering.
[3] Mohamed Ziauddin,et al. Materialized Views in Oracle , 1998, VLDB.
[4] Jeffrey D. Ullman,et al. Implementing data cubes efficiently , 1996, SIGMOD '96.
[5] Daniel C. Zilio,et al. DB2 advisor: an optimizer smart enough to recommend its own indexes , 2000, Proceedings of 16th International Conference on Data Engineering (Cat. No.00CB37073).
[6] Surajit Chaudhuri,et al. Automated Selection of Materialized Views and Indexes in SQL Databases , 2000, VLDB.
[7] Wilburt Labio,et al. Physical database design for data warehouses , 1997, Proceedings 13th International Conference on Data Engineering.
[8] Peter Scheuermann,et al. WATCHMAN : A Data Warehouse Intelligent Cache Manager , 1996, VLDB.
[9] Jennifer Widom,et al. View maintenance in a warehousing environment , 1995, SIGMOD '95.
[10] Graham Wood,et al. Automatic Performance Diagnosis and Tuning in Oracle , 2005, CIDR.
[11] Jian Yang,et al. Algorithms for Materialized View Design in Data Warehousing Environment , 1997, VLDB.
[12] Inderpal Singh Mumick,et al. Selection of Views to Materialize Under a Maintenance Cost Constraint , 1999, ICDT.
[13] Ralph Kimball,et al. The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses , 1996 .
[14] Timos K. Sellis,et al. Data Warehouse Configuration , 1997, VLDB.
[15] Sam Lightstone,et al. DB2 Design Advisor: Integrated Automatic Physical Database Design , 2004, VLDB.
[16] Jeffrey D. Ullman,et al. Index selection for OLAP , 1997, Proceedings 13th International Conference on Data Engineering.
[17] Krithi Ramamritham,et al. Materialized view selection and maintenance using multi-query optimization , 2000, SIGMOD '01.
[18] Nick Roussopoulos,et al. DynaMat: a dynamic view management system for data warehouses , 1999, SIGMOD '99.
[19] Surajit Chaudhuri,et al. Maintenance of Materialized Views: Problems, Techniques, and Applications. , 1995 .
[20] Alejandro P. Buchmann,et al. Research Issues in Data Warehousing , 1997, BTW.
[21] Frank Wm. Tompa,et al. Efficiently updating materialized views , 1986, SIGMOD '86.
[22] Benoît Dageville,et al. Automatic SQL Tuning in Oracle 10g , 2004, VLDB.
[23] Nick Roussopoulos,et al. An incremental access method for ViewCache: concept, algorithms, and cost analysis , 1991, TODS.
[24] Jennifer Widom,et al. Research problems in data warehousing , 1995, CIKM '95.
[25] N. Roussopoulos,et al. The Adms Project: Views \ R " Us , 1995 .
[26] Inderpal Singh Mumick,et al. Selection of Views to Materialize in a Data Warehouse , 2005, IEEE Trans. Knowl. Data Eng..
[27] Nick Roussopoulos,et al. Preliminary Design of ADMS±: A Workstation-Mainframe Integrated Architecture for Database Management Systems , 1986, VLDB.
[28] Kenneth A. Ross,et al. Materialized view maintenance and integrity constraint checking: trading space for time , 1996, SIGMOD '96.