Increasing Firebird Performance: strategies and good practices
DOI:
https://doi.org/10.33448/rsd-v12i5.41328Keywords:
Performance; Firebird; Indexes.Abstract
This article aims to analyze and optimize the performance of Firebird, an open source database management system, applying the case study methodology in varied business contexts to identify effective improvement strategies, such as the proper use of indexes (including compounds), the implementation of cache, conducting fast transactions with planning and monitoring, and the correct use of parameters in the queries. The research highlights the importance of planning in creating indexes and the need for in-depth knowledge of Firebird architecture and appropriate programming techniques. In addition, the analysis also emphasizes the relevance of collaboration between developers and database administrators to ensure optimal performance. By applying the identified strategies, the results demonstrate that with careful planning and precise adjustments, it is possible to improve the performance of Firebird, making it more efficient and faster, thus providing valuable insights for its application in different business scenarios and contributing to informed decision making.
References
Bell, C. (2012). Expert MYSQL. (2nd. Ed.) Berkeley, CA, USA.
CIO. (2023). Open source tools tasmanian newspaper tames open source firebird. [NOTÍCIAS]. https://www.cio.com/article/258547/open-source-tools-tasmanian-newspaper-tames-open-source-firebird.html.
Cantú, C. H. (2004). Firebird, essa é minha escolha, e a sua? SQL Magazine, Edição 15.
PGDOCPTBR. (2014). Documentação do POSTGRESQL 8.0.0: Analyze. HTTPS://PGDOCPTBR.SOURCEFORGE.IO/PG80/SQL-ANALYZE.HTML.
Fernandes, J. M. (2019). Otimização de bancos de dados firebird. Editora Novatec.
FirebirdSQL. (2021).O verdadeiro banco de dados relacional de código aberto. https://firebirdsql.org/. Gestão, Revista Científica De Administração E Sistemas De Informação/Unidade De Ensino Superior. (2008). 11(11).
Heuser, C. A. (2009). Projeto de banco de dados: Volume 4 da Série Livros didáticos informática UFRGS. Editora Bookman.
Krohnmayer, C. (2014). Firebird 2.5: Aumente a Performance do seu Banco de Dados. Editora Novatec.
Lightstone, S. S., Teorey, T. J., & Nadeau, T. (2007). Physical Database Design: The Database Professional’s Guide to Exploiting Indexes, Views, Storage, and More. San Francisco, CA, USA: Morgan Kaufmann Publishers Inc., 2007.
Mascarenhas, H. R. (2007). Firebird: Guia do Programador. Editora Ciência Moderna.
Martin, J. (2019). Gestão de Performance de Sistemas. Editora XYZ.
Mecenas, I. (2006). Firebird. SQL Magazine, 3(37).
Myers, MD (2002). Pesquisa Qualitativa em Sistemas de Informação. MIS Quarterly, 21(2), 241-242.
Petrai, E., Idreos, S., & Manegold, S. (2015). Indexação holística em armazenamentos de coluna da memória principal. Em Proceedings of the 2015 ACM SIGMOD International Conference on Management of Data (SIGMOD '15), 1153-1166.
Pereira, A. S., Shitsuka, D. M., Parreira, F. J., & Shitsuka, R. (2018). Metodologia da pesquisa científica. [E-book gratuito]. Santa Maria/RS: Ed. UAB/NTE/UFSM. https://www.ufsm.br/app/uploads/sites/358/2019/02/Metodologia-da-Pesquisa-Cientifica_final.pdf
Ramakrishnan, R., & Gehrke, J. (2003). Sistemas de Gerenciamento de Banco de Dados. McGraw-Hill. https://books.google.com.br/books?hl=pt-BR&lr=&id=COUJpkH5v38C&oi=fnd&pg=PR7&dq=Ramakrishnan,+R.,+%26+Gehrke,+J.+(2003).+Sistemas+de+Gerenciamento+de+Banco+de+Dados.+McGraw-Hill.&ots=0Y57QiQ3Wz&sig=2zAsRwDz1x0u7FXCgETsHVz78GI#vfalse.
Santos, P. S. M. (2007). Comparando Firebird, MySQL, PostgreSQL e SQLite. Revista SQL, 4(41).
Silva, A. M., et al. (2016). A Importância da Otimização de Performance em Bancos de Dados. In Anais do Congresso Nacional de Tecnologia da Informação e Comunicação (Vol. 8, pp. 1-10). Recife, Brasil. Editora do Congresso.
Sudarshan, S., Silberschatz, A., & Korth, F. H. (1999). Sistemas de Banco de Dados. (3a ed.). Editora Pearson Makron Books
Silberschatz, A., Korth, H. F., & Sudarshan, S. Sistema de Banco de Dados. (3a ed.), Pearson Makron Books, 1999. 778 p.
Tecnospeed (2023).Banco de dados Firebird em aplicativos: como integrar dashboards? https://blog.tecnospeed.com.br/firebird/#Por_que_Firebird_e_o_querido.
Thalheim, B., & Tropmann, M. (2011). Previsão de desempenho para grandes bancos de dados críticos de desempenho. Em Modelagem de Informação e Bases de Conhecimento XXII (pp. 206-225). Imprensa IOS.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2023 Alice Silva de Souza; Caroline Nunes Carr; Deivid Cesar Costa de Oliveira; Felipe Grotto da Silva; Lorena Dalva da Conceição Sousa; Renato Ferreira Carr
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors who publish with this journal agree to the following terms:
1) Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
2) Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
3) Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.
