Invention Grant
US08346761B2 Method and system for data mining for automatic query optimization 有权
用于自动查询优化的数据挖掘方法和系统

Method and system for data mining for automatic query optimization
Abstract:
A database monitor tracks performance statistics and information about the execution of different SQL statements. A query optimizer benefits from these statistics when generating an access plan. In particular, the query optimizer, upon receiving an SQL statement, searches the records of the database monitor for similar SQL statements that have previously been executed. As part of determining the best access plan for the current SQL statement, the query optimizer considers the information retrieved from the database monitor. In this way, the access plan that is generated can automatically be tuned based on empirical performance evidence.
Public/Granted literature
Information query
Patent Agency Ranking
0/0