Analysis and impact
论文探讨数据库查询中去除 NULL 与多重集的设计取向
论文的核心论点指向关系数据库长期存在的两个设计妥协。NULL 自引入以来，一直是 SQL 查询中错误与混淆的常见来源：三值逻辑（TRUE/FALSE/UNKNOWN）使得 WHERE 子句的过滤行为变得不直观，聚合函数对 NULL 的处理规则也因实现而异。多重集则允许查询结果包含重复行，虽然在某些场景下能提升性能或简化实现，但破坏了关系代数中集合语义的纯粹性，迫使开发者额外使用 DISTINCT 或 GROUP BY 来修正结果。论文主张通过去除这两个特性，使查询语言在语义上更接近经典关系模型，减少意外行为。原文未提供论文作者的具体身份与所属机构信息。
从数据库理论的发展脉络看，这一主张并非首次提出。关系模型的奠基者 E.F. Codd 本人就曾对 NULL 的引入持保留态度，认为它是对关系模型完整性的妥协。后续的学术研究与工业实践中，Date 与 Darwen 等学者长期倡导更严格的关系语言设计，部分现代查询系统也在探索无 NULL 或集合语义优先的路径。不过，SQL 标准与主流数据库引擎出于向后兼容和实际工程考量，至今仍保留 NULL 与多重集支持，这使得相关讨论更多停留在理论层面与替代系统设计中。原文未提供论文是否涉及具体实现或实验评估的细节。
Hacker News 评论区尚未在素材中呈现具体讨论内容，仅显示该帖获得 37 点与 8 条评论。从标题与摘要判断，该论文面向数据库系统研究者与查询语言设计者，其价值在于为长期存在的语义问题提供一个系统性反思的切入点。对于普通开发者而言，理解 NULL 与多重集在 SQL 中的实际行为差异，仍是日常工作中规避查询陷阱的必要功课。
References
Original source text
-->
Computer Science > Databases
arXiv:2608.10863 (cs)
-
[Submitted on 11 Aug 2026]
Title: Time to Move on: Querying without Nulls and Bags
Authors: Molham Aref, Leonid Libkin, Wim Martens View a PDF of the paper titled Time to Move on: Querying without Nulls and Bags, by Molham Aref and Leonid Libkin and Wim Martens View PDF
Abstract: SQL is the database community's success story in terms of language design. The key reason for its success is its declarativeness: it gives rise to optimizability, reducing the programmer's burden significantly. However, given the evolving complexity of problems to solve with query languages, our community needs to re-think some of the fundamental early query language design decisions. Our experience in having worked on the design of Rel (a language for end-to-end relational programming) tells us that it is possible to design, implement, and successfully deploy a language based on fully normalized relations. Such relations avoid what Codd called corrupted relations and what we commonly refer to as bags, and the 'harmful' 'billion dollar mistake' that we know as nulls. In the SQL world, it is accepted that bags and nulls are tolerated as an unavoidable evil. We argue that the evil is completely avoidable: reasons offered for justifying bags and nulls evaporate at a closer examination. In addition to debunking them, we also describe opportunities offered by a null-free language with set semantics.
Subjects:
Databases (cs.DB) ; Programming Languages (cs.PL)
Cite as: arXiv:2608.10863 [cs.DB]
(or arXiv:2608.10863v1 [cs.DB] for this version)
https://doi.org/10.48550/arXiv.2608.10863
Focus to learn more
arXiv-issued DOI via DataCite
Submission history
From: Leonid Libkin [view email] [v1] Tue, 11 Aug 2026 12:34:39 UTC (105 KB)
Full-text links:
Access Paper:
View a PDF of the paper titled Time to Move on: Querying without Nulls and Bags, by Molham Aref and Leonid Libkin and Wim Martens
Current browse context:
cs.DB
| next >
Change to browse by:
References & Citations
- NASA ADS
-
export BibTeX citation Loading...
BibTeX formatted citation
×
loading...
Data provided by:
Bookmark
图片
图片
Bibliographic Tools
Bibliographic and Citation Tools
Bibliographic Explorer Toggle
Bibliographic Explorer (What is the Explorer?)
Connected Papers Toggle
Connected Papers (What is Connected Papers?)
Litmaps Toggle
Litmaps (What is Litmaps?)
scite.ai Toggle
scite Smart Citations (What are Smart Citations?)
Code, Data, Media
Code, Data and Media Associated with this Article
alphaXiv Toggle
alphaXiv (What is alphaXiv?)
Links to Code Toggle
CatalyzeX Code Finder for Papers (What is CatalyzeX?)
DagsHub Toggle
DagsHub (What is DagsHub?)
GotitPub Toggle
Gotit.pub (What is GotitPub?)
Huggingface Toggle
Hugging Face (What is Huggingface?)
ScienceCast Toggle
ScienceCast (What is ScienceCast?)
Demos
Demos
Replicate Toggle
Replicate (What is Replicate?)
Spaces Toggle
Hugging Face Spaces (What is Spaces?)
Spaces Toggle
TXYZ.AI (What is TXYZ.AI?)
Related Papers
Recommenders and Search Tools
Link to Influence Flower
Influence Flower (What are Influence Flowers?)
Core recommender toggle
CORE Recommender (What is CORE?)
Author
Venue
Institution
Topic
About arXivLabs
arXivLabs: experimental projects with community collaborators
arXivLabs is a framework that allows collaborators to develop and share new arXiv features directly on our website.
Both individuals and organizations that work with arXivLabs have embraced and accepted our values of openness, community, excellence, and user data privacy. arXiv is committed to these values and only works with partners that adhere to them.
Have an idea for a project that will add value for arXiv's community? Learn more about arXivLabs.
Which authors of this paper are endorsers? | Disable MathJax (What is MathJax?)