Systems and methods for synchronizing database schema
AssigneeWalmart Apollo, LLC
InventorsJoshua Ledbetter, Daniel Bryan Austin
Life of this patent
Estimating the term…
Abstract
Methods and systems for synchronizing a database schema (or data structure) of a source database to a target database are disclosed. A source data structure definition is generated, including definitions of each object in the source database structure. A target database structure is generated, including definitions of each object in the source database structure. Object definitions are compared between the source database structure and the target database structure. A data definition language change instruction sequence is generated that, when executed, will modify the target database structure to correspond to the data structure definition. The change instruction sequence is executed on the target database.
Claims20
A method for updating a target database structure of a target database based on a source data structure of a source database, the target database structure and the source database structure each having one or more objects, the method comprising:
- generating a data structure definition, the data structure definition having an object definition for each of the one or more objects of the source data structure;
- comparing each object definition to the one or more objects in the target database structure;
- generating one or more creation actions for each object definition that does not have a corresponding object in the target database structure;
- generating one or more modification actions for each object definition that differs from a corresponding object in the target database structure;
- generating one or more deletion actions for each object in the target database structure that does not have a corresponding object definition;
- generating a data definition language change instruction sequence from the generated creation actions, modification actions, and deletion actions that, when executed, will modify the target database structure to correspond to the data structure definition;
- executing the change instruction sequence on the target database;
- and
- providing an output regarding a status of the executing of the change instruction sequence.
A database structure update system for updating a target database structure of a target database based on a source data structure of a source database, the target database structure and the source database structure each having one or more objects, the system comprising:
- a data structure definition extractor communicatively coupled to the source database and configured to generate a data structure definition, the data structure definition having an object definition for each of the one or more objects of the source data structure;
- a comparator communicatively coupled to the target database and configured to receive the data structure definition, compare each object definition to the one or more objects in the target database structure, and to:
- generate one or more creation actions for each object definition that does not have a corresponding object in the target database structure,
- generate one or more modification actions for each object definition that differs from a corresponding object in the target database structure, and
- generate one or more deletion actions for each object in the target database structure that does not have a corresponding object definition;
- a data definition language generator configured to generate a data definition language change instruction sequence from the generated actions instructions, modification actions, and deletion actions that, when executed will modify the target database structure to correspond to the data structure definition;
- and
- a deployment engine communicatively coupled to the target database and to a user interface and configured to execute the change instruction sequence on the target database, and to provide an output to the user interface regarding the status of the execution of the change instruction sequence.
Dependencies are inferred from the claim text.