Skip to main content

Table 1 Relationship among the tables from the proposed data warehouse and some of the most common applications for web site automation

From: A data warehouse to support web site automation

  Fact tables Dimension tables
Applications Structure Usage Content Session User Referrer Time Date Page
Web personalization/recommendation   × × × ×   × × ×
Categorization/clustering of content    ×     × × ×
Automatic summarization of content    ×     × × ×
Extraction of keywords from web pages   × × × ×   × × ×
Web page ranking ×       × × ×
Web caching improvement   ×   × ×   × × ×
Clickstream/web logs analysis   ×   × × × × × ×
Analysis of web site topology × ×      × × ×
Identifying hubs and authorities ×       × × ×
Identifying web communities ×       × × ×
OLAP analysis of usage   ×   × × × × × ×
OLAP analysis of content    ×     × × ×
OLAP analysis of structure ×       × × ×