Siemens Aktiengesellschaft

Andrea Boero

Matteo Bardini

Davide Corso

Ignazio Selvaggio

Davide Mini

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.

Method for merging data into a database table by locking data identities in the database table that are also present in a temporary copy of the database table and executing update and import functions

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.

Method and system for archiving data from a source database to a target database

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 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 T, to add a new resource to the pool, and to terminate the resource of the pool.

Method and system for managing resources among different clients for an exclusive use

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.

Modeling defect management and product handling during the manufacturing process

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.

Growing community of inventors

Genoa, Italy

Andrea Boero