The Application Of The OnLine Analytical Processing Technique In The Tax Administration

The information-based construction of our country tax administration system has developed a scale in the passed 20 years, and accumulated abundant construction experiences and results , but it also exists some problems. The outstanding performance of these problems are at following few aspects: Although accumulating a great deal of basic revenue tax data, but the data were too scattered, formed information island; The level of data applies is lower, and a great deal of data can' t convert into the information making policy quickly; There are many antinomies and problems, e. g. it was hard to examine inward and to supervise and control outward from overall and at real time. Therefore, it was necessary to construct" the taxation affairs decision support system on the basis of Data Warehousing technique" on the exiting Taxation Administration Information System. At the late of 90' s 20th century, the Data Warehousing and on-line analytical processing (OLAP) techniques and data mining techniques contain the fast breakthrough that practical product turn, decision support system ( DSS) providing the support on the technique for the decision, also developing a new path for the DSS. The Data Warehousing and OLAP technique, which can utilize the Multi-Dimensional Cube means to process and analyze masses heterogeneous data quickly, were the powerful tools. And the tools will translate thecomplicated mass data into the form of business index which the businessmen are familiar with, and the index will take on the people immediately, such as tabulation, various analytical sketches...etc. The personnel will analyze the data deeply, dynamically and at real time from various observations angle around the operation index. It will help data analysis personnel, manager, decision-maker to insight into data variety, discover the disciplinarian and provide the assistance support for scientific decision-maker. It can be solved all levels tax administration system demand (tax supervising and controlling, decision-making and analysis) successfully, throwing setting up the data warehouse and making use of OLAP. This kind of technique can carry out the big concentration of the data of the Department of Taxation of the province, the city place under the existing network environment, and under the condition of affect the revenue from tax to advertise for to take care of the system movement nowise, attain the data concentration to carry on synchronously. In mass multi-dimension information, according to the leadership concern of key index ( KPI), utilizing the OLAP technique, personnel can withdraw the data from the recent data warehouse quickly, and form the tabulation, sketch etc. And that will make the leader easily to understand. That is the best technique to realize the revenue supervising and controlling. This text introduced the origin, characteristics and advantage of the database on line analyticalprocessing, and explained in detail to set up the data warehouse and analyze the principle of the processing and carry out the process with the on-line. At the end, it take the tax administration systemas an example, building up the tax administration on line analytical processing model. And Set up the original search analysis model for the tax administration profession. According to the demand, the model can continue to expand. Returning the tax administration profession can carry on the statistical data involving into various dimension. The statistics analysis resolved the mass data multi-dimensional cube problems of taxation affairs.