Apparatus and method for analyzing query optimizer performance
作者： Brian Hagenbuch , Sivaramakrishnan Narayanan , Florian Michael Waas , Chad William Whipkey
DOI:
关键词: Query optimization 、 Event trigger 、 Object (computer science) 、 Computer science 、 Data mining
摘要: A method of analyzing the performance a query optimizer includes identifying an event trigger. reproduction object characterizing operational parameters customer computer at time trigger is populated. The transported from to test computer. analyzed characterize optimizer.
lens.org 参考文章(26)
Nancy L. Green, Database query code generation and optimization based on the cost of alternate access methods ,(1984)
Ramanujam Seshadri Halasipuram, Edwin Anthony Seputis, Query Optimization with Memory I/O Awareness ,(2009)
Edwin Anthony Seputis, Mihnea Andrei, Xun Cheng, Xiao Ming Zhou, System and methodology for automatic tuning of database query optimizer ,(2007)
Ramakumar Kosuru, Renu Varshneya, Awny K Al-Omari, Robert L. Wall, Skew-based costing for database queries ,(2008)
Dushyanth Narayanan, Eno Thereska, Predicting database system performance ,(2005)
Walid Rjaibi, Calisto Paul Zuzarte, John F. Hornibrook, John E. Lumby, A system and process for evaluating the performance of a database system ,(1999)
Alexander G. Balikov, Viatcheslav Krassovsky, Dmitry Sonkin, API for programmatic retrieval and replay of database trace ,(2004)
Philippe Richard, System and method for managing and updating data from a number of sources for a project ,(2008)
Patrick Dooling Bossman, Chan-Hua Liu, Jie Zhang, Yun Wang, Ping Wang, You-Chin Fuh, Method, system, and program for performance tuning a database query ,(2003)
Vivek Narasayya, Surajit Chaudhuri, Ravishankar Ramamurthy, Detecting estimation errors in dictinct page counts ,(2008)