Deploying incremental scripts

Patent metadata

Field	Value
Publication number	US-9811332-B2
Application number	US-201615047148-A
Country	US
Kind code	B2
Filing date	Feb 18, 2016
Priority date	Mar 31, 2015
Publication date	Nov 7, 2017
Grant date	Nov 7, 2017

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 method for deploying incremental script updates, the method comprising:
receiving 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;
creating 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;
classifying the elements associated with the first set, wherein classifying the elements associated with the first set comprises adding metadata tags to the elements associated with the first set corresponding to the function of the element;
creating 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;
classifying the elements associated with the first set as structural changes to the database;
creating a data migration script based on the elements classified as structural changes;
creating a third script from the elements classified as structural changes and the data migration script; and
deploying the third script as an update to the first script.

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

3. The method of claim 2 , wherein the metadata tags comprise information detailing table changes, constraint changes or column changes.

4. The method of claim 1 , further comprising:
generating 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
creating the third script from the context model and the fourth script.

5. The method 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 method of claim 1 , further comprising removing duplicative elements contained in the context model.

7. The method of claim 1 , further comprising testing the third script for errors prior to deploying the third script.

Assignees

• IBM

Inventors

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

Classifications

• G06F8/65

  Updates (security arrangements therefor G06F21/57) · CPC title

• G06F17/30604

  Physics · mapped topic

• G06F17/30371

  Physics · mapped topic

• G06F8/68 Primary

  Physics · mapped topic

• G06F17/30377

  Physics · mapped topic