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.
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)
- Adriana Karla de Souza Santana, Elilson Leal de Araújo, Waldeck Matheus de Oliveira Lins Belo, Bruno Pereira Gonçalves, Jean Mark Lobo de Oliveira, Rilmar Pereira Gomes, David Barbosa de Alencar, Hybrid Mobile Prototype for Evapotranspiration Calculation Using Raspberry Pi , International Journal for Innovation Education and Research: Vol. 7 No. 11 (2019): International Journal for Innovation Education and Research
- Vinícius Guilherme Pereira Vasconcelos, David Barbosa de Alencar, Alexandra Priscilla Tregue Costa, Marden Eufrasio dos Santos, Proposal for an Araçá-Boi Fruit Mead Factory in the Amazon Region , International Journal for Innovation Education and Research: Vol. 7 No. 11 (2019): International Journal for Innovation Education and Research
- Willians dos Santos Teixeira, Giselle Cunha do Nascimento, Lívia da Silva Oliveira, David Barbosa de Alencar, Use of RCDs in the Making of Interlocked Pavements with Waste Collected at the Federal Institute of Amazonas – CMC , International Journal for Innovation Education and Research: Vol. 7 No. 10 (2019): International Journal for Innovation Education and Research
- Ronaldo Lopes Gomes, Ricardo Chamy do Nascimento, Caio Victor da Silva Viga, Bruno Pereira Gonçalves, Jean Mark Lobo de Oliveira, Rilmar Pereira Gomes, David Barbosa de Alencar, Introduction of Basic Computer Programming Logic in Elementary and High Schools Using Logic Block , International Journal for Innovation Education and Research: Vol. 7 No. 11 (2019): International Journal for Innovation Education and Research
- Priscilla Leão de Lima, Richardyson Nobrega da Fonseca, Rilmar Pereira Gomes, David Barbosa de Alencar, Use of association rules to perform the mining of a marketing database commercial , International Journal for Innovation Education and Research: Vol. 9 No. 4 (2021): International Journal for Innovation Education and Research
- Nilzemar da Silva Mariano, Livia da Silva Oliveira, David Barbosa de Alencar, Eliton Smith dos Santos, Economic Feasibility Study Generated on Replacing Tubular Fluorescent Lamps with Led Lamps in a Commercial Building , International Journal for Innovation Education and Research: Vol. 7 No. 11 (2019): International Journal for Innovation Education and Research
- Luiza Yanka Trindade Ribeiro, Livia da Silva Oliveira, David Barbosa de Alencar, Ricardo Silva Parente, Economic analysis of an automated lighting system with presence sensor at a state school in the city of Manacapuru-AM , International Journal for Innovation Education and Research: Vol. 7 No. 11 (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
- Raimundo Marinaldo da Silva Lopes, Fabiana Rocha Pinto, David Barbosa de Alencar, Gisele de Freitas Lopes, Diagnosis of the Basic Sanitation of the Prata Lagoon and Maresia Lagoon, Prosai-Maués Project, Located in the Municipality of Maués - Amazonas , International Journal for Innovation Education and Research: Vol. 7 No. 11 (2019): International Journal for Innovation Education and Research
- 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