Re: Relational and multivalue databases

"Mikito Harakiri" <mikharakiri_at_iahu.com> wrote in message news:V67Zb.18$iK2.150_at_news.oracle.com...
>
> "Dawn M. Wolthuis" <dwolt_at_tincat-group.com> wrote in message
> news:c12rgj$4e1$1_at_news.netins.net...
> > This string of data could be:
> > Joan<field-delimiter>
> > Doe<field-delimiter>
> > 6165551234<value-delimiter>7615552222<field-delimiter>
> >
>
MATH<sub-value-delimiter>2002<value-delimiter>PHIL<sub-value-delimiter>2003<
> > field-delimiter>
>
> How about:
>
>

<sub-value-delimiter>2002<sub-sub-value-delimiter>Jan<sub-sub-sub-value-deli
> miter>25
>
> Am I expert Pick programmer already?
>
You got it -- simple, right? It's just a function that represents a graph. We could call it a web! But on the outside to the user, it is a vocabulary with functions (also part of the vocabulary).

How do you decide whether info is a sub-table of an existing table or should go in its own table? If the information is functionally dependent. My phone numbers are information that one might think of as being in the relationship between me and the telecom industry. But my phone numbers have no meaning apart from me -- sure they are phone numbers that exist in the world, but the point of capturing the data is to capture information about a person. So, don't stick them in some other function (aka file) -- put them with the person, even if there are more than one of them.

Make sense? --dawn Received on Thu Feb 19 2004 - 19:38:02 CET