	US 7,516,144 B2
	Method and system for re-population of data in a database
Muralidharan Kanchi Lakshminarasimhan, Bangalore (India)
Assigned to Vaakya Technologies Private Limited, Bangalore, Karnataka (India)
Filed on Sep. 27, 2006, as Appl. No. 11/535,491.
Claims priority of application No. 1574/CHE/2005 (IN), filed on Oct. 28, 2005.
Prior Publication US 2007/0100791 A1, May 03, 2007
Int. Cl. G06F 17/00 (2006.01)

U.S. Cl. 707—101 [707/104.1]

12 Claims

1. 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.