System and method for cross-referencing information in an enterprise system
원문보기
IPC분류정보
국가/구분
United States(US) Patent
등록
국제특허분류(IPC7판)
G06Q-030/02
G06F-017/30
출원번호
US-0401790
(2006-04-03)
등록번호
US-9881068
(2018-01-30)
발명자
/ 주소
Yeap, Hwee Har
Devireddy, Raj
Hsiao, Chiun-Feng
Liou, Ming-Tao
출원인 / 주소
Oracle America, Inc.
대리인 / 주소
Sheppard Mullin Richter & Hampton LLP
인용정보
피인용 횟수 :
0인용 특허 :
50
초록
A system and method for enabling the cross-referencing or linking of records in an enterprise system is disclosed.
대표청구항▼
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
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; andreceiving 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 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. 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; andmeans 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, 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. 5. The system of claim 4, wherein: the message comprises a body;the processor is configured to create an identifying information in the body; andthe 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; andinstructions 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; andat least one processor, wherein the processor is configured to execute instructions stored in the memory for 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, andproviding 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; andtransmitting 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.
연구과제 타임라인
LOADING...
LOADING...
LOADING...
LOADING...
LOADING...
이 특허에 인용된 특허 (50)
Kleinerman Aurel, Apparatus and method for high performance remote application gateway servers.
Burke, Miles D.; Solar, Jr., Richard J., Building business objects and business software applications using dynamic object definitions of ingrediential objects.
Reed Drummond Shattuck ; Heymann Peter Earnshaw ; Mushero Steven Mark ; Jones Kevin Benard ; Oberlander Jeffrey Todd, Computer-based communication system and method using metadata defining a control-structure.
Norihiro Hara JP; Nobuo Kawamura JP; Tomohiro Nakayama JP; Kiyomi Hirohata JP, Database processing method, apparatus for carrying out the same and medium storing processing program.
Beauchamp,Robert E.; Baker,Brian L.; Skufca,James D.; Wooldridge,Brett K., Enterprise workflow screen based navigational process tool system and method.
Tabu, Takashi; Murayama, Masami; Inoue, Sachiko; Suzuki, Hidehiko; Kubota, Yoshihiro; Ueki, Kohei, Hybrid exchange, an exchange, and a re-arrangement method for STM data in an exchange.
Levac Ronald A. ; Bilgrien Stephen D. ; Peters Michael J. ; Kuecherer Robert K., Intelligent messaging system and method for providing and updating a message using a communication device, such as a large character display.
Sasaki Takatsugu (Kawasaki JPX) Kabemoto Akira (Kawasaki JPX) Takahashi Hajime (Kawasaki JPX) Sugahara Horihide (Kawasaki JPX), Message control system for data communication system.
Helgeson,Chris; Lipkin,Daniel S.; Larson,Robert S.; Dufner,Michael L.; Mehra,Gaurav; Jain,Deepak, Method and apparatus for a business applications server management system platform.
Lipkin, Daniel S.; Mehra, Gaurav, Method and apparatus for an improved security system mechanism in a business applications management system platform.
Lyon Thomas ; Newman Peter ; Minshall Greg ; Hinden Robert ; Liaw Fong Ching ; Hoffman Eric ; Huston Lawrence B. ; Roberson William A., Method and apparatus for dynamically shifting between routing and switching packets in a transmission network.
Fakes Thomas F. ; Morais Dinarte ; Benson Max L., Method and computer program product for converting message identification codes using a conversion map accesible via a.
Willis Richard A. (West Clandon GBX) Markham Alan (Radlett NY GBX) Genshaft Robert S. (Plainview NY), Method and system for dynamically controlling the content of a local receiver data base from a transmitted data base in.
Lindberg, Henrik; Hallgren, Thomas, Method and system for transferring information between a user interface and a database over a global information network.
Mokuya,Senichi; Ehara,Shinji; Mori,Hozumi, Method for linking management-information database structure definition files, network device management system, and process program for linking management-information database structure definition f.
Schaefer Diane E. ; Kayser Steven L. ; Rajcan Steven L., Methods and apparatus for enabling a component in a first transaction processing environment to access a resource in another environment that is under the control of an Xatmi complaint transaction ma.
Chandra,Mala; Evans,Steven R.; Kruempelstaedter,John; Khalsa,Kirpal; McFarland,Joshua, Methods and apparatus providing electronic messages that are linked and aggregated.
Burroughs Tracy Kim ; Gansemer Steven John ; Lee Wilson D. ; Voldal Erik E. ; Rogers Cynthia Ann ; Zaborowski Laura Jane, Schema mapping to a legacy table with primary and foreign key support.
Lee,Wang Chien; Mitchell,Gail Anne; Rundensteiner,Elke Angelika; Zhang,Xin, System and method for synchronizing and/or updating an existing relational database with supplemental XML data.
Bashant, David M.; Buddenbaum, Donald E.; Denny, Michael L.; Yellin, Daniel M., System and method for synchronizing related data elements in disparate storage systems.
Chang Chia-Pei ; Connolly Brian J. ; Blackledge Eric ; Hoffman Robert John ; Homan Bob ; Schulz Klaus, System for integrating data among heterogeneous systems.
※ AI-Helper는 부적절한 답변을 할 수 있습니다.