Oracle Database: An In-Depth Analysis of the DBMS That Dominates the Corporate World

Authors

DOI:

https://doi.org/10.33448/rsd-v12i5.41323

Keywords:

Oracle database; DBMS; Performance.

Abstract

In this article, a thorough analysis of Oracle Database, one of the most widely used database management systems (DBMS) in the corporate world, is performed in order to evaluate its security, performance and adaptability in relation to other systems available in the market. The methodology employed is the narrative bibliographic review, based on secondary sources such as scientific articles, technical reports, and case studies. The text begins with a brief introduction to the DBMS, followed by a discussion of its forms of insertion in the market, such as high availability and support for multiple platforms. The composition explores its core functions and advantages, emphasizing the enterprise innovation that Oracle Database brings to companies that embrace it in their operations. In addition, success stories of companies that have opted for Oracle Database are presented, highlighting its effectiveness in the management of sensitive and complex data. Finally, adoption perspectives are discussed in the corporate environment, for the future of database technology, considering the importance of Oracle Database in a scenario in constant transformation and improvement.

Author Biographies

Eduardo de Vasconcelos Silva, Universidade do Estado do Pará

Student of the Software Engineering Course of the 3rd Period.

Gustavo Casanova Oliveira Lima, Universidade do Estado do Pará

Student of the Software Engineering Course of the 3rd Period.

Renato Ferreira Carr, Universidade do Estado do Pará

Master Professor in the Software Engineering course

Tomas Robyson da Cruz Braga, Universidade do Estado do Pará

Student of the Software Engineering course

References

Araújo, R. (2007). Análise de Vulnerabilidade Em Um Banco de Dados Oracle E Teste de Eficiência Na Correção a Partir de Um Patch.

Biyiklioglu, O. (2018). Oracle Database 12c Release 2 Performance Tuning Tips & Techniques. McGraw-Hill Education.

Bryla, B., & Loney, K. (2009). Oracle Database 11G: Manual do DBA. In Google Books. Bookman. https://books.google.com.br/books?hl=pt-BR&lr=lang_pt&id=e1d_0m9jevEC&oi=fnd&pg=PA9&dq=oracle+database&ots=FU_UgcJEz-&sig=xPGraIDNjGbNh_AaEGNYxfsxa80#v=onepage&q&f=false

Cordeiro, A. M., Oliveira, G. M., Rentería, J. M., & Guimarães, C. A. (2007). Revisão sistemática: uma revisão narrativa. Rev. Col. Bras. Cir, 34(6), 428-431, 2007. https://doi.org/10.1590/S0100-69912007000600012

Elisson, L. (2018). Larry Ellison Introduces Oracle Autonomous Database. www.oracle.com/corporate/pressrelease/oow18-larry-ellison-autonomous-100118.html.

Felipe, C., Dias Neto, J., Regina De Oliveira, J., & Bruschi, G. (2023). Análise de Vulnerabilidade em um Banco de Dados Oracle e Teste de Eficiência na Correção a Partir de um Patch.http://www.fatecbauru.edu.br/assets/upload/revista/9a6b4-211-706-2-pb.pdf

Gonçalves, E. (1998). SQL uma abordagem para banco de dados oracle.

Guimarães, R. F., & Gonçalves, P. (2006). Pleasy: Ferramenta De Apoio Ao Desenvolvedor Para Sgbd Oracle Marília. https://aberto.univem.edu.br/bitstream/handle/11077/433/PLEASY%20-%20Ferramenta%20de%20Apoio%20ao%20Desenvolvedor%20para%20SGBD%20Oracle.pdf?sequence=1

Huang, X., & Zhang, X. (2019). An Empirical Study on the Impact of Database Management Systems on Small and Medium Enterprises' Performance. https://doi.org/10.1016/j.jbusres.2019.04.005

Magalhães, R., Indara, S., Bezerra, C., César, C., Brasil, P., Rejane, E., & Moura, F. (2018). Estudos Qualitativos: Enfoques Teóricos e Técnicas de Coleta de Informações. https://portais.univasf.edu.br/medicina-pa/pesquisa/producao-cientifica/experiencias-qualitativas-ebook

Martins, A., & Lima, E. (2023). Segurança em Banco de Dados: Teste de Quebra de Senha por Força Bruta no Banco de Dados Oracle 11G. http://www.fatecbauru.edu.br/assets/upload/revista/7ae69-207-703-2-pb.pdf

Moreno A., F. J., & Olarte V., J. W. (2013). Índices de Tres Estrellas: un caso de estudio en Oracle y SQL Server. Ingenium Revista De La Facultad De ingeniería, 13(26), 6–17. https://doi.org/10.21500/01247492.1275

Moreno Arboleda, F. J., Quintero Rendón, J. E., & Rueda Vásquez, R. (2016). Una comparación de rendimiento entre Oracle y MongoDB.https://doi.org/10.18359/rcin.1669

Paulinho, R.(2006). Pleasy: Ferramenta De Apoio Ao Desenvolvedor Para Sgbd Oracle. aberto.univem.edu.br/bitstream/handle/11077/433/PLEASY%20-%20Ferramenta%20de%20Apoio%20ao%20Desenvolvedor%20para%20SGBD%20Oracle.pdf?sequence=1&isAllowed=y.

Rometty, G. (2023.). Fortune. https://fortune.com/author/ginni-rometty/

Sobrinho, V., & Galvani, A. (2014). Estudo Comparativo do Oracle Automatic Storage Management em Relação ao Desempenho. http://fatecbauru.edu.br/mtg/source/Estudo%20Comparativo%20do%20Oracle%20Automatic%20Storage%20Management%20em%20Rela%C3%A7%C3%A3o%20ao%20Desempenho.pdf

Takai. Italiano. & Ferreira. (2005). https://cepein.femanet.com.br/BDigital/arqTccs/0511150040.pdf

Watson, J. (2009). OCA Oracle Database 11g: Administração I (Guia do Exame 1Z0-052). In Google Books. Bookman Editora. https://books.google.com.br/books?hl=pt-BR&lr=&id=E-xfMkJr8rwC&oi=fnd&pg=PR7&dq=Oracle+Database+ferramentas+para+monitoramento&ots=7h0eTswiov&sig=u_MG1kxwV8NV8wYhYn9Qo-MnV5M#v=onepage&q=Oracle%20Database%20ferramentas%20para%20monitoramento&f=false

Wieczorek, E., & Leal, E. (2023) Caminhos e Tendências do uso de Banco de Dados em Bioinformática. http://ulbra-to.br/encoinfo/wp-content/uploads/2020/03/Bioinformatica-1.pdf

Yamagami, C., & Nadella, S. (2017). Aperte o F5. Saraiva Educação S.A.

Zorzi, M. (2023). Universidade De Caxias Do Sul Centro De Ciências Exatas E Tecnologia Curso De Sistemas De Informação Tuning De Sistema Operacional Em Banco De Dados Oracle.https://repositorio.ucs.br/xmlui/bitstream/handle/11338/1210/TCC%20Marcelo%20Tomiello%20Zorzi.pdf?sequence=1&isAllowed=y

Published

23/04/2023

How to Cite

CARR, C. N.; SILVA, E. de V. .; LIMA, G. C. O. .; CARR, R. F. .; BRAGA, T. R. da C. . Oracle Database: An In-Depth Analysis of the DBMS That Dominates the Corporate World. Research, Society and Development, [S. l.], v. 12, n. 5, p. e0812541323, 2023. DOI: 10.33448/rsd-v12i5.41323. Disponível em: https://rsdjournal.org/index.php/rsd/article/view/41323. Acesso em: 27 apr. 2024.

Issue

Section

Exact and Earth Sciences