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: 2016
Pages: 32
Source title: Applying Business Intelligence to Clinical and Healthcare Organizations
Source Author(s)/Editor(s): José Machado (University of Minho, Portugal)and António Abelha (University of Minho, Portugal)
DOI: 10.4018/978-1-4666-9882-6.ch005

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

Dina Darwish. © 2024. 48 pages.
Dina Darwish. © 2024. 51 pages.
Smrity Prasad, Kashvi Prawal. © 2024. 19 pages.
Jignesh Patil, Sharmila Rathod. © 2024. 17 pages.
Ganesh B. Regulwar, Ashish Mahalle, Raju Pawar, Swati K. Shamkuwar, Priti Roshan Kakde, Swati Tiwari. © 2024. 23 pages.
Pranali Dhawas, Abhishek Dhore, Dhananjay Bhagat, Ritu Dorlikar Pawar, Ashwini Kukade, Kamlesh Kalbande. © 2024. 24 pages.
Pranali Dhawas, Minakshi Ashok Ramteke, Aarti Thakur, Poonam Vijay Polshetwar, Ramadevi Vitthal Salunkhe, Dhananjay Bhagat. © 2024. 26 pages.
Body Bottom