| Author |
Topic |
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
 Posted - 2011-03-23 : 08:02:09
|
| In SQLTEAM forums, I see people recommending using ISO-11179 rules for the data element names, and using ISO-8601 temporal formats. I googled for those, but the documentation that I found seems very dense, for example here: http://metadata-standards.org/11179/Can anyone point me to a "ISO-11179 for dummies" (or Manga guides if you prefer) that is a little less intimidating? |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-03-23 : 09:03:09
|
| The only one I know of that keeps referring to ISO standards is Joe Celko and to be honest I have a feeling he's the only one that cares...- LumbagoMy blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/ |
 |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-03-23 : 09:34:29
|
| True, it is Joe Celko whom I have seen referring to the standards often. I have very poor skills at naming, so I thought it would be nice to see the industry recommendations and standards. I have very poor naming skills; "consistently inconsistent" would describe my naming style. I have used all of the following variations at one time or other (and probably in the same database) for the last name of a customer: last_name lastname LastName Lastname customer_last_name CustomerLastName ....and many permutations and combinations of those. |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-03-23 : 09:53:08
|
| In that case reading about ISO isn't going to help you either...what you need is *consistency* :) Create a standard that works for you and stick to it would be my word of advice. Here are some links on naming conventions for .NET that are somewhat transferrable:-> http://msdn.microsoft.com/en-us/library/xzf533w0(v=vs.71).aspx-> http://msdn.microsoft.com/en-us/library/ms229045.aspxMicrosoft has not published a naming convention for SQL- LumbagoMy blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/ |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-03-23 : 09:59:57
|
quote:
Microsoft has not published a naming convention for SQL
They have, in a way, although it's a standard of what NOT to name things: the database schema for Sharepoint, Biztalk, and Project Server.  |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-03-23 : 10:15:32
|
quote:
Originally posted by robvolk
quote:
Microsoft has not published a naming convention for SQL
They have, in a way, although it's a standard of what NOT to name things: the database schema for Sharepoint, Biztalk, and Project Server.
Aaahh yes! You just gotta love GUIDs in database names and primary keys - LumbagoMy blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/ |
|
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2011-03-23 : 17:04:44
|
quote:
Originally posted by sunitabeck
In SQLTEAM forums, I see people recommending using ISO-11179 rules for the data element names, and using ISO-8601 temporal formats. I googled for those, but the documentation that I found seems very dense, for example here: http://metadata-standards.org/11179/Can anyone point me to a "ISO-11179 for dummies" (or Manga guides if you prefer) that is a little less intimidating?
11179 for dummies I don't know of. Celko apparently wrote a book on the topic. I have not read said book. But, he keeps talking about naming tables in the plural, so I tend to think he misinterpreted the standard anyway. But stadards aside, like many here, I'd just about kill for some consistancy in naming.. anything.As to the ISO date stuff, books online covers the basics. I'm not sure at what level of detail you are looking for but here is a qucik summary:ISO: yymmdd or yyyymmddISO8601: yyyy-mm-ddThh:mi:ss.mmm (no spaces)ISO8601 with time zone Z: yyyy-mm-ddThh:mi:ss.mmmZ (no spaces) |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-03-23 : 17:22:27
|
| Lamprey, thanks. Any standard is a step up from where I am currently. I look at my own column names from 3 months ago and shake my head sadly at the person who picked those names :-) I am starting with the .Net naming conventions that Lumbago pointed to. |
|
|
|
|
ISO-11179 for Dummies