Re: DB clasical structure violation

In article <3D117C1B.6621_at_ix.netcom.com>, Lee Fesperman <firstsql_at_ix.netcom.com> writes
>I'll ask you one question --- are you also researching the performance impact of
>the
>additional constraints required when you denormalize the database structures?
>Or, in
>changing the structure are you ignoring the effects on the integrity of your
>data? A
>database that can't be trusted is worthless.

I'll ask you one question - are you jumping to conclusions? ...

I would suggest the OP investigate Multi-Value (or Network, or hierarchical, etc - basically something that's NOT an *R*DBMS).

The databases I work with are NOT 3NF, but will quite happily maintain integrity provided they're defined properly - delete an object and all related data disappears with it, and you can't assign values to attributes without declaring the object they belong too.

People today assume DBMS == RDBMS, and that's a pretty stupid assumption to make ...

Cheers,
Wol.

-- 
Anthony W. Youngman - wol at thewolery dot demon dot co dot uk
Witches are curious by definition and inquisitive by nature. She moved in. "Let 
me through. I'm a nosey person.", she said, employing both elbows.
Maskerade : (c) 1995 Terry Pratchett