System and method for cross-referencing information in an enterprise system
First Claim
Patent Images
1. A computer-implemented method comprising:
- generating a message using a first data system, whereinthe 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, whereinthe 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 recordthe intermediate hub is configured to transmit the modified message to the second data system for processing, andthe 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.
0 Assignments
0 Petitions
Accused Products
Abstract
A system and method for enabling the cross-referencing or linking of records in an enterprise system is disclosed.
65 Citations
15 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. - View Dependent Claims (2, 3)
-
-
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. - View Dependent Claims (5, 6)
-
-
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. - View Dependent Claims (8, 9)
-
-
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. - View Dependent Claims (11, 12, 13, 14)
-
-
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.
-
Specification