The Application Study Of Data Warehouse Technique In The Police Office Of Jiangxi Province Complex Information Analysis

The Chinese police departments shoulder the tasks of combating criminal ofences, maintaining social order, administrating and providing services to the society. The police informatization covers wide areas,complicated operations and huge quantities of data. It has become a key link in the informatization of the police work to apply the technology of data warehouse and set up an analyzing system of comprehensive information of police work that may satisfy the requirements in data inquiry, analysis and data mining.This paper starts from the concepts of decision-making support and data warehouse, and introduces respectively the concepts of decision-making support and data warehouse, the ETL process of the data warehouse, the related concepts and methods of on-line analyzing process, data mining technology and the scheme of resolving the existing databases. In its demand analysis;this paper introduces the scope of the research topic,the technical methods the system has adopted, the means of research and the concrete themes for analysis. In the realization of the design, this paper expands mainly on the process of installation and configuration of the data warehouse system, the process of realizing data extraction, conversion and loading, the process of building a multi-dimensional model and the process of using front-end analytical tools. Listed at the end of this paper are some related analytical results obtained by applying this system and the direction of development of this system at a later stage.The thesis has found an in-depth, practical way to valuable-added information exploration by means of having made full use of present information resources and explored the founded information of application data. The research results will, to some extent, be instructive to the future batebice establishment of the police system and the application of data- advancement techonology.