Making SQL Queries Correct on Incomplete Databases: A Feasibility Study
Summary: Empirically demonstrates that standard SQL semantics over NULLs frequently yields incorrect answers on real workloads (TPC-H), especially for queries with negation. Proposes a novel FO-query rewriting that computes certain answers efficiently in practice, fixing prior impractical methods with modest overhead and no loss of correct results. (summarized by gpt-5-mini on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
Incoming Citations (Sorted by Pagerank)
Showing 10 of 10 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 4,150 | A Formal Semantics of SQL Queries, Its Validation, and Applications | 2018 | VLDB | 6.4022639e-05 |
| 4,271 | Cleaning Denial Constraint Violations through Relaxation | 2020 | SIGMOD | 6.2943273e-05 |
| 4,809 | Uncertainty Annotated Databases - A Lightweight Approach for Approximating Certain Answers | 2019 | SIGMOD | 5.9035874e-05 |
| 5,393 | Troubles with Nulls, Views from the Users | 2022 | VLDB | 5.5319929e-05 |
| 5,714 | ACID: A System for Computing Approximate Certain Query Answers over Incomplete Databases | 2018 | SIGMOD | 5.3591645e-05 |
| 6,781 | SQL Nulls and Two-Valued Logic | 2023 | PODS | 4.9227317e-05 |
| 7,435 | Schema Mappings for Data Graphs | 2017 | PODS | 4.7265981e-05 |
| 7,944 | Efficient Uncertainty Tracking for Complex Queries with Attribute-level Bounds | 2021 | SIGMOD | 4.6089395e-05 |
| 8,802 | Coping with Incomplete Data: Recent Advances | 2020 | PODS | 4.4428211e-05 |
| 9,044 | Efficient Approximation of Certain and Possible Answers for Ranking and Window Queries over Uncertain Data | 2023 | VLDB | 4.3997447e-05 |
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 |
|---|---|---|---|---|
| 47 | Data Integration: A Theoretical Perspective | 2002 | PODS | 0.00069691761 |
| 71 | How Good Are Query Optimizers, Really? | 2016 | VLDB | 0.00059446482 |
| 483 | Clio Grows Up: From Research Prototype to Industrial Tool | 2005 | SIGMOD | 0.00022101908 |
| 529 | Database Relations with Null Values (Extended Abstract) | 1982 | PODS | 0.00020825533 |
| 1,885 | The iBench Integration Metadata Generator | 2016 | VLDB | 0.00010206139 |
| 2,641 | STBenchmark: Towards a Benchmark for Mapping Systems | 2008 | VLDB | 8.3968228e-05 |
| 3,054 | Partial Results in Database Systems | 2014 | SIGMOD | 7.6478475e-05 |
| 3,835 | ++Spicy: an Open-Source Tool for Second-Generation Schema Mapping and Data Exchange | 2011 | VLDB | 6.7129526e-05 |
| 4,757 | On Relational Algebra With Marked Nulls | 1984 | PODS | 5.9358967e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 7,391 | Incomplete Information and Certain Answers in General Data Models | 2011 | PODS | 4.7383385e-05 |
| 12,217 | Completeness of Queries over Incomplete Databases | 2011 | VLDB | 4.1905499e-05 |
| 11,164 | Querying Incomplete Numerical Data: Between Certain and Possible Answers | 2023 | PODS | 4.1905499e-05 |
| 965 | Null Values in Data Base Management: A Denotational Semantics Approach | 1979 | SIGMOD | 0.00014965054 |
| 5,508 | Incomplete Data: What Went Wrong, and How to Fix It | 2014 | PODS | 5.4706858e-05 |
| 4,150 | A Formal Semantics of SQL Queries, Its Validation, and Applications | 2018 | VLDB | 6.4022639e-05 |
| 8,802 | Coping with Incomplete Data: Recent Advances | 2020 | PODS | 4.4428211e-05 |
| 6,781 | SQL Nulls and Two-Valued Logic | 2023 | PODS | 4.9227317e-05 |
| 5,393 | Troubles with Nulls, Views from the Users | 2022 | VLDB | 5.5319929e-05 |
| 5,743 | Explaining Wrong Queries Using Small Examples | 2019 | SIGMOD | 5.3432106e-05 |