Invention Grant
US08346761B2 Method and system for data mining for automatic query optimization
有权
用于自动查询优化的数据挖掘方法和系统
- Patent Title: Method and system for data mining for automatic query optimization
- Patent Title (中): 用于自动查询优化的数据挖掘方法和系统
-
Application No.: US10911849Application Date: 2004-08-05
-
Publication No.: US08346761B2Publication Date: 2013-01-01
- Inventor: Brian Robert Muras , John Matthew Santosuosso
- Applicant: Brian Robert Muras , John Matthew Santosuosso
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Wood, Herron & Evans, LLP
- Main IPC: G06F15/16
- IPC: G06F15/16 ; G06F17/20

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
- US20060031189A1 Method and system for data mining for automatic query optimization Public/Granted day:2006-02-09
Information query