Abstract: A system manages results of an analysis process on objects handled along a technical process line. The system contains measures for defining workflow steps of the technical process line and workflow execution software, and measures for generating for each object an object record containing the results of the workflow steps and a status. The system further has measures for defining an event manager for managing a transition from an actual status to a new status according to results of the workflow steps. The event manager contains a customized number of statuses linked to the workflow steps and contains for each transition a customizable set of rules for delivering check results. Finally, measures are provided for executing in parallel the analysis process, the workflow execution software and the event manager, thereby assigning a status to the object record depending on the check results derived from the execution of the set of rules.

Abstract: A method performs a database query in a relational database, the query being carried out by a database engine and being based on user-defined search criteria. The method includes retrieving a number N of properties of a record within a main database table, the number N being higher than zero, creating a search criteria option for each of the N properties, creating a search criteria table for every search criteria option, creating an index for every search criteria table, and performing the database query based on a user-defined combination of a plurality of the search criteria options.

Abstract: A method and a system for managing in a laboratory information management system (LIMS) at least one intervention on at least one piece of equipment managed by the LIMS, and in particular with at least a daily analysis work. The system contains at least one equipment intervention management module integrated to the LIMS, a device for defining in the equipment intervention management module, intervention management rules for the equipment managed by the LIMS, a device for defining in the equipment intervention management module, at least one intervention process for the equipment, and a device for executing the intervention.

Abstract: A system manages results of an analysis process on objects handled along a technical process line. The system contains measures for defining workflow steps of the technical process line and workflow execution software, and measures for generating for each object an object record containing the results of the workflow steps and a status. The system further has measures for defining an event manager for managing a transition from an actual status to a new status according to results of the workflow steps. The event manager contains a customized number of statuses linked to the workflow steps and contains for each transition a customizable set of rules for delivering check results. Finally, measures are provided for executing in parallel the analysis process, the workflow execution software and the event manager, thereby assigning a status to the object record depending on the check results derived from the execution of the set of rules.

Abstract: A method performs a database query in a relational database, the query being carried out by a database engine and being based on user-defined search criteria. The method includes retrieving a number N of properties of a record within a main database table, the number N being higher than zero, creating a search criteria option for each of the N properties, creating a search criteria table for every search criteria option, creating an index for every search criteria table, and performing the database query based on a user-defined combination of a plurality of the search criteria options.

Abstract: In a method for modifying an unlocked record of a database by interacting processes, a first process accesses the record and locks it, then checks if the record is marked for post-processing. In case the record is not marked for post-processing the first process proceeds to the following actions: performs the operations on the record, unlocks the record and terminates. In case the record is marked for post-processing the first process performs the following steps: sets the flag to a predefined first state which denotes that post-processing is due, performs the operations to the record and saves them, unlocks the record, calls a second process and terminates. In the case that the record is marked for post-processing, the second process performs the following steps: performs further operations to the record and saves them, sets the flag to a predefined second state which denotes that post-processing is done and terminates.