
VMware, Inc. 31
Chapter 4 ADM ERD Schema
Where:
IDisaPrimarykey
NE_IDisaForeignkey
Database
Thistablecontainsdatabaseserverandinstanceinformation.Severalinstancesmightexistforeachserver.
Table 4‐4liststhecontentsoftheDatabasetable.
Where:
IDisaPrimarykey
NE_IDandSERVICE_IDareForeignkeys
Dependency
Thistablerepresentstherelationshipbetweenasourcehost/serviceandtargethost/service(capturing
topology).Table 4‐5liststhecontentsoftheDependencytable.
VENDOR VARCHAR2
FAMILY VARCHAR2
CLOCK_SPEED_HZ NUMBER Maxclockspeed inHertz
CACHE_SIZE NUMBER CachesizeinBytes
STEPPING VARCHAR2 IdentifiesthetypeandversionoftheCPU.
DESCRIPTION VARCHAR2
COUNT NUMBER Numberofprocessorsofthistype
Table 4-3. CPU Table (Continued)
Name Datatype Description
Table 4-4. Database Table
Name Datatype Description
ID NUMBER(19) UniqueIdentifier
NE_ID NUMBER(19) Networkelement
SERVICE_ID NUMBER(19) Service
VENDOR VARCHAR2(1024) Vendorofthedatabase
SERVER_NAME VARCHAR2(1024) DatabaseServername
INSTANCE VARCHAR2(256) Databaseinstance
IS_AUTO_START VARCHAR2(1) Autostartflag(Y/N)
Table 4-5. Dependency Table
Name Datatype Description
ID NUMBER(19) Uniqueidentifier
DEPENDENCY_TYPE VARCHAR2(100) NetworkConnection,DocumentedDependency
PROTOCOL VARCHAR2(1024) Networkconnectionprotocol(HTTP,FTP,etc.)
PROTOCOL_VERSION VARCHAR2(1024) Protocolversion
TRANSPORT_PROTOCOL VARCHAR2(100) Transportprotocol(TCP,UDP)
URL VARCHAR2(512) DocumentedDependencyURL
DOC_DEP_TYPE VARCHAR2(256) Typeofthedocumenteddependency
Comentários a estes Manuais