A data warehouse to support web site automation

Journal of the Brazilian Computer Society

Table 1 Relationship among the tables from the proposed data warehouse and some of the most common applications for 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	×						×	×	×