Re: Lost Schema

In article <Od%E8.18203$oF2.2256975_at_news20.bellglobal.com>, PA <el93_at_yahoo.com> wrote:
>
>Suppose you have at some point in time lots of relations and you had to
>build a universal relation (or in general you may have a big big relation).
>The point is to analyze its data and induce a new schema/description of
>this.
>
>Is there some work on that ? Is there something that gives a solution to
>this problem ?

Yes, it's called database normalization; you find out the (functional, multi-valued, join) dependencies in your big table and then split it into smaller tables. If you do this well you will find what the original tables were or should have been :-).

• Jan Hidders