Because the BMC _CORE_BMC_BASERELATIONSHIP table used by BMC Atrium CMDB to store CI relationship data is not suitable for the reporting requirements of BMC Analytics for BSM, a new table is created during installation that prepares the operational data for use in the reports.
The installation utility populates the table using the PC_DENORMALIZE_BSM_RELATIONSHIPS procedure that retrieves BMC Business Service Class CI data from the BMC _CORE_BMC_BASERELATIONSHIP table and recursively traverses the table following the relationships that identify a service model, then stores the CI, Relationship and other denormalized data in the DENORMALIZE_BSM_RELATIONSHIPS table.
You should update the table whenever relationships are updated in BMC Atrium CMDB. See Updating the DENORMALIZE_BSM_RELATIONSHIPS table for more information.
The following table shows the detailed structure of the DENORMALIZE_BSM_RELATIONSHIPS table.
Structure of the DENORMALIZE_BSM_RELATIONSHIPS table
Column name |
Type |
Description |
---|---|---|
NODEID |
VARCHAR2(38 BYTE)/VARCHAR(38) |
Stores the reconciliation ID of the CI in the business service model that is representing the current row |
LEVELNUMBER |
NUMBER |
Stores the level number for each CI in the tree as part of the root/ultimate Provider (Parent) or Consumer (Child). For example, it stores 1 for root-level parent and 2 for the immediate child when traversing from top to bottom in a tree. |
NODEORDER |
NUMBER |
Stores the node-order number for each CI in the tree as part of root/ultimate Provider (Parent) or Consumer (Child). For example, it stores 1 for root-level parent, 2 for immediate child, and 3 for another immediate child of root-level parent when traversing from bottom to top in a tree. |
RELATIONTYPE |
VARCHAR2 (254 Byte) / VARCHAR(254) |
Captures the relationship type between the CIs involved in a relationship; for example, DEPENDENCY, COMPONENT and MEMBEROFCOLLECTION |
UNODE |
VARCHAR2 (254 Byte) / VARCHAR(254) |
Stores the reconciliation identity of the root-level parent when traversing from top to bottom in a tree or root-level child when traversing from bottom to top in a tree |
REQUESTID |
VARCHAR2 (38 Byte) / VARCHAR(38) |
Stores the request ID of the row which belongs to the CI in the baserelationship table |
INSTANCEID |
VARCHAR2 (38 Byte) / VARCHAR(38) |
Stores the instance ID of the row which belongs to the CI in the baserelationship table |
UNODENAME |
VARCHAR2 (254 Byte) / VARCHAR(254) |
Stores the name of the root-level parent when traversing from top to bottom in a tree or root-level child when traversing from bottom to top in a tree |
INODE |
VARCHAR2 (38 Byte) / VARCHAR(38) |
Stores the Reconciliation identity of the immediate provider for a given CI (Consumer) |
INODENAME |
VARCHAR2 (254 Byte) / VARCHAR(254) |
Stores the name of immediate provider for a given CI (Consumer) |
RELATIONSHIPNAME |
VARCHAR2(254 BYTE) |
The name of the relationship, like "member of," "hosts," or "hosted by," that the current CI forms with the CI at the next level |
UPARENT |
VARCHAR2(254 BYTE) |
The reconciliation ID of the Business Service CI at the root of the business service model |
RELATIONSHIP |
VARCHAR2 (4000 Byte) / VARCHAR(4000) |
Captures the relationship type between the CIs involved in a relationship along with the Immediate Provider Name |
NODENAME |
VARCHAR2(254BYTE)/ VARCHAR(254) |
Stores the name of the Consumer |
NODEDISPLAY |
VARCHAR2 (4000 Byte) / VARCHAR(4000) |
Stores the name of the Consumer with -- (hyphens) based on the order which falls in the tree |
DATASETID |
VARCHAR2(254BYTE) |
Stores the dataset ID of the root-level provider/consumer |
SHOW_RELATION |
VARCHAR2 (38 Byte) / VARCHAR(38) |
Stores the relation of Ultimate Provider/Consumer with dependent CIs. It stores PARENT when traversing from top to bottom in a tree or CHILD when traversing from bottom to top in a tree. |
RELATION_CODE |
NUMBER/INT |
Stores the numeric value 0 for the parent and 1 for the children. This column is required for data translation. |
SOURCE_CLASSID |
VARCHAR2(254 BYTE) / VARCHAR(254) |
Stores the class ID of the Provider/Parent/Source (source class ID) |
DESTINATION_CLASSID VARCHAR2(254 BYTE) |
VARCHAR2(254 BYTE) / VARCHAR(254) |
Stores the class ID of the Provider/Parent/Destination (destination class ID) |