File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Naming Standard

 
Gregg Bolinger
GenRocket Founder
Ranch Hand
Posts: 15302
6
Chrome IntelliJ IDE Mac OS X
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is there a naming standard for database, table, and field names? Different projects all seem to do things a little bit differently and I was wondering if there was some sort of industry standard or not.
 
Gregg Bolinger
GenRocket Founder
Ranch Hand
Posts: 15302
6
Chrome IntelliJ IDE Mac OS X
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I found this which is pretty good reading, but it is just someone's weblog (opinion) on the subject. I'd like to know if there is anything more concrete.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33697
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Gregg,
We have company naming standards, but that's not much better than project ones. There are some things that are common across most or all standards (like underscores in the names.) However, I don't think there is one standard. Look at all the different coding standards for Java!
 
Adeel Ansari
Ranch Hand
Posts: 2874
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
what i have come across is,

- underscores as a seperator in table and field name
- all caps in table and field names
- no standard naming for database name

i know it does matter, but does it really matter? i mean field names and table names are not case sensitive, though.
[ October 21, 2004: Message edited by: adeel ansari ]
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
That link is pretty good Gregg. There's a few things in there I'd disagree with (plural entity names drive me up the wall for example, but I'm well aware that is just a personal peculuarity), but that's true with every "standard" I've ever read.

We too have company defined standards. But we use them for a slightly different purpose - namely to remind developers that we support 5 different DB platforms. Standards are essential if you are doing that - there's lots of gotchas, like DB2 only supporting an object name length of <= 18 characters. I think they are less necessary otherwise. I'd be happy to see models defined anyway the DBA liked so long as the naming convention is internally consistant.
 
Gregg Bolinger
GenRocket Founder
Ranch Hand
Posts: 15302
6
Chrome IntelliJ IDE Mac OS X
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for the information. Luckily I only have to concern myself with one db vendor, so I've got it fairly easy. I guess I'll just create my own standard based on what I like from everyone else's standard and just be consistant with that.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic