Abstract: Ecological demonstration zones are developing rapidly with the development of society, bringing an increasingly larger volume of information. The information treatment is becoming ever more important and complex. Data warehouse technology started only at the end of the eighties in the 20th century and decision support system are dependent on and complementary to each other. Data warehouse technology adopts a totally new data organization mode to carry out various treatments on a large number of raw data and draw the information valuable for making strategic decision. The paper mainly describes the application of data warehouse technology in the decision support system for ecological demonstration zones, highlights the establishment of conceptual model, logical model and physical model, and expatiates the human-machine interface and the future application and maintenance of data warehouse. The paper also describes the design method and procedure of data warehouse system, and the necessity and feasibility of establishing data warehouse technology in the decision support system for ecological demonstration zones．

Key words: Data warehouse, Decision support system, Mine ecological demonstration zone