The use of Electronic Healthcare Record as a Business Intelligence tool in healthcare
DOI:
https://doi.org/10.14600/irpps_wps.57.2013Keywords:
data warehouse, Electronic Healthcare Record, Business Intelligence, diabetes, dashboard, governance, secondary uses, clinical indicatorsAbstract
This paper proposes the analysis and design of a data warehouse based on the Italian Electronic Healthcare Record (EHR) infrastructure. In particular, it outlines the benefits in the use of the EHR as a Business Intelligence tool, focusing on the system administration and governance (secondary uses). The focus is posed on the LUMIR project (Lucania Medici in Rete), the EHR developed for the Basilicata region. Its architecture and logical model have been used to design the data warehouse and to analyze the main social-health business processes, with particular attention to the healthcare pathway of patients suffering from diabetes mellitus. The present work has been discussed as a thesis for the Master’s Degree in Governance of information systems: development, management, monitoring (Academic year 2011/2012).References
Bentzen, Niels. 1995. “An international glossary for general/family practice.†Family Practice 12.3: 341-369.
Bodenheimer, Thomas, Edward, Wagner H., and Grumbach, Kevin. 2002. “Improving primary care for patients with chronic illness.†Journal of the American Medical Association 288: 1775-1779.
Cabana, Micheal D., Rand, Cynthia S., Powe, Neil R., Wu, Albert W., Wilson, Modena H., Abboud, Paul-André A., and Rubin, Haya R. 1999. “Why don’t physicians follow clinical practice guidelines? A framework for improvement.†Journal of the American Medical Association 282: 1458-1465.
Contenti, Mariangela, Mercurio, Gregorio, Ricci, Fabrizio L., and Serbanati, Luca D. 2010. “The LUMIR project: developing the GP’s network pilot program in the Basilicata region.†Information Systems: People, Organizations, Institutions, and Technologies. Physica-Verlag HD 255-263.
Contenti, Mariangela, and Ricci, Fabrizio L. 2010. “Il sistema LUMIR e gli usi secondari del Fascicolo Sanitario Elettronico.†E-Health care : innovazione e tecnologie in sanità 2(3): 8-25
CONTSys – EN 13940-1:2007 Health informatics – System of concepts to support continuity of care – Part 1: Basic concepts. CEN 2007.
Côté, Roger A. 1989. “Architecture of SNOMED.†Implementing Health Care Information Systems 167-179.
Elliott, Paul, Wakefield, Jon C., Best, Nicola G., and Brings, David J., “Spatialepidemiology: methods and applications.†in Spatial Epidemiology: Methods and applications, (Oxford: University Press 2000): 3-14.
Fritz, April G., “International classification of diseases for oncology: ICD-O.†World Health Organization, 2000.
Grilli, Roberto, and Taroni, Francesco, “Governo clinico: governo delle organizzazioni sanitarie e qualità dell'assistenza.†Il pensiero scientifico, 2004, Roma.
Kimball, Ralph, “The data warehouse lifecycle toolkit: expert methods for designing, developing, and deploying data warehouses.†Wiley, 1998, New York.
Lamberts, Henk, and Hofmans-Okkes, Inge. 1996a. “The core of computer based patient records in family practice: episodes of care classified with ICPC.†International Journal of Biomedical Computing 42.1: 35-41.
Lamberts, Henk, and Hofmans-Okkes, Inge. 1996b. “Episode of care: a core concept in family practice.†Journal of Family Practice 42.2: 161-170.
Luhn, Hans P. 1968. “A business intelligence system.†IBM Journal of Research and Development 2.4: 314-319.
Morosini, Pierluigi, “Indicatori in valutazione e miglioramento della qualità professionale.†Istituto Superiore di Sanità 2004, Roma.
Mosca, Lori, Linfante, Allison H., Benjamin, Emelia J., Berra, Kathy, Hayes, Sharonne N., Walsh, Brian W., Fabunmi, Rosalind P., Kwan, Johnny., Mills, Thomas, and Simpson, Susan L. 2005. “National study of physician awareness and adherence to cardiovascular disease prevention guidelines.†Circulation 111: 499-510.
Norris, Susan L., Nichols, Phyllis J., Caspersen, Carl J., Glasgow, Russell E., Engelgau, Michael M., Leonard, Jack Jr, , Isham, George, Snyder, Susan R., Carande-Kulis, Vilma G., Garï¬eld, Sanford, Briss, Peter, McCulloch, David, and the Task Force on Community Preventive Services. 2002. “The effectiveness of disease and case management for people with diabetes.†American Journal of Preventive Medicine 22: 15-38.
Perrella, Giuseppe, Leggeri, Riccardo, “La gestione del rischio clinico. La sicurezza del paziente e la lotta agli sprechi nelle strutture pubbliche e private.†Franco Angeli 2007, Milano.
Ricci, Fabrizio L., et. al., “Libro Bianco sulla funzione e prospettive di sviluppo del Patient File.†Ministero della Salute – Progetto Mattoni SSN, Realizzazione del Patient File, 2007.
Rossi Mori, Angelo, et al., “Sanità Elettronica, quale futuro possibile.†I quaderni del COPIT QC11, Comitato di Parlamentari per l’Innovazione Tecnologica e lo Sviluppo Sostenibile, 2006.
Rossi Mori, Angelo, and Mazzeo, Marta, “La cartella clinica elettronica: dalla documentazione cartacea al fascicolo sanitario.†Edisef (eHealthbook) 2009, Roma.
Rossi Mori, Angelo, Mercurio, Gregorio, Palumbo, Walter, Paolini Italo, and Ruotolo, Luigi. 2008. “Focused Profiles for Chronic Patients in Integrated Care and Clinical Governance.†Proceedings of the 9th International HL7 Interoperability Conference (IHIC).
Scally, Gabriel, and Donaldson, Liam J. 1998. “Looking forward: clinical governance and the drive for quality improvement in the new NHS in England.†BMJ: British Medical Journal 317.7150: 61.
Schadow, Gunther, Mead, Charles N., Walker, Mead D. 2006. “The HL7 Reference Information Model under scrutiny.†Ubiquity: Technologies for Better Health in Aging Societies, Proceedings of MIE2006. IOS Press: 151-156.
Solon, Jerry A., Feeney, James J., Jones, Sally H., Rigg, Ruth D., and Sheps, Cecil G. 1967. “Delineating episodes of medical care.†American Journal of Public Health and the Nations Health 57.3: 401-408.
Starey, Nigel, “What is clinical governance?†Hayward Medical Communications 1999, London.
Verbicaro, Rita, Pecoraro, Fabrizio, and Mercurio, Gregorio, “HL7 Principi di modellazioneâ€, Edisef 2011, Roma.
Wagner, Edward H. 1998. “Chronic disease management: what will it take to improve care for chronic illness?†Effective Clinical Practice 1: 2-4.
Downloads
Published
How to Cite
Issue
Section
License
 | This licence lets others distribute, remix and build upon a work, even commercially, as long as they credit the original creator/s (and any other nominated parties). This is the most accommodating of the licences in terms of what others can do with the work. |
