Welcome to the InfoSci Platform
A New Approach to Generate Hospital Data Warehouse Schema

A New Approach to Generate Hospital Data Warehouse Schema

Nouha Arfaoui, Jalel Akaichi
Copyright: © 2020 |Pages: 26
ISBN13: 9781799824510|ISBN10: 1799824519|EISBN13: 9781799824527
DOI: 10.4018/978-1-7998-2451-0.ch001
Cite Chapter Cite Chapter

MLA

Arfaoui, Nouha, and Jalel Akaichi. "A New Approach to Generate Hospital Data Warehouse Schema." Hospital Management and Emergency Medicine: Breakthroughs in Research and Practice, edited by Information Resources Management Association, IGI Global, 2020, pp. 1-26. https://doi.org/10.4018/978-1-7998-2451-0.ch001

APA

Arfaoui, N. & Akaichi, J. (2020). A New Approach to Generate Hospital Data Warehouse Schema. In I. Management Association (Ed.), Hospital Management and Emergency Medicine: Breakthroughs in Research and Practice (pp. 1-26). IGI Global. https://doi.org/10.4018/978-1-7998-2451-0.ch001

Chicago

Arfaoui, Nouha, and Jalel Akaichi. "A New Approach to Generate Hospital Data Warehouse Schema." In Hospital Management and Emergency Medicine: Breakthroughs in Research and Practice, edited by Information Resources Management Association, 1-26. Hershey, PA: IGI Global, 2020. https://doi.org/10.4018/978-1-7998-2451-0.ch001

Export Reference

Mendeley
Favorite

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.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.