Overview
HUB/BOG naming standards aid developers by providing uniformity for Data Warehouse database objects.
Tables
Follow identifier naming convention described in the above section. (scope, primary identifier, modifier)
. Ex: HUB_PERSON_CURRENT
Indexes
table_name_
idx## Ex: HUB_PERSON_CURRENT_IDX01
Primary Key Constraint
table_name_
pk Expk Ex: HUB_PERSON_CURRENT_PK
Unique Key Constraint Unique Key Constraint Anchor
Unique Key Constraint
table_name_
uk## Exuk## Ex: HUB_PERSON_CURRENT_UK
Foreign Key Constraint Foreign Key Constraint Anchor
Foreign Key Constraint
table_name _
fk## Exfk## Ex: HUB_PERSON_CURRENT_UK
Sequence Sequence Anchor
Sequence
table_name_seq## (if associated with a table. Else follows identifier naming convention from the above section)
Ex: HUB_PERSON_CURRENT_SEQ
Trigger Trigger Anchor
Trigger
table_name_action_
trg Extrg Ex: HUB_PERSON_CURRENT_INS_UPD_TRG
Snapshots and Materialized
ViewsViews
The name of the source object, pre-pended by system name. (Scope, primary identifier, modifier)
Ex. Ex: snapshot of spbpers becomes OASIS_SPBPERS.
ViewsViews
Same as tables. (scope, primary identifier,
modifier) Exmodifier Ex: HUB_STUDENT_COURSES
Function Function Anchor
Function
F_ scope_primary identifier_
modifier Exmodifier Ex : F_OASIS_EXTERNAL_ID
Procedure Procedure Anchor
Procedure
P_ scope_primary identifier_
modifier Exmodifier Ex: P_REG_STUDENT_EXEMPTIONS
Packageanchor
Package
pkg Ex: COMMON_DATALOAD_PKG
Dblink Dblink Anchor
Dblink
1st type - system name (like OASIS) will point at database in same state as you are in. in other words, from DWDVLP, OASIS dblink will point at db: dvlp. In DWTEST same name will point at pprd. In DWHOUSE same name will point at prod. This allows code to be promoted without modifying.
2nd type, if actual database name, it points at actual database. For example, in DWDVLP, GEMSPRO dblink will point at GEMSPRO database, GEMS dblink will point at GEMSDVLP database. (Note: in some cases these 2 types are the same. System and db have same name. Those are solved on case by case basis).
Insert Script
tablename_ins.
sql Exsql Ex : HUB_ROOMS_INS.sql
TheThe following are the exceptions:
- For table hub_xref_rule inserts, the script should be named as xref_kw_qualifier_ins.sql
- For table q$error inserts, the insert script should be named as q$error_catname_ins.sql
IT Analytics, SVC4010, Contact Us