RE: Questions on DB Design

Hi Dick and Bjørn,

Thank you for your comments. It seems to me that db design in a J2EE environemnt is not much different to non J2EE environment. A few interviewees gave this reply and basically I agree with them. Since many Web applciation these days use Java I guess that large number of concurrent access would be a factor to consider in the design.

Cheers
Long

-----Original Message-----
Sent: Saturday, 2 February 2002 3:23 AM
To: Multiple recipients of list ORACLE-L

You clearly also need to ask these persons about application design.  Together with the database design, poor application design is the source of countless performance problems. The good application developer is fully aware of how Oracle handles SQL statemens, how he should and should not write the code, which features are available from the interface chosen (be it Java, C, forms, whatever), and how this interacts with the database kernel.

Thanks, Bjørn.

dgoulet_at_vicr.com wrote:

>Long,
>
> If your interviewing a DB designer you might want to add a question on
>normalization, namely how they view the process. I've seen what IMHO is both
>ends of the spectrum, namely every thing absolutely normalized to the N'th
>degree and absolutely no normalization at all. In case 1 you end up with
>minimal storage requirements, but kill the CPU's when you try to create
>information from the data. On the other end you save of CPU time, but clobber
>the system with disk requirements. Either extreme makes modification of the
>design rather painful.
>
>Dick Goulet
>
>____________________Reply Separator____________________
>Author: Long.Nguyen_at_csiro.au
>Date: 1/31/2002 1:50 PM
>
>Hi,
>
>I am preparing questions for an Oracle DB Designer job interview. Two questions
>that I would like you to give me some input. They are
>
>1) What are the aspects of DB Design that you would consider to be important in
>J2EE applications development?
>
>2) Organisations usually have some standards for DB Design. What would your
>approach be to using and/or reviewing these standards?
>
>Your comments are appreciated.
>
>Long
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?ISO-8859-1?Q?Bj=F8rn?= Engsig
  INET: bengsig_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: Long.Nguyen_at_csiro.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).