Database Technology Nulls Considered Harmful(1st Edition)

Authors:

Chris Date

Type:Hardcover/ PaperBack / Loose Leaf
Condition: Used/New

In Stock: 2 Left

Shipment time

Expected shipping within 2 - 3 Days
Access to 35 Million+ Textbooks solutions Free
Ask Unlimited Questions from expert AI-Powered Answers 30 Min Free Tutoring Session
7 days-trial

Total Price:

$0

List Price: $43.43 Savings: $43.43 (100%)
Access to 30 Million+ solutions
Ask 50 Questions from expert AI-Powered Answers 24/7 Tutor Help Detailed solutions for Database Technology Nulls Considered Harmful

Price:

$9.99

/month

Book details

ISBN: 1634624769, 978-1634624763

Book publisher: Technics Publications

Offer Just for You!: Buy 2 books before the end of January and enter our lucky draw.

Book Price $0 : 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.