Automated Generation of Materialized Views in Oracle

Summary: Presents an end-to-end Oracle system that automatically generates, cost-selects, verifies, and maintains materialized views for autonomous databases. Its extended covering subexpression algorithm is validated experimentally and deployed in Oracle Autonomous Database Cloud. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: 12377
Venue: VLDB
Year: 2020
Pagerank: 6.9009734e-05
Overall Rank: 4,101 | 71.87%
DOI: 10.14778/3415478.3415533

Incoming Non-self Citations Over Time

Authors

1. Rafi Ahmed (Oracle)
2. Randall Bello (Oracle)
3. Andrew Witkowski (Oracle)
4. Praveen Kumar (Oracle)

BibTeX Citation

@article{ahmed_vldb20,
        title = {{Automated Generation of Materialized Views in Oracle}},
        author = {Ahmed, Rafi and Bello, Randall and Witkowski, Andrew and Kumar, Praveen},
        journal = {PVLDB},
        series = {{VLDB} '20},
        volume = {13},
        number = {12},
        pages = {3046--3058},
        doi = {10.14778/3415478.3415533},
        url = {https://doi.org/10.14778/3415478.3415533},
        year = {2020}
}

Incoming Citations (Sorted by Pagerank)

Showing 12 of 12 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
3,662	openGauss: An Autonomous Database System	2021	VLDB	7.2166682e-05
5,169	LearnedSQLGen: Constraint-aware SQL Generation using Reinforcement Learning	2022	SIGMOD	6.3349035e-05
6,848	Jigsaw: A Data Storage and Query Processing Engine for Irregular Table Partitioning	2021	SIGMOD	5.7550624e-05
7,846	The Holon Approach for Simultaneously Tuning Multiple Components in a Self-Driving Database Management System with Machine Learning via Synthesized Proto-Actions	2024	VLDB	5.5331459e-05
8,798	GEqO: ML-Accelerated Semantic Equivalence Detection	2023	SIGMOD	5.3698781e-05
9,240	Automatic SQL Error Mitigation in Oracle	2023	VLDB	5.3004142e-05
9,775	Twisted Twin: A Collaborative and Competitive Memory Management Approach in HTAP Systems	2025	VLDB	5.2209769e-05
9,949	UniView: A Unified Autonomous Materialized View Management System for Various Databases	2024	VLDB	5.1915905e-05
9,951	Cquirrel: Continuous Query Processing over Acyclic Relational Schemas	2021	VLDB	5.1915905e-05
10,506	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	5.093636e-05
11,017	Streaming View: An Efficient Data Processing Engine for Modern Real-time Data Warehouse of Alibaba Cloud	2025	VLDB	5.093636e-05
11,297	Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle	2024	VLDB	5.093636e-05

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
18	How Good Are Query Optimizers, Really?	2016	VLDB	0.00059284255
87	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00035281619
128	Efficient and Extensible Algorithms for Multi Query Optimization	2000	SIGMOD	0.0003072825
156	An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server	1997	VLDB	0.00028636811
184	DB2 Design Advisor: Integrated Automatic Physical Database Design	2004	VLDB	0.00026256101
288	Towards Estimation Error Guarantees for Distinct Values	2000	PODS	0.00022296371
387	AutoAdmin "What-if" Index Analysis Utility	1998	SIGMOD	0.00019442332
501	Database Tuning Advisor for Microsoft SQL Server 2005	2004	VLDB	0.0001738508
524	Automatic SQL Tuning in Oracle 10g	2004	VLDB	0.00017120666
559	Optimizing Queries Using Materialized Views: A Practical, Scalable Solution	2001	SIGMOD	0.00016528822
643	Materialized Views In Oracle	1998	VLDB	0.00015372449
1,154	Efficient Exploitation of Similar Subexpressions for Query Processing	2007	SIGMOD	0.00011934202
1,548	Automatically Indexing Millions of Databases in Microsoft Azure SQL Database	2019	SIGMOD	0.00010392475
1,765	Selecting Subexpressions to Materialize at Datacenter Scale	2018	VLDB	9.8079546e-05
3,268	Efficient and Provable Multi-Query Optimization	2017	PODS	7.5810998e-05
4,091	Of Snowstorms and Bushy Trees	2014	VLDB	6.9090244e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	2,095	Enhanced Subquery Optimizations in Oracle	2009	VLDB
2	4,155	On the Content of Materialized Aggregate Views	2000	PODS
3	1,743	Algorithms for Materialized View Design in Data Warehousing Environment	1997	VLDB
4	559	Optimizing Queries Using Materialized Views: A Practical, Scalable Solution	2001	SIGMOD
5	1,034	Answering Complex SQL Queries Using Automatic Summary Tables	2000	SIGMOD
6	9,240	Automatic SQL Error Mitigation in Oracle	2023	VLDB
7	258	Deriving Production Rules for Incremental View Maintenance	1991	VLDB
8	929	Materialized View Selection and Maintenance Using Multi-Query Optimization	2001	SIGMOD
9	11,003	Automatic Indexing in Oracle	2025	VLDB
10	87	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB