The Specifics of Dedicated Data Warehouse Solutions
Anna Zygmunt, Marek A. Valenta, Tomasz Kmiecik · 2005
Data warehouses are currently one of the most dynamic areas of database development. Knowledge in this area is valuable for the developers of applications, especially when it concerns a rarely touched-upon domain. The authors would like to present their experience with the practical implementation of a data warehouse which stores and processes data related to the incidence of nosocomial infections in hospitals. The paper presents the methodology of creating a conceptual data warehouse model as well as the resultant system architecture. We focus on aspects of managing the data warehouse itself and propose methods for creating and updating the data warehouse in light of the specific conditions posed by the application domain. In order to manage our data warehouse we have created a dedicated application, whose development process is also described in this paper.