【作者】 郎大鹏；

【导师】 黄少滨；

【作者基本信息】 哈尔滨工程大学 ， 计算机应用技术， 2009， 硕士

【摘要】 随着社会保障计算机审计的逐渐铺开,由于数据量的不断增大,审计方案的不断改进等因素,在目前和将来的应用中,对于增量数据的处理、存储、识别以及传输,将逐渐成为国内外学者关注的热点领域。而联网审计工作需要打破地域限制,通过远端部署就能够开展审计工作;同时为了能及时了解社保数据不同阶段的变化情况,以便预测审计结果,增量数据的提取与识别更成为一个不容忽视的问题。本文结合已有的国内外对于增量数据的提取技术,如基于数据库自带的日志解析法、时间戳法、基于快照法、基于触发器法、基于API法以及基于变更轨迹表法等方法,提出了基于多线程技术的改进型影子表法(multi-threadbased improved shadow table),适用于多种类型的数据库中的增量数据提取。根据该方法,本文初步实现了增量数据处理系统,包括:数据转换模块、核心对比模块、指令设置模块以及结果显示模块四部分。在充分考虑了提高系统的可扩展性的前提下,采用java语言实现,增量数据、设置参数传输采用txt文本格式,允许系统管理员和审计人员对系统进行设置;同时,为了适应审计业务的需要,本增量提取系统可以由审计人员任意选择增量提取的属性,并可根据具体情况停止增量识别与提取;审计人员、软件的所有操作将被记录到日志中。最后,本文利用黑龙江省某市的真实数据,将本软件部署于审计机关的设备上,对本方法进行了测试,基本满足了联网审计业务的要求,实现了高效的信息交换并增加了审计灵活性。更多还原

【Abstract】 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.更多还原