CN114625749A

CN114625749A - Auditing processing method, auditing processing device, electronic equipment, storage medium and program product

Info

Publication number: CN114625749A
Application number: CN202210063873.1A
Authority: CN
Inventors: 雷嘉健; 戴启军; 周贤舜
Original assignee: Lakala Payment Co ltd
Current assignee: Lakala Payment Co ltd
Priority date: 2022-01-20
Filing date: 2022-01-20
Publication date: 2022-06-14

Abstract

The embodiment of the disclosure discloses a method and a device for auditing processing, electronic equipment, a storage medium and a program product, wherein the method comprises the following steps: in response to receiving an audit request sent by an audit requester, determining an object to be audited corresponding to the audit request, and auditing the object to be audited, wherein the audit request carries an audit request and information of the object to be audited; when the object to be audited is determined to be the first object to be audited, sending the audit request to a three-party audit platform for auditing; and receiving the auditing result sent by the three-party auditing platform. The technical scheme can ensure the execution efficiency of the SQL change and other audit flows, promote the execution convenience of the SQL change and other audit flows, and can also correlate the SQL change and other audit flows with the SQL implementation flow, thereby facilitating the management of the SQL change.

Description

Auditing processing method, auditing processing device, electronic equipment, storage medium and program product

Technical Field

The embodiment of the disclosure relates to the technical field of data processing, in particular to an audit processing method, an audit processing device, electronic equipment, a storage medium and a program product.

Background

A Database Management System (DMS) refers to a System for managing a Database, and in the prior art, for an SQL change and other audit process and an SQL implementation process, the DMS generally adopts two processing methods: 1. the SQL change and other examination and check process and the SQL implementation process are carried out in the same platform; 2. the SQL change and other examination and check process and the SQL implementation process are mutually independent. For the first processing mode, because the SQL implementation flow has relatively high requirements on data security and sealing, executing the SQL change and other audit flows in such a secure and sealed data operating environment is not favorable for improving the efficiency of the SQL change and other audit flows. For the second processing mode, mutual independence between the SQL modification and other audit processes and the SQL implementation process will cause the SQL modification and other audit processes not to be associated with the SQL modification, which is not beneficial to the management of the SQL modification. Therefore, there is a need for a technical solution that can not only ensure the execution efficiency of the audit procedures such as SQL change, but also correlate with the SQL change to facilitate the management of the SQL change.

Disclosure of Invention

The embodiment of the disclosure provides an auditing processing method and device, electronic equipment, a storage medium and a program product.

In a first aspect, an embodiment of the present disclosure provides an audit processing method.

Specifically, the auditing processing method includes:

in response to receiving an audit request sent by an audit requester, determining an object to be audited corresponding to the audit request, and auditing the object to be audited, wherein the audit request carries an audit request and information of the object to be audited;

when the object to be audited is determined to be the first object to be audited, sending the audit request to a three-party audit platform for auditing;

and receiving the auditing result sent by the three-party auditing platform.

With reference to the first aspect, in a first implementation manner of the first aspect, an embodiment of the present disclosure further includes:

when the object to be audited is determined to be a second object to be audited, confirming that the audit result of the object to be audited is a positive audit result;

and when the object to be audited is determined to be the third object to be audited, confirming that the auditing result of the object to be audited is a negative auditing result.

With reference to the first aspect and the first implementation manner of the first aspect, in a second implementation manner of the first aspect, the embodiment of the present disclosure further includes, before sending the audit request to a three-party audit platform for auditing:

and adding auditor information for the audit request, and carrying out desensitization processing on the new audit request.

In a second aspect, an embodiment of the present disclosure provides an audit processing method.

Specifically, the auditing processing method includes:

receiving an auditing request which is sent by a database management system and carries an auditing requirement, information of an object to be audited and information of an auditor;

sending an audit notification message carrying an audit request and information of an object to be audited to an auditor according to the information of the auditor, so that the auditor audits the object to be audited according to the audit request and the information of the object to be audited;

and acquiring the auditing result of the auditor, determining the auditing result of the object to be audited according to the auditing result of the auditor, and sending the auditing result to the database management system.

With reference to the second aspect, in a first implementation manner of the second aspect, the determining an audit result of the object to be audited according to the audit result of the auditor according to the second aspect includes:

when the number of the auditors is one, determining the audit result of the auditors as the audit result of the object to be audited;

and when the number of the auditors is two or more, and the audit results of all the auditors are positive audit results, the audit result of the object to be audited is a positive audit result, otherwise, the audit result of the object to be audited is a negative audit result.

In a third aspect, an embodiment of the present disclosure provides an audit processing method.

Specifically, the auditing processing method includes:

the database management system responds to an audit request sent by an audit requester, determines an object to be audited corresponding to the audit request, audits the object to be audited, and sends the audit request to a three-party audit platform for auditing when the object to be audited is determined to be a first object to be audited, wherein the audit request carries an audit request, information of the object to be audited and the audit request of the information of the auditor;

the three-party auditing platform receives the auditing request sent by the database management system, sends an auditing notification message to the auditing party according to the information of the auditing party, so that the auditing party audits the object to be audited according to the auditing request and the information of the object to be audited, obtains the auditing result of the auditing party, determines the auditing result of the object to be audited according to the auditing result of the auditing party, and sends the auditing result to the database management system;

and the database management system receives the auditing result sent by the three-party auditing platform.

With reference to the third aspect, in a first implementation manner of the third aspect, the embodiment of the present disclosure further includes:

and when the database management system determines that the object to be audited is the second object to be audited, the database management system confirms that the object to be audited is approved, and when the object to be audited is determined to be the third object to be audited, the database management system confirms that the object to be audited is not approved.

With reference to the third aspect and the first implementation manner of the third aspect, in a second implementation manner of the third aspect, before the sending, by the database management system, the audit request to the three-party audit platform for audit, the method further includes:

With reference to the third aspect, the first implementation manner of the third aspect, and the second implementation manner of the third aspect, in a third implementation manner of the third aspect, the determining, by the three-party auditing platform, an auditing result of the object to be audited according to the auditing result of the auditor includes:

In a fourth aspect, an audit processing apparatus is provided in an embodiment of the present disclosure.

Specifically, the audit processing device includes:

the auditing module is configured to respond to an auditing request sent by an auditing requester, determine an object to be audited corresponding to the auditing request, and audit the object to be audited, wherein the auditing request carries an auditing requirement and object information to be audited;

the first determining module is configured to send the auditing request to a three-party auditing platform for auditing when the object to be audited is determined to be the first object to be audited;

and the receiving module is configured to receive the auditing result sent by the three-party auditing platform.

With reference to the fourth aspect, in a first implementation manner of the fourth aspect, the first determining module is further configured to:

With reference to the fourth aspect and the first implementation manner of the fourth aspect, in a second implementation manner of the fourth aspect, the first determining module is further configured to:

In a fifth aspect, an audit processing apparatus is provided in an embodiment of the present disclosure.

Specifically, the audit processing device includes:

the receiving module is configured to receive an auditing request which is sent by a database management system and carries an auditing requirement, information of an object to be audited and information of an auditor;

the sending module is configured to send an audit notification message carrying an audit requirement and information of an object to be audited to an auditor according to the audit party information, so that the auditor audits the object to be audited according to the audit requirement and the information of the object to be audited;

and the second determining module is configured to obtain the auditing result of the auditing party, determine the auditing result of the object to be audited according to the auditing result of the auditing party, and send the auditing result to the database management system.

With reference to the fifth aspect, in a first implementation manner of the fifth aspect, the second determining module is configured to determine, according to the audit result of the auditor, a part of the audit result of the object to be audited, and configured to:

In a sixth aspect, an audit processing apparatus is provided in an embodiment of the present disclosure.

Specifically, the audit processing device includes:

the database management system is configured to respond to an audit request sent by an audit requester, determine an object to be audited corresponding to the audit request, audit the object to be audited, send the audit request to a three-party audit platform for auditing and receive an audit result sent by the three-party audit platform when the object to be audited is determined to be a first object to be audited, wherein the audit request carries an audit request, information of the object to be audited and the audit request of the information of the audit requester;

and the three-party auditing platform is configured to receive an auditing request sent by the database management system, send an auditing notification message to an auditing party according to the auditing party information, so that the auditing party audits the object to be audited according to the auditing request and the object information to be audited, obtain an auditing result of the auditing party, determine an auditing result of the object to be audited according to the auditing result of the auditing party, and send the auditing result to the database management system.

With reference to the sixth aspect, in a first implementation manner of the sixth aspect, an embodiment of the present disclosure further includes:

and when the object to be audited is determined to be a second object to be audited, the object to be audited is confirmed to be passed, and when the object to be audited is determined to be a third object to be audited, the object to be audited is confirmed to be not passed.

With reference to the sixth aspect and the first implementation manner of the sixth aspect, in a second implementation manner of the sixth aspect, before the database management system sends the audit request to a three-party audit platform for audit, the database management system is further configured to:

With reference to the sixth aspect, the first implementation manner of the sixth aspect, and the second implementation manner of the sixth aspect, in a third implementation manner of the sixth aspect, the embodiment of the present disclosure provides that the three-party auditing platform determines, according to the auditing result of the auditor, a part of the auditing result of the object to be audited, and is configured to:

and when the number of the auditors is two or more than two, and the audit results of all the auditors are positive audit results, the audit result of the object to be audited is a positive audit result, otherwise, the audit result of the object to be audited is a negative audit result.

In a seventh aspect, an embodiment of the present disclosure provides an electronic device, including a memory and a processor, where the memory is used to store one or more computer instructions for supporting an audit processing apparatus to execute the audit processing method described above, and the processor is configured to execute the computer instructions stored in the memory. The audit processing apparatus may further comprise a communication interface for the audit processing apparatus to communicate with other devices or a communication network.

In an eighth aspect, the present disclosure provides a computer-readable storage medium for storing computer instructions for an audit processing apparatus, where the computer instructions include computer instructions for executing the audit processing method to the audit processing apparatus.

In a ninth aspect, the present disclosure provides a computer program product, which includes a computer program/instruction, and when executed by a processor, implements the steps of the above-mentioned auditing processing method.

The technical scheme provided by the embodiment of the disclosure can have the following beneficial effects:

according to the technical scheme, the three-party auditing platform associated with the database management system is arranged, and the auditing of the object to be audited is realized by means of the three-party auditing platform. The technical scheme can ensure the execution efficiency of the checking process such as SQL change and the like, improve the execution convenience of the checking process such as SQL change and the like, and can also correlate the checking process such as SQL change and the like with the SQL implementation process, thereby facilitating the management of the SQL change.

It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of embodiments of the disclosure.

Drawings

Other features, objects, and advantages of embodiments of the disclosure will become more apparent from the following detailed description of non-limiting embodiments when taken in conjunction with the accompanying drawings. In the drawings:

FIG. 1 illustrates a flow diagram of an audit processing method according to an embodiment of the present disclosure;

FIG. 2 shows a flow diagram of an audit processing method according to another embodiment of the present disclosure;

FIG. 3 illustrates a flow diagram of an audit processing method according to yet another embodiment of the present disclosure;

FIG. 4 illustrates an application scenario diagram of an audit processing method according to an embodiment of the present disclosure;

fig. 5 shows a block diagram of an audit processing apparatus according to an embodiment of the present disclosure;

fig. 6 shows a block diagram of an audit processing apparatus according to another embodiment of the present disclosure;

fig. 7 shows a block diagram of an audit processing apparatus according to yet another embodiment of the present disclosure;

FIG. 8 shows a block diagram of an electronic device according to an embodiment of the present disclosure;

fig. 9 is a schematic block diagram of a computer system suitable for implementing an audit processing method according to an embodiment of the present disclosure.

Detailed Description

Hereinafter, exemplary embodiments of the disclosed embodiments will be described in detail with reference to the accompanying drawings so that they can be easily implemented by those skilled in the art. Also, for the sake of clarity, parts not relevant to the description of the exemplary embodiments are omitted in the drawings.

In the disclosed embodiments, it is to be understood that terms such as "including" or "having," etc., are intended to indicate the presence of the disclosed features, numbers, steps, behaviors, components, parts, or combinations thereof, and are not intended to preclude the possibility that one or more other features, numbers, steps, behaviors, components, parts, or combinations thereof may be present or added.

It should be further noted that the embodiments and features of the embodiments in the present disclosure may be combined with each other without conflict. The embodiments of the present disclosure will be described in detail below with reference to the accompanying drawings in conjunction with embodiments.

The technical scheme provided by the embodiment of the disclosure sets a three-party auditing platform associated with a database management system, and realizes auditing of an object to be audited by means of the three-party auditing platform. The technical scheme can ensure the execution efficiency of the checking process such as SQL change and the like, improve the execution convenience of the checking process such as SQL change and the like, and can also correlate the checking process such as SQL change and the like with the SQL implementation process, thereby facilitating the management of the SQL change.

Fig. 1 shows a flowchart of an audit processing method according to an embodiment of the present disclosure, which includes the following steps S101-S103, as shown in fig. 1:

in step S101, in response to receiving an audit request sent by an audit requester, determining an object to be audited corresponding to the audit request, and performing an audit on the object to be audited, where the audit request carries an audit request and information of the object to be audited;

in step S102, when it is determined that the object to be audited is the first object to be audited, sending the audit request to a three-party audit platform for audit;

in step S103, an audit result sent by the three-party audit platform is received.

As mentioned above, the database management system refers to a system for managing a database, and in the prior art, for the SQL change and other audit processes and the SQL implementation processes, the DMS generally adopts two processing methods: 1. the SQL change and other examination and check process and the SQL implementation process are carried out in the same platform; 2. the SQL change and other audit processes and the SQL implementation process are mutually independent. For the first processing mode, because the SQL implementation flow has relatively high requirements on data security and sealing, executing the examination flows such as SQL modification in such a secure and sealed data operating environment is not favorable for improving the efficiency of the examination flows such as SQL modification. For the second processing mode, mutual independence between the SQL modification and other audit processes and the SQL implementation process will cause the SQL modification and other audit processes not to be associated with the SQL modification, which is not beneficial to the management of the SQL modification. Therefore, there is a need for a technical solution that can not only ensure the execution efficiency of the audit procedures such as SQL change, but also correlate with the SQL change to facilitate the management of the SQL change.

In view of the above problem, in this embodiment, an audit processing method is provided, in which a three-party audit platform associated with a database management system is provided, and an audit of an object to be audited is implemented by using the three-party audit platform. The technical scheme can ensure the execution efficiency of the checking process such as SQL change and the like, improve the execution convenience of the checking process such as SQL change and the like, and can also correlate the checking process such as SQL change and the like with the SQL implementation process, thereby facilitating the management of the SQL change.

In an embodiment of the present disclosure, the auditing method may be applied to a database management system such as a computer, an electronic device, a server cluster, or the like, which performs auditing.

In an embodiment of the present disclosure, the audit requester refers to a party that requests to perform an audit on a certain item, and the audit requester may be, for example, a user, a database developer, a database technician, or the like.

In an embodiment of the present disclosure, the audit request refers to a request that is sent by the audit requester and carries an audit request and information of an object to be audited, and what audit is performed on which object to be audited can be determined through the audit request. The object to be checked may be, for example, SQL, a certain item, and the like, and the information of the object to be checked may be, for example, basic information of the object to be checked, change information of the object to be checked, and the like.

In an embodiment of the present disclosure, the first object to be audited refers to an object to be audited, which is difficult to perform automatic audit and needs to be manually audited by an auditor.

In an embodiment of the present disclosure, the three-party auditing platform refers to a platform which is associated with the database management system, can communicate data, but operates relatively independently, and can implement independent auditing.

In the above embodiment, an audit request sent by an audit requester is received first, then an object to be audited corresponding to the audit request is determined according to information carried by the audit request, and then automatic audit can be performed on the object to be audited; if the object to be audited is determined to be the object to be audited which is difficult to automatically audit through automatic audit, and the auditor is required to manually audit, the audit request is sent to a three-party audit platform, so that the auditor is informed to manually audit the object to be audited; and finally, receiving the auditing result sent by the three-party auditing platform.

Further, if the object to be audited is determined to be the object to be audited which can be audited by means of automatic auditing, the auditing result can be directly obtained without auditing by means of a three-party auditing platform, for example, if the object to be audited is determined to be the object to be audited which is low in risk or easy to audit by means of automatic auditing, the auditing result of the object to be audited can be directly confirmed to be an approved result, namely a positive auditing result; if the object to be audited is determined to be the object to be audited with high risk or illegal operation through automatic audit, the audit result of the object to be audited can be directly confirmed to be that the audit does not pass, namely, the audit result is negative.

That is, in an embodiment of the present disclosure, the method may further include the steps of:

when the object to be audited is determined to be a second object to be audited, the object to be audited is confirmed to be approved;

and when the object to be audited is determined to be a third object to be audited, confirming that the object to be audited is not audited.

The second object to be audited refers to the object to be audited with low risk or easy to audit mentioned above. The third object to be audited refers to the object to be audited with high risk or illegal operation mentioned above.

In an embodiment of the present disclosure, before sending the audit request to a three-party audit platform for auditing in step S102, the method may further include the following steps:

In order to facilitate the determination of the three-party audit platform, the auditor is notified to the auditor to perform the audit on the object to be audited, and before the audit request is sent to the three-party audit platform, the auditor information needs to be added to the audit request, where the auditor information may be, for example, identity information of the auditor, distinguishable identification information of the auditor, and the like. Further, in order to guarantee data security and avoid loss of sensitive information, before the audit request is sent to the three-party audit platform, desensitization processing needs to be performed on the audit request.

Fig. 2 shows a flowchart of an audit processing method according to another embodiment of the present disclosure, which includes the following steps S201 to S203, as shown in fig. 2:

in step S201, an audit request carrying an audit request, information of an object to be audited, and information of an auditor sent by a database management system is received;

in step S202, an audit notification message carrying an audit request and information of an object to be audited is sent to an auditor according to the information of the auditor, so that the auditor audits the object to be audited according to the audit request and the information of the object to be audited;

in step S203, an auditor audit result is obtained, an audit result of the object to be audited is determined according to the auditor audit result, and the audit result is sent to the database management system.

As mentioned above, the database management system refers to a system for managing a database, and in the prior art, for the SQL change and other audit processes and the SQL implementation processes, the DMS generally adopts two processing methods: 1. the SQL change and other examination and check process and the SQL implementation process are carried out in the same platform; 2. the SQL change and other examination and check process and the SQL implementation process are mutually independent. For the first processing mode, because the SQL implementation flow has relatively high requirements on data security and sealing, executing the SQL change and other audit flows in such a secure and sealed data operating environment is not favorable for improving the efficiency of the SQL change and other audit flows. For the second processing mode, mutual independence between the SQL modification and other audit processes and the SQL implementation process will cause the SQL modification and other audit processes not to be associated with the SQL modification, which is not beneficial to the management of the SQL modification. Therefore, there is a need for a technical solution that can not only ensure the execution efficiency of the audit procedures such as SQL change, but also correlate with the SQL change to facilitate the management of the SQL change.

In an embodiment of the present disclosure, the auditing processing method may be applied to a three-party auditing platform such as a computer, an electronic device, a server cluster, and the like, which performs auditing processing.

In an embodiment of the present disclosure, the audit notification message refers to a message that notifies the auditor to perform audit on a three-party audit platform. The audit notification message may carry an audit request and information of an object to be audited, so that an auditor can audit the object to be audited according to the audit request and the information of the object to be audited carried by the audit notification message.

In the above embodiment, after receiving an audit request carrying an audit request, information of an object to be audited, and information of an auditor sent by a database management system, a three-party audit platform sends an audit notification message carrying the audit request and the information of the object to be audited to a corresponding auditor according to the information of the auditor carried by the audit request, so that the auditor can audit the object to be audited according to the audit request and the information of the object to be audited carried by the audit notification message; and finally, acquiring an auditing result of the auditing party, determining a final auditing result of the object to be audited according to the auditing result of the auditing party, and sending the final auditing result to the database management system.

In an embodiment of the present disclosure, the step of determining an audit result of the object to be audited according to the audit result of the auditor in step S203 may include the following steps:

In this embodiment, it is necessary to determine the final audit result of the object to be audited according to the audit results of all auditors, considering that there may be multiple auditors, for example, the auditors may include a project manager, a Database Administrator (DBA), and so on. Specifically, when the number of the auditors is one, the final audit result of the object to be audited is the audit result of the auditor, that is, the audit result of the auditor can be directly determined as the audit result of the object to be audited; and when the number of the auditors is two or more, if all the auditor audit results are audit passed, namely are all positive audit results, the audit result of the object to be audited is a positive audit result, otherwise, if one of the audit results of all the auditors is audit not passed, namely is a negative audit result, the audit result of the object to be audited is a negative audit result.

Technical terms and technical features related to the technical terms and technical features shown in fig. 2 and related embodiments are the same as or similar to those of the technical terms and technical features shown in fig. 1 and related embodiments, and for the explanation and description of the technical terms and technical features related to the technical terms and technical features shown in fig. 2 and related embodiments, reference may be made to the above explanation of the explanation of fig. 1 and related embodiments, and no further description is provided here.

Fig. 3 shows a flowchart of an audit processing method according to still another embodiment of the present disclosure, which includes the following steps S301 to S303, as shown in fig. 3:

in step S301, in response to receiving an audit request sent by an audit requester, a database management system determines an object to be audited corresponding to the audit request, audits the object to be audited, and sends the audit request to a three-party audit platform for auditing when it is determined that the object to be audited is a first object to be audited, where the audit request carries an audit request, information of the object to be audited, and an audit request of the information of the auditor;

in step S302, the three-party auditing platform receives an auditing request sent by the database management system, and sends an auditing notification message to an auditing party according to the auditing party information, so that the auditing party audits the object to be audited according to the auditing request and the object information to be audited, obtains an auditing result of the auditing party, determines an auditing result of the object to be audited according to the auditing result of the auditing party, and sends the auditing result to the database management system;

in step S303, the database management system receives the audit result sent by the three-party audit platform.

As mentioned above, the dbms refers to a system for managing a database, and in the prior art, two processing methods are generally adopted by the DMS for an SQL change and other audit process and an SQL implementation process: 1. the SQL change and other examination and check process and the SQL implementation process are carried out in the same platform; 2. the SQL change and other examination and check process and the SQL implementation process are mutually independent. For the first processing mode, because the SQL implementation flow has relatively high requirements on data security and sealing, executing the SQL change and other audit flows in such a secure and sealed data operating environment is not favorable for improving the efficiency of the SQL change and other audit flows. For the second processing mode, mutual independence between the SQL modification and other audit processes and the SQL implementation process will cause the SQL modification and other audit processes not to be associated with the SQL modification, which is not beneficial to the management of the SQL modification. Therefore, there is a need for a technical solution that can not only ensure the execution efficiency of the audit procedures such as SQL change, but also correlate with the SQL change to facilitate the management of the SQL change.

In an embodiment of the present disclosure, the auditing processing method may be applied to an auditing processing system including a database management system and a three-party auditing platform, such as a computer, an electronic device, a server cluster, and the like.

In an embodiment of the present disclosure, the method may further include the steps of:

In an embodiment of the present disclosure, before the database management system sends the audit request to a three-party audit platform for audit, the method may further include the following steps:

In an embodiment of the present disclosure, the step of determining, by the three-party auditing platform, the auditing result of the object to be audited according to the auditing result of the auditor may include the following steps:

Technical terms and technical features related to the technical terms and technical features shown in fig. 3 and related embodiments are the same as or similar to those of the technical terms and technical features shown in fig. 1-2 and related embodiments, and for the explanation and description of the technical terms and technical features related to the technical terms and technical features shown in fig. 3 and related embodiments, reference may be made to the above explanation of the embodiment shown in fig. 1-2 and related embodiments, and no further description is provided here.

Fig. 4 shows an application scenario diagram of an audit processing method according to an embodiment of the present disclosure. As shown in fig. 4, in this scenario, the database management system starts an audit process after receiving an audit request sent by an audit requester, where the audit request carries an audit request and information of an object to be audited. Firstly, determining a corresponding object to be audited according to the audit request, and automatically auditing the object to be audited. And when the object to be audited is determined to be a second object to be audited with low risk or easy audit, directly confirming that the object to be audited passes audit, and ending the audit process. And when the object to be audited is determined to be a third object to be audited with high risk or illegal operation, directly confirming that the object to be audited is not audited, and ending the auditing process. When the object to be audited is determined to be not the second object to be audited with low risk or easy to audit and not the third object to be audited with high risk or illegal operation but the first object to be audited which is difficult to automatically audit and needs to be audited manually by the auditor, the audit request is sent to a three-party audit platform to start manual audit, at this moment, the auditor information can be added to the audit request, desensitization processing is executed on the audit request, and data safety is guaranteed. After the three-party auditing platform receives the auditing request, the manual auditing process of the auditor is started, firstly, the three-party auditing platform sends auditing notification information to the auditor according to the information of the auditor, enabling the auditor to determine the object to be audited according to the audit request carried by the audit request and the information of the object to be audited, and auditing the object to be audited, if the number of the auditor is one, the auditing result of the auditor can be directly determined as the final auditing result of the object to be audited, if the number of the auditors is two or more, only the auditing results of all auditors are approved, and determining that the final audit result of the object to be audited is passed, otherwise, determining that the final audit result of the object to be audited is not passed as long as one of the audit results of all auditors is not passed. And finally, the three-party auditing platform sends the final auditing result of the object to be audited to the database management system, and the auditing process is finished.

The following are embodiments of the disclosed apparatus that may be used to perform embodiments of the disclosed methods.

Fig. 5 shows a block diagram of an audit processing apparatus according to an embodiment of the present disclosure, which may be implemented as part or all of an electronic device by software, hardware, or a combination of the two. As shown in fig. 5, the audit processing apparatus includes:

the auditing module 501 is configured to determine an object to be audited corresponding to an auditing request in response to receiving the auditing request sent by an auditing requester, and audit the object to be audited, wherein the auditing request carries an auditing requirement and information of the object to be audited;

a first determining module 502, configured to send the audit request to a three-party audit platform for audit when it is determined that the object to be audited is the first object to be audited;

a receiving module 503 configured to receive the audit result sent by the three-party audit platform.

As mentioned above, the database management system refers to a system for managing a database, and in the prior art, for the SQL change and other audit processes and the SQL implementation processes, the DMS generally adopts two processing methods: 1. the SQL change and other examination and check process and the SQL implementation process are carried out in the same platform; 2. the SQL change and other examination and check process and the SQL implementation process are mutually independent. For the first processing mode, because the SQL implementation flow has relatively high requirements on data security and sealing, executing the examination flows such as SQL modification in such a secure and sealed data operating environment is not favorable for improving the efficiency of the examination flows such as SQL modification. For the second processing mode, mutual independence between the SQL modification and other audit processes and the SQL implementation process will cause the SQL modification and other audit processes not to be associated with the SQL modification, which is not beneficial to the management of the SQL modification. Therefore, there is a need for a technical solution that can not only ensure the execution efficiency of the auditing process such as SQL change, but also facilitate the management of the SQL change by associating with the SQL change.

In view of the above problem, in this embodiment, an audit processing apparatus is provided, in which a three-party audit platform associated with a database management system is provided, and an audit of an object to be audited is implemented by using the three-party audit platform. The technical scheme can ensure the execution efficiency of the checking process such as SQL change and the like, improve the execution convenience of the checking process such as SQL change and the like, and can also correlate the checking process such as SQL change and the like with the SQL implementation process, thereby facilitating the management of the SQL change.

In an embodiment of the present disclosure, the audit processing apparatus may be implemented as a database management system such as a computer, an electronic device, a server cluster, and the like that performs audit processing.

In an embodiment of the present disclosure, the review requester refers to a party that requests to perform a review of a certain item, and the review requester may be, for example, a user, a database developer, a database technician, or the like.

In an embodiment of the present disclosure, the first object to be audited refers to an object to be audited that is difficult to perform automatic audit and requires an auditor to perform manual audit.

That is, in an embodiment of the present disclosure, the first determining module may be further configured to:

and when the object to be audited is determined to be a third object to be audited, confirming that the object to be audited is not approved.

In an embodiment of the present disclosure, the first determining module may be further configured to:

Fig. 6 shows a block diagram of an audit processing apparatus according to an embodiment of the present disclosure, which may be implemented as part or all of an electronic device by software, hardware, or a combination of the two. As shown in fig. 6, the audit processing apparatus includes:

the receiving module 601 is configured to receive an audit request which is sent by a database management system and carries an audit requirement, information of an object to be audited and information of an auditor;

a sending module 602, configured to send an audit notification message carrying an audit requirement and information of an object to be audited to an auditor according to the information of the auditor, so that the auditor audits the object to be audited according to the audit requirement and the information of the object to be audited;

the second determining module 603 is configured to obtain an audit result of the auditor, determine an audit result of the object to be audited according to the audit result of the auditor, and send the audit result to the database management system.

As mentioned above, the dbms refers to a system for managing a database, and in the prior art, two processing methods are generally adopted by the DMS for an SQL change and other audit process and an SQL implementation process: 1. the SQL change and other examination and check process and the SQL implementation process are carried out in the same platform; 2. the SQL change and other examination and check process and the SQL implementation process are mutually independent. For the first processing mode, because the SQL implementation flow has relatively high requirements on data security and sealing, executing the SQL change and other audit flows in such a secure and sealed data operating environment is not favorable for improving the efficiency of the SQL change and other audit flows. For the second processing mode, mutual independence between the SQL modification and other audit processes and the SQL implementation process will cause the SQL modification and other audit processes not to be associated with the SQL modification, which is not beneficial to the management of the SQL modification. Therefore, there is a need for a technical solution that can not only ensure the execution efficiency of the auditing process such as SQL change, but also facilitate the management of the SQL change by associating with the SQL change.

In an embodiment of the present disclosure, the auditing processing apparatus may be implemented as a three-party auditing platform such as a computer, an electronic device, a server, and a server cluster for auditing processing.

In the embodiment, after receiving an audit request which is sent by a database management system and carries an audit request, information of an object to be audited and information of an auditor, a three-party audit platform sends an audit notification message which carries the audit request and the information of the object to be audited to a corresponding auditor according to the information of the auditor carried by the audit request, so that the auditor can audit the object to be audited according to the audit request and the information of the object to be audited carried by the audit notification message; and finally, acquiring an auditing result of the auditing party, determining a final auditing result of the object to be audited according to the auditing result of the auditing party, and sending the final auditing result to the database management system.

In an embodiment of the present disclosure, a part of the second determining module, which determines the audit result of the object to be audited according to the audit result of the auditor, may be configured to:

In this embodiment, it is required to determine a final audit result of the object to be audited according to audit results of all auditors, considering that there may be multiple auditors, for example, the auditors may include a project manager, a Database Administrator (DBA), and the like. Specifically, when the number of the auditors is one, the final audit result of the object to be audited is the audit result of the auditor, that is, the audit result of the auditor can be directly determined as the audit result of the object to be audited; and when the number of the auditors is two or more, if all the auditor audit results are audit passed, namely are all positive audit results, the audit result of the object to be audited is a positive audit result, otherwise, if one of the audit results of all the auditors is audit not passed, namely is a negative audit result, the audit result of the object to be audited is a negative audit result.

Technical terms and technical features related to the technical terms and technical features shown in fig. 6 and related embodiments are the same as or similar to those of the technical terms and technical features shown in fig. 5 and related embodiments, and for the explanation and description of the technical terms and technical features related to the technical terms and technical features shown in fig. 6 and related embodiments, reference may be made to the above explanation of the explanation of fig. 5 and related embodiments, and no further description is provided here.

Fig. 7 shows a block diagram of an audit processing apparatus according to an embodiment of the present disclosure, which may be implemented as part or all of an electronic device by software, hardware, or a combination of the two. As shown in fig. 7, the audit processing apparatus includes:

the database management system 701 is configured to respond to an audit request sent by an audit requester, determine an object to be audited corresponding to the audit request, audit the object to be audited, send the audit request to a three-party audit platform for auditing and receive an audit result sent by the three-party audit platform when the object to be audited is determined to be a first object to be audited, wherein the audit request carries an audit request, information of the object to be audited and the audit request of the information of the audit requester;

the three-party auditing platform 702 is configured to receive an auditing request sent by the database management system, send an auditing notification message to an auditing party according to the auditing party information, so that the auditing party audits the object to be audited according to the auditing request and the object information to be audited, obtain an auditing result of the auditing party, determine an auditing result of the object to be audited according to the auditing result of the auditing party, and send the auditing result to the database management system.

As mentioned above, the database management system refers to a system for managing a database, and in the prior art, for the SQL change and other audit processes and the SQL implementation processes, the DMS generally adopts two processing methods: 1. the SQL change and other examination and check process and the SQL implementation process are carried out in the same platform; 2. the SQL change and other audit processes and the SQL implementation process are mutually independent. For the first processing mode, because the SQL implementation flow has relatively high requirements on data security and sealing, executing the examination flows such as SQL modification in such a secure and sealed data operating environment is not favorable for improving the efficiency of the examination flows such as SQL modification. For the second processing mode, the mutual independence between the SQL modification and other audit processes and the SQL implementation process will result in that the SQL modification and other audit processes cannot be associated with the SQL modification, which is not beneficial to the management of the SQL modification. Therefore, there is a need for a technical solution that can not only ensure the execution efficiency of the audit procedures such as SQL change, but also correlate with the SQL change to facilitate the management of the SQL change.

In view of the above problem, in this embodiment, an audit processing apparatus is provided, in which a three-party audit platform associated with a database management system is provided, and an audit of an object to be audited is implemented by using the three-party audit platform. The technical scheme can ensure the execution efficiency of the SQL change and other audit flows, promote the execution convenience of the SQL change and other audit flows, and can also correlate the SQL change and other audit flows with the SQL implementation flow, thereby facilitating the management of the SQL change.

In an embodiment of the present disclosure, the auditing processing apparatus may be implemented as an auditing processing system including a database management system and a three-party auditing platform, such as a computer, an electronic device, a server cluster, and so on.

In an embodiment of the present disclosure, the database management system may be further configured to:

In an embodiment of the present disclosure, before the database management system sends the audit request to a three-party audit platform for audit, the database management system may be further configured to:

In an embodiment of the present disclosure, the three-party auditing platform determines the part of the auditing result of the object to be audited according to the auditing result of the auditor, and may be configured to:

Technical terms and technical features related to technical terms and technical features shown in fig. 7 and related embodiments are the same as or similar to technical terms and technical features shown in fig. 5 to 6 and related embodiments, and for explanation and explanation of the technical terms and technical features related to fig. 7 and related embodiments, reference may be made to the above explanation of the explanation of fig. 5 to 6 and related embodiments, and detailed description is omitted here.

The present disclosure also discloses an electronic device, fig. 8 shows a block diagram of the electronic device according to an embodiment of the present disclosure, as shown in fig. 8, the electronic device 800 includes a memory 801 and a processor 802; wherein, the first and the second end of the pipe are connected with each other,

the memory 801 is used to store one or more computer instructions that are executed by the processor 802 to implement the above-described method steps.

As shown in fig. 9, the computer system 900 includes a processing unit 901 which can execute various processes in the above-described embodiments according to a program stored in a Read Only Memory (ROM)902 or a program loaded from a storage section 908 into a Random Access Memory (RAM) 903. In the RAM903, various programs and data necessary for the operation of the system 900 are also stored. The processing unit 901, the ROM902, and the RAM903 are connected to each other via a bus 904. An input/output (I/O) interface 905 is also connected to bus 904.

The following components are connected to the I/O interface 905: an input portion 906 including a keyboard, a mouse, and the like; an output section 907 including components such as a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and the like, and a speaker; a storage portion 908 including a hard disk and the like; and a communication section 909 including a network interface card such as a LAN card, a modem, or the like. The communication section 909 performs communication processing via a network such as the internet. The drive 910 is also connected to the I/O interface 905 as necessary. A removable medium 911 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is mounted on the drive 910 as necessary, so that a computer program read out therefrom is mounted into the storage section 908 as necessary. The processing unit 901 may be implemented as a CPU, a GPU, a TPU, an FPGA, an NPU, or other processing units.

In particular, the above described methods may be implemented as computer software programs, according to embodiments of the present disclosure. For example, embodiments of the present disclosure include a computer program product comprising a computer program tangibly embodied on a medium readable thereby, the computer program comprising program code for performing the clear information determination method. In such an embodiment, the computer program may be downloaded and installed from a network via the communication section 909, and/or installed from the removable medium 911.

A computer program product is also disclosed in embodiments of the present disclosure, the computer program product comprising computer programs/instructions which, when executed by a processor, implement any of the above method steps.

The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowcharts or block diagrams may represent a module, a program segment, or a portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.

The units or modules described in the embodiments of the present disclosure may be implemented by software or hardware. The units or modules described may also be provided in a processor, and the names of the units or modules do not in some cases constitute a limitation of the units or modules themselves.

As another aspect, the disclosed embodiment also provides a computer-readable storage medium, which may be the computer-readable storage medium included in the apparatus in the foregoing embodiment; or it may be a separate computer readable storage medium not incorporated into the device. The computer readable storage medium stores one or more programs for use by one or more processors in performing the methods described in the embodiments of the present disclosure.

The foregoing description is only exemplary of the preferred embodiments of the disclosure and is illustrative of the principles of the technology employed. It will be appreciated by those skilled in the art that the scope of the invention in the embodiments of the present disclosure is not limited to the specific combination of the above-mentioned features, but also encompasses other embodiments in which any combination of the above-mentioned features or their equivalents is made without departing from the inventive concept. For example, the above features and (but not limited to) the features with similar functions disclosed in the embodiments of the present disclosure are mutually replaced to form the technical solution.

Claims

1. An audit processing method comprising:

and receiving the auditing result sent by the three-party auditing platform.

2. The method of claim 1, further comprising:

3. The method of claim 1 or 2, before sending the audit request to a three-party audit platform for auditing, further comprising:

4. An audit processing method comprising:

5. The method according to claim 4, wherein the determining an audit result of the object to be audited according to the audit result of the auditor includes:

6. An audit processing method comprising:

7. The method of claim 6, further comprising:

8. The method of claim 6 or 7, wherein before the database management system sends the audit request to a three-party audit platform for auditing, the method further comprises:

and adding auditor information for the audit request, and carrying out desensitization processing on a new audit request.

9. The method according to any one of claims 6 to 8, wherein the determining, by the three-party audit platform, the audit result of the object to be audited according to the audit result of the auditor includes:

10. A computer program product comprising computer programs/instructions which, when executed by a processor, carry out the steps of the method of any one of claims 1 to 9.