A framework for database optimization and workload control

Nowadays, database optimizers take advantage of indexes and materialized views (MVs) to produce query execution plans. While indexes and MVs can speed up the execution of queries, there are costs to store and manage them. This paper presents a mathematical model and a greedy implementation to recomm...

Full description

Bibliographic Details
Main Authors: ALVES JR., A. C., SCARABELIN, F. D., DIGIAMPIETRI, L. A.
Format: Article
Language:English
Published: Faculdade Salesiana Maria Auxiliadora 2010-06-01
Series:Sistemas de Informação
Subjects:
Online Access:http://www.fsma.edu.br/si/edicao5/FSMA_SI_2010_1_Estudantil_2.pdf