PathArgs Summary Table


The information from the PathArgs Table is summarized to allow a variety of statistical reports to be generated.



Columns
uniqueSummaryID
frequency
startTimestamp
cardinality
webServerID
pathArgsID
hits
percentHits
averageHits





Indices

Unique
  1. uniqueSummaryID


Non-Unique
  1. frequency, startTimestamp
  2. pathArgID


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.


pathArgsID

The unique ID of the Path Arguments passed. This information is not affected by the summary frequency.


hits

Hits indicates the 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




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




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


Home Page - Reports