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 |
|---|---|---|---|---|
| 15 | How Good Are Query Optimizers, Really? | 2016 | VLDB | 0.00061066921 |
| 24 | Data Integration: A Theoretical Perspective | 2002 | PODS | 0.00055043581 |
| 480 | Clio Grows Up: From Research Prototype to Industrial Tool | 2005 | SIGMOD | 0.00017608007 |
| 628 | Database Relations with Null Values (Extended Abstract) | 1982 | PODS | 0.0001544126 |
| 1,681 | The iBench Integration Metadata Generator | 2016 | VLDB | 9.8851118e-05 |
| 2,311 | STBenchmark: Towards a Benchmark for Mapping Systems | 2008 | VLDB | 8.6606108e-05 |
| 2,717 | Partial Results in Database Systems | 2014 | SIGMOD | 8.0980367e-05 |
| 3,558 | ++Spicy: an Open-Source Tool for Second-Generation Schema Mapping and Data Exchange | 2011 | VLDB | 7.2077064e-05 |
| 4,130 | On Relational Algebra With Marked Nulls | 1984 | PODS | 6.7896586e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 7,605 | Incomplete Information and Certain Answers in General Data Models | 2011 | PODS |
| 2 | 12,695 | Completeness of Queries over Incomplete Databases | 2011 | VLDB |
| 3 | 11,683 | Querying Incomplete Numerical Data: Between Certain and Possible Answers | 2023 | PODS |
| 4 | 1,418 | Null Values in Data Base Management: A Denotational Semantics Approach | 1979 | SIGMOD |
| 5 | 5,392 | Incomplete Data: What Went Wrong, and How to Fix It | 2014 | PODS |
| 6 | 3,718 | A Formal Semantics of SQL Queries, Its Validation, and Applications | 2018 | VLDB |
| 7 | 9,002 | Coping with Incomplete Data: Recent Advances | 2020 | PODS |
| 8 | 6,013 | SQL Nulls and Two-Valued Logic | 2023 | PODS |
| 9 | 5,507 | Troubles with Nulls, Views from the Users | 2022 | VLDB |
| 10 | 4,847 | Explaining Wrong Queries Using Small Examples | 2019 | SIGMOD |