MODIFICATION OF A SAVED DATABASE QUERY BASED ON A CHANGE IN THE MEANING OF A QUERY VALUE OVER TIME
First Claim
Patent Images
1. ) An apparatus comprising:
- at least one processor;
a memory coupled to the at least one processor;
a database residing in the memory; and
a query adjustment mechanism residing in the memory and executed by the at least one processor, the query adjustment mechanism adjusting a time sensitive query based on a change in a time sensitive query value that has occurred over a period of time such that the query will have the same basic meaning as when the query was originally created and stored;
wherein the query adjustment mechanism is part of a graphical query interface that displays an option to time adjust the time sensitive query, and in response to a user selection adjusting the time sensitive query based on a change in a query value that has occurred over a period of time; and
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.
0 Assignments
0 Petitions
Accused Products
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.
24 Citations
14 Claims
-
1. ) An apparatus comprising:
-
at least one processor; a memory coupled to the at least one processor; a database residing in the memory; and a query adjustment mechanism residing in the memory and executed by the at least one processor, the query adjustment mechanism adjusting a time sensitive query based on a change in a time sensitive query value that has occurred over a period of time such that the query will have the same basic meaning as when the query was originally created and stored; wherein the query adjustment mechanism is part of a graphical query interface that displays an option to time adjust the time sensitive query, and in response to a user selection adjusting the time sensitive query based on a change in a query value that has occurred over a period of time; and 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. - View Dependent Claims (5, 6)
-
-
2-4. -4. (canceled)
-
7. ) (canceled)
-
8. ) A program product comprising:
-
(A) a query adjustment mechanism that adjusts a time sensitive query based on a change in a query value that has occurred over a period of time; (B) computer-recordable signal bearing media bearing the graphical query interface; wherein the query adjustment mechanism is part of a graphical query interface that displays an option to time adjust the time sensitive query, and in response to a user selection, adjusting the time sensitive query based on a change in a query value that has occurred over a period of time such that the query will have the same basic meaning as when the query was originally created and stored; and 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. - View Dependent Claims (12, 13)
-
-
9-11. -11. (canceled)
-
14. ) (canceled)
Specification