返回
Ontological Considerations When Modeling Missing Data With Relational Databases
DOI:10.1177/0894439314521988.png)
摘要
En 中文
SQL's use of nulls to indicate missing data in relational databases has been criticized as violating the relational model. In this article, I review this critique and two popular recommendations of resolution. The first is to retire SQL's multivalued logic and replace it with a conventional binary logic. The second is to revise SQL's implementation of multivalued logic so that it can recognize tautological propositions. I argue that underlying this debate is an ontological disagreement about how to properly model missing data and, more generally, social reality. I demonstrate that the relational model provides useful tools for modeling different types of missing data in different ways and, furthermore, offers a useful foundation upon which to conduct social research, one that supports both variable-oriented and case-oriented analysis.
Keyword:
relational databases
SQL
nulls
missing data
AI总结
对已上传原文的论文进行重点信息的提取,主要内容包括:简要概述、研究摘要、背景介绍、关键亮点、图文解析、展望与总结。
期刊
IF:
12.7
论文数:
2.3K
被引数:
5.2K
机构
暂无机构信息
引用论文
没有更多内容

