Research On Tracking Program Of Data Path For Doubts Examination

The social security relates to everyone's vital interest, so the supervision is especially important to the audit work. And the audit institutions bear the responsibility of the supervision to the work of social security. In the work of audit, when the audit doubts have emerged, it is unresolved that how to judge the accuracy and reliability of audit doubt and how to find the source data of the relational information of the audit doubt. The techniques that make the auditors could track the source data which generates the corresponding audited doubt are needed to be provided.This thesis is started from the lineage of data and combined with the data lineage techniques which are exist both at home and abroad and take the verification issues of the audit doubts as the study object. The methods that resolved the concrete problem of the issues for doubt examination are provided through discover and classified the related problems of the doubts examination and study the scarcity of the existing methods. It includes the creation of auxiliary views, the retrieval of the prosperity level lineage information, the retrieval of the form level lineage information, the classified study to the auxiliary views, the auto construction of the auxiliary database, going against the audit methods, going against the transformation of the templates and going against the integration of the multi-table, use query rewrite technology to resolve the problem includes query. The concrete algorithms that resolved the related problems are provided through the in-depth analysis to the concrete problems that appear during the doubt examination. Since the algorithms are provided according to the classification to the concrete problems, it could be used to the other similar problems after slightly modification to each algorithm.At last, this thesis shows the functions of generation of the doubts tables, the examination of the doubts and the authentication to the doubt verification by the experiments. So the accuracy mentioned above is verified and the performance of the doubts examination is analyzed through the tracking program of data path for doubts examination.