File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Names and Performance Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Names and Performance" Watch "Names and Performance" New topic
Author

Names and Performance

Stan James
(instanceof Sidekick)
Ranch Hand

Joined: Jan 29, 2003
Posts: 8791
I'll apologize ahead of time if any of you are corporate data modelers, but ours have evolved a set of naming standards that make me want to chew my leg off to get away. Most of them seem to be about shortening names as much as possible. There are several pages of accepted abbreviations, like stts for status.

Does the database perform any differently at all with shorter names? I started with DB2 when Date's Guide to DB2 first edition was current, and there might have been some real limits on name lengths then. Are there still such limits? Any good reasons we don't name db columns just like Java fields - to try to communicate something? Don't the Rails (and other automated OR) users do that?


A good question is never answered. It is not a bolt to be tightened into place but a seed to be planted and to bear more seed toward the hope of greening the landscape of the idea. John Ciardi
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2491
    
    8

There are limits. Your database's documentation will mention them. For Oracle it is (or was?) 30 chars.

But I haven't ever seen measurable impact of using full-blown fieldnames.
We do abbreviate item_id, cust_no, and the like, but always strive for meaningfull, readable names.

Regards, Jan


OCUP UML fundamental and ITIL foundation
youtube channel
 
 
subject: Names and Performance
 
Similar Threads
How do I integrate a DB2 9.5 data source into WAS 6?
Cannot insert chinese/thai characters in db2 through script
parameter name / value length issue
Db2 invalid column name error
Changing schema in DB2