Upload

Loading icon Loading...

This video is unavailable.

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

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to like tcation's video.

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to dislike tcation's video.

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to add tcation's video to your playlist.

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 icon Loading...

Loading icon Loading...

Loading icon Loading...

The interactive transcript could not be loaded.

Loading icon Loading...

Loading icon 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.

Loading icon Loading...

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

Add to