Patent Document ID: 7809712
Application ID: 11592470

Base Claim:
1. A method for rewriting queries, the method comprising the computer implemented steps of: examining a first query that references a relation to which a second query evaluates; wherein the second query defines an array and a first set of formulas that reference the array; wherein the array has one or more dimensions; wherein the first query includes one or more predicates; wherein the second query does not include the one or more predicates; determining whether one or more criteria for rewriting said first query or said second query are satisfied; if said one or more criteria for rewriting said first query or said second query are satisfied, then making, based on said one or more predicates included in said first query, modifications to said second query involving one or more predicate conditions; and generating a rewritten query based on the modifications to said second query; wherein the steps of the method are performed by one or more computing devices.

---

Claim 10:
10. The method of claim 1 , wherein: a dimension of said one or more dimensions corresponds to a dimension column in said relation; said one or more predicates includes a particular predicate that references said dimension column; each formula of said set of formulas has a right side and a left side; the step of making modifications to said second query involving one or more predicate conditions includes a means for making modifications to the second query when, for at least one formula of said set of formulas, a value of the dimension referenced by the left side is different than a value referenced on the right side for the dimension.