AUTOMATED DATA ARCHIVE TOOL

• US 20080294697A1
• Filed: 05/22/2007
• Published: 11/27/2008
• Est. Priority Date: 05/22/2007
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Andrasak, Michael J., Wang, Chin-Ying
• Application Number:
  US11/751,695
• Publication Number:
  US 20080294697A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/219 Managing data history or versioning querying versioned data G06F16/2474; querying temporal data G06F16/2477

Abstract

A method and programmable storage device for controlling an archival process in a supply chain management software tool that includes using a control table to identify files or directories to be archived, and archiving information based on the data stored in each row of the control table. The method provides for the querying of archive control table rows by incrementally reading a row in the archive control table for an active column designation, storing the information from the row in a list if the active column designation is in a predetermined active state, and incrementing to a next row in the archive control table, or skipping the row if the active column designation is in a predetermined non-active state, and incrementing to a next row in the archive control table.

Claims

1. A method for automating the archiving of data in a supply chain software tool comprising:

generating via software code in said supply chain software tool an archive control table having a plurality of rows;

querying said archive control table rows by incrementally reading a row in said archive control table for an active column designation;

storing information from said row in a list if said active column designation is in a predetermined active state, and incrementing to a next row in said archive control table, or skipping said row if said active column designation is in a predetermined non-active state, and incrementing to a next row in said archive control table;

generating a list of rows having active column designations; and

determining if an additional column needs to be added to an archived table having a table name, including;

comparing a first and second predetermined identifier;

copying said archived table if said first and second predetermined identifiers are not equal, or copying said archived table and adding said additional column if said first and second predetermined identifiers are equal; and

inserting said first predetermined identifier value into said additional column.

2. The method of claim 1 wherein said archive control table rows include the identification of DB2 tables, files, or directories.

3. The method of claim 1 including:

combining a source schema and said table name to generate a target source table;

combining a sink schema and said table name to generate a target sink table; and

exporting said target source table to a DEL file.

4. The method of claim 1 wherein said step of copying said archived table includes generating an input table and a destination table.

5. The method of claim 1 wherein said step of storing information from said row in a list if said active column designation is in a predetermined active state includes having said predetermined active state equal to a first predetermined value.

6. The method of claim 5 wherein said step of skipping said row if said active column designation is in a predetermined non-active state includes have said predetermined non-active state equal to a second predetermined value not equal to said first predetermined value.

8. The program storage device of claim 6 including:

combining a source schema and said table name to generate a target source table;

combining a sink schema and said table name to generate a target sink table; and

exporting said target source table to a DEL file.

7. A program storage device readable by a machine, tangibly embodying a program of instructions executable by the machine to perform method steps for automating the archiving of data in supply chain software, said method steps comprising:

generating via software code in said supply chain software tool an archive control table having a plurality of rows;

querying said archive control table rows by incrementally reading a row in said archive control table for an active column designation;

storing information from said row in a list if said active column designation is in a predetermined active state, and incrementing to a next row in said archive control table, or skipping said row if said active column designation is in a predetermined non-active state, and incrementing to a next row in said archive control table;

generating a list of rows having active column designations; and

determining if an additional column needs to be added to an archived table having a table name, including;

comparing a first and second predetermined identifier;

copying said archived table if said first and second predetermined identifiers are not equal, or copying said archived table and adding said additional column if said first and second predetermined identifiers are equal; and

inserting said first predetermined identifier value into said additional column.