Re: Regarding Database Design

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Mon, 11 May 2009 06:23:18 -0700 (PDT)
Message-ID: <544eb4be-8f97-4f7a-9069-64c04f6d2fad_at_q14g2000vbn.googlegroups.com>



On May 11, 1:37 am, DeB <debashish.majum..._at_gmail.com> wrote:
> Hi Faculties,
>
>    Please accept my apologies if this query is out of context of the
> discussions in this forum.
>
>    I've with me a proposed database design which is not normalized
> fully. There are some other tables that we plan to denormalize. The
> targeted database platform is Oracle Database 10g Release 2.
>
>   For ex:- We have a table called user_groups which links the users
> and the groups table. But now we are thinking to eliminate this table
> and have a group_ids column storing comma separated values of groups
> ids from the groups table instead.
>
>    The records will look like -
>
>    groups
>    ------
>
>    group_id                    group_name
>         1       Admin
>         2       Operator
>         3       Power User
>
>    users
>    ------
>
>    user_id                    user_name                group_ids
>         1       User1           1,3
>         2       User2           2,3
>
>    The targeted database will be a typical OLTP system. Please suggest
> if this approach to database design has any fundamental flaws.
>
> Thanks in advance
> DeB

If performance and data integrity are important then you normalize rather than denormalize.

HTH -- Mark D Powell -- Received on Mon May 11 2009 - 08:23:18 CDT

Original text of this message