Method for allowing simple interoperation between backend database systems

• US 7,099,891 B2
• Filed: 06/15/2001
• Issued: 08/29/2006
• Est. Priority Date: 06/15/2001
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Harris, Clifford Vernon, Sundaresan, Neelakantan, Krishna, Vikas, McCurley, Kevin Snow, Kreulen, Jeffrey Thomas, Strong, Hovey Raymond Jr., Rollins, Sami Nicole
• Primary Examiner(s): Wong, Don
• Assistant Examiner(s): Black, Linh
• Application Number:
  US09/882,634
• Publication Number:
  US 20020194357A1
• Time in Patent Office: 1,901 Days
• Field of Search: 707 1-203
• US Class Current: 707/754
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• 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/08 Protocols for interworking; Protocol conversion
• CPC Class Codes: H04L 69/329 in the application layer [OSI layer 7]
• CPC Class Codes: H04L 9/40 Network security protocols
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

According to a preferred embodiment of the present invention, a bridging system (100) and method provides a way of linking two independent data systems by receiving a dataset from a source data system. The bridging system (100) translates the dataset from a source schema to a target schema according to a set of mapping rules, and queues the translated data in persistent storage, and then sends the translated dataset to a destination data system. The system (100) includes an XML bridge (114), multiple application specific gateways (116,118), and a web admin interface (210), all in communication via a wide area network.

Claims

1. A method comprising the steps of:

receiving a dataset from a source data system, the dataset including a set of data elements with corresponding data values;

translating the dataset from a source schema to a target schema according to a set of mapping rules, each schema including a set of data elements and a set of relationships among the data elements, each mapping rule including a type and instructions for obtaining one or more target data element values as a function of one or more source data element values, the type containing all the information about relationships among data elements used by the function;

queuing the translated dataset in persistent storage; and

sending the translated dataset from the persistent storage to a destination data system, wherein there are three prespecified types that are defined generally for XML documents;

a first type restricting the function to one target data element that is restricted from repeating in the target dataset by the relationships of the target schema and to any number of source data elements that are restricted from repeating in the source dataset by the relationships of the source schema;

a second type restricting the function to one instance of a group comprising multiple data elements that are restricted to repeat as a group by the relationships of the target schema and to any number of source data elements that are restricted from repeating in the source dataset by the relationships of the source schema; and

a third type restricting the function to a first number of instances of a group comprising multiple data elements that are restricted to repeat as a group by the relationships of the target schema, a second number of instances of a group comprising multiple data elements that are restricted to repeat as a group by the relationships of the source schema, and any number of source data elements that are restricted from repeating in the source dataset by the relationships of the source schema, the first and second numbers being equal.

2. The method of claim 1, wherein the step of queuing comprises the steps of:

assigning a key to each new request; and

storing a translated dataset in the persistent memory.

3. The method of claim 1, wherein the instructions of each mapping rule comprise a computer program.

4. The method of claim 3, wherein the computer program comprises a Java program.

5. The method of claim 4, wherein the computer program refers only methods of the Java String class.

6. The method of claim 1, further comprising the steps of:

waiting a set period of time to receive an ACK from the destination system;

retrying to send the translated dataset to the destination system a set number of times;

signaling an error if the ACK is not received; and

upon receipt of the ACK, removing the translated dataset from the persistent memory.

7. A method comprising the steps of:

receiving an XML document from a source data system, the XML document including a set of data elements with corresponding data values;

translating the XML document from a source schema to a target schema according to a set of mapping rules, each schema including a set of data elements and a set of relationships among the data elements, each mapping rule including a type and instructions for obtaining one or more target data element values as a function of one or more source data element values, the type containing all the information about relationships among data elements used by the function;

queuing the translated XML document in persistent storage; and

sending the translated XML document from the persistent storage to a destination data system, wherein there are three prespecified types that are defined generally for XML documents;

a first type restricting the function to one target data element that is restricted from repeating in the target XML document by the relationships of the target schema and to any number of source data elements that are restricted from repeating in the source XML document by the relationships of the source schema,

a second type restricting the function to one instance of a group comprising multiple data elements that are restricted to repeat as a group by the relationships of the target schema and to any number of source data elements that are restricted from repeating in the source XML document by the relationships of the source schema, and

a third type restricting the function to a first number of instances of a group comprising multiple data elements that are restricted to repeat as a group by the relationships of the target schema, a second number of instances of a group comprising multiple data elements that are restricted to repeat as a group by the relationships of the source schema, and any number of source data elements that are restricted from repeating in the source XML document by the relationships of the source schema, the first and second numbers being equal.

8. The method of claim 7, wherein the step of queuing includes the steps of:

assigning a key to each new request; and

storing a translated XML document in persistent memory.

9. The method of claim 7, wherein the instructions of each mapping rule include a computer program.

10. The method of claim 9, wherein the computer program includes a Java program.

11. The method of claim 10, wherein the computer program refers only methods of the Java String class.

12. The method of claim 7, further comprising the steps of:

waiting a set period of time to receive an ACK from the destination system;

retrying to send the translated XML document to the destination system a set number of times;

signaling an error if the ACK is not received; and

upon receipt of the ACK, removing the translated XML document from the persistent memory.