OBJECTIVE: To describe the development of an information system that connects data from multiple health records to improve assistance to patients, health services administration, management, evaluation, and inspection, as well as public health and research. METHOD: Deterministic connection of pseudonymized data from a population of 8.5 million inhabitants provided by: a users database, DIRAYA electronic medical records, minimum basic data sets (inpatients, outpatient mayor surgery, hospital emergencies and medical day hospital), mental health information systems, analytical and image tests, vaccines, renal patients, and pharmacy. An automatic coder was used to code clinical diagnoses and 80 chronic pathologies were identified to follow-up. The architecture of the information system consisted of three layers: data (Oracle Database 11g), applications (MicroStrategy BI) and presentation (MicroStrategy Web, JavaScript libraries, HTML 5 and CSS style sheets). Measures for the governance of the system were implemented. RESULTS: Data from 12.5 million health system users between 2001 and 2017 were gathered, including 435.5 million diagnoses, 88.7% of which were generated by the automatic coder. Data can be accessed through predefined reports or dynamic queries, both exportable to CSV files for processing outside the system. Expert analysts can directly access the databases and perform queries using SQL or directly treat the data with external tools. CONCLUSION: The work has shown that the connection of health records opens new possibilities for data analysis.
OBJECTIVE: To describe the development of an information system that connects data from multiple health records to improve assistance to patients, health services administration, management, evaluation, and inspection, as well as public health and research. METHOD: Deterministic connection of pseudonymized data from a population of 8.5 million inhabitants provided by: a users database, DIRAYA electronic medical records, minimum basic data sets (inpatients, outpatient mayor surgery, hospital emergencies and medical day hospital), mental health information systems, analytical and image tests, vaccines, renal patients, and pharmacy. An automatic coder was used to code clinical diagnoses and 80 chronic pathologies were identified to follow-up. The architecture of the information system consisted of three layers: data (Oracle Database 11g), applications (MicroStrategy BI) and presentation (MicroStrategy Web, JavaScript libraries, HTML 5 and CSS style sheets). Measures for the governance of the system were implemented. RESULTS: Data from 12.5 million health system users between 2001 and 2017 were gathered, including 435.5 million diagnoses, 88.7% of which were generated by the automatic coder. Data can be accessed through predefined reports or dynamic queries, both exportable to CSV files for processing outside the system. Expert analysts can directly access the databases and perform queries using SQL or directly treat the data with external tools. CONCLUSION: The work has shown that the connection of health records opens new possibilities for data analysis.
Keywords:
Almacenamiento de datos; Conexión de registros médicos; Data analysis; Data warehouse; Decision support systems; Electronic health records; Estadística; Health information systems; Historia clínica electrónica; Investigación; Medical record linkage; Organización y administración; Organization and administration; Research; Sistemas de ayuda a decisiones; Sistemas de información en salud
Authors: Ana Barragán-Prieto; Soledad Pérez-Sánchez; Francisco Moniche; Roberto Valverde Moyano; Fernando Delgado; Patricia Martínez-Sánchez; Miguel Moya; Juan M Oropesa; Adolfo Mínguez-Castellanos; Inmaculada Villegas; María José Álvarez Soria; Jose Antonio Tamayo Toledo; Carlos de la Cruz Cosme; Rafael Canto Neguillo; Juan Manuel Herrerías Esteban; Daniel José Montero Cobos; Jose Antonio Moreno Muñoz; Alejandro González; Joan Montaner Journal: Eur Stroke J Date: 2022-05-25
Authors: Carlos Loucera; María Peña-Chilet; Marina Esteban-Medina; Dolores Muñoyerro-Muñiz; Román Villegas; Jose Lopez-Miranda; Jesus Rodriguez-Baño; Isaac Túnez; Roger Bouillon; Joaquin Dopazo; Jose Manuel Quesada Gomez Journal: Sci Rep Date: 2021-12-03 Impact factor: 4.379
Authors: Jonás Carmona-Pírez; Ignatios Ioakeim-Skoufa; Antonio Gimeno-Miguel; Beatriz Poblador-Plou; Francisca González-Rubio; Dolores Muñoyerro-Muñiz; Juliana Rodríguez-Herrera; Juan Antonio Goicoechea-Salazar; Alexandra Prados-Torres; Román Villegas-Portero Journal: Int J Environ Res Public Health Date: 2022-03-23 Impact factor: 3.390
Authors: Carlos Loucera; Javier Perez-Florido; Carlos S Casimiro-Soriguer; Francisco M Ortuño; Rosario Carmona; Gerrit Bostelmann; L Javier Martínez-González; Dolores Muñoyerro-Muñiz; Román Villegas; Jesus Rodriguez-Baño; Manuel Romero-Gomez; Nicola Lorusso; Javier Garcia-León; Jose M Navarro-Marí; Pedro Camacho-Martinez; Laura Merino-Diaz; Adolfo de Salazar; Laura Viñuela; Jose A Lepe; Federico Garcia; Joaquin Dopazo Journal: Viruses Date: 2022-08-27 Impact factor: 5.818
Authors: Joaquín Dopazo; Douglas Maya-Miles; Federico García; Nicola Lorusso; Miguel Ángel Calleja; María Jesús Pareja; José López-Miranda; Jesús Rodríguez-Baño; Javier Padillo; Isaac Túnez; Manuel Romero-Gómez Journal: J Pers Med Date: 2021-05-26