Data exchange method and system

• US 20030195765A1
• Filed: 04/10/2003
• Published: 10/16/2003
• Est. Priority Date: 04/10/2002
• Status: Abandoned Application

• Current Assignee: RSG Systems, Inc.
• Original Assignee: RSG Systems, Inc.
• Inventors: Duggal, Rukun, Arcot, Ramakant, Sehgal, Mukesh
• Application Number:
  US10/411,580
• Publication Number:
  US 20030195765A1
• Time in Patent Office: Days
• US Class Current: 705/1.1
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems

Abstract

Systems and methods for integrating data between disparate systems is provided which may include receiving one or more first publisher data records at a processing computer, the first publisher data records being received from a first publisher system and comprising data extracted from a first publisher database and arranged in the first publisher data records in one or more first publisher fields according to a first publisher template. One or more of the first publisher fields correspond to one or more fields of the first publisher database. The systems and methods may also include parsing all or a portion of the data from one or more of the first publisher data records into one or more corresponding first recipient data records according to a master template. The data is arranged in one or more of the first recipient data records in one or more first recipient fields according to a first recipient template. In addition, the master template includes one or more master fields for establishing a mapping between one or more first publisher fields of the first publisher data records and one or more first recipient fields of the first recipient data records.

Claims

1. A method for integrating data between computer systems comprising:

extracting data from a first publisher database of a first publisher system to create one or more first publisher data records, wherein data in one or more of the first publisher data records is arranged in one or more first publisher fields according to a first publisher template, wherein one or more of the first publisher fields correspond to one or more fields of the first publisher database; and

parsing all or a portion of the data from one or more of the first publisher data records into one or more corresponding first recipient data records according to a master template, wherein data is arranged in one or more of the first recipient data records in one or more first recipient fields according to a first recipient data template, and wherein the master template includes one or more master fields for establishing a mapping between one or more first publisher fields of the first publisher data records and one or more first recipient fields of the first recipient data records.

2. The method according to claim 1, wherein one or more first recipient data records are stored in a first recipient database.

3. The method according to claim 1, further comprising parsing all or a portion of the data from one or more first publisher records into one or more corresponding second recipient data records according to the master template, wherein data is arranged in one or more of the second recipient data records in one or more second recipient fields according to a second recipient template, and wherein one or more master fields establish a mapping between one or more first publisher fields of the first publisher data records and one or more second recipient fields of the second recipient data records.

4. The method according to claim 3, wherein the first recipient data records are designated for a first recipient system and wherein the second recipient data records are designated for a second recipient system.

5. The method according to claim 1, further comprising:

extracting data from a second publisher database of a second publisher system to create one or more second publisher data records, wherein data in one or more second publisher data records is arranged in one or more second publisher fields according to a second publisher template, and wherein one or more second publisher fields correspond to one or more fields of the second publisher database; and

parsing all or a portion of the data from one or more second publisher data records into one or more corresponding first recipient data records according to the master template, the data being arranged in one or more of the first recipient data records in one or more first recipient fields according to the first recipient data template and wherein one or more of the master fields establish a mapping between one or more second publisher fields of the second publisher data records and one or more first recipient fields of the first recipient data records.

6. The method according to claim 5, further comprising parsing all or a portion of the data from one or more second publisher data records into one or more corresponding second recipient data records according to the master template, wherein the data being arranged in one or more of the second recipient data records in one or more second recipient fields according to the second recipient template, and wherein one or more of the master fields establishes a mapping between one or more second publisher fields of the second publisher records and one or more second recipient fields of the second recipient data records.

7. A method for integrating data between computer systems comprising:

receiving one or more first publisher data records, the first publisher data records being received from a first publisher system and comprising data extracted from a first publisher database and arranged in the first publisher data records in one or more first publisher fields according to a first publisher template, wherein one or more first publisher fields correspond to one or more fields of the first publisher database; and

parsing all or a portion of the data from one or more first publisher data records into one or more corresponding first recipient data records according to a master template, wherein the data being arranged in one or more of the first recipient data records in one or more first recipient fields according to a first recipient template, and wherein the master template includes one or more master fields for establishing a mapping between one or more first publisher fields of the first publisher data records and one or more first recipient fields of the first recipient data records.

8. The method according to claim 7, further comprising parsing all or a portion of the data from one or more first publisher records into one or more corresponding second recipient data records according to the master template, wherein data is arranged in one or more of the second recipient data records in one or more second recipient fields according to a second recipient template, and wherein one or more master fields establish a mapping between one or more first publisher fields of the first publisher data records and one or more second recipient fields of the second recipient data records.

9. The method according to claim 7, further comprising:

receiving extracted data from a second publisher database of a second publisher system to create one or more second publisher data records, wherein data in one or more second publisher data records is arranged in one or more second publisher fields according to a second publisher template, and wherein one or more second publisher fields correspond to one or more fields of the second publisher database; and

parsing all or a portion of the data from one or more second publisher data records into one or more corresponding first recipient data records according to the master template, the data being arranged in one or more of the first recipient data records in one or more first recipient fields according to the first recipient data template and wherein one or more of the master fields establish a mapping between one or more second publisher fields of the second publisher data records and one or more first recipient fields of the first recipient data records.

10. The method according to claim 9, further comprising parsing all or a portion of the data from one or more second publisher data records into one or more corresponding second recipient data records according to the master template, wherein the data being arranged in one or more of the second recipient data records in one or more second recipient fields according to the second recipient template, and wherein one or more of the master fields establishes a mapping between one or more second publisher fields of the second publisher records and one or more second recipient fields of the second recipient data records.

11. The method according to claim 7, further comprising forwarding one or more first recipient data records to a first recipient system for storing all or a portion of the data from one or more first recipient data records into a first recipient database.

12. The method according to claim 7, wherein the data is extracted from the first publisher database at a predetermined time.

13. The method according to claim 7, wherein one or more first recipient data records are forwarded to the first recipient system according to a predetermined protocol.

14. The method according to claim 7, wherein one or more first recipient data records include a second format different from a first format of the first publisher data records.

15. The method according to claim 7, wherein the first recipient template includes a related child template having child template fields corresponding to a nested data structure within the first recipient template.

16. A method for integrating data between computer systems comprising:

receiving a plurality of sets of one or more respective publisher data records each from a respective publisher system,

parsing all or a portion of the data in each set of publisher data records into one or more sets of respective recipient data records for a respective recipient system according to a master template, wherein;

the data contained in each respective set of publisher records is arranged according to a respective publisher template,

the data in each respective set of recipient records is arranged according to a respective recipient template, and

the master template includes one or more master fields for establishing a mapping between one or more of the respective publisher fields of one or more of the respective sets of publisher data records and one or more of the respective recipient fields of one or more respective sets of recipient data records.

17. A system for integrating data between computer systems comprising:

a processing computer system for receiving one or more first publisher data records, the one or more first publisher data records comprising data extracted from a first publisher database of a first publisher system and arranged in one or more first publisher fields according to a first publisher template, wherein one or more of the first publisher fields correspond to one or more fields of the first database;

a processor for processing the data in one or more of the first publisher data records by parsing all or a portion of the data in the one or more first publisher data records into one or more corresponding first recipient data records according to a master template, wherein the data being arranged in the one or more first recipient data records in one or more first recipient fields according to a first recipient template, and wherein the master template includes one or more master fields for establishing a mapping between one or more first publisher fields of the first publisher data records and one or more recipient fields of the first recipient data records.

18. The system according to claim 17, wherein the processing computer system receives the one or more first publisher data records from a first publisher system in communication with the processing computer system.

19. The system according to claim 17, wherein one or more first recipient data records are sent to a second system.

20. The system according to claim 17, wherein the first publisher system communicates with the processing computer system via a computer network.

21. The system according to claim 20, wherein the computer network is selected from the group consisting of:

a wired network, a wireless network, a LAN, a WAN, and the Internet.

22. The system according to claim 17, wherein the processing computer system archives the first publisher data records and/or the first recipient data records.

23. The system according to claim 17, wherein the processing computer system encrypts the first recipient data records.

24. The system according to claim 17, wherein the processing of data for parsing is carried out in real time.

25. The system according to claim 19, wherein the first recipient records are sent to the first recipient system at a predetermined time.

26. The system according to claim 25, wherein the predetermined time is determined according to a recurring schedule.

27. The system according to claim 17, wherein the first recipient template includes a related child template for arranging nested data within the first recipient data records, and wherein the related child template includes one or more child template fields which correspond to one or more fields of the master template.

28. A system for integrating data between computer systems comprising:

a client application operating on a first publisher system for extracting data from a first publisher database and arranging the extracted data into one or more first publisher data records, wherein the data in the one or more publisher data records is arranged in one or more first publisher fields according to a first publisher template, and wherein one or more first publisher fields correspond to one or more fields of the first database; and

a processing computer in communication with the first publisher system, the processing computer receiving one or more first publisher data records and operating a processing application for;

parsing all or a portion of the data from one or more first publisher data records into one or more corresponding first recipient records using a master template, the data being arranged in one or more first recipient data records in one or more first recipient fields according to a first recipient data template, wherein the master template includes one or more master fields for establishing a mapping between one or more first publisher fields of the first publisher records and one or more first recipient fields of the first recipient data records,

wherein the processing computer forwards the first recipient data records to a first recipient system.

29. A method for integrating data over a computer network, the computer network allowing communication between a processing computer, a plurality of publisher systems and a plurality of recipient systems in communication with the processing computer, the method comprising:

receiving one or more sets of data extracted from a respective database of a respective publisher system to create one or more sets of one or more respective publisher data records, wherein;

the data in each set of one or more publisher data records is arranged in one or more publisher fields according to a respective publisher template of a particular publisher system, and

the one or more of the respective publisher fields correspond to one or more fields of the respective publisher database,

forwarding each set of publisher data records to the processing computer;

using the processing computer, parsing all or a portion of the data contained in each set of publisher data records into one or more corresponding sets of one or more recipient data records according to a master template, wherein;

each set of recipient data records is for a particular recipient system,

the data in each set of recipient data records being arranged in one or more respective recipient data fields according to a respective recipient template of a particular recipient system,

the master template includes one or more master fields for establishing a mapping between one or more respective publisher fields of one or more sets of publisher data records and one or more respective recipient fields of one or more sets of recipient data records, and

forwarding each respective set of recipient data records to a respective recipient system.

30. A system for integrating data between computer systems comprising:

a processing system for communicating with a plurality of publisher systems and for communicating with a plurality of recipient systems wherein;

each publisher system extracts one or more sets of data from a respective publisher database to create one or more sets of one or more publisher data records, wherein;

the data in each set of one or more publisher data records is arranged in one or more publisher fields according to a respective publisher template of a particular publisher system,

the one or more of the respective publisher fields correspond to one or more fields of the respective publisher database, and

each set of publisher data records are sent to the processing computer;

the processing computer parses all or a portion of each set of publisher data records into one or more corresponding sets of one or more recipient data records according to a master template, the data in each set of recipient data records being arranged in one or more respective recipient data fields according to a respective recipient template of a particular recipient system, and

the master template includes one or more master fields for establishing a mapping between one or more respective publisher data fields of one or more sets of respective publisher data records and one or more respective recipient fields of one or more sets of recipient data records.

31. A computer readable medium having computer instructions provided thereon for enabling a computer system to perform a method for integrating data between computer systems, the method comprising:

extracting data from a first publisher database of a first publisher system to create one or more first publisher data records, wherein data in the one or more first publisher data records is arranged in one or more first publisher fields according to a first publisher template, wherein one or more of the first publisher fields correspond to one or more fields of the first publisher database; and

parsing all or a portion of the data from the one or more first publisher data records into one or more corresponding first recipient data records according to a master template, wherein data is arranged in one or more of the first recipient data records in one or more of the first recipient fields according to a first recipient data template, and wherein the master template includes one or more master fields for establishing a mapping between one or more of the first publisher fields of the first publisher data records and one or more of the first recipient fields of the first recipient data records.

32. A computer application program operable on a computer system for enabling the computer system to perform a method for integrating data between computer systems, the method comprising:

extracting data from a first publisher database of a first publisher system to create one or more first publisher data records, wherein data in the one or more first publisher data records is arranged in one or more first publisher fields according to a first publisher template, wherein one or more of the first publisher fields correspond to one or more fields of the first publisher database; and

parsing all or a portion of the data from the one or more first publisher data records into one or more corresponding first recipient data records according to a master template, wherein data is arranged in one or more of the first recipient data records in one or more first recipient fields according to a first recipient data template, and wherein the master template includes one or more master fields for establishing a mapping between one or more first publisher fields of the first publisher data records and one or more first recipient fields of the first recipient data records.

33. A computer readable medium having computer instructions provided thereon for enabling a computer system to perform a method for integrating data between computer systems, the method comprising:

receiving one or more first publisher data records, the first publisher data records being received from a first publisher system and comprising data extracted from a first publisher database and arranged in the first publisher data records in one or more first publisher fields according to a first publisher template, wherein one or more first publisher fields correspond to one or more fields of the first publisher database; and

parsing all or a portion of the data from one or more first publisher data records into one or more corresponding first recipient data records according to a master template, wherein the data being arranged in one or more of the first recipient data records in one or more first recipient fields according to a first recipient template, and wherein the master template includes one or more master fields for establishing a mapping between one or more first publisher fields of the first publisher data records and one or more first recipient fields of the first recipient data records.

34. A computer application program operable on a computer system for enabling the computer system to perform a method for integrating data between computer systems, the method comprising:

receiving one or more first publisher data records, the first publisher data records being received from a first publisher system and comprising data extracted from a first publisher database and arranged in the first publisher data records in one or more first publisher fields according to a first publisher template, wherein one or more first publisher fields correspond to one or more fields of the first publisher database; and

parsing all or a portion of the data from one or more first publisher data records into one or more corresponding first recipient data records according to a master template, wherein the data being arranged in one or more of the first recipient data records in one or more first recipient fields according to a first recipient template, and wherein the master template includes one or more master fields for establishing a mapping between one or more first publisher fields of the first publisher data records and one or more first recipient fields of the first recipient data records.

35. A computer readable medium having computer instructions provided thereon for enabling a computer system to perform a method for integrating data between computer systems, the method comprising:

receiving a plurality of sets of one or more respective publisher data records each from a respective publisher system,

parsing all or a portion of the data in each set of publisher data records into one or more sets of respective recipient data records for a respective recipient system according to a master template, wherein;

the data contained in each respective set of publisher records is arranged according to a respective publisher template,

the data in each respective set of recipient records is arranged according to a respective recipient template, and

the master template includes one or more master fields for establishing a mapping between one or more respective publisher fields of one or more respective sets of publisher data records and one or more respective recipient fields of one or more respective sets of recipient data records.

36. A computer application program operable on a computer system for enabling the computer system to perform a method for integrating data between computer systems, the method comprising:

receiving a plurality of sets of one or more respective publisher data records each from a respective publisher system,

parsing all or a portion of the data in each set of publisher data records into one or more sets of respective recipient data records for a respective recipient system according to a master template, wherein;

the data contained in each respective set of publisher records is arranged according to a respective publisher template,

the data in each respective set of recipient records is arranged according to a respective recipient template, and

the master template includes one or more master fields for establishing a mapping between one or more respective publisher fields of one or more respective sets of publisher data records and one or more respective recipient fields of one or more respective sets of recipient data records.

37. A computer readable medium having computer instructions provided thereon for enabling a computer system to perform a method for integrating data over a computer network, the computer network allowing communication between a processing computer, a plurality of publisher systems and a plurality of recipient systems in communication with the processing computer, the method comprising:

extracting one or more sets of data from a respective database of a respective publisher system to create one or more sets of one or more respective publisher data records, wherein;

the data in each set of one or more publisher data records is arranged in one or more publisher fields according to a respective publisher template of a particular publisher system, and

the one or more of the respective publisher fields correspond to one or more fields of the respective publisher database,

forwarding each set of publisher data records to the processing computer;

using the processing computer, parsing all or a portion of the data contained in each set of publisher data records into one or more corresponding sets of one or more recipient data records according to a master template, wherein;

each set of recipient data records is for a particular recipient system,

the data in each set of recipient data records being arranged in one or more respective recipient data fields according to a respective recipient template of a particular recipient system,

the master template includes one or more master fields for establishing a mapping between one or more respective publisher fields of one or more sets of publisher data records and one or more respective recipient fields of one or more sets of recipient data records, and

forwarding each respective set of recipient data records to a respective recipient system.

38. A computer application program operable on a computer system for enabling the computer system to perform a method for integrating data over a computer network, the computer network allowing communication between a processing computer, a plurality of publisher systems and a plurality of recipient systems in communication with the processing computer, the method comprising:

extracting one or more sets of data from a respective database of a respective publisher system to create one or more sets of one or more respective publisher data records, wherein;

the data in each set of one or more publisher data records is arranged in one or more publisher fields according to a respective publisher template of a particular publisher system, and

the one or more of the respective publisher fields correspond to one or more fields of the respective publisher database,

forwarding each set of publisher data records to the processing computer;

using the processing computer, parsing all or a portion of the data contained in each set of publisher data records into one or more corresponding sets of one or more recipient data records according to a master template, wherein;

each set of recipient data records is for a particular recipient system,

the data in each set of recipient data records being arranged in one or more respective recipient data fields according to a respective recipient template of a particular recipient system,

the master template includes one or more master fields for establishing a mapping between one or more respective publisher fields of one or more sets of publisher data records and one or more respective recipient fields of one or more sets of recipient data records, and

forwarding each respective set of recipient data records to a respective recipient system.