Invention Grant
US07831592B2 System and method for updating database statistics according to query feedback
有权
根据查询反馈更新数据库统计的系统和方法
- Patent Title: System and method for updating database statistics according to query feedback
- Patent Title (中): 根据查询反馈更新数据库统计的系统和方法
-
Application No.: US10904241Application Date: 2004-10-29
-
Publication No.: US07831592B2Publication Date: 2010-11-09
- Inventor: Volker G. Markl , Peter Jay Haas , Ashraf Ismail Aboulnaga , Vijayashankar Raman , Felix Endres
- Applicant: Volker G. Markl , Peter Jay Haas , Ashraf Ismail Aboulnaga , Vijayashankar Raman , Felix Endres
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent Jeffrey T. Holman
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
An autonomic tool that supervises the collection and maintenance of database statistics for query optimization by transparently deciding what statistics to gather, when and in what detail to gather them. Feedback from data-driven statistics collection is simultaneously combined with feedback from query-driven learning-based statistics collection, to better process both rapidly changing data and data that is queried frequently. The invention monitors table activity and decides if the data in a table has changed sufficiently to require a refresh of invalid statistics. The invention determines if the invalidity is due to correlation between purportedly independent data, outdated statistics, or statistics that have too few frequent values. Tables and column groups are ranked in order of statistical invalidity, and a limited computational budget is prioritized by ranking subsequent gathering of improved statistics. Multiple tables can have their statistics refreshed over time, and the maintenance effort is concentrated on the most important tables.
Public/Granted literature
- US20080133454A1 SYSTEM AND METHOD FOR UPDATING DATABASE STATISTICS ACCORDING TO QUERY FEEDBACK Public/Granted day:2008-06-05
Information query