 |
|
|
Materialized Views in Oracle |
Full Paper (PDF)
|
Oracle Materialized Views (MVs) are designed for data warehousing and replication.
For data warehousing, MVs based on inner/outer equijoins with optional aggregation, can be refreshed on transaction boundaries, on demand, or periodically.
Refreshes are optimized for bulk loads and can use a multi-MV scheduler.
MVs based on subqueries on remote tables support bidirectional replication.
Optimization with MVs includes transparent query rewrite based on cost- based selection method.
The ability to rewrite a large class of queries based on a small set of MVs is supported by using Dimensions (new Oracle object), losslessness of joins, functional dependency, column equivalence, join derivability, joinback and aggregate rollup.
|
References, where available, link to the DBLP on the World Wide Web.
[BM90]José A. Blakeley, Nancy L. Martin:
Join Index, Materialized View, and Hybrid-Hash Join: A Performance Analysis.
ICDE 1990: 256-263[CCHJJMSW98]Latha S. Colby, Richard L. Cole, Edward Haslam, Nasi Jazayeri, Galt Johnson, William J. McKenna, Lee Schumacher, David Wilhite:
Redbrick Vista: Aggregate Computation and Management.
ICDE 1998: 174-177[CKPS95]Surajit Chaudhuri, Ravi Krishnamurthy, Spyros Potamianos, Kyuseok Shim:
Optimizing Queries with Materialized Views.
ICDE 1995: 190-200[CM96]...
[DDDEHJJLSSS94]Dean Daniels, Lip Boon Doo, Alan Downing, Curtis Elsbernd, Gary Hallmark, Sandeep Jain, Bob Jenkins, Peter Lim, Gordon Smith, Benny Souder, Jim Stamos:
Oracle's Symmetric Replication Technology and Implications for Application Design.
SIGMOD Conference 1994: 467[GHQ95]Ashish Gupta, Venky Harinarayan, Dallan Quass:
Aggregate-Query Processing in Data Warehousing Environments.
VLDB 1995: 358-369[GMS93]Ashish Gupta, Inderpal Singh Mumick, V. S. Subrahmanian:
Maintaining Views Incrementally.
SIGMOD Conference 1993: 157-166[GM95]Ashish Gupta, Inderpal Singh Mumick:
Maintenance of Materialized Views: Problems, Techniques, and Applications.
Data Engineering Bulletin 18(2): 3-18(1995)[LHMPW86]Bruce G. Lindsay, Laura M. Haas, C. Mohan, Hamid Pirahesh, Paul F. Wilms:
A Snapshot Differential Refresh Algorithm.
SIGMOD Conference 1986: 53-60[LMSS95]Alon Y. Levy, Alberto O. Mendelzon, Yehoshua Sagiv, Divesh Srivastava:
Answering Queries Using Views.
PODS 1995: 95-104[MQM97]Inderpal Singh Mumick, Dallan Quass, Barinderpal Singh Mumick:
Maintenance of Data Cubes and Summary Tables in a Warehouse.
SIGMOD Conference 1997: 100-111[S95]...
[SDJL96]Divesh Srivastava, Shaul Dar, H. V. Jagadish, Alon Y. Levy:
Answering Queries with Aggregation Using Views.
VLDB 1996: 318-329
|
@inproceedings{DBLP:conf/vldb/BelloDDFNSWZ98,
author = {Randall G. Bello and
Karl Dias and
Alan Downing and
James Feenan Jr. and
William D. Norcott and
Harry Sun and
Andrew Witkowski and
Mohamed Ziauddin},
editor = {Ashish Gupta and
Oded Shmueli and
Jennifer Widom},
title = {Materialized Views in Oracle},
booktitle = {VLDB'98, Proceedings of 24rd International Conference on Very
Large Data Bases, August 24-27, 1998, New York City, New York,
USA},
publisher = {Morgan Kaufmann},
year = {1998},
isbn = {1-55860-566-5},
pages = {659-664},
crossref = {DBLP:conf/vldb/98},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
|
DBLP: Copyright ©1999 by Michael Ley (ley@uni-trier.de).
|
|
