Open AccessANÁLISE COMPARATIVA DOS ALGORITMOS DE OTIMIZAÇÃO DE CONSULTAS DO POSTGRESQL
Author(s) -
Lucas Bianchi Magalhães,
Francisco Virgínio Maracci,
Aglaê Pereira Zaupa,
Francisco Assis da Silva
Publication year - 2015
Publication title -
colloquium exactarum
Language(s) - English
Resource type - Journals
ISSN - 2178-8332
DOI - 10.5747/ce.2015.v07.n1.e001x
Subject(s) - computer science
The use of databases to keep information turn an\udessential need. The databases management systems are responsible to\udrealize SQL queries that manipulate the information in an easy way.\udThe PostgreSQL have two different algorithm to optimization queries\ud(dynamic programming and genetic algorithm). The amount of tables\udused in a query is what differentiates the algorithm to be used. This\udpaper aim to make a analyze using the algorithms with different\udamount of tables in queries trying to verify in which situation the most\udappropriated algorithm.\ud\ud\u