METHOD AND SYSTEM FOR RE-POPULATION OF DATA IN A DATABASE
First Claim
1. A method for automatic re-population of data in a database in response to detection of at least one script-transaction, the database comprising a plurality of tables, the script-transaction being carried out in response to a script input, the method comprising:
- a. truncating at least one table which are being modified by at least 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. 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.
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 comprises a plurality of tables. The script-transaction is carried out in response to a script input. The method comprises 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 comprises executing a non-persistent trigger corresponding to each truncated table of the database in a predefined-update-sequence. Also, the method comprises executing at least one persistent trigger corresponding to each truncated table of the database.
10 Citations
13 Claims
-
1. A method for automatic re-population of data in a database in response to detection of at least one script-transaction, the database comprising a plurality of tables, the script-transaction being carried out in response to a script input, the method comprising:
-
a. truncating at least one table which are being modified by at least 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. 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. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. 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 a persistent-trigger-table is modified by a persistent trigger. - View Dependent Claims (10)
-
-
11. A database management system, the database management system managing a database, the database comprising a plurality of tables, the database management system comprising:
-
a. a classifier, the classifier classifying 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, the categorizer 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 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, the sequencing module sequencing each table into a predefined-update-sequence;
d. a detection module, the detection module detecting at least one script-transaction, the at least one script-transaction being carried out in response to a script input; and
e. a re-population module, 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 (12)
-
-
13. 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 in response to at least one script-transaction, the database comprising a plurality of tables, the script-transaction being carried out in response to a script input, the computer code performing:
-
a. truncating at least one table which are being modified by at least 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. 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.
-
Specification