Research And Application On The Incremental Data Processing Technology In Network Audit

As the application of computer audit of social security in China is spreading out, because of the increasing amount of data, the continuous improvement of audit program and other factors, the incremental data processing, storage, recognition and transmission in the current and future applications will gradually become a hot area of the scholars' concern at home and abroad. The audit based on network needs to break the geographical restrictions to be able to carry out audit work through remote deployment; meanwhile, in order to know the social security data changes in different stages for predicting the outcome of the audit, the gaining and identifying of incremental data have become a problem that cannot be ignored.In this thesis, with the combination of the incremental data gaining technologies existing both at home and abroad, such as analytical method based on build-in logs in database, time stamp , the snapshot, trigger , API, as well as change trace table, a method was put forward the based on multi-thread based improved shadow table, which can be used to gain all kinds of the incremental data in the database. According to the method, the incremental data processing system was initially implemented, including four parts: data conversion module, the core comparison module, instruction set module and the results display module.Given full consideration to improve the system scalability, the system was implemented by Java, using text format for the transmission of incremental data and configure parameters in order to allow system administrators and auditors to set up the system; meanwhile, for adapting to the needs of audit business, the incremental gaining system can allow the audit staff to arbitrarily select incremental extraction properties, and can stop the incremental identification and extraction in accordance with specific circumstances; All operations of the audit staff and software will be recorded in the log. Finally, by deploying the software on the equipment of the audit institutions, this method has been tested by using the real data from a city in Heilongjiang Province. It basically meets the needs of the requirements of the on-line auditing, implements efficient information exchange and increase the flexibility of audit.