Patent ID: 8112414
Filing Date: 2012-02-07
Classification: G06F

Abstract:
1. A computer program product stored on a computer-readable medium for reducing the locking of Materialized Query Tables (MQTs), the computer program product comprising: a MQT definition query defining the aggregates within a MQT as distributive; an insert module configured to perform an insert operation on the MQT that adds a child row to a MQT without refreshing the MQT in response to an insert operation inserting a base table row in a base table referenced by the MQT, a delete module configured to perform an insert operation on the MQT that adds a child row to the MQT without refreshing the MQT in response to a delete operation deleting a base table row in the base table referenced by the MQT, wherein the added child row comprises: an update module configured to add two child rows to the MQT without refreshing the MQT in response to an update operation updating a base table row in the base table referenced by the MQT with one or more new values: an execution module configured to provide a value in response to a query requesting values associated with a particular foreign key by summing all measure values in the MQT sharing the particular foreign key, wherein the summation is executed in an order specified by the unique identifier; and a consolidation module that executes an aggregation operation that aggregates all records in the MQT having the same foreign key into a single row entry without refreshing the MQT from the base table, wherein the consolidation module is further configured to determine: