Laboratory database for bacterial sample data cataloguing in the hospital environment

Abstract

The proper management of the results of typing methods for bacterial classification is crucial for monitoring the spread of infections in the hospital environment. The solution for their management is a relational database. The problem is the storage of large amounts of multidimensional data due to the variability of typing methods and the need to adapt the working of the database to the requirements of a specific healthcare facility. This paper introduces the design and implementation of a relational database for the Centre of Molecular Biology and Genetics at the University Hospital Brno. It discusses the key steps in database development, including data structuring, table and relation creation, and user interface design. The use of the database has significantly improved the management and accessibility of typing data within the department.