VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1 - REPOSITORY User Manual download pdf (Page 28)

ADM Repository Reference Guide

28 VMware, Inc.

Overview of External Database Tables

Thischapterprovidesinformationabouttheexternaldatabasetables.

Database Structure and Dependencies

Figure 4‐1illustratesthestructureanddependenciesoftheADMexternaldatabase.Arrowheadsareusedto

identifythetablekeys.

Itisimportanttonotethatsomeofthecommonlyaccesseddataisduplicatedinmanytablestoavoid

unnecessaryjoins.

Fordisplaypurposes,somedataisaggregatedtoa

comma‐separatedlist.Forexample:

 hostnames–aflatlistofoneormorehostnames.

 host_ips–aflatlistofallIPsofahost.

 groups–aflatlistofgroupstheentitybelongsto.

 Asinglerelationcalledentity_id(ingroupmembership,usagemetric,etc.)couldbejoinedwithallthree

“entity”tables(network_element,service,anddependency)althoughitisnotshownintheERDasa

foreignkey.

1 2 ... 23 24 25 26 27 28 29 30 31 32 33 ... 41 42

No comments

VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1 - REPOSITORY User Manual Page 28