Design And Implementation Of Tongbupan Backstage Management System

With the continuous promotion of enterprise management philosophy, the competition and cooperation between internet companies both get closer. To get satisfactory business performance and realize company’s rapid development, the decision made by leaders and the correct cognition of current situation are both very important. Now is the era of digital information and the traditional analysis of management and the means of making decision should be changed to "talk with data". To develop faster and better, leaders should put more concentration on data analysis, which depends whether the decisions and the direction of development are correct. Therefore, the Extraction, arrangement and analysis of big data become necessary for most of the internet companies and software companies.The system can meet the demands of different roles of staff, such as supplying the leaders and Operating personnels with various of basic operating data and the increment of data between different time nodes. The salesmen can use the system to handle orders and query income;Operating personnels use it to manage practical functions like opening, renewing, Expansion and charging; Marketing personnels use it to open Private cloud and query. At the meanwhile, the system also includes many statistics interfaces that are frequently needed. Since entering the company, I have been in complete charge of the system including capturing the requirements, design, development and maintenance. I got requirement from the operating personnels and made a detailed design of system after requirement analysis, then I began to develop the system after getting the permission of the leader. I have completed the development of all the function modules including the pages, backstage and database development. The difficulty of the project lies on the large amounts of data and how to improve the efficiency on the premise of correction.For example, some of the functions are realized by querying with three tables each of which contains more than ten million records. Besides, iterating a table which is about20G in MongoDB is also not that easy. The system uses SpringMVC framework and the traditional business system B/S architecture to get better flexibility and maintainability. The pages are developed with JQuery and ajax to pass parameter. MyBatis is used to get and put data between the system and database. There are two kinds of databases used in this system, MySQL and MongoDB, the latter of which is a popular non-relational database with free and document oriented mode. Database connection pool is used to control the number of connection. The system uses jetty as its web server which has the advantage of Simple structure, expansion and flexibility. Maven is used as project management tool and SVN is used as version management tool.During my internship, I have developed7large modules and more than10interfaces and the system has come on stream more than20times. Now the system is put into practical use for the staff in Beijing, Shanghai and Hangzhou and gradually becomes more and more important. New requirements based on the system are put forward and I believe the system will be improved better.