Generating materialized query table candidates
作者： Yefim Shuf , Hong Min , Terence P. Purcell , Zhong Liang Zhang , Xiao Bo Wang
DOI:
关键词:
摘要: Techniques for generating a set of one or more materialized query table (MQT) candidates workload are provided. The techniques include receiving workload, wherein the comprises queries, best matching MQTs (BMQTs) based on blocks queries by removing syntax that is not qualified MQT re-write, determining frequently used multi-joins in using BMQTs and to generate (WMQTs), grouping WMQTs into groups merge smaller number cover workload.
google.co.uk 参考文章(27)
Haifeng Jiang, Dengfeng Gao, Wen-Syan Li, Correlation and parallelism aware materialized view recommendation for heterogeneous, distributed database systems ,(2008)
Benoit Dageville, Abhinav Gupta, Shilpa Lawande, Incremental refresh of materialized views with joins and aggregates after arbitrary DML operations to multiple tables ,(2002)
Terence Patrick Purcell, Performing a multiple table join operating based on generated predicates from materialized results ,(2004)
Vivek Narasayya, Surajit Chaudhuri, Database system index selection using index configuration enumeration for a workload ,(1997)
Shilpa S. Lawande, Recommending materialized views for queries with multiple instances of same table ,(2006)
Wen-Syan Li, Daniele Costante Zilio, Autonomic recommendation and placement of materialized query tables for load distribution ,(2006)
Ruiping Li, Brian Thinh-Vinh Tran, Guogen Zhang, Lee-Chin Hsu Liu, Hsuiying Yen Cheng, Ding-Wei Chieh, Irene Ching-Hua Liu, Yun Wang, Yao-Ching Stephen Chen, Materialized view signature and efficient identification of materialized view candidates for queries ,(2002)
Per-Ake Larson, Jonathan Goldstein, System and method for optimizing queries using materialized views and fast view matching ,(2001)
Yoichi Tsuji, Patrick Dooling Bossman, Chan-Hua Liu, You-Chin Fuh, Shuanglin Guo, Query Workload Statistics Collection in a Database Management System ,(2004)
David E. Simmen, Daniel C. Zilio, Roberta J. Cochrane, Calisto P. Zuzarte, Gary G. Valentin, Samuel S. Lightstone, Hamid Pirahesh, Markos Zaharioudakis, Kit Man Cheung, Ting Y. Leung, Guy M. Lohman, Kevin S. Beyer, Method for recommending indexes and materialized views for a database workload ,(2002)