Research And Application Of Data Warehouse Technology In Nanjing Local Tax Integrated Information System

Tax is the country’s economic lifeline and an important lever of economic development. It is very significant and far-reaching to analyze tax data effectively and rationally. With the increasing speed of informatization process, data warehouse technology in the tax system has been used more commonly. By building the tax data warehouse and online analytical processing technology used in combination, which change historical data into useful information, it makes tax revenue source monitoring, natural management and tax planning and management more effective and easier, and provides decision support for the tax system a guarantee.The implementation of data warehouse project from the bottom up includes data warehouse modeling, ETL and data display. Thesis using practical application of data warehouse technology in Nanjing Local Tax Integrated Information System as the background, discussed the data warehouse modeling, ETL (Extract-Transform-Load) and data display technologies.First, the paper introduced the Nanjing Local Tax Integrated Information System data warehouse’s architecture and development tools on every level. Second it focused on modeling process of Nanjing Local Tax Integrated Information System data warehouse. Meanwhile, it did some improvements to the traditional Three-Stage modeling for data warehouse, and summarized the hierarchical design method used in our project; on the stage of logical modeling, with the the dimensional modeling method applied and specific subject combined, it presented how to design different types of dimensions, select the granularity and deal with the changing dimensions; In the physical modeling stage, data warehouse storage strategies and index strategies in the project were chosen and constructed a data warehouse with good expansibility and high efficency. Third, it gave an introduction to the project ETL process’implementation used tool ODI (Oracle Data Integrator) and other key technology. Finally, it introduced the practical application. OLAP (OLAP, On-Line Analytical Processing), data mining and other types of analysis results were displayed. The data warehouse modeling technology, ETL technology and so on applied in this thesis can also apply to other tax system with similar characteristics and provide a practical reference to other tax system around the country which wants to build the data warehouse.