Patent ID: 7516144

Claim:
A database management system, the database management system managing a database, the database comprising a plurality of tables, the database management system comprising: a processor; and a memory coupled to the processor; a. a classifier residing in the memory, classifies each database trigger into one of a persistent trigger and a non-persistent trigger, wherein a persistent trigger updates a table and a non-persistent trigger performs one of an insert operation and a delete operation on a table; b. a categorizer residing in the memory, categorizes each table into one of a no-trigger-table, a non-persistent-trigger-table and a persistent-trigger-table, wherein a no-trigger-table is a table that is not modified by a trigger, a non-persistent-trigger-table is a table that is modified by a non-persistent trigger, and a persistent-trigger-table is a table that is modified by a persistent trigger; c. a sequencing module residing in the memory, the sequencing module sequencing each table into a predefined-update-sequence; d. a detection module residing in the memory, the detection module detecting at least one script-transaction, wherein the script-transaction is result of a structural change in the database, the at least one script-transaction being carried out in response to a script input; and e. a re-population module residing in the memory, the re-population module re-populating data in the database in response to the detection module detecting the at least one script-transaction.