Integrating Brazilian health information systems in order to support the building of data warehouses

Abstract

Introduction: This paper's aim is to develop a data warehouse from the integration of the files of three Brazilian health information systems concerned with the production of ambulatory and hospital procedures for cancer care, and cancer mortality. These systems do not have a unique patient identification, which makes their integration difficult even within a single system. Methods: Data from the Brazilian Public Hospital Information System (SIH-SUS), the Oncology Module for the Outpatient Information System (APAC-ONCO) and the Mortality Information System (SIM) for the State of Rio de Janeiro, in the period from January 2000 to December 2004 were used. Each of the systems has the monthly data production compiled in dbase files (dbf). All the files pertaining to the same system were then read into a corresponding table in a MySQL Server 5.1. The SIH-SUS and APAC-ONCO tables were linked internally and with one another through record linkage methods. The APAC-ONCO table was linked to the SIM table. Afterwards a data warehouse was built using Pentaho and the MySQL database management system. Results: The sensitivities and specificities of the linkage processes were above 95% and close to 100% respectively. The data warehouse provided several analytical views that are accessed through the Pentaho Schema Workbench. Conclusion: This study presented a proposal for the integration of Brazilian Health Systems to support the building of data warehouses and provide information beyond those currently available with the individual systems.

Comparing the Performance of NoSQL Approaches for Managing Archetype-Based Electronic Health Record Data

“…These databases were subjected to a record linkage process, so that records belonging to the same patient received the same identification number (uid). This process was performed separately for AIH, APAC and MIS [ 28 ], on one side, and for the SISCOLO database on the other side [ 29 ].…”

Administrative Data Linkage in Brazil: Potentials for Health Technology Assessment

“…Mammography results are classified using the Breast Imaging Reporting and Data System (BI-RADS) developed by the American College of Radiology (ACR). SISMAMA has been used in several studies after linkage with SIM, SIA-APAC, and SIH-SUS (Freire et al, 2015; Peres et al, 2016; Tomazelli et al, 2018a; Tomazelli et al, 2018b).…”

“…Recent work on the development of an open source version, the OpenRecLink (de Camargo and Coeli, 2015) has provided a multi-platform solution suitable to international users. Additional efforts have been made to define a cut-off point on probabilistic record linkage results (Verzinhasse Peres et al, 2014) and building a data warehouse for the integration of three Brazilian health information systems concerned with the production of ambulatory and hospital procedures for cancer care, and cancer mortality: SIH-SUS, APAC-ONCO, and SIM (Freire et al, 2015).…”

Healthcare resource utilization of spinal muscular atrophy in the Brazilian Unified Health System: a retrospective database study

“…The methodology used to assess the inpatient healthcare resource could explain this data discrepancy, such as probabilistic record linkage techniques. (Freire et al, 2015). This method depends on the correct coding of SMA diagnosis, according to ICD-10, and misclassification of SMA cases due to incorrect registration ICD codes is widespread, which could lead to an underestimated number of outpatients SMA-related procedures.…”