From oracle-l-bounce@freelists.org Mon Jan 16 18:49:27 2006 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id k0H0nRB8007338 for ; Mon, 16 Jan 2006 18:49:27 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id k0H0nQg7007329 for ; Mon, 16 Jan 2006 18:49:26 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C7C3D27A17C; Mon, 16 Jan 2006 19:49:23 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 02667-08; Mon, 16 Jan 2006 19:49:23 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3AB8B27A15B; Mon, 16 Jan 2006 19:49:23 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 16 Jan 2006 19:49:15 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 28869242604 for ; Mon, 16 Jan 2006 19:49:15 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 02636-06 for ; Mon, 16 Jan 2006 19:49:15 -0500 (EST) Received: from uproxy.gmail.com (uproxy.gmail.com [66.249.92.206]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8DB4827A129 for ; Mon, 16 Jan 2006 19:49:14 -0500 (EST) Received: by uproxy.gmail.com with SMTP id j40so133163ugd for ; Mon, 16 Jan 2006 16:49:13 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=VKar1++IUrmUIvlItJgt5gguYqEDaQZPwEUy0kyxXmtAFz0sZT+qwF7y3XXHwxHEzQ/HJxWyVWwW1d+mwdAF0cHmXOTytZz61AkEQuFerglT5gPtFSS2GLJyaNtNA8qr/FhshC3jV0cDOINycRbtn0CbjwRSRYpCFWNUaLuarLU= Received: by 10.48.30.18 with SMTP id d18mr297216nfd; Mon, 16 Jan 2006 16:49:13 -0800 (PST) Received: by 10.48.239.12 with HTTP; Mon, 16 Jan 2006 16:49:13 -0800 (PST) Message-ID: Date: Mon, 16 Jan 2006 16:49:13 -0800 From: Jared Still To: Sandeep Dubey Subject: Re: SQL question Cc: oracle-l@freelists.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_13546_8902349.1137458953444" References: X-archive-position: 30076 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jkstill@gmail.com Precedence: normal Reply-To: jkstill@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Not scanned: please contact your Internet E-Mail Service Provider for details X-MailScanner-From: oracle-l-bounce@freelists.org ------=_Part_13546_8902349.1137458953444 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Comments below: On 1/16/06, Sandeep Dubey wrote: > > > > On 1/13/06, Sandeep Dubey wrote: > > > > I am sorry I can't be more helpful. I don't really see this as > problem, > > to > > > > me it's more of an exemple of bad data. > > > > > > I am not sure if it is a bad data model. It's battle of normalization > > > - denormalization. > > > > The example given would appear to be denormalized. There is no > > candidate key to start with. > > > > > I have a table Items. It's child is item_parts. Item can be made up o= f > > > 1 or may parts. So it is right to store in a table like item_parts. > > > okay? > > > > The example does not match what you were trying to do. > > You won't get much help here with an example like that. > > > > What you are trying to do requires 3 tables. > > > > ITEMS, PARTS, and an intersection table. > > The foo table in the example I gave is in fact item_part, child of > item and part table. Item and part are many to many relationship. So I > have table item_part (foo in this example) having column item and part > ids. Sorry if I missed your point. > > -- Ah, so there are 3 tables. I've found this thread rather confusing. Perhaps if you post again with examples that are more clear and representative of the problem you are trying solve, you would get some helpful replies. Including DDL and DML to create a test is a sure way to get some respondents. I know you did that in your original post, but it appears that that example had little to do with the problem you are trying to solve. Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist ------=_Part_13546_8902349.1137458953444 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
Comments below:

On 1/16/06, Sandee= p Dubey <dubey.sandeep@gm= ail.com> wrote:

> On 1/13/06, Sandeep Dubey <dubey.sandeep@gmail.com> wrote:
> > > I am sorry = I can't be more helpful. I don't really see this as problem,
> to
> > > me it's more of an exemple of bad data.
> >
>= > I am not sure if it is a bad data model. It's battle of normalization=
> > - denormalization.
>
> The example given would ap= pear to be denormalized.  There is no
> candidate key to start with.
>
> > I have a table I= tems. It's child is item_parts. Item can be made up of
> > 1 or ma= y parts. So it is right to store in a table like item_parts.
> > o= kay?
>
> The example does not match what you were trying to do.
= > You won't get much help here with an example like that.
>
>= ; What you are trying to do requires 3 tables.
>
> ITEMS, PARTS= , and an intersection table.

The foo table in the example I gave is in fact item_part, child of<= br>item and part table. Item and part are many to many relationship. So Ihave table item_part (foo in this example) having column item and part
ids. Sorry if I missed your point.

--
Ah, so there are 3 tables. 

I've found this thread rather con= fusing.

Perhaps if you post again with examples that are more clear<= br> and representative of the problem you are trying solve, you would
get so= me helpful replies.

Including DDL and DML to create a test is a sure= way to get
some respondents. 

I know you did that in your= original post, but it appears that that
example had little to do with the problem you are trying to solve.
<= br>
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist<= br> ------=_Part_13546_8902349.1137458953444-- -- http://www.freelists.org/webpage/oracle-l