Audit-oriented relational database aggregation algebra constraint automatic mining method
An automatic mining and database technology, applied in relational databases, database models, electrical digital data processing, etc., can solve problems such as huge computing scale, high computing cost, and huge computing space, and achieve the goal of reducing the size of computing space and reducing computing costs Effect
Active Publication Date: 2020-11-03
ZHEJIANG UNIV
View PDF2 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0004] The existing technical methods have not been able to fully meet the needs of data-driven auditing. The reasons may be: 1) There are many types of audit rules, and it is difficult to use only one set of methods to cope with the diversification of auditing needs brought about by endless business changes; 2) The defect of the huge computing space brought by the data-driven method may lead to the huge scale of the intermediate results of the operation, and it will explode with the growth of the original data; 3) The huge computing scale and high computing cost make it impossible to Complete audit work in a meaningful time
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment
[0039] Below a simplified relational database table, for example reimbursement data, as additional information on the discovery of specific embodiments of the process of polymerization algebraic constraints. D in the presence of a relational database table data reimbursement r contains five fields :( employees, departments, transportation, lodging, fees), each record in the table that contains records for reimbursement of the five fields of information; relational database D also There are other data tables s i Since independent of its particular mode of embodiment of the present embodiment, and therefore not described in detail. Auditor desired data from the database records to identify the offending claims, in addition to the simple logic of auditing rules can be obtained from a priori knowledge, fuzzy logic more complex constraint, especially polymeric algebraic constraints need to be found by the method of the present invention.
[0040] First, the first step of the polymeriza...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More PUM
Login to View More Abstract
The invention discloses an audit-oriented relational database aggregation algebra constraint automatic mining method, which is a constraint relation mining method hidden in mass data in intelligent audit application. An existing auditing rule is generated by an expert or a database constraint discovery method, the purpose of auditing simple services can be achieved, but the existing auditing ruleis not enough to deal with massive data scale challenges, and the requirement for complex operation containing statistical values in auditing operation cannot be met. Aiming at the defects, the demandform is converted into an aggregation algebra constraint, a mining method of the aggregation algebra constraint is provided, the method sequentially enumerates table connection, a grouping mode and an algebra expression according to mode information of a database, and the aggregation algebra constraint is obtained after calculation and analysis. According to the method, artificial participation in constraint mining is not needed, space-time performance challenges brought by calculation of mass data can be dealt with, and complex operation requirements related to auditing statistical values are met.
Description
Technical field [0001] The present invention relates to the audit wisdom auditing rules mining applications, and more particularly, to a relational database for audit polymerization algebraic constraints automatic excavation method. Background technique [0002] In the audit work in real life, according to the auditor to carry out audit work audit practice guidelines and expertise. Typically, the key to the smooth audit process auditors can find embodiment in that the fuzzy constraint corresponding data present in the table according to the service rules, i.e., acting on the most but not all constraints between the recording data in the table, these constraints can be as the auditing rules, play an important role in the audit work. For example, "constraint c 1 : Sum (Revenue) = Sum (expenses) "and" constraint c 2 : Transportation + accommodation <1000 "is relatively simple fuzzy constraints, can rely on the expertise given by the auditor, and then one by one to check whether t...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More Application Information
Patent Timeline
Login to View More Patent Type & AuthorityApplications(China)
IPC IPC(8): G06F16/28G06F16/2458
CPCG06F16/285G06F16/2465
Inventor江大伟陈珂张效伟陈刚寿黎但伍赛胡天磊
OwnerZHEJIANG UNIV