DBScholar

Back to papers

Materialized Views In Oracle

Summary: Oracle MVs unify warehouse acceleration and bidirectional replication, supporting incremental, scheduled, and transaction-boundary refreshes optimized for bulk loads. Cost-based query rewrite leverages Dimensions and join/aggregate reasoning to derive many queries from few views. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
h2f2cf283b8f67b14
Venue
VLDB
Year
1998
Pagerank
0.00015144459
Overall Rank
649 | 95.64%
DOI
-

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{bello_vldb98,
        title = {{Materialized Views In Oracle}},
        author = {Bello, Randall G. and Dias, Karl and Downing, Alan and Feenan, James and Finnerty, Jim and Norcott, William D. and Sun, Harry and Witkowski, Andrew and Ziauddin, Mohamed},
        journal = {PVLDB},
        series = {{VLDB} '98},
        pages = {659},
        year = {1998}
}

Incoming Citations (Sorted by Pagerank)

Showing 29 of 29 citing papers.

Rank Citing Paper Year Venue Pagerank
553 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.00016518678
568 Extending Query Rewriting Techniques for Fine-Grained Access Control 2004 SIGMOD 0.00016254878
882 An Efficient SQL-based RDF Querying Scheme 2005 VLDB 0.00013271863
936 A Scalable Algorithm for Answering Queries Using Views 2000 VLDB 0.00012983552
949 DynaMat: A Dynamic View Management System for Data Warehouses 1999 SIGMOD 0.00012897003
1,054 Answering Complex SQL Queries Using Automatic Summary Tables 2000 SIGMOD 0.00012263425
1,715 Spreadsheets in RDBMS for OLAP 2003 SIGMOD 9.8056478e-05
1,780 Lazy Maintenance of Materialized Views 2007 VLDB 9.654014e-05
2,608 WebView Materialization 2000 SIGMOD 8.2256561e-05
2,877 Continuous Queries in Oracle 2007 VLDB 7.9150085e-05
3,447 Complete Yet Practical Search for Minimal Query Reformulations Under Constraints 2014 SIGMOD 7.2907616e-05
3,600 Practical Applications of Triggers and Constraints: Successes and Lingering Issues 2000 VLDB 7.1731072e-05
3,763 Dimensions Based Data Clustering and Zone Maps 2017 VLDB 7.0389893e-05
4,007 Automated Generation of Materialized Views in Oracle 2020 VLDB 6.8561069e-05
4,497 A Chase Too Far? 2000 SIGMOD 6.5739818e-05
6,211 Have Your Data and Query It Too: From Key-Value Caching to Big Data Management 2016 SIGMOD 5.8478125e-05
6,385 View Matching for Outer-Join Views 2005 VLDB 5.8039464e-05
6,765 Performance Issues in Incremental Warehouse Maintenance 2000 VLDB 5.6862741e-05
6,809 Stacked Indexed Views in Microsoft SQL Server 2005 SIGMOD 5.6755734e-05
7,020 Oracle8i Index-Organized Table and its Application to New Domains 2000 VLDB 5.6168641e-05
7,269 Query Evaluation using Overlapping Views: Completeness and Efficiency 2006 SIGMOD 5.5673576e-05
7,533 Foreign Keys Open the Door for Faster Incremental View Maintenance 2023 SIGMOD 5.4991257e-05
7,780 DBToaster: Agile Views in a Dynamic Data Management System 2011 CIDR 5.4528185e-05
9,236 Streaming Democratized: Ease Across the Latency Spectrum with Delayed View Semantics and Snowflake Dynamic Tables 2025 SIGMOD 5.2032182e-05
9,593 Materializing Views with Minimal Size To Answer Queries 2003 PODS 5.154741e-05
10,138 Cquirrel: Continuous Query Processing over Acyclic Relational Schemas 2021 VLDB 5.0727027e-05
10,905 Benchmarking the Full Pipeline of Materialized-View-Based Query Rewriting 2026 VLDB 4.9769913e-05
11,306 STsCache: An Efficient Semantic Caching Scheme for Time-series Data Workloads Based on Hybrid Storage 2025 VLDB 4.9769913e-05
11,388 Streaming View: An Efficient Data Processing Engine for Modern Real-time Data Warehouse of Alibaba Cloud 2025 VLDB 4.9769913e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 7 of 7 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
62 Maintaining Views Incrementally 1993 SIGMOD 0.00039040346
72 Answering Queries Using Views (Extended Abstract) 1995 PODS 0.0003753293
202 Aggregate-Query Processing in Data Warehousing Environments 1995 VLDB 0.0002523837
567 Answering Queries with Aggregation Using Views 1996 VLDB 0.00016264813
705 A Snapshot Differential Refresh Algorithm 1986 SIGMOD 0.00014651538
901 Maintenance of Data Cubes and Summary Tables in a Warehouse 1997 SIGMOD 0.00013179526
14,614 Oracle’s Symmetric Replication Technology and Implications for Application Design 1994 SIGMOD -
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 567 Answering Queries with Aggregation Using Views 1996 VLDB
2 4,232 On the Content of Materialized Aggregate Views 2000 PODS
3 553 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD
4 9,130 What is the data warehousing problem? (Are materialized views the answer?) 1996 VLDB
5 923 Materialized View Selection and Maintenance Using Multi-Query Optimization 2001 SIGMOD
6 724 A Performance Analysis of View Materialization Strategies 1987 SIGMOD
7 4,007 Automated Generation of Materialized Views in Oracle 2020 VLDB
8 1,822 Adapting Materialized Views after Redefinitions 1995 SIGMOD
9 10,905 Benchmarking the Full Pipeline of Materialized-View-Based Query Rewriting 2026 VLDB
10 4,096 Optimizing Refresh of a Set of Materialized Views 2005 VLDB