Abstract: A database has a main table and an auxiliary table. Data are stored by: dividing the data into a sequence of segments each having a size smaller than a predetermined threshold; storing a first segment into a first field of a record of the main table; storing an index indexing the data into a second field of the record of the main table; storing the other segments into first fields of corresponding records of the auxiliary table; generating indexes associated to the other segments and storing each index into a second field of the record of the auxiliary table storing the associated segment of the sequence and also in a third field of the record of the auxiliary table storing a preceding segment in the sequence. A third record of the main table stores the index of a first segment of the sequence which is stored in the auxiliary table.

Abstract: A method models a defect management routine. Both the modeling and a handling are executed within a manufacturing execution system. During an engineering phase: modeling the production process and creating a library of possible defect types which may occur; assigning the defect types to at least one defect group; creating a library of defect specifications; creating a library of defect type specification details; creating at least one runtime defect criteria that is used to link the defect type to a certain production volume; and creating a runtime defect measurement routine that monitors a corrective measure. During a runtime production phase evaluating the product produced; identifying the respective defect type out of the library of defect types; and using the identified defect type to determine a corrective measure, a runtime defect criteria identifying the resource causing the defect type, a production volume, and to run the respective runtime defect management routine.

Abstract: A method controls a manufacturing execution system (MES) in which one or more parameters of a predetermined manufacturing process executed in a production chain may deviate from a predetermined range. The method includes storing in a controller module of the MES predetermined ranges associated with parameters to be controlled and detecting parameter values in the manufacturing process and a deviation thereof outside a predetermined range. The controller is programmed to prosecute the manufacturing process in the chain if no deviation is detected or to prosecute the manufacturing process in a secondary chain, if the deviation is detected. The controller is programmed to instantiate a deviation object for each parameter to be controlled, the deviation object containing a state machine implementing the prosecution in the secondary chain. A transition state in the state machine being triggered from signatures of persons involved in controlling the deviations.

Abstract: A database has a main table and an auxiliary table. Data are stored by: dividing the data into a sequence of segments each having a size smaller than a predetermined threshold; storing a first segment into a first field of a record of the main table; storing an index indexing the data into a second field of the record of the main table; storing the other segments into first fields of corresponding records of the auxiliary table; generating indexes associated to the other segments and storing each index into a second field of the record of the auxiliary table storing the associated segment of the sequence and also in a third field of the record of the auxiliary table storing a preceding segment in the sequence. A third record of the main table stores the index of a first segment of the sequence which is stored in the auxiliary table.

Abstract: A method models a defect management routine. Both the modeling and a handling are executed within a manufacturing execution system. During an engineering phase: modeling the production process and creating a library of possible defect types which may occur; assigning the defect types to at least one defect group; creating a library of defect specifications; creating a library of defect type specification details; creating at least one runtime defect criteria that is used to link the defect type to a certain production volume; and creating a runtime defect measurement routine that monitors a corrective measure. During a runtime production phase evaluating the product produced; identifying the respective defect type out of the library of defect types; and using the identified defect type to determine a corrective measure, a runtime defect criteria identifying the resource causing the defect type, a production volume, and to run the respective runtime defect management routine.