Design And Implementation Of A Mobile Data Statistics Analysis System For A Game Distribution Company

With the rapid development of the mobile Internet,the rapid improvement of mobile game research and development efficiency,and the continuous growth of original power,the size of the mobile game market has continued to grow.In this situation,how to make intelligent decisions and operations through data analysis and data mining has become very urgent,especially in the field of mobile Internet,where the amount of data is large and precious.In order to better meet the needs of the company's internal issuance and promotion,expand business more efficiently,and help partners obtain higher returns,it is necessary to develop a mobile data statistical analysis system based on actual business needs.The work content and characteristics of the game distribution personnel is analyzed.The research ideas of the mobile data statistical analysis system is given and the functional requirements and non-functional requirements of the system is determined.On the basis of demand analysis,the system is divided into six modules: data collection,data transmission,data analysis,data visualization,background management and data warning,and the underlying architecture of the system is designed based on AWS cloud services.In the data collection module,the Kinesis agent is used to push mobile data into the Kinesis data stream.The data transmission module is implemented in Java language.The Kinesis data stream receives and processes the user's original log reported from the mobile statistics SDK in real time,and converts it into a structured data is saved in the Redshift.The data analysis module first uses R language to analyze various operational indicators related to user behavior according to multiple dimensions such as date,country,client version,channel,sub-channel,and ad group,and then uses the current mainstream SSM open source framework to build web applications The results of data analysis in My SQL will be presented to relevant users in the form of graphs and reports in the form of retention analysis,active analysis,ROI analysis,and LTV analysis.The visualization module uses Echarts and Data Tables to implement charts and reports,and the background management module implements permission management for users,products,roles,etc.in the system.In addition,in order to allow users to find data problems in time,the data warning module provides multiple warning methods to send warning messages to users.This article designs and codes in detail to implement the four core modules of data transmission,data analysis and visualization,background management,and data warning,and uses class diagrams,flowcharts,activity diagrams,and timing diagrams to elaborate on the implementation process.Finally,in order to ensure the operating quality of the system,a test environment is actually deployed to perform functional and non-functional tests on the mobile data statistical analysis system.The test results show that the system designed and implemented with the current architecture can run steadily,the effective use time has reached more than 99.9%,and has realized all the functions in the demand analysis,achieved the expected purpose,and has practical application value.After the system is officially put into use,it provides clear and clear decision-making directions for the operators,promoters and product managers of various products,and also provides massive data resources for data mining personnel,which improves the company's game distribution The efficiency achieves the intended purpose.