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.00016228477
Overall Rank
567 | 96.21%
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.00055201845
72
Answering Queries Using Views (Extended Abstract) 1995
PODS
0.00037421163
117
Querying Heterogeneous Information Sources Using Source Descriptions 1996
VLDB
0.00031526277
259
An Overview of Query Optimization in Relational Systems 1998
PODS
0.00022881075
419
PREFER: A System for the Efficient Execution of Multiparametric Ranked Queries 2001
SIGMOD
0.00018558415
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
654
Materialized Views In Oracle 1998
VLDB
0.00015096471
882
Rewriting Aggregate Queries Using Views 1999
PODS
0.00013239752
971
Recovering Information from Summary Data 1997
VLDB
0.00012748313
1,059
Answering Complex SQL Queries Using Automatic Summary Tables 2000
SIGMOD
0.00012224962
1,364
Design Considerations for High Fan-in Systems: The HiFi Approach 2005
CIDR
0.00010881397
1,550
Data Warehouse Configuration 1997
VLDB
0.00010257652
1,625
Mesa: Geo-Replicated, Near Real-Time, Scalable Data Warehousing 2014
VLDB
0.00010028153
1,736
Using Schematically Heterogeneous Structures 1998
SIGMOD
9.7450722e-05
1,779
Caching Multidimensional Queries Using Chunks 1998
SIGMOD
9.6641413e-05
2,043
Rewriting of Regular Expressions and Regular Path Queries 1999
PODS
9.1266211e-05
2,284
Deciding Equivalences among Aggregate Queries 1998
PODS
8.6880978e-05
2,301
Querying Aggregate Data 1999
PODS
8.6620636e-05
2,626
Cost-Based Optimization of Decision Support Queries using Transient-Views 1998
SIGMOD
8.1919956e-05
3,444
Complete Yet Practical Search for Minimal Query Reformulations Under Constraints 2014
SIGMOD
7.277762e-05
3,793
Supporting Ad-hoc Ranking Aggregates 2006
SIGMOD
6.9967739e-05
3,979
On Efficiently Implementing SchemaSQL on a SQL Database System 1999
VLDB
6.8700205e-05
4,246
On the Content of Materialized Aggregate Views 2000
PODS
6.694623e-05
5,028
User-Defined Aggregate Functions: Bridging Theory and Practice 2006
SIGMOD
6.2956973e-05
5,076
IncShrink: Architecting Efficient Outsourced Databases using Incremental MPC and Differential Privacy 2022
SIGMOD
6.2720607e-05
5,210
Crystal: A Unified Cache Storage System for Analytical Databases 2021
VLDB
6.2142008e-05
6,395
View Matching for Outer-Join Views 2005
VLDB
5.7850662e-05
7,288
Query Evaluation using Overlapping Views: Completeness and Efficiency 2006
SIGMOD
5.5489538e-05
7,305
Processing Star Queries on Hierarchically-Clustered Fact Tables 2002
VLDB
5.545323e-05
7,774
Snakes and Sandwiches: Optimal Clustering Strategies for a Data Warehouse 1999
SIGMOD
5.4386896e-05
9,166
Equivalence of Nested Queries with Mixed Semantics 2009
PODS
5.2031263e-05
9,827
ProvCite: Provenance-based Data Citation 2019
VLDB
5.108228e-05
11,967
High-dimensional Data Cubes 2022
VLDB
4.9605343e-05
13,235
Using LDAP Directory Caches 1999
PODS
4.9605343e-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