IP Library › Granted Patent US 7,743,065
Granted Patent B2
US 7,743,065 · App. 10/183,021 · Granted Jun 22, 2010

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

View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 7,743,065
App. No.
10/183,021
Granted
Jun 22, 2010
Kind
B2
Abstract

Data objects can be cross-referenced or linked between multiple systems by normalizing the communications between the multiple systems rather than creating hard code links. The normalization includes creating and inserting data mapping information in messages exchanged by the multiple systems, according to certain embodiments. According to certain other embodiments, an alert mechanism may be included in the message to indicate that mapping information is present in the message.

Claims (106)

1. A method executable on a computer, the method comprising:

detecting a first identifier in a message generated by a first data system, wherein

the message comprises a transaction data and the first identifier, and

the first identifier identifies data that is stored in the first data system and that corresponds to the transaction data;

generating an intermediate identifier;

adding a first cross-reference information into the message, wherein

the first cross-reference information comprises the intermediate identifier, and

the first cross-reference information indicates that the intermediate identifier is associated with the first identifier;

adding a second cross-reference information into the message, wherein

the second cross-reference information indicates that the intermediate identifier is associated with a second identifier, and

the second identifier identifies data that is stored in a second data system and that corresponds to the transaction data;

detecting, using the computer, a repeated instance of the first identifier in the message;

detecting a repeated instance of the transaction data in the message;

replacing, using the computer, the repeated instance of the first identifier with the intermediate identifier;

deleting the repeated instance of the transaction data in the message;

transmitting the message from the first data system to an intermediate hub after the replacing and prior to the adding the second cross-reference information into the message, and

transmitting the message from the intermediate hub to the second data system after the adding the second cross-reference information into the message.

2. The method of claim 1 , wherein the transmitting the message from the first data system comprises:

transmitting the message from the first data system to the intermediate hub after the adding the first cross-reference information into the message.

3. The method of claim 1 , further comprising:

generating a third identifier corresponding to the intermediate identifier, wherein the third identifier identifies data that is stored in an enterprise comprising the first and second data systems and that corresponds to the transaction data; and

adding a third cross-reference information into the message, wherein the third cross-reference information indicates that the intermediate identifier is associated with the third identifier.

4. The method of claim 1 , wherein the second data system is a legacy system.

5. The method of claim 1 , wherein the second identifier identifies data that is stored in an enterprise comprising the first and second data systems and that corresponds to the transaction data.

6. The method of claim 1 , wherein the message comprises data formatted in Extensible Markup Language (XML).

7. The method of claim 1 , wherein

the first cross-reference information comprises the first identifier.

8. A computer-readable storage medium comprising computer code configured to cause a computer to execute a method comprising:

detecting a first identifier in a message generated by a first data system, wherein

the message comprises a transaction data and the first identifier, and

the first identifier identifies data that is stored in the first data system and that corresponds to the transaction data;

generating an intermediate identifier;

adding a first cross-reference information into the message, wherein

the first cross-reference information comprises the intermediate identifier, and

the first cross-reference information indicates that the intermediate identifier is associated with the first identifier;

adding a second cross-reference information into the message, wherein

the second cross-reference information indicates that the intermediate identifier is associated with a second identifier, and

the second identifier identifies data that is stored in a second data system and that corresponds to the transaction data;

detecting a repeated instance of the first identifier in the message;

detecting a repeated instance of the transaction data in the message; and

replacing the repeated instance of the first identifier with the intermediate identifier;

deleting the repeated instance of the transaction data in the message; and

transmitting the message from the first data system to an intermediate hub after the replacing and prior to the adding the second cross-reference information into the message, and

transmitting the message from the intermediate hub to the second data system after the adding the second cross-reference information into the message.

9. The computer-readable medium of claim 8 , wherein the computer-readable medium comprises a memory and the transmitting the message from the first data system comprises:

transmitting the message from the first data system to the intermediate hub after the adding the first cross-reference information into the message.

10. The computer-readable medium of claim 8 , wherein the method further comprises:

generating a third identifier corresponding to the intermediate identifier, wherein the third identifier identifies data that is stored in an enterprise comprising the first and second data systems and that corresponds to the transaction data; and

adding a third cross-reference information into the message, wherein the third cross-reference information indicates that the intermediate identifier is associated with the third identifier.

11. The computer-readable medium of claim 8 , wherein the second data system is a legacy system and the second identifier identifies data that is stored in an enterprise comprising the first and second data systems and that corresponds to the transaction data.

12. The computer-readable medium of claim 8 , wherein:

the first cross-reference information comprises the first identifier.

13. A system comprising:

means for detecting a first identifier in a message generated by a first data system, wherein

the message comprises a transaction data and the first identifier, and

the first identifier identifies data that is stored in the first data system and that corresponds to the transaction data;

a memory for storing the first identifier;

means for generating an intermediate identifier;

means for adding a first cross-reference information into the message, wherein

the first cross-reference information comprises the intermediate identifier, and

the first cross-reference information indicates that the intermediate identifier is associated with the first identifier;

means for adding a second cross-reference information into the message, wherein

the second cross-reference information comprises the intermediate identifier, and

the second cross-reference information indicates that the intermediate identifier is associated with a second identifier, and

the second identifier identifies data that is stored in a second data system and that corresponds to the transaction data;

means for detecting a repeated instance of the first identifier in the message;

means for detecting a repeated instance of the transaction data in the message;

means for replacing the repeated instance of the first identifier with the intermediate identifier

means for transmitting the message from the first data system to an intermediate hub after the replacing and prior to the adding the second cross-reference information into the message, and

means for transmitting the message from the intermediate hub to the second data system after the adding the second cross-reference information into the message.

14. The system of claim 13 , wherein the means for transmitting the message from the first data system comprises:

means for transmitting the message from the first data system to the intermediate hub after the first cross-reference information has been added into the message and prior to the second cross-reference information being added into the message.

15. The system of claim 13 , further comprising:

means for generating a third identifier corresponding to the intermediate identifier, wherein the third identifier identifies data that is stored in an enterprise comprising the first and second data systems and that corresponds to the transaction data; and

means for adding a third cross-reference information into the message, wherein the third cross-reference information indicates that the intermediate identifier is associated with the third identifier.

16. The system of claim 13 , wherein the message comprises data formatted in Extensible Markup Language (XML).

17. The system of claim 13 , wherein:

the first cross-reference information comprises the first identifier;

the second cross-reference information comprises the second identifier.

18. A system comprising:

a memory configured to store a message generated by a first data system, wherein

the message comprises a transaction data and a first identifier, and

the first identifier identifies data that is stored in the first data system and that corresponds to the transaction data;

a modification module configured to

generate an intermediate identifier,

add a first cross-reference information into the message, wherein

the first cross-reference information comprises the intermediate identifier, and

the first cross-reference information indicates that the intermediate identifier is associated with the first identifier,

detect a repeated instance of the first identifier in the message,

detect a repeated instance of the transaction data in the message,

replace the repeated instance of the first identifier with the intermediate identifier, and

delete the repeated instance of the transaction data in the message;

a communications port; and

a transmission module configured to transmit the message through the communications port to an intermediate hub, wherein the intermediate hub is configured to:

add a second cross-reference information into the message, wherein

the second-cross reference information indicates that the intermediate identifier is associated with a second identifier, and

the second identifier identifies data that is stored in a second data system and that corresponds to the transaction data, and

communicate the message from the first data system to the intermediate hub, wherein the communicating the message from the first data system is performed after the replacing the repeated instance and prior to the adding the second cross-reference information into the message, and

transmit the message from the intermediate hub to the second data system after the adding the second cross-reference information into the message.

19. The system of claim 18 , wherein the modification module is further configured to:

generate a third identifier corresponding to the intermediate identifier, wherein the third identifier identifies data that is stored in an enterprise comprising the first and second data systems and that corresponds to the transaction data; and

add a third cross-reference information into the message, wherein the third cross-reference information indicates that the intermediate identifier is associated with the third identifier.

20. The system of claim 18 , wherein the second data system is a legacy system.

21. The system of claim 18 , wherein the second identifier identifies data that is stored in an enterprise comprising the first and second data systems and that corresponds to the transaction data.

22. The system of claim 18 , wherein:

the first cross-reference information comprises the first identifier.

Assignments (1)
MERGER Recorded Feb 5, 2016
From: SIEBEL SYSTEMS, INC.
To: ORACLE AMERICA, INC.
Reel/Frame 037702/0505 →