An Approach to Representing Non-Applicable Data in Relational Databases

 

By filling out this or any DATAVERSITY® form, as applicable by local privacy laws, you agree to receive marketing e-mail notifications from DATAVERSITY, listed sponsors, and listed partners. Just click the “unsubscribe” or "Manage Your Email Subscriptions" link in any e-mail to unsubscribe.

Sponsored by:

About the Paper

Much has been written and debated about the use of SQL NULLs to represent unknown values, and the possible use of three-valued logic.  However, there has never been a systematic application of any three-valued logic to use in the logical expressions of computer programs.  This paper lays the foundation for a systematic application of three-valued logic to one of the two problems inadequately addressed by SQL NULLs.

Data Education for Business and IT Professionals