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.00012269068
Overall Rank
1,054 | 92.92%
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
187 DB2 Design Advisor: Integrated Automatic Physical Database Design 2004 VLDB 0.0002592488
553 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.0001652591
568 Extending Query Rewriting Techniques for Fine-Grained Access Control 2004 SIGMOD 0.00016262553
935 A Scalable Algorithm for Answering Queries Using Views 2000 VLDB 0.00012989395
1,779 Lazy Maintenance of Materialized Views 2007 VLDB 9.6583009e-05
2,045 WinMagic : Subquery Elimination Using Window Aggregation 2003 SIGMOD 9.1329128e-05
2,715 A Framework for Using Materialized XPath Views in XML Query Processing 2004 VLDB 8.1017908e-05
3,345 Cache Tables: Paving the Way for an Adaptive Database Cache 2003 VLDB 7.3949085e-05
3,447 Complete Yet Practical Search for Minimal Query Reformulations Under Constraints 2014 SIGMOD 7.2941472e-05
4,729 Interactive Summarization and Exploration of Top Aggregate Query Answers 2018 VLDB 6.4470592e-05
5,012 User-Defined Aggregate Functions: Bridging Theory and Practice 2006 SIGMOD 6.3145331e-05
5,597 StatAdvisor: Recommending Statistical Views 2009 VLDB 6.0718206e-05
5,773 Optimizing Data Pipelines for Machine Learning in Feature Stores 2023 VLDB 5.9987664e-05
5,777 POP/FED: Progressive Query Optimization for Federated Queries in DB2 2006 VLDB 5.9981204e-05
5,834 Opportunistic Physical Design for Big Data Analytics 2014 SIGMOD 5.9759267e-05
6,382 View Matching for Outer-Join Views 2005 VLDB 5.8066944e-05
6,664 Generating Efficient Plans for Queries Using Views 2001 SIGMOD 5.7161652e-05
6,804 Stacked Indexed Views in Microsoft SQL Server 2005 SIGMOD 5.6782614e-05
7,266 Query Evaluation using Overlapping Views: Completeness and Efficiency 2006 SIGMOD 5.5699944e-05
8,621 Maintenance of Cube Automatic Summary Tables 2000 SIGMOD 5.3012918e-05
9,135 Equivalence of Nested Queries with Mixed Semantics 2009 PODS 5.2224867e-05
9,585 Materializing Views with Minimal Size To Answer Queries 2003 PODS 5.1571823e-05
9,787 ProvCite: Provenance-based Data Citation 2019 VLDB 5.1276016e-05
10,189 COMPARE: Accelerating Groupwise Comparison in Relational Databases for Data Analytics 2021 VLDB 5.0651993e-05
13,060 Vertical and Horizontal Percentage Aggregations 2004 SIGMOD 4.9793485e-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.00071084324
72 Answering Queries Using Views (Extended Abstract) 1995 PODS 0.00037549176
202 Aggregate-Query Processing in Data Warehousing Environments 1995 VLDB 0.00025244649
567 Answering Queries with Aggregation Using Views 1996 VLDB 0.00016272161
648 Materialized Views In Oracle 1998 VLDB 0.00015151422
880 Rewriting Aggregate Queries Using Views 1999 PODS 0.00013280642
901 Maintenance of Data Cubes and Summary Tables in a Warehouse 1997 SIGMOD 0.00013185553
2,269 Deciding Equivalences among Aggregate Queries 1998 PODS 8.7196256e-05
2,289 Querying Aggregate Data 1999 PODS 8.6891266e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

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