Logo do repositório
 
Publicação

Scalability and Performance Evaluation of NewSQL and Relational Databases: A Comparative Benchmark Study

2023Texto Acesso restrito
Ver registo simples
datacite.subject.fosEngenharia e Tecnologia::Engenharia Eletrotécnica, Eletrónica e Informática
datacite.subject.sdg09:Indústria, Inovação e Infraestruturas
dc.contributor.authorNascimento, Bruno
dc.contributor.authorSantos, Rui
dc.contributor.authorAbbasi, Maryam
dc.contributor.authorMartins, Pedro
dc.contributor.authorSilva, José
dc.contributor.authorANTUNES VAZ, PAULO JOAQUIM
dc.date.accessioned2026-03-04T15:37:16Z
dc.date.available2026-03-04T15:37:16Z
dc.date.issued2023
dc.description.abstractThe purpose of this article is to test and compare the scalability and performance of NewSQL databases (CockroachDB and SingleStoreDB) versus standard relational databases (MySQL and PostgreSQL). The dataset chosen for this benchmark was an TPC-H generated database, making it a suitable dataset for testing database scalability and efficiency in handling complex queries and big amounts of data. To execute the benchmarking, we will construct assessment criteria based on 3 main categories: Process, Performance and Strategy. In this way, it will be possible to evaluate the behavior of each solution, in different contexts and how they use the respective functionalities to obtain the best result. A Benchmarking tool is essential for obtaining sustainable, reliable, and communityaccepted indicators, as it uses standard metrics to assess and classify behavior and performance. Based on these paradigms and the mechanism used for data generation, the benchmark tool chosen for this paper is the TPC-H Benchmark, which explores the data organization and complexity. The results of this benchmarking will give significant insights into the strengths and drawbacks of NewSQL and RDBMS databases, as well as whether the database is better suited for certain use cases. Furthermore, using a dataset like TPC-H will deliver more accurate and useful results, allowing developers and database administrators to make more educated database selection selections. Another point to check is the behavior of technologies in the face of a large volume of data, which is something natural and increasingly common nowadays.por
dc.identifier.citationNascimento, B., Santos, R., Abbasi, M., Martins, P., Silva, J., & Vaz, P. (2023). Scalability and Performance Evaluation of NewSQL and Relational Databases: A Comparative Benchmark Study. 2023 Second International Conference On Smart Technologies For Smart Nation (SmartTechCon), Singapore, 2023, 908–913. https://doi.org/10.1109/SmartTechCon57526.2023.10391567
dc.identifier.doi10.1109/SmartTechCon57526.2023.10391567
dc.identifier.isbn979-8-3503-0541-8
dc.identifier.urihttp://hdl.handle.net/10400.19/9724
dc.language.isoeng
dc.peerreviewedyes
dc.relationCentre for Research in Digital Services
dc.relation.hasversionhttps://ieeexplore.ieee.org/document/10391567/
dc.rights.urihttp://creativecommons.org/licenses/by/4.0/
dc.subjectNewSQL
dc.subjectBenchmark
dc.subjectRMDBS
dc.subjectscalability
dc.subjectperformance
dc.titleScalability and Performance Evaluation of NewSQL and Relational Databases: A Comparative Benchmark Studypor
dc.typetext
dspace.entity.typePublication
oaire.awardNumberUIDB/05583/2020
oaire.awardTitleCentre for Research in Digital Services
oaire.awardURIinfo:eu-repo/grantAgreement/FCT/6817 - DCRRNI ID/UIDB%2F05583%2F2020/PT
oaire.citation.endPage913
oaire.citation.startPage908
oaire.citation.titleIEEE
oaire.fundingStream6817 - DCRRNI ID
oaire.versionhttp://purl.org/coar/version/c_970fb48d4fbd8a85
person.familyNameSilva
person.familyNameANTUNES VAZ
person.givenNameJosé
person.givenNamePAULO JOAQUIM
person.identifier.ciencia-id4A14-D3E7-5B32
person.identifier.ciencia-id351C-9899-0EE7
person.identifier.orcid0000-0001-7285-8282
person.identifier.orcid0000-0002-1745-8937
person.identifier.scopus-author-id55447844100
project.funder.identifierhttp://doi.org/10.13039/501100001871
project.funder.nameFundação para a Ciência e a Tecnologia
relation.isAuthorOfPublicatione9d8719e-af47-4008-b854-817801bb3964
relation.isAuthorOfPublication702e79ee-5b0b-47ff-989d-12e6d8ea1e89
relation.isAuthorOfPublication.latestForDiscoverye9d8719e-af47-4008-b854-817801bb3964
relation.isProjectOfPublicationa2335235-05b4-404c-a71e-cc37ae7fbf2c
relation.isProjectOfPublication.latestForDiscoverya2335235-05b4-404c-a71e-cc37ae7fbf2c

Ficheiros

Principais
A mostrar 1 - 1 de 1
Miniatura indisponível
Nome:
Scalability and Performance Evaluation of NewSQL and Relational Databases.pdf
Tamanho:
947.79 KB
Formato:
Adobe Portable Document Format
Ver/Abrir
Licença
A mostrar 1 - 1 de 1
Miniatura indisponível
Nome:
license.txt
Tamanho:
1.79 KB
Formato:
Item-specific license agreed upon to submission
Descrição:
Ver/Abrir

Coleções

ESTGV - DEMGI - Documentos de congressos (comunicações, posters, actas)
ESTGV - DI - Documentos de congressos (comunicações, posters, actas)