An application of a healthcare data warehouse system

Author

Boon Keong Seah

Author_Institution

Adv. Comput. Lab., MIMOS, Berhad, Malaysia

fYear

2013

fDate

29-31 Aug. 2013

Firstpage

269

Lastpage

273

Abstract

This paper describes the establishment ofthe proof of concept (POC) data warehouse platform for the healthcare system which encompassed the system design, ETL data processing, and On-Line Analytical Process (OLAP) analysis. The healthcare data warehouse system implemented is developed in both client-server platform as well as web-based platform. In each platform, we provide both the OLAP and reports in interactive graphical layout and deployed in the cloud environment. In the data cleansing process, a cleansing methodology has been proposed and implements to ensure a consistent and correct loading of data into data warehouse.

Keywords

client-server systems; cloud computing; data mining; data warehouses; health care; interactive systems; ETL data processing; OLAP analysis; POC data warehouse platform; Web-based platform; client-server platform; cloud environment; data cleansing process; data consistency; data loading; extract transform load; healthcare data warehouse system; healthcare system; interactive graphical layout; on-line analytical process analysis; Cleaning; Data mining; Data models; Data warehouses; Databases; Hospitals; Extract Transform Load (ETL); OLAP; data cleaning; data quality;healthcare data warehouse; data warehouse;

fLanguage

English

Publisher

ieee

Conference_Titel

Innovative Computing Technology (INTECH), 2013 Third International Conference on

Conference_Location

London

Print_ISBN

978-1-4799-0047-3

Type

conf

DOI

10.1109/INTECH.2013.6653698

Filename

6653698