Deploying incremental scripts

Patent metadata

Field	Value
Publication number	US-9513901-B2
Application number	US-201514674017-A
Country	US
Kind code	B2
Filing date	Mar 31, 2015
Priority date	Mar 31, 2015
Publication date	Dec 6, 2016
Grant date	Dec 6, 2016

Abstract

A method and system of implementing continuous deployment of scripts in languages that only support single deployment. The method and system may develop incremental scripts based on differences between a pending script and an implemented script.

First claim

What is claimed is:

1. A computer program product for deploying incremental script updates, the computer program product comprising:
one or more computer-readable storage devices and program instructions stored on at least one of the one or more tangible storage devices, the program instructions comprising:
program instructions to receive a first script and a second script, wherein the first script is associated with a database, and wherein the second script is a potential update to the first script;
program instructions to create a first set and a second set by comparing the first script and the second script, wherein the first set includes elements that are present in only the second script, and wherein the second set includes elements that are present in the first script and the second script;
program instructions to classify the elements associated with the first set, wherein program instructions to classify the elements associated with the first set comprise adding metadata tags to the elements associated with the first set corresponding to the function of the element;
program instructions to create a context model, wherein the context model includes the elements and corresponding metadata tags associated with the first set and elements associated with the second set;
program instructions to classify the elements associated with the first set as structural changes to the database;
program instructions to create a data migration script based on the elements classified as structural changes;
program instructions to create a third script from the elements classified as structural changes and the data migration script; and
program instructions to deploy the third script as an update to the first script.

2. The computer program product of claim 1 , wherein the first script, the second script and the third script are scripts that utilize the SQL programming language.

3. The computer program product of claim 2 , wherein the metadata tags corresponding to the function of the element comprise tags corresponding to table changes, constraint changes or column changes.

4. The computer program product of claim 1 , further comprising:
program instructions to generate a fourth script, wherein the fourth script includes at least one element to populate new structural components of the database with values form a linked database; and
program instructions to create the third script from the context model and the fourth script.

5. The computer program product of claim 1 , wherein creating the context model further comprises eliminating a first element from the context model based on a disagreement between the first element and a first preference, wherein the first preference is a constraint associated with the database.

6. The computer program product of claim 1 , further comprising program instructions to remove duplicative elements contained in the context model.

7. The computer program product of claim 1 , further comprising program instructions to test the third script for errors prior to deploying the third script.

8. A computer system for deploying incremental script updates, the computer system comprising:
one or more processors, one or more computer-readable memories, one or more computer-readable tangible storage devices, and program instructions stored on at least one of the one or more storage devices for execution by at least one of the one or more processors via at least one of the one or more memories, the program instructions comprising:
program instructions to receive a first script and a second script, wherein the first script is associated with a database, and wherein the second script is a potential update to the first script;
program instructions to create a first set and a second set by comparing the first script and the second script, wherein the first set includes elements that are present in only the second script, and wherein the second set includes elements that are present in the first script and the second script; program instructions to classify the elements associated with the first set, wherein program instructions to classify the elements associated with the first set comprise adding metadata tags to the elements associated with the first set corresponding to the function of the element;
program instructions to create a context model, wherein the context model includes the elements and corresponding metadata tags associated with the first set and elements associated with the second set;
program instructions to classify the elements associated with the first set as structural changes to the database;
program instructions to create a data migration script based on the elements classified as structural changes;
program instructions to create a third script from the elements classified as structural changes and the data migration script; and

program instructions to deploy the third script as an update to the first script.

9. The computer system of claim 8 , wherein the first script, the second script and the third script are scripts that utilize the SQL programming language.

10. The computer system of claim 9 , wherein the metadata tags corresponding to the function of the element comprise tags corresponding to table changes, constraint changes or column changes.

11. The computer system of claim 8 , further comprising:
program instructions to generate a fourth script, wherein the fourth script includes at least one element to populate new structural components of the database with values form a linked database; and
program instructions to create the third script from the context model and the fourth script.

12. The computer system of claim 8 , wherein creating the context model further comprises eliminating a first element from the context model based on a disagreement between the first element and a first preference, wherein the first preference is a constraint associated with the database.

13. The computer system of claim 8 , further comprising program instructions to remove duplicative elements contained in the context model.

Assignees

• IBM

Inventors

• Chen xiao long
• Lv Na
• Wang Xi Ning
• Yan Zhe
• Zhao Zhuo

Classifications

• G06F8/68 Primary

  Physics · mapped topic

• G06F16/214

  Database migration support · CPC title

• G06F16/288

  Entity relationship models · CPC title

• G06F16/24556

  Aggregation; Duplicate elimination · CPC title

• G06F8/658 Primary

  Incremental updates; Differential updates · CPC title