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
8545
Venue
VLDB
Year
1996
Pagerank
0.00016580778
Overall Rank
554 | 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
22
Data Integration: A Theoretical Perspective 2002
PODS
0.00056204792
69
Answering Queries Using Views (Extended Abstract) 1995
PODS
0.00038090878
117
Querying Heterogeneous Information Sources Using Source Descriptions 1996
VLDB
0.00032192665
290
An Overview of Query Optimization in Relational Systems 1998
PODS
0.0002227038
407
PREFER: A System for the Efficient Execution of Multiparametric Ranked Queries 2001
SIGMOD
0.00019021441
552
Extending Query Rewriting Techniques for Fine-Grained Access Control 2004
SIGMOD
0.00016630306
559
Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001
SIGMOD
0.00016528822
643
Materialized Views In Oracle 1998
VLDB
0.00015372449
869
Rewriting Aggregate Queries Using Views 1999
PODS
0.00013503594
952
Recovering Information from Summary Data 1997
VLDB
0.00013010681
1,034
Answering Complex SQL Queries Using Automatic Summary Tables 2000
SIGMOD
0.00012516197
1,322
Design Considerations for High Fan-in Systems: The HiFi Approach 2005
CIDR
0.00011155403
1,543
Data Warehouse Configuration 1997
VLDB
0.00010413384
1,606
Mesa: Geo-Replicated, Near Real-Time, Scalable Data Warehousing 2014
VLDB
0.00010228576
1,708
Using Schematically Heterogeneous Structures 1998
SIGMOD
9.958846e-05
1,732
Caching Multidimensional Queries Using Chunks 1998
SIGMOD
9.9065981e-05
2,066
Rewriting of Regular Expressions and Regular Path Queries 1999
PODS
9.2348082e-05
2,238
Deciding Equivalences among Aggregate Queries 1998
PODS
8.8882317e-05
2,305
Querying Aggregate Data 1999
PODS
8.7766218e-05
2,593
Cost-Based Optimization of Decision Support Queries using Transient-Views 1998
SIGMOD
8.3649196e-05
3,392
Complete Yet Practical Search for Minimal Query Reformulations Under Constraints 2014
SIGMOD
7.4515019e-05
3,706
Supporting Ad-hoc Ranking Aggregates 2006
SIGMOD
7.1819534e-05
3,889
On Efficiently Implementing SchemaSQL on a SQL Database System 1999
VLDB
7.0440224e-05
4,155
On the Content of Materialized Aggregate Views 2000
PODS
6.866935e-05
4,896
User-Defined Aggregate Functions: Bridging Theory and Practice 2006
SIGMOD
6.4548696e-05
4,930
IncShrink: Architecting Efficient Outsourced Databases using Incremental MPC and Differential Privacy 2022
SIGMOD
6.4402718e-05
5,348
Crystal: A Unified Cache Storage System for Analytical Databases 2021
VLDB
6.2562688e-05
6,256
View Matching for Outer-Join Views 2005
VLDB
5.9398047e-05
7,121
Query Evaluation using Overlapping Views: Completeness and Efficiency 2006
SIGMOD
5.6969248e-05
7,162
Processing Star Queries on Hierarchically-Clustered Fact Tables 2002
VLDB
5.6851725e-05
7,612
Snakes and Sandwiches: Optimal Clustering Strategies for a Data Warehouse 1999
SIGMOD
5.5834218e-05
8,971
Equivalence of Nested Queries with Mixed Semantics 2009
PODS
5.3420194e-05
10,077
ProvCite: Provenance-based Data Citation 2019
VLDB
5.1603976e-05
11,609
High-dimensional Data Cubes 2022
VLDB
5.093636e-05
12,898
Using LDAP Directory Caches 1999
PODS
5.093636e-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