×

Transformative migration of static data

  • US 9,582,524 B1
  • Filed: 06/19/2012
  • Issued: 02/28/2017
  • Est. Priority Date: 06/19/2012
  • Status: Active Grant
First Claim
Patent Images

1. A computer-implemented method comprising:

  • identifying, by one or more computing devices including a processing unit and memory, a first database table with a first characteristic;

    creating, by the one or more computing devices, a second database table with a second characteristic that is different than the first characteristic in at least one of a table schema, an encryption key, or a data structure;

    creating, by the one or more computing devices, a primary key index for the second database table;

    creating or updating, by the one or more computing devices, a status table prior to a first phase of data migration to indicate that, during the first phase of data migration, the first database table is accessible to at least one data reading process and the first database table is accessible to at least one data writing process, wherein information included in the first database table and information included in the second database table are not included in the status table;

    migrating, by the one or more computing devices and during the first phase of data migration, a first portion of data stored in the first database table to the second database table while transforming the first portion of data from the first characteristic to the second characteristic, the first portion of data being at least as old as a threshold age;

    creating, by the one or more computing devices, one or more other indices for the second database table;

    updating, by the one or more computing devices, the status table prior to a second phase of data migration to indicate that, during the second phase of data migration, the first database table is accessible to the at least one data writing process and to the at least one data reading process;

    the second database table is not accessible to the at least one data reading process; and

    the second database table is accessible to the at least one data writing process; and

    migrating, by the one or more computing devices and during the second phase of data migration, a second portion of data stored in the first database table to the second database table while transforming the second portion of data from the first characteristic to the second characteristic, the second portion of data being more recent than the threshold age.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×