Re: Any new thoughts on OTLT (One True Lookup Table)
Date: Sat, 27 Mar 2004 08:12:44 -0500
Message-ID: <5cCdnRxJhvQx4PjdRVn-jg_at_comcast.com>
> Doesn't OTLT have to include a third column, 'class' perhaps, with
> values 'state' and 'airline' respectively?
>
Yes, it does. And that's precisely the problem with putting the code "PA"
in the same column twice, with two different meanings. Making use of the
"class" column,
We've taken a step away from self describing data.
How does the new user of the data, whether person or automaton, "know"
that you have to qualify the "code" column with the "class" column? Is that
inherent in the two columns? Is it written in the metadata? No!
Is it inherent in the underlying subject matter? No!
The new user "just has to know" that that was the intent of the designer,
requires a programmatic solution.