Back to results
US 2010/0161649 A1Published application
Database management
AssigneeInternational Business Machines Corporation
InventorsGopikrishnan Varadarajulu, Abhishek Iyer, Pallavi Gupta
Life of this patent
Estimating the term…
Abstract
There is disclosed a system and method for optimising database access plans. Specifically, modifications made to a database are monitored and compared to a set of criteria. If a modification satisfies a criterion, the access plans relating to the modification are updated.
Claims10
A method for managing a database, the method comprising:
- receiving a request, wherein the request is a database modification request indicating a database modification;
- determining a database access plan affected by the database modification request;
- storing information related to the database access plan in a plan update log;
- receiving an interrupt indicating a modification of the plan update log;
- identifying the database access plan from the information received in the interrupt indicating modification of the plan update log;
- and
- updating the access plan.
4 more elements
A database system comprising:
- a processor configured to receive an interrupt, the interrupt indicating a database modification request and determining a database access plan affected by the modification request;
- and
- a storage device for storing information related to the database access plan in a plan update log;
- wherein the processor receiving the interrupt indicates a modification of the plan update log, identifies the database access plan from the information in the modification request, and updates the access plan in the storage device.
1 more element
Dependencies are inferred from the claim text.