Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Normalisaition (was Re: Large databases)

RE: Normalisaition (was Re: Large databases)

From: Orr, Steve <>
Date: Thu, 17 Apr 2003 06:47:06 -0800
Message-ID: <>

> It's mathematical 100%.

Hmmm... while set theory and its implementation are indeed mathematical, database design and application development should be a fine art unless you're not in your right mind, er uh, right brain.

Math -> left brain, Art -> right brain, database design -> whole brain.

It's said that males are predominately left brained and are therefore not in their right mind but I resemble that remark. ;-)

Finally, how can you profess knowledge about normaliZation if you don't even know how to spell it? :-)

Steve Orr, not so normalized DBA... looking for lost tuples.

-----Original Message-----
Sent: Thursday, April 17, 2003 7:57 AM
To: Multiple recipients of list ORACLE-L

It's mathematical 100%.

When I've learned sql and relationnal theory we were resolving sql operations with mathematical statements.

Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
Tel. (514) 925-7187 <>

-----Original Message-----
Sent: Wednesday, April 16, 2003 7:19 PM
To: Multiple recipients of list ORACLE-L

No !

Normalisation was developed as part of
relational theory.

Relational Theory was developed in a
mathematical way to reduce the mess
created by the ad hoc development of
suck it and see strategies that made
it labour-intensive to design, code and
modify systems for storing data.

Suggested reading:

    C.J.Date An introduction to Database Systems Vol. 1

Suggested light entertainment


Jonathan Lewis

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr

One-day tutorials:

____UK_______April 22nd
____USA_(FL)_May 2nd
____Denmark__May 21-23rd

Three-day seminar:

____UK_(Manchester)_May x 2
____Estonia___June (provisional)
____Australia_June (provisional)
____USA_(CA, TX)_August

The Co-operative Oracle Users' FAQ

> I think the thing that maybe hasn't been stated is that
"normalization" of
> data was developed because.....
> storage space was extremely expensive. Eliminating redundant data
was THE
> driving factor in data modeling. In a typical system you could save
tens of
> thousands if not 100K if you could eliminate redundant data. Speed
> performance was not as important as data integrity and cost. In
> days...many "users" were not "users" until these systems were
created. They
> went from a paper world to a green screen and they rejoiced and said
it was
> good.

Please see the official ORACLE-L FAQ:
Author: Orr, Steve

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Thu Apr 17 2003 - 09:47:06 CDT

Original text of this message