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.