Estudo de tecnologias para melhorar a performance na busca de dados

• Autor(a) principal: Boeing, Eduardo Nienkotter
• Data de Publicação: 2018
• Outros Autores: Boeing, Ricardo Nienkotter
• Tipo de documento: Artigo de conferência
• Idioma: por
• Título da fonte: Repositório Universitário da Ânima (RUNA)
• Texto Completo: https://repositorio.animaeducacao.com.br/handle/ANIMA/11097
• topic: PostgreSQL; Performance; Particionamento; Base de dados colunares

Companies that does not have expirience in development area or have the need of generate resources quickly, skip an important part of the project, the planning, and with that, sometimes the best tools are no chosen to fit the software needs. In this study scenario we analyze the database. In the beginning of the development of the application there was no problems with performance in queries because the quantity of data and accesses was small, but, with time, this scenario changed and the first problems with performance appears. In this study the authors applied two alternatives to solve the query problems in a table of database postgreSQL. The first solution was the partition and the second was the application of a extension for column oriented database. After Analise benchmarks of the current scenario and the others solutions proposed by the authors, it was concluded that the partition had no significant gains, but the column oriented database solution manage to reduce the query time approximately by half for the main queries of the system.