社区警务系统的设计及性能优化

发布时间：2018-01-30 09:56

本文关键词： 社区警务系统索引智能缓存统计优化改进数据分页　出处：《南华大学》2014年硕士论文　论文类型：学位论文

【摘要】：随着互联网行业的繁荣和计算机技术的不断发展，基于Web的应用系统已被广泛的应用到各行各业，以达到高效办公、降低成本和提高自身竞争力的目的。社区警务系统是为衡阳市公安局开发的一个应用web技术解决社区民警日常繁杂工作的软件系统。本系统将多个警用平台的功能集于一身，并加入方位图，使得社区民警对社区的管理更加的直观，人口信息、房屋信息与实际的卫星地图相结合，使社区民警可以对社区的总体情况了如指掌，为社区民警的工作提供了便利。然而随着系统使用时间的增长，人口流动频繁而导致暂住人口的数据量越来越大，使该系统的部分功能面临着显著的性能问题。如元素复杂的页面加载缓慢，人口相关数据查询及警员绩效统计功能加载延迟太久甚至失去响应。这些问题不但直接影响警员的工作效率，往往也使警员的工作变得更加复杂和繁琐，不利于警务工作的更好开展，因此对该系统进行性能优化是一份势必执行且具有十分重要意义的工作。本文首先描述了社区警务系统的功能组成，主要包括：系统管理、方位图、人口管理、治安信息、安全防范、社情信息、群众工作、信息发布、工作量统计9个子系统。然后着重介绍了系统的设计及其开发工作。在系统的实现过程中，使用迭代开发模式，通过实地部署并对系统进行监控，不断完善运行中所发现的问题。对从系统运行中所发现的性能问题，进行数据分析，找到系统的性能瓶颈，并设计相关优化方案进行解决，主要应用的优化方案有如下几种：（1）通过数据查询计划，分析人口模块查询sql，建立适当的索引，优化后台数据的查询效率。（2）针对社区警务系统中警务人员操作人口的权限控制特点，提出了基于智能缓存策略的优化方法，进而大大提高了警务人员在操作本组织下人口数据时的工作效率；（3）通过对警务系统中统计报表类业务进行分析，，设计一种根据报表的统计数据需求，定制特有的中间结果数据暂存结构的方式（通用灵活报表统计方案），来提高报表数据统计的效率。（4）结合系统使用者的常规特点：往往更关注第一时间浏览到查询结果，而不需要看完全部数据，进而对目前已有的分页方案做优化，基于定制总数的策略进一步提高分页查询时，数据展示的效率。该系统已经持续稳定运行达两年多时间，大大提高了民警处理社区警务工作的效率，经过一系列优化之后，系统性能也满足了用户需求。
[Abstract]:With the prosperity of the Internet industry and the continuous development of computer technology, the application system based on Web has been widely used in various industries to achieve efficient office. Community policing system is a software system developed for Hengyang city public security bureau to solve the daily complex work of community police with web technology. This system will use multiple police platforms. The capabilities of. And add the azimuth map, make the community police management of the community more intuitive, population information, housing information and the actual satellite map combination, so that the community police can know the overall situation of the community. It provides convenience for the community police work. However, with the increase of system usage time, the population flow frequently leads to more and more data volume of the temporary resident population. Some of the functions of the system are faced with significant performance problems, such as the slow loading of complex page elements. Population related data query and police performance statistics function load delay or even lost response. These problems not only directly affect the efficiency of police officers, but also make the work of police officers become more complex and cumbersome. It is not conducive to the better development of police work, so the performance optimization of the system is bound to be carried out and has a very important significance. This paper first describes the functional components of the community policing system, including: system management, azimuth map, population management, public security information, security prevention, social information, mass work, information release. 9 subsystems of workload statistics. Then the design and development of the system are introduced. In the implementation of the system, the iterative development model is used to monitor the system through the field deployment. Continuously improve the problems found in the operation. From the performance problems found in the operation of the system, data analysis, find the system performance bottlenecks, and design related optimization solutions. The main application optimization schemes are as follows: 1) through the data query plan, the population module query sql is analyzed, the proper index is established, and the query efficiency of background data is optimized. 2) according to the control characteristics of police personnel's operation population in community policing system, an optimization method based on intelligent cache strategy is proposed. This has greatly improved the efficiency of police personnel in the operation of population data under the Organization; Through the analysis of the statistical report business in the police service system, the author designs a kind of statistical data demand according to the report form. In order to improve the efficiency of report data statistics, the unique intermediate result data temporary storage structure is customized (general flexible report statistics scheme). Combined with the general characteristics of the system users: often pay more attention to the first time browse to the query results, and do not need to see all the data, and then optimize the existing paging scheme. The strategy based on customizing the total number further improves the efficiency of pagination query. The system has been running steadily for more than two years, which greatly improves the efficiency of the police in dealing with the community policing work. After a series of optimization, the system performance also meets the needs of users.
【学位授予单位】：南华大学
【学位级别】：硕士
【学位授予年份】：2014
【分类号】：TP393.09

【参考文献】