In this paper, we conduct research on the web application development pattern and the UI optimization mode under data warehouse environment. Despite the application of Web standards for Web site construction, the concept, technology, efficiency has a certain advantage, but if chose the development process of application of the Web standards, should be strictly in accordance with the corresponding specification, requirements, otherwise may have serious consequences for the entire project, even failure. Under this condition, we integrate the data warehouse environment for the basic optimization. The emergence and development of data warehouse is the inevitable outcome of the computer application to a certain stage. After many years of the computer application and market accumulation, many business enterprises have saved a large amount of raw data. Our method could enhance the performance from the perspectives of effectiveness and efficiency.