Assessment of SQL and NoSQL Systems to Store and Mine COVID-19 Data

被引:4
作者
Antas, Joao [1 ]
Rocha Silva, Rodrigo [2 ,3 ]
Bernardino, Jorge [1 ,2 ]
机构
[1] Coimbra Inst Engn ISEC, Polytech Coimbra, P-3030199 Coimbra, Portugal
[2] Ctr Informat & Syst Univ Coimbra CISUC, P-3030290 Coimbra, Portugal
[3] Sao Paulo Technol Coll, FATEC Mogi Cruzes, BR-08773600 Mogi Das Cruzes, SP, Brazil
关键词
big data; COVID-19; Data Mining; SQL and NoSQL databases;
D O I
10.3390/computers11020029
中图分类号
TP39 [计算机的应用];
学科分类号
081203 ; 0835 ;
摘要
COVID-19 has provoked enormous negative impacts on human lives and the world economy. In order to help in the fight against this pandemic, this study evaluates different databases' systems and selects the most suitable for storing, handling, and mining COVID-19 data. We evaluate different SQL and NoSQL database systems using the following metrics: query runtime, memory used, CPU used, and storage size. The databases systems assessed were Microsoft SQL Server, MongoDB, and Cassandra. We also evaluate Data Mining algorithms, including Decision Trees, Random Forest, Naive Bayes, and Logistic Regression using Orange Data Mining software data classification tests. Classification tests were performed using cross-validation in a table with about 3 M records, including COVID-19 exams with patients' symptoms. The Random Forest algorithm has obtained the best average accuracy, recall, precision, and F1 Score in the COVID-19 predictive model performed in the mining stage. In performance evaluation, MongoDB has presented the best results for almost all tests with a large data volume.
引用
收藏
页数:23
相关论文
共 33 条
  • [31] Sperandei S, 2014, BIOCHEM MEDICA, V24, P12, DOI 10.11613/BM.2014.003
  • [32] Thange U., 2021, P 2 INT C COMP AUT K, P198
  • [33] World Health Organization, 2021, 'Information note on maritime labour issues and coronavirus (COVID-19), Including the General Obser- vation of the Committee of Experts on the Application of Conventions and recommendations and joint statements of the Officers of the Spe- cial Tripartite Committee of the Maritime Labour Convention, 2006, as amended'