The Tax Data Warehouse System Design And Application

Recently, there have been some new trends in the informatization process of the taxation sector. The centralization of taxation has been the major theme of the informatization process of the taxation sector. In most provincial capitals and other provincial-level cities, the applications and data have been centralized. To build an effective decision support system with data warehousing technologies has become one of the importent focus of the further development of the informatization project of the taxation authorities. The text of the results achieved mainly include the following aspects:Firstly, according to the characteristics of data warehouse,combining with the reality of the situation of the Nanjing Local Taxation's informatization project,proposed tax data warehouse design principles,designed the architecture of the tax data warehouse,described the function of tax data warehouse component in detail.Secondly,combining with the featuresof the Local Taxation,designed the tax business applications thematic framework of six major types including the tax households, taxes,acts of tax, the tax information, tax authorities and external information, analyzed and described the models of various themes in detail, and gives the describtion of relations between the entitie of the models.Thirdly, described two key technologies about ETL and front-end show in the system of data warehousing, expatiated ETL strategies and methods of tax data warehousing,gived a personalized front-end applications of the show way which against all kinds of different users.The data warehousing system has been put into practice, it has achieved good results and the informatization application has moved forward to a new step in the Nanjing Local Taxation Bureau.