Comparação de Serviços de Banco de Dados em Nuvem com RSSF: Amazon RDS e Google Cloud SQL
Resumo
A computação em nuvem trouxe a possibilidade de ter recursos computacionais como um serviço, diferentemente do que estamos acostumados, onde eles são fornecidos como um produto. Um dos serviços oferecidos pelos provedores de nuvem é a gestão de banco de dados relacional, que é um componente indispensável na maioria dos sistemas computacionais hoje em dia. Como existem vários provedores que oferecem o mesmo serviço, surge a necessidade de uma comparação entre eles, a fim de mostrar qual plataforma é viável de acordo com a necessidade da aplicação. Este artigo detalha dois serviços de banco de dados relacional em nuvem, Amazon RDS e Google Cloud SQL, mostrando como eles funcionam, quais são suas limitações e como o custo de ambos é calculado. Com a compreensão desses dois serviços, é feita uma comparação entre eles de acordo com métricas pré-definidas. O serviço Amazon RDS teve um melhor desempenho no tempo de execução das instruções em comparação ao serviço Google Cloud SQL. Empresas que precisam escolher o melhor serviço de banco de dados relacional podem usar esta pesquisa como um indicador.
Palavras-chave:
computação em nuvem, base de dados, Redes sensores sem fio, Amazon RDS, Google Cloud SQL
Referências
S. Okdem and H. Shi, "Improving IoT and WSN Communication Throughput Using Evolutionary Optimization,"2024 6th International Conference on Computer Communication and the Internet (ICCCI), Tokyo, Japan, 2024, pp. 169-174.
A. Gupta and T. Kumar Dubey, "Performance Analysis of Clustering Protocols for WSN Assisted IoT Network," 2023 14th International Conference on Computing Communication and Networking Technologies (ICCCNT), Delhi, India, 2023, pp. 1-7
B. Wibowo, A. Haq and M. T. A. A. Zein, "A Comparative Study of Load Balancing Methods in Cloud-Based Village Information Systems,"2023 IEEE 7th International Conference on Information Technology, Information Systems and Electrical Engineering (ICITISEE), Purwokerto, Indonesia, 2023, pp. 285-289.
P. J. Assudaniet al., "Testing Resiliency of AWS Services Using the Concept of Chaos Engineering," 2024 5th International Conference on Intelligent Communication Technologies and Virtual Mobile Networks (ICICV), Tirunelveli, India, 2024, pp. 352-356, DOI: 10.1109/ICICV62344.2024.00061.
S. C. Muppalla, S. Rana and J. Chawla, "Cloud-Powered Blood Bank Management-Leveraging AWS Services for Efficiency and Scalability,"2023 3rd International Conference on Smart Generation Computing, Communication and Networking (SMART GENCON), Bangalore, India, 2023, pp. 1-6.
A. Rajput, P. Gupta, P. Ghodeshwar, S. Varma, K. K. Sharma and U. Singh, "Study of Cloud Providers (Azure, Amazon, and Oracle) According To Service Availability and Price,"2023 3rd International Conference on Pervasive Computing and Social Networking (ICPCSN), Salem, India, 2023, pp. 1177-1188 .
A. Choudhary, P. K. Verma and P. Rai, "Comparative Study of Various Cloud Service Providers: A Review,"2022 International Conference on Power, Energy, Control and Transmission Systems (ICPECTS), Chennai, India, 2022, pp. 1-8, DOI: 10.1109/ICPECTS56089.2022.10047594.
B. Wibowo, A. Haq and M. T. A. A. Zein, "A Comparative Study of Load Balancing Methods in Cloud-Based Village Information Systems,"2023 IEEE 7th International Conference on Information Technology, Information Systems and Electrical Engineering (ICITISEE), Purwokerto, Indonesia, 2023, pp. 285-289.
S. C. Muppalla, S. Rana and J. Chawla, "Cloud-Powered Blood Bank Management-Leveraging AWS Services for Efficiency and Scalability,"2023 3rd International Conference on Smart Generation Computing, Communication and Networking (SMART GENCON), Bangalore, India, 2023,
Z. Li, L. O’Brien, H. Zhang, and R. Cai, “On a Catalogue of Metrics for Evaluating Commercial Cloud Services,” in 2012 ACM/IEEE 13th International Conference on Grid Computing, 2012, pp. 164–173.
N. A. de Santana, F. A. A. Lins, and E. T. G. de Sousa, “Performance Evaluation of Mobile Applications in Mobile Cloud Environments,” IEEE Lat. Am. Trans., vol. 14, no. 11, pp. 4597–4602, Nov. 2016.
G. C. Silva, L. M. Rose, and R. Calinescu, “A Systematic Review of Cloud Lock-In Solutions,” in 2013 IEEE 5th International Conference on Cloud Computing Technology and Science, 2013, vol. 2, pp. 363–368.
Abiodun, Moses Kazeem. "A Comparative Study of Cloud Databases: Analyzing Microsoft Azure, IBM db2, and Oracle Cloud." Privacy Preservation and Secured Data Storage in Cloud Computing. IGI Global, 2023. 42-65
D. Almeida et al., "Performance Comparison of Redis, Memcached, MySQL, and PostgreSQL: A Study on Key-Value and Relational Databases," 2023 Second International Conference On Smart Technologies For Smart Nation (SmartTechCon), Singapore, Singapore, 2023, pp. 902-907
N. Prasetio, D. Ferdinand, B. C. Wijaya, M. S. Anggreainy and A. Kumiawan, "Performance Analysis of Distributed Database System in Cloud Computing Environment," 2023 IEEE 9th International Conference on Computing, Engineering and Design (ICCED), Kuala Lumpur, Malaysia, 2023,
S. Verma, S. Kaur and A. D. Gupta, "A Brief Survey on Simulators for Designing Routing Protocol for Wireless Sensor Network,"2023 14th International Conference on Computing Communication and Networking Technologies (ICCCNT), Delhi, India, 2023.
S. Verma, S. Kaur and A. D. Gupta, "A Brief Survey on Simulators for Designing Routing Protocol for Wireless Sensor Network," 2023 14th International Conference on Computing Communication and Networking Technologies (ICCCNT), Delhi, India, 2023, pp. 1-6.
A. Gupta and T. Kumar Dubey, "Performance Analysis of Clustering Protocols for WSN Assisted IoT Network," 2023 14th International Conference on Computing Communication and Networking Technologies (ICCCNT), Delhi, India, 2023, pp. 1-7
B. Wibowo, A. Haq and M. T. A. A. Zein, "A Comparative Study of Load Balancing Methods in Cloud-Based Village Information Systems,"2023 IEEE 7th International Conference on Information Technology, Information Systems and Electrical Engineering (ICITISEE), Purwokerto, Indonesia, 2023, pp. 285-289.
P. J. Assudaniet al., "Testing Resiliency of AWS Services Using the Concept of Chaos Engineering," 2024 5th International Conference on Intelligent Communication Technologies and Virtual Mobile Networks (ICICV), Tirunelveli, India, 2024, pp. 352-356, DOI: 10.1109/ICICV62344.2024.00061.
S. C. Muppalla, S. Rana and J. Chawla, "Cloud-Powered Blood Bank Management-Leveraging AWS Services for Efficiency and Scalability,"2023 3rd International Conference on Smart Generation Computing, Communication and Networking (SMART GENCON), Bangalore, India, 2023, pp. 1-6.
A. Rajput, P. Gupta, P. Ghodeshwar, S. Varma, K. K. Sharma and U. Singh, "Study of Cloud Providers (Azure, Amazon, and Oracle) According To Service Availability and Price,"2023 3rd International Conference on Pervasive Computing and Social Networking (ICPCSN), Salem, India, 2023, pp. 1177-1188 .
A. Choudhary, P. K. Verma and P. Rai, "Comparative Study of Various Cloud Service Providers: A Review,"2022 International Conference on Power, Energy, Control and Transmission Systems (ICPECTS), Chennai, India, 2022, pp. 1-8, DOI: 10.1109/ICPECTS56089.2022.10047594.
B. Wibowo, A. Haq and M. T. A. A. Zein, "A Comparative Study of Load Balancing Methods in Cloud-Based Village Information Systems,"2023 IEEE 7th International Conference on Information Technology, Information Systems and Electrical Engineering (ICITISEE), Purwokerto, Indonesia, 2023, pp. 285-289.
S. C. Muppalla, S. Rana and J. Chawla, "Cloud-Powered Blood Bank Management-Leveraging AWS Services for Efficiency and Scalability,"2023 3rd International Conference on Smart Generation Computing, Communication and Networking (SMART GENCON), Bangalore, India, 2023,
Z. Li, L. O’Brien, H. Zhang, and R. Cai, “On a Catalogue of Metrics for Evaluating Commercial Cloud Services,” in 2012 ACM/IEEE 13th International Conference on Grid Computing, 2012, pp. 164–173.
N. A. de Santana, F. A. A. Lins, and E. T. G. de Sousa, “Performance Evaluation of Mobile Applications in Mobile Cloud Environments,” IEEE Lat. Am. Trans., vol. 14, no. 11, pp. 4597–4602, Nov. 2016.
G. C. Silva, L. M. Rose, and R. Calinescu, “A Systematic Review of Cloud Lock-In Solutions,” in 2013 IEEE 5th International Conference on Cloud Computing Technology and Science, 2013, vol. 2, pp. 363–368.
Abiodun, Moses Kazeem. "A Comparative Study of Cloud Databases: Analyzing Microsoft Azure, IBM db2, and Oracle Cloud." Privacy Preservation and Secured Data Storage in Cloud Computing. IGI Global, 2023. 42-65
D. Almeida et al., "Performance Comparison of Redis, Memcached, MySQL, and PostgreSQL: A Study on Key-Value and Relational Databases," 2023 Second International Conference On Smart Technologies For Smart Nation (SmartTechCon), Singapore, Singapore, 2023, pp. 902-907
N. Prasetio, D. Ferdinand, B. C. Wijaya, M. S. Anggreainy and A. Kumiawan, "Performance Analysis of Distributed Database System in Cloud Computing Environment," 2023 IEEE 9th International Conference on Computing, Engineering and Design (ICCED), Kuala Lumpur, Malaysia, 2023,
S. Verma, S. Kaur and A. D. Gupta, "A Brief Survey on Simulators for Designing Routing Protocol for Wireless Sensor Network,"2023 14th International Conference on Computing Communication and Networking Technologies (ICCCNT), Delhi, India, 2023.
S. Verma, S. Kaur and A. D. Gupta, "A Brief Survey on Simulators for Designing Routing Protocol for Wireless Sensor Network," 2023 14th International Conference on Computing Communication and Networking Technologies (ICCCNT), Delhi, India, 2023, pp. 1-6.
Publicado
27/11/2024
Como Citar
ISMAEL, Marcelo Alexandre da Cruz ; DE CAMARGO, Edson Tavares ; GALANTE, Guilherme ; SILVA, César Alberto da; ALVES, Fabrício Fernando; DE BONA, Luis Carlos Erpen.
Comparação de Serviços de Banco de Dados em Nuvem com RSSF: Amazon RDS e Google Cloud SQL. In: CONGRESSO LATINO-AMERICANO DE SOFTWARE LIVRE E TECNOLOGIAS ABERTAS (LATINOWARE), 21. , 2024, Foz do Iguaçu/PR.
Anais [...].
Porto Alegre: Sociedade Brasileira de Computação,
2024
.
p. 130-136.
DOI: https://doi.org/10.5753/latinoware.2024.245720.
