Database – Naming Standardization (Oracle)

Problem Statement: In tables can we use employee_name or emp_name?

Solution: This depends on organization. Many organizations follow emp_name.

Full Name Advantages:

  1. Easy to Read
  2. No Confusion

Disadvantages:

  1. Oracle supports only 30 char length column names
  2. Difficult to write queries at command prompt

Abbreviation Usage:

  1. Needs Abbreviation map to understand all column Names.
  2. Column Comments should help in this process.
  3. Easy to write queries
  4. Looks simple and easy to write and talk

Here with attached document from Oracle Site for your reference.

http://www.oracle.com/technetwork/developer-tools/datamodeler/datamodelernamingstandards-167685.pdf

datamodelernamingstandards-167685

Reference:

https://wiki.kuali.org/display/KULRICE/Database+Table+and+Column+Name+Standards

https://forums.oracle.com/forums/thread.jspa?threadID=1001609

-o-

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s