Essentially all truly general purpose database systems today are based on the relational model of data. That model was invented by E. F. (“Ted”) Codd in the late 1960s and early 1970s, during his employment at the IBM Research Laboratory in San Jose, California, and it was solidly based on conventional two-valued logic, 2VL. Unfortunately, those same general purpose database systems today all use the language SQL as their user language—and SQL is based not on 2VL but on what’s called three-valued logic, 3VL, instead, and uses what are called nulls to represent missing information. In fact, Codd himself subsequently extended his original model to support 3VL and nulls as well. (Actually, basing SQL on 3VL and adding 3VL to the relational model seem to have occurred in lockstep, as it were. Certainly both developments occurred at the same place—the IBM San Jose Research Laboratory—at more or less the same time.)

But 3VL is a disastrously bad basis on which to build databases, or database applications, or database languages. It’s bad because 3VL doesn’t behave the way reality behaves, which means that results that 3VL says are correct are often not correct in the real world. Not only that, but SQL’s implementation of 3VL is itself incorrect in places, which means it effectively adds another layer of wrong answers on top of the first. Bottom line:

If you have nulls in your database, you’re getting wrong answers.

This book explains this issue in detail. It also contains numerous practical suggestions for dealing with the problem.

About the Author

Chris Date has a stature that is unique in the database industry. He is best known for his textbook An Introduction to Database Systems (Addison-Wesley), which has sold close to a million copies at the time of writing. He enjoys a reputation that is second to none for his ability to explain complex technical issues in a clear and understandable fashion. He was inducted into the Computing Industry Hall of Fame in 2004.

"About this title" may belong to another edition of this title.

Store Description

We specialise in General Interest Books from South Asian countries.

Visit Seller's Storefront

Seller's business information

BOOKS AND PERIODICALS AGENCY LTD
90 Barnet Gate Lane, Barnet, EN5 2AX, United Kingdom

Sale & Shipping Terms

Terms of Sale

Returns accepted if you are not satisfied with the Service or Book.

Shipping Terms

Best packaging and fast delivery

Shipping rates from United Kingdom to U.S.A.

Shipping rates from United Kingdom to U.S.A.
Order quantity	14 to 45 business days	5 to 10 business days
First item	US$ 8.74	US$ 13.24

Delivery times are set by sellers and vary by carrier and location. Orders passing through Customs may face delays and buyers are responsible for any associated duties or fees. Sellers may contact you regarding additional charges to cover any increased costs to ship your items.