Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: help with Object Model, relation daabase model, - some theory
[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.
-- BillyReceived on Fri Jun 06 2003 - 02:42:23 CDT