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
hda8d16c5a2f92757
Venue
VLDB
Year
1996
Pagerank
0.00016264813
Overall Rank
567 | 96.20%
DOI
-
Incoming Non-self Citations Over Time
BibTeX Citation
@article{srivastava_vldb96,
title = {{Answering Queries with Aggregation Using Views}},
author = {Srivastava, Divesh and Dar, Shaul and Jagadish, H. V. and Levy, Alon Y.},
journal = {PVLDB},
series = {{VLDB} '96},
year = {1996}
}
Incoming Citations (Sorted by Pagerank)
Showing 35 of 35 citing papers.
Rank
Citing Paper
Year
Venue
Pagerank
24
Data Integration: A Theoretical Perspective 2002
PODS
0.00055018384
72
Answering Queries Using Views (Extended Abstract) 1995
PODS
0.0003753293
117
Querying Heterogeneous Information Sources Using Source Descriptions 1996
VLDB
0.00031616101
272
An Overview of Query Optimization in Relational Systems 1998
PODS
0.0002251422
418
PREFER: A System for the Efficient Execution of Multiparametric Ranked Queries 2001
SIGMOD
0.00018609134
553
Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001
SIGMOD
0.00016518678
568
Extending Query Rewriting Techniques for Fine-Grained Access Control 2004
SIGMOD
0.00016254878
649
Materialized Views In Oracle 1998
VLDB
0.00015144459
880
Rewriting Aggregate Queries Using Views 1999
PODS
0.00013274554
969
Recovering Information from Summary Data 1997
VLDB
0.00012788914
1,054
Answering Complex SQL Queries Using Automatic Summary Tables 2000
SIGMOD
0.00012263425
1,358
Design Considerations for High Fan-in Systems: The HiFi Approach 2005
CIDR
0.00010917457
1,549
Data Warehouse Configuration 1997
VLDB
0.00010287654
1,623
Mesa: Geo-Replicated, Near Real-Time, Scalable Data Warehousing 2014
VLDB
0.00010047769
1,729
Using Schematically Heterogeneous Structures 1998
SIGMOD
9.7734376e-05
1,766
Caching Multidimensional Queries Using Chunks 1998
SIGMOD
9.6923431e-05
2,043
Rewriting of Regular Expressions and Regular Path Queries 1999
PODS
9.1379399e-05
2,271
Deciding Equivalences among Aggregate Queries 1998
PODS
8.7155798e-05
2,292
Querying Aggregate Data 1999
PODS
8.6850643e-05
2,620
Cost-Based Optimization of Decision Support Queries using Transient-Views 1998
SIGMOD
8.2178624e-05
3,447
Complete Yet Practical Search for Minimal Query Reformulations Under Constraints 2014
SIGMOD
7.2907616e-05
3,784
Supporting Ad-hoc Ranking Aggregates 2006
SIGMOD
7.0197908e-05
3,961
On Efficiently Implementing SchemaSQL on a SQL Database System 1999
VLDB
6.8926339e-05
4,232
On the Content of Materialized Aggregate Views 2000
PODS
6.7114333e-05
5,016
User-Defined Aggregate Functions: Bridging Theory and Practice 2006
SIGMOD
6.311544e-05
5,056
IncShrink: Architecting Efficient Outsourced Databases using Incremental MPC and Differential Privacy 2022
SIGMOD
6.2928688e-05
5,451
Crystal: A Unified Cache Storage System for Analytical Databases 2021
VLDB
6.1238308e-05
6,385
View Matching for Outer-Join Views 2005
VLDB
5.8039464e-05
7,269
Query Evaluation using Overlapping Views: Completeness and Efficiency 2006
SIGMOD
5.5673576e-05
7,287
Processing Star Queries on Hierarchically-Clustered Fact Tables 2002
VLDB
5.5636487e-05
7,761
Snakes and Sandwiches: Optimal Clustering Strategies for a Data Warehouse 1999
SIGMOD
5.4565021e-05
9,145
Equivalence of Nested Queries with Mixed Semantics 2009
PODS
5.2200167e-05
9,793
ProvCite: Provenance-based Data Citation 2019
VLDB
5.1251743e-05
11,923
High-dimensional Data Cubes 2022
VLDB
4.9769913e-05
13,194
Using LDAP Directory Caches 1999
PODS
4.9769913e-05
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.
Semantically Similar Papers