Exploration on Web Usage Mining and its Application

Along with the deepening development of e-commerce, it becomes important to know the user access mode. Through Web usage mining, the server log, registration information and other relative information left by user access can be mined with the user access mode which will provide foundation for decision-making of organizations. This paper proposes a SQL Server2000 based Web usage mining solution and illustrates with authentic examples on how to use DTS, T-SQL and other tools under SQL Server2000 to realize data transfer, data cleansing, user recognition, session recognition and other data pre-processing work, and illustrates on how to use Online Analysis and Process (OLAP) as well as Data Mining (DM) under SQL Server2000 as to realize mode discovery and mode analysis. This thesis is aimed at exploring a visual Web usage mining method.

I. Introduction

The Internet is developing so fast that an increasing number of enterprises, governments, schools and other organizations set up web sites on it. With the operation of these web sites, the web site administrators are eager to know the user access model including user interests, user habits and user sources etc. which can help with operational strategies of enterprises, administrative policies of governments and the teaching approaches of schools. It will also be helpful to adjust the structure of a web site and to improve web-page information.