O'Reilly Open Source Convention
Books Safari Bookshelf Conferences O'Reilly Network

Arrow Home
Arrow Registration
Arrow Speakers
Arrow Keynotes
Arrow Tutorials
Arrow Sessions
Arrow At-a-Glance
Arrow Wiki
Arrow BOFs
Arrow Events
Arrow Exhibitors
Arrow Sponsors
Arrow Hotel/Travel
Arrow Venue Map
Arrow See & Do
Arrow Tips for
Arrow Press
Arrow Mail List



Why Data Stinks
Joe Celko, Professor, Northface University

Track: Emerging Topics
Date: Wednesday, July 28
Time: 2:35pm - 3:20pm
Location: Mt. Hood


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.