you reminded me of another few:
make sure that number columns/primary keys are really numeric (I have a
3rd party design that doesn't)
make sure that char columns really need to BE char columns. This can
cause you problems way down the line
on the other hand, don't indiscriminately create varchar2 columns of
length 255 or 2000 or whatever the max is in the version you are
running. Just because you CAN do it is not necessarily a reason TO do
it
- Kimberly Smith <ksmith2_at_myfirstlink.net> wrote:
> Well, I would fire your manager for starts. You most definitely need
> to see the SQL. Having the most excellent design in no way stops
> developers
> from being stupid.
>
> However, that being said, you should review the design. You are the
> one
> that has to live with it. Number one, make sure they are consistent.
> This
> is especially true with things like where the same column is in
> multiple
> tables
> (for whatever reason) and is a different length in each. Make sure
> that all
> the tables have primary keys and that those primary keys are not
> intelligent.
> Make sure the appropriate foreign keys are present. Make sure that
> they
> keep
> the design somewhat in 3rd normal form. Blah blah blah....
>
> Question anything that you think is funny looking. Go to them and
> say why
> did you do this that way? They should be able to explain it to you
> and you
> should get a warm and fuzzy. If you don't keep at them.
>
> I am a big supporter of having ones work reviewed. As the DBA you
> are the
> best person to review the Data Architect.
>
> -----Original Message-----
> WILLIAMS
> Sent: Friday, January 04, 2002 11:45 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Can anyone provide some criteria of what you look for when a data
> model is
> handed off from production? We are starting a large development
> project and
> I lobbied management to hire a data architect. As they have talked to
> these
> people, they are getting statements such as "and then the DBA will
> check out
> the data model to make sure there won't be any performance problems".
> I am
> concerned about what will be expected of me and wondered how other
> DBAs
> handle this situation. What do you look for in a model in terms of
> making
> sure the performance will be good? I said that I could look at the
> queries
> that would be run to see how many tables would need to be joined to
> retrieve
> the data, but the manager replied that a good DBA wouldn't need to
> see the
> queries, should just be able to look at the model. Up until this
> point, our
> client-server design tools have tended to protect the developers from
> doing
> dumb stuff, but now in the Java world some of those safeguards.
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.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: Kimberly Smith
> INET: ksmith2_at_myfirstlink.net
>
> 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).
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_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).
Received on Fri Jan 04 2002 - 21:06:54 CST
