O'Reilly logo

Joe Celko's SQL for Smarties, 5th Edition by Joe Celko

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 9

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required