RE: Normalisaition (was Re: Large databases)

> 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
www.standardlife.ca
Tel. (514) 925-7187
stephane.paquette_at_standardlife.ca <mailto:stephane.paquette_at_standardlife.ca>

-----Original Message-----
Lewis
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

    www.dbdebunk.com

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  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:
http://www.jlcomp.demon.co.uk/tutorial.html

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

Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html

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

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: 16 April 2003 22:54

> 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
and
> performance was not as important as data integrity and cost. In
those
> 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: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET: sorr_at_rightnow.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).