Graphical user interface for creating database integration specifications

• US 5,721,912 A
• Filed: 08/05/1994
• Issued: 02/24/1998
• Est. Priority Date: 08/05/1994
• Status: Expired due to Fees

• Current Assignee: Data Integration Works LLC
• Original Assignee: Data Integration Solutions Corp.
• Inventors: Materna, Anthony T., Hays, Boyd, Stepczyk, Frank M.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): LEWIS, CHERYL RENEA
• Application Number:
  US08/286,688
• Time in Patent Office: 1,299 Days
• Field of Search: 395/600, 395/613, 395/611, 395/612, 395/614, 395/615, 395/208, 395/677
• US Class Current: 1/1
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

The present invention provides a method, and corresponding apparatus, for interactively creating database integration specifications comprising a workflow specification, communication scripts, and data translators. The invention includes steps and means for interactively creating a workflow specification which graphically depicts the flow of control and data among the various communication scripts and data translators. Each communication script, data translator, or other integration object that is part of the overall workflow specification is graphically represented by corresponding, cursor-sensitive display objects. These display objects are then interactively interconnected so as to depict the desired flow of control and data. The method further includes steps and means for specifying content for the actual communication scripts and data translators. Specifying a particular communication script or data translator is preferably initiated by interactively selecting the cursor-sensitive display object corresponding to that particular communication script or data translator. In a further feature of the invention, software data objects representing the communication scripts, data translators, and the workflow specification are stored in an object-oriented database. The database integration specification is ultimately compiled into executable form.

Claims

1. A method for interactively creating a database integration specification, said database integration specification comprising a graphical workflow specification, one or more communication scripts, and one or more data translators, said method comprising the following steps:

providing a graphical user interface for forming the graphical workflow specification including the steps of generating a plurality of cursor-sensitive display objects corresponding to the communication scripts and the data translators; and

interconnecting the plurality of display objects so as to depict a flow of control and data among the corresponding communication scripts and data translators, thereby forming the graphical workflow specification;

specifying the communication scripts;

specifying the data translators; and

compiling the database integration specification into an executable format.

2. The method of claim 1, wherein the plurality of display objects further includes at least one display object corresponding to a conditional branch.

3. The method of claim 1 further including the step of storing, in an object-oriented database, a plurality of data objects for describing the database integration specification.

4. The method of claim 1 wherein the steps of specifying the communication scripts and the data translators each include the step of interactively selecting the cursor-sensitive display objects corresponding to the respective communication scripts and data translators.

5. The method of claim 1 wherein the step of specifying the communication scripts further includes the steps of capturing a user communication session, converting the user communication session into an SDL script, and editing the SDL script.

6. The method of claim 4 wherein the step of converting the user communication session into an SDL script further includes the step of automatically generating an abbreviated version of the user communication session.

7. The method of claim 1 wherein the step of specifying the data translators further includes the step of displaying, in a single window, a plurality of input field definitions, along with a plurality of output field definitions, each of the output field definitions corresponding to one or more of the input field definitions.

8. An apparatus for interactively creating a database integration specification, said database integration specification comprising a graphical workflow specification, one or more communication scripts, and one or more data translators, said apparatus comprising:

graphical user interface means for forming a graphical workflow specification including means for generating a plurality of cursor-sensitive display objects corresponding to the communication scripts and the data translators; and

means for interconnecting the plurality of display objects so as to depict a flow of control and data among the corresponding communication scripts and the data translators, thereby forming the graphical workflow specification;

means for specifying the communication scripts;

means for specifying the data translators; and

means for compiling the database integration specifying into an executable format.

9. The apparatus of claim 8, wherein the plurality of display objects further includes at least one display object corresponding to a conditional branch.

10. The apparatus of claim 8 further including an object-oriented database storing a plurality of objects describing the database integration specification.

11. The apparatus of claim 8 wherein the means for specifying the communication scripts and the data translators each include means for interactively selecting the cursor-sensitive display objects corresponding to the respective communication scripts and data translators.

12. The apparatus of claim 8 wherein the means for specifying the communication scripts further include means for capturing a user communication session, means for converting the user communication session into an SDL script, and means for editing the SDL script.

13. The apparatus of claim 12 wherein the means for converting the user communication session into an SDL script further include means for automatically generating an abbreviated version of the user communication session.

14. The apparatus of claim 8 wherein the means for specifying the data translators further include means for displaying, in a single window, a plurality of input field definitions, along with a plurality of output field definitions, each of the output field definitions corresponding to one or more of the input field definitions.