Invention Grant
US08478741B2 Autonomic refresh of a materialized query table in a computer database 有权
在计算机数据库中自动刷新物化查询表

Autonomic refresh of a materialized query table in a computer database
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.
Information query
Patent Agency Ranking
0/0