MODIFICATION OF A SAVED DATABASE QUERY BASED ON A CHANGE IN THE MEANING OF A QUERY VALUE OVER TIME

• US 20080301109A1
• Filed: 08/14/2008
• Published: 12/04/2008
• Est. Priority Date: 03/02/2006
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Kolz, Daniel Paul, Dettinger, Richard Dean, Shim, Kyong Jin, Wilkening, Marie Renee, Swanson, Alan Benjamin
• Granted Patent: US 10,599,692 B2
• Time in Patent Office: Days
• US Class Current: 707/4
• CPC Class Codes: G06F 16/3322 using system suggestions G06F16/3325 takes precedence

Abstract

An apparatus and method modify a saved query based on a change in a query value meaning that changes over time. In preferred embodiments a graphical query interface displays an option to adjust query values of a saved database query. A query adjustment mechanism then adjusts the value of the query to compensate for the change in the meaning of the query value since the query was created such that the adjusted query will have the same basic meaning as when the query was originally created. Preferred Embodiments allow the user to specify to adjust the query to the current date or to a specified date in the past.

Claims

1. ) A computer-implemented method for a user to modify a query to a database, the method comprising the steps of:

displaying an option to a user of the database to time adjust a query; and

in response to a user selection, modifying the query based on the change in a meaning of a query value over time such that the query will have the same meaning as when the query was originally created and stored.

2. ) The method of claim 8 wherein the query is modified by adjusting the query value that has changed in meaning.

3. ) The method of claim 9 wherein the query value is adjusted to the product of an original query value and the historical value returned by the query divided by a current value returned by the query.

4. ) The method of claim 10 wherein the query is done regarding other query values in the query

5. ) The method of claim 8 wherein the query is done disregarding other query values in the query.

6. ) The method of claim 8 wherein the time sensitive query is a stored query.