This is one of 4124 IT projects that we have successfully completed with our customers.

How can we support you?

Weißes Quadrat mit umrandeten Seiten rechts oben

Database queries to identify workload of laboratory information systems

Project duration: 3 months

Brief description

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.

Supplement

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.

Subject description

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.

Overview

Project period18.07.2016 - 15.10.2016

Have we sparked your interest?

Portrait Herr Knudsen, Mann im Anzug

Ole Knudsen

Key Account Manager

Jetzt Kontakt aufnehmen

Zum Umgang mit den hier erhobenen Daten informieren wir in unserer Datenschutzerklärung.

Contact now

We provide information on the handling of the data collected here in our privacy policy.

Download file

We provide information on the handling of the data collected here in our privacy policy.