SALE ON KIDS & YA BOOKS • COOL! SHOW ME

Close Notification

Your cart does not contain any items

Database Technology: Nulls Considered Harmful by Chris Date at Abbey's Bookshop,
Database Technology: Nulls Considered Harmful
— —
Chris Date

Database Technology

Nulls Considered Harmful

Chris Date

$83.95   $71.05

Paperback

Not in-store but you can order this
How long will it take?
English
Technics Publications
08 July 2024
Databases; Database design & theory; Data warehousing; Information architecture
"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."
By:  
Imprint:   Technics Publications
Dimensions:   Height: 235mm,  Width: 191mm,  Spine: 13mm
Weight:   431g
ISBN:   9781634624763
ISBN 10:   1634624769
Pages:   246
Publication Date:  
Audience:   General/trade ,  ELT Advanced
Format:   Paperback
Publisher's Status:   Active

See Also

Database Technology: Nulls Considered Harmful

Data Modeling Made Simple with erwin...

Jeff Harris

Paperback

$120.95  $96.76

Not in-store but you can order this

ADD +
Database Technology: Nulls Considered Harmful

SQL For Beginners SQL Made Easy...

Craig Berg

Paperback

$49.95  $42.83

Not in-store but you can order this

ADD +
Database Technology: Nulls Considered Harmful

The Analyst's Atlas

Navigating the Financial Data Sphere...

Manish Tomar

Paperback

$25.95  $22.93

Not in-store but you can order this

ADD +
Database Technology: Nulls Considered Harmful

Dashboarding with Tableau

Chandraish Sinha

Paperback

$52.95  $45.21

Not in-store but you can order this

ADD +
Database Technology: Nulls Considered Harmful

Data Mining

The Data Mining Guide for Beginners,...

Herbert Jones

Hardback

$32.95  $29.69

Not in-store but you can order this

ADD +
Database Technology: Nulls Considered Harmful

Data Science

What the Best Data Scientists Know...

Herbert Jones

Hardback

$32.95  $29.69

Not in-store but you can order this

ADD +