DBScholar

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
hb3e4f16711a1f53d
Venue
SIGMOD
Year
2000
Pagerank
0.00012224962
Overall Rank
1,059 | 92.91%
DOI
10.1145/342009.335390

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{zaharioudakis_sigmod00,
        title = {{Answering Complex SQL Queries Using Automatic Summary Tables}},
        author = {Zaharioudakis, Markos and Cochrane, Roberta and Lapis, George and Pirahesh, Hamid and Urata, Monica},
        series = {{SIGMOD} '00},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/342009.335390},
        url = {https://dl.acm.org/doi/10.1145/342009.335390},
        year = {2000}
}

Incoming Citations (Sorted by Pagerank)

Showing 25 of 25 citing papers.

Rank Citing Paper Year Venue Pagerank
189 DB2 Design Advisor: Integrated Automatic Physical Database Design 2004 VLDB 0.00025846085
556 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.00016470022
570 Extending Query Rewriting Techniques for Fine-Grained Access Control 2004 SIGMOD 0.00016201674
940 A Scalable Algorithm for Answering Queries Using Views 2000 VLDB 0.00012941424
1,790 Lazy Maintenance of Materialized Views 2007 VLDB 9.6228433e-05
2,054 WinMagic : Subquery Elimination Using Window Aggregation 2003 SIGMOD 9.1030561e-05
2,726 A Framework for Using Materialized XPath Views in XML Query Processing 2004 VLDB 8.0711806e-05
3,352 Cache Tables: Paving the Way for an Adaptive Database Cache 2003 VLDB 7.3694169e-05
3,444 Complete Yet Practical Search for Minimal Query Reformulations Under Constraints 2014 SIGMOD 7.277762e-05
4,752 Interactive Summarization and Exploration of Top Aggregate Query Answers 2018 VLDB 6.4226993e-05
5,028 User-Defined Aggregate Functions: Bridging Theory and Practice 2006 SIGMOD 6.2956973e-05
5,611 StatAdvisor: Recommending Statistical Views 2009 VLDB 6.0498181e-05
5,782 POP/FED: Progressive Query Optimization for Federated Queries in DB2 2006 VLDB 5.9783002e-05
5,793 Optimizing Data Pipelines for Machine Learning in Feature Stores 2023 VLDB 5.9761004e-05
5,847 Opportunistic Physical Design for Big Data Analytics 2014 SIGMOD 5.9537345e-05
6,395 View Matching for Outer-Join Views 2005 VLDB 5.7850662e-05
6,681 Generating Efficient Plans for Queries Using Views 2001 SIGMOD 5.6945953e-05
6,824 Stacked Indexed Views in Microsoft SQL Server 2005 SIGMOD 5.6568082e-05
7,288 Query Evaluation using Overlapping Views: Completeness and Efficiency 2006 SIGMOD 5.5489538e-05
8,648 Maintenance of Cube Automatic Summary Tables 2000 SIGMOD 5.2812957e-05
9,166 Equivalence of Nested Queries with Mixed Semantics 2009 PODS 5.2031263e-05
9,620 Materializing Views with Minimal Size To Answer Queries 2003 PODS 5.1376962e-05
9,827 ProvCite: Provenance-based Data Citation 2019 VLDB 5.108228e-05
10,225 COMPARE: Accelerating Groupwise Comparison in Relational Databases for Data Analytics 2021 VLDB 5.0460607e-05
13,107 Vertical and Horizontal Percentage Aggregations 2004 SIGMOD 4.9605343e-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.00070860346
72 Answering Queries Using Views (Extended Abstract) 1995 PODS 0.00037421163
204 Aggregate-Query Processing in Data Warehousing Environments 1995 VLDB 0.0002516936
567 Answering Queries with Aggregation Using Views 1996 VLDB 0.00016228477
654 Materialized Views In Oracle 1998 VLDB 0.00015096471
882 Rewriting Aggregate Queries Using Views 1999 PODS 0.00013239752
904 Maintenance of Data Cubes and Summary Tables in a Warehouse 1997 SIGMOD 0.00013138723
2,284 Deciding Equivalences among Aggregate Queries 1998 PODS 8.6880978e-05
2,301 Querying Aggregate Data 1999 PODS 8.6620636e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 9,620 Materializing Views with Minimal Size To Answer Queries 2003 PODS
2 648 Materialized View Selection in a Multidimensional Database 1997 VLDB
3 3,619 Summary Graphs for Relational Database Schemas 2011 VLDB
4 2,626 Cost-Based Optimization of Decision Support Queries using Transient-Views 1998 SIGMOD
5 927 Materialized View Selection and Maintenance Using Multi-Query Optimization 2001 SIGMOD
6 72 Answering Queries Using Views (Extended Abstract) 1995 PODS
7 556 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD
8 4,246 On the Content of Materialized Aggregate Views 2000 PODS
9 239 Complexity of Answering Queries Using Materialized Views 1998 PODS
10 567 Answering Queries with Aggregation Using Views 1996 VLDB