Research on Biomedical Engineering
http://www.rbejournal.periodikos.com.br/article/doi/10.1590/2446-4740.0666
Research on Biomedical Engineering
Original Article

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

Freire, Sergio Miranda; Souza, Rômulo Cristovão de; Almeida, Rosimary Terezinha de

Downloads: 0
Views: 782

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.

Keywords

Record linkage, Health information systems, Database integration, Data warehouse, Neoplasms.

References

Bastos EA. Estimativa da efetividade do programa de rastreamento do câncer do colo do útero no estado do Rio de Janeiro [dissertation] [internet]. Rio de Janeiro: Universidade Federal do Rio de Janeiro; 2011 [cited 2014 Aug 16]. Available from: http://objdig.ufrj.br/60/teses/coppe_m/EdianeDeAssisBastos.pdf.

Brasil. Lei 12.401, de 28 de abril de 2011. Altera a Lei 8.080, de 19 de setembro de 1990, para dispor sobre a assistência terapêutica e a incorporação de tecnologia em saúde no âmbito do Sistema Único de Saúde - SUS. Diário Oficial da República Federativa do Brasil [internet], Brasília, abr. 2011a [cited 2014 Aug 11]. Available from: http://www.planalto.gov.br/ccivil_03/_Ato2011-2014/2011/Lei/L12401.htm.

Brasil. Decreto 7.646, de 21 de dezembro de 2011. Dispõe sobre a Comissão Nacional de Incorporação de Tecnologias no Sistema Único de Saúde e sobre o processo administrativo para incorporação, exclusão e alteração de tecnologias em saúde pelo Sistema Único de Saúde - SUS, e dá outras providências. Diário Oficial da República Federativa do Brasil [internet], Brasília, dez. 2011b [cited 2014 Aug 11]. Available from: http://www.planalto.gov.br/ccivil_03/_Ato2011-2014/2011/Decreto/D7646.htm.

Churches T, Christen KL, Zhu JX. Preparation of name and address data for record linkage using hidden markov models. Biomed Central Medical Informatics and Decision Making. 2002 [cited 2014 Aug 16]; 2(9). Available from: http://www.biomedcentral.com/content/pdf/1472-6947-2-9.pdf.

Chute CG, Beck SA, Fisk TB, Mohr DN. The Enterprise Data Trust at Mayo Clinic: a semantically integrated warehouse of biomedical data. Journal of the American Medical Informatics Association. 2010; 17(2):131-5. http://dx.doi.org/10.1136/jamia.2009.002691. PMid:20190054.

Comissão Nacional de Incorporação de Tecnologias no Sistema Único de Saúde - Conitec. Decisões sobre a incorporação de tecnologias no Sistema Único de Saúde. Brasília; 2013 [cited 2014 Aug 16]. Available from: http://portalsaude.saude.gov.br/index.php/o-ministerio/principal/leia-mais-o-ministerio/257-sctie-raiz/dgits-raiz/conitec/9027-relatorios-e-decisoes.

Costa MR. Comparação das condutas terapêuticas no tratamento ambulatorial das mulheres com câncer de mama [dissertation]. Rio de Janeiro: Universidade Federal do Rio de Janeiro; 2005.

DATASUS. Departamento de Informática do SUS, sistemas e aplicativos. Brasília; 2013 [cited 2013 Nov 16]. Available from: http://www2.datasus.gov.br/DATASUS/index.php?area=04.

Dean AG, Sullivan KM, Mir R. OpenEpi: Open Source Epidemiologic Statistics for Public Health. 2007 [cited 2014 Aug 16]. Available from: http://www.OpenEpi.com.

Fellegi IP, Sunter AB. A theory for record linkage. Journal of the American Statistical Association. 1969; 64(328):1183-210. http://dx.doi.org/10.1080/01621459.1969.10501049.

Freire SM, Almeida RT, Cabral MD, Bastos EA, Souza RC, da Silva MG. A record linkage process of a cervical cancer screening database. Computer Methods and Programs in Biomedicine. 2012; 108(1):90-101. http://dx.doi.org/10.1016/j.cmpb.2012.01.007. PMid:22341207.

Gill L. Methods for automatic record matching and linking and their use in national statistics. Norwich: Oxford University; 2001, [cited 2014 Aug 16]. (National Statistics Methodology Series, 25). [cited 2014 Aug 16]. Available from: http://www.ons.gov.uk/ons/guide-method/method-quality/specific/gss-methodology-series/gss-methodology-series--25--methods-for-automatic-record-matching-and-linkage-and-their-use-in-national-statistics.pdf.

Gomes SCS Jr, Almeida RT. Identificação de um caso novo de câncer no Sistema de Informação Ambulatorial do Sistema Único de Saúde. Cadernos Saúde Coletiva. 2004; 12:57-68.

Gomes SCS Jr, Almeida RT. Simulation model for estimating the cancer care infrastructure required by the public health system. Revista Panamericana de Salud Publica. 2009; 25(2):113-119. http://dx.doi.org/10.1590/S1020-49892009000200003.

Gomes SCS Jr, Martino R, Almeida RT. Rotinas de integração das tabelas do Sistema de Autorização de Procedimentos de Alta Complexidade em Oncologia do Sistema Único de Saúde. Cadernos Saúde Coletiva. 2003; 11:231-54.

Herzog TN, Scheuren FJ, Winkler WE. Data quality and record linkage techniques. New York: Springer Science + Business Media, LLC; 2007.

Immon WH. Building the data warehouse. 4th ed. Wiley Publishing; 2005.

Kimbal R. The data warehouse lifecycle toolkit. Indianapolis: Wiley Publishing; 2008.

Kimball R, Caserta J. The data warehouse ETL toolkit: practical techniques for extracting, cleaning, conforming, and delivering data. Indianapolis: Wiley Publishing; 2004.

Lyman JA, Scully K, Harrison JH Jr. The development of health care data warehouses to support data mining. Clinics in Laboratory Medicine. 2008; 28(1):55-71, vi. http://dx.doi.org/10.1016/j.cll.2007.10.003. PMid:18194718.

Martins M, Travassos C. Assessing the availability of casemix information in hospital database systems in Rio de Janeiro, Brazil. International Journal for Quality in Health Care. 1998; 10(2):125-33. http://dx.doi.org/10.1093/intqhc/10.2.125. PMid:9690885.

Muranaga F, Kumamoto I, Uto Y. Development of hospital data warehouse for cost analysis of DPC based on medical costs. Methods of Information in Medicine. 2007; 46(6):679-85. PMid:18066419.

Newcombe HB, Kennedy JM, Axford SJ, James AP. The use of medical record linkage for population and genetic studies. Methods of Information in Medicine. 1969; 8(1):7-11. PMid:5780257.

Oracle. MySQL database. 2013 [cited 2014 Aug 16]. Available from: http://www.oracle.com/br/products/mysql/index.html

Pentaho Corporation. Pentaho. 2014 [cited 2014 Aug 16]. Available from: http://www.pentaho.com.

Pires FA. Ambiente para extração de informação epidemiológica a partir da mineração de dez anos de dados do Sistema Público de Saúde [thesis]. São Paulo: Universidade de São Paulo; 2011.

Prevedello LM, Andriole KP, Hanson R, Kelly P, Khorasani R. Business intelligence tools for radiology: creating a prototype model using open-source tools. Journal of Digital Imaging. 2010; 23(2):133-41. http://dx.doi.org/10.1007/s10278-008-9167-3. PMid:19011943.

Queiroz OV, Guerra AA Jr, Machado CJ, Andrade ELG, Meira W Jr, Acúrcio FA, Santos W Fo, Cherchiglia ML. Building the national database on renal replacement therapy focused on the individual: probabilistic record linkage of death registries at the high complexity procedures authorization subsystem (Apac/SIA/SUS) and at the mortality information system (SIM) – Brazil, 2000-2004. Epidemiologia e Serviços de Saúde. 2009; 18(2):107-20.

Santos RS, Gutierrez MA. Ambiente computacional para extração de informações para a gestão da saúde pública por meio da mineração dos dados do SUS. Revista Brasileira de Engenharia Biomédica. 2008; 24(2):77-90. http://dx.doi.org/10.4322/rbeb.2012.050.

Souza RC, Pinheiro RS, Coeli CM, Camargo KR Jr. The Charlson comorbidity index (CCI) for adjustment of hip fracture mortality in the elderly: analysis of the importance of recording secondary diagnoses. Cadernos de Saude Publica. 2008; 24(2):315-22. http://dx.doi.org/10.1590/S0102-311X2008000200010. PMid:18278278.
5889fbf35d01231a018b4881 rbejournal Articles
Links & Downloads

Res. Biomed. Eng.

Share this page
Page Sections