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