IRMA-International.org: Creator of Knowledge
Information Resources Management Association
Advancing the Concepts & Practices of Information Resources Management in Modern Organizations

A New Approach to Generate Hospital Data Warehouse Schema

A New Approach to Generate Hospital Data Warehouse Schema
View Sample PDF
Author(s): Nouha Arfaoui (Institut Supérieur de Gestion de Tunis, Tunisia)and Jalel Akaichi (Institut Supérieur de Gestion de Tunis, Tunisia)
Copyright: 2020
Pages: 26
Source title: Hospital Management and Emergency Medicine: Breakthroughs in Research and Practice
Source Author(s)/Editor(s): Information Resources Management Association (USA)
DOI: 10.4018/978-1-7998-2451-0.ch001

Purchase

View A New Approach to Generate Hospital Data Warehouse Schema on the publisher's website for pricing and purchasing information.

Abstract

The healthcare industry generates huge amount of data underused for decision making needs because of the absence of specific design mastered by healthcare actors and the lack of collaboration and information exchange between the institutions. In this work, a new approach is proposed to design the schema of a Hospital Data Warehouse (HDW). It starts by generating the schemas of the Hospital Data Mart (HDM) one for each department taking into consideration the requirements of the healthcare staffs and the existing data sources. Then, it merges them to build the schema of HDW. The bottom-up approach is suitable because the healthcare departments are separately. To merge the schemas, a new schema integration methodology is used. It starts by extracting the similar elements of the schemas and the conflicts and presents them as mapping rules. Then, it transforms the rules into queries and applies them to merge the schemas.

Related Content

Nouha Arfaoui, Jalel Akaichi. © 2020. 26 pages.
Manel Saad Saoud, Abdelhak Boubetra, Safa Attia. © 2020. 18 pages.
Jim Ryan, Barbara Doster, Sandra Daily, Carmen Lewis. © 2020. 26 pages.
Rakhee, M. B. Srinivas. © 2020. 13 pages.
Rui Veloso, Filipe Portela, Manuel Filipe Santos, José Machado, António da Silva Abelha, Fernando Rua, Álvaro Silva. © 2020. 16 pages.
Alberto Freitas, Isabel Garcia Lema, Altamiro Costa-Pereira. © 2020. 12 pages.
Filipe Portela, Manuel Filipe Santos, António da Silva Abelha, José Machado, Fernando Rua. © 2020. 10 pages.
Body Bottom