Re: Ideas for World Hierarchy Example

From: Neo <neo55592_at_hotmail.com>
Date: 12 Jan 2007 20:45:52 -0800
Message-ID: <1168663551.326475.38000_at_51g2000cwl.googlegroups.com>

> T_Capital(city_id, capital_types)
> and a code file, either specifically for capital types or preferably
> (in this model) a big one as indicated in my current blog entry on OTLT

Ok, I cruised on over to your website only to stared down by an arm-less (declawed?) purple cat. Let me summarize my comphresion. Typical RMDB implement "lookups" like gender and bodyType in separate tables as follows:

T_Person

Name  Gender       BodyType
John    ->Male        ->Slim

Mary ->Female ->Tall

T_Gender
Male
Female

T_BodyType
Slim
Tall

In MV, it seems the equivalent lookup might be implemented as follows:

T_Lookup

Gender      Male
Gender      Female

BodyType Slim
BodyType Tall

Again neither solution is perfect. Each has an Achilles' heel making it more ideal for a specific application. Now wouldn't it be delicious if someone could kill both birds with one stone, said the purple cat. Received on Sat Jan 13 2007 - 05:45:52 CET