Database Technology: Nulls Considered Harmful - Image 1

£41.95

Technics Publications Database Technology: Nulls Considered Harmful

Name: Database Technology: Nulls Considered Harmful
Brand: Technics Publications
Price: 41.95 GBP
Availability: InStock

Data Warehousing

About as cheap as it gets. The only time it was cheaper was 2 months ago.

£42 today · all-time low £42 (Mar 2026) · usually the usual

NEW HERE?

Amazon shows you one price. We show you all of them.

Tosheroon watches Amazon prices so you don't have to. Every product on Amazon has a price history — we make it visible. Set the price you'd actually pay, and we'll email you the second it gets there. No app, no account, one email.

WHAT'S ON THIS PAGE

↓ Price chart
when this has been cheap or pricey

↓ Forecast
where the price is heading next

↓ Statistics
all-time high & low, recent range

↑ Price alert
name your number, we'll email you

Price History & Forecast

Grey patches = out of stock. Cheaper = lower on the chart. Hover for exact prices.

Last 48 days • 48 data points (No recent data available)

Historical

Generating forecast...

Price Distribution

Price distribution over 48 days • 1 price levels

Days at Price

Price Analysis

Most common price: £42 (48 days, 100.0%)

Price range: £42 - £42

Price levels: 1 different prices over 48 days

Description

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.

Product Specifications

Brand: Technics Publications
Format: paperback
ASIN: 1634624769
Category: Books > Subjects > Computing & Internet > Databases > Data Storage & Management > Data Warehousing
Domain: Amazon UK
Release Date: 08 July 2024
Listed Since: 03 July 2024

Barcode

No barcode data available

Technics Publications Database Technology: Nulls Considered Harmful

About as cheap as it gets. The only time it was cheaper was 2 months ago.

Price History & Forecast

Price Distribution

Price Analysis

Description

Product Specifications

Barcode

Similar Products You Might Like

Relational Database and Transact SQL Second Edition

Simple SQL: Beginner’s Guide To Master SQL And Boost Career (Zero To Hero)

26 Dominios con Ejercicios de SQL: 270 Consultas de SQL de nivel avanzado

SQL The Complete Reference, 3rd Edition

Database Systems: A Practical Approach to Design, Implementation, and Management, Global Edition

Datenbanken im Unternehmen: Analyse, Modellbildung Und Einsatz (Lehrbücher Wirtschaftsinformatik)

26 Domeinu SQL Ariketekin: Maila aurreratuko 270 SQL kontsulta

Springer Applications of Logic Databases: 296 - Computer Science

SQL & NoSQL Databases: Models, Languages, Consistency Options and Architectures for Big Data Management

Real World SQL and PL/SQL: Advice from the Experts (DATABASE & ERP - OMG)

SQL Bible: 742

Relational Database And SQL: Third Edition

Murach's SQL Server 2022 for Developers

Database Design and Relational Theory: Normal Forms and All That Jazz

Pro SQL Server Relational Database Design and Implementation: Best Practices for Scalability and Performance

SQL for eServer i5 and iSeries

SQL in a Nutshell: A Desktop Quick Reference

Databases and Transaction Processing:An Application-Oriented Approach with Learning SQL:A Step-By-Step Guide Using Oracle

Database Development and Management (Foundations of Database Design)

Head First SQL (A Brain Friendly Guide)

SQL: The Practical Guide

Murach's MySQL (4th Edition): Training & Reference

Methods and Supporting Technologies for Data Analysis: 225 (Studies in Computational Intelligence, 225)

A Guide to SQL (Mindtap Course List)