Statement Paragraph
TablesOverview
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 ConstraintKey Constraint
table_name_
pk Expk Ex: HUB_PERSON_CURRENT_PK
Unique Key Constraint
Anchor
uk## Ex: HUB_PERSON_CURRENT_UK
Foreign Key Constraint Foreign Key Constraint Anchor
Foreign Key Constraint
table_name _
fk## Exfk## Ex: HUB_PERSON_CURRENT_UK
Sequenceanchor
Sequence
Ex: HUB_PERSON_CURRENT_SEQ
Trigger
Anchor
trg 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.
ViewsanchorViews
Same as tables. (scope, primary identifier,
modifier) Exmodifier Ex: HUB_STUDENT_COURSES
FunctionFunction
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
Package Package Anchor
Package
scope_primary identifier_modifier_
pkg Expkg Ex: COMMON_DATALOAD_PKG
Dblink
Anchor
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