Oracle Optimization Technology Application On The Integrated Query System

Along with the development of science and technology,the application of computer is becoming more extensive,Especially in the development of China's high-speed information technology related departments of government.The information of these departments may be small to face area,or big to face the whole country.In our country's tax department,with the number of database users in tax authorities has increased dramatically,and user information is becoming more and more complex,the original simple information management system is not enough to assist in completing complicated tax work,now even hindered the tax work and reduce the working efficiency.How to access data from huge tax database efficiently,is the emphasis and difficulty in the development of tax affairs information.Based on Oracle efficient data query that is the key to improve the administrative ability in the tax authorities.This paper,taking the "tax professional management platform" of Guizhou province local tax as the foundation,introduced the tax data integrated query and optimization in the design and implementation of the tax system in our country.The highlight of this article lies in how to use the materialized view technology,index technology,partition table technology to have the comparative analysis before and after optimizing the whole comprehensive query system performance,in order to improve the efficiency of the integrated query system.This paper introduces the integrated query system in the development background of Guizhou province local taxation bureau,the original data comes from Guizhou province local taxation bureau and has strong practicability.By analyzing the query performance,this paper use the index,partitions and materialized view technologies to improve the query efficiency of comprehensive query system;Using partitioning technology as the breakthrough point,put forward in the process of query using secondary partition method;Using technology of materialized views which use data synchronization as the fundamental key to partition the materialized views,and use index technology which is based on materialized views for query optimization.On the premise of the existing database software and hardware,These optimization methods result in better query efficiency,saving the labor cost of the tax authorities at the same time.