Research And Application Of ETL In The Political Work Integrated Service System Of Public Security Bureau

Under the strategy of Internet prevalence, construction of the police information system has been promoted deeply and many kinds of team management information systems have been developed. Thinking in big data and its technology are widely used in public security affairs. In order to improve the work efficiency and mode, promote political work in public security transformation and upgrading, collect and analyze data and strengthen the application of political big data, political work of police comprehensive service system needs to be built hereby. And the previous public security personnel management system is used as well.This paper proposes an scheme of ETL design and solution about political work in public security comprehensive service system by analyzing mass of data in people management system, and solves many problems for example matching data dictionary, heterogeneous multi data sources integration, jointing special fields, cleaning redundant and vain data, deleting or add fields and so on. Making use of Kettle a tool of ETL it can finish extraction, transition and loading of data and synchronise data into public security comprehensive service system.Now the data processing system on the basis of police information system has been built by integrating data. This method can guarantee system running accurately by integrate basic information using the automated process and the system has been used in a certain municipality. It offers police comprehensive service system a good environment to run accurately by executing it every day and reduces the tedious work of people increasing efficiency of data processing to a great extent.