AUTOMATIC CREATION OF MATERIALIZED VIEWS IN RELATIONAL DBMS / CRIAÇÃO AUTOMÁTICA DE VISÕES MATERIALIZADAS EM SGBDS RELACIONAIS
AUTOR(ES)
ANDRÉA WEBERLING CARVALHO
FONTE
IBICT - Instituto Brasileiro de Informação em Ciência e Tecnologia
DATA DE PUBLICAÇÃO
29/04/2011
RESUMO
As database applications become more complex, tuning database systems in order to improve query response times also become harder. One could consider materialized views, a relational database object that stores data resulting from specific queries, to obtain better performances. This dissertation proposes the automatic creation of materialized views. A non-intrusive architecture is used in order to keep DBMS source codes unchanged. There is a need to estimate the creation cost and the benefits obtained from the presence of the materialized views. Heuristics are proposed to help with the automatic decision upon creation of these materialized views for a given workload. Simulation tests for TPC-H benchmark and MS SQL Server DBMS are presented.
ASSUNTO(S)
auto-sintonia self-tuning visoes views
