Process and a system for updating a data structure in a relational database used within a manufacturing execution system

摘要

A process for updating a data structure in a relational database used within a manufacturing execution system, contain the steps of defining within the database the data structure and defining SQL scripts having specific rules. The rules contain a header describing an initial data structure and a final data structure, thereby defining each of the defined SQL scripts as a section of the updating process. The current data structure of the database is analyzed and the required sections among the sections available are identified by comparing the current data structure of the database to the initial data structure defined in the header of the SQL script. A sequence order to apply the sections is defined and the required SQL scripts are run according to the defined sequence order. This allows developers to define the SQL script for their own demands without coordinating the requested changes with other development groups.

主权项

1. A process for updating a data structure in a relational database used within a manufacturing execution system, which comprises the steps of:
a) defining within the relational database the data structure; b) defining SQL scripts having a number of specific rules, the rules containing a header describing an initial data structure and a final data structure, thereby defining each of the defined SQL scripts as a section of an updating process; c) analyzing a current data structure of the relational database; d) identifying required sections among the sections available by comparing the current data structure of the relational database to the initial data structure defined in the header of a SQL script; e) defining a sequence order to consistently apply the sections; and f) running required SQL scripts according to a defined sequence order of the sections.