System and methods for live data migration
AssigneePalantir Technologies Inc.
InventorsJoseph Ellis, Mark Elliot, Robert Fink, Sandor Van Wassenhove
Life of this patent
Estimating the term…
Abstract
Systems and methods are provided for data migration. The system may comprise one or more processors and a memory storing instructions that, when executed by the one or more processors, cause the system to migrate at least one first table of a first database schema to at least one second table of a second database schema, determine a query for modifying the first table during the migration, modify the second table based at least in part on the query, and update a mutation table to describe the modification, wherein the mutation table at least describes the modification.
Claims20
A system for live data migration, the system comprising:
- one or more processors;
- and
- memory storing instructions that, when executed by the one or more processors, cause the system to perform:
- receiving a first query requesting a modification of at least one field in the first table of a first database schema during a live migration of the first table to a second table of a second database schema, the first table storing live data;
- modifying, in response to receiving the first query, at least one corresponding field of the second table based on the first query;
- updating a mutation table based on the modification, wherein the mutation table tracks one or more modifications to the second table;
- receiving a second query for accessing the at least one field in the first table during the live migration of the first table to the second table of the second database schema;
- and
- determining, in response to receiving the second query and based on the mutation table, the corresponding field of the second table has been modified;
- providing, based on the determination the corresponding field of the second table has been modified, data from the at least one corresponding field of the second table in response to the second query.
A computer-implemented method, the method being implemented by a computing system including one or more processors and storage media storing machine-readable instructions, the method comprising:
- receiving a first query requesting a modification of at least one field in the first table of a first database schema during a live migration of the first table to a second table of a second database schema, the first table storing live data;
- modifying, in response to receiving the first query, at least one corresponding field of the second table based on the first query;
- updating a mutation table based on the modification, wherein the mutation table tracks one or more modifications to the second table;
- receiving a second query for accessing the at least one field in the first table during the live migration of the first table to the second table of the second database schema;
- and
- determining, in response to receiving the second query and based on the mutation table, the corresponding field of the second table has been modified;
- providing, based on the determination the corresponding field of the second table has been modified, data from the at least one corresponding field of the second table in response to the second query.
A non-transitory computer readable medium comprising instructions that, when executed, cause one or more processors to perform:
- receiving a first query requesting a modification of at least one field in the first table of a first database schema during a live migration of the first table to a second table of a second database schema, the first table storing live data;
- modifying, in response to receiving the first query, at least one corresponding field of the second table based on the first query;
- updating a mutation table based on the modification, wherein the mutation table tracks one or more modifications to the second table;
- receiving a second query for accessing the at least one field in the first table during the live migration of the first table to the second table of the second database schema;
- and
- determining, in response to receiving the second query and based on the mutation table, the corresponding field of the second table has been modified;
- providing, based on the determination the corresponding field of the second table has been modified, data from the at least one corresponding field of the second table in response to the second query.
Dependencies are inferred from the claim text.