System for and method of automatically migrating data among multiple legacy applications and accessible storage formats

• US 20020138570A1
• Filed: 03/23/2001
• Published: 09/26/2002
• Est. Priority Date: 03/23/2001
• Status: Abandoned Application

• Current Assignee: Orchid Systems Incorporated
• Original Assignee: Orchid Systems Incorporated
• Inventors: Hickey, Neil
• Application Number:
  US09/815,805
• Publication Number:
  US 20020138570A1
• Time in Patent Office: Days
• US Class Current: 709/204
• CPC Class Codes: H04L 67/56 Provisioning of proxy services store-and-forward switching systems in data switching networks H04L12/54
• CPC Class Codes: H04L 67/564 Enhancement of application control based on intercepted application data
• CPC Class Codes: H04L 67/565 Conversion or adaptation of application format or content adding application control or application functional data H04L67/561
• CPC Class Codes: H04L 69/329 in the application layer [OSI layer 7]
• CPC Class Codes: H04L 9/40 Network security protocols

Abstract

A system for and method of automatically migrating data among multiple legacy applications and accessible storage formats. The various embodiments described employ a trainable user interface translator application to monitor, reinterpret, and reformat data streams. The sequences of steps necessary to migrate data are recorded in a shaper rule set during a training session. Automatic migration of data is accomplished by operating the trainable user interface translator application in normal run mode in accordance with a shaper rule set previously created during the training session.

Claims

1. A trainable system for automatically transferring data between multiple existing applications, comprising:

a shaper computer operating a trainable user interface translator application and storing a shaper rule set and a list of control variables identifying data to be transferred;

a training terminal electrically connected to the shaper computer for establishing the shaper rule set the list of control variables during a training session;

a first host computer electrically connected to the shaper computer, and operating at least one first host application, thereby generating data streams that may be monitored by the shaper computer;

a second host computer electrically connected to the shaper computer, and operating at least one second host application, thereby generating data streams that may be monitored by the shaper computer;

wherein the shaper computer monitors the data streams of the at least one first host application and, according to the shaper rule set and list of control variables established during the training session, reinterprets and transmits automatically the data identified by the control variables to the at least one second host application.

2. The trainable system of claim 1, wherein the first host computer is a remote host computer operating a remote host application.

3. The trainable system of claim 1, wherein both the first host computer and the second host computer are remote host computers.

4. The trainable system of claim 1, wherein the first host computer and second host computer are the same computer operating the at least one first host application and at least one second host application.

5. The trainable system of claim 1, further comprising a plurality of first host computers electrically connected to the shaper computer and operating at least one first host application.

6. The trainable system of claim 1, further comprising an auxiliary storage device electrically connected to the shaper computer for storage and retrieval of training data sets to be employed during the training session.

7. The trainable system of claim 1, wherein the first host computer further comprises a first storage device containing data associated with the at least one first host application.

8. In a trainable system comprising a shaper computer operating a trainable user interface translator application and storing a shaper rule set and control variables, a training terminal electrically connected to the shaper computer, a first host computer electrically connected to the shaper computer and operating at least one first host application, and a second host computer electrically connected to the shaper computer and operating at least one second host application, a method of training the trainable system to transfer data between multiple host applications, comprising the steps of:

operating the trainable user interface translator application via the training terminal to define and store input and output variables associated with each step embodied in the business logic of the at least one first host application;

defining one or more control variables identifying data to be transferred between the at least one first host application and at least one second host application via the training terminal;

selecting sample data values for the control variables;

starting a training mode on the training terminal;

exercising the at least one first host application via the training terminal with the sample data values to obtain resultant output data, while storing the sequence of steps for exercising the at least one first host application in the shaper rule set;

storing the resultant output data in temporary storage;

exercising the at least one second host application via the training terminal with the resultant output data which may produce secondary output data, while storing the sequence of steps for exercising the at least one second host application in the shaper rule set;

storing secondary output data, if any;

determining if the trainable system is fully trained to accommodate business processes associated with transferring data between the at least one first host application and at least one second host application, and if not, reverting to the step of exercising the at least one first host application; and

determining if there are additional sample data values to process, and if so, reverting to the step of exercising the at least one first host application.

9. The method of claim 8, wherein the first host computer is a remote host computer operating a remote host application.

10. The method of claim 8, wherein both the first host computer and the second host computer are remote host computers.

11. The method of claim 8, wherein the first host computer and second host computer are the same computer operating the at least one first host application and at least one second host application.

12. The method of claim 8, wherein the trainable system further comprises a plurality of first host computers electrically connected to the shaper computer and operating at least one first host application.

13. The method of claim 8, wherein the trainable system further comprises an auxiliary storage device electrically connected to the shaper computer for storage and retrieval of training data sets to be employed during the training session.

14. The method of claim 8, wherein the first host computer further comprises a first storage device containing data associated with the at least one first host application.

17. The method of claim 16, wherein the list of control variables are stored on an auxiliary storage device.

19. The trainable system of claim 18, wherein the host computer is a remote host computer operating a remote host application.

15. In a trained system comprising a shaper computer operating a trainable user interface translator application and storing a shaper rule set, a training terminal electrically connected to the shaper computer, a first host computer electrically connected to the shaper computer and operating at least one first host application, and a second host computer electrically connected to the shaper computer and operating at least one second host application, a method of using the trained system to automatically transfer data between multiple host applications, comprising the steps of

generating and storing via the training terminal a list of control variables identifying data to be transferred from the at least one first host application to the at least one second host application;

and

starting via the training terminal the trainable user interface application in automatic mode, causing the trainable user interface translator application to survey the list of control variables and exercise the at least one first host application and at least one second host application in accordance with the shaper rule set, thereby transferring the identified data.

16. In a trainable system comprising a shaper computer operating a trainable user interface translator application and storing a shaper rule set, a training terminal electrically connected to the shaper computer, a first host computer electrically connected to the shaper computer and operating at least one first host application, and a second host computer electrically connected to the shaper computer and operating at least one second host application, a method of training the trainable system to generate a list of control values, comprising the steps of:

defining and storing via the training terminal one or more control variables associated with each step embodied in the business logic of either the at least one first host application or at least one second host application;

starting via the training terminal the trainable user interface translator application in training mode;

exercising via the training terminal the at least one first host application to generate a list of control variables; and

storing the list of control variables.

18. A trainable system for migrating data from an existing application to a storage format accessible to other applications, comprising:

a shaper computer operating a trainable user interface translator application and storing a shaper rule set and a list of control variables identifying data to be transferred;

a training terminal electrically connected to the shaper computer for establishing the shaper rule set the list of control variables during a training session;

a host computer electrically connected to the shaper computer, and operating at least one host application, thereby generating data streams that may be monitored by the shaper computer;

an auxiliary storage device electrically connected to the shaper computer for receiving data transferred from the at least one host application;

wherein the shaper computer monitors the data streams of the at least one host application and, according to the shaper rule set and list of control variables established during the training session, reinterprets and transmits automatically the data identified by the control variables to the auxiliary storage device.

20. In a trainable system comprising a shaper computer operating a trainable user interface translator application and storing a shaper rule set and control variables, a training terminal electrically connected to the shaper computer, a host computer electrically connected to the shaper computer and operating at least one host application, and an auxiliary storage device electrically connected to the shaper computer, a method of training the trainable system to migrate data from an existing application to a storage format accessible to other applications, comprising the steps of:

operating the trainable user interface translator application via the training terminal to define and store input and output variables associated with each step embodied in the business logic of the at least one host application;

defining and storing via the training terminal one or more control variables identifying data to be transferred between the at least one host application and the auxiliary storage device;

selecting sample data values for the control variables;

starting the user interface translator application in training mode;

exercising the at least one host application via the training terminal with the sample data values to obtain resultant output data, while storing the sequence of steps for exercising the at least one host application in the shaper rule set;

storing the resultant output data in the auxiliary storage device;

determining if the trainable system is fully trained to accommodate business processes associated with migrating data between the at least one host application and the auxiliary storage device, and if not, reverting to the step of exercising the at least one host application; and

determining if there are additional sample data values to process, and if so, reverting to the step of exercising the at least one host application.

21. The method of claim 20, wherein the host computer is a remote host computer operating at least one remote host application.

22. In a trained system comprising a shaper computer operating a trainable user interface translator application and storing a shaper rule set and control variables, a training terminal electrically connected to the shaper computer, a host computer electrically connected to the shaper computer and operating at least one host application, and an auxiliary storage device electrically connected to the shaper computer, a method of using the trained system to migrate data from an existing application to a storage format accessible to other applications, comprising the steps of:

generating and storing on the auxiliary storage device via the training terminal a list of control variables identifying data to be transferred from the at least one host application to the auxiliary storage device; and

starting via the training terminal the trainable user interface application in automatic mode, causing the trainable user interface translator application to survey the list of control variables and exercise the at least one first host application and at least one second host application in accordance with the shaper rule set, thereby migrating the identified data.

23. The method of claim 22, wherein the host computer is a remote host computer operating at least one remote host application.

25. The method of claim 24, wherein the host computer is a remote host computer operating at least one remote host application.

27. The trainable system of claim 26, wherein the host computer is a remote host computer operating at least one remote host application.

29. The method of claim 28, wherein the host computer is a remote host computer operating at least one remote host application.

24. In a trainable system comprising a shaper computer operating a trainable user interface translator application and storing a shaper rule set, a training terminal electrically connected to the shaper computer, a host computer electrically connected to the shaper computer and operating at least one host application, and an auxiliary storage device electrically connected to the shaper computer, a method of training the trainable system to pre-fetch a list of control values, comprising the steps of:

defining and storing via the training terminal one or more control variables associated with each step embodied in the business logic of the at least one host application and identifying the data to be migrated;

starting via the training terminal the trainable user interface translator application in training mode;

exercising via the training terminal the at least one host application to generate a list of control variables; and

storing the list of control variables in the auxiliary storage device.

26. A trainable system for migrating data from a particular storage format to an existing application that cannot otherwise access the data:

a shaper computer operating a trainable user interface translator application and storing a shaper rule set and a list of control variables identifying data to be transferred;

a training terminal electrically connected to the shaper computer for establishing the shaper rule set the list of control variables during a training session;

a host computer electrically connected to the shaper computer, and operating at least one first host application;

an auxiliary storage device electrically connected to the shaper computer, from which input data files may be retrieved by the shaper computer, the data files being otherwise inaccessible to the at least one host application;

wherein the shaper computer, according to the shaper rule set established during the training session, retrieves input data files from the auxiliary storage device and migrates the input data files to the at least one host application.

28. In a trainable system comprising a shaper computer operating a trainable user interface translator application and storing a shaper rule set, a training terminal electrically connected to the shaper computer, a host computer electrically connected to the shaper computer and operating at least one host application, and an auxiliary storage device electrically connected to the shaper computer, a method of training the trainable system to migrate data from a particular storage format to an existing application, comprising the steps of:

associating input values where used in the host application;

copying via the training terminal a test input file from a stored location to the auxiliary storage device;

starting the trainable user interface translator application in training mode;

exercising the at least one host application via the training terminal with a first record of the test input file to migrate the first record to the at least one host application, while recording the sequence of steps for exercising the at least one host application in the shaper rule set;

exercising the at least one host application via the training terminal with a next record of the test input file to migrate the next record to the at least one host application, utilizing and refining the shaper rule set to migrate the next record; and

determining if there are additional records in the test input file, and if so, reverting to the previous step.

30. In a trained system comprising a shaper computer operating a trainable user interface translator application and storing a shaper rule set, a training terminal electrically connected to the shaper computer, a host computer electrically connected to the shaper computer and operating at least one host application, and an auxiliary storage device electrically connected to the shaper computer, a method of using the trained system of the first or second aspects to migrate data from a particular storage format to an existing application, including the steps:

copying an input file from a source to the auxiliary storage device; and

starting the trainable user interface translator application in a normal run mode, causing the trainable user interface translator application to execute the shaper rule set thereby migrating the input file from the auxiliary storage device to the at least one host application.