Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: help with Object Model, relation daabase model, - some theory

Re: help with Object Model, relation daabase model, - some theory

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Fri, 06 Jun 2003 07:42:23 +0000
Message-ID: <bbp9nf$ccm$1@ctb-nnrp2.saix.net>


[crossposting groups removed]

Don wrote:

> I'm trying to properly model a supply chain process and would like
> some help. I'll warn you that this post is fairly long and is mainly
> theoretical discussion.

<snipped>

I would select Door Number 2.

Reason. The quantities are _attributes_ of the entity Inventory. Straight forward and that simple. Relational DB Design 101.

Ignore the fact that these attributes contain values of the same unit. That does not determine the nature of the design. If these attributes were weight, price and colour, how would you have normalised and designed the relation? Separate tables? Or a single table.

Also - on the physical design side. Single i/o to read entity with all its attributes. As oppose to multiple i/o's to assemble the attributes of the entity.

In fact, I would say that any other approach _will_ have a significant and unnecessary impact on performance and space required for tables & indexes.

--
Billy
Received on Fri Jun 06 2003 - 02:42:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US