Abstract: A method and a system import data into a table. The method includes providing the table with data identities and a primary key assigned to each of the data identities. A temporary copy of the table is provided and contains a data identity to be merged into the table. The table structure of the table and of the temporary copy is determined and the determined table structure is compared to the table structure of the temporary copy to decide which data identities have to be updated and/or imported. In the temporary copy a new column contains a final primary key of the related data identity for its transfer into the table. The data identities in the table that are present in the temporary copy are locked and an update function for the data identities having the same primary key in both the table and the temporary copy are executed.

Abstract: A method and a system for archiving data from a source database to a target database perform the following step: a) specifying the data being subject to the archiving operation in the source database; b) extracting the data genealogy of the specified data, thereby revealing the physical relations among tables of the specified data and/or arbitrary rules defined by an administrator in order to create a data tree of the specified data; c) executing an export/import operation of the specified data from the source database to the target database, thereby starting in a direction from the root of the data tree to the leaves of the data tree; and d) after the successful execution of the export/import operation, executing a delete operation in the source database for the specified data, thereby starting in a direction of the leaves of the data tree to the root of the data tree.

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 and a system share resources of a server among different clients. The system has a server which contains a maximum number m of resources among which a predetermined number w of the resources are initializable for being kept ready for use by the clients and forming a pool. A communication system communicates with the clients. A managing device manages the resources. The managing device contains at least a processor and a memory. The managing device is able to change the status of the resource of the pool in dependence on an assignment of the resource to the client or a release of the resource at a time T4, to add a new resource to the pool, and to terminate the resource of the pool.

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 and a system for archiving data from a source database to a target database perform the following step: a) specifying the data being subject to the archiving operation in the source database; b) extracting the data genealogy of the specified data, thereby revealing the physical relations among tables of the specified data and/or arbitrary rules defined by an administrator in order to create a data tree of the specified data; c) executing an export/import operation of the specified data from the source database to the target database, thereby starting in a direction from the root of the data tree to the leaves of the data tree; and d) after the successful execution of the export/import operation, executing a delete operation in the source database for the specified data, thereby starting in a direction of the leaves of the data tree to the root of the data tree.

Abstract: A method and a system import data into a table. The method includes providing the table with data identities and a primary key assigned to each of the data identities. A temporary copy of the table is provided and contains a data identity to be merged into the table. The table structure of the table and of the temporary copy is determined and the determined table structure is compared to the table structure of the temporary copy to decide which data identities have to be updated and/or imported. In the temporary copy a new column contains a final primary key of the related data identity for its transfer into the table. The data identities in the table that are present in the temporary copy are locked and an update function for the data identities having the same primary key in both the table and the temporary copy are executed.

Abstract: A method and system for entities of a data access layer, the data access layer following an entity-relationship model in which data are depicted in term of entities and relationships between them and the entities are provided with a CRUD interface. The method includes the steps of: defining a meta-entity being a virtual entity, resulting as a composition of parts of one or more entities; describing the virtual entity, via a virtual entity descriptor, as a hierarchical structure in which entities are connected in a parent-child structure via a link; in the virtual entity descriptor, specifying which properties are taken from each entity to form partial entities of the virtual entity; providing a CRUD interface on the virtual entity; and at run time, accessing the virtual entity via its CRUD interface. The accessing is implemented as a set of calls to CRUD methods accessing the entities composing the virtual entity.

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.