Maintenance of active database queries
AssigneeLogicBlox, Inc.
InventorTodd L. Veldhuizen
Life of this patent
Estimating the term…
Abstract
An aspect includes a method for maintaining active queries. The method includes executing a query based on data items in at least two relations in a database. The executing includes outputting a query result and control information associated with the query. The query result and the control information are recorded. A notification that at least one of the data items has been updated subsequent to the executing is received. The query result is modified, responsive to the control information, to reflect the data items that were updated subsequent to the executing.
Claims21
A method to maintain active queries, the method comprising:
- executing a query based on data items in at least two relations in a database, the executing including outputting a query result and control information associated with the query;
- recording the query result and the control information;
- receiving a notification that at least one of the data items has been updated subsequent to the executing;
- modifying the query result to reflect the data items that were updated subsequent to the executing, the modifying responsive to the control information.
A system for maintaining active queries, comprising:
- a memory having computer readable computer instructions;
- and
- a processor for executing the computer readable instructions to perform a method comprising:
- executing a query based on data items in at least two relations in a database, the executing including outputting a query result and control information associated with the query;
- recording the query result and the control information;
- receiving a notification that at least one of the data items has been updated subsequent to the executing;
- modifying the query result to reflect the data items that were updated subsequent to the executing, the modifying responsive to the control information.
A computer program product for maintaining active queries, the computer program product comprising a computer readable storage medium having computer-readable program code embodied thereon, which when executed by a computer processor, causes the computer processor to implement a method, the method comprising:
- executing a query based on data items in at least two relations in a database, the executing including outputting a query result and control information associated with the query;
- recording the query result and the control information;
- receiving a notification that at least one of the data items has been updated subsequent to the executing;
- modifying the query result to reflect the data items that were updated subsequent to the executing, the modifying responsive to the control information.
Dependencies are inferred from the claim text.