Abstract: The paper introduced a design of fault data warehouse of mine local ventilation system based on OLAP, expounded architectural structure,establishment of data model and implementation of the data warehouse and its functions. The establishment of data warehouse can prevent ventilation fault effectively and provide effestive decision assistance.