Query join ordering optimization with evolutionary multi-agent systems.

Registro completo de metadados
MetadadosDescriçãoIdioma
Autor(es): dc.creatorGonçalves, Frederico Augusto de Cezar Almeida-
Autor(es): dc.creatorGuimarães, Frederico Gadelha-
Autor(es): dc.creatorSouza, Marcone Jamilson Freitas-
Data de aceite: dc.date.accessioned2019-11-06T13:32:04Z-
Data de disponibilização: dc.date.available2019-11-06T13:32:04Z-
Data de envio: dc.date.issued2015-01-26-
Data de envio: dc.date.issued2015-01-26-
Data de envio: dc.date.issued2014-
Fonte completa do material: dc.identifierhttp://www.repositorio.ufop.br/handle/123456789/4388-
Fonte: dc.identifier.urihttp://educapes.capes.gov.br/handle/capes/557439-
Descrição: dc.descriptionThis work presents an evolutionary multi-agent system applied to the query optimization phase of Relational Database Management Systems (RDBMS) in a non-distributed environment. The query optimization phase deals with a known problem called query join ordering, which has a direct impact on the performance of such systems. The proposed optimizer was programmed in the optimization core of the H2 Database Engine. The experimental section was designed according to a factorial design of fixed effects and the analysis based on the Permutations Test for an Analysis of Variance Design. The evaluation methodology is based on synthetic benchmarks and the tests are divided into three different experiments: calibration of the algorithm, validation with an exhaustive method and a general comparison with different database systems, namely Apache Derby, HSQLDB and PostgreSQL. The results show that the proposed evolutionary multi-agent system was able to generate solutions associated with lower cost plans and faster execution times in the majority of the cases.-
Idioma: dc.languageen-
Direitos: dc.rightsO Periódico Expert Systems with Applications concede permissão para depósito do artigo no Repositório Institucional da UFOP. Número da licença: 3553111246763.-
Palavras-chave: dc.subjectJoin ordering problem-
Palavras-chave: dc.subjectQuery optimization-
Palavras-chave: dc.subjectMulti-agent system-
Palavras-chave: dc.subjectEvolutionary algorithm-
Palavras-chave: dc.subjectHeuristics-
Título: dc.titleQuery join ordering optimization with evolutionary multi-agent systems.-
Aparece nas coleções:Repositório Institucional - UFOP

Não existem arquivos associados a este item.