Cary,
you said
"* Don't embed the object type in the object's name. I used to see this
all the time with tablespaces called XYZ_TS, indexes called IND_THING,
and so on."
what's your logic behind that?
Rachel
- Cary Millsap <cary.millsap_at_hotsos.com> wrote:
> Here's a start. Not a checklist by any means, just kind of a micro
> pet
> peeves list.
>
> * Decide today whether table names will be singular or plural. Do you
> want a THING (singular) table? Or a THINGS (plural) table?
>
> * Don't use case-sensitive names. E.g., use THING (without quotes) in
> your CREATE (DDL) statement, which can be spelled "THING", "thing",
> "Thing", or even "tHiNG" in your developers' SQL. But don't make
> developers type stuff like this...
>
> select "Name" from "Thing" where "Id" = y /* won't work without
> ""
> */
>
> * Don't embed the object type in the object's name. I used to see
> this
> all the time with tablespaces called XYZ_TS, indexes called
> IND_THING,
> and so on.
>
> * Decide today whether you want to abbreviate or not. If you do, then
> construct a formal, standard, consistent list of accepted
> abbreviations.
> Don't name one table CUSTOMER_THING and another CUST_HISTORY.
>
>
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
>
> Upcoming events:
> - NCOAUG Training Day, Aug 16 Chicago
> - Miracle Database Forum, Sep 20-22 Middlefart Denmark
> - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12
> Dallas
>
>
>
> -----Original Message-----
> Chambers
> Sent: Tuesday, July 30, 2002 3:37 PM
> To: Multiple recipients of list ORACLE-L
>
> All...
>
> Will some of you please provide some insight on your table naming
> conventions? I'm in the very early planning stages of what will
> likely
> be a large and complex schema (IT asset inventory). I have a chance
> to
> start it correctly. TIA
>
> Gary Chambers
>
> //-------------------------------------
> // Lucent Technologies GIO/Unix
> // 4 Robbins Road, Westford, MA 01886
> // 978-399-0481 / 888-480-6924 (Pager)
> // Nothing fancy and nothing Microsoft
> //-------------------------------------
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Gary Chambers
> INET: gc22_at_lucent.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: Cary Millsap
> INET: cary.millsap_at_hotsos.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).
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
--
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 Tue Jul 30 2002 - 16:48:59 CDT
