Database Paper Browser

Back to papers

Automated Generation of Materialized Views in Oracle

Summary: Automated generation, selection, verification, and maintenance of materialized views in Oracle RDBMS using a novel extended covering sub-expression algorithm. Shows feasibility and efficiency via experiments; implemented system slated for deployment on Oracle Autonomous Database in the Cloud. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
12189
Venue
VLDB
Year
2020
Pagerank
6.0411909e-05
Overall Rank
4,623 | 67.84%
DOI
10.14778/3415478.3415533

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 12 of 12 citing papers.

Rank Citing Paper Year Venue Pagerank
4,152 openGauss: An Autonomous Database System 2021 VLDB 6.4060406e-05
5,371 LearnedSQLGen: Constraint-aware SQL Generation using Reinforcement Learning 2022 SIGMOD 5.5428776e-05
7,128 Jigsaw: A Data Storage and Query Processing Engine for Irregular Table Partitioning 2021 SIGMOD 4.8230171e-05
8,020 The Holon Approach for Simultaneously Tuning Multiple Components in a Self-Driving Database Management System with Machine Learning via Synthesized Proto-Actions 2024 VLDB 4.6040862e-05
8,783 GEqO: ML-Accelerated Semantic Equivalence Detection 2023 SIGMOD 4.452825e-05
9,141 Automatic SQL Error Mitigation in Oracle 2023 VLDB 4.3855791e-05
9,795 UniView: A Unified Autonomous Materialized View Management System for Various Databases 2024 VLDB 4.2818172e-05
9,800 Cquirrel: Continuous Query Processing over Acyclic Relational Schemas 2021 VLDB 4.2818172e-05
10,217 This is Going to Sound Crazy, But What If We Used Large Language Models to Boost Automatic Database Tuning Algorithms By Leveraging Prior History? We Will Find Better Configurations More Quickly Than Retraining From Scratch! 2026 SIGMOD 4.1945683e-05
10,668 Twisted Twin: A Collaborative and Competitive Memory Management Approach in HTAP Systems 2025 VLDB 4.1945683e-05
10,788 Streaming View: An Efficient Data Processing Engine for Modern Real-time Data Warehouse of Alibaba Cloud 2025 VLDB 4.1945683e-05
11,091 Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle 2024 VLDB 4.1945683e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 16 of 16 cited papers.

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

Rank Cited Paper Year Venue Pagerank
71 How Good Are Query Optimizers, Really? 2016 VLDB 0.00059038975
158 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB 0.00040071492
179 Efficient and Extensible Algorithms for Multi Query Optimization 2000 SIGMOD 0.00037672155
237 An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server 1997 VLDB 0.00031726304
258 DB2 Design Advisor: Integrated Automatic Physical Database Design 2004 VLDB 0.0003022091
378 Towards Estimation Error Guarantees for Distinct Values 2000 PODS 0.0002497492
468 Materialized Views In Oracle 1998 VLDB 0.00022411821
496 Automatic SQL Tuning in Oracle 10g 2004 VLDB 0.00021728655
516 AutoAdmin "What-if" Index Analysis Utility 1998 SIGMOD 0.00021196031
661 Database Tuning Advisor for Microsoft SQL Server 2005 2004 VLDB 0.00018481174
731 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.00017468889
1,476 Efficient Exploitation of Similar Subexpressions for Query Processing 2007 SIGMOD 0.00011779092
1,922 Selecting Subexpressions to Materialize at Datacenter Scale 2018 VLDB 0.00010082599
2,047 Automatically Indexing Millions of Databases in Microsoft Azure SQL Database 2019 SIGMOD 9.6920209e-05
3,462 Efficient and Provable Multi-Query Optimization 2017 PODS 7.0703696e-05
4,511 Of Snowstorms and Bushy Trees 2014 VLDB 6.1247645e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
2,504 Enhanced Subquery Optimizations in Oracle 2009 VLDB 8.6351917e-05
4,082 On the Content of Materialized Aggregate Views 2000 PODS 6.4639136e-05
1,911 Algorithms for Materialized View Design in Data Warehousing Environment 1997 VLDB 0.00010120234
731 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.00017468889
1,059 Answering Complex SQL Queries Using Automatic Summary Tables 2000 SIGMOD 0.00014382575
9,141 Automatic SQL Error Mitigation in Oracle 2023 VLDB 4.3855791e-05
264 Deriving Production Rules for Incremental View Maintenance 1991 VLDB 0.00029844694
1,112 Materialized View Selection and Maintenance Using Multi-Query Optimization 2001 SIGMOD 0.00013917776
10,774 Automatic Indexing in Oracle 2025 VLDB 4.1945683e-05
158 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB 0.00040071492