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: A Normalization Question

Re: A Normalization Question

From: Neo <neo55592_at_hotmail.com>
Date: 8 Jul 2004 21:20:10 -0700
Message-ID: <4b45d3ad.0407082020.6735f7e9@posting.google.com>


> There is only redundancy if one of them can be ignored
> without loss of information. You cannot.

Below is approximately how XDb1 ignores the redundant "brown" strings that were in the place of ->2, ->3 and ->4 without loss of information. The person, color and street in tuple1 are not redundant, the string that names them was.

Thing Person Color Street
1 ->2 ->3 ->4

Person Name
2 ->5

Color Name
3 ->5

Street Name
4 ->5

String Sym1 Sym2 Sym3 Sym4 Sym5 ....
5 ->6, ->7, ->8, ->9, ->10

Symbol

6      b
7      r
8      o
9      w
10     n
Received on Thu Jul 08 2004 - 23:20:10 CDT

Original text of this message

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