Part 1. History, Standards, and Designing Data
The first of this book discusses the principles of designing data encoding schemes and some of the history of standardization. This second part will give examples of actual standards used in a variety of industries.
In the first six chapters, I look at the foundations from the view point of a database designer who needs some understanding of the how and why.
I find it odd that database designers are very physical about their data and do not work with many abstractions. They were never taught the theory of scales and measurements. They have only a minimal knowledge of validation, verification, and risk of error as a part of the data.
Check digit algorithms are taught as single “programming tricks” in ...

Get Joe Celko's Data, Measurements and Standards in SQL now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.