Re: Lost Schema

From: Jan.Hidders <>
Date: 17 May 2002 09:52:42 +0200
Message-ID: <3ce4b6ca$>

In article <Od%E8.18203$>, PA <> 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
>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
Received on Fri May 17 2002 - 09:52:42 CEST

Original text of this message