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
![Creative Commons License](http://i.creativecommons.org/l/by-nd/4.0/88x31.png)
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)
- 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
- Alessandro Marques Martins, Érica Pantoja de Araújo, Frank Henrique Santos Fontineles, Sara dos Santos Santarém, David Barbosa de Alencar, Gisele de Freitas Lopes, The Socioeconomic Impact of Paralyzed Public Works: Analysis on the University City of the State of Amazonas , 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
- Geilson Pires Ferreira, Giselane Campos Espadim, Fabiana Rocha Pinto, David Barbosa de Alencar, Gisele de Freitas Lopes, The Importance of (ECI / EIA) applied to substations and the 500kv Transmission Line Manaus – Boa Vista and the Socio-Environmental Changes of the Waimiri Atroari Indigenous Lands , International Journal for Innovation Education and Research: Vol. 7 No. 11 (2019): International Journal for Innovation Education and Research
- Jean Barros Félix, David Barbosa de Alencar, Alexandra Priscilla Tregue Costa, Antônio Estanislau Sanches, Process Optimization on Rear Bumper Assembly in a PIM Two Wheels Poly Company , International Journal for Innovation Education and Research: Vol. 7 No. 9 (2019): International Journal for Innovation Education and Research
- Adilson Alves Góes, Fabiana Rocha Pinto, David Barbosa de Alencar, Gisele de Freitas Lopes, Proposal of LPS Implementation in Popular Buildings in Manaus City , International Journal for Innovation Education and Research: Vol. 7 No. 11 (2019): International Journal for Innovation Education and Research
- Brena Karine Pires Gaspar, Fabiana Rocha Pinto, David Barbosa de Alencar, Gisele de Freitas Lopes, Degrees of Risk of Environmental Impacts Arising from Irregular Occupations in the Northern Zone of Manaus - Amazonas , International Journal for Innovation Education and Research: Vol. 7 No. 11 (2019): International Journal for Innovation Education and Research
- Evilly Cardoso Gomes, Mikelly Pinheiro Garcia, Igor Bezerra de Lima, David Barbosa de Alencar, Antônio Estanislau Sanches, Technological Control Assessment and Concrete Receiving , International Journal for Innovation Education and Research: Vol. 7 No. 11 (2019): International Journal for Innovation Education and Research
- Jorge Fernando Rodrigues Valente, Giliane Corrêa Pereira, David Barbosa de Alencar, Carlos Alberto Oliveira de Freitas, Antônio Estanislau Sanches, CAD / CAM Application for the Development of Submerged Pump Maintenance Tools , International Journal for Innovation Education and Research: Vol. 7 No. 11 (2019): International Journal for Innovation Education and Research
- Ruan Mattheus Ferreira Braga, Fabiana Rocha Pinto, David Barbosa de Alencar, Gisele de Freitas Lopes, Low Cost Process Modeling for a Manaus Industrial Polo factory , International Journal for Innovation Education and Research: Vol. 7 No. 11 (2019): International Journal for Innovation Education and Research