The application of data mining by classification in a database of notified covid-19 cases in Manaus-AM
DOI:
https://doi.org/10.31686/ijier.vol9.iss4.3060Keywords:
COVID-19, MySql, KDD, Weka, Workbench, Data MiningAbstract
This scientific article aims to present information on the cases of comorbidity that most aggravate the symptoms of SARS-CoV-2 (Covid 19) with data extracted from the database of the official website of the Ministry of Health, which defined a system to monitor the information detected in the diagnoses of each patient. Since the beginning of the pandemic, the city of Manaus has suffered great consequences in relation to the SARS-CoV-2 virus (Covid-19). predicting patients at higher risk of death. We describe the origin and spread of the virus and the use of the SGBD software MySql and MySql Workbench to improve data in the selection and pre-processing, with the resources of the weka tool for knowledge learning, ending with the objective achieved in the classification of comorbidities that further aggravate the clinical conditions.
Downloads
References
FAYYAD, U; PIATETSKY-SHAPIRO, G; SMYTH, P. From Data Mining to Knowledge Discovery in Databases. American Association for Artificial Intelligence, 1996. DOI: https://doi.org/10.1007/3-540-61286-6_131
CAMILO, C.; SILVA, J. Mineração de Dados: Conceitos, tarefas, métodos e ferramentas. Universidade Federal de Goiás (UFC), p. 29, 2009. ISSN 16113349.
OLIVEIRA, R. R; CARVALHO, C. L. Algoritmos de agrupamento e suas aplicações. Technical report, Universidade Federal de Goiás, 2008.
FREITAS, A. A; LAVINGTON, S. H. Mining Very Large Databases with Parallel Processing. The Kluwer international series on advances in database systems. Kluwer Academic Publishers, Boston, 1998.
LUKE WELLING, LAURA THOMSON. Tutorial Mysql. Ciência Moderna, 2004
Lambert M. Surhone, Miriam T. Timpledon, Susan F. Marseken. MySQL Workbench. Betascript Publishing, 2010
H. Witten, E. Frank, M. A. Hall. Data Mining: Practical Machine Learning Tools and Techniques. 3rd Edition, Morgan Kaufmann, 2011. DOI: https://doi.org/10.1016/B978-0-12-374856-0.00001-8
R. Santos. “Weka na Munheca: um Guia para Uso do Weka em Scripts e Integração com Aplicações Java”. Instituto Nacional de Pesquisas Espaciais (INPE), 2005.
AGRAWAL, R. & SRIKANT, R. Fast algorithms for mining association rules. Proc. of the 20th Int’l Conference on Very Large Databases. Santiago, Chile, set. 1994. Disponível na Internet. http://www.almaden.ibm.com/u/ragrawal/pubs.html. 3 junho 1999.
Zanardi, Lucas Adão. Data mining: estudo e aplicação de algoritmos de data mining; orientador: Prof. Dr. Evandro de Araújo Jardini. Fernandópolis, 2007. 100 f.
MINISTÉRIO DA SAÚDE. Coordenação-Geral do Programa Nacional de Imunizações. Disponível em: https://opendatasus.saude.gov.br/dataset/bd-srag-2021 Acesso em: 14 fev. 2021. Autor: Datasus – Brasília: Ministério da Saúde, 2021.
Galvão,Noemi Dreyer ; Marin, Heimar de Fátima. ARTIGO DE REVISÃO.Técnica de mineração de dados: uma revisão da literatura. Acta Paulista de Enfermagem. versão impressa ISSN 0103-2100. Acta paul. enferm. vol.22 no.5 São Paulo set./out. 2009. DOI: https://doi.org/10.1590/S0103-21002009000500014
MENDES, Luciana. TCC Data Mining – Estudo de Técnicas e Aplicações na Área Bancária.São Paulo-2011.
NANGIYALIL, Sajeev G. Estudo de Ferramenta de KDD & Mineração de Dados. In: Trabalho Monográfico. São Paulo. UNICID-SP, 2007.
Tan P, Steinbach M, Kumar V (2009) Introdução ao Data Mining - Mineração de Dados. Editora Ciência Moderna Ltda
Ellram, L (1996) The use of the case study method in logistics research. Journal of Business Logistics. Oakbrook, Ill, v. 17, n. 2.
BORGES, H. B. Redução de dimensionalidade em bases de dados de expressão gênica. 2006. 123 f. Dissertação (Mestrado em Informática) - Pontifícia Universidade Católica do Paraná. Curitiba, 2006.
NASCIMENTO, F. R. S. Um Estudo Comparativo entre Algoritmos de Proteção da Privacidade e Segurança de Dados Aplicado à Bases de Dados na Área de Saúde. 2017. 52 f. Trabalho de Conclusão de Curso (Graduação em Sistema de Informação) - Universidade Federal do Rio Grande do Norte. Caicó – RN. 2017
Downloads
Published
Issue
Section
License
Copyright (c) 2021 Fábio Gomes Cantuário, Luiz Eduardo Santos de Araújo, Rilmar Pereira Gomes, David Barbosa de Alencar
This work is licensed under a Creative Commons Attribution-NoDerivatives 4.0 International License.
Copyrights for articles published in IJIER journals are retained by the authors, with first publication rights granted to the journal. The journal/publisher is not responsible for subsequent uses of the work. It is the author's responsibility to bring an infringement action if so desired by the author for more visit Copyright & License.
How to Cite
Accepted 2021-03-24
Published 2021-04-01
Most read articles by the same author(s)
- Tatiane Gomes Ferreira, Fabiana Rocha Pinto, David Barbosa de Alencar, Manoel Henrique Reis Nascimento, PGRSS Application in a Public Hospital Unit of Manaus and its Sustainability Characteristics , International Journal for Innovation Education and Research: Vol. 7 No. 11 (2019): International Journal for Innovation Education and Research
- Carlos Gilmar França dos Santos, Livia da Silva Oliveira, David Barbosa de Alencar, Francisco Carlos Tavares Amorim, Grounding Measurement Applied to a 13.8 kV Substation in Manaus - Amazonas , International Journal for Innovation Education and Research: Vol. 7 No. 10 (2019): International Journal for Innovation Education and Research
- Fernanda Yakushijin Gomes dos Santos, David Barbosa de Alencar, Alexandra Priscilla Tregue Costa, Marden Eufrasio dos Santos, Air Conditioner Production Failure Analysis Techniques , International Journal for Innovation Education and Research: Vol. 7 No. 10 (2019): International Journal for Innovation Education and Research
- Candy Ace de Oliveira Monteiro, Fabiana Rocha Pinto, David Barbosa de Alencar, Gisele de Freitas Lopes, Applicability Study of ISO 14001: 2015 for Implementation of the Environmental Management System in an Electro-Electronic Industry in PIM , International Journal for Innovation Education and Research: Vol. 7 No. 11 (2019): International Journal for Innovation Education and Research
- Suelânia Cristina Gonzaga de Figueiredo, Luciane Farias Ribas, Rute Holanda Lopes Alves, Elizângela de Jesus Oliveira, David Barbosa de Alencar, Antônio Estanislau Sanches, Articulation between teaching, research and extension , International Journal for Innovation Education and Research: Vol. 10 No. 7 (2022): International Journal for Innovation Education and Research
- Igor da Silva Corocher, Barbara Lopes Felsenthal, Bruno Pereira Gonçalves, Jean Mark Lobo de Oliveira, Rilmar Pereira Gomes, David Barbosa de Alencar, The Relevance of Information Security Policy in the Logical Part of the Company , International Journal for Innovation Education and Research: Vol. 7 No. 11 (2019): International Journal for Innovation Education and Research
- Tatiane Nunes Pereira, Fabiana Rocha Pinto, David Barbosa de Alencar, Gisele de Freitas Lopes, Waste Reuse in a food establishment for the production of organic fertilizer in Manaus - Amazonas , International Journal for Innovation Education and Research: Vol. 7 No. 11 (2019): International Journal for Innovation Education and Research
- Geovani da Silva Monteiro, Luiz André Martins Pereira, David Barbosa de Alencar, Antônio Estanislau Sanches, Carlos Eduardo de Oliveira, Igor Felipe Oliveira Bezerra, Reverse Aftermarket Logistics in E-Commerce a Case Study in a Manaus Microenterprise , International Journal for Innovation Education and Research: Vol. 7 No. 9 (2019): International Journal for Innovation Education and Research
- Déryk Jórdan da Silva Cunha, Fabiana Rocha Pinto, Daria Kessy da Silva Cunha, Gilvania Mendes Cunha, David Barbosa de Alencar, Gisele de Freitas Lopes, Environmental Management of Gabriel Correia Pedrosa Children's School in Manaus - Amazonas, an Application of Environmental Education , International Journal for Innovation Education and Research: Vol. 7 No. 11 (2019): International Journal for Innovation Education and Research
- Diana Barbosa de Castro, Fabiana Rocha Pinto, David Barbosa de Alencar, Ricardo Silva Parente, Adaptation of Leopold Matrix for Assessment of Environmental Impacts Caused by the Flower Avenue Project in Manaus City - Amazonas , International Journal for Innovation Education and Research: Vol. 7 No. 11 (2019): International Journal for Innovation Education and Research