Distributed and Parallel Databases

On Using a Warehouse to Analyze Web Logs

Karuna Pande Joshi, Anupam Joshi, and Yelena Yesha

March 1, 2003

Analyzing Web Logs for usage and access trends can not only provide important information to web site developers and administrators, but also help in creating adaptive web sites. While there are many existing tools that generate fixed reports from web logs, they typically do not allow ad-hoc analysis queries. Moreover, such tools cannot discover hidden patterns of access embedded in the access logs. We describe a relational OLAP (ROLAP) approach for creating a web-log warehouse. This is populated both from web logs, as well as the results of mining web logs. We discuss the design criteria that influenced our choice of dimensions, facts and data granularity. A web based ad-hoc tool for analytic queries on the warehouse was developed. We present some of the performance specific experiments that we performed on our warehouse.

BibTeX OWL Tweet Scholar

Tags: adaptive websites, data mining, data warehouse, ecommerce, web logs, web mining

Type: InCollection

Publisher: Springer

Series: ISSN:0926-8782

Volume: 13

Number: Issue 2 (March

Downloads: 3081 downloads

Google Scholar Citations: 20 citations