Materialized view tuning mechanism and usability enhancement

Authors:
Tsae-Feng Yu;Thomas Tong;Min Xiao;Jack Raitto
Affiliations:
Oracle Corporation, Nashua, NH;Oracle Corporation, Nashua, NH;Oracle Corporation, Nashua, NH;Oracle Corporation, Nashua, NH
Venue:
ICDCIT'06 Proceedings of the Third international conference on Distributed Computing and Internet Technology
Year:
2006

Citing 3
Cited 0

Database tuning advisor for microsoft SQL server 2005: demo

Proceedings of the 2005 ACM SIGMOD international conference on Management of data
DB2 design advisor: integrated automatic physical database design

VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
Automatic SQL tuning in oracle 10g

VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30

Quantified Score

Hi-index	0.00

Visualization

Abstract

The materialized view technology has been widely adopted in the data warehouse systems to improve query performance. Two key underlying techniques are materialized view incremental refresh and query rewrite. However, due to the potential complexity of the materialized view defining query and dependency on the materialized view change log, not all materialized views are incrementally refreshable or generally query rewritable. Many restrictions need to be applied and addressed which make the materialized view not easy to use. This paper presents Oracle's tuning mechanism/tool to facilitate the materialized view creation by automatically fixing and/or decomposing the defining query and addressing the change log requirements. The resulting materialized view implemented by a set of recommendation statements achieves the goals of incremental maintenance and broad query rewrite.