Abstract
AbstractIntroduction: This paper aims to develop a data warehouse (AD-SISCOLO) in order to support the management of the cervical cancer screening program in the municipality of Rio de Janeiro/Brazil. As a part of the management process, the program managers of the municipality perform tedious manual work in order to calculate a series of performance indicators and then take decisions based on them. Methods AD-SISCOLO was implemented using the Pentaho BI Suite Business Intelligence Platform and the MySQL database management system. The indicators to be calculated and visualized in the tool were based on the municipal data of the cytopathology and histopathology tests from January 2012 until December 2014, which was obtained from the Information System of Cervical Cancer (SISCOLO) after a record linkage process. The follow-up indicators were based on a simplified version of the Brazilian guidelines for the cervical cancer screening. Results AD-SISCOLO allows the visualization of a set of test-based and follow-up indicators from different views and dimensions, which enable managers to monitor all the phases of the screening process and to identify the process’ failures. Conclusions Compared with the current available environments in Brazil, AD-SISCOLO is unique in its visualization of the follow-up indicators of groups of women, according to their test results and age. Thereby it provides presentation flexibility to suit the program manager's needs.
Highlights
This paper aims to develop a data warehouse (AD-SISCOLO) in order to support the management of the cervical cancer screening program in the municipality of Rio de Janeiro/Brazil
The AD-SISCOLO dimensional model is shown in Figure 1, with the fact table connected to the dimensional tables through the foreign keys respectively
The methodology to obtain a number of folow-up indicators from the SISCOLO raw data and the Brazilian guidelines for cervical cancer screening and their visualization by groups of women, according to their test results and age, are the major contributions of this data warehouse (DW)
Summary
This paper aims to develop a data warehouse (AD-SISCOLO) in order to support the management of the cervical cancer screening program in the municipality of Rio de Janeiro/Brazil. The indicators to be calculated and visualized in the tool were based on the municipal data of the cytopathology and histopathology tests from January 2012 until December 2014, which was obtained from the Information System of Cervical Cancer (SISCOLO) after a record linkage process. Results: AD-SISCOLO allows the visualization of a set of test-based and follow-up indicators from different views and dimensions, which enable managers to monitor all the phases of the screening process and to identify the process’ failures. During the past 30 years, cervical cancer mortality
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.