Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: INQ: Physical data modeling books

Re: INQ: Physical data modeling books

From: Michael Austin <miaustin_at_bellsouth.net>
Date: Tue, 15 May 2001 10:05:12 -0400
Message-ID: <3B013798.3E790ED0@bellsouth.net>

I do not ever recall seeing anything on the physical data model. Generally, you do the PDM based solely on your hardware I/O subsystem configuration. Don't put the same hot files on the same physical spindles, spread the load over as many controllers as possible, again, taking into account the hotfiles.

Of course this only a rule of thumb and your mileage may vary.

Michael Austin
DBA Consultant -specializing in PDM and available now. 704-947-1089 (Office)

Patrick Demets wrote:

> Would anyone be able to suggest good (fairly recent) books on physical data
> modeling, especially those that follow Oracle Designer (6i, 6, or earlier)
> theory and conventions? There are many books available on logical data
> modeling (most notably by Barker and by Silverston, amongst others), but
> very few on PDM. Or would this fall under "database design"?; to me,
> there's a difference between that and "physical data modeling". Any help
> would be appreciated.
>
> Cheers,
>
> Patrick Demets
Received on Tue May 15 2001 - 09:05:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US