Upload

Loading...

This video is unavailable.

Chris Date talks about "The Problem of Missing Information" at OUG Harmony 2012 in Finland

Want to watch this again later?

Sign in to add this video to a playlist.

Like this video?

Sign in to make your opinion count.

Don't like this video?

Sign in to make your opinion count.

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Ratings have been disabled for this video.
Rating is available when the video has been rented.
This feature is not available right now. Please try again later.

Published on Jun 19, 2012

Date describes the three-valued logic approach to missing information ("nulls") in depth. Both the underlying theory and SQL's attempt to implement that theory will be described. In particular, Date will show why the approach is a disastrously bad one and will sketch an alternative and logically sounder approach. Topic outline:
 Types of null
 UNK, unk, and three-valued logic (3VL)
 Consequences of the 3VL approach
 SQL's implementation of 3VL
 Outer join
 Further thoughts
 So what can we do?

Loading...

Loading...
Working...
to add this to Watch Later

Add to