Abstract: In Public Security Industry, with the gradually promoting informationization work, only using business data-base to handle alert, case handling, security business work already can not meet the demand, so the construction of data warehouse is the must. According to the characteristics of public security, this paper gave a solution which is suitable for public security industry data warehouse system .In this project overall design and implementation phase, this paper expouned the data warehouse system of data extraction, conversion and loading, the establishment of multidimensional modcl,data warehouse front application show.

Key words: Data warehouse, Public Security Industry, Data model, ETL