The Design And Implementation Of Tax Data Warehouse System

With the rapid development of information technology, information technology has been introduced into all walks of life, being used in the production area and management field. The tax authorities have experienced10years information development and have obtained some results. The online transaction information system we are used currently is more than ten. On the one hand, they improved the efficiency of tax authorities to a certain extent; On the other hand, they accumulated the massive collection data which is the precious resources of the tax authorities. However, due to the data is scattered and lack of effective explosion and using, we fall into the situation of data explosion and lack of information.Data warehouse and OLAP is a platform of information provided. They obtain the data from business processing system and organize data with star model and snowflakes model. They can provide users with the means of accession to information and knowledge, so as to reveal the valuable knowledge and technology which hidden after the dater. They can help the tax authorities to analysis the behavior of the taxpayer from the large collection of data, and to identify the tax declarations whether is true or not. So that, they strengthen the collection and lock the examiner target. Finally, they reduce audit costs. They also can analysis the development of various industries in order to provide useful decision-making information for the government decision making.This paper has carried on a preliminary exploration for establishing a tax data warehouse system for technical route as open source projects Jpivot and currently popular web technology using OLAP analysis of the data in Yunnan province. It based on the management information system data resource in Yunnan province local tax bureau and Microsoft SQL2005database system. There are two main achievements: One is the analysis and design on how to build a data warehouse of Yunnan local tax system. It based on the accumulation of a large number of business data. Two is building a data warehouse of tax system using SQL2005based on the collection data, and giving a show of the data warehouse in the tax authorities.