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
Incoming Citations (Sorted by Pagerank)
Showing 2 of 2 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 9,986 | Database Research needs an Abstract Relational Query Language | 2026 | CIDR | 4.1945683e-05 |
| 9,989 | On the Vexing Difficulty of Evaluating IN Predicates | 2026 | CIDR | 4.1945683e-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 |
|---|---|---|---|---|
| 331 | The Ubiquity of Large Graphs and Surprising Challenges of Graph Processing | 2018 | VLDB | 0.00027214222 |
| 528 | Database Relations with Null Values (Extended Abstract) | 1982 | PODS | 0.0002084153 |
| 613 | Design and Implementation of the LogicBlox System | 2015 | SIGMOD | 0.00019181325 |
| 2,505 | Graph Pattern Matching in GQL and SQL/PGQ | 2022 | SIGMOD | 8.634551e-05 |
| 4,148 | A Formal Semantics of SQL Queries, Its Validation, and Applications | 2018 | VLDB | 6.4079361e-05 |
| 4,806 | Uncertainty Annotated Databases - A Lightweight Approach for Approximating Certain Answers | 2019 | SIGMOD | 5.9092698e-05 |
| 5,259 | On the Optimization of Recursive Relational Queries: Application to Graph Queries | 2020 | SIGMOD | 5.5984356e-05 |
| 5,388 | Troubles with Nulls, Views from the Users | 2022 | VLDB | 5.5373113e-05 |
| 5,857 | Making SQL Queries Correct on Incomplete Databases: A Feasibility Study | 2016 | PODS | 5.3000054e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 6,710 | Schema-free SQL | 2014 | SIGMOD | 4.9526147e-05 |
| 4,499 | Possible and Certain SQL Keys | 2015 | VLDB | 6.1385333e-05 |
| 3,576 | Closed World Databases Opened Through Null Values | 1988 | VLDB | 6.9506798e-05 |
| 4,759 | On Relational Algebra With Marked Nulls | 1984 | PODS | 5.9416104e-05 |
| 528 | Database Relations with Null Values (Extended Abstract) | 1982 | PODS | 0.0002084153 |
| 12,219 | When Data Dependencies over SQL Tables Meet the Logics of Paradox and S-3 | 2010 | PODS | 4.1945683e-05 |
| 5,857 | Making SQL Queries Correct on Incomplete Databases: A Feasibility Study | 2016 | PODS | 5.3000054e-05 |
| 963 | Null Values in Data Base Management: A Denotational Semantics Approach | 1979 | SIGMOD | 0.00014980053 |
| 5,388 | Troubles with Nulls, Views from the Users | 2022 | VLDB | 5.5373113e-05 |
| 4,148 | A Formal Semantics of SQL Queries, Its Validation, and Applications | 2018 | VLDB | 6.4079361e-05 |