Patent ID: 7584178

Claim:
A computer-implemented method of managing execution of a query against data in a database, comprising: receiving a plurality of first queries, each first query having: (i) at least one result field configured to return data from at least one data record included with the database, and (ii) a query condition comprising a field and a query object associated with the field by an operator configured to select values for the field from the query object; wherein each query object is one of a plurality of different query object types; for each first query containing a query object of a first type in which the query object is defined by a second query having one or more result fields: transforming the query object from being configured not to provide one or more valid values for the field into a transformed query object that is configured to provide one or more valid values for the field; the transforming comprising: determining whether a particular result field from the one or more result fields matches the field of the query condition, the second query being configured to return data for the particular result field that defines the one or more valid values; and upon determining that the particular result field from the one or more result fields matches the field of the query condition, removing all result fields from the second query, except the identified particular result field, thereby producing the transformed query object; and for each first query for which the query object was transformed: executing the first query against the database, the executed first query including the transformed query object.