Oracle-L: RE: Large databases

From: Chris Berry <compjma_at_hotmail.com>
Date: Wed, 16 Apr 2003 13:19:10 -0800
Message-ID: <F001.00583560.20030416131910@fatcity.com>

>From: "Nelson, Allan" <anelson_at_midf.com>
>CREATE TABLE PERSON (
> PERSON_ID NUMBER,
> FNAME VARCHAR2(20),
> MNAME VARCHAR2(20),
> LNAME VARCHAR2(30),
> RACE_ID NUMBER(25), /*allows for proliferation
>of pc categories */
> BIRTH_DATE DATE,
> AGE NUMBER(3),
> HANDEDNESS CHAR(1),
> SEX CHAR(1),
> HEIGHT NUMBER(3),
> WEIGHT NUMBER(3),
> WAIST NUMBER(2),
> INSEAM NUMBER(2),
> COLLAR NUMBER(2),
> ARM_LEN VARCHAR2(5),
> HAT_SIZE VARCHAR2(4),
> SHOE_SIZE VARCHAR2(5),
> EYE_COLOR_CD VARCHAR2(3),
> HAIR_COLOR_CD VARCHAR2(3),
> MARRIED CHAR(1),
> EDUCATION_CD NUMBER(1),
>)
>
>Now, that's over 20 and afaik normalized, no repeating groups, no
>dependency on non key atttibutes, just to point out that aribitrary
>numerical limits don't mean much if no business requirements are in
>view.
>
>Allan

Very true, and I wasn't advocating that. Just mentioning that in most cases properly normalized tables don't have huge numbers of columns. The above example would work well in some situations, in others it would be terrible depending on the business requirements. For a clothing store it would be awefull.

Chris Berry
compjma_at_hotmail.com
Systems Administrator
JM Associates

"Without change, something sleeps inside us, and seldom awakens. The sleeper must awaken." -- Duke Leto Atreides

Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Chris Berry
  INET: compjma_at_hotmail.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).

Received on Wed Apr 16 2003 - 16:19:10 CDT