TY - GEN
T1 - Reasoning in the presence of NULLs
AU - Neumann, Thomas
N1 - Publisher Copyright:
© 2018 IEEE.
PY - 2018/10/24
Y1 - 2018/10/24
N2 - NULL values offer an explicit way to model missing, unknown or invalid values in a database. While having such an explicitly value is convenient, the resulting semantic is unfortunately often surprising. Furthermore, there seem to be cases where the desired semantic is unclear, and different systems produce different results. This paper highlights some of the problematic cases and argues for a literal interpretation of the SQL UNKNOWN.
AB - NULL values offer an explicit way to model missing, unknown or invalid values in a database. While having such an explicitly value is convenient, the resulting semantic is unfortunately often surprising. Furthermore, there seem to be cases where the desired semantic is unclear, and different systems produce different results. This paper highlights some of the problematic cases and argues for a literal interpretation of the SQL UNKNOWN.
KW - NULL
KW - query optimization
UR - http://www.scopus.com/inward/record.url?scp=85057080152&partnerID=8YFLogxK
U2 - 10.1109/ICDE.2018.00214
DO - 10.1109/ICDE.2018.00214
M3 - Conference contribution
AN - SCOPUS:85057080152
T3 - Proceedings - IEEE 34th International Conference on Data Engineering, ICDE 2018
SP - 1682
EP - 1683
BT - Proceedings - IEEE 34th International Conference on Data Engineering, ICDE 2018
PB - Institute of Electrical and Electronics Engineers Inc.
T2 - 34th IEEE International Conference on Data Engineering, ICDE 2018
Y2 - 16 April 2018 through 19 April 2018
ER -