Database Reference
In-Depth Information
users. User interaction within a web site is a collection of user navigation sessions or user
sessions whose information is logged in a web server log. A user session is inferred from
a web log, which represents a sequence of requests made by the user within a defi ned time
interval.
A user session is therefore defi ned as a sequence of requests from the same IP address
such that no two consecutive requests are separated by more than
X
minutes, where
X
is a
Figure 7: User navigation session inferred from cleaned web log
Figure 8: Algorithm for recording user access paths into data warehouse
Given: materialized view V. auxiliary relations V
1
, ..., V
n
, data to be updated δR into
data warehouse view and data warehouse view V' after update.
begin
for record added in log
extract desired data fi elds and map into main table;
if access path exists
then increment the frequency pattern by 1;
else
add the new user access path into fact table;
end if
end for
// V' = V + Applied Group by δR' with Aggregate
// count by re-computing total and aggregate count
if δR comes from updates to fact table destination relation
then V' = V ∪ δR';
end if
end
