3
The Client Host Dimension

The Client Host dimension contains attributes relating to the host that is making a request (typically to a server). Attributes stored in this dimension include the IP address of the client machine, the resolved DNS hostname, domain name, and country code.

This chapter contains the following topics:

• Client Host Dimension Hierarchies

• Client Host Dimension Levels

Client Host Dimension Hierarchies

The Client Host dimension contains the following hierarchies:

• The Client Geography Hierarchy

• The Client Organization Hierarchy

The sections that follow list all levels in each hierarchy, followed by a diagram that provides a graphical representation of the hierarchy.

The Client Geography Hierarchy

This hierarchy contains the following levels, listed from top to bottom. For details about the attributes of each level, see Client Host Dimension Levels.

• Region

• Country

• Domain

• Client Host

The Client Organization Hierarchy

This hierarchy contains the following levels, listed from top to bottom. For details about the attributes of each level, see Client Host Dimension Levels.

• Domain Type

• Domain

• Client Host

Figure 3-1 The Client Geography and Client Organization Level Hierarchies

Text description of the illustration client-h.gif

Client Host Dimension Levels

The Client Host dimension is comprised of the following levels. For each level, information about each attribute (column name) is provided in the following format:

• Attribute: Description (example value)

levels are presented in descending order. In addition to the pre-defined attributes, each level contains five "generic" attributes that can be defined by the user.

CLK_L_REGION

• Region_Code: Identifying code of the world region; natural key. (EUROPE, MIDDLE_EAST, PACIFIC_ISLANDS)

• Region_Name : Name of the world region in which a country is located. (Europe, Middle East, Pacific Islands)

• Region_Attributes 1-5: Region level user-defined attributes.

CLK_L_COUNTRY

• Country_Code : Two-letter ISO code of the country; natural key. (fi, jp, uk, UNKNOWN)

• Country_Name : Name of the country. ( Finland, Japan, United Kingdom, United States)

• Country_Attributes 1-5: Country level user-defined attributes.

CLK_L_DOMAIN_TYPE

• Domain_Type_Code : Abbreviated domain type suffix; natural key. (co, com, ed, edu, net, org)

• Domain_Type_Name : Name of the domain type. (Company, Education, Network, Organization)

• Domain_Type_Attributes 1-5: Domain type level user-defined attributes.

CLK_L_DOMAIN

• Domain_Name : Domain name; natural key. (dmsjwa.com)

• Domain_Attributes 1-5: Domain level user-defined attributes.

CLK_L_CLIENT_HOST

• Client_Host_Name: DNS hostname or IP address of the client as it appears in the access logs; natural key. (user29-dms.oracle.com)

• Client_Host_Resolved_Name : Resolved DNS hostname of the client host . (user29-dms.oracle.com)

• Client_Host_Attributes 1-5: Client host level user-defined attributes.