有值 无值 空值
下述情况是DB设计有缺陷的明确征兆:表的字段大多为空值,特别是某两个字段不可能同时有值。
关系模型的完备性(completeness)是以二值逻辑(two-valued logic)为基础的,记录要么存在、要么不存在。
As we know,there are known knowns.There are thins we know we know.We also know there are known unknowns.That is to say we know there are some things we do not know.But there are also unknown unknowns,the ones we don't know we don't know.
空值对程序逻辑是危险的;必须使用空值的话,一定要清除它在特定情况下的影响。