Processo de otimização de consultas para banco de dados relacional

Abstract

The flow of information has grown increasingly in information systems and this is one of the factors that influence the occurrence of performance bottlenecks when accessing data in the database. Performance bottlenecks are seen by end users of information systems while performing consultations on these systems. Thus, it is not enough that the Management System Database (DBMS) to facilitate access to the data from the database. It is necessary for access to these data is done in an efficient (rapid). Therefore, it is necessary to perform the optimization of these consultations was to obtain a better performance during the execution of the same. Query optimization is the process of selecting an efficient execution plan to perform a given query. Indexing is one of the most widely used techniques for query optimization. When this technique is applied in conjunction with some commands and settings that are applied to the server database, the results are quite satisfactory. This paper proposes through literature, create a Process Query Optimization for Relational Database and, through a case study, run this process for demonstration purposes. Finally, the necessary tests will be carried out with the purpose of proving its efficiency. The MySQL server is used as a database alternative for the execution of the query optimization process. The tests applied to the case study using different amounts of data and demonstrated satisfactory results for both quantities. In the last phase of testing, we obtained the following average percentages of optimization for a selected query: 96.38% optimization for worst case of query execution and 100% for the best case of query execution.