Design And Implementation Of Four Acquisiton System Based On Data Warehouse

With the rapid development of the public security information,the police department has accumulated a huge amount of business data which is constituted of many kinds of species and alienated structures with constantly enrich constantly growing.How to integrate the data for sharing and eliminate the information silos to provide powerful data synthesis,analysis and query capabilities to meet the data analysis requirement of the police from different angles.In order to solve this problem,based on the large number of business databases,this paper use data warehouse technology to design,inplement and verificate the four(the key event,the key persion,the key position,the key group)acquisition system.In this paper,we finished data modeling,system frame design,system implementation and verification.This paper also extracts the four key data from the business data to establish an unified data warehouse and provides an unified,efficient and comprehensive data management for the public security work,it can be used in public security information analysis system,decision support system and other fields.This paper confucted the following research areas:Firstly,this paper discusses the issues exist in the construction of public security information,such as heterogeneous data,information silos,insufficient data utilization,the lack of comprehensive data analysis and decision-making skills.It arranges the status of data warehouse,the methods of data modeling and the process of data integration.This paper studies on the features of the popular ETL(Extract,Transform,Load)tools,and puts forward an idea to set up the four acquisition system based on data warehouse to provide an unified data base for the Police information judged.Secondly,this paper analyzes the detailed demand of the four acquisition systm and accomplishes the analysis of the theme,data modeling,analysis of the functional modules.This system uses Oracle databases,and is designed of B/S architecture based on Java technology.It is composed by the key person,the key event,the key position,the key groups and other business function modules.Thirdly,this paper implements the four acquisition system based on data warehouse.It employs the ETL tools to accomplish the process of data extraction,data transformation,da ta cleaning and data loading.This paper designs and implements the capabilities of the data warehouse and the modules of the four acquisition system.Finally,this paper validates the function and performace of the four acquisition system based on data warehouse.This paper validates the feasibility of the four acquisition system based on data warehouse in the public security information analysis and decision support system through the researches on the system.The application of the system helps the police to converge,integrate,associate and manage the four key data resources,provide the data base and resource service support for the grass-roots police,police and business leadership decision making.It effectively promote public security information technology applications and enhances the abilities of the police to ensure the sustainable development of the public security work.