Database Paper Browser

Back to papers

Answering Queries with Aggregation Using Views

Summary: Semantic query rewriting using materialized views for grouped/aggregated SQL over multisets. Shows when a view works via isomorphism to a query portion or via aggregation data; may yield unions of single-block rewrites, unlike prior syntactic methods. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
8355
Venue
VLDB
Year
1996
Pagerank
0.00019705383
Overall Rank
583 | 95.95%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 35 of 35 citing papers.

Rank Citing Paper Year Venue Pagerank
47 Data Integration: A Theoretical Perspective 2002 PODS 0.00069691761
82 Answering Queries Using Views (Extended Abstract) 1995 PODS 0.00054430106
127 Querying Heterogeneous Information Sources Using Source Descriptions 1996 VLDB 0.00044607231
454 An Overview of Query Optimization in Relational Systems 1998 PODS 0.00022796106
464 PREFER: A System for the Efficient Execution of Multiparametric Ranked Queries 2001 SIGMOD 0.00022476798
470 Materialized Views In Oracle 1998 VLDB 0.00022386815
523 Recovering Information from Summary Data 1997 VLDB 0.00021101376
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
908 Design Considerations for High Fan-in Systems: The HiFi Approach 2005 CIDR 0.00015405471
971 Rewriting Aggregate Queries Using Views 1999 PODS 0.00014915911
1,059 Answering Complex SQL Queries Using Automatic Summary Tables 2000 SIGMOD 0.00014370009
1,360 Data Warehouse Configuration 1997 VLDB 0.0001239983
1,508 Using Schematically Heterogeneous Structures 1998 SIGMOD 0.00011593524
1,838 Mesa: Geo-Replicated, Near Real-Time, Scalable Data Warehousing 2014 VLDB 0.00010353323
1,890 Caching Multidimensional Queries Using Chunks 1998 SIGMOD 0.0001018961
2,105 Deciding Equivalences among Aggregate Queries 1998 PODS 9.5309231e-05
2,290 Cost-Based Optimization of Decision Support Queries using Transient-Views 1998 SIGMOD 9.0918901e-05
2,345 Rewriting of Regular Expressions and Regular Path Queries 1999 PODS 8.9933611e-05
2,475 Querying Aggregate Data 1999 PODS 8.6942707e-05
3,101 On Efficiently Implementing SchemaSQL on a SQL Database System 1999 VLDB 7.5611936e-05
3,514 Complete Yet Practical Search for Minimal Query Reformulations Under Constraints 2014 SIGMOD 7.0192177e-05
3,809 Supporting Ad-hoc Ranking Aggregates 2006 SIGMOD 6.7413981e-05
4,084 On the Content of Materialized Aggregate Views 2000 PODS 6.4581296e-05
5,177 User-Defined Aggregate Functions: Bridging Theory and Practice 2006 SIGMOD 5.6386942e-05
5,522 IncShrink: Architecting Efficient Outsourced Databases using Incremental MPC and Differential Privacy 2022 SIGMOD 5.4654207e-05
6,152 Crystal: A Unified Cache Storage System for Analytical Databases 2021 VLDB 5.1802666e-05
6,168 View Matching for Outer-Join Views 2005 VLDB 5.1709078e-05
6,884 Query Evaluation using Overlapping Views: Completeness and Efficiency 2006 SIGMOD 4.8917858e-05
7,042 Processing Star Queries on Hierarchically-Clustered Fact Tables 2002 VLDB 4.8483133e-05
7,412 Snakes and Sandwiches: Optimal Clustering Strategies for a Data Warehouse 1999 SIGMOD 4.7316475e-05
8,699 Equivalence of Nested Queries with Mixed Semantics 2009 PODS 4.4604187e-05
9,920 ProvCite: Provenance-based Data Citation 2019 VLDB 4.250874e-05
11,414 High-dimensional Data Cubes 2022 VLDB 4.1905499e-05
12,714 Using LDAP Directory Caches 1999 PODS 4.1905499e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 14 of 14 cited papers.

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

Rank Cited Paper Year Venue Pagerank
51 Including Group-By in Query Optimization 1994 VLDB 0.00067060283
82 Answering Queries Using Views (Extended Abstract) 1995 PODS 0.00054430106
89 Common Expression Analysis in Database Applications 1982 SIGMOD 0.00052299473
127 Querying Heterogeneous Information Sources Using Source Descriptions 1996 VLDB 0.00044607231
135 On Rules, Procedures, Caching And Views In Data Base Systems 1990 SIGMOD 0.0004273413
138 Query Transformation for PSJ-queries 1987 VLDB 0.00042322097
218 Aggregate-Query Processing in Data Warehousing Environments 1995 VLDB 0.00033489004
335 Optimization of Real Conjunctive Queries 1993 PODS 0.00027012705
402 View Maintenance in a Warehousing Environment 1995 SIGMOD 0.00024179174
578 The GMAP: A Versatile Tool for Physical Data Independence 1994 VLDB 0.00019825485
1,303 Query Optimization by Predicate Move-Around 1994 VLDB 0.00012692678
1,395 View Maintenance Issues for the Chronicle Data Model (Extended Abstract) 1995 PODS 0.00012216523
1,591 Sleepers and Workaholics: Caching Strategies in Mobile Environments 1994 SIGMOD 0.00011218656
1,620 Adapting Materialized Views after Redefinitions 1995 SIGMOD 0.00011112989
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
1,110 Materialized View Selection and Maintenance Using Multi-Query Optimization 2001 SIGMOD 0.00013902997
1,155 A Scalable Algorithm for Answering Queries Using Views 2000 VLDB 0.00013606507
9,263 Materializing Views with Minimal Size To Answer Queries 2003 PODS 4.3648789e-05
6,884 Query Evaluation using Overlapping Views: Completeness and Efficiency 2006 SIGMOD 4.8917858e-05
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
1,059 Answering Complex SQL Queries Using Automatic Summary Tables 2000 SIGMOD 0.00014370009
297 Complexity of Answering Queries Using Materialized Views 1998 PODS 0.00028572729
971 Rewriting Aggregate Queries Using Views 1999 PODS 0.00014915911
4,084 On the Content of Materialized Aggregate Views 2000 PODS 6.4581296e-05