VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1 - REPOSITORY Manuel d'utilisateur télécharger pdf (Page 39)

VMware, Inc. 39

Chapter 4 ADM ERD Schema

Where:

IDisaPrimarykey

NE_ID,NIC_IDandTRG_NE_IDareForeignkeys

Time Dimension

Thistableprovidesthetimedimension.Table 4‐17liststhecontentsoftheTimedimensiontable.

Where:

TIME_IDisaPrimarykey

Usage Metric

Thistableisamulti‐dimensionalOLAPfacttableforcapturingthedemandofDependency,Service,and

NetworkElement.Thegranularityofthedataisofasinglehour.Togetherwiththetimedimensionandthe

relatedentities,itisslicedanddicedasneeded.Table 4‐18liststhecontentsof

theUsagemetrictable.

MAC VARCHAR2(100) ForwardMACaddress

V_LAN NUMBER(10) VirtualLAN

TRG_NE_ID NUMBER(19) Forwardnetworkelement

Table 4-16. Switch_Address_Forwarding Table

Name Datatype Description

Table 4-17. Time Dimension Table

Name Datatype Description

TIME_ID NUMBER(19) Humanreadablenumber:yyyymmddhh

YEAR NUMBER(10) yyyy

QUARTER NUMBER(10) 1‐4

QUARTER_NAME VARCHAR2(50) Q1‐2008

MONTH NUMBER(10) 1‐12

MONTH_NAME VARCHAR2(50) January‐December

DAY_OF_MONTH NUMBER(10) 1‐31

DAY_OF_WEEK NUMBER(10) 1‐7

DAY_OF_WEEK_NAME VARCHAR2(50) Sunday‐Saturday

WEEK_OF_YEAR NUMBER(10) 1‐52

HOUR NUMBER(10) 0‐23

Table 4-18. Usage Metric Table

Name Datatype Description

ENTITY_ID NUMBER(19) Theentityoftheusagemetric.Thedatacontains

foreignkeystoallentitytypes:network_element,

service,anddependency.

TIME_ID NUMBER(19) Thetimedimensionid:numericvaluebuthuman

readable:yyyymmddhh.

BASELINE_TIME_ID NUMBER(19) Baselinetimeidcontainsthehourpartofthetime_id

(baselineisfor24hours).

VALUE NUMBER(19) Thenumberofnetworktransactionsinthe

giventime

(hourgranularity).

1 2 ... 34 35 36 37 38 39 40 41 42

Commentaires sur ces manuels

Pas de commentaire

VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1 - REPOSITORY Manuel d'utilisateur Page 39

Commentaires sur ces manuels

Produits connexes et manuels pour Logiciel de base de données VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1 - REPOSITORY