Web applications such as personalization and recommendation have raised the concerns of people because they are crucial to improve customer services, particularly for E-commerce Websites. Understanding customer preferences and requirements in time is a premise to optimize these Web services. In this paper, a new data model for Web data is introduced to analyze user behavior. The merit of the cube model is that it not only aggregates user access information but also takes the Web structure information into account. Based on the model, we propose some solutions to intelligently discover interesting user access patterns for Website optimization, Web personalization and recommendation. We used the Web usage data from a sports Website in China to evaluate the effectiveness of the model. The results show that this integrated data model is effective and efficient to apply into practical Web applications.