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