同步盘后台管理系统的设计与实现

发布时间：2018-06-24 01:21

本文选题：数据库连接池 + 数据库优化　；参考：《北京交通大学》2015年硕士论文

【摘要】：随着企业经营管理理念的不断提升,互联网公司之间的竞争和合作日益密切,想要取得令人满意的业绩和实现公司的高速发展,取决于领导层的决策和基层工作人员对当前状况的认知。如今是数字信息化时代,传统意义上的管理分析和决策手段正在发生转变,变为“用数据说话”。一个公司若想更快更好的发展,那么数据分析这块必须得到重视,这关系到公司领导层的决策是否正确以及企业的发展方向是否切实可行。如此,基于大数据量的数据提取,整理,分析就成为了所有互联网公司以及大部分软件公司必须要做的事情。本项目同时满足公司不同职能人员的基于数据统计的不同需求和运营操作。向公司领导层以及运营人员提供多项基础运营数据,不同时间节点间的数据增量等。向公司销售人员提供营帐系统,进行订单处理和收入查询。向公司运营人员提供用户开通,续费,扩容,计费等实际功能。向市场人员提供私有云开通,查询等功能。同时,本项目含有很多常用的统计接口。本人自进入公司后,交接同步盘后台管理系统,独立负责同步盘后台管理系统的需求获取,设计,开发以及维护。其中本人从运营人员手中获取需求,进行需求分析。独立完成详细设计后,向上级汇报讲解设计思路,确认无误后开始正式开发。本人开发完成了所有的模块,包括前台页面和后台逻辑以及数据库开发。项目的难点在于在数据量十分庞大时,如何在确保数据统计准确的前提下,提高效率。其中有的功能需要联查三张以上的千万级MySQL数据表,以及遍历20G以上大小的mongoDB表。为了提供更好的灵活性和可维护性,采用了商业系统传统的B/S架构,项目本身使用SpringMVC框架,页面使用j Query技术,使用Ajax传递参数,数据库使用MyBatis框架,使用的数据库为关系型数据库MySQL以及非关系型数据库mongoDB, mongoDB是最流行的一种非关系型数据库,它是模式自由和面向文档的。并有应用数据连接池来控制数据库连接资源。项目使用的应用服务器为jetty,它架构比较简单,可扩展性非常好而且非常灵活,使用的项目管理工具为maven,版本管理工具为SVN。实习期间,总计开发大型常用功能模块7个,接口10个以上,经历产品上线20余次,如今产品已经正式上线,供北京、上海、杭州的同事们使用,使用效果良好,公司越来越倚重本系统,不断有新的需求出现,目前系统仍在不断的更新和完善。
[Abstract]:With the development of enterprise management concept, the competition and cooperation between Internet companies are becoming closer and closer. In order to achieve satisfactory performance and achieve the rapid development of the company, Depends on leadership decisions and grass-roots staff's perception of the current situation. Nowadays, in the era of digital information, traditional management analysis and decision-making means are changing into "talking with data". If a company wants to develop faster and better, then the data analysis must be taken seriously, which is related to whether the decision of the company's leadership is correct and whether the direction of the enterprise's development is feasible. In this way, data extraction, collation and analysis based on large amount of data have become a must for all Internet companies and most software companies. This project also meets the different needs and operations of the company's different functional personnel based on data statistics. To provide company leadership and operators with a number of basic operational data, data increments between different time nodes, etc. To provide the company sales personnel with a tent system, order processing and revenue inquiries. To provide the company operators with user opening, renewal, capacity expansion, billing and other practical functions. To market personnel to provide private cloud opening, query and other functions. At the same time, this project contains many commonly used statistical interfaces. Since entering the company, I hand over the synchronous disk background management system, independently responsible for the synchronous disk background management system requirements acquisition, design, development and maintenance. Among them I obtain the demand from the operator hand, carry on the demand analysis. After completing the detailed design independently, report to the superior to explain the design ideas, confirm that the official development. I completed the development of all modules, including front page and background logic and database development. The difficulty of the project is how to improve the efficiency under the premise of ensuring the accurate statistics when the data is very large. Some of the functions need to check three more than 10 million MySQL data table, as well as the size of more than 20 gigabytes of mongoDB tables. In order to provide better flexibility and maintainability, the traditional B / S architecture of commercial system is adopted. The project itself uses Spring MVC framework, page uses jQuery technology, Ajax passes parameters, database uses MyBatis framework. The databases used are relational database MySQL and non-relational database mongoDB. MongoDB is the most popular non-relational database which is schema-free and document-oriented. Data connection pool is also used to control database connection resources. The application server used in the project is jetty, which has simple architecture, good extensibility and flexibility. The project management tool is maven. the version management tool is SVN. During the internship period, a total of 7 large commonly used functional modules, more than 10 interfaces, and more than 20 product launches have been developed. Now the products have been officially launched for use by colleagues in Beijing, Shanghai, and Hangzhou, with good results. The company more and more rely on this system, there are new requirements, the current system is still constantly updated and improved.
【学位授予单位】：北京交通大学
【学位级别】：硕士
【学位授予年份】：2015
【分类号】：TP311.52

【相似文献】