Comparative Analysis of performance for SQL and NoSQL Databases

被引:0
作者
Diaz Erazo, Amparo Daniela [1 ]
Morales Morales, Mario Raul [1 ]
Pineda Chavez, Veronica Karina [1 ]
Morales Cardoso, Santiago Leonardo [1 ]
机构
[1] Univ Cent Ecuador, Fac Ingn & Ciencias Aplicadas, Quito, Ecuador
来源
2022 17TH IBERIAN CONFERENCE ON INFORMATION SYSTEMS AND TECHNOLOGIES (CISTI) | 2022年
关键词
Database; SQL; NoSQL; Performance; Benchmarking; Resources; YCSB; TPC-C; HammerrDB; YCSB-Client;
D O I
暂无
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
Databases are a fundamental part of the systems of organizations, companies or enterprises, therefore, the importance of a suitable selection of the database manager to use implies the correct functioning of the system and a factor of business success. This work is focused on measuring the performance between SQL and NoSQL databases by executing several tests defined in different scenarios, which differ in the number of clients and the number of transactions that will increase in each scenario and also the definition of benchmarks for hardware such as CPU usage, disk I / O, memory and software such as, response time, number of operations successfully executed; which will allow a comparative analysis between SQL and NoSQL databases or what is known as database benchmarking, obtaining a clearer view of the behavior and consumption of resources of each database manager.
引用
收藏
页数:14
相关论文
共 55 条
  • [51] The PostgreSQL Global Development Group, 2020, POSTGRESQL DOC 12 WH
  • [52] Tozun P., 2013, 16 INT C, DOI [10.1145/2452376.2452380, DOI 10.1145/2452376.2452380]
  • [53] TPC, 2020, TPC BENCHM OV ACT TP
  • [54] Vivanco K.G., 2019, THESIS
  • [55] Zhang P., 2017, PRACTICAL GUIDE ORAC