Patent ID: 8615507

Claim:
A method for managing a database, the method comprising: applying a database modification to a database entity based on a database modification request; recording the database modification in a database modification log; periodically checking the database modification log to determine whether the database modification triggers at least one database access plan update based on a set of rules; storing information related to the at least one database access plan update in a plan update log when determined that the database modification triggered the at least one database access plan update, wherein the information indicates modification made to the database; receiving an interrupt indicating a modification of the plan update log to invoke a database access plan update process; identifying a database access plan in condition for an update from the information in the plan update log; scanning dependency information within the database and utilizing the dependency information to determine one or more other database entities modified by the database modification and identify one or more other database access plans indirectly affected by the database modification and in condition for an update; and updating the identified database access plan and the one or more other database access plans in condition for the update.