Re: Deadly sins againts database performance/scalability

Daniel Morgan <damorgan_at_x.washington.edu> wrote

> Developers that seem incapable of understanding the basics of
> normalization and data integrity.

Amen to that.

> Again, today, I've been called into look at a database in which it is
> impossible to connect related events.
>
> Example:
> 1. Cases have a case number
> 2. Citations have a case number and a citation number
> 3. Fees paid for citations have a case number and a payment number

Almost the exact same problem here (dealing with billing issues and tariffs).

I'm still amazed at the "logic" employed to design relationships like that.

> If you can't see what's wrong ... you're part of the problem. ;-)

Yeah.. and requires liberal application of the old lead pipe to correct the problem.

--
Billy