the product shortcut consists of two uppercase, alphanumeric characters representing the product, as detailed in the following table.
Product | Product Shortcut |
---|---|
Precise for J2EE | JE |
Precise for Db2 | UD |
Precise for Oracle | OR |
Precise for SQL Server | SQ |
Precise for Web | WW |
Precise for SAP | SP |
Insight | IS |
Report Manager | FS |
Alerts | PU |
Instance Watch | PD |
PMDB | PW |
Precise for Sybase | SY |
Precise for Microsoft .NET | DN |
Customer Defined 1 | C1 |
Customer Defined 2 | C2 |
Customer Defined 3 | C3 |
The environment shortcut consists of two uppercase, alphanumeric characters representing the environment, as detailed in the following table.
Environment | Environment Shortcut |
---|---|
Oracle | OR |
Db2 | UD |
Microsoft SQL Server | SQ |
Tuxedo | TU |
WWW | WW |
Java Virtual Machine | JE |
SAP Application Server | SP |
Oracle Applications | OA |
Web Servers | WS |
Storage | ST |
Other | OT |
Customer Defined | CD |
The table shortcut consists of two uppercase, alphanumeric characters representing the table. For example, the table that holds hour group details has the shortcut "HG."
The table short name consists of four uppercase, alphanumeric characters representing the concatenation of:
The table description is a string describing the table's role and content. It can consist of uppercase letters, numbers, and the underscore character.
The index description is a string describing the index’s role and content. It can consist of uppercase letters, numbers, and the underscore character.
The column description is a string describing the column's role and content. It can consist of uppercase letters, numbers, and the underscore character.
The foreign key description is a string describing the foreign key's role and content. It can consist of uppercase letters, numbers, and the underscore character.
The format for an Events table follows this convention:
PW_[environment shortcut][table shortcut]_[table description]
Due to Oracle limitations, the length of a table name cannot exceed 30 characters. For example, the table PW_ORIE_INSTANCE_EXCEPTIONS
is interpreted as follows:
PW
For all PMDB tablesORIE
For the environment shortcut (OR
) and the table shortcut (IE
)INSTANCE_EXCEPTIONS
For the description of the tableThe format for a Statistics table follows this convention:
PW_[environment shortcut][table shortcut]_[table description]_[summary level]
where the summary level comprises one character of one of the following values:
H
For an hourly summary levelD
For a daily summary levelW
For a weekly summary levelM
For a monthly summary levelDue to Oracle limitations, the length of a table name cannot exceed 30 characters. For example, the table PW_ORIS_INSTANCE_STATISTICS_H
is interpreted as follows:
PW
For all PMDB tableORIS
For the environment shortcut (OR
) and the table shortcut (IS
)INSTANCE_STATISTICS
For the description of the tableH
For the summary level (hourly)The view name does not follow any specific convention.
The format for an index of an Events table follows this convention:
IW_[table short name]_[index description]
Due to internal limitations, the index name cannot exceed 18 characters. For example, the index IW_ORIW_ID
is interpreted as follows:
IW
For all PMDB table indexesORIW
For the short name of the table PW_ORIW_INSTANCE_EXCEPTIONS
ID
For the description of the indexThe format for an index of a Statistics table follows this convention:
IW_[table short name]_[index description]_[summary level]
where the summary level comprises one character of one of the following values:
H
For an hourly summary levelD
For a daily summary levelW
For a weekly summary levelM
For a monthly summary levelDue to internal limitations, the index name cannot exceed 18 characters. For example, the index IW_ORIS_ID_H
is interpreted as follows:
IW
For all PMDB table indexesORIS
For the short name of the table PW_ORIS_INSTANCE_STATISTICS_H
ID
For the description of the indexH
For the summary level (hourly)The format for a column name in an Events follows this convention:
[table short name]_[column description]
where the column description describes the column role and content; it can consist of uppercase letters, numbers, and the underscore character.
Due to Oracle limitations, the column name cannot exceed 30 characters. For example, the column name PWLH_TYPE
is interpreted as follows:
PWLH
For the product PMDB (PW
) and the short description of the table (LH
)TYPE
For the description of the columnFor naming conventions of columns that are foreign keys, see Foreign key name.
Column names in Statistics tables follow the same naming convention as those in Events tables but add an additional element if the column type is one of the following: SUM
, AVG
, MIN
, or MAX
. In this case, SUM
, AVG
, MIN
, or MAX
are attached.
The foreign key constraint name follows this convention:
FK_[referencing table short name]_[referenced table short name]_[foreign key description]
Due to internal limitations, the foreign key cannot exceed 18 characters, which means that the foreign key description is limited to five characters. For example, the foreign key name FK_PWHM_PWHG_ID
is interpreted as follows:
FK
For all foreign keysPWHM
For the short name of the referencing tablePWHG
For the short name of the referenced tableID
For the foreign key descriptionThe foreign key column names consist of the table short name and the column name of the reference primary key. For example, a foreign key in the table PS_PWHM_HOUR_MAPPING
referencing the column PWHM_ID
of the table PS_PWHG_HOUR_GROUPS
should be called PWHM_PWHG_ID
.
| | | | | | | |