Re: Database design qn for one-to-many relationship
From: Anthony Youngman <Anthony.Youngman_at_ECA-International.com>
Date: 11 Mar 2003 01:16:04 -0800
Message-ID: <9a993dee.0303110116.16aaa27b_at_posting.google.com>
Date: 11 Mar 2003 01:16:04 -0800
Message-ID: <9a993dee.0303110116.16aaa27b_at_posting.google.com>
karl wettin <wettin_at_users.sourceforge.net> wrote in message news:<20030305170356.5d9ed63e.wettin_at_users.sourceforge.net>...
>
> So your choises are speed or a good looking RDB. If you still can't make up
> your mind you might want to consider using an OODB.
>
Or a Multi-Value db. If you want to keep the number of tables down, MV
is almost perfect, as you - should - use one table per entity, and you
can store both attributes *AND* relationships in this one table.
>
> karl
Cheers,
Wol
Received on Tue Mar 11 2003 - 10:16:04 CET