CN107480188B - Audit service data processing method and computer equipment - Google Patents
Audit service data processing method and computer equipment Download PDFInfo
- Publication number
- CN107480188B CN107480188B CN201710559074.2A CN201710559074A CN107480188B CN 107480188 B CN107480188 B CN 107480188B CN 201710559074 A CN201710559074 A CN 201710559074A CN 107480188 B CN107480188 B CN 107480188B
- Authority
- CN
- China
- Prior art keywords
- service
- label
- audit
- relation
- entity
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/288—Entity relationship models
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The disclosure provides an audit service data processing method and computer equipment. The method comprises the following steps: establishing a service label of audit result data, wherein the service label comprises a service label value entity and a service label name entity, the service label value entity comprises a label value number, a label name number, a label value description and an in-use mark, and the service label name entity comprises a label name number, a label name and an in-use mark; creating a service label value relation entity of a mesh relation between service labels, wherein the service label value relation entity comprises a father label value number, a father label name number, a son label value number and a son label name number; and storing the service label value entity, the service label name entity and the service label value relation entity into a relational database. The method and the equipment provided by the disclosure can conveniently display the incidence relation among the service labels, and avoid the problem of resource waste caused by virtual or redundant nodes and the problem of display and maintenance after the relation is released.
Description
Technical Field
The present invention relates to a data processing method, and more particularly, to an audit service data processing method and a computer device.
Background
In the related art, a tree-shaped problem classification system is generally used for positioning, classifying, counting, analyzing and the like of audit data. According to the audit data processing method, when a user selects a higher-level problem entry, a plurality of lower-level problem classifications are inquired and expanded, and then the lower-level problem classifications are used for correlating audit results.
On one hand, if a certain node in the tree structure has a superior-inferior relation with a plurality of nodes, the relation of the associated nodes cannot be displayed correctly, and the common processing method is to use redundancy or virtual nodes to keep the tree structure complete, so that the processing mode can cause resource waste. On the other hand, if the coupling degree between the service data classifications is high, the classification relations are related through strict upper and lower level relations, and if a certain classification is disassociated from the upper level classification, the classification and the sub-classifications thereof cannot be displayed in the relation tree, and the maintenance difficulty is high.
Disclosure of Invention
The utility model provides an audit service data processing method and computer equipment, which establish a network-structured service label for audit result data, facilitate displaying the incidence relation between the service labels, and avoid the resource waste problem caused by virtual or redundant nodes in the related technology and the display and maintenance problem after the relation is removed.
According to a first aspect of the embodiments of the present invention, there is provided an audit service data processing method, which may include: establishing a service label of audit result data, wherein the service label comprises a service label value entity and a service label name entity, the service label value entity comprises a label value number, a label name number, a label value description and an in-use mark, and the service label name entity comprises a label name number, a label name and an in-use mark; creating a service label value relation entity of a mesh relation between service labels, wherein the service label value relation entity comprises a father label value number, a father label name number, a son label value number and a son label name number; and storing the service label value entity, the service label name entity and the service label value relation entity into a relational database.
In some embodiments, the method further comprises: and establishing a relation entity of the business label and the audit result of the relation between the business label and the audit result data, wherein the relation entity of the business label and the audit result comprises an audit result number, a business result type number, a label value number and a label name number.
In some embodiments, the method further comprises: when a service label is newly added in the mesh relation, the newly added service label and the existing service label in the mesh relation are established into an association relation.
In some embodiments, the business label value belongs to one or more business label names, including audit units, processes, links, product lines, product groups, base products, saleable products, business systems, and channels.
In some embodiments, the method further comprises: and displaying the service labels according to one or more label names in the service label names and the hierarchical sequence of the service label names set by the user.
In some embodiments, the method further comprises: generating one or more audit test records according to the audit test points, wherein the audit test points are used as the incidence relation between the audit result and one or more service tags and are stored in the corresponding service tags and the corresponding relation entities of the audit result, generating one or more audit evidence obtaining manuscripts according to the one or more audit test records, and copying the corresponding service tags and the corresponding relation entities of the audit result to the one or more audit evidence obtaining manuscripts used as the audit result.
According to a second aspect of embodiments of the present invention, there is provided a computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing when executing the program: establishing a service label of audit result data, wherein the service label comprises a service label value entity and a service label name entity, the service label value entity comprises a label value number, a label name number, a label value description and an in-use mark, and the service label name entity comprises a label name number, a label name and an in-use mark; creating a service label value relation entity of a mesh relation between service labels, wherein the service label value relation entity comprises a father label value number, a father label name number, a son label value number and a son label name number; and storing the service label value entity, the service label name entity and the service label value relation entity into a relational database.
In some embodiments, the processor, when executing the program, further implements: and establishing a relation entity of the business label and the audit result of the relation between the business label and the audit result data, wherein the relation entity of the business label and the audit result comprises an audit result number, a business result type number, a label value number and a label name number.
In some embodiments, the processor, when executing the program, further implements: when a service label is newly added in the mesh relation, the newly added service label and the existing service label in the mesh relation are established into an association relation.
In some embodiments, the business label value belongs to one or more business label names, including audit units, processes, links, product lines, product groups, base products, saleable products, business systems, and channels.
In some embodiments, the processor, when executing the program, further implements: and displaying the service labels according to one or more label names in the service label names and the hierarchical sequence of the service label names set by the user.
In some embodiments, the processor, when executing the program, further implements: generating one or more audit test records according to the audit test points, wherein the audit test points are used as the incidence relation between the audit result and one or more service tags and are stored in the corresponding service tags and the corresponding relation entities of the audit result, generating one or more audit evidence obtaining manuscripts according to the one or more audit test records, and copying the corresponding service tags and the corresponding relation entities of the audit result to the one or more audit evidence obtaining manuscripts used as the audit result.
According to the auditing service data processing method and the computer equipment provided by the embodiment of the invention, the service label is established for auditing result data through the service label value entity and the service label name entity, and the network system of the service label is established through the service label value relation entity, so that the incidence relation of the service label can be displayed according to the user-defined hierarchy system of the service label name, even if the incidence relation between the service labels is released, the corresponding items of the service label value relation entity can be modified, the incidence relation between the service labels can still be displayed, and the problem of displaying after the relation is released due to strict upper and lower hierarchy relations in the prior art is avoided; moreover, compared with the mode of displaying audit service data by using redundant nodes or virtual nodes in the prior art, the service label can be displayed according to the service label hierarchy defined by the user without virtual redundant service label nodes, so that the flexibility of displaying audit result data is improved.
Drawings
Fig. 1 is a flowchart illustrating an audit transaction data processing method according to an embodiment of the present invention.
Fig. 2 is a schematic diagram of a data structure of a service tag according to an embodiment of the present invention.
FIG. 3 is a screenshot of a business label presentation according to one embodiment of the invention.
FIG. 4 is a screenshot of a business label presentation according to one embodiment of the invention.
FIG. 5 is a screenshot of a business label presentation according to one embodiment of the invention.
FIG. 6 is a schematic diagram of a relationship between a service label and an audit test point according to an embodiment of the present invention.
FIG. 7 is a schematic diagram of a computer device according to an embodiment of the present invention.
Detailed Description
Various aspects of the invention are described in detail below with reference to the figures and the detailed description. Well-known modules, units and their interconnections, links, communications or operations with each other are not shown or described in detail. Furthermore, the described features, architectures, or functions can be combined in any manner in one or more implementations. It will be understood by those skilled in the art that the various embodiments described below are illustrative only and are not intended to limit the scope of the present invention. It will also be readily understood that the modules or units or processes of the embodiments described herein and illustrated in the figures can be combined and designed in a wide variety of different configurations.
The terms used in the embodiments of the present invention will be briefly described below. It should be noted that these descriptions should not be construed as limiting these terms.
The business label value is formed by extracting the business characteristics of the audit result, is a classification of the audit result data, and is mainly used for describing the business characteristics of the audit result data from multiple dimensions.
The service tag name is a packet type of the service tag value, and one service tag value may belong to one service tag name or to a plurality of (for example, greater than or equal to 2) service tag names.
And the service label comprises a service label value and a service label name to which the service label value belongs. For example, the 'small business credit business' is a business label value, the 'auditing unit' is a business label name, and the two are combined to form an auditing business label. Service labels are a classification of service characteristics and may also be a carrier of service capabilities. Part of the service tags have a superior-inferior relation, but the service tags can also have no superior-inferior relation.
The audit result can comprise: the method comprises the steps of auditing a project plan, auditing projects, auditing scheme items, auditing test points, auditing evidence obtaining manuscripts, auditing problem finding, auditing data, internal control points, internal control validity evaluation, a basic auditing scheme, an auditing tool, a predefined flow and the like.
Referring to fig. 1, fig. 1 is a schematic flow chart of an audit transaction data processing method according to an embodiment of the present invention, where the method may include:
s101, establishing a service label of audit result data, wherein the service label comprises a service label value entity and a service label name entity, the label value entity comprises a label value number, a label name number, a label value description and an in-use mark, and the service label name entity comprises a label name number, a label name and an in-use mark;
s102, creating a service tag value relation entity of a mesh relation among service tags, wherein the service tag value relation entity comprises a father tag value number, a father tag name number, a son tag value number and a son tag name number;
s103, storing the service label value entity, the service label name entity and the service label value relation entity into a relational database.
The embodiment of the invention mainly processes the auditing result data in the auditing service data, including expression, classification, storage, query and the like. The method of the embodiment of the invention can be applied to the auditing system of the BS structure with the following modules:
and (4) evaluating audit risks: through the multidimensional risk assessment of the audit unit and the audited mechanism, an accurate and quantifiable audit risk assessment result is formed, and a basis is provided for planning an audit project. The method is a mandatory requirement of external supervision on risk oriented audit, and an audit mechanism quantitatively measures audit risk conditions of an audit unit and an audited mechanism by adopting modes of internal control defect analysis, expert scoring and the like and combining with the prior audit coverage.
Planning an audit project: compiling an audit project plan according to a plan period, determining an expected range, an organization mode, implementation time and resource requirements of the audit project to be developed, and balancing audit resource allocation. The method is a project establishment basis of the audit project, and the audit organization overall arranges audit resources according to a risk guiding principle and performs pre-deployment and arrangement on the audit project to be developed in a plan period.
Preparing an audit project: the target, range and resource requirement of the audit project are determined, the work flow and the audit method of the audit project are determined, and the audit test work is guided. Is the first stage that an audit project must execute. And selecting and starting a project group from the listed auditing projects, allocating auditing resources for subsequent auditing test work, customizing an auditing flow, determining a test method and the like.
And (4) executing audit test: and executing an audit test according to the test content and steps determined in the overall audit scheme and the specific audit scheme, recording the test process and the audit difference, and forming, communicating and confirming audit finding and audit problems. The method is a main step in an auditing program, and is characterized in that an auditor compares the working condition of an auditing object and auditing basis by adopting modes of interviewing, observation, review, recalculation, reasonable inference and the like according to auditing test points and a test sample table to form a test conclusion, forms auditing findings and problems according to professional judgment, and provides an improvement suggestion.
Evaluating the effectiveness of internal control: by evaluating the effectiveness of internal control, the internal control condition of an audited unit is known, and reference is provided for subsequent risk assessment and formulation of an audit project plan. The auditing mechanism records the control effectiveness grade, internal control defects, residual auditing risks and the like of the internal control unit which has been subjected to the auditing test by the audited unit according to a set evaluation standard.
Compiling an audit report: by summarizing and analyzing the results of the audit project and deeply mining, an audit viewpoint and a service improvement suggestion are formed and communicated with a proper management layer. According to the management requirement or the report caliber, the audit result formed in the audit project is reasonably organized, quickly retrieved and efficiently utilized, and the audit result is deeply processed, audited and issued according to a specific work flow.
And (4) monitoring an audit project: a supervising role is set in the process of the audit project to synchronously supervise the project quality, and deviation rectification can be performed on the project under necessary conditions so as to improve the process quality control of the audit project. The method is an important measure for auditing project process control, and the auditing supervision carries out parallel supervision on the auditing project process, can provide supervision opinions with experts, suspends the auditing project when necessary, corrects execution deviation, and ensures the process quality of the auditing project to be effectively controlled.
Evaluating an audit item: by checking the members, the process quality and the project results of the audit project, the quality of the audit project is evaluated, and the continuous improvement of the project management level is promoted. The method is an important link for quality control of the audit project, and measures the management level of the audit project through metering and comprehensive evaluation on the process execution effect, the audit result and the performance of an auditor.
And (3) implementing audit trail: by implementing audit trail, the correction condition of the audited unit to the audit finding problem is mastered, the problems and the defects existing in the audit correction work are revealed, the residual risk is evaluated, and the effective use of the audit result is promoted. The final stage of the auditing program is based on the problems found in auditing, and adopts the strategies of reporting and tracking, merging and tracking, item establishing and tracking and the like to continuously supervise and evaluate the auditing and correcting work effect of the audited unit.
Maintaining an audit test library: an auditing method and a testing step library for main banking business are established, and the establishment, the release, the use and the modification of a full life cycle maintenance of an auditing testing point and a basic auditing scheme are realized. The audit test base is a core knowledge base of audit service, and auditors study test points and basic schemes in the test base in a mode of independent research and development, modification suggestion proposal and the like, and the test points and the basic schemes are used for audit projects after being audited and released.
Implementing auditing specialization: through continuous research on audit tools, techniques and audit project organization modes, the work competency of auditors is improved, and virtuous circle of research guidance audit projects and project promotion professional research is formed. The method is one of important measures for improving the internal audit core capability, and based on professional division of labor of an audit organization, research and innovation work is carried out on audit processes, methods, technologies, tools and the like by adopting a normalized and systematized operation mechanism.
Evaluation audit organization: the working condition of the auditing mechanism in the evaluating period is comprehensively evaluated, and the evaluating result is used for generating positive guidance for the work of the auditing mechanism, so that the continuous improvement of the auditing working quality is promoted. Is one of measures for guiding an auditing mechanism to improve the working quality. Based on the statistical data of the work results of the auditing mechanism, the reasonable calculation method is used for regularly and quantitatively evaluating the work results of the auditing mechanism by using specific standards and indexes.
Confirming audit problem responsibility: standardize and strengthen the responsibility treatment of the audit finding problem, form the sustainable and operable responsibility affirmation mechanism, ensure the responsibility affirmation and the responsibility investigation in time and in place, and improve the seriousness and the effectiveness of the audit work. The system is an important measure for fulfilling the requirements of checking, identifying and supervising and correcting, and a responsibility identification mechanism is used for providing reference for executing responsibility inquiry and tracking and supervising the responsibility processing condition for the fact of the audit problem and the identification of related mechanisms, posts and personnel.
Through these modules, 12 audit results can be generated and maintained: the method comprises the steps of auditing a project plan, auditing projects, auditing scheme items, auditing test points, auditing evidence obtaining manuscripts, auditing problem finding, auditing data, internal control points, internal control validity evaluation, a basic auditing scheme, an auditing tool and a predefined flow. The audit result data can set the number of the audit result and the type of the business result, for example, each audit result of the 12 audit results can have an audit result number, and each audit result can belong to a certain type of the business result.
The above method will be described with reference to specific examples.
In step S101, data mining is performed on the audit result data generated in the audit system, a service tag value of the audit result data is generated, and a service tag name is obtained according to the service tag value analysis, thereby establishing a service tag of the audit result data. The service label comprises a service label value entity and a service label name entity, wherein the service label value entity comprises a label value number, a label name number, a label value description and an in-use mark, and the service label name entity comprises a label name number, a label name and an in-use mark.
In some embodiments, the business tag name can include audit units, processes, links, product lines, product groups, base products, saleable products, business systems, and channels. The business label names may have a top-bottom relationship, for example, the auditing unit, flow and link are sequentially from top to bottom.
Step S102, establishing a mesh relation among the service labels through a service label value relation entity, wherein the service label value relation entity comprises a father label value number, a father label name number, a son label value number and a son label name number. The relationship establishment of the father label value, the father label name, the son label value and the son label number is according to the closeness degree and the coupling degree of the business relationship among the business labels. In a mesh structure, all service tags can be associated, and any tag can find other tags through single or combined association.
The service label is a combination of a service label name and a service label value, and is unique in a mesh system of the service label, and each service label name and each service label value are respectively unique. Moreover, the business label names may have a hierarchical relationship, for example, the business label names "audit unit", "flow" and "link" have a hierarchical relationship, so the business labels attached under the business label names are as follows: the ' private bank ' audit unit ' - ' channel management ' process ' - ' electronic channel ' link ' can be displayed on a tree structure.
For example, for the business label private bank @ audit unit, where the private bank is the business label value and the audit unit is the business label name, the process under the business label may include: a transaction management @ flow, a comprehensive management @ flow, a customer management @ flow, a product management @ flow, a service management @ flow and a channel management @ flow; for the channel management @ process, the following links may include: the method comprises the steps of construction of a special mechanism @ link, an electronic channel @ link, important article control @ link and a safe deposit box service @ link. The business label private bank @ auditing unit can be directly related to the business label channel management @ process, and the business label private bank @ auditing unit can skip the business label channel management @ process and establish a relationship with an electronic channel @ link at a link level, and the relationship can be regarded as indirect relationship. In such a mesh-structured service label architecture, one service label may find other service labels through one or more paths.
In step S103, the created service tag value entity, service tag name entity, and service tag value relationship entity are stored in the relational data, so that the user can perform subsequent query. After storing the entities in the relational database, the user can inquire all the service labels which are directly or indirectly associated with the service label through one service label. Even if the incidence relation between one service label and another service label is removed, the parent label value number, the parent label name number, the child label value number and the child label name number in the service label value relation entity in the database are modified, other incidence service labels of the service label can still be displayed, and the problem that the relation between the service labels cannot be displayed after the incidence relation is removed by using a strict expression mode of the upper and lower relation in the prior art is solved.
In some embodiments, when a service tag is newly added in the mesh relationship, the newly added service tag must be associated with an existing service tag in the mesh relationship, and the existence of the newly added service tag that is not associated with the existing service tag in the mesh relationship is not allowed. That is, in the business label mesh relationship system, each business label will have an association relationship with other business labels, and an isolated business label is not allowed to exist.
In some embodiments, the auditing business data processing method may further include processing the association relationship between the auditing result data and the business label, and such processing may include: and creating a relation entity of the business label and the audit result for expressing the incidence relation between the business label and the audit result data, wherein the relation entity of the business label and the audit result can comprise an audit result number, a business result type, a label value number and a label name number. The created relation entity of the service label and the audit result is stored in a relational database together with the service label value entity, the service label name entity and the audit service label value relation entity, so that a user can conveniently inquire the service label and the associated audit result data. The service label can be transferred by a relational entity which copies the service label and the audit result. In a particular embodiment, the data model of the business tag may be as shown in FIG. 2.
In some embodiments, the auditing service data processing method may further include receiving a user-defined query, and presenting the query in a user-defined format, for example, the method may include: and displaying the service labels according to one or more label names in the service label names and the hierarchical sequence of the service labels set by the user. The hierarchical order of the service tags can be set arbitrarily, and the service tags can be displayed according to the inherent hierarchical order among the service tag names, or the inherent hierarchical order among the service tag names can be displayed in a disordered way. Moreover, the business labels can be freely combined for inquiry, for example, the product line, the product group, the base product and the saleable product can be displayed according to the hierarchical sequence of 1, 2, 3 and 4, or the product line and the saleable product can be displayed according to the hierarchical sequence of 1 and 2 respectively. In addition, the user-defined query history can be saved, and the input workload when the user enters the page query again is reduced.
The display method of the query data provided by the embodiment of the invention greatly improves the flexibility of the data display of the audit result and avoids the problem that the data can be displayed only according to strict upper and lower level relations in the prior art; moreover, the display mode does not need virtual service label nodes, and even if the association relationship between a certain service label and other service labels is released, the association relationship between the service labels can still be displayed.
In a specific embodiment, it has been mentioned above that the auditing units, processes and links in the service tag name have a relationship between upper and lower levels, and then the user may choose to show the relationship of the service tag according to the inherent relationship between upper and lower levels, for example, the screenshot may be as shown in fig. 3. In fig. 3, the service label private bank @ audit unit, channel management @ flow, electronic channel @ link may be presented in the order of audit unit, flow, link.
In another embodiment, if two service tag names of the audit unit and the link are selected and the audit unit and the link are in the order from top to bottom, the service tag private bank @ audit unit may also skip the channel management @ flow and establish an association with the service tag channel management @ flow, and the screenshot may be as shown in fig. 4. The display mode is flexible, and the user operation is simplified.
In another embodiment, the upper and lower orders of the audit unit, the flow and the link can be disturbed, and the service label can be displayed according to the order of the link, the audit unit and the flow. The level sequence of the audit unit, flow and link can be 2, 3 and 1, and the screenshot in the display form can be as shown in fig. 5. And, under such presentation form, the query can be associated to the channel management @ flow.
In some embodiments, the auditing service data processing method may further include: generating one or more audit test records according to the audit test points, wherein the audit test points are used as the relationship entities of the corresponding service labels and the audit results in the association relationship between the audit results and one or more service labels; and generating one or more auditing evidence-obtaining manuscripts by the one or more auditing test records, and copying the corresponding business labels and the relation entities of the auditing results to the one or more auditing evidence-obtaining manuscripts serving as the auditing results.
The audit test point is an audit business unit which is arranged by an auditor according to the business characteristics, and the audit test point can be associated with a corresponding business label to determine the corresponding characteristics of the audit test point. For example, in a certain audit test point, the associated service label can be system entry associated party information @ link, associated party management @ flow, and associated transaction management @ audit unit. The audit test point, as an audit result data, can store the association relationship of one or more service labels associated with the audit test point to the relationship entity of the service label and the audit result corresponding to the audit test point.
During the auditing work, one or more auditing test records are generated according to the auditing test points, and the auditing test records can form one or more auditing evidence obtaining manuscripts. For the audit evidence-taking manuscript, the relation entity of the service label and the audit result corresponding to the audit test point can be copied to a part of the manuscript to realize the transmission of the service label on the audit result; a new business label may also be generated for a portion of the audit forensic script. The service label is transmitted between the auditing results, the range of selecting the service label by service personnel can be reduced, and the overlarge statistical analysis result deviation of the auditing result data caused by errors caused by human factors is avoided.
In one embodiment, the delivery of the service label at the audit test point may be as in FIG. 6. The audit test point 11 has an associated service tag 111 and a service tag 112, and an audit test record 121, an audit test record 122 and an audit test record 123 can be generated according to the audit test point 11, wherein the audit test record 121 and the audit test record 122 can generate an audit forensic manuscript 131, the audit test record 123 can generate an audit forensic manuscript 132, the audit forensic manuscript 131 can copy the associated service tag 111 of the audit test point 11, the audit forensic manuscript 132 can copy the service tag 112, and a service tag 113 can be added.
The auditing service data processing method according to the embodiment of the present invention is described above with reference to a specific embodiment, and a computer device to which the auditing service data processing method is applied will be described below.
The embodiment of the invention also provides computer equipment. As shown in fig. 7, the computer device 700 may comprise a memory 701, a processor 702 and a computer program stored on the memory and capable of running on the processor, the processor when executing the program implementing: establishing a service label of audit result data, wherein the service label comprises a service label value entity and a service label name entity, the service label value entity comprises a label value number, a label name number, a label value description and an in-use mark, and the service label name entity comprises a label name number, a label name and an in-use mark; creating a service label value relation entity of a mesh relation between service labels, wherein the service label value relation entity comprises a father label value number, a father label name number, a son label value number and a son label name number; and storing the service label value entity, the service label name entity and the service label value relation entity into a relational database.
In some embodiments, the processor, when executing the program, further implements: and establishing a relation entity of the business label and the audit result of the relation between the business label and the audit result data, wherein the relation entity of the business label and the audit result comprises an audit result number, a business result type number, a label value number and a label name number.
In some embodiments, the processor, when executing the program, further implements: when a service label is newly added in the mesh relation, the newly added service label and the existing service label in the mesh relation are established into an association relation.
In some embodiments, the business label value belongs to one or more business label names, including audit units, processes, links, product lines, product groups, base products, saleable products, business systems, and channels.
In some embodiments, the processor, when executing the program, further implements: and displaying the service labels according to one or more label names in the service label names and the hierarchical sequence of the service label names set by the user.
In some embodiments, the processor, when executing the program, further implements: generating one or more audit test records according to the audit test points, wherein the audit test points are used as the incidence relation between the audit result and one or more service tags and are stored in the corresponding service tags and the corresponding relation entities of the audit result, generating one or more audit evidence obtaining manuscripts according to the one or more audit test records, and copying the corresponding service tags and the corresponding relation entities of the audit result to the one or more audit evidence obtaining manuscripts used as the audit result.
Through the above description of the embodiments, those skilled in the art will clearly understand that the present invention can be implemented by combining software and a hardware platform. With this understanding in mind, all or part of the technical solutions of the present invention that contribute to the background art may be embodied in the form of a software product, which can be stored in a storage medium, such as a ROM/RAM, a magnetic disk, an optical disk, etc., and includes instructions for causing a computer device (which may be a personal computer, a server, a smart phone, or a network device, etc.) to execute the methods according to the embodiments or some parts of the embodiments.
The terms and expressions used in the specification of the present invention have been set forth for illustrative purposes only and are not meant to be limiting. It will be appreciated by those skilled in the art that changes could be made to the details of the above-described embodiments without departing from the underlying principles thereof. The scope of the invention is, therefore, indicated by the appended claims, in which all terms are intended to be interpreted in their broadest reasonable sense unless otherwise indicated.
Claims (12)
1. A processing method for auditing service data is characterized by comprising the following steps:
extracting the service characteristics of audit result data, generating a service tag value of the audit result data, and obtaining a service tag name according to the service tag value, so as to establish a service tag of the audit result data, wherein the service tag comprises a service tag value entity and a service tag name entity, the service tag value entity comprises a tag value number, a tag name number, a tag value description and an in-use mark, and the service tag name entity comprises a tag name number, a tag name and an in-use mark;
creating a service label value relation entity of a mesh relation between service labels, wherein the service label value relation entity comprises a father label value number, a father label name number, a son label value number and a son label name number;
and storing the service label value entity, the service label name entity and the service label value relation entity into a relational database.
2. The method of claim 1, further comprising:
and establishing a relation entity of the business label and the audit result of the relation between the business label and the audit result data, wherein the relation entity of the business label and the audit result comprises an audit result number, a business result type number, a label value number and a label name number.
3. The method of claim 1, further comprising:
when a service label is newly added in the mesh relation, the newly added service label and the existing service label in the mesh relation are established into an association relation.
4. The method of claim 2, wherein the business label value belongs to one or more business label names, wherein the business label names include audit units, processes, links, product lines, product groups, base products, saleable products, business systems, and channels.
5. The method of claim 4, further comprising:
and displaying the service labels according to one or more label names in the service label names and the hierarchical sequence of the service label names set by the user.
6. The method of claim 4, further comprising:
generating one or more audit test records according to the audit test points, wherein the audit test points are used as the association relation between the audit result and one or more service labels and are stored in the corresponding service labels and the relation entities of the audit result,
and generating one or more auditing evidence-obtaining manuscripts by the one or more auditing test records, and copying the corresponding business labels and the relation entities of the auditing results to the one or more auditing evidence-obtaining manuscripts serving as the auditing results.
7. A computer device comprising a memory, a processor, and a computer program stored on the memory and operable on the processor, wherein the processor when executing the program implements:
extracting the service characteristics of audit result data, generating a service tag value of the audit result data, and obtaining a service tag name according to the service tag value, so as to establish a service tag of the audit result data, wherein the service tag comprises a service tag value entity and a service tag name entity, the service tag value entity comprises a tag value number, a tag name number, a tag value description and an in-use mark, and the service tag name entity comprises a tag name number, a tag name and an in-use mark;
creating a service label value relation entity of a mesh relation between service labels, wherein the service label value relation entity comprises a father label value number, a father label name number, a son label value number and a son label name number;
and storing the service label value entity, the service label name entity and the service label value relation entity into a relational database.
8. The computer device of claim 7, wherein the processor, when executing the program, further implements:
and establishing a relation entity of the business label and the audit result of the relation between the business label and the audit result data, wherein the relation entity of the business label and the audit result comprises an audit result number, a business result type number, a label value number and a label name number.
9. The computer device of claim 7, wherein the processor, when executing the program, further implements:
when a service label is newly added in the mesh relation, the newly added service label and the existing service label in the mesh relation are established into an association relation.
10. The computer device of claim 8, wherein the business label value belongs to one or more business label names, the business label names including audit units, processes, links, product lines, product groups, base products, saleable products, business systems, and channels.
11. The computer device of claim 10, wherein the processor, when executing the program, further implements:
and displaying the service labels according to one or more label names in the service label names and the hierarchical sequence of the service label names set by the user.
12. The computer device of claim 10, wherein the processor, when executing the program, further implements:
generating one or more audit test records according to the audit test points, wherein the audit test points are used as the association relation between the audit result and one or more service labels and are stored in the corresponding service labels and the relation entities of the audit result,
and generating one or more auditing evidence-obtaining manuscripts by the one or more auditing test records, and copying the corresponding business labels and the relation entities of the auditing results to the one or more auditing evidence-obtaining manuscripts serving as the auditing results.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710559074.2A CN107480188B (en) | 2017-07-11 | 2017-07-11 | Audit service data processing method and computer equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710559074.2A CN107480188B (en) | 2017-07-11 | 2017-07-11 | Audit service data processing method and computer equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107480188A CN107480188A (en) | 2017-12-15 |
| CN107480188B true CN107480188B (en) | 2020-12-04 |
Family
ID=60596190
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710559074.2A Active CN107480188B (en) | 2017-07-11 | 2017-07-11 | Audit service data processing method and computer equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107480188B (en) |
Families Citing this family (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112463788A (en) * | 2019-09-09 | 2021-03-09 | 北京国双科技有限公司 | Entity organization tree construction method, entity calling method and product in building control system |
| CN111198879A (en) * | 2019-11-12 | 2020-05-26 | 恒大智慧科技有限公司 | Intelligent community-based business data storage method and system |
| CN111126969A (en) * | 2019-12-29 | 2020-05-08 | 山西云时代技术有限公司 | Enterprise audit supervision implementation method |
| CN112149764A (en) * | 2020-08-28 | 2020-12-29 | 青岛海尔空调器有限总公司 | Printing method of label printing system and label printing system |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101447047A (en) * | 2008-12-31 | 2009-06-03 | 中国建设银行股份有限公司 | Method for analyzing auditing result, device and auditing system |
| CN102117464A (en) * | 2010-01-06 | 2011-07-06 | 埃森哲环球服务有限公司 | Marketing investment optimizer with dynamic hierarchies |
| CN104217307A (en) * | 2014-09-23 | 2014-12-17 | 中国南方电网有限责任公司 | Achievement structured management and quality monitoring method for full information construction process |
| CN106407230A (en) * | 2015-08-03 | 2017-02-15 | 天脉聚源（北京）科技有限公司 | A data classification method and system |
| CN106649318A (en) * | 2015-10-29 | 2017-05-10 | 北京国双科技有限公司 | Information display method and device |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1321509C (en) * | 2004-02-19 | 2007-06-13 | 上海复旦光华信息科技股份有限公司 | Universal safety audit strategies customing method based on mapping table |
| US8504490B2 (en) * | 2010-04-09 | 2013-08-06 | Microsoft Corporation | Web-scale entity relationship extraction that extracts pattern(s) based on an extracted tuple |
| CN104199900B (en) * | 2014-08-26 | 2017-09-26 | 中国航天科工集团第二研究院七〇六所 | Audit analysis method based on file trajectory track tree |
-
2017
- 2017-07-11 CN CN201710559074.2A patent/CN107480188B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101447047A (en) * | 2008-12-31 | 2009-06-03 | 中国建设银行股份有限公司 | Method for analyzing auditing result, device and auditing system |
| CN102117464A (en) * | 2010-01-06 | 2011-07-06 | 埃森哲环球服务有限公司 | Marketing investment optimizer with dynamic hierarchies |
| CN104217307A (en) * | 2014-09-23 | 2014-12-17 | 中国南方电网有限责任公司 | Achievement structured management and quality monitoring method for full information construction process |
| CN106407230A (en) * | 2015-08-03 | 2017-02-15 | 天脉聚源（北京）科技有限公司 | A data classification method and system |
| CN106649318A (en) * | 2015-10-29 | 2017-05-10 | 北京国双科技有限公司 | Information display method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107480188A (en) | 2017-12-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20190347282A1 (en) | Technology incident management platform | |
| Meneely et al. | Predicting failures with developer networks and social network analysis | |
| Rodríguez et al. | Empirical findings on team size and productivity in software development | |
| CN107480188B (en) | Audit service data processing method and computer equipment | |
| Altuntas et al. | Analysis of patent documents with weighted association rules | |
| CN111080222A (en) | Approval method and approval system | |
| Lodhi et al. | An extension of bpmn meta-model for evaluation of business processes | |
| Fejzer et al. | Profile based recommendation of code reviewers | |
| Marshall et al. | Decision making in the context of business intelligence and data quality | |
| Söylemez et al. | Challenges of software process and product quality improvement: catalyzing defect root-cause investigation by process enactment data analysis | |
| Tahir et al. | A systematic mapping study on software measurement programs in SMEs | |
| US7992126B2 (en) | Apparatus and method for quantitatively measuring the balance within a balanced scorecard | |
| Ge et al. | Data and information quality assessment in information manufacturing systems | |
| CN104391986B (en) | Business reclassification apparatus and method | |
| Gupta et al. | Process cube for software defect resolution | |
| Li et al. | Configurable event correlation for process discovery from object-centric event data | |
| Almomani et al. | Software process improvement initiatives in small and medium firms: a systematic review | |
| EP3306540A1 (en) | System and method for content affinity analytics | |
| US20080033995A1 (en) | Identifying events that correspond to a modified version of a process | |
| Corea et al. | A taxonomy of business rule organizing approaches in regard to business process compliance | |
| Delias et al. | Business process analytics: a dedicated methodology through a case study | |
| Ferreira et al. | Using process mining for ITIL assessment: a case study with incident management | |
| JP2013178669A (en) | Tabulation device and tabulation program | |
| Taylor et al. | A provenance maturity model | |
| CN110399337A (en) | File automating method of servicing and system based on data-driven |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |