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
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 |
|---|---|---|---|---|
| 82 | Answering Queries Using Views (Extended Abstract) | 1995 | PODS | 0.00054430106 |
| 335 | Optimization of Real Conjunctive Queries | 1993 | PODS | 0.00027012705 |
| 533 | Answering Recursive Queries Using Views | 1997 | PODS | 0.00020767726 |
| 695 | The Chase Revisited | 2008 | PODS | 0.00018013323 |
| 971 | Rewriting Aggregate Queries Using Views | 1999 | PODS | 0.00014915911 |
| 1,520 | The Containment Problem for Real Conjunctive Queries with Inequalities | 2006 | PODS | 0.00011524911 |
| 2,105 | Deciding Equivalences among Aggregate Queries | 1998 | PODS | 9.5309231e-05 |
| 5,196 | Equivalence of Queries Combining Set and Bag-Set Semantics | 2006 | PODS | 5.6311982e-05 |
| 6,884 | Query Evaluation using Overlapping Views: Completeness and Efficiency | 2006 | SIGMOD | 4.8917858e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 2,097 | Axiomatic Foundations and Algorithms for Deciding Semantic Equivalences of SQL Queries | 2018 | VLDB | 9.5439744e-05 |
| 11,837 | Semantic Acyclicity Under Constraints | 2016 | PODS | 4.1905499e-05 |
| 1,520 | The Containment Problem for Real Conjunctive Queries with Inequalities | 2006 | PODS | 0.00011524911 |
| 6,884 | Query Evaluation using Overlapping Views: Completeness and Efficiency | 2006 | SIGMOD | 4.8917858e-05 |
| 9,794 | Bag Semantics Conjunctive Query Containment. Four Small Steps Towards Undecidability. | 2024 | PODS | 4.2777144e-05 |
| 10,001 | Bag Semantics Query Containment: The CQ vs. UCQ Case and Other Stories | 2026 | PODS | 4.1905499e-05 |
| 2,732 | Semantic Query Optimization in the Presence of Types | 2010 | PODS | 8.2137395e-05 |
| 8,699 | Equivalence of Nested Queries with Mixed Semantics | 2009 | PODS | 4.4604187e-05 |
| 2,105 | Deciding Equivalences among Aggregate Queries | 1998 | PODS | 9.5309231e-05 |
| 5,196 | Equivalence of Queries Combining Set and Bag-Set Semantics | 2006 | PODS | 5.6311982e-05 |