Client Domains Summary Table


The information in the ClientDomains table is summarized to allow a variety of statistical reports to be generated.



Columns
uniqueSummaryID
frequency
startTimestamp
cardinality
webServerID
clientDomainID
clientDomainAbbr
hits
bytesSent
transferTime
percentHits
percentBytesSent
percentTransferTime
averageHits
averageBytesSent
averageTransferTime





Indices

Unique
  1. uniqueSummaryID


Non-Unique
  1. frequency, startTimestamp
  2. clientDomainID


Column Definitions

uniqueSummaryID

Each summary row has its own unique ID, which distinguishes it from other rows.

Description of rows entered for each summary frequency.

Hourly: Unique ID assigned to this summary row
Daily: Unique ID assigned to this summary row
Weekly: Unique ID assigned to this summary row
Monthly: Unique ID assigned to this summary row




frequency

This column indicates the frequency of the summary row--hourly (H), daily (D), weekly (W) or monthly (M).

Description of rows entered for each summary frequency.

Hourly: H
Daily: D
Weekly: W
Monthly: M




startTimestamp

The start date and time of a summary.

Description of rows entered for each summary frequency.

Hourly: The date and the hour of the day (eg. 02/22/1996 14:00:00)
Daily: The date and the midnight hour (eg. 02/22/1996 00:00:00)
Weekly: The date of first day of the week and the midnight hour (eg. 02/18/1996 00:00:00)
Monthly: The date of the first day of the month and the midnight hour (eg. 02/01/1996 00:00:00)




cardinality

Depending on the frequency (hourly, daily, weekly or monthly), the number displayed indicates the exact hour, day, week or month at the time of the summary.

Description of rows entered for each summary frequency.

Hourly: Hour of the day (0-23)
Daily: Day of the week (1-7, 1=Sunday)
Weekly: Week of the year (1-52, or 53)
Monthly: Month of the year (1-12)




webServerID

The unique ID of Web server that sent the log entry. The corresponding Web Server can be found in the WebServers table. This information is not affected by the summary frequency.


clientDomainID

The unique ID of the Client Domain derived from the Domain Name. This information is not affected by the summary frequency.


clientDomainAbbr

The abbreviated name of the Client Domain. This information is not affected by the summary frequency.


hits

Hits indicates how many times a certain Web page is accessed every hour, day, week or month.

Description of rows entered for each summary frequency.

Hourly: Total hits received for this hour
Daily: Total hits received for this day
Weekly: Total hits received for this week
Monthly: Total hits received for this month




bytesSent

Bytes sent indicates the number of bytes transmitted every hour, day, week or month.

Description of rows entered for each summary frequency.

Hourly: Total bytes transmitted for this hour
Daily: Total bytes transmitted for this day
Weekly: Total bytes transmitted for this week
Monthly: Total bytes transmitted for this month




transferTime

The number of seconds (with decimal precision) it takes to complete a transmission.

Description of rows entered for each summary frequency.

Hourly: Total time spent transmitting data for this hour
Daily: Total time spent transmitting data for this day
Weekly: Total time spent transmitting data for this week
Monthly: Total time spent transmitting data for this month




percentHits

The percentage of hits per hour, day, week or month is indicated in this column.

Description of rows entered for each summary frequency.

Hourly: Percent of total hits per hour
Daily: Percent of total hits per day
Weekly: Percent of total hits per week
Monthly: Percent of total hits per month




percentBytesSent

The percentage of bytes sent per hour, day, week or month is indicated in this column.

Description of rows entered for each summary frequency.

Hourly: Percent of total bytes sent per hour
Daily: Percent of total bytes sent per day
Weekly: Percent of total bytes sent per week
Monthly: Percent of total bytes sent per month




percentTransferTime

The percentage of time sent transferring per hour, day, week or month is indicated in this column.

Description of rows entered for each summary frequency.

Hourly: Percent of total transfer time per hour
Daily: Percent of total transfer time per day
Weekly: Percent of total transfer time per week
Monthly: Percent of total transfer time per month




averageHits

The total number of hits is averaged out for each day, week or month.

Description of rows entered for each summary frequency.

Hourly: N/A
Daily: Average hits received per hour for this day
Weekly: Average hits received per day for this week
Monthly: Average hits received per day for this month




averageBytesSent

The total number of bytes sent is averaged out for each day, week or month.

Description of rows entered for each summary frequency.

Hourly: N/A
Daily: Average bytes transmitted per hour for this day
Weekly: Average bytes transmitted per day for this week
Monthly: Average bytes transmitted per day for this month




averageTransferTime

The total amount of time spent transferring data is averaged out for each day, week and month.

Description of rows entered for each summary frequency.

Hourly: N/A
Daily: Average time spent transmitting data per hour for this day
Weekly: Average time spent transmitting data per day for this week
Monthly: Average time spent transmitting data per day for this month


Home Page - Reports