Data Warehouse Based Design And Implementation Of Mobile Application Operation And Analysis System

With the development of computer application, especially when applications emerge in the field of Internet and Mobile Internet, the amount of data in this information society explodes. More and more companies realize that huge data is not just burden but also a mine containing much valuable information. The optimization of process and cost saving and the personalized user marketing benefit from better use of this information. Data warehouse is such a basic system to perform data analyzing and data mining.This thesis introduces the data warehouse based implementation of data analysis system that provide high-quality and high-efficiency data analysis support for the decision-making person. Firstly, it explains related concepts such as Mobile Application Operation & Analysis System and Data Warehouse System, and also shows the main technologies used in building a Data Warehouse. Secondly, dimension and fact are brought out based on the requirement analyzing. Thirdly, brief design that focusing on the ETL system is presented. ETL system contains three parts:Extraction, Transformation, Loading. The section of Extraction explains the theory and difficulty in data extraction, then implements a timestamp based data extraction method. The section of Transformation shows the common fashion of dimensional modeling, also lists the detailed design of some major dimension tables. Finally, data reports of this system are compared with the current reports. By this way it validates the accuracy of this system, and declares the goal achieved.The ETL system is developed instead of using any integrated tools, and provides critical data processing support for data analysis. The system in this thesis has been in use for a period of time. The user are satisfied with it.