Wow, that is an open-ended question...
I start with schema's. If the entities are related to a particular
business unit, then I give them schema that represents the unit. If the
entity relates to multiple business units but under a specific company,
then the schema is the company name. Otherwise they fall into a global
schema I call "AI" (All Inclusive).
I always use the following prefixes on tables:
DIM_ - A Dimension Table
REF_ - A reference (code) table
XREF_ - A cross-reference (intersecting code table) table
FACT_ - A Fact table
Past that, I give them plain English names that describe the contained
data.
TRAVEL.DIM_DESTINATIONS
INSURANCE.DIM_PREMIUMS
AI.FACT_2003_YEAREND
Douglas Kostelnik
Senior Database Administrator/Architect
[Email address protected]
AAA Auto Club South
(813)-289-1342
-----Original Message-----
From: Grace
[mailto:db2udbdba-ezmlmshield-x91622577.[Email address protected]
Sent: Wednesday, October 25, 2006 4:16 PM
To: LazyDBA Discussion
Subject: database naming conventions
Hi All,
I wonder if anyone can share some information regarding database naming
conventions. We are in the process to develop a database for business
intelligence on DB2 UDB for AIX, but we haven't got the database naming
conventions set up yet.
Thanks a lot!
Grace
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
<html>
<p class=MsoNormal> <align=justify> <font size=3 face="Times New Roman"><span style='font-size:12.0pt'><br>
_____________________________________________________________<br>
The information transmitted is intended only for the person(s) or entity to which it is addressed and may contain confidential and or privileged material and should be treated as a confidential AAA Auto Club South communication. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer.</span></font></p>
</html>
DB2 & UDB email list listserv db2-l LazyDBA home page