Data Warehouse System to Support Condition Health Care of Elderly
- 1 Department of Information Technology, School of Information and Communication Technology, University of Phayao, Thailand
Abstract
Maeka Health Promotion Hospital conducts a survey on health conditions and collects the data involving activities or organization operations each year, particularly, the data on the elderly health care having too much. This might lead to difficulties in searching and analyzing the information. To solve this problem, it is essential to rely on tools and information technology in making a decision of the administrator rapidly and correctly as well as being the information for caring for and rehabilitating the elderly's health. The objectives of this study are to develop the data warehouse system and to create data visualization to depict the online report in the form of a dashboard. The research results indicate that the data warehouse system in supporting the elderly’s health care consists of four reports such as the report on the elderly’s score Activity of Daily Living (ADL), the statistical report on the elderly’s living, the reports on the elderly’s behavior, ailment and physical disabled and the statistical report on the elderly's health problem and the depression condition evaluation. Meanwhile, the user's satisfaction with the data warehouse system is at a good level ( = 4.21, S.D. = 0.08).
DOI: https://doi.org/10.3844/jcssp.2024.1602.1609
Copyright: © 2024 Rattanawadee Panthong. This is an open access article distributed under the terms of the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original author and source are credited.
- 396 Views
- 213 Downloads
- 0 Citations
Download
Keywords
- Data Warehouse
- Business Intelligence
- Activities of Daily Living
- Elderly
- Health Care