Method and system for re-population of data in a database
First Claim
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.
1 Assignment
0 Petitions
Accused Products
Abstract
A method for automatic re-population of data in a database in response to detection of at least one script-transaction, the database includes a plurality of tables. The script-transaction is carried out in response to a script input. The method includes truncating at least one table, which is being modified by at least one of a persistent trigger and a non-persistent trigger. The persistent trigger updates a table and the non-persistent trigger performs one of an insert operation and a delete operation on a table. Further, the method includes executing a non-persistent trigger corresponding to each truncated table of the database in a predefined-update-sequence. Also, the method includes executing at least one persistent trigger corresponding to each truncated table of the database.
-
Citations
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. - View Dependent Claims (2)
-
-
3. A method for enabling automatic re-population of data in a database, the database comprising a plurality of tables, the method comprising:
-
a. classifying each database trigger into one of a persistent trigger and a non-persistent trigger, wherein a persistent trigger modifies a table and a non-persistent trigger performs one of an insert operation and a delete operation on a table; and b. categorizing 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 not modified by a trigger, a non-persistent-trigger-table is modified by a non-persistent trigger, and persistent-trigger-table is modified by a persistent trigger. - View Dependent Claims (4)
-
-
5. A method for automatic re-population of data in a database comprising a plurality of tables, the method comprising:
-
a. truncating at least one table in response to detection of at least one script-transaction, wherein the script-transaction is result of a structural change in the database, and wherein a table of the at least one table is one of a non-persistent-trigger-table and a persistent-trigger-table, and wherein a non-persistent-trigger-table is modified by a non-persistent trigger and a persistent-trigger-table is modified by a persistent trigger, and 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. executing a non-persistent trigger corresponding to each truncated table in a predefined-update-sequence; and c. executing at least one persistent trigger corresponding to each truncated table for automatic re-population of data in the database. - View Dependent Claims (6, 7, 8, 9, 10, 11)
-
-
12. A computer program product for use with a computer, the computer program product comprising a computer usable medium having a computer readable program code embodied therein for automatic re-population of data in a database comprising a plurality of tables, the computer code performing:
-
a. truncating at least one table in response to at least one script-transaction, wherein the script-transaction is result of a structural change in the database, and wherein a table of the at least one table is one of a non-persistent-trigger-table and a persistent-trigger-table, and wherein a non-persistent-trigger-table is modified by a non-persistent trigger and a persistent-trigger-table is modified by a persistent trigger, and 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. executing a non-persistent trigger corresponding to each truncated table of the database in a predefined-update-sequence; and c. executing at least one persistent trigger corresponding to each truncated table of the database for automatic re-population of data in the database.
-
Specification