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.00016272161
Overall Rank
567 | 96.19%
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.00055043581
72
Answering Queries Using Views (Extended Abstract) 1995
PODS
0.00037549176
117
Querying Heterogeneous Information Sources Using Source Descriptions 1996
VLDB
0.00031630695
272
An Overview of Query Optimization in Relational Systems 1998
PODS
0.00022509573
418
PREFER: A System for the Efficient Execution of Multiparametric Ranked Queries 2001
SIGMOD
0.00018617842
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
648
Materialized Views In Oracle 1998
VLDB
0.00015151422
880
Rewriting Aggregate Queries Using Views 1999
PODS
0.00013280642
967
Recovering Information from Summary Data 1997
VLDB
0.00012794553
1,054
Answering Complex SQL Queries Using Automatic Summary Tables 2000
SIGMOD
0.00012269068
1,358
Design Considerations for High Fan-in Systems: The HiFi Approach 2005
CIDR
0.00010922626
1,547
Data Warehouse Configuration 1997
VLDB
0.00010292395
1,622
Mesa: Geo-Replicated, Near Real-Time, Scalable Data Warehousing 2014
VLDB
0.00010051462
1,728
Using Schematically Heterogeneous Structures 1998
SIGMOD
9.7779564e-05
1,764
Caching Multidimensional Queries Using Chunks 1998
SIGMOD
9.6965217e-05
2,041
Rewriting of Regular Expressions and Regular Path Queries 1999
PODS
9.1421879e-05
2,269
Deciding Equivalences among Aggregate Queries 1998
PODS
8.7196256e-05
2,289
Querying Aggregate Data 1999
PODS
8.6891266e-05
2,619
Cost-Based Optimization of Decision Support Queries using Transient-Views 1998
SIGMOD
8.2215744e-05
3,447
Complete Yet Practical Search for Minimal Query Reformulations Under Constraints 2014
SIGMOD
7.2941472e-05
3,782
Supporting Ad-hoc Ranking Aggregates 2006
SIGMOD
7.0230959e-05
3,960
On Efficiently Implementing SchemaSQL on a SQL Database System 1999
VLDB
6.8958644e-05
4,232
On the Content of Materialized Aggregate Views 2000
PODS
6.7145949e-05
5,012
User-Defined Aggregate Functions: Bridging Theory and Practice 2006
SIGMOD
6.3145331e-05
5,052
IncShrink: Architecting Efficient Outsourced Databases using Incremental MPC and Differential Privacy 2022
SIGMOD
6.2958492e-05
5,446
Crystal: A Unified Cache Storage System for Analytical Databases 2021
VLDB
6.1266228e-05
6,382
View Matching for Outer-Join Views 2005
VLDB
5.8066944e-05
7,266
Query Evaluation using Overlapping Views: Completeness and Efficiency 2006
SIGMOD
5.5699944e-05
7,285
Processing Star Queries on Hierarchically-Clustered Fact Tables 2002
VLDB
5.5662445e-05
7,755
Snakes and Sandwiches: Optimal Clustering Strategies for a Data Warehouse 1999
SIGMOD
5.4590631e-05
9,135
Equivalence of Nested Queries with Mixed Semantics 2009
PODS
5.2224867e-05
9,787
ProvCite: Provenance-based Data Citation 2019
VLDB
5.1276016e-05
11,917
High-dimensional Data Cubes 2022
VLDB
4.9793485e-05
13,188
Using LDAP Directory Caches 1999
PODS
4.9793485e-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