Public Service Oriented Data Warehouse Architecture in Public Security Field

Abstract

The storage data of each application system in public security field is distributed and heterogeneous. However, the traditional knowledge discovery system and data warehouse based on homogeneous data source can not meet the needs of public security knowledge discovery. Therefore, the construction of data warehouse architecture in the public security field is the key to the successful application of knowledge discovery technology in the public security field. According to the characteristics of the public security industry, this paper designs a public security data warehouse architecture in detail. This paper focuses on the design of data warehouse system architecture, data extraction, transformation and loading, the establishment of multi-dimensional model and the display of data warehouse front-end application. In view of the deficiency of the public security organs in decision support, a public security decision support platform based on data warehouse is proposed. At the same time, this paper analyzes the design and structure of decision support system, and studies the key technologies of data warehouse, OLAP and data mining used in the process of system implementation. Finally, an example is given to show the function of the system.