Statistical tool for laboratory data

The project is implemented in accordance with the requirements of the FDA, the development is managed with SVN and Visual Studio. The VB .NET application is used for data warehouse configuration, controlling data selection (e.g. evaluation period) from the Oracle database, and the export of data to preconfigurable Excel files. A test for data inconsistencies is made. The transaction data tables and data warehouse integrated in the LIS form the basis of the evaluations. As the customers have different requirements on the statistics, the flexible Excel output is chosen, which allows the users to create individual statistics. A special challenge is to program high-performance PL-SQL database queries on the complex data stocks, because the operation of the laboratory must not be affected by them. The statistics are used, among other things, to meet the legal requirement for German laboratories to report to the Robert Koch Institute (statistics on germs, pathogens, and resistance).