Design and Implement of Transaction Data Model in Clickstream
点击流中事务数据模型的设计与实现

In this paper, we first briefly introduce the concepts of clickstream data and data warehouse, analyze two existing clickstream star schema-click star schema and session star schema in webhouse, then induce a new model-transaction star model based on them, and expressed the method of bringing out the model. Comparing with the two schemas mentioned above, its most apparent speciality is that it includes a series of meaningful page-view sequence rather than a single click. Thus, on the one hand it improves the query performance of data, on the other hand it is in favor of executing more deepen analysis-data mining, and simplifies the process of data pretreatment. At last,the paper verifies its' feasibility and validity using association rules based on the model.