I just think it's a waste. You can tell by context what kind of thing a thing is. For example, consider: "select a.flarg from bloing a where a.croopoo > 7". This can be understood by syntactical context (even with the nonsense names), without having to rename "bloing" to "bloing_table".
Most of the embedding of type names into object names that I've seen has been implemented by users who were inexperienced at the time they created the standard. They were worried that without embedding the type name into the object name, they might forget what kind of object it was. ...Most such naming conventions become onerous over time, long after you find out that you can find the type of something in the data dictionary, but after it's too late to save the thousands of extra characters of typing that'll waste people's lifespans over time. In my old OFA paper, I made a joke about how we don't embed type names into object names in daily life, with just a few exceptions (Billy the Kid, Winnie the Pooh, Atilla the Hun, and the younger family members of the old Walton Family TV show are a few examples). If you have both a dog and a child named "Rex," though, it's probably a good idea to expect them both to come when you call. With SQL, though, I can't think of a case in which it's not easy to tell by syntactic context what kind of thing you're talking about... 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----- Carmichael Sent: Tuesday, July 30, 2002 4:49 PM To: Multiple recipients of list ORACLE-L 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
