×

Internal parameters (parameters aging) in an abstract query

  • US 7,606,791 B2
  • Filed: 06/03/2004
  • Issued: 10/20/2009
  • Est. Priority Date: 06/03/2004
  • Status: Expired due to Fees
First Claim
Patent Images

1. A computer-implemented method for performing queries based on aging result fields by operation of one or more computer processors, the method comprising:

  • executing a first query, the first query comprising;

    one or more fields for which values of a database are to be returned in a first result set upon execution of the first query; and

    one or more conditions each containing one or more result fields, the one or more conditions defining logic for restricting the values to be returned upon execution of the first query;

    storing a timestamp indicative of a time at which the first query is executed;

    returning the first result set for the first query;

    storing the executed first query in a storage medium;

    retrieving the stored first query from the storage medium;

    designating at least one of the result fields of the retrieved first query as an aging parameter, wherein each result field designated as an aging parameter has an associated time value field; and

    for each designated aging parameter, programmatically adding, by operation of a query conversion engine executing on one or more of the computer processors, a temporal condition to the retrieved first query to produce a second query;

    wherein each temporal condition comprises the respective associated time value field and a value corresponding to the timestamp, whereby results returned for the respective aging parameter are limited to those having time values more recent than the timestamp.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×