Difference-based database upgrade
AssigneeMicrosoft Corporation
InventorsAndrey Zaytsev, Jigar Thakkar, Sonja Jackson
Life of this patent
Estimating the term…
Abstract
A method for updating a database that combines the advantages of both the migration and incremental approach may resolve some of the problems associated with earlier methods. This may be accomplished by a methodology which incrementally updates new data while using the migration approach to create an entirely new schema. Such a method might compare the metadata from both the existing database and the data update to generate a new schema and integrate new data into the database.
Claims20
A method of updating a database comprising:
- loading a first metadata from the database into a first cache;
- loading a second metadata from a file into a second cache;
- comparing the first cache metadata and the second cache metadata;
- creating a request based on differences between the first cache and the second cache;
- deriving a script from the request;
- and,
- executing the script.
A method of updating a database comprising:
- serializing a first metadata from the database to a common information format;
- deserializing the common information formatted first metadata to a first comparable object;
- loading the first comparable object into a first cache;
- serializing a second metadata from a database update file to a common information format;
- deserializing the common information formatted second metadata to a second comparable object;
- loading the second comparable object into a second cache;
- comparing the first comparable object and the second comparable object;
- creating a request based on differences between the first comparable object and the second comparable object;
- deriving a script from the request;
- and,
- executing the script.
A computer readable medium comprising computer executable instructions for updating a database comprising computer executable instructions for:
- loading a first metadata from the database into a first cache;
- loading a second metadata from a database next release file into a second cache;
- comparing the first cache metadata and the second cache metadata;
- creating a request based on differences between the first cache and the second cache;
- deriving a script from the request;
- and,
- executing the script.
Dependencies are inferred from the claim text.