Equivalence of SQL Queries In Presence of Embedded Dependencies
Summary: Equivalence tests for CQ/SPJ queries under bag and bag-set semantics with embedded dependencies, assuming set-chase termination. Sound-and-complete algorithms (when set-chase terminates) for minimal-size reformulation and grouped/aggregate queries, enabling dependency-aware and view-based rewrites. (summarized by gpt-5-mini on Feb 09 2026)
Incoming Non-self Citations Over Time
No non-self incoming citations found for this paper in this database.
Authors
- 1. Rada Chirkova (North Carolina State University)
- 2. Michael R. Genesereth (Stanford University)
BibTeX Citation
@inproceedings{chirkova_pods09,
address = {New York, NY, USA},
series = {{PODS} '09},
title = {{Equivalence of SQL Queries In Presence of Embedded Dependencies}},
url = {https://dl.acm.org/doi/10.1145/1559795.1559829},
doi = {10.1145/1559795.1559829},
booktitle = {Proceedings of the {ACM} {SIGMOD} Symposium on {Principles} of {Database} {Systems}},
publisher = {Association for Computing Machinery},
author = {Chirkova, Rada and Genesereth, Michael R.},
year = {2009}
}Incoming Citations (Sorted by Pagerank)
Showing 0 of 0 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 9 of 9 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 72 | Answering Queries Using Views (Extended Abstract) | 1995 | PODS | 0.00037549176 |
| 310 | Optimization of Real Conjunctive Queries | 1993 | PODS | 0.00021374145 |
| 532 | Answering Recursive Queries Using Views | 1997 | PODS | 0.0001682881 |
| 539 | The Chase Revisited | 2008 | PODS | 0.00016735847 |
| 880 | Rewriting Aggregate Queries Using Views | 1999 | PODS | 0.00013280642 |
| 1,275 | The Containment Problem for Real Conjunctive Queries with Inequalities | 2006 | PODS | 0.00011242154 |
| 2,269 | Deciding Equivalences among Aggregate Queries | 1998 | PODS | 8.7196256e-05 |
| 5,187 | Equivalence of Queries Combining Set and Bag-Set Semantics | 2006 | PODS | 6.2371772e-05 |
| 7,266 | Query Evaluation using Overlapping Views: Completeness and Efficiency | 2006 | SIGMOD | 5.5699944e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 1,680 | Axiomatic Foundations and Algorithms for Deciding Semantic Equivalences of SQL Queries | 2018 | VLDB |
| 2 | 10,115 | Semantic Acyclicity Under Constraints | 2016 | PODS |
| 3 | 1,275 | The Containment Problem for Real Conjunctive Queries with Inequalities | 2006 | PODS |
| 4 | 7,266 | Query Evaluation using Overlapping Views: Completeness and Efficiency | 2006 | SIGMOD |
| 5 | 10,130 | Bag Semantics Conjunctive Query Containment. Four Small Steps Towards Undecidability. | 2024 | PODS |
| 6 | 10,392 | Bag Semantics Query Containment: The CQ vs. UCQ Case and Other Stories | 2026 | PODS |
| 7 | 4,459 | Semantic Query Optimization in the Presence of Types | 2010 | PODS |
| 8 | 9,135 | Equivalence of Nested Queries with Mixed Semantics | 2009 | PODS |
| 9 | 2,269 | Deciding Equivalences among Aggregate Queries | 1998 | PODS |
| 10 | 5,187 | Equivalence of Queries Combining Set and Bag-Set Semantics | 2006 | PODS |