Supporting extensions to production event message schemes via production database server versioning
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 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;
an extensible production event message schema, stored on the non-transitory computer-readable medium, that accommodates production event message schema extensions to pre-defined production event message, definitions;
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 tabling the set of data corresponding to the production event in the production database, and wherein the production event messages are generated and processed in accordance with the extensible production event message schema; and
wherein the production event message schema extensions include production server version definitions specifying one of potentially many production server versions maintained by the production database services.
2. The computer system including the production events information recording system of claim 1 wherein the production event message schema extensions include message validation definitions.
3. The computer system including the production events information recording system of claim 1 wherein the production event message schema extensions include message origin definitions.
4. The computer system including the production events information recording system of claim 1 wherein the production event message schema extensions include production services event message handling definitions.
5. The computer system including the production events information recording system of claim 1 wherein the production event message schema extensions include manufacturing electronic records extensions.
6. The computer system including the production events information recording system of claim 1 wherein the production event message schema extensions include response message definitions.
7. A method for processing a production event arising from a manufacturing environment wherein a production database stores production event information in a set of tables, the method comprising the steps of:
receiving a triggering production event notification;
generating, in response to the receiving step, a production event message including a set of data corresponding to a production event, and wherein the set of data includes server version specification information;
receiving, by production services associated with the production database, the production event message;
parsing, by the production database services, the server version specification information, and invoking a production server version for processing the production event message, wherein
processing the production event message, by the invoked production server version, prior to tabling the set of data corresponding to the production event in the production database,
wherein the production event message is generated and processed in accordance with an extensible production event message schema that accommodates production event message schema extensions, and
wherein the production event message schema extensions include production server version definitions specifying one of potentially many production server versions maintained by the production database services.
8. The method of claim 7 wherein the server version specification information is specified within an extension to a production event messaging schema.
9. The method of claim 7 wherein the generating step is carried out by a production event object.
10. The method of claim 7 further comprising the step of validating the production event message according to a validation definition provided by an extension to a production event messaging schema.
11. The method of claim 8 further comprising the step of specifying, by the production event message, a message origin for the production event message according to an extension to a production event messaging schema.
12. The method of claim 7 further comprising the step of specifying, by the production event message, production services event message handling definitions according to a production event messaging schema.
13. The method of claim 7 further comprising the step of specifying, by the production event message, manufacturing electronic records according to an extension to a production event messaging schema.
14. The method of claim 7 further comprising the step of specifying, by the production event message, a message response within the production event message according to an extension to a production event messaging schema.
15. A physical computer-readable storage medium including computer executable instructions for facilitating processing a production event arising from a manufacturing environment wherein a production database stores production event information in a set of tables, the computer-executable instructions facilitating performing the steps of:
receiving a triggering production event notification;
generating, in response to the receiving step, a production event message including a set of data corresponding to a production event, and wherein the set of data includes server version specification information;
receiving, by production database services associated with the production database, the production event message;
parsing, by the production services, the server version specification information, and invoking a production server version for processing the production event message, and
processing the production event message, by the invoked production server version, prior to tabling the set of data corresponding to the production event in the production database,
wherein the production event message is generated and processed in accordance with an extensible product event message schema that accommodates production event message schema extensions, and
wherein the production event message schema extensions include production server version definitions specifying one of potentially many production server versions maintained by the production database services.
16. The physical computer-readable storage medium of claim 15 wherein the server version specification information is specified within an extension to a production event messaging schema.
17. The physical computer-readable storage medium of claim 15 wherein the generating step is carried out by a production event object.
18. The physical computer-readable storage medium of claim 15 further comprising computer-executable instructions for validating the production event message according to a validation definition provided by an extension to a production event messaging schema.
19. The physical computer-readable storage medium of claim 15 further comprising computer-executable instructions for specifying, by the production event message, a message origin for the production event message according to an extension to a production event messaging schema.