Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Lost Schema

Re: Lost Schema

From: PA <el93_at_yahoo.com>
Date: Mon, 20 May 2002 00:31:50 -0400
Message-ID: <S1%F8.1679$qn1.426768@news20.bellglobal.com>


> >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.
>
> 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 :-).

I understand that... but norm/tion starts when you know the fd's. Is there any easy way to find fd's in a huge relation ?

Any pointers or software would be helpful.

Thanks.

P Received on Sun May 19 2002 - 23:31:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US