Patent ID: 7240078

Claim:
A method for executing a query, comprising: matching the query to an outlier materialized query table that stores exception data, wherein the query contains a correlation predicate, by translating the correlation predicate into a join predicate in a context of the outlier materialized query table and, when the translated join predicate matches the join predicate in the outlier materialized query table, deriving a new predicate for the correlation predicate in a child query block using a source predicate on a quantifier of a parent query block; searching the query for a source predicate, including searching the parent query block for the source predicate; searching an outlier predicate in the outlier materialized query table that corresponds to the source predicate for a target column that corresponds to a source column in the source predicate; deriving a new range predicate based on the target column; and introducing the new range predicate into the query, wherein the query is executed to retrieve data from one or more data stores.