From: | Joshua Daniel Franklin <joshua(at)iocc(dot)com> |
---|---|
To: | PgSQL Novice ML <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: hiding normalization with views |
Date: | 2002-10-08 20:04:24 |
Message-ID: | Pine.LNX.4.44.0210081459240.9703-100000@iocc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On 8 Oct 2002, Ron Johnson wrote:
> Sometimes, you can go too "normalization happy". Yes, it's academically
> correct, and you save a little disk space, but disks are cheap, and
> you add bunches of extra joins to each query.
Yes, I thought about that, too. The big thing to me is that with the
system we currently use (flat files) there are quite a lot of typos.
For the city/state this is not a big deal but the ZIP code it is.
We did a mailing around 6 months ago with about 50 return-to-senders
many of which were stupid typos. I don't think the normalization will
solve all my problems, but it will at least be something.
Also, just for the discussion, we're also talking about instead of
a separate table just having the (java) client reading a configuration file
with the common values for autocompletion.
From | Date | Subject | |
---|---|---|---|
Next Message | Randy Neumann | 2002-10-08 20:06:57 | Re: hiding normalization with views |
Previous Message | Ron Johnson | 2002-10-08 19:52:46 | Re: hiding normalization with views |