×

MIGRATING DATA IN TABLES IN A DATABASE

  • US 20150112923A1
  • Filed: 10/21/2013
  • Published: 04/23/2015
  • Est. Priority Date: 10/21/2013
  • Status: Active Grant
First Claim
Patent Images

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.

View all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×