Efficient Exploitation of Similar Subexpressions for Query Processing
Summary: Light-weight detection of similar subexpressions to reuse results across queries/batches. Comprehensive solution: detection, construction, and cost-based optimization; covers batches, nested queries, and materialized views with speedups and low overhead. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Jingren Zhou (Microsoft)
- 2. Per-Ake Larson (Microsoft)
- 3. Johann-Christoph Freytag (Humboldt University of Berlin)
- 4. Wolfgang Lehner (Technical University of Dresden)
BibTeX Citation
@inproceedings{zhou_sigmod07,
title = {{Efficient Exploitation of Similar Subexpressions for Query Processing}},
author = {Zhou, Jingren and Larson, Per-Ake and Freytag, Johann-Christoph and Lehner, Wolfgang},
series = {{SIGMOD} '07},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/1247480.1247540},
url = {https://dl.acm.org/doi/10.1145/1247480.1247540},
year = {2007}
}
Incoming Citations (Sorted by Pagerank)
Showing 34 of 34 citing papers.
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 10 of 10 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 88 | Automated Selection of Materialized Views and Indexes for SQL Databases | 2000 | VLDB | 0.00035351639 |
| 129 | Efficient and Extensible Algorithms for Multi Query Optimization | 2000 | SIGMOD | 0.0003040756 |
| 155 | Common Expression Analysis in Database Applications | 1982 | SIGMOD | 0.00028527932 |
| 553 | Optimizing Queries Using Materialized Views: A Practical, Scalable Solution | 2001 | SIGMOD | 0.0001652591 |
| 744 | Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time | 1996 | SIGMOD | 0.00014309622 |
| 923 | Materialized View Selection and Maintenance Using Multi-Query Optimization | 2001 | SIGMOD | 0.00013064753 |
| 2,114 | Reusing Invariants: A New Strategy for Correlated Queries | 1998 | SIGMOD | 9.0158191e-05 |
| 2,619 | Cost-Based Optimization of Decision Support Queries using Transient-Views | 1998 | SIGMOD | 8.2215744e-05 |
| 4,093 | Optimizing Refresh of a Set of Materialized Views | 2005 | VLDB | 6.8115511e-05 |
| 6,804 | Stacked Indexed Views in Microsoft SQL Server | 2005 | SIGMOD | 5.6782614e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 923 | Materialized View Selection and Maintenance Using Multi-Query Optimization | 2001 | SIGMOD |
| 2 | 10,508 | Succinct Structure Representations for Efficient Query Optimization | 2026 | SIGMOD |
| 3 | 2,108 | Enhanced Subquery Optimizations in Oracle | 2009 | VLDB |
| 4 | 553 | Optimizing Queries Using Materialized Views: A Practical, Scalable Solution | 2001 | SIGMOD |
| 5 | 155 | Common Expression Analysis in Database Applications | 1982 | SIGMOD |
| 6 | 3,214 | Efficient and Provable Multi-Query Optimization | 2017 | PODS |
| 7 | 8,164 | Efficient Query Re-optimization with Judicious Subquery Selections | 2023 | SIGMOD |
| 8 | 552 | Orthogonal Optimization of Subqueries and Aggregation | 2001 | SIGMOD |
| 9 | 646 | Exploiting Statistics on Query Expressions for Optimization | 2002 | SIGMOD |
| 10 | 1,378 | Execution Strategies for SQL Subqueries | 2007 | SIGMOD |