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
- 1. Paolo Guagliardo (University of Edinburgh)
- 2. Leonid Libkin (University of Edinburgh)
BibTeX Citation
@inproceedings{guagliardo_pods16,
address = {New York, NY, USA},
series = {{PODS} '16},
title = {{Making SQL Queries Correct on Incomplete Databases: A Feasibility Study}},
url = {https://dl.acm.org/doi/10.1145/2902251.2902297},
doi = {10.1145/2902251.2902297},
booktitle = {Proceedings of the {ACM} {SIGMOD} Symposium on {Principles} of {Database} {Systems}},
publisher = {Association for Computing Machinery},
author = {Guagliardo, Paolo and Libkin, Leonid},
year = {2016}
}Incoming Citations (Sorted by Pagerank)
Showing 11 of 11 citing papers.
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 |
|---|---|---|---|---|
| 18 | How Good Are Query Optimizers, Really? | 2016 | VLDB | 0.00059284255 |
| 22 | Data Integration: A Theoretical Perspective | 2002 | PODS | 0.00056204792 |
| 469 | Clio Grows Up: From Research Prototype to Industrial Tool | 2005 | SIGMOD | 0.00017973925 |
| 613 | Database Relations with Null Values (Extended Abstract) | 1982 | PODS | 0.00015723523 |
| 1,652 | The iBench Integration Metadata Generator | 2016 | VLDB | 0.00010109142 |
| 2,256 | STBenchmark: Towards a Benchmark for Mapping Systems | 2008 | VLDB | 8.8578542e-05 |
| 2,663 | Partial Results in Database Systems | 2014 | SIGMOD | 8.2818137e-05 |
| 3,487 | ++Spicy: an Open-Source Tool for Second-Generation Schema Mapping and Data Exchange | 2011 | VLDB | 7.3687386e-05 |
| 4,032 | On Relational Algebra With Marked Nulls | 1984 | PODS | 6.9453392e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 7,462 | Incomplete Information and Certain Answers in General Data Models | 2011 | PODS |
| 2 | 12,404 | Completeness of Queries over Incomplete Databases | 2011 | VLDB |
| 3 | 11,367 | Querying Incomplete Numerical Data: Between Certain and Possible Answers | 2023 | PODS |
| 4 | 1,380 | Null Values in Data Base Management: A Denotational Semantics Approach | 1979 | SIGMOD |
| 5 | 5,271 | Incomplete Data: What Went Wrong, and How to Fix It | 2014 | PODS |
| 6 | 3,925 | A Formal Semantics of SQL Queries, Its Validation, and Applications | 2018 | VLDB |
| 7 | 8,837 | Coping with Incomplete Data: Recent Advances | 2020 | PODS |
| 8 | 6,950 | SQL Nulls and Two-Valued Logic | 2023 | PODS |
| 9 | 5,378 | Troubles with Nulls, Views from the Users | 2022 | VLDB |
| 10 | 4,759 | Explaining Wrong Queries Using Small Examples | 2019 | SIGMOD |