A data warehouse to support web site automation

Journal of the Brazilian Computer Society

Table 5 Relationship among data warehouses, web data, and some of the most common applications for web site automation

	Data warehouses
	Zaïane et al.	Buchner and	Bonchi et al.	Joshi et al.	Hu and	Wu et al.	Thor et al.	Velasquez and	Moya et al.	Our
	1998 [[29]]	Mulvenna	2001 [[22]]	2003 [[25]]	Cercone	2004 [[28]]	2005 [[27]]	Palade 2008 [[8]]	2011 [[26]]	proposal
		1998 [[23]]			2004 [[24]]
Web data
Usage	×	×	×	×	×	×	×	×		×
Content		×					×	×	×	×
Structure								×		×
Applications
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										×

The character ‘ ×’ indicates that the data warehouse is designed for the web data and application. The character ‘ ⊗’ means that it supports the application, even though it has not been designed for this purpose.