Siemens Aktiengesellschaft

Ignazio Selvaggio

Andrea Boero

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.

Method and system for storing data in a database

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.

Growing community of inventors

Genoa, Italy

Ignazio Selvaggio