MIGRATING DATA IN TABLES IN A DATABASE
First Claim
1. A computer-implemented method for migrating data in a database, comprising:
- identifying an update to one or more data entries of a source table;
determining that a status of a trigger associated with the source table indicates to update a logging table, and in response;
updating, in a first transaction, (i) the one or more data entries of the source table, and (ii) one or more data entries of the logging table based on the user input, andcopying content of the source table to a target table; and
determining that the status of the trigger associated with the source table indicates to update the target table, and in response;
updating, in a second transaction, (i) the one or more data entries of the source table and (ii) one or more data entries of the target table based on the user input, andupdating the content of the target table based on the one or more data entries of the logging table.
2 Assignments
0 Petitions
Accused Products
Abstract
Techniques for migrating data in a database include identifying an update to one or more data entries of a source table; determining that a status of a trigger associated with the source table indicates to update a logging table, and in response: updating, in a first transaction, (i) the one or more data entries of the source table, and (ii) one or more data entries of the logging table based on the user input, and copying content of the source table to a target table; and determining that the status indicates to update the target table, and in response: updating, in a second transaction, (i) the one or more data entries of the source table and (ii) one or more data entries of the target table based on the user input, and updating the content of the target table based on the one or more data entries of the logging table.
-
Citations
20 Claims
-
1. A computer-implemented method for migrating data in a database, comprising:
-
identifying an update to one or more data entries of a source table; determining that a status of a trigger associated with the source table indicates to update a logging table, and in response; updating, in a first transaction, (i) the one or more data entries of the source table, and (ii) one or more data entries of the logging table based on the user input, and copying content of the source table to a target table; and determining that the status of the trigger associated with the source table indicates to update the target table, and in response; updating, in a second transaction, (i) the one or more data entries of the source table and (ii) one or more data entries of the target table based on the user input, and updating the content of the target table based on the one or more data entries of the logging table. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A computer program product encoded on a non-transitory storage medium, the product comprising non-transitory, computer readable instructions for causing one or more processors to perform operations comprising:
-
identifying an update to one or more data entries of a source table; determining that a status of a trigger associated with the source table indicates to update a logging table, and in response; updating, in a first transaction, (i) the one or more data entries of the source table, and (ii) one or more data entries of the logging table based on the user input, and copying content of the source table to a target table; and determining that the status of the trigger associated with the source table indicates to update the target table, and in response; updating, in a second transaction, (i) the one or more data entries of the source table and (ii) one or more data entries of the target table based on the user input, and updating the content of the target table based on the one or more data entries of the logging table. - View Dependent Claims (10, 11, 12, 13, 14, 15)
-
-
16. A system of one or more computers configured to perform operations comprising:
-
identifying an update to one or more data entries of a source table; determining that a status of a trigger associated with the source table indicates to update a logging table, and in response; updating, in a first transaction, (i) the one or more data entries of the source table, and (ii) one or more data entries of the logging table based on the user input, and copying content of the source table to a target table; and determining that the status of the trigger associated with the source table indicates to update the target table, and in response; updating, in a second transaction, (i) the one or more data entries of the source table and (ii) one or more data entries of the target table based on the user input, and updating the content of the target table based on the one or more data entries of the logging table. - View Dependent Claims (17, 18, 19, 20)
-
Specification