Re: Question on Structuring Product Attributes

On 2013-02-16, paul c <toledobythesea_at_oohay.ac> wrote: ...
> From Codd 1970: "For expository reasons, we shall frequently make use of
> an array representation of relations, but it must be remembered
> that this particular representation is not an essential part of the
> relational view being expounded."

<snip properties of these arrays>

> It's pretty clear to me that the SQL originators missed Codd's point
> about this kind of array being merely for "expository reasons". So they
> implemented something that is more physical than the the logical kind of
> relations Codd had in mind. Perhaps they missed the point on purpose
> ...

I don't think it's all that clear, because Codd also says:

   "The simplicity of the array representation which becomes feasible     when all relations are cast in normal form is not only an advantage     for storage purposes but also for communication of bulk data between     systems which use widely different representations of the data."

I think they did the wrong thing, but they did have that justification.

Eric

-- 
ms fnd in a lbry