View Selection for Query-Evaluation Efficiency using Materialized Views

Materialized View;Query Optimization

Gupta, Shalu ; Dr. Jaewoo Kang, Committee Member,Dr. Munindar P Singh, Committee Member,Dr. Rada Y Chirkova, Committee Chair,Gupta, Shalu ; Dr. Jaewoo Kang ; Committee Member ; Dr. Munindar P Singh ; Committee Member ; Dr. Rada Y Chirkova ; Committee Chair

University:North Carolina State University

关键词: Materialized View;    Query Optimization;   

Others  :  https://repository.lib.ncsu.edu/bitstream/handle/1840.16/2286/etd.pdf?sequence=1&isAllowed=y

美国|英语

来源: null

【 摘 要 】

The purpose of this research is to show the use of derived data such as materialized views for run time optimization of aggregate queries. In this thesis, we show the trade off between the time taken to design the views Vs the query run time. We have designed a system called Query Performance Enhancement by Tuning (QPET) which implements the idea of designing and using materialized views to answer frequent aggregate queries.