Dimensional model of healthcare services for Health Dependencies of Public Universities
DOI:
https://doi.org/10.17981/ingecuc.16.2.2020.16Keywords:
data warehouse, medical consultation, odontologic consultation, psychological consultation, dimensional modelAbstract
Introduction: Most public higher education institutions in Colombia offer healthcare services to students through a dependency, which needs to characterize the population, relying on databases, to generate welfare policies. However, most of them do not have a repository that integrates information from healthcare services, allows analyzing the data, and generates programs of promotion and prevention in accordance with the characteristics of the population.
Objective: Propose a trio of dimensional models for healthcare services in general medicine, dentistry and psychology, specifying the identified design techniques.
Method: In the elaboration of the dimensional models and the data warehouse prototype, the methodology for the development of data warehouses for small and medium-sized enterprises was used, bearing in mind that it is aimed at small workgroups and the use of few roles and artifacts.
Results: The evaluation of Utility based on the ISO/IEC 25022 standard that was carried out on the prototype of the data warehouse for the general medicine service of the Universidad del Cauca, it showed that the degree of user satisfaction was Very satisfactory.
Conclusions: The proposed dimensional models allow obtaining statistics requested by government entities, which is described in the design techniques identified, allowing these models to be adapted in the design of similar health services in public universities in the country.
Downloads
References
Ministerio de Educación, Lineamientos de política de bienestar para instituciones de educación superior, Bg. Co.: Mineducación, 2016. Available: https://www.mineducacion.gov.co/1759/articles-360314_recurso.pdf
O. Bernal-Acevedo & J. C. Forero-camacho, “Sistemas de información en el sector salud en Colombia,” Gerenc Polit Salud, vol. 10, no. 21, pp. 85–100, Dec. 2011. https://doi.org/10.11144/Javeriana.rgsp10-21.siss
Ministerio de Educación, Compendio Estadístico Educación Superior Colombiana. Bo., Co.: INC.
R. Kimball & M. Ross,The data warehouse toolkit: The Definitive Guide to Dimensional Modeling. 3 Ed. Hbk., NY, USA: Wiley, Jul. 2013.
R. Dutta, “Health Care Data Warehouse System Architecture for Influenza (Flu) Diseases,” presented at Comput Sci Inf Technol, AIRCC, Cn., TN., In., pp. 77–89, Mar. 2013. https://doi.org/10.5121/csit.2013.3208
F. Pecoraro, D. Luzi & F. L. Ricci, “Designing ETL Tools to Feed a Data Warehouse Based on Electronic Healthcare Record Infrastructure,” Stud Health Technol Inform, vol. 10, pp. 929–933, 2015. https://doi.org/10.3233/978-1-61499-512-8-929
S. I. Khan & A. Hoque, “Towards development of health Data Warehouse: Bangladesh perspective,” presented at International Conference on Electrical Engineering and Information Communication Technology, ICEEICT, Savar, Bd., 21-23 May. 21-23, 2015. https://doi.org/10.1109/ICEEICT.2015.7307514
S. I. Khan & A. Hoque, “Towards Development of National Health Data Warehouse for Knowledge Discovery,” Intell Syst Technol Appl, vol. 2, pp. 413–421, 2016. https://doi.org/10.1007/978-3-319-23258-4_36
S. G. Cornejo, K. Caro, L. F. Rodriguez, R. Aguilar, C. B. Perez & L. A. Castro, “Design and Implementation of a Data Warehouse to Support Decision-Making in a Health Environment,” Res Comput Sci, vol. 147, no. 3, pp. 45–53, 2018. https://doi.org/10.13053/rcs-147-3-5
B. Kitchenham & P. Brereton, “A systematic review of systematic review process research in software engineering,” Inf Softw Technol,vol. 55, no. 12, pp. 2049–2075, Dic. 2013. https://doi.org/10.1016/j.infsof.2013.07.010
M. E. Mendoza, L. Duran Meneses & N. Rivera Ortiz, “MBD 1.0 - Metodología de desarrollo de bodegas de datos para micro, pequeñas y medianas empresas,” UIS Ing, vol. 9, no. 1, pp. 85–101, 2010. Disponible en https://revistas.uis.edu.co/index.php/revistauisingenierias/article/view/1059
A. Gómez, “Clasificación Internacional de Enfermedades (CIE): Descifrando la CIE-10 y esperando la CIE-11,” Monitor Estratégico, no. 7, pp. 66–73, 2015. Available: https://www.minsalud.gov.co/sites/rid/Lists/BibliotecaDigital/RIDE/IA/SSA/cie10-cie11.pdf
Alcaldia Mayor de Bogotá D.C., “Lista de medicamentos resolución 1016 de 2015,” Resolución 1016 de 2015, SDS-PSS-FT-439 V.1, 2015. Available: http://www.saludcapital.gov.co/Documents/LISTA DE MEDICAMENTOS - RESOLUCIÓN 1016 DE 2015.pdf
República de Colombia, Ministerio de Salud y Protección Social, “Resolución 5851 del 2018,” consultorsalud.com, [online , 2018. Available: http://www.consultorsalud.com/sites/consultorsalud/files/nuevos_cups_para_2019_-_resolucion_5851_de_2018_-_consultorsalud.pdf
República de Colombia, Ministerio de la Protección Social, “Aspectos metodológicos para la construcción de Línea base para el Seguimiento a las Metas del Objetivo 3 del Plan Nacional de Salud Pública,” minsalud.gov.co, [online , 2010. Available: https://www.minsalud.gov.co/Documentos y Publicaciones/DOCUMENTO TÉCNICO LÍNEA DE BASE CON ATLAS VERSIÓN 3 - ABRIL 2010.pdf
E. A. Balseca, “Evaluacón de calidad de productos software en empresas de desarrollo de software aplicando la norma ISO/IEC 25000,” Tesis de Grado, Fac. Ing. Sis., EPN, Uio., Ec., 2014.
C. K. Hou, “Examining users’ intention to continue using business intelligence systems from the perspectives of end-user computing satisfaction and individual performance,” Int J Bus Contin Risk Manag, vol. 8, no. 1, pp. 49–70, Mar. 2018. https://doi.org/10.1504/IJBCRM.2018.090593
J. García, J. R. Aguilera & A. Castillo, “Guía técnica para la construcción de escalas de actitud,” Rev. Electron Pedagog, vol. 8, no. 16, pp. 1–13, 2011. Recuperado de https://www.odiseo.com.mx/2011/8-16/pdf/garcia-aguilera-castillo-guia-construccion-escalas-actitud.pdf
Published
How to Cite
Issue
Section
License
Copyright (c) 2020 INGE CUC
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
Published papers are the exclusive responsibility of their authors and do not necessary reflect the opinions of the editorial committee.
INGE CUC Journal respects the moral rights of its authors, whom must cede the editorial committee the patrimonial rights of the published material. In turn, the authors inform that the current work is unpublished and has not been previously published.
All articles are licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
English
Español (España)
