Skip to main content
SpringerLink
Log in
Book cover

International Conference on Distributed Computing and Internet Technology

ICDCIT 2006: Distributed Computing and Internet Technology pp 347–360Cite as

Materialized View Tuning Mechanism and Usability Enhancement

  • Conference paper

  • 493 Accesses

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 4317))

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.

This is a preview of subscription content, log in via an institution.

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Dageville, B., Das, D., Dias, K., Yagoub, K., Zait, M., Ziauddin, M.: Automatic SQL Tuning in Oracle 10g. In: VLDB conference, Toronto, Canada (2004)

    Google Scholar 

  2. Zilio, D., Rao, J., Lightstone, S., Lohman, G., Storm, A., Christian, Garcia-Arellano, Fadden, S.: DB2 Design Advisor: Integrated Automatic Physical Database Design. In: VLDB conference, Toronto, Canada (2004)

    Google Scholar 

  3. EBM-Software BV, X4!-Materialized Views for MySQL (2005), http://x4.olap4all.com/

  4. Gardner, J.: Materialized Views in PostgreSQL (2004), http://www.jonathangardner.net/PostgreSQL/materialized_views/matviews.html

  5. IBM, DB2 UDB’s High-Function Business Intelligence in e-business (2002), www.redbooks.ibm.com/redbooks/pdfs/sg246546.pdf

  6. Microsoft Corporation, Microsoft SQL Server 2005 Indexed Views (2006), www.microsoft.com

  7. Oracle Corporation, Data Warehousing Guide, Oracle9i Release 1 (2002), http://otn.oracle.com/

  8. Oracle Corporation, Data Warehousing Guide, Oracle10g Release 1 (2004), http://otn.oracle.com/

  9. Agrawal, S., Chaudhuri, S., Kollar, L., Marathe, A., Narasayya, V., Syamala, M.: Database Tuning Advisor for Microsoft SQL Server 2005. In: VLDB conference, Toronto, Canada (2004)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Oracle Corporation, One Oracle Drive, Nashua, NH, 03062, U.S.A

    Tsae-Feng Yu, Thomas Tong, Min Xiao & Jack Raitto

Authors
  1. Tsae-Feng Yu
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Thomas Tong
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Min Xiao
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Jack Raitto
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Department of Computer Science, University of Missouri-Rolla, USA

    Sanjay K. Madria

  2. MIT Lincoln Laboratories,  

    Kajal T. Claypool

  3. Dept of CS, Louisiana State University, 70803, Baton Rouge, LA

    Rajgopal Kannan

  4. Department of Computer Science, Radford University, 24060, Radford, VA, USA

    Prem Uppuluri

  5. Department of Computer Science and Engineering, Motilal Nehru National Institute of Technology, Allahabad, India

    Manoj Madhava Gore

Rights and permissions

Reprints and permissions

Copyright information

© 2006 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Yu, TF., Tong, T., Xiao, M., Raitto, J. (2006). Materialized View Tuning Mechanism and Usability Enhancement. In: Madria, S.K., Claypool, K.T., Kannan, R., Uppuluri, P., Gore, M.M. (eds) Distributed Computing and Internet Technology. ICDCIT 2006. Lecture Notes in Computer Science, vol 4317. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11951957_31

Download citation

  • DOI: https://doi.org/10.1007/11951957_31

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-68379-7

  • Online ISBN: 978-3-540-68380-3

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation