Event-driven servers for data extraction and merge for EDI transaction processing using the internet

• US 6,724,896 B1
• Filed: 03/31/1997
• Issued: 04/20/2004
• Est. Priority Date: 03/31/1997
• Status: Expired due to Term

• Current Assignee: Oracle America, Inc. (Oracle Corporation)
• Original Assignee: Sun Microsystems Incorporated (Oracle Corporation)
• Inventors: Jansson, Mats, Alur, Deepak, Beckett, Cynthia F., Hyde, Virginia C.
• Primary Examiner(s): Sheikh, Ayaz
• Assistant Examiner(s): Baum, Ronald
• Application Number:
  US08/828,486
• Time in Patent Office: 2,577 Days
• Field of Search: 380/49, 709/300, 709/101, 709/246, 705/50, 705/64, 705/75
• US Class Current: 380/255
• CPC Class Codes: G06Q 20/382 insuring higher security of transaction
• CPC Class Codes: H04L 63/0428 wherein the data content is protected, e.g. by encrypting or encapsulating the payload
• CPC Class Codes: H04L 63/12 Applying verification of the received information cryptographic mechanisms or cryptographic arrangements for data integrity or data verification H04L9/32
• CPC Class Codes: H04L 67/1097 for distributed storage of data in networks, e.g. transport arrangements for network file system [NFS], storage area networks [SAN] or network attached storage [NAS]
• CPC Class Codes: H04L 69/329 in the application layer [OSI layer 7]
• CPC Class Codes: H04L 9/40 Network security protocols

Abstract

A method and apparatus for performing event-driven data transfer operations over a global computer network. Electronic Data Interchange (EDI) format data is extracted from a database stored on a first computer system connected to a global computer network. The transaction data extracted from the database is then monitored to determine whether the data is ready to be transmitted to a second computer system connected to the global computer network. When ready, the transaction data is transmitted to the second computer system. The second computer system, in turn, receives the transaction data, monitors the data to determine whether the data is ready to be merged into a database stored on the second computer system, and merges the data into the database. Embodiments of the invention allow for secure data transfer operations to be performed on-line and in real-time. In addition, since a global computer network is utilized, there is no need to maintain a dedicated communication line between the first and the second computer system. Rather, a single network connection can be used by the first and the second computer system to communicate with any number of computer systems connected to the global computer network.

Claims

1. A method of performing event-driven data transfer operations over a global computer network, the method comprising:

extracting data related to service orders from a database stored on a first computer system connected to the global computer network;

monitoring the data extracted from the database to determine whether the data extracted from the database is ready to be transmitted to a second computer system connected to the global computer network;

translating the data extracted from the database from a first format into a second format to generate a formatted data file;

encrypting the formatted data file to generate encrypted data; and

transmitting the encrypted data to the second computer system connected over the global computer network;

wherein said extracting, monitoring, translating, encrypting and transmitting are performed in real-time and wherein if a receipt of the transmitted data to the second computer system remains unacknowledged and a predetermined period of time has elapsed since the transmitting has occurred, the formatted data is transmitted via facsimile.

2. The method of claim 1, further comprising:

receiving on the second system encrypted data transmitted from the first computer system connected to the global computer network;

decrypting the encrypted data to generate decrypted data;

translating the decrypted data from the second format into the first format;

monitoring the data received from the first computer system to determine whether the data received from the first computer system is ready to be merged into a database stored on the second computer system; and

merging the data into a database stored on the second computer system connected to the global computer network.

37. The method of claim 1 wherein the formatted data is transmitted via paging.

3. A computer system for performing event-driven data transfer operations, the system comprising a first and a second programmed computers connected to a global computer network, the first computer comprising a computer-readable medium storing instructions for:

extracting data related to service orders from a database stored on a first computer system connected, to the global computer network;

monitoring the data extracted from the database to determine whether the data extracted from the database is ready to be transmitted to a second computer system connected to the global computer network;

translating the data from the database from a first format into a second format to generate a formatted data file;

encrypting the formatted data file to generate encrypted data; and

transmitting the encrypted data to the second computer system connected over the global computer network;

wherein said extracting, monitoring, translating, encrypting and transmitting are performed in real-time and wherein if a receipt of the transmitted data to the second computer system remains unacknowledged and a predetermined period of time has elapsed since the transmitting has occurred, the formatted data is transmitted via facsimile.

4. The system of claim 3, wherein the second programmed computer comprises instructions for:

receiving encrypted data transmitted from the first computer system connected to the global computer network;

decrypting the encrypted data to generate decrypted data;

translating the decrypted data from the second format into the first format;

monitoring the data received from the first computer system to determine whether the data received from the first computer system is ready to be merged into a database stored on the second computer system; and

merging the data into a database stored on the second computer system connected to the global computer network.

38. The system of claim 3 wherein the formatted data is transmitted via paging.

5. A computer-readable medium storing a computer program, the program comprising instructions for:

extracting data related to service orders from a database stored on a first computer system connected to the global computer network;

monitoring the data extracted from the database to determine whether the data extracted from the database is ready to be transmitted to a second computer system connected to the global computer network;

translating the data extracted from the database from a first format into a second format to generate a formatted data file;

encrypting the formatted data file to generate encrypted data; and

transmitting the encrypted data to the second computer system connected over the global computer network;

wherein said extracting, monitoring, translating, encrypting and transmitting are performed in real-time and wherein if a receipt of the transmitted data to the second computer system remains unacknowledged and a predetermined period of time has elapsed since the transmitting has occurred, the formatted data is transmitted via facsimile.

6. The computer-readable medium of claim 5, further comprising instructions for:

receiving on the second computer encrypted data transmitted from the first computer system connected to the global computer network;

decrypting the encrypted data to generate decrypted data;

translating the decrypted data from the second format into the first format;

monitoring the data received from the first computer system to determine whether the data received from the first computer system is ready to be merged into a database stored on the second computer system; and

merging the data into a database stored on the second computer system connected to the global computer network.

39. The computer-readable medium of claim 5 wherein the formatted data is transmitted via paging.

41. The article of claim 5 wherein the formatted data is transmitted via paging.

7. A method of transferring data over a computer network, the method comprising:

extracting data from a database stored on a first computer system coupled to the computer network;

formatting the extracted data into a first format recognized by a business partner, a specification of the first format being stored on the first computer system in a data structure specific to the business partner;

translating the formatted data into a second format, the second format facilitating exchange of a plurality of business transactions over the computer network; and

transmitting the translated data to a second computer system coupled to the computer network,

wherein if a receipt of the transmitted data to the second computer system remains unacknowledged and a predetermined period of time has elapsed since the transmitting has occurred, the formatted data is transmitted to the business partner via facsimile.

8. The method of claim 7 further including:

receiving on the second computer system the transmitted data from the first computer system coupled to the computer network;

translating the received data in the second format into the first format recognized by the business partner; and

merging the translated data into a database stored on the second computer system coupled to the computer network.

9. The method of claim 8 further including decrypting the received data from the first computer system prior to the translating of the received data into the first format recognized by the business partner.

10. The method of claim 8 further including storing the received data in an input queue on the second computer system.

11. The method of claim 7 further including encrypting the translated data prior to the transmitting of the translated data to the second computer system.

12. The method of claim 11 wherein the encrypting utilizes Data Encryption Standard (DES).

13. The method of claim 12 wherein a key is encrypted using Rivest Shamir Adelman (RSA).

14. The method of claim 7 further including verifying that the formatted data stored on the first computer system in the data structure specific to the business partner is in the first format recognized by the business partner.

15. The method of claim 7 further including acknowledging receipt of the transmitted data by the second computer system.

16. The method of claim 7 wherein the formatted data is transmitted via paging.

17. The method of claim 16 further including sending a page to indicate that the formatted data has been sent via facsimile.

18. The method of claim 7 wherein the second format facilitating exchange of the plurality of business transactions utilizes an Electronic Data Interchange (EDI) format.

19. The method of claim 18 wherein the Electronic Data Interchange (EDI) format is selected from a group comprising X12.141, X12.142, and X12.143.

20. The method of claim 7 wherein the second format complies with an American National Standards Institute (ANSI) standard.

21. The method of claim 7 wherein the first format specification recognized by the business partner is stored in a file.

22. The method of claim 21 wherein the file and the formatted data recognized by the business partner are stored in a plurality of data structures that share a same parent.

23. The method of claim 7 further including storing the translated data on the first computer system.

24. The method of claim 7 wherein the computer network is a global computer network.

25. The method of claim 24 wherein the global computer network is Internet.

26. The method of claim 7 wherein the data structure is a directory in a file system.

27. The method of claim 26 wherein the file system is a UNIX file system.

28. The method of claim 7 wherein the transmitted data includes only data that has changed since a last transmission to the second computer system.

29. A system for transferring data over a computer network, the system comprising a first and a second computer systems coupled to the computer network, the first computer system comprising a computer-readable medium storing instructions to:

extract data from a database stored on the first computer system coupled to the computer network;

format the extracted data into a first format recognized by a business partner, a specification of the first format being stored on the first computer system in a data structure specific to the business partner;

translate the formatted data into a second format, the second format facilitating exchange of a plurality of business transactions over the computer network; and

transmit the translated data to the second computer system coupled to the computer network,

wherein if a receipt of the transmitted data to the second computer system remains unacknowledged and a predetermined period of time has elapsed since the transmitting has occurred, the formatted data is transmitted to the business partner via facsimile.

30. The system of claim 29 wherein the second computer system comprises instructions to:

receive on the second computer system the transmitted data from the first computer system coupled to the computer network;

translate the received data from the second format into the first format recognized by the business partner; and

merge the translated data into a database stored on the second computer system coupled to the computer network.

31. The system of claim 30 wherein the second computer system comprises instructions to store the received data in an input queue on the second computer system.

32. The system of claim 29 wherein the transmitted data includes only data that has changed since a last transmission to the second computer system.

40. The system of claim 29 wherein the formatted data is transmitted via paging.

33. An article of manufacture comprising:

a machine readable medium that provides instructions that, if executed by a machine, will cause the machine to perform operations including;

extracting data from a database stored on a first computer system coupled to the computer network;

formatting the extracted data into a first format recognized by a business partner, a specification of the first format being stored on the first computer system in a data structure specific to the business partner;

translating the formatted data into a second format, the second format facilitating exchange of a plurality of business transactions over the computer network; and

transmitting the translated data to a second computer system coupled to the computer network,

wherein if a receipt of the transmitted data to the second computer system remains unacknowledged and a predetermined period of time has elapsed since the transmitting has occurred, the formatted data is transmitted to the business partner via facsimile.

34. The article of claim 33, wherein the second computer system comprises a machine readable medium that provides instructions that, if executed by a machine, will cause the machine to perform operations including:

receiving on the second computer system the transmitted data from the first computer system coupled to the computer network;

translating the received data from the second format into the first format recognized by the business partner; and

merging the translated data into a database stored on the second computer system coupled to the computer network.

35. A system for transferring data over a computer network, the system comprising a first and a second computer systems coupled to the computer network, the first computer system comprising:

means for extracting data from a database stored on the first computer system coupled to the computer network;

means for formatting the extracted data into a first format recognized by a business partner;

means for translating the formatted data into a second format, the second format facilitating exchange of a plurality of business transactions over the computer network; and

means for transmitting the translated data to the second computer system coupled to the computer network,

wherein if a receipt of the transmitted data to the second computer system remains unacknowledged and a predetermined period of time has elapsed since the transmitting has occurred, the formatted data is transmitted to the business partner via facsimile.

36. The system of claim 35 wherein the second computer system comprises:

means for receiving on the second computer system the transmitted data from the first computer system coupled to the computer network;

means for translating the received data from the second format into the first format recognized by the business partner; and

means for merging the translated data into a database stored on the second computer system coupled to the computer network.

42. The system of claim 35 wherein the formatted data is transmitted via paging.