The Data Storehouse Technology Synthesizes Application In Information System In Public Security

With the "Golden Shield Project" the full implementation of public security work of building the information the rapid development, public security organs nationwide have completed the province as a unit or units to the city's population to basic information resource base, criminals who are information resource database, run Information resources for staff and other key information resource library. But its application independent data storage systems, business data by the business sector from the computer system to produce and management, data storage forms vary, it is hard to achieve between applications to share visits, to meet top leaders on cross-business Departmental and inter-time data for comprehensive analysis and correlation analysis. For this reason the papers were starting data warehouse technology to public security in the integrated information system so as to solve the problem.In this paper, making full use of existing resources in public security information library, in-depth digging has been completed and the application of the current database of information, data warehouse technology will be introduced to the public security of the application of information systems. From the data warehouse concept, introduced the concept of data warehousing, ETL process, on-line analytical processing-related concepts and methods as well as existing data warehouse solutions. At the same time immigration officers for information management theme, the theme of information criminals, stolen vehicle information theme, the case information for analysis and modeling theme, a data warehouse system on the use of ETL tools for heterogeneous data sources of data extraction, transformation and loading of Implementation process, multi-dimensional model of the process. Finally also cited the application of this system is the result of a number of related systems and the development direction of late.