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

• Current Assignee: International Business Machines SA (International Business Machines Corporation)
• Original Assignee: International Business Machines Corporation
• Inventors: Kolz, Daniel P., Dettinger, Richard D., Rath, Cale T., Wenzel, Shannon E.
• Primary Examiner(s): Jalil; Neveen Abel
• Assistant Examiner(s): Hoffler; Raheem
• Application Number:
  US10/860,417
• Publication Number:
  US 20060004707A1
• Time in Patent Office: 1,965 Days
• Field of Search: 707/3, 707/100
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2425 Iterative querying; Query formulation based on the results of a preceding query
• CPC Class Codes: G06F 16/2477 Temporal data queries
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

The present invention provides for aging queries. Queries are aged by, for example, adding temporal conditions to the queries. The temporal conditions include temporal fields having a time-based association with one or more other conditions of the respective queries. In one embodiment, each temporal condition includes a temporal field and corresponding time value, where the time value is set to the time when the respective query was last run.

Claims

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.

2. The method of claim 1, further comprising:

successively executing the second query multiple times; and

updating the timestamp for each execution of the second query.

3. The method of claim 1, further comprising:

executing the second query; and

returning a second result set for the second query, the second result set including all the results that satisfy the first query and are not redundant with respect to the first set.

4. The method of claim 1, further comprising:

executing the second query;

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

at a later time, receiving a request to execute the second query again; and

for each designated aging parameter, programmatically updating the temporal condition on the basis of the timestamp indicative of the time at which the second query was last executed.

5. The method of claim 1, wherein the first query and second queries are initially constructed as abstract queries comprising logical fields abstractly representing physical data and further comprising:

converting the abstract queries into executable queries.

6. The method of claim 1, wherein designating at least one of the result fields as the aging parameter is done in response to user input to a user interface.

7. The method of claim 1, wherein the designation of at least one of the result fields as the aging parameter is located in a data structure and is not done in response to user input to a user interface.

8. The method of claim 1, further comprising:

updating the timestamp for each execution of the second query; and

updating the temporal condition for each execution of the second query on the basis of the timestamp for the immediately previous execution of the second query.

9. The method of claim 1, further comprising:

storing the timestamp to a table record; and

storing a user identifier to the table record.

10. The method of claim 1, wherein the temporal condition comprises the associated time value field, an arithmetic operator and a time value.

11. A computer system, comprising:

a database stored in a computer readable storage medium;

an aging parameter table in which each row comprises a query and a timestamp indicating the time at which the query was last executed, wherein the query has a result field capable of being temporarily restricted; and

a query manager configured to;

store the query in the aging parameter table;

perform a query execution operation repeatedly;

wherein the query execution operation comprises;

retrieving stored query from the aging parameter table; and

adding a temporal condition to the retrieved query to generate a modified retrieved query, the temporal condition being applied to the result field and including the timestamp for the immediately previous execution of the query, whereby results returned for the result field are limited to those having time values more recent than the timestamp; and

updating the timestamp in the aging parameter table to reflect the time at which the modified retrieved query is executed.

12. The computer system of claim 11, wherein the temporal condition is added to the retrieved query in response to user input designating the result field as an aging parameter.

13. The computer system of claim 11, further comprising a user interface having a selection element allowing a user to designate the result field as an aging parameter, the designation prompting the query manager to add the temporal condition.

14. The computer system of claim 11, further comprising a user interface configured to allow a user to modify the timestamp to an arbitrary value and thereby control the time range for which results satisfying the query are returned.

15. A computer readable storage medium containing a program which when executed by a computer processor, performs an operation 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 the computer processor, 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.

16. The computer readable storage medium of claim 15, further comprising:

successively executing the second query multiple times; and

updating the timestamp for each execution of the second query.

17. The computer readable storage medium of claim 15, further comprising:

executing the second query; and

returning a second result set for the second query, the second result set including all the results that satisfy the first query and are not redundant with respect to the first set.

18. The computer readable storage medium of claim 15, further comprising:

executing the second query;

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

at a later time, receiving a request to execute the second query again; and

for each designated aging parameter, programmatically updating the temporal condition on the basis of the timestamp indicative of the time at which the second query was last executed.

19. The computer readable storage medium of claim 15, wherein designating at least one of the result fields as the aging parameter is done in response to user input to a user interface.

20. The computer readable storage medium of claim 15, wherein the designation of at least one of the result fields as the aging parameter is located in a data structure and is not done in response to user input to a user interface.

21. The computer readable storage medium of claim 15, further comprising:

updating the timestamp for each execution of the second query; and

updating the temporal condition for each execution of the second query on the basis of the timestamp for the immediately previous execution of the second query.