Supporting both asynchronous and synchronous data transfers between production event information sources and a production information database
View Patent ↗A production information reporting/recording system is disclosed herein including a number of features to ensure efficient, flexible and reliable recording of production data in a manufacturing system. Such features include validating the content of event messages to ensure compliance of event report information with a standard. The system also supports caching IDs associated with particular aspects of an event message (e.g., a production request, a process segment) as well as a unique ID corresponding to the ID assigned by the production event database to reduce the need to access the database when assigning unique database IDs to received events. The production event messaging system also supports both asynchronous and synchronous transactional messaging between the sources of events and the production database service. Furthermore, the system supports including extensions to a base production message schema through the inclusion of metadata that designates a particular production server to parse and apply/store the extension information.
1. A computer system including computer-executable instructions stored on a non-transitory computer-readable medium for providing a production events information recording system for use in a manufacturing environment, the computer system comprising:
a production database comprising a set of tables for storing production event information;
a production event object for generating, in response to a triggering production event, a production event message including a set of data corresponding to a production event;
production database services for processing the production event message generated by the production event object, the production database services including a production server for processing information content within the production event message prior to storing the set of data corresponding to the production event in the production database; and
a multiple mode production events messaging interface between the production event object and the production database services, wherein the multiple mode production events messaging interface supports both asynchronous and synchronous messaging transactions between the production event object and the production database services.
2. The computer system including the production events information recording system of claim 1 wherein a first mode supporting synchronous messaging transactions utilizes Internet services to transfer production event messages.
3. The computer system including the production events information recording system of claim 2 wherein the production database services, in response to designation of the first mode, generate a response message that is returned to the production event object.
4. The computer system including the production events information recording system of claim 1 wherein the production database services, in response to designation of a second mode supporting asynchronous messaging transaction, generates a result that is stored within a table of the production database.
5. The computer system including the production events information recording system of claim 1 wherein a second mode supporting asynchronous messaging transactions utilizes a message queue to transfer production event messages.
6. The computer system including the production events information recording system of claim 5 wherein the second mode is carried out on a client machine by a message service including a queue for storing messages in the event that a connection between the client machine and a server machine including the production database services is disrupted.
7. The computer system including the production events information recording system of claim 6 wherein a server machine includes:
a queue, associated with the second mode, for receiving production event messages from the client machine; and
wherein the production database services include a dispatcher for observing the queue for production event messages.
8. The computer system including the production events information recording system of claim 1 wherein the production database services include a message handler for receiving both asynchronous and synchronous mode production message transmissions.
9. The computer system including the production events information recording system of claim 8 wherein the message handler parses at least a portion of the received message to determine a version of production server to invoke to process the received message.
10. The computer system including the production events information recording system of claim 1 further comprising a production event object configuration interface including an interface enabling a user to designate one of multiple supported messaging modes of the multiple mode production events messaging interface.
11. The computer system including the production events information recording system of claim 1 wherein the production server, in handling a message provided in a synchronous messaging mode, reports any event information errors detected during processing back to the production event object.
12. The computer system including the production events information recording system of claim 1 wherein the production event object, upon receiving a reported event information error for a previously sent production event message, reconstructs the previously sent production event message using current production event information.