Database queries to identify workload of laboratory information systems
Start/end of project:18.07.2016 - 15.10.2016
Laboratory information systems (LIS) are used as so called middlewares in medicinal-diagnostic laboratories. They support specific laboratory workflows, allow to view and store data or are responsible for the communication between host systems and laboratory devices. The manufacturer of LIS is provided with individual database queries which allow him to obtain statistical data concerning the operation of LIS as well as the workload capacity of running LIS. Moreover, the provided solution also allows to identify the hardware specification of LIS. The database queries are written in SQL and can be executed through a provided windows batch script.
As the database queries support multiple LIS products, the database technologies used in LIS products are identified and the different database table structures are analyzed. For oracle databases, SQL*Plus is used to execute SQL queries. For databases using InterSystems Caché, the development of an individual solution is required by using third party libraries. After clarification of customer requirements and definition of various terms, the SQL queries are written and tested in specific testing environments. The customer is provided with the SQL queries, as well as the batch script including the individual software solution to execute the queries.
The customer is interested in executing the SQL queries on running LIS products to identify the average and maximal workload of LIS, as well as the hardware specifications of the systems. Special attention is paid to the time-dependent sample distribution over the course of a day, including various aggregations over different groups of samples. The project takes place in the scope of a bigger project with the goal to identify the minimal hardware requirements for the optimal operation of LIS for various sizes of laboratories.