Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Large databases

Re: Large databases

From: Igor Neyman <>
Date: Wed, 16 Apr 2003 10:49:23 -0800
Message-ID: <>

MessageThen, there is no need to discuss "thickness" or "thinness" of the tables in OLTP environment. It should be normalized, period.
And could be normalized, having 4 or 40 columns per table, it all depends on the "business" problem it's solving.

Igor Neyman, OCP DBA   

  I said "had a point", I didn't agree that there is a solid limitation. 4 columns is NOT a limit I'd suggest or enforce.

  Basic database normalization will lead to "thinner" tables; it is often the case that "wide" tables (ones with many columns) are poorly designed for transactional systems (ie inserts and updates versus read-only). OLTP == transactional, of course.

  Just because ERP vendors, many of whom originally designed their systems on non-relational database systems have abused this design principle doesn't mean it isn't valid.

    -----Original Message-----
    From: Igor Neyman []     Sent: Wednesday, April 16, 2003 9:24 AM     To: Multiple recipients of list ORACLE-L     Subject: Re: Large databases


    Are you serious?
    Where did you get this limitation (4 columns per table) for transactional (btw. did you mean OLTP?) systems?     Are you ready to substantiate your statement?

    Igor Neyman, OCP DBA       

> From: Lyndon Tiu []
> Ths is real and happened to me last month.
> An "Access DBA" told me after seeing my Oracle/Postgresql database ER
> Diagram:
> "Your database is too big. I took an Access course last year
> and the instructor mentioned that tables should have no more
> than 4 columns each."

      Would it be cruel of me to point out that s/he has a point? Assuming you're talking about a transactional system, of course...

Please see the official ORACLE-L FAQ:
Author: Igor Neyman

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 Wed Apr 16 2003 - 13:49:23 CDT

Original text of this message