Back to results
US 9,436,712 B2Granted
Data migration framework
AssigneeMicrosoft Technology Licensing, LLC
InventorsSri Srinivasan, Mudit Mittal, Tao Wang
Life of this patent
Estimating the term…
Abstract
User data is retrieved from an instance of a data system. A mapping between the data system and one or more staging tables is generated and a package that includes the data and the mapping is generated. The user data is saved to the one or more staging tables using the mapping.
Claims18
A computer-implemented method of migrating data, comprising:
- identifying data in a source data system instance, the identified data comprising non-canonical data;
- generating a staging mapping that maps data from a first number of tables in the identified data to a second number of tables in the staging data structure, the first and second numbers being different from one another;
- and
- in parallel,
- saving a first subset of the identified data from the source data system instance to the staging data structure according to the staging mapping, wherein the first subset of data is saved to the staging data structure in a canonical form;
- and
- copying a second subset of the identified data from the staging data structure to a target data system instance.
4 more elements
A data migration system, comprising:
- a source-to-staging mapper component configured to:
- read a non-canonical data file in an instance of a source data system, including at least first and second subsets of data;
- and
- generate a map that maps a first number of tables in the non-canonical data file to a second number of tables, different from the first number of tables, in a canonical staging data structure;
- and
- a data processing component configured to, in parallel,
- populate, based on the map, the canonical staging data structure with the first subset of data from the non-canonical data file, using a computer processor;
- and
- copy the second subset of the data from the canonical staging data structure to an instance of a target data system.
6 more elements
A computer readable storage medium that stores computer readable instructions which, when executed by a computer, cause the computer to perform a method, comprising:
- obtaining data from an on-premise source data system instance, the obtained data comprising non-canonical data;
- obtaining a staging mapping that maps data from a first number of tables in the on-premise source data system instance to a second number of tables in the staging data structure, the first and second numbers being different one another;
- generating a package including an indicator indicating the obtained data and the staging mapping;
- and
- in parallel based on the package,
- saving a first subset of the obtained data from the source data system instance to the staging data structure according to the staging mapping, wherein the obtained data is saved to the staging data structure in a canonical form;
- and
- copying a second subset of the obtained data from the staging data structure to a cloud-based version of the on-premise source date system instance.
5 more elements
Dependencies are inferred from the claim text.