arrow
返回

Ontological Considerations When Modeling Missing Data With Relational Databases

delete2014-07-03
delete1
PRE
AI
C
Claude Rubinson *
DOI:10.1177/0894439314521988delete
delete原文链接
delete原文求助
delete分享
delete收藏
摘要

摘要

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总结

AI总结

对已上传原文的论文进行重点信息的提取,主要内容包括:简要概述、研究摘要、背景介绍、关键亮点、图文解析、展望与总结。

期刊

Computer Science Review 封面图
Computer Science Review
IF:
12.7
论文数:
2.3K
被引数:
5.2K

机构

暂无机构信息
引用论文

引用论文

Diffusion tensor imaging revealed different pathological processes of white matter hyperintensities
err2021-03-19
err0
errOAAI
errZhi-gang Min; Hai-rong Shan; Long Xu; Dai-hai Yuan; Xue-xia Sheng; Wen-chao Xie; Ming Zhang; Chen Niu; Tahir Mehmood Shakir; Zhi-hong Cao
err分享
err收藏
Diabetic Neuropathy and Gait: A Review
err2017-09-01
err0
errOAAI
errUazman Alam; David R. Riley; Ravinder S. Jugdey; Shazli Azmi; Satyan Rajbhandari; Kristiaan D’Août; Rayaz A. Malik
err分享
err收藏
err分享
err收藏
err
IF0
err
err0
PREAI
err
err分享
err收藏
没有更多内容