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
3178
Venue
SIGMOD
Year
2000
Pagerank
0.00014370009
Overall Rank
1,059 | 92.65%
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.00030196528
607 Extending Query Rewriting Techniques for Fine-Grained Access Control 2004 SIGMOD 0.00019248482
728 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.00017459654
1,155 A Scalable Algorithm for Answering Queries Using Views 2000 VLDB 0.00013606507
1,871 WinMagic : Subquery Elimination Using Window Aggregation 2003 SIGMOD 0.0001025746
2,026 Lazy Maintenance of Materialized Views 2007 VLDB 9.7466372e-05
2,980 A Framework for Using Materialized XPath Views in XML Query Processing 2004 VLDB 7.7800968e-05
3,514 Complete Yet Practical Search for Minimal Query Reformulations Under Constraints 2014 SIGMOD 7.0192177e-05
3,602 Cache Tables: Paving the Way for an Adaptive Database Cache 2003 VLDB 6.9282932e-05
4,608 Interactive Summarization and Exploration of Top Aggregate Query Answers 2018 VLDB 6.046643e-05
5,177 User-Defined Aggregate Functions: Bridging Theory and Practice 2006 SIGMOD 5.6386942e-05
5,575 Optimizing Data Pipelines for Machine Learning in Feature Stores 2023 VLDB 5.4253204e-05
5,824 StatAdvisor: Recommending Statistical Views 2009 VLDB 5.311975e-05
6,053 POP/FED: Progressive Query Optimization for Federated Queries in DB2 2006 VLDB 5.2310929e-05
6,079 Opportunistic Physical Design for Big Data Analytics 2014 SIGMOD 5.2194019e-05
6,168 View Matching for Outer-Join Views 2005 VLDB 5.1709078e-05
6,567 Generating Efficient Plans for Queries Using Views 2001 SIGMOD 5.0023017e-05
6,830 Stacked Indexed Views in Microsoft SQL Server 2005 SIGMOD 4.9081078e-05
6,884 Query Evaluation using Overlapping Views: Completeness and Efficiency 2006 SIGMOD 4.8917858e-05
8,169 Maintenance of Cube Automatic Summary Tables 2000 SIGMOD 4.5662628e-05
8,699 Equivalence of Nested Queries with Mixed Semantics 2009 PODS 4.4604187e-05
9,263 Materializing Views with Minimal Size To Answer Queries 2003 PODS 4.3648789e-05
9,850 COMPARE: Accelerating Groupwise Comparison in Relational Databases for Data Analytics 2021 VLDB 4.2680295e-05
9,920 ProvCite: Provenance-based Data Citation 2019 VLDB 4.250874e-05
12,586 Vertical and Horizontal Percentage Aggregations 2004 SIGMOD 4.1905499e-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.0011695087
82 Answering Queries Using Views (Extended Abstract) 1995 PODS 0.00054430106
218 Aggregate-Query Processing in Data Warehousing Environments 1995 VLDB 0.00033489004
470 Materialized Views In Oracle 1998 VLDB 0.00022386815
583 Answering Queries with Aggregation Using Views 1996 VLDB 0.00019705383
963 Maintenance of Data Cubes and Summary Tables in a Warehouse 1997 SIGMOD 0.00014975448
971 Rewriting Aggregate Queries Using Views 1999 PODS 0.00014915911
2,105 Deciding Equivalences among Aggregate Queries 1998 PODS 9.5309231e-05
2,475 Querying Aggregate Data 1999 PODS 8.6942707e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
9,263 Materializing Views with Minimal Size To Answer Queries 2003 PODS 4.3648789e-05
681 Materialized View Selection in a Multidimensional Database 1997 VLDB 0.0001818285
1,794 Summary Graphs for Relational Database Schemas 2011 VLDB 0.00010516799
2,290 Cost-Based Optimization of Decision Support Queries using Transient-Views 1998 SIGMOD 9.0918901e-05
1,110 Materialized View Selection and Maintenance Using Multi-Query Optimization 2001 SIGMOD 0.00013902997
82 Answering Queries Using Views (Extended Abstract) 1995 PODS 0.00054430106
728 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.00017459654
4,084 On the Content of Materialized Aggregate Views 2000 PODS 6.4581296e-05
297 Complexity of Answering Queries Using Materialized Views 1998 PODS 0.00028572729
583 Answering Queries with Aggregation Using Views 1996 VLDB 0.00019705383