The Design Of VAT Monitoring And Analysis System Based On Data Warehouse

VAT(Value Added Tax) is a kind of tax that nations levy upon the added value comes from sales, processing, repair services and even import which operated by person or corporations. Recently, VAT has become one of the most important taxes. Since1994, China carried out the reform which makes VAT as the main body of tax system, in order to use high-tech means to curb the behavior of tax evasion by using VAT invoices, Our nation started the Golden Tax Project which composed by anti-forgery tax control system and cross-auditing system. The monitoring and analysis system for the input and output of VAT is attached to and serving the anti-counterfeiting tax control system, relying on taxpayers end security tax billing software and online authentication software, purchased by the taxpayers, than selling goods on the analysis of information, strengthen tax people buying and selling things in the monitoring of information, to detect abnormal buying and selling, yin and yang, tickets and other violations. Data warehouse technology is an important technique used in data analysis and business decision support. It has some basic principles:1. subject-oriented;2. integration;3. being relatively stable;4to reflect changes in data. So that the data warehouse technology could be used successfully for data analysis and decision support. This paper would use the data warehouse as a technology-based, dimensional modeling and ETL process as the main data processing techniques, and the B/S architecture as the construction to design and implement the VAT monitoring and analysis system.Firstly, this paper describes the background and meaning of this project, and the presentation and discussion of current research in related fields. After that, the requirement for this project has been briefly analysed. Based upon those above, we propose our main tasks during the development of this project, and make the plan of organizational structure of this paper.After that, this paper discusses the analysis of the systematic product demand, the main functions of the system implementation and characteristics of the users. After that, this paper further elaborated the functional and non-functional requirements-of the system and discusses the project focused on solving the problem. Paper carried a summary of the design of this system, proposed technical solutions, deployment architecture diagram and draw a network topology diagram of the system, determined the development platform and runtime environment. After all, paper made the design of the framework and described the functionality and business logic of each module.The next chapter, this paper designs the data warehouse of this system in detail, which focuses on the ETL processes and dimensional modeling. Firstly, this paper explains the external data sources in this project. After that, paper describes ETL process. The core of that is programming the procedures. ETL process extracts the information of taxpayers, tax invoices and tax authorities from the massive amounts of data in those data sources. And in accordance with reasonable rules for data cleaning and conversion, the final processed data will be loaded into data warehouses built by us. Then paper makes the dimension modeling of data warehouse system. It designs dimension tables for date, taxpayers, tax authorities and other dimension tables and fact tables for Yinyang Invoices, Zhiliu Invoices and Several topics under one number. After that, the metadata of data warehouse, exception handling, and system management optimization will be introduced. Finally, we take use of BI@Report to achieve front-end design and the design of query and report of invoice information and doubtful information.After the requirement analysis, programing and system testing, our system achieves the desired objective, which takes an effective use of existing technology to control system security, combines with advanced data analysis methods to detect, locate and resolve the problems of enterprises that take advantages of VAT invoices for tax evasion. With the implementation of the monitoring system, we could further deepen the managing ideas of tax control and information management, and make up the missing items of tax authorities’ monitoring information to take effective containment and deterrence against those unscrupulous companies which commit a falsifying crime.