Method, apparatus and system for transforming, converting and processing messages between multiple systems

• US 7,299,230 B2
• Filed: 08/02/2002
• Issued: 11/20/2007
• Est. Priority Date: 08/30/2001
• Status: Active Grant

• Current Assignee: Oracle America, Inc. (Oracle Corporation)
• Original Assignee: Siebel Systems Inc. (Oracle Corporation)
• Inventors: Hsiao, Chiun-Feng, Liou, Ming-Tao, Yeap, Hwee Har
• Primary Examiner(s): Alam; Shahid Al
• Application Number:
  US10/211,448
• Publication Number:
  US 20070226263A1
• Time in Patent Office: 1,936 Days
• Field of Search: 707 1- 10, 707100-1041, 707200-205, 455/550.1, 709/201, 709/230, 709/238, 709/242, 709/245, 709/246, 709/248, 705/4
• US Class Current: 1/1
• CPC Class Codes: G06F 16/275 Synchronous replication
• 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/99952 Coherency, e.g. same view to multiple users

Abstract

In one embodiment, the present invention is a method of sending change information from a first database to a second database. The method includes managing a set of transactions to produce a first message. The method also includes transforming the first message into a second message. The method further includes converting the second message into a transmittable message.

Claims

1. A method comprising:

sending change information from a first database to a second database, wherein

said sending change information comprises

processing a set of transactions to the first database to produce a first message, wherein said processing the set of transactions comprises

invoking a method, and

producing the first message using a result of said invoking,

transforming the first message into a second message, and

converting the second message into a transmittable message; and

wherein said converting the second message into the transmittable message comprises

processing a transaction of the second message in preparation for transmission of the transaction,

processing a data object associated with the transaction of the second message in preparation for transmission of the transaction, and

if an envelope is required for the transmittable message,

generating an envelope and headers,

attaching the processed transaction and the processed data objects to the envelope, and

including the envelope in the transmittable message.

2. The method of claim 1 wherein said processing the set of transactions comprises:

finding a change to the first database since a specified time or event;

translating the change into the first command;

finding a record identifier related to the change; and

performing the invoking the method for the first command and a record associated with the record identifier.

3. The method of claim 2 wherein processing the set of transactions to form the first message further comprises:

transforming the result of said invoking during a process of capturing the result.

4. The method of claim 1 wherein said transforming the first message into the second message comprises:

finding a command in the body of the first message, wherein

said finding the command comprises

finding a part of the first message,

identifying the part of the first message, and

traversing the part of the first message, if the part is identified as a body of the first message;

transforming the command in the body of the first message into newly formatted material; and

packaging the newly formatted material into the second message.

5. The method of claim 4 wherein said transforming the first message into the second message further comprises:

processing a header portion of the first message; and

passing through non-commands of the body portion of the first message.

6. The method of claim 1 wherein said converting the second message into the transmittable message further comprises:

generating processing instructions for the transaction; and

assembling the processed transaction, processed data objects, and processing instructions into the transmittable message.

7. The method of claim 6 wherein said processing the transaction of the second message comprises:

customized pre-processing of the transactions of the second message; and

default processing of the transactions.

8. A method comprising:

finding a change to a first set of data since a specified time or event;

translating the change into a first command;

finding a record identifier related to the change;

invoking a method for the first command and a record associated with the record identifier;

producing a first message using a result of said invoking;

finding a second command in the first message, wherein

said finding the second command comprises

finding a part of the first message,

identifying the part of the first message, and

traversing the part of the first message, if the part is identified as a body of the first message;

transforming the second command using a first predefined rule;

packaging a transformed second command into a second message;

processing a transaction of the second message in preparation for transmission of the transaction;

processing a data object associated with the transaction in preparation for transmission of the transaction;

generating processing instructions for the transaction; and

assembling the processed transaction, processed data objects, and processing instructions into a transmittable message.

9. The method of claim 8 further comprising:

determining whether an envelope is required for the transmittable message;

generating an envelope and headers if said determining indicates that the envelope is required; and

attaching the processed transaction and the processed data objects to the envelope if the envelope is present; and

including the envelope in the transmittable message.

10. The method of claim 8 further comprising:

processing a header portion of the first message; and

passing through non-commands of the body portion of the first message.

11. The method of claim 8 wherein producing the first message comprises:

transforming the result of said invoking during a process of capturing the result.

12. The method of claim 8 wherein processing the transaction of the second message comprises:

customized pre-processing of the transaction of the second message; and

default processing of the transaction of the second message.

13. A machine-readable storage medium embodying instructions, which, when executed by a processor, cause the processor to perform a method of sending change information from a first database to a second database, the method comprising:

processing a set of transactions to the first database to produce a first message;

transforming the first message into a second message;

converting the second message into a transmittable message; and

wherein said converting the second message into the transmittable message comprises

processing a transaction of the second message in preparation for transmission of the transaction,

processing a data object associated with the transaction of the second message in preparation for transmission of the transaction, and

if an envelope is required for the transmittable message,

generating an envelope and headers,

attaching the processed transaction and the processed data objects to the envelope, and

including the envelope in the transmittable message.

14. The machine-readable storage medium of claim 13 further embodying instructions which, when executed by the processor, cause the processor to perform the method further comprising:

finding a change to the first database since a specified time or event;

translating the change into a first command;

finding a record identifier related to the change;

invoking a method for the first command and a record associated with the record identifier; and

producing a first message using a result of said invoking.

15. The machine-readable storage medium of claim 14 further embodying instructions which, when executed by the processor, further cause the processor to perform processing the set of transactions to form the first message the method further comprising:

transforming the result of said invoking during a process of capturing the result.

16. The machine-readable storage medium of claim 13 further embodying instructions which, when executed by the processor, cause the processor to perform transforming the first message into the second message, the method further comprising:

finding a command in the body of the first message, wherein

said finding the command comprises

finding a part of the first message,

identifying the part of the first message, and

traversing the part of the first message, if the part is identified as a body of the first message;

transforming the command in the body of the first message into newly formatted material; and

packaging die newly formatted material into the second message.

17. The machine-readable storage medium of claim 16 further embodying instructions which, when executed by the processor, further cause the processor to perform said transforming the first message into the second message the method further comprising:

processing a header portion of the first message; and

passing through non-commands of the body portion of the first message.

18. The machine-readable storage medium of claim 13 further embodying instructions which, when executed by the processor, cause the processor to perform said converting the second message into the transmittable message, the method further comprising:

generating processing instructions for the transaction; and

assembling the processed transaction, processed data objects, and processing instructions into the transmittable message.

19. The machine-readable storage medium of claim 18 further embodying instructions which, when executed by the processor, further cause the processor to perform said processing the transaction of the second message the method further comprising:

customized pre-processing of the transactions of the second message; and

default processing of the transactions.

20. An apparatus comprising:

a manager module configured to process a set of transactions to a first set of data to produce a first message;

a transformer module configured to transform the first message into a second message;

a converter module configured to

convert the second message into a transmittable message,

process a transaction of the second message in preparation for transmission of the transaction,

process a data object associated with the transaction of the second message in preparation for transmission of the transaction, and

if an envelope is required for the transmittable message,

generate an envelope and headers,

attach the processed transaction and the processed data objects to the envelope, and

include the envelope in the transmittable message;

a processor, wherein the Processor is configured to execute at least one of the manager module, the transformer module and the converter module; and

a memory, wherein

the memory and the processor are coupled to one another, and

the memory is configured to store at least one of the selecting module, the determining module, the comparing module and the generating module.

21. The apparatus of claim 20 wherein the manager module is further configured to:

find a change to the first set of data since a specified time or event;

translate the change into a first command,

find a record identifier related to the change,

invoke a method for the first command and the record associated with the record identifier, and

produce the first message using a result of said invoking the method.

22. The apparatus of claim 21 wherein the manager module is further configured to:

transform the result of said invoking during a process of capturing the result.

23. The apparatus of claim 20 wherein said transformer module is further configured to:

find a command in the body of the first message, wherein

to find the command comprises

finding a part of the first message,

identifying the part of the first message, and

traversing the part of the first message, if the part is identified as a body of the first message;

transform the command in the body of the first message into newly formatted material; and

package the newly formatted material into the second message.

24. The apparatus of claim 23 wherein said transformer module is further configured to:

process a header portion of the first message; and

pass through non-commands of the body portion of the first message.

25. The apparatus of claim 20 wherein the converter module is further configured to:

generate processing instructions for the transaction; and

assemble the processed transaction, processed data objects, and processing instructions into the transmittable message.