The Construction Of A Network Game Data Warehouse System

With rapid development of the online gaming industry over the past decade. The original experience and decision-making can not keep up the gradually increasing change of the user needs. Currently, how to wake up years of accumulated business experience of a company and use some much more scientific way to guide the online game operator in decision making has become a very important issue to every big online gaming industry. To solve this problem and enable enterprises to shift from the experience of decision-making to much more scientific solution way, more and more people have pay attention on data warehouse system.One of online gaming industry has aware the important of the data warehouse system. During the testing process of a new game, the date warehouse has been gradually designed and successfully established which supported the operational decisions and provide complex queries of cross-sectoral. The same way, they chosen and integrated some famous Business Intelligence Company’s date analysis and display platform basised on date warehouse system. During the data warehouse design, architecture, operation and management of a variety of practical problems encountered, they summarized the online game operator in support of data warehouse design and build experience. After the built of date warehouse, according the knowledge and way of Data Mining Theory and union the feature of the game, company can summarize the guide way of normal operation and the theory date supporting of practice. From the side of the argument, this support the proof of the importance of the date warehouse system in the online gaming industry decision-making. This made a good result to the early stage of normal operation, and the registered users number is more than2million, concurrent users exceeded200,000.The design and construction of date warehouse system include9steps. Basised on the practical application, and the detailed decomposition of demand, this achieve a data warehouse extracts data from various data sources and links to important breakthroughs in the data; Solved every problem of data storage, data transmission, data screening from game sever to date warehouse. According to the responsibilities of different departments and applications, flexibile permissions system has been buildup; Completed the automatically generate of a daily, weekly, monthly key performance indicators (KPI) data, curing the daily report, and will soon realize the communication with company’s office automation(OA), offer more intuitive achievement and efficiency support. Build a cross-sectoral, multi-access, multi-task service model; Build a "data stream-game development-game operator" architecture. This make the R&D and product much faster to obtain feedback from the market, than to achieve the "user-Operations-R&D" fully integrated in the data.