Re: Database Design questions

From: <Jared.Still_at_radisys.com>
Date: Fri, 18 Jun 2004 11:00:06 -0700
Message-ID: <OF29FE2076.98151859-ON88256EB7.0062C795-88256EB7.0062E0C1@radisys.com>

You are on the right track.
Have you ever noticed how difficult it is to write code with a table like this?

No doubt you have.

Be assured that this is not simply an academic exercise.

This table should really be several tables.

Jared

oracle-l-bounce_at_freelists.org wrote on 06/18/2004 06:49:23 AM:

> Hi Design Experts,
>
> I am in the process of designing a datamodel for
> a new application and I need some advice regarding
> that. I have a table with almost 130 columns in it.
> This table gets updated with new information regularly
> and all the columns are mostly dependent or related to
> the primary key. I think there will be a poor
> performance with the table of this size. My question
> is it better of breaking this table into several
> different tables like
>
> property_details ( prop_id (pk), prop address, bed
> rooms,bath rooms ,total sqft ...)
> property_auctions ( prop_id (fk), auction date,
> auction location..)
> property_loans, (prop_id (fk), loan date, loan amount,
> loan recording date...)
> property_defendents (prop_id (fk), defendent owner
> firstname, lastname, company name ...)
> .
> .
> .

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Jun 18 2004 - 12:57:16 CDT