System and method for implementing an interface between an external process and transaction processing system

• US 5,530,848 A
• Filed: 10/15/1992
• Issued: 06/25/1996
• Est. Priority Date: 10/15/1992
• Status: Expired due to Fees

• Current Assignee: The Dow Chemical Company (Dow, Inc.)
• Original Assignee: The Dow Chemical Company (Dow, Inc.)
• Inventors: Burton, Reiner, Gilbert, Peter W., Walters, Brian J., Diment, Matthew M.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): HOMERE, JEAN RAYMOND
• Application Number:
  US07/961,271
• Time in Patent Office: 1,349 Days
• Field of Search: 395/600, 395/575, 395/200, 395/200.20, 395/835, 395/838, 395/839, 364/DIG. 1
• US Class Current: 719/313
• CPC Class Codes: G06F 9/466 Transaction processing
• CPC Class Codes: G06F 9/54 Interprogram communication

Abstract

A system and method for interfacing external processes to a transaction processing system. An interface system is provided that accepts input messages from external processes wherein in the input messages are to be processed by a transaction processing system. The interface system logs received messages and notifies the transaction processing system that a message has been received for processing. The interface system sends a confirmation to the external process indicating that the message has been received. The interface system periodically examines the status of each message as it is being processed by the transaction processing system. Output status messages indicative of such status are created, stored, and sent to an external destination for informational purposes. Outbound data messages are created, stored and sent to an external application. The interface system is event driven, but includes a monitor subsystem to time the start-up of certain processes at periodic intervals.

Claims

1. A method for implementing an interface system between an external process that sends an input message and a transaction processing system that receives and processes the input message, the method comprising the steps of:

(a) receiving at the interface system the input message from the external process;

(b) creating a control record which is indicative of the input message received by the interface system;

(c) writing said control record to an interface system log file in the interface system to log receipt of the input message by the interface system;

(d) confirming receipt of the input message to the external process to indicate that the input message has been received and logged by the interface system;

(e) scanning said interface system log file to detect said control record and triggering the transaction processing system in response to said detection of said control record; and

(f) providing, via said control record, data from the input message to the transaction processing system so that the transaction processing system can receive and act on the input message.

2. The method of claim 1, further comprising the steps of:

(g) receiving at the interface system a processing status message from the transaction processing system to indicate a processing status of the input message in the transaction processing system;

(h) updating said interface system log file based on said processing status message received by the interface system;

(i) reading said control record in said interface system log file to determine a processing status of the input message and to determine if an output message is to be sent by the interface system;

(j) storing an outbound control record in a communications log file in the interface system based on said step (i); and

(k) transmitting said output message from the interface system to a destination designated by said outbound control record, wherein said output message includes one of an output data message and an output status message.

3. The method of claim 1, wherein said step (a) comprises the steps of:

initializing an input receive subsystem in the interface system;

receiving the input message in said input receive subsystem;

validating and initializing an interface system status code indicative of processing performed on the input message; and

updating said interface system status code to indicate that said input receive subsystem has completed its processing of the input message.

4. The method of claim 1, wherein said step (e) comprises the steps of:

browsing said interface system log file for active control records;

generating a trigger message indicating the input message has been received by the interface system and logged to said interface system log file and indicating the location of said control record created upon logging receipt of the input message; and

sending said trigger message from the interface system to the transaction processing system.

5. The method of claim 4, further comprising the steps of:

initializing an Online Data Communications (ODC) queue counter to zero;

determining whether said ODC queue counter exceeds a predetermined threshold before generating said trigger message;

incrementing said ODC queue counter upon sending said trigger message; and

continuing to browse said interface system log file until no more said active control records are found.

6. The method of claim 5, further comprising the steps of:

checking said interface system status code to determine whether a trigger message should be sent; and

incrementing said ODC queue counter for each said active control record awaiting processing by the transaction processing system according to said interface system status code.

7. The method of claim 2, wherein said step (h) further comprises the steps of:

determining whether said processing status message contains one of an update to an existing control record, a new control record, and an update to a master control record;

writing said new control record as a control record in said interface system log file if said processing status message is said new control record;

retrieving and updating an existing control record from said interface system log file if said processing status message is said update to an existing control record; and

retrieving and updating said master control record in said interface system log file if said processing status message is said update to a master control record.

8. A method for implementing an interface system between an external process that sends an input message and a transaction processing system that receives and processes the input message, the method comprising the steps of:

(a) receiving at the interface system the input message from the external process;

(b) creating a control record which is indicative of the input message received by the interface system;

(c) writing said control record to an interface system log file in the interface system to log receipt of the input message by the interface system;

(d) confirming receipt of the input message to the external process to indicate that the input message has been received and logged by the interface system;

(e) scanning said interface system log file to detect said control record and triggering the transaction processing system in response to said detection of said control record;

(f) providing, via said control record, data from the input message to the transaction processing system so that the transaction processing system can receive and act on the input message;

(g) receiving at the interface system a processing status message from the transaction processing system to indicate a processing status of the input message in the transaction processing system;

(h) updating said interface system log file based on said processing status message received by the interface system;

(i) reading said control record in said interface system log file to determine a processing status of the input message and to determine if an output message is to be sent by the interface system;

(j) storing an outbound control record in a communications log file in the interface system based on said step (i);

(k) transmitting said output message from the interface system to a destination designated by said outbound control record, wherein said output message includes one of an output data message and an output status message;

(l) browsing a transaction processing system log file in the interface system in an area defined by a previous end-of-file marker and a current end-of-file marker to find a transaction record corresponding to said control record; and

(m) adding a match record which contains an address of said found transaction record to a match file in the interface system.

9. The method of claim 8, wherein said step (i) comprises the steps of:

browsing said interface system log file to find said control record;

browsing said match file to locate said match record corresponding to said found control record;

changing an interface system status code and a file type of said found control record to create a finished control record;

replacing said found control record with said finished control record.

10. The method of claim 9, further comprising the steps of:

reading a transaction processing system status if said match record is found;

reading said transaction processing system log file if said transaction processing system status is pending;

determining if said control record has timed out; and

changing said interface system status code and said file type of said control record to create a finished control record if said control record has timed out.

11. The method of claim 9, wherein said step (j) comprises the step of writing said finished control record as an outbound control record to said communications log file.

16. The method of claim 11, further comprising the step of deleting said outbound control record from said communications log file once said output message has been sent error free.

17. The method of claim 11, further comprising the steps of:

browsing said communications log file and sending first, middle, and last records of a chain mail sequence if said outbound control record is a last control record of a finite chain;

sending said outbound control record from said communications log file to a communications subsystem in the interface system;

sending said data records from said interface system log file to said communications subsystem;

deleting said outbound control record from said communications log file; and

updating said interface system status code of said control record to reflect that processing of said communications subsystem is complete.

12. A method for implementing an interface system between an external process that sends an input message and a transaction processing system that receives and processes the input message, the method comprising the steps of:

(a) receiving at the interface system the input message from the external process;

(b) creating a control record which is indicative of the input message received by the interface system;

(c) writing said control record to an interface system log file in the interface system to log receipt of the input message by the interface system;

(d) confirming receipt of the input message to the external process to indicate that the input message has been received and logged by the interface system;

(e) scanning said interface system log file to detect said control record and triggering the transaction processing system in response to said detection of said control record;

(f) providing, via said control record, data from the input message to the transaction processing system so that the transaction processing system can receive and process the input message;

(g) receiving at the interface system a processing status message from the transaction processing system to indicate a processing status of the input message in the transaction processing system;

(h) updating said interface system log file based on said processing status message received by the interface system;

(i) reading said control record in said interface system log file to determine a processing status of the input message and to determine if an output message is to be sent by the interface system;

(j) storing an outbound control record in a communications log file in the interface system based on said step (i); and

(k) transmitting said output message from the interface system to a destination designated by said outbound control record, wherein said output message includes one of an output data message and an output status message;

wherein said step (k) comprises the steps of;

receiving at the interface system one of said output data record and said output control record from the transaction processing system;

adding said received output control record to said interface system log file;

changing an interface system status code and a file type of said output control record to create a finished output control record;

writing said finished output control record as an outbound control record to an outbound communications log file in the interface system;

browsing said outbound communications log file to find said outbound control record;

establishing a communications link between the interface system and a destination node addressed by said outbound control record;

sending said outbound control record from the interface system to said destination node; and

sending said output data record from the interface system to said destination node.

13. A method for implementing an interface system between an external process that sends an input message and a transaction processing system that receives and processes the input message, the method comprising the steps of:

(a) receiving at the interface system the input message from the external process;

(b) creating a control record which is indicative of the input message received by the interface system;

(c) writing said control record to an interface system log file in the interface system to log receipt of the input message by the interface system;

(d) confirming receipt of the input message to the external process to indicate that the input message has been received and logged by the interface system;

(e) scanning said interface system log file to detect said control record and triggering the transaction processing system in response to said detection of said control record;

(f) providing, via said control record, data from the input message to the transaction processing system so that the transaction processing system can receive and process the input message;

(g) receiving at the interface system a processing status message from the transaction processing system to indicate a processing status of the input message in the transaction processing system;

(h) updating said interface system log file based on said processing status message received by the interface system;

(i) reading said control record in said interface system log file to determine a processing status of the input message and to determine if an output message is to be sent by the interface system;

(j) storing an outbound control record in a communications log file in the interface system based on said step (i); and

(k) transmitting said output message from the interface system to a destination designated by said outbound control record, wherein said output message includes one of an output data message and an output status message;

wherein said step (k) comprises the steps of;

creating and storing said outbound control record in said communications log file;

determining whether a destination address field of said outbound control record contains a direct address;

establishing a link between the interface system and an external process designated by said address;

creating an output message based on said outbound control record; and

sending from the interface system said output message to said external process.

14. The method of claim 13, wherein said sending step comprises the steps of attempting to connect to a first external node based on a first destination address, and, if unsuccessful, then attempting to connect to a second external node based on a second destination address.

15. The method of claim 14, further comprising the steps of:

detecting whether a transmission error has occurred;

re-sending said output message from said interface system if said transmission error has occurred;

counting a number of attempts to send said output message;

deleting said output message from said communications log file if said number of attempts exceeds a threshold limit; and

changing a file type of said outbound control record if said number of attempts exceeds a threshold limit to create a finished outbound control record.

18. A method for implementing an interface system between an external process that sends an input message and a transaction processing system that receives and processes the input message, the method comprising the steps of:

(a) receiving at the interface system the input message from the external process;

(b) creating a control record which is indicative of the input message received by the interface system;

(c) writing said control record to an interface system log file in the interface system to log receipt of the input message by the interface system;

(d) confirming receipt of the input message to the external process to indicate that the input message has been received and logged by the interface system;

(e) scanning said interface system log file to detect said control record and triggering the transaction processing system in response to said detection of said control record;

(f) providing, via said control record, data from the input message to the transaction processing system so that the transaction processing system can receive and process the input message;

(g) receiving at the interface system a processing status message from the transaction processing system to indicate a processing status of the input message in the transaction processing system;

(h) updating said interface system log file based on said processing status message received by the interface system;

(i) reading said control record in said interface system log file to determine a processing status of the input message and to determine if an output message is to be sent by the interface system;

(j) storing an outbound control record in a communications log file in the interface system based on said step (i); and

(k) transmitting said output message from the interface system to a destination designated by said outbound control record, wherein said output message includes one of an output data message and an output status message;

(l) browsing said communications log file to search for said outbound control record;

(m) checking a master control record to determine whether a number of communications tasks has exceeded a threshold, if said outbound control record is found;

(n) checking whether a communications node pointed to by said outbound control record is available; and

(o) starting a communications process in the interface system for said communications node.

19. A system for interfacing an external process that sends an input message and a transaction processing system that receives and processes the input message, the system comprising:

(a) a log file for storing a control record and for providing, via said control record, data from the input message to the transaction processing system;

(b) first means, coupled to said log file, for receiving the input message from the external process and for logging receipt thereof to said log file;

(c) second means, coupled to said log file, for providing a trigger message to the transaction processing system to indicate that the input message has been received and logged by said first means;

(d) third means, coupled to said log file, for determining a processing status of the input message in the transaction processing system and for generating an outbound control record as a function of said status; and

(e) fourth means, coupled to said third means, for creating an output message as a result of said outbound control record and for transmitting said output message to a destination.

20. The system of claim 19, further comprising a second log file, coupled to said third means and to said fourth means, for storing said outbound control record.

21. The system of claim 19, further comprising a file, coupled to said third means, for storing an index to a transaction processing system log file.

22. The system of claim 19, further comprising fifth means for retrieving a processing status message and for updating said first log file as a result of said processing status message.

23. The system of claim 20, further comprising fifth means for browsing said second log file to look for said outbound control record and for starting a communications task as a result of said outbound control record.

24. The system of claim 19, further comprising fifth means, coupled to said second and said third means, for initiating said second and said third means at timed periodic intervals.

25. The system of claim 19, further comprising an elapsed-time timer table to store time information on generation of timing strobes to initiate said second and third means.

26. A system for interfacing an external process to a transaction processing system:

(a) a first log file;

(b) a second log file;

(c) an input receive subsystem, coupled to said first log file, operable to receive an input message from the external process, to log a control record of such receipt onto said first log file, and to send a confirmation to the external process confirming receipt of said input message;

(d) a trigger subsystem, coupled to said first log file, operable to browse said first log file to search for said control record, and to provide a trigger message to the transaction processing system indicating an input message has been received and is ready for processing by the transaction processing system;

(e) a status subsystem, coupled to said first log file, operable to retrieve a processing status message from the transaction processing system and to update control record information on said first log file;

(f) an acknowledgement subsystem, coupled to said first log file and to said second log file, operable to determine a processing status of the input message by reading control records updated by said status subsystem, and to provide an outbound control record to said second log file for control records indicating that an acknowledgment is requested; and

(g) a communications subsystem, coupled to said second log file, operable to retrieve said outbound control record and from said second log file, operable to create an output message from said outbound control record, and to send said output message to an external destination.

27. The system of claim 26, further comprising a match file, coupled to said acknowledgement subsystem, for providing an index to transaction records in the transaction processing system.

28. The system according to claim 26, further comprising a communications monitor subsystem, coupled to said second log file, operable to browse said second log file to search for said outbound control record, to determine if a communications task exists for each of said outbound control record, and to start a communications task where one does not already exist.

29. The system according to claim 28, further comprising a monitor subsystem, operable to provide an artificial initiating event to said acknowledgement subsystem, said trigger subsystem, and said communications monitor subsystem.

30. A method for implementing an interface system between an external process that sends an input message and a transaction processing system that receives and processes an input message, the method comprising the steps of:

(a) receiving at the interface system the input message from the external process;

(b) creating a control record which contains a header used to control processing of the input message and one of data from the input message and a pointer to said data;

(c) writing said control record to an interface system log file in the interface system to log receipt of the input message by the interface system;

(d) confirming receipt of the input message to the external process to indicate that the input message has been received and logged by the interface system;

(e) scanning said interface system log file to detect said control record and triggering the transaction processing system in response to said detection of said control record; and

(f) providing, via said control record, said data to the transaction processing system so that the transaction processing system can process the input message without requiring further action by the external process.