Patent ID: 7716214
Filing Date: 2010-05-11
Classification: G06F

Abstract:
1. A computer-implemented method for dynamic management of materialized query tables (MQTs) for a workload queue, said method comprising: inputting said workload queue comprising an ordered number of queries, and a database size allocated to a least recently used (LRU) MQT cache; generating candidate MQTs for said ordered number of queries based on common portions of said ordered number of queries; calculating a benefit for each of said candidate MQTs, wherein said benefit corresponds to a time reduction in accessing said each of said candidate MQTs versus accessing a base table, minus an overhead time of creating said required each of said candidate MQTs; creating a schedule for materialization of said candidate MQTs in said LRU MQT cache, based on said ordered number of queries and an ordered value of said benefit for said each of said candidate MQTs and their respective sizes; executing said ordered number of queries of said database workload queue; and materializing and storing said candidate MQTs, according to said schedule, until said LRU MQT cache is filled.