Key Performance Optimization Of Data Warehouse Technology In The Application Of Guizhou Local Tax

In recent years, under the impetus of the global informationization tide, informationization level also has a great development in our country. The embodiment of the informatization level is the large-scale construction of all kinds of information system. The data warehouse technology is used for the company providing some valuable information. One prominent feature of the data in the data warehouse is big, and the need to provide query service for themes. Data warehouse data synchronization is slow at this time, the data processing cycle is long, slow query data problems gradually exposed, the performance of the research at home and abroad has become research hot spot.This paper first introduces the basic theory of data warehouse and data warehouse architecture. Through the theory and architecture can know, data warehouse and the traditional database system there is a big difference. The core idea is to particle data in data warehouse processing, the detailed historical data processed into larger particles, meet the needs of the subject inquiry and business data. Due to particle data after forming, need to meet the growth of the data warehouse, build new data particles. According to the Oracle Data warehouse increasing technology and data forming technology, we know materialized views, table partitioning and the technology of index are the key technology in the all of performance optimization technology. Through the introduction of the key performance optimization technology of concrete concept, respectively, in combination with Oracle data warehouse environment, its scope of application and the optimization way of further research.In the practical application, performance optimization techniques are base on the actual data. In Guizhou local tax data warehouse widely using materialized views, table partitioning technology, index technology. In this paper, in terms of technology application, the performance optimization of comprehensive use to display.