Session Why Data Stinks Joe Celko, Professor, Northface University Track: Emerging Topics Date: Wednesday, July 28 Time: 2:35pm - 3:20pm Location: Mt. Hood TrackBack Celko looks at how data in a database goes bad and what can be done about it, specifically: 1. Picking data types 1.1. Failure to use the right data type 1.2. Failure to check the data in the DB 2. SQL is not computational 2.1. Computed columns 2.2. Redundant computations 3. Reasonableness and statisti4cs 3.1. Ev Op and other stat tricks 4. Validation - internal 4.1. Check digits 4.2. grep() and syntax 4.3. cross references 5. Validation - external 5.1. Trusted sources 5.2. Degrees of trust 6. "We cannot change the schema" 6.1. but you can fail, kill people, or go to jail 6.2. Horror stories

---

O'Reilly Home | Privacy Policy

© 2004, O'Reilly Media, Inc.