RE: database naming conventions

Hi All,

Thank you very much for all of the great information.

How do you handle constraint name, in my opinion, I will create constraint
for primary key as "$table-name_PK", and constraint for foreign key as
"$table-name_FK$NN" where $NN is a sequential number.

How do you handle index name, I will create primary key index and foreign
key index as "$table-name_PK" /"$table-name_FK$NN", the same name as their
corresponding constraint name. Then unique indexes will be
"$table-name_UK$NN". All of other indexes will be "$table-name_IDX$NN".

Is this good, any comment? What is your best practices?

Thanks a lot!

Regards,
Grace

"Doug Kostelnik "
<db2udbdba-ezmlmshield-x73976642.[Email address protected]
10/25/2006 04:44 PM

To: "LazyDBA Discussion" <[Email address protected]
cc:
Subject: RE: database naming conventions

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>
 <align=justify> 
_____________________________________________________________ 
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.
</html>

---------------------------------------------------------------------
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

DB2 & UDB email list listserv db2-l LazyDBA home page