I have been replying to messages but somehow may
message doesnt go to the list, hope this one makes it.
Thanks! for all your comments. I think , I should
explain more about my application, the table which I
showed is
the data from one company for one type of property
listing say "Preforeclosure" data. I will be having
similar types of tables for different types of
property listings like "foreclosures" ,
"Foresalebyowner" and from different companies. In
that case I will end up with 10-20 tables each with
130 columnns.
Does it make sense to break the data into several
tables and have one-to-one relationsips ? There would
be some updates to the properties otherwise it is
mostly showing property listings on our website.
- Jared.Still_at_radisys.com wrote:
> 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
>
>
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
http://promotions.yahoo.com/new_mail
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 - 13:12:06 CDT
