DDL Flaws to Avoid
Abstract
Having tools is the same as knowing how to use them. This is a discussion of common errors.
Keywords
Tibbling
ISO-11179 Standards
Attribute splitting
Overloading
Non-normal form redundancy
Conflicting relationships
Now we have the basic tools to build the DDL we need for a schema. But having tools is the same as knowing how to use them. Ask anyone who has tried to do his own plumbing.
9.1 Tibbling and Related Errors
Back in the days of punch cards and magnetic tapes, identifiers were short and had to carry metadata for the simple compilers and repeating systems. The classic example was FORTRAN I and FORTRAN II. They were languages based on algebra and used GOTO statements for process flow control. They ...
Get Joe Celko's SQL for Smarties, 5th Edition 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.
