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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Wisniewski, M.F., Kieszkowski, P., Zagorski, B.M., Trick, W.E., Sommers, M., Weinstein, R.A.: Development of a Clinical Data Warehouse for Hospital Infection Control. J. Am. Med. Inform. Assoc. 10, 454–462 (2003)
Lahtela, A., Hassinen, M.: Requirements for Radio Frequency Identification in Healthcare. Stud. Health Technol. Inform. 150, 720–724 (2009)
Brailer, D.J.: Interoperability: the Key to the Future Health Care System. Health Aff. (Millwood) Suppl. Web Exclusives, W5-19–W15-21 (2005)
Hackbarth, G.M., Reichauer, R.D., Miller, M.E.: Medicare Payment Advisory Commission (MEDPAC). Report to the Congress: New Approaches in Medicare, 157–181 (2004)
Bradford Dementia Group, Evaluating dementia care: The DCM method, 7th edn. University of Bradford, Bradford (1997)
Bradford Dementia Group, DCM 8 User’s Manual. University of Bradford, Bradford (2005)
Brooker, D., Foster, N., Banner, A., Payne, M., Jackson, L.: The efficacy of Dementia Care Mapping as an audit tool: report of a 3-year British NHS evaluation. Aging and Mental Health 2(1), 60–70 (1998)
Fossey, J., Ballard, C., Juszczak, E., James, I., Alder, N., Jacoby, R., Howard, R.: Effect of Enhanced Psychosocial Care on Antipsychotic Use in Nursing Home Residents with Dementia: Cluster Randomised Controlled Trial. BMJ 332(7544), 756–758 (2006)
Gigliotti, C.M., Jarrott, S.E., Yorgason, J.: Harvesting Health: Effects of Three Types of Horticultural Therapy Activities for Persons with Dementia. Dementia: The International Journal of Social Research and Practice 3(2), 161–180 (2004)
Sloane, P.D., Brooker, D., Cohen, L., Douglass, C., Edelman, P., Fulton, B.R., Jarrott, S., Kasayka, R., Kuhn, D., Preisser, J.S., Williams, C.S., Zimmerman, S.: Dementia Care Mapping as a Research Tool. International Journal of Geriatric Psychiatry 22, 580–589 (2007)
Younger, D., Martin, G.W.: Dementia care mapping: an Approach to Quality Audit of Services for People with Dementia in two Health Districts. Journal of Advanced Nursing 32(5), 1206–1212 (2000)
Brooker, D., Surr, C.: Dementia Care Mapping: Principles and Practice. University of Bradford, Bradford (2005)
Brooker, D.: Dementia Care Mapping: A Review of the Research Literature. Gerontologist 45 (Special Issue 1), 11–18 (2005)
British Standard Institution (BSI), PAS 800: Use of Dementia Care Mapping for Improved Person-centered Care in a Care Provider Organisations (2010)
Ross, D.: Retail Data Warehousing The- State-of-the-Art. In: Global Coverage of the Business Intelligence Ecosystem, US edition (2005), http://www.b-eye-network.com/view/769
The Data Warehouse Institute Awards: ARC’s Fraud Prevention Solutions. TDWI Best Practices Awards (2009), http://www.arccorp.com/news/pr20090623.pdf
Stolba, N., Tjoa, A.M., Thomas, M., Marko, B.: Federated Data Warehouse Approach to Support the National and International Interoperability of HealthCare Information Systems. In: 15th European Conference on Information systems (ECIS), St Gallen, Switzerland (2007)
Protti, D.J.: How Business Intelligence is making Health Care Smarter. World View Report (10) (2005), http://www.connectingforhealth.nhs.uk/newsroom/worldview/protti10
Connecting for Health (NHS) Spine Factsheet, http://www.connectingforhealth.nhs.uk/resources/systserv/spine-factsheet
Connecting for Health (NHS) Secondary Uses Service (SUS), http://www.connectingforhealth.nhs.uk/systemsandservices/sus
Connection for Health (NHS), Hospital Episode Statistics (HES), http://www.connectingforhealth.nhs.uk/systemsandservices/sus/delivery/hes/index_html
Berndt, D.J., Fisher, J.W., Craighead, J.G., Hevner, A.R., Luther, S., Studnicki, J.: The Role of Data Warehousing in Bioterrorism Surveillance. Decision Support Systems 43, 1383–1403 (2007)
Ramick, C.D.: Data Warehouse in Disease Management Programmes. Journal of Health Care Information Management 15(2), 99–105 (2001)
Berndt, D.J., Hevner, A.R., Studnicki, J.: The Catch Data Warehouse: Support for Community Health Care Decision-making. Decision Support Systems 35, 367–384 (2003)
Stolba, N.: Towards a Sustainable Data Warehouse Approach for Evidence-Based Health Care, PHD Thesis (2007), http://publik.tuwien.ac.at/files/PubDat_141378.pdf
Trujillo, J., Luján-Mora, M.: A UML Based Approach for Modeling ETL Processes in Data Warehouses. In: Song, I.-Y., Liddle, S.W., Ling, T.-W., Scheuermann, P. (eds.) ER 2003. LNCS, vol. 2813, pp. 307–320. Springer, Heidelberg (2003)
Gray, P., Watson, H.: Decision Support in the Data Warehouse. Prentice-Hall, Englewood Cliffs (1998)
Ponniah, P.: Data Warehouse Fundamentals: A Comprehensive Guide for IT Professionals. John Wiley & Sons, inc., Chichester (2001)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2010 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Khalid, S., Surr, C., Neagu, D. (2010). DCM Data Management Framework: A Data Warehousing Approach. In: Khuri, S., Lhotská, L., Pisanti, N. (eds) Information Technology in Bio- and Medical Informatics, ITBAM 2010. ITBAM 2010. Lecture Notes in Computer Science, vol 6266. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-15020-3_4
Download citation
DOI: https://doi.org/10.1007/978-3-642-15020-3_4
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-15019-7
Online ISBN: 978-3-642-15020-3
eBook Packages: Computer ScienceComputer Science (R0)