DCM data management framework: a data warehousing approach

Authors:
Shehla Khalid;Claire Surr;Daniel Neagu
Affiliations:
School of Computing, Informatics and Media, University of Bradford, Bradford, UK;School of Health Studies, University of Bradford, Bradford, UK;School of Computing, Informatics and Media, University of Bradford, Bradford, UK
Venue:
ITBAM'10 Proceedings of the First international conference on Information technology in bio- and medical informatics
Year:
2010

Citing 4
Cited 0

Data Warehousing Fundamentals

Data Warehousing Fundamentals
Decision Support in the Data Warehouse

Decision Support in the Data Warehouse
The Catch data warehouse: support for community health care decision-making

Decision Support Systems
The role of data warehousing in bioterrorism surveillance

Decision Support Systems

Quantified Score

Hi-index	0.01

Visualization

Abstract

In health care systems the contribution of Information Technology (IT) has proven to have a dynamic role in supporting the quality of care provided to the general population. Dementia Care Mapping (DCM), an observational tool to assess the quality of care for people with dementia, still depends on spreadsheet based tools for data storage and analysis. This system does not comply with the emerging needs of DCM data to store, share, track, and compare overtime in order to monitor progress and trends in care quality. In this paper we provide an overview of the DCM system, identify the need for data management and we propose a DCM data management framework based on a data warehousing approach to facilitate the data collection, storage, sharing and analysis in an organised and consistent manner. We show the sequence of steps (designing relational and dimensional databases) required to transform DCM data into required information.