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 条
  • [1] Abreu J., 2012, DAENA INT J GOOD CON, V7, P187
  • [2] Towards a Visualization-Driven Approach to Database Benchmarking Analysis
    Aggarwal, Dippy
    Shekhar, Shreyas
    [J]. 2019 IEEE 20TH INTERNATIONAL CONFERENCE ON INFORMATION REUSE AND INTEGRATION FOR DATA SCIENCE (IRI 2019), 2019, : 229 - 236
  • [3] NoWog: A Workload Generator for Database Performance Benchmarking
    Ameri, Parinaz
    Schlitter, Nico
    Meyer, Joerg
    Streit, Achim
    [J]. 2016 IEEE 14TH INTL CONF ON DEPENDABLE, AUTONOMIC AND SECURE COMPUTING, 14TH INTL CONF ON PERVASIVE INTELLIGENCE AND COMPUTING, 2ND INTL CONF ON BIG DATA INTELLIGENCE AND COMPUTING AND CYBER SCIENCE AND TECHNOLOGY CONGRESS (DASC/PICOM/DATACOM/CYBERSC, 2016, : 666 - 673
  • [4] AVAC, 2020, HIV PREVENTION RES D
  • [5] Benchmarking big data systems: A survey
    Bajaber, Fuad
    Sakr, Sherif
    Batarfi, Omar
    Altalhi, Abdulrahman
    Barnawi, Ahmed
    [J]. COMPUTER COMMUNICATIONS, 2020, 149 : 241 - 251
  • [6] Barzu C., 2017, THESIS U POLITECNICA
  • [7] Boza E.F., 2015, REV TECNOLOGICA ESPO, P333
  • [8] Comparison of query performance in relational a non-relation databases
    Ceresnak, Roman
    Kvet, Michal
    [J]. 13TH INTERNATIONAL SCIENTIFIC CONFERENCE ON SUSTAINABLE, MODERN AND SAFE TRANSPORT (TRANSCOM 2019), 2019, 40 : 170 - 177
  • [9] BASE analysis of NoSQL database
    Chandra, Deka Ganesh
    [J]. FUTURE GENERATION COMPUTER SYSTEMS-THE INTERNATIONAL JOURNAL OF ESCIENCE, 2015, 52 : 13 - 21
  • [10] TPC-E vs. TPC-C: Characterizing the New TPC-E Benchmark via an I/O Comparison Study
    Chen, Shimin
    Ailamaki, Anastasia
    Athanassoulis, Manos
    Gibbons, Phillip B.
    Johnson, Ryan
    Pandis, Ippokratis
    Stoica, Radu
    [J]. SIGMOD RECORD, 2010, 39 (03) : 5 - 10