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: Jan.Hidders <hidders_at_hcoss.uia.ac.be>
Date: 17 May 2002 09:52:42 +0200
Message-ID: <3ce4b6ca$1@news.uia.ac.be>


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

Received on Fri May 17 2002 - 02:52:42 CDT

Original text of this message

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