Invention Grant
US08478741B2 Autonomic refresh of a materialized query table in a computer database
有权
在计算机数据库中自动刷新物化查询表
- Patent Title: Autonomic refresh of a materialized query table in a computer database
- Patent Title (中): 在计算机数据库中自动刷新物化查询表
-
Application No.: US11953050Application Date: 2007-12-09
-
Publication No.: US08478741B2Publication Date: 2013-07-02
- Inventor: John Matthew Santosuosso
- Applicant: 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: Martin & Associates LLC
- Agent Bret J. Petersen
- Main IPC: G06F7/00
- IPC: G06F7/00

Abstract:
A method autonomically refreshes a materialized query table (MQT) in a computer database to improve database performance and utility. In preferred embodiments, the query optimizer autonomically initiates a refresh of MQT depending on an estimated time for the query to access the base tables. In other preferred embodiments, the query optimizer estimates the time for the query to access the base tables and compares it to the estimated time to refresh the MQT to determine whether to refresh the MQT and run the query over the MQT rather than the base tables.
Public/Granted literature
- US20080097962A1 APPARATUS AND METHOD FOR AUTONOMIC REFRESH OF A MATERIALIZED QUERY TABLE IN A COMPUTER DATABASE Public/Granted day:2008-04-24
Information query