Design And Implementation Of The Data Warehouse On Dazhenggong Platform

Enhancing information construction of the public security organization is a necessary requirement to maintain national security and public safety, with the development of the second phase of "Jindun Project", the information construction of the public security has entered a rapid,comprehensive and depth development stage. Although the information construction of the public security has made a great progress, it still facing many challenges. Through a public survey on Dazhenggong platform the same as the public security and political work integrated service platform, finding that although the data can be shared, but the coordination ability is poor, causing the problem of information silos. In order to solve the above problems, data warehouse technology can be introduced on the original platform, it can achieve the integration of various data resources and the shares between different business systems, guarantee the data resources richness,consistency, accuracy, provide effective, reliable data sources of data analysis and data mining.In the paper, mainly to solve two problems: the first one is how to build a data warehouse; the second one is how to load the data into the data warehouse through ETL technology. 1) In the data warehouse design, the first step is based on preliminary investigations, understanding the using and construction of the system, knowing the requirements of the data warehouse;Secondly,according to the business requirements of data warehouse, making a decision of the subject areas of data warehouse; Then, through the conceptual model, logical model, physical model to complete the modeling of data warehouse; Finally, designing the granularity division and slowly changing dimension of data warehouse. 2) In the ETL design, Firstly, making a detailed analysis of data source,and establish data collection process; Secondly, according to the business requirements of data warehouse, defining the ETL overall architecture design; Finally, basing onuniversal design of data extraction, date transformation, data loading to design the operation of the ETL process; In the ETL design,the paper focuses on the incremental date extraction and data parallelism design.3) The article also analyze the application of data warehouse.At present, there existing a prototype of data warehouse which is under test and improvement phases. The construction of data warehouse on Dazhenggong platform facilitates integration of various business applications, and laid a good foundation of data analyze and data mining in the future,make a big process in construction of the public security.