Ministry Of Public Security Investigations Data Warehouse And Data Mining Construction

Ministry of Public Security of information systems have now accumulated a large amount of data, including cases, household, vehicles, housing, greatly increasing the efficiency of the Ministry of Public Security, but how will the data be used for more long-term strategic decision-making, trend analysis, correlation analysis as a new challenge, so building the data warehouse case Ministry of Public Security Ministry of Public Security of information has become the focus of the next phase.This paper discusses the basic principles of data warehouse, including data warehouse concept, characteristics and modeling methods. Ministry of Public Security and the case described the process of building a data warehouse. The first is the overall architecture design, consider the two kinds of system data and external data, mainly from the public security of the system data within the system, external data in the project has not officially considered a major source of telecommunications, finance and other industries, these data may come from different structures, different types of databases, so ODI server needs to implement data extraction, cleansing, transformation and loading. Then the application software and data warehousing software selection, focuses on the latter, why choose Oracle as the data warehouse software, Oracle database software advantages relative to other where. Followed by analytical processing and data mining module design and data warehouse design, data warehouse design using dimensional models, according to the theme of customer care organization in the data warehouse can be achieved only on the basis of data mining, data mining module features a number of discussions with customers OK. Finally, analytical processing and data mining module function for example, include the following:1. In time, space, data analysis for the condition, the main scope of inquiry into the case by the time the relevant information-the time the collision, according to space, including the incident, the household registration, temporary shelter and other related information query the case-the collision of space to time and space at the same time as the conditions of the query case-related information-time and space collision; 2. to commit crimes characterized by the conditions of the data analysis, including methods of crime features, time characteristics, characteristics of the object crime in order to find cases similar information; 3. risk analysis, similar to the characteristics of crime, but the difference is mainly aimed at high risk of major cases, because these cases are the focus; 4. classification analysis, classification analysis according to the dimension or metric, such as the number of cases of deaths, injured, kidnapped the number of people, on the basis of the results can continue to do chart analysis, you can use pie charts, graphs, bar charts for more intuitive results; 5. data mining, mainly associated with analysis and sequence analysis, the former of the same occurrence of criminal cases of different types of relevance, the latter study with a criminal case has different types of relationships.