System and method for cross-referencing information in an enterprise system

• US 9,881,068 B2
• Filed: 04/03/2006
• Issued: 01/30/2018
• Est. Priority Date: 06/27/2002
• Status: Active Grant

• Current Assignee: Oracle America, Inc. (Oracle Corporation)
• Original Assignee: Oracle America, Inc. (Oracle Corporation)
• Inventors: Yeap, Hwee Har, Devireddy, Raj, Hsiao, Chiun-Feng, Liou, Ming-Tao
• Primary Examiner(s): Herndon, Heather
• Assistant Examiner(s): Davanlou, Soheila (Gina)
• Application Number:
  US11/401,790
• Publication Number:
  US 20060200830A1
• Time in Patent Office: 4,320 Days
• Field of Search: 707 1, 707 9, 707100, 7071041, 707E17124, 707E17032, 709217-224
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising

Abstract

A system and method for enabling the cross-referencing or linking of records in an enterprise system is disclosed.

Claims

1. A computer-implemented method comprising:

generating a message using a first data system, wherein

the message is related to a transaction between the first data system and a second data system,

the message comprises information that relates to a first data record of a plurality of data records on the first data system and to a second data record of a plurality of data records on the second data system, wherein the first data record is in a first table in the first data system, the second data record is in a second table in the second data system, the first table is distinct from the second table, the first table comprises a first identifier for the first data record, the second table comprises a second identifier for the second data record, the first identifier is distinct from the second identifier, the information indicates that the intermediate identifier is associated with the first and second identifiers, and wherein the information indicates a system identifier for the first data system and a system identifier for the second data system,

the information associates a relationship between an object identifier corresponding to the first data record and a generic reference identifier;

transmitting the message to an intermediate hub that is separate from the first data system and from the second data system; and

receiving the message at the intermediate hub, wherein

the intermediate hub is configured to determine that the object identifier corresponding to the first data record needs to be updated based upon identifying the generic reference identifier,

the intermediate hub is configured to determine a corresponding identifier for the second data record based at least in part on the object identifier corresponding to the first data record,

the intermediate hub is configured to modify the message by replacing the object identifier corresponding to the first data record referenced in the message with the corresponding identifier for the second data record

the intermediate hub is configured to transmit the modified message to the second data system for processing, and

the intermediate hub being configured to modify any messages transmitted from the second data system to the first data system by replacing the corresponding identifier for the second data record with the object identifier corresponding to the first data record.

2. The method of claim 1, wherein the message comprises a body, the method further comprising:

including identifying information in the body, wherein the identifying information identifies the plurality of data records on the first data system and the plurality of data records on the second data system.

3. The method of claim 1, wherein the information comprises:

a unique identifier corresponding to the first and second data records.

4. A system comprising:

means for generating a message, wherein

the message is related to a transaction between a first data system and a second data system,

the message comprises information that relates to a first data record of a plurality of data records on the first data system and to a second data record of a plurality of data records on the second data system, wherein the first data record is in a first table in the first data system, the second data record is in a second table in the second data system, the first table is distinct from the second table, the first table comprises a first identifier for the first data record, the second table comprises a second identifier for the second data record, the first identifier is distinct from the second identifier, the information indicates that the intermediate identifier is associated with the first and second identifiers, and wherein the information indicates a system identifier for the first data system and a system identifier for the second data system,

the information associates a relationship between an object identifier corresponding to the first data record and a generic reference identifier;

means for transmitting the message to an intermediate hub that is separate from the first data system and from the second data system; and

means for receiving the message at the intermediate hub, wherein

the intermediate hub is configured to determine that the object identifier corresponding to the first data record needs to be updated based upon identifying the generic reference identifier,

the intermediate hub is configured to determine a corresponding identifier for the second data record based at least in part on the object identifier corresponding to the first data record,

the intermediate hub is configured to modify the message by replacing the object identifier corresponding to the first data record referenced in the message with the corresponding identifier for the second data record,

the intermediate hub is configured to transmit the modified message to the second data system for processing, and

the intermediate hub being configured to modify any messages transmitted from the second data system to the first data system by replacing the corresponding identifier for the second data record with the object identifier corresponding to the first data record.

5. The system of claim 4, wherein:

the message comprises a body;

the processor is configured to create an identifying information in the body; and

the identifying information identifies the plurality of data records on the first data system and the plurality of data records on the second data system.

6. The system of claim 4, further comprising:

means for creating, in the message, a unique identifier corresponding to the first and second data records.

7. A non-transitory computer-readable storage medium having encoded thereon program instructions executable by a processor, the program instructions comprising:

instructions for generating a message using a first data system, wherein

the message is related to a transaction between the first data system and a second data system,

the message comprises information that relates to a first data record of a plurality of data records on the first data system and to a second data record of a plurality of data records on the second data system, wherein the first data record is in a first table in the first data system, the second data record is in a second table in the second data system, the first table is distinct from the second table, the first table comprises a first identifier for the first data record, the second table comprises a second identifier for the second data record, the first identifier is distinct from the second identifier, the information indicates that the intermediate identifier is associated with the first and second identifiers, and wherein the information indicates a system identifier for the first data system and a system identifier for the second data system,

the information associates a relationship between an object identifier corresponding to the first data record and a generic reference identifier; and

instructions for transmitting the message to an intermediate hub that is separate from the first data system and from the second data system,

the intermediate hub being configured to modify the message by replacing the object identifier corresponding to the first data record with a corresponding identifier for the second data record that is referenced using the object identifier corresponding to the first data record.

8. The non-transitory computer-readable storage medium of claim 7, wherein the message comprises a body, the program instructions further comprising:

instructions for including identifying information in the body, wherein the identifying information identifies the plurality of data records on the first data system and the plurality of data records on the second data system.

9. The non-transitory computer-readable storage medium of claim 7, wherein the instructions for generating comprise:

instructions for creating, in the message, a unique identifier corresponding to the first and second data records.

10. A system comprising:

a memory; and

at least one processor, wherein the processor is configured to execute instructions stored in the memory for

generating a message using a first data system, wherein

the message is related to a transaction between the first data system and a second data system,

the message comprises information that relates to a first data record of a plurality of data records on the first data system and to a second data record of a plurality of data records on the second data system, wherein the first data record is in a first table in the first data system, the second data record is in a second table in the second data system, the first table is distinct from the second table, the first table comprises a first identifier for the first data record, the second table comprises a second identifier for the second data record, the first identifier is distinct from the second identifier, the information indicates that the intermediate identifier is associated with the first and second identifiers, and wherein the information indicates a system identifier for the first data system and a system identifier for the second data system, and

providing the message to an intermediate hub that is configured to insert mapping information in the message, the intermediate hub being separate from the first data system and the second data system, wherein

the mapping information indicates a relationship between the first data record among the plurality of data records on the first data system and the second data record among the plurality of data records on the second data system.

11. The system of claim 10, wherein the message comprises a body, and the processor is configured to execute instructions stored in the memory for:

including identifying information in the body, wherein the identifying information identifies the plurality of data records on the first data system and the plurality of data records on the second data system.

12. The system of claim 10, wherein the processor is configured to execute instructions stored in the memory for:

generating a reference identifier, wherein the reference identifier is associated with the first and second data records.

13. The system of claim 10, wherein the processor is configured to execute instructions stored in the memory for:

creating, in the message, a unique identifier corresponding to the first and second data records.

14. The system of claim 10, wherein the message comprises a body and multiple instances of the first data record in the body, and the generating of the message comprises:

associating a reference identifier with each instance of the first data record in the message.

15. A computer-implemented method comprising:

generating a message using a first system, wherein

the message is related to a transaction between the first data system and a second data system,

the transaction is related to a first data record of the first data system,

the first data record corresponds to a second data record of the second data system,

the first data record is identified by a first identifier,

wherein the first data record is in a first table in the first data system, the second data record is in a second table in the second data system, the first table is distinct from the second table, the first table comprises a first identifier for the first data record, the second table comprises a second identifier for the second data record, the first identifier is distinct from the second identifier, the information indicates that the intermediate identifier is associated with the first and second identifiers, and wherein the information indicates a system identifier for the first data system and a system identifier for the second data system; and

transmitting the message to an intermediate hub that is separate from the first data system and from the second data system, wherein

before transmitting the message to the second data system, the intermediate hub is configured to modify the message so that the first identifier referencing the first data record is replaced with the second identifier referencing the second data record, wherein the second data system recognizes the second identifier but not the first identifier.