Troubles with Nulls, Views from the Users

Summary: An empirical survey of practitioners shows NULLs are ubiquitous and SQL's null-handling features cause real-world problems. It argues foundational nulls research misdirected, urging theory-practice bridging and a reorientation of data-management work. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 12750
Venue: VLDB
Year: 2022
Pagerank: 5.5373113e-05
Overall Rank: 5,388 | 62.52%
DOI: 10.14778/3551793.3551818

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 5 of 5 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
6,781	SQL Nulls and Two-Valued Logic	2023	PODS	4.927459e-05
8,404	On The Reasonable Effectiveness of Relational Diagrams: Explaining Relational Query Patterns and the Pattern Expressiveness of Relational Languages	2024	SIGMOD	4.5224126e-05
9,856	In-Database Data Imputation	2024	SIGMOD	4.269353e-05
9,989	On the Vexing Difficulty of Evaluating IN Predicates	2026	CIDR	4.1945683e-05
10,995	Understanding and Reusing Test Suites Across Database Systems	2024	SIGMOD	4.1945683e-05

Outgoing Citations (Sorted by Pagerank)

Showing 11 of 11 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
8	Extending the Data Base Relational Model to Capture More Meaning	1979	SIGMOD	0.0015385917
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
1,297	Incomplete Objects - A Data Model for Design and Planning Applications	1991	SIGMOD	0.00012758233
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
4,806	Uncertainty Annotated Databases - A Lightweight Approach for Approximating Certain Answers	2019	SIGMOD	5.9092698e-05
5,494	Incomplete Data: What Went Wrong, and How to Fix It	2014	PODS	5.4759469e-05
5,703	ACID: A System for Computing Approximate Certain Query Answers over Incomplete Databases	2018	SIGMOD	5.3643177e-05
5,857	Making SQL Queries Correct on Incomplete Databases: A Feasibility Study	2016	PODS	5.3000054e-05
8,803	Coping with Incomplete Data: Recent Advances	2020	PODS	4.4470842e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
12,957	A Sound and Complete Query Evaluation Algorithm for Relational Databases with Null Values	1988	SIGMOD	4.1945683e-05
5,494	Incomplete Data: What Went Wrong, and How to Fix It	2014	PODS	5.4759469e-05
6,710	Schema-free SQL	2014	SIGMOD	4.9526147e-05
4,499	Possible and Certain SQL Keys	2015	VLDB	6.1385333e-05
4,148	A Formal Semantics of SQL Queries, Its Validation, and Applications	2018	VLDB	6.4079361e-05
3,576	Closed World Databases Opened Through Null Values	1988	VLDB	6.9506798e-05
6,781	SQL Nulls and Two-Valued Logic	2023	PODS	4.927459e-05
963	Null Values in Data Base Management: A Denotational Semantics Approach	1979	SIGMOD	0.00014980053
5,857	Making SQL Queries Correct on Incomplete Databases: A Feasibility Study	2016	PODS	5.3000054e-05
528	Database Relations with Null Values (Extended Abstract)	1982	PODS	0.0002084153