移行の時:NULLとBagなしでのクエリ
Time to Move On: Querying Without Nulls and Bags (arxiv.org)
要約
この論文は、データベースクエリ言語におけるNULL値とBag(重複を許す集合)の扱いに疑問を呈しています。SQLの成功の要因である宣言的な性質は維持しつつ、これらの概念が「避けられない悪」とされる理由を検証し、それらが完全に回避可能であると主張しています。NULLフリーでセットセマンティクスを持つ言語の利点と機会について論じています。
全文翻訳
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
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 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
[画像: license icon] view license
Additional Features
Current browse context:
cs.DB
Change to browse by:
References & Citations
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?)