Database Paper Browser

Back to papers

Answering Complex SQL Queries Using Automatic Summary Tables

Summary: Introduces automatic summary tables from materialized views to answer complex SQL with joins, arith., UDFs, nested queries. Graph-based MV-graph with bottom-up, pairwise node matching enables rewriting to MVs, delivering modular, extensible support. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
3177
Venue
SIGMOD
Year
2000
Pagerank
0.00014382575
Overall Rank
1,059 | 92.64%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 25 of 25 citing papers.

Rank Citing Paper Year Venue Pagerank
258 DB2 Design Advisor: Integrated Automatic Physical Database Design 2004 VLDB 0.0003022091
607 Extending Query Rewriting Techniques for Fine-Grained Access Control 2004 SIGMOD 0.00019266724
731 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.00017468889
1,155 A Scalable Algorithm for Answering Queries Using Views 2000 VLDB 0.00013616518
1,869 WinMagic : Subquery Elimination Using Window Aggregation 2003 SIGMOD 0.00010265836
2,022 Lazy Maintenance of Materialized Views 2007 VLDB 9.754634e-05
2,977 A Framework for Using Materialized XPath Views in XML Query Processing 2004 VLDB 7.7876083e-05
3,509 Complete Yet Practical Search for Minimal Query Reformulations Under Constraints 2014 SIGMOD 7.0263584e-05
3,607 Cache Tables: Paving the Way for an Adaptive Database Cache 2003 VLDB 6.9253431e-05
4,614 Interactive Summarization and Exploration of Top Aggregate Query Answers 2018 VLDB 6.0467204e-05
5,176 User-Defined Aggregate Functions: Bridging Theory and Practice 2006 SIGMOD 5.6439407e-05
5,567 Optimizing Data Pipelines for Machine Learning in Feature Stores 2023 VLDB 5.4305348e-05
5,815 StatAdvisor: Recommending Statistical Views 2009 VLDB 5.3165295e-05
6,049 POP/FED: Progressive Query Optimization for Federated Queries in DB2 2006 VLDB 5.2360942e-05
6,075 Opportunistic Physical Design for Big Data Analytics 2014 SIGMOD 5.223901e-05
6,166 View Matching for Outer-Join Views 2005 VLDB 5.1724475e-05
6,567 Generating Efficient Plans for Queries Using Views 2001 SIGMOD 5.0069599e-05
6,832 Stacked Indexed Views in Microsoft SQL Server 2005 SIGMOD 4.9128255e-05
6,881 Query Evaluation using Overlapping Views: Completeness and Efficiency 2006 SIGMOD 4.8964953e-05
8,167 Maintenance of Cube Automatic Summary Tables 2000 SIGMOD 4.5705919e-05
8,704 Equivalence of Nested Queries with Mixed Semantics 2009 PODS 4.4647149e-05
9,259 Materializing Views with Minimal Size To Answer Queries 2003 PODS 4.3690661e-05
9,850 COMPARE: Accelerating Groupwise Comparison in Relational Databases for Data Analytics 2021 VLDB 4.2721228e-05
9,921 ProvCite: Provenance-based Data Citation 2019 VLDB 4.2549509e-05
12,577 Vertical and Horizontal Percentage Aggregations 2004 SIGMOD 4.1945683e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 9 of 9 cited papers.

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

Rank Cited Paper Year Venue Pagerank
11 Implementing Data Cubes Efficiently 1996 SIGMOD 0.0011708144
82 Answering Queries Using Views (Extended Abstract) 1995 PODS 0.00054402763
218 Aggregate-Query Processing in Data Warehousing Environments 1995 VLDB 0.00033503922
468 Materialized Views In Oracle 1998 VLDB 0.00022411821
584 Answering Queries with Aggregation Using Views 1996 VLDB 0.0001971526
962 Maintenance of Data Cubes and Summary Tables in a Warehouse 1997 SIGMOD 0.00014986226
971 Rewriting Aggregate Queries Using Views 1999 PODS 0.00014925576
2,103 Deciding Equivalences among Aggregate Queries 1998 PODS 9.5385023e-05
2,475 Querying Aggregate Data 1999 PODS 8.7017602e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
9,259 Materializing Views with Minimal Size To Answer Queries 2003 PODS 4.3690661e-05
681 Materialized View Selection in a Multidimensional Database 1997 VLDB 0.00018203591
1,796 Summary Graphs for Relational Database Schemas 2011 VLDB 0.00010524897
2,284 Cost-Based Optimization of Decision Support Queries using Transient-Views 1998 SIGMOD 9.1053836e-05
1,112 Materialized View Selection and Maintenance Using Multi-Query Optimization 2001 SIGMOD 0.00013917776
82 Answering Queries Using Views (Extended Abstract) 1995 PODS 0.00054402763
731 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.00017468889
4,082 On the Content of Materialized Aggregate Views 2000 PODS 6.4639136e-05
297 Complexity of Answering Queries Using Materialized Views 1998 PODS 0.00028596715
584 Answering Queries with Aggregation Using Views 1996 VLDB 0.0001971526