SQL Nulls and Two-Valued Logic
Summary: Shows SQL's 3VL for NULLs can be replaced by an equally expressive 2VL by conflating unknown with false for null-involving conditions (core SQL:1999). Provides efficient translation to standard DBMS, enables optimizations, characterizes when 2VL/3VL coincide, and reports benchmark analysis plus a user-study preference for 2VL. (summarized by gpt-5-mini on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Leonid Libkin (RelationalAI; University of Edinburgh; École Normale Supérieure (Paris Sciences et Lettres University))
- 2. Liat Peterfreund (Gustave Eiffel University; National Centre for Scientific Research)
BibTeX Citation
@inproceedings{libkin_pods23,
address = {New York, NY, USA},
series = {{PODS} '23},
title = {{SQL Nulls and Two-Valued Logic}},
url = {https://dl.acm.org/doi/10.1145/3584372.3588661},
doi = {10.1145/3584372.3588661},
booktitle = {Proceedings of the {ACM} {SIGMOD} Symposium on {Principles} of {Database} {Systems}},
publisher = {Association for Computing Machinery},
author = {Libkin, Leonid and Peterfreund, Liat},
year = {2023}
}Incoming Citations (Sorted by Pagerank)
Showing 4 of 4 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 10,354 | Database Research needs an Abstract Relational Query Language | 2026 | CIDR | 4.9793485e-05 |
| 10,357 | On the Vexing Difficulty of Evaluating IN Predicates | 2026 | CIDR | 4.9793485e-05 |
| 10,877 | Window Function Optimization: Co-Evaluation and Other Techniques | 2026 | VLDB | 4.9793485e-05 |
| 11,033 | An Extended Tutorial and Vocabulary for Relational Language Design in an Era of AI-Assisted Query Generation | 2026 | VLDB | 4.9793485e-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 |
|---|---|---|---|---|
| 239 | The Ubiquity of Large Graphs and Surprising Challenges of Graph Processing | 2018 | VLDB | 0.000235107 |
| 466 | Design and Implementation of the LogicBlox System | 2015 | SIGMOD | 0.00017773029 |
| 628 | Database Relations with Null Values (Extended Abstract) | 1982 | PODS | 0.0001544126 |
| 1,494 | Graph Pattern Matching in GQL and SQL/PGQ | 2022 | SIGMOD | 0.00010502195 |
| 3,718 | A Formal Semantics of SQL Queries, Its Validation, and Applications | 2018 | VLDB | 7.0721776e-05 |
| 4,868 | Uncertainty Annotated Databases - A Lightweight Approach for Approximating Certain Answers | 2019 | SIGMOD | 6.3748367e-05 |
| 5,050 | On the Optimization of Recursive Relational Queries: Application to Graph Queries | 2020 | SIGMOD | 6.2976106e-05 |
| 5,507 | Troubles with Nulls, Views from the Users | 2022 | VLDB | 6.1009808e-05 |
| 5,802 | Making SQL Queries Correct on Incomplete Databases: A Feasibility Study | 2016 | PODS | 5.989635e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 6,724 | Schema-free SQL | 2014 | SIGMOD |
| 2 | 4,342 | Possible and Certain SQL Keys | 2015 | VLDB |
| 3 | 3,813 | Closed World Databases Opened Through Null Values | 1988 | VLDB |
| 4 | 4,130 | On Relational Algebra With Marked Nulls | 1984 | PODS |
| 5 | 628 | Database Relations with Null Values (Extended Abstract) | 1982 | PODS |
| 6 | 12,705 | When Data Dependencies over SQL Tables Meet the Logics of Paradox and S-3 | 2010 | PODS |
| 7 | 5,802 | Making SQL Queries Correct on Incomplete Databases: A Feasibility Study | 2016 | PODS |
| 8 | 1,418 | Null Values in Data Base Management: A Denotational Semantics Approach | 1979 | SIGMOD |
| 9 | 5,507 | Troubles with Nulls, Views from the Users | 2022 | VLDB |
| 10 | 3,718 | A Formal Semantics of SQL Queries, Its Validation, and Applications | 2018 | VLDB |