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

A New Approach to Generate Hospital Data Warehouse Schema

Nouha Arfaoui, Jalel Akaichi
Copyright: © 2016 |Pages: 32
ISBN13: 9781466698826|ISBN10: 1466698829|EISBN13: 9781466698833
DOI: 10.4018/978-1-4666-9882-6.ch005
Cite Chapter Cite Chapter

MLA

Arfaoui, Nouha, and Jalel Akaichi. "A New Approach to Generate Hospital Data Warehouse Schema." Applying Business Intelligence to Clinical and Healthcare Organizations, edited by José Machado and António Abelha, IGI Global, 2016, pp. 84-115. https://doi.org/10.4018/978-1-4666-9882-6.ch005

APA

Arfaoui, N. & Akaichi, J. (2016). A New Approach to Generate Hospital Data Warehouse Schema. In J. Machado & A. Abelha (Eds.), Applying Business Intelligence to Clinical and Healthcare Organizations (pp. 84-115). IGI Global. https://doi.org/10.4018/978-1-4666-9882-6.ch005

Chicago

Arfaoui, Nouha, and Jalel Akaichi. "A New Approach to Generate Hospital Data Warehouse Schema." In Applying Business Intelligence to Clinical and Healthcare Organizations, edited by José Machado and António Abelha, 84-115. Hershey, PA: IGI Global, 2016. https://doi.org/10.4018/978-1-4666-9882-6.ch005

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.