The Design And Implementation Of A Public Security Information System Based On Data Warehouse Technology

Under the background of current grim situation of public security, and police shortage in technology, promote the building of information sharing and resource integration can do a lot help. Using the data warehouse technology to establish an integrated information system of public security, helps to achieve the integration of various information resources, also helps to get the business systems interoperability, greatly enriched the data resources in public security area.Combined with the actual needs, based on the software process principles, followed the steps of requirement analysis, conceptual design, logic design and physical design. Through the analysis of the problems in public security police. Design and implementation the public security information system. The author’s work included: Learn the construction methods of data warehouse and its key technologies ETL and OLAP. With the actual demand, used the thoughts of business analysis and star model. Designed the logical model and physical model of data warehouse, exhibition the design process with a police theme. Designed the rules of ETL and methods. Compared the current popular ETL tools, chose the most appropriate one and finished the data integration with tools. Designed and implemented the CUBE based on the OLAP technology.Based on the data warehouse of public security, establish the public security information system, covering the realization of the public security business of all kinds of business application integration, successfully drives the development of policing method and the technology innovation, improves the abilities of criminal investigation and public security prevention,helps the transition of policing works.