CN118172020A

CN118172020A - Data restoration method, device, equipment, storage medium and program product

Info

Publication number: CN118172020A
Application number: CN202410372771.7A
Authority: CN
Inventors: 胡伟
Original assignee: China Construction Bank Corp; CCB Finetech Co Ltd
Current assignee: China Construction Bank Corp; CCB Finetech Co Ltd
Priority date: 2024-03-29
Filing date: 2024-03-29
Publication date: 2024-06-11

Abstract

The application provides a data repairing method, which relates to the technical field of data processing and comprises the following steps: receiving a task application of data restoration through a data restoration function interface so as to enable an approval user to approve the task application; when the approval passing instruction for the task application is determined to be received, analyzing the task application to obtain a data repair operation statement; executing data repair operation sentences aiming at the database to be repaired so as to repair the data in the database to be repaired in batches. The task application formulated and submitted by the business operator is directly acquired, and the data repair operation statement is acquired under the condition that the approval passes so as to repair the data, so that interaction of multiple departments and formulation and development processes of schemes are not needed, the operation of automatic processing is increased, the error rate of data repair is obviously reduced, the data repair flow is obviously simplified, the intervention of multiple users is reduced, and the data repair efficiency is improved.

Description

Data restoration method, device, equipment, storage medium and program product

Technical Field

The present application relates to the field of data processing technologies, and in particular, to a method, an apparatus, a device, a storage medium, and a program product for repairing data.

Background

For historical reasons, the data in the financial system, such as the data of the customer information, has many abnormal conditions and cannot meet the condition of business supervision, and in this case, the data of the customer information needs to be repaired so as to ensure that the data of the customer information used in the financial system is matched with the requirement of business supervision.

However, when the business department wants to repair data, the business department needs to initiate an application first, go to the project group after the process is finished in the department, and analyze and formulate a scheme by the project group, and after the project group leads pass the audit, go to the data center to develop and audit the scheme, and then select proper time to repair the data of the client information. Therefore, the existing data restoration method is long in overall time consumption and complex in flow, increases the workload of business and project group personnel, reduces the data processing efficiency, and can cause the situation that the final data restoration is wrong due to unsmooth communication in multiple departments.

Disclosure of Invention

The application provides a data repairing method, a device, equipment, a storage medium and a program product, which are used for realizing the condition of repairing data rapidly and accurately on line.

In a first aspect, the present application provides a method for repairing data, including: receiving a task application of data restoration through a data restoration function interface, so that an approval user approves the task application;

When the approval passing instruction for the task application is determined to be received, analyzing the task application to obtain a data repair operation statement;

Receiving a database selection instruction, and determining a database to be repaired according to the database selection instruction;

and executing the data repair operation statement aiming at the database to be repaired so as to repair the data in the database to be repaired in batches.

In a second aspect, the present application provides a data repair device comprising: the task application approval module is used for receiving a task application of data restoration through the data restoration function interface so as to enable an approval user to approve the task application;

the task application analysis module is used for analyzing the task application to acquire a data repair operation statement when determining that an approval passing instruction aiming at the task application is received;

The database to be repaired determining module is used for receiving a database selection instruction and determining a database to be repaired according to the database selection instruction;

And the data repair module is used for executing the data repair operation statement aiming at the database to be repaired so as to repair the data in the database to be repaired in batches.

In a third aspect, the present application provides an electronic device comprising: a processor, and a memory communicatively coupled to the processor;

The memory stores computer-executable instructions;

the processor executes the computer-executable instructions stored in the memory to implement the method according to the present application.

In a fourth aspect, the present application provides a computer readable storage medium having stored therein computer executable instructions which when executed by a processor are adapted to carry out the method of the present application.

In a fifth aspect, the application provides a computer program product comprising a computer program which, when executed by a processor, implements the method of the application.

According to the data repairing method, device, equipment, storage medium and program product, the task application formulated and submitted by a business operator is directly acquired through the online data repairing function interface, under the condition that the approval of an approval user of a business department passes, the task application is directly analyzed to acquire a data repairing operation statement, and the operation statement is executed through terminal equipment to realize the data repairing, so that interaction of multiple departments and formulation and development processes of schemes are not needed, the operation of automatic processing is increased, the error rate of data repairing is obviously reduced, the repairing flow of the data is obviously simplified, the intervention of multiple users is reduced, and the efficiency of data repairing is improved.

Drawings

The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the application and together with the description, serve to explain the principles of the application.

FIG. 1 is a flowchart of a method for repairing data according to a first embodiment of the present application;

FIG. 2 is a flowchart of a method for repairing data according to a second embodiment of the present application;

Fig. 3 is a schematic structural diagram of a data restoration device according to a third embodiment of the present application;

fig. 4 is a schematic structural diagram of an electronic device according to a fourth embodiment of the present application.

Specific embodiments of the present application have been shown by way of the above drawings and will be described in more detail below. The drawings and the written description are not intended to limit the scope of the inventive concepts in any way, but rather to illustrate the inventive concepts to those skilled in the art by reference to the specific embodiments.

Detailed Description

Reference will now be made in detail to exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, the same numbers in different drawings refer to the same or similar elements, unless otherwise indicated. The implementations described in the following exemplary examples do not represent all implementations consistent with the application. Rather, they are merely examples of apparatus and methods consistent with aspects of the application as detailed in the accompanying claims.

The following describes the technical scheme of the present application and how the technical scheme of the present application solves the above technical problems in detail with specific embodiments. The following embodiments may be combined with each other, and the same or similar concepts or processes may not be described in detail in some embodiments. Embodiments of the present application will be described below with reference to the accompanying drawings. The technical scheme of the application obtains, stores, uses, processes and the like the data, which all meet the relevant regulations of national laws and regulations.

In this embodiment, when the data of the customer information in the financial system in the prior art is not matched with the requirement of the business supervision, the repair of the customer information data is required. However, when the business department wants to repair data, the business department needs to initiate an application first, after the department finishes the process, the business department goes to the project group, and the project group analyzes and formulates a method, after the project group leads to pass the examination, the business department goes to the data center to carry out the proposal development examination, and then the business department selects proper time to repair the data of the client information. Therefore, the existing method for repairing the customer information data is long in overall time consumption and complex in flow, increases the workload of business and project team personnel, and reduces the data processing efficiency. The application provides a data repairing method, a device, equipment, a storage medium and a program product, wherein a task application formulated and submitted by a business operator is directly acquired through an on-line data repairing function interface, under the condition that approval of an approval user of a business department passes, the task application is directly analyzed to acquire a data repairing operation statement, and the operation statement is executed through terminal equipment to realize data repairing, so that interaction of multiple departments and formulation and development processes of schemes are not needed, the operation of automatic processing is increased, the error rate of data repairing is obviously reduced, the repairing flow of the data is obviously simplified, the intervention of multiple users is reduced, and the efficiency of data repairing is improved.

Example 1

Fig. 1 is a flow chart of a data repairing method according to an embodiment of the present application, where the embodiment is applicable to a case of repairing data on line quickly and accurately, the method may be performed by a data repairing device, and the device may be implemented in a form of hardware and/or software. As shown in fig. 1, the method comprises the steps of:

step S101, receiving a task application of data restoration through a data restoration function interface so as to enable an approval user to approve the task application.

Optionally, receiving, through the data repair function interface, a task application for data repair, so that an approval user approves the task application, including: when the data restoration request instruction is determined to be received, displaying a data restoration function interface, wherein the data restoration function interface comprises an attribute information filling item of a task application; receiving attribute information added in filling items by a user through a data restoration function interface, and generating a task application according to the attribute information, wherein the attribute information comprises a data restoration rule, a client range and a data restoration plan; and receiving an approval user appointed by the application user, and submitting the task application to the approval user so that the approval user performs compliance approval on the attribute information in the task application.

Specifically, the embodiment adopts an online form when data is repaired, when operators of a business department log in a financial system through a pre-registered account, when the customers data in the financial system need to be repaired, a data repair request instruction is sent to a terminal device through the logged-in financial system, the terminal device displays a data repair function interface based on the received request instruction, and the operators can customize task application through corresponding operations on the data repair function interface. For example, the data repair function interface may include an attribute information filling item of the task application, the filling item of each attribute information may be specifically displayed in an option list or a position of a filling frame, and the application user may add corresponding attribute information in each filling item by clicking or manually inputting, where the attribute information may include a data repair rule, a client range, a data repair schedule, and the like, and in this embodiment, a specific type and a specific adding manner of the attribute information are not limited. When all the attribute information in each filling item is added, a task application can be generated from each added attribute information.

For example, the data repair rule 1 added by the application user in the data repair rule filling item is: changing the customer's financial service identification to be correct; the client scope 1 added in the client scope filling item is: clients with deposit line between 100 ten thousand and 200 ten thousand; the data repair plan 1 added in the data repair plan filling item is: the resources occupied by the single operation are not more than 80% of the resources of the single operation, and the task application is formed according to the added data restoration rule 1, the client scope 1 and the data restoration plan arrangement 1. And the number of the data repair rules added by the user can be multiple, for example, the data repair rule 2 added by the user in the data wife rule filling item is as follows: the address of the financial service provider used by the customer is changed to a format designated by the business administration, so that the task application is formed according to the above-mentioned added data repair rule 1, data repair rule 2, customer scope 1 and data repair schedule 1, and therefore, the specific number of data repair rules included in the task application is not limited in this embodiment. The above-mentioned data restoration rules can be added by manual input, and the client scope and the data planning arrangement can be added by selecting an option list, which is, of course, only illustrative in the present embodiment, and not limited to the specific content and adding manner of each attribute information in the task application.

It should be noted that, in this embodiment, an employee architecture table of the financial system is further displayed on the data restoration function interface, each employee information is included in the employee architecture table, and the employees associated with the application user are marked, for example, the employees are marked with different colors from the direct leaders and the indirect leaders of the departments where the application user is located, and because the auditing is usually performed by the business department when the task application is performed, the user can select the approving user from the employee architecture table in a clicking manner, for example, the direct leaders and the like, which is only illustrated in this embodiment and is not limited in detail. After receiving an approval user specified by a user, the terminal device submits a task application to the approval user, takes the application task as a task to be processed of the approval user, and after the approval user logs in the financial system, the terminal device can check the task application submitted by the user to be processed, and the approval user can approve the sum of all attribute information in the task application, for example, the terminal device comprises: the data repair rule 1 is: changing the sex of the customer to correct; customer range 1 is: clients with deposit line between 100 ten thousand and 200 ten thousand; the data repair schedule 1 is: when the resources occupied by the single operation do not exceed 80% of the resources, and the approval user determines that the client with the deposit credit in the range of 100 ten thousand to 200 ten thousand just finishes repairing data in the same day when auditing the attribute information, the data is not required to be repaired again, and the approval is not required under the condition; or clients in the range of clients in the task application do not carry out data restoration on the same day, but the new system online needs to occupy more resources in the week, the data restoration needs to occupy as few as possible or does not occupy resources, and the resource limit set by single operation in the task application is too high, and in this case, the approval is not carried out; or the clients in the client range in the task application do not carry out data restoration on the same day, and no other tasks occupy system resources recently, the resource limit is set reasonably, and the task application is determined to be compliant under the condition, so that approval is determined to pass.

Step S102, when it is determined that an approval passing instruction for the task application is received, analyzing the task application to obtain a data repair operation statement.

Optionally, analyzing the task application to obtain a data repair operation statement includes: analyzing attribute information in the task application to obtain repair parameters, wherein the repair parameters comprise guest groups, data repair modes and single repair quantity; and acquiring an operation sentence template, and adding the repair parameters into the operation sentence template to generate a data repair operation sentence.

Optionally, analyzing the attribute information in the task application to obtain the repair parameter includes: determining a customer group according to a customer range, determining a data repair mode according to a data repair rule, and determining a single repair quantity according to a data repair plan arrangement; and taking the guest group, the data restoration mode and the single restoration quantity as restoration parameters.

Specifically, when it is determined that the task application submitted by the application user meets compliance through examination, the approval user submits an approval passing instruction, and at this time, the terminal device starts analysis work on the task application when receiving the approval passing instruction submitted by the approval user. The terminal device analyzes attribute information in the task application to obtain repair parameters, and when determining that the attribute information includes a client scope, a data repair rule and a data repair plan arrangement, analyzes the attribute information to obtain the repair parameters respectively, and in this embodiment, only different client groups are classified by taking the deposit amount as an example, for example, the deposit amount is VVIP n or more client groups, the deposit amount is 100 n-200 n client groups, the deposit amount is 50 n-100 n client groups, the deposit amount is less than 50 n client groups, and different client groups are provided with different preference policies and service items respectively, and in this embodiment, the different client groups are classified according to the items and time of purchasing the product, and the specific classification mode of the client groups is not limited in this embodiment, so that in the case of determining the client scope, the client groups can obtain a corresponding financial relation with the client scope, that is, namely, the repair parameters are obtained.

In addition, in this embodiment, the data repair mode may be determined according to the data repair rule, the terminal device may analyze and identify the repair object and the repair target according to different data repair rules, and select a data repair mode matched with the repair object and the repair target from a plurality of repair modes configured in advance, for example, a plurality of repair modes for different repair objects and repair targets are stored in a local data repair mode list in advance, and when it is determined that the data repair rule 1 included in the task application is: changing the financial service identifier of the customer into correct one, determining that the repair object in the data repair rule is the financial service identifier by analysis, and changing the repair object into correct one, and obtaining a data repair mode 1 corresponding to the data repair rule 1 according to the two information inquiry data repair mode lists, wherein the data repair mode 1 is as follows: referring to the 3 rd digit in the customer contract number, the digit is used as the financial service identifier, the financial service identifier filled in the customer information is compared with the digit, and if the financial service identifier is inconsistent with the digit, the modification is carried out. When the data restoration rule 2 contained in the task application is determined to be: changing the address of a financial service providing mechanism used by a customer into a format appointed by business supervision, determining that a repair object in the data repair rule is the address of the financial service providing mechanism used by analysis, and obtaining a data repair mode 2 corresponding to the data repair rule 2 according to the two information inquiry data repair mode lists, wherein the repair object is changed into the format appointed by business supervision, and the data repair mode 2 is: checking whether separators exist in province-city-county regions in addresses of used financial services, and adding separators among province-city-county regions for addresses without separators, so that a second repair parameter, namely a data repair mode, can be obtained according to an analysis result of the data repair rule under the condition that the data repair rule is determined. Finally, in this embodiment, the number of single repairs may be determined according to the data repair schedule, for example, when it is determined that the resources occupied by the single operation do not exceed 80% of the own resources, the terminal may calculate according to the highest limit, that is, 80% of the own resources, where the own resources and the resources occupied by the single data repair are known, the number of single repairs may be calculated, for example, it is determined that the number of single repairs is at most 1 ten thousand through calculation, and therefore, in the case of determining the data repair schedule, the third repair parameter, that is, the number of single repairs may be obtained through calculation. Of course, this embodiment is merely illustrative, and the specific acquisition scheme and number of each repair parameter are not limited.

Optionally, adding the repair parameter to the operation statement template to generate a data repair operation statement includes: judging whether the number of the data restoration modes in the restoration parameters is one, if so, directly adding the restoration parameters into an operation statement template to generate a data restoration operation statement, otherwise, adding the restoration parameters into the operation statement template to generate at least one data restoration operation statement.

Optionally, adding the repair parameter to the operation statement template to generate at least one data repair operation statement includes: obtaining a repair object corresponding to each data repair mode, wherein the repair object comprises at least one of a financial service identifier, a financial service validity period and a financial service providing mechanism address; grouping the data restoration modes according to the characteristics of the restoration objects to obtain a specified number of data restoration mode groups, wherein the data restoration mode groups comprise data restoration modes with the same characteristics of the restoration objects, and the characteristics comprise the uniqueness of the relationship between the restoration objects and the clients or the uniqueness of the relationship between the restoration objects and the clients; determining a designated number of the data restoration mode groups, wherein the value of the designated number is at least one; each data repair mode group, each data repair mode and each single repair quantity are respectively added into the operation statement templates of the designated quantity to generate at least one data repair operation statement.

In this embodiment, the operation sentence template may be selected in advance, and the operation sentence template may be in SQL language, C language or a language that can be identified by other computing devices, and in this embodiment, the specific language or specific format adopted by the operation sentence template is not limited, and it is within the scope of the present application as long as the data repair operation sentence generated by adding the parsed repair parameter to the operation sentence template can be identified by the terminal device. For example, if the operation sentence template is s= (user-guest group; style-data repair method; number-single repair number), if it is determined that the guest group is VIP guest group, the data repair method is data repair method 1, and the number of single repairs is 1 ten thousand, the generated data repair operation sentence s= (user-VIP guest group; style-data repair method 1; number-1 ten thousand), however, this embodiment is merely illustrative, and the specific format and content of the generated data repair method are not limited.

When it is determined that only one data repair method is included in the parsed repair parameters, one data repair operation statement may be generated directly according to the above method, but when the data repair methods include a plurality of data repair methods, the number of generated data repair operation statements needs to be determined according to the characteristics of the repair object corresponding to each repair method. Wherein, the characteristic of the repairing object refers to the uniqueness or non-uniqueness of the relationship with the client, for example, when the client is limited to only allow to use one financial service, the characteristic of the repairing object financial service identifier is unique, and the characteristic of the validity period of the financial service is also unique; the characteristic of the repair object address is non-unique because there is a case where a plurality of branches of a financial institution provide the same financial service to the same customer, for example, the customer may perform withdrawal operations in the eastern branch of an a bank and the northwest branch of the a bank, respectively. Of course, the present embodiment is merely illustrative, and the type of the repair object and the characteristics of each repair object are not limited. And the data repair mode group can be obtained by grouping aiming at the data repair modes with the same characteristics of the repair object, and the data repair operation sentences with the same number as the data repair mode group are generated. For example, when it is determined that the guest group is a VIP guest group, the data repair manner is a data repair manner 1 and a data repair manner 2, and the number of single repairs is 1 ten thousand, since the repair object corresponding to the data repair manner 1 is a contract number, the repair object corresponding to the data repair manner 2 is a financial service providing organization address, and the two repair objects respectively have different characteristics, two data repair operation sentences are correspondingly generated, where the two data repair operation sentences are respectively: data repair operation sentence s1= (user-VIP guest group; style-data repair method 1; number-1 ten thousand), and data repair operation sentence s2= (user-VIP guest group; style-data repair method 2; number-1 ten thousand). In the case that the repair object in the data repair mode is a financial service valid period, a data repair operation statement s= (user-VIP guest group; style-data repair mode 1& & data repair mode 2; number-1 ten thousand) can be directly generated, and in the embodiment, different numbers of data repair operation statements are generated according to the characteristics of different data repair objects, so that the data repair efficiency is improved under the condition that the diversity of data repair scenes is satisfied.

Step S103, receiving a database selection instruction, and determining a database to be repaired according to the database selection instruction.

The terminal equipment can also receive a database selection instruction input by a user, different databases respectively store client data with different contents because of a plurality of databases in the financial system, and the database to be repaired can be determined from the plurality of databases according to the database selection instruction. In this embodiment, the number of databases to be repaired selected by the user may be plural, and the number of databases to be repaired is not limited. The selected database to be repaired may be a client database, and client data of relevant clients applying the financial system service is stored in the client database, for example, client registration information or relevant content such as service type of client application may be included in the client data, in this embodiment, the type of the selected database to be repaired and the data content stored in the database are not limited, and the following embodiments mainly refer to repairing the client data in the client database.

Step S104, executing data repair operation sentences aiming at the database to be repaired so as to repair the data in the database to be repaired in batches.

Optionally, executing a data repair operation statement for the database to be repaired to repair data in the database to be repaired in batches, including: determining target data from a database to be repaired according to the guest group in the data repair operation statement; determining a data repair period according to the single repair quantity in the data repair operation statement and the target data; and carrying out batch repair on the target data in a repair period according to a data repair mode.

Under the condition that the client database to be repaired and the data repair operation sentences are determined, the data repair operation sentences can be executed for the client database to be repaired, wherein when the number of the client databases to be repaired is multiple, the data repair operation sentences can be executed in parallel in the multiple client data to be repaired, so that the batch repair of the client data in parallel to the multiple client databases to be repaired is realized. In addition, when the number of the data repair operation sentences is multiple, the multiple data repair operation sentences can be executed in parallel in the same customer database to be repaired, so that the number of the customer databases to be repaired and the number of the executed data repair operation sentences are not limited in the embodiment aiming at the synchronous batch repair of different repair objects of the customer data, and the number of the customer databases to be repaired and the number of the executed data repair operation sentences are all within the protection scope of the application as long as the customer data can be repaired to be a numerical value matched with the business supervision standard according to the requirement of a user.

In a specific implementation, when it is determined that the data repair operation statement is s2= (user-VIP guest group; style-data repair mode 2; number-1 ten thousand), if the customer database to be repaired is a customer loan database, it may be determined that, according to the VIP guest group, the target customer data corresponding to the VIP guest group is 10 ten thousand from the customer loan database, which is merely an example in this embodiment, and the value of the target customer data is usually very huge in practical application. Therefore, if the number of single repairs in the data repair operation statement is 1 ten thousand, the data recovery period is 10 times according to 10 ten thousand target client data, and the data repair mode 2 is known according to the content: checking whether separators exist in province-city-county intervals in the addresses of the financial service providing institutions, adding separators between province-city-county intervals for addresses without separators, checking 1 ten thousand target customer data in each data restoration process, screening out the addresses of the financial service providing institutions which do not meet the requirements in each customer address, and uniformly restoring the addresses to be represented in the form of separators, wherein the separators can be blank spaces or "-", and of course, the separators are only exemplified and not limited in specific form, can be defaults of financial systems and can be designated in a data restoration mode, so that the restoration of the customer data in a customer loan database is completed in 10 restoration processes.

According to the embodiment of the application, the task application formulated and submitted by the service operator is directly acquired through the on-line data restoration function interface, under the condition that the approval of the approval user of the service department passes, the task application is directly analyzed to acquire the data restoration operation statement, and the operation statement is executed through the terminal equipment to realize the restoration of the data, so that multiple departments do not need to participate in interaction and formulation and development processes of schemes, the operation of automatic processing is increased, the error rate of the data restoration is obviously reduced, the restoration flow of the data is obviously simplified, the intervention of multiple users is reduced, and the efficiency of the data restoration is improved.

Example two

Fig. 2 is a flowchart of a data repair method according to two embodiments of the present application, where the embodiment is based on the above embodiment, and after executing a data repair operation statement with respect to a database to be repaired, the method further includes: obtaining a data restoration result; and carrying out statistics on the repair result to obtain statistical parameters. As shown in fig. 2, the method comprises the steps of:

Step S201, receiving a task application of data restoration through a data restoration function interface so that an approval user approves the task application.

Step S202, when it is determined that an approval passing instruction for the task application is received, analyzing the task application to obtain a data repair operation statement.

Optionally, adding the repair parameter to the operation statement template to generate at least one data repair operation statement includes: obtaining a repair object corresponding to each data repair mode, wherein the repair object comprises at least one of gender, address, nationality and contact mode; grouping the data restoration modes according to the characteristics of the restoration objects to obtain a specified number of data restoration mode groups, wherein the data restoration mode groups comprise data restoration modes with the same characteristics of the restoration objects, and the characteristics comprise the uniqueness of the relationship between the restoration objects and the clients or the uniqueness of the relationship between the restoration objects and the clients; determining a designated number of the data restoration mode groups, wherein the value of the designated number is at least one; each data repair mode group, each data repair mode and each single repair quantity are respectively added into the operation statement templates of the designated quantity to generate at least one data repair operation statement.

Step S203, receiving a database selection instruction, and determining a database to be repaired according to the database selection instruction.

Step S204, executing data repair operation sentences aiming at the database to be repaired so as to repair the data in the database to be repaired in batches.

Step S205, obtaining a repair result of the data, and carrying out statistics on the repair result to obtain statistical parameters.

Specifically, in this embodiment, when executing the data repair operation statement, the data content before and after each data modification is recorded, the recorded repair result is obtained when the execution of the data repair operation statement is completed, and the statistical analysis is performed on the repair result to obtain the statistical parameter, where the statistical parameter includes the repair proportion of the client data, for example, when determining that the data repair operation statement is s2= (user-VIP client group; style-data repair mode 2; number-1 ten thousand), the repair proportion of the client data can be determined to be 1/5 if the repair is determined to be only 2 ten thousand target client data according to the VIP client group from the client database to be repaired, and the format of the providing mechanism address of the financial service is changed. In addition, in the case that the data repair operation statement includes multiple data repair manners, the obtained statistical parameter may also be a repair proportion of the client data corresponding to the different repair manners, for example, when determining that the data repair operation statement includes: data repair operation sentence s1= (user-VIP guest group; style-data repair method 1; number-1 ten thousand), and data repair operation sentence s2= (user-VIP guest group; style-data repair method 2; number-1 ten thousand). The restoration ratio of the customer data of the address of the providing institution for the financial service can be determined to be 1/4 for the same customer database to be restored, and the restoration ratio of the customer data of the identification for the financial service is 1/6, which is, of course, only illustrated in the embodiment, and not limited to the content of the statistical parameters and the specific acquisition mode of the statistical parameters.

Optionally, the method further comprises; tracking the execution process of the data repair operation statement to acquire the repair progress of the target data; and receiving a progress query instruction of an application user, and displaying the repair progress on the repair function interface according to the progress query quality.

Optionally, after displaying the repair progress on the repair function interface according to the progress query quality, the method further includes: receiving a repair pause instruction of an application user, wherein the repair pause instruction is triggered when the repair progress is abnormal; and stopping the execution of the data repair operation statement according to the repair pause instruction.

It should be noted that, in this embodiment, the data repair process is further tracked, and the data repair progress is displayed on the repair function interface according to the display requirement of the user, for example, when the data repair period is determined to be 10, but only one data repair is currently performed, when the progress query instruction of the user is received, the current repair progress is displayed in the form of a cross-track chart or a pie chart, which is, of course, only illustrated, but not limited by the specific display manner of the repair progress, and if the user can conveniently and intuitively and efficiently obtain the repair progress, the repair progress is within the protection scope of the present application, which is not described in detail in this embodiment. When the application user determines that the data repair is abnormal according to the repair progress, a data repair pause instruction can be input to the terminal equipment, for example, the repair progress does not change within ten minutes, the current data repair operation statement does not work normally, and therefore the data repair is determined to be abnormal, invalid occupation of resources is avoided, after the data repair operation statement is stopped and executed, the user can repair software and hardware equipment in time, and therefore accuracy of the data repair is guaranteed.

Example III

Fig. 3 is a schematic structural diagram of a data restoration device according to an embodiment of the present application. As shown in fig. 3, the data restoration apparatus includes: the system comprises a task application approval module 310, a task application analysis module 320, a database determination module 330 to be repaired and a data repair module 340.

The task application approval module 310 is configured to receive a task application for data restoration through the data restoration function interface, so that an approval user approves the task application;

The task application parsing module 320 is configured to parse the task application to obtain a data repair operation statement when it is determined that an approval passing instruction for the task application is received;

The database to be repaired determining module 330 is configured to receive the database selection instruction and determine a database to be repaired according to the database selection instruction;

the data repair module 340 is configured to execute a data repair operation statement for the database to be repaired, so as to repair data in the database to be repaired in batches.

Optionally, the task application approval module is configured to display a data repair function interface when it is determined that a data repair request instruction is received, where the data repair function interface includes an attribute information filling item of a task application;

Receiving attribute information added in filling items by a user through a data restoration function interface, and generating a task application according to the attribute information, wherein the attribute information comprises a data restoration rule, a client range and a data restoration plan;

And receiving an approval user appointed by the application user, and submitting the task application to the approval user so that the approval user performs compliance approval on the attribute information in the task application.

Optionally, the task application parsing module includes: the task application analysis unit is used for analyzing the attribute information in the task application to obtain repair parameters, wherein the repair parameters comprise a customer group, a data repair mode and a single repair quantity;

The data repair operation sentence acquisition unit is used for acquiring the operation sentence template and adding the repair parameters into the operation sentence template to generate a data repair operation sentence.

Optionally, the task application parsing unit is configured to determine a customer group according to a customer scope, determine a data repair mode according to a data repair rule, and determine a single repair number according to a data repair plan;

and taking the guest group, the data restoration mode and the single restoration quantity as restoration parameters.

Optionally, a data repair operation sentence acquisition unit, configured to determine whether the number of data repair manners in the repair parameters is one, if yes, directly add the repair parameters to an operation sentence template to generate a data repair operation sentence,

Otherwise, adding the repair parameters to the operation statement template to generate at least one data repair operation statement.

Optionally, the data repair operation sentence obtaining unit is further configured to obtain a repair object corresponding to each data repair mode, where the repair object includes at least one of gender, address, nationality and contact mode;

grouping the data restoration modes according to the characteristics of the restoration objects to obtain a specified number of data restoration mode groups, wherein the data restoration mode groups comprise data restoration modes with the same characteristics of the restoration objects, and the characteristics comprise the uniqueness of the relationship between the restoration objects and the clients or the uniqueness of the relationship between the restoration objects and the clients;

determining a designated number of the data restoration mode groups, wherein the value of the designated number is at least one;

each data repair mode group, each data repair mode and each single repair quantity are respectively added into the operation statement templates of the designated quantity to generate at least one data repair operation statement.

Optionally, the data repairing module is used for determining target data from the database to be repaired according to the guest group in the data repairing operation statement;

determining a data repair period according to the single repair quantity in the data repair operation statement and the target data;

and carrying out batch repair on the target data in a repair period according to a data repair mode.

Optionally, the device further comprises a statistics module, which is used for obtaining the repair result of the data;

and carrying out statistics on the repair result to obtain a statistical parameter, wherein the statistical parameter comprises the repair proportion of the data.

Optionally, the device further comprises a progress display module, which is used for tracking the execution process of the data repair operation statement to obtain the repair progress of the target data;

and receiving a progress query instruction of the application user, and displaying the repair progress on the repair function interface according to the progress query quality.

Optionally, the device further comprises a repair suspension module, which is used for receiving a repair suspension instruction of the application user, wherein the repair suspension instruction is triggered when the repair progress is abnormal;

and stopping the execution of the data repair operation statement according to the repair suspension instruction.

The data restoration device provided by the embodiment of the invention can execute the data restoration method provided by any embodiment of the invention, and has the corresponding functional modules and beneficial effects of the execution method.

Example IV

Fig. 4 shows a schematic diagram of the structure of an electronic device 10 that may be used to implement an embodiment of the invention. Electronic devices are intended to represent various forms of digital computers, such as laptops, desktops, workstations, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. Electronic equipment may also represent various forms of mobile devices, such as personal digital processing, cellular telephones, smartphones, wearable devices (e.g., helmets, glasses, watches, etc.), and other similar computing devices. The components shown herein, their connections and relationships, and their functions, are meant to be exemplary only, and are not meant to limit implementations of the inventions described and/or claimed herein.

As shown in fig. 4, the electronic device 10 includes at least one processor 11, and a memory, such as a Read Only Memory (ROM) 12, a Random Access Memory (RAM) 13, etc., communicatively connected to the at least one processor 11, in which the memory stores a computer program executable by the at least one processor, and the processor 11 may perform various appropriate actions and processes according to the computer program stored in the Read Only Memory (ROM) 12 or the computer program loaded from the storage unit 18 into the Random Access Memory (RAM) 13. In the RAM 13, various programs and data required for the operation of the electronic device 10 may also be stored. The processor 11, the ROM 12 and the RAM 13 are connected to each other via a bus 14. An input/output (I/O) interface 15 is also connected to bus 14.

Various components in the electronic device 10 are connected to the I/O interface 15, including: an input unit 16 such as a keyboard, a mouse, etc.; an output unit 17 such as various types of displays, speakers, and the like; a storage unit 18 such as a magnetic disk, an optical disk, or the like; and a communication unit 19 such as a network card, modem, wireless communication transceiver, etc. The communication unit 19 allows the electronic device 10 to exchange information/data with other devices via a computer network, such as the internet, and/or various telecommunication networks.

The processor 11 may be a variety of general and/or special purpose processing components having processing and computing capabilities. Some examples of processor 11 include, but are not limited to, a Central Processing Unit (CPU), a Graphics Processing Unit (GPU), various specialized Artificial Intelligence (AI) computing chips, various processors running machine learning model algorithms, digital Signal Processors (DSPs), and any suitable processor, controller, microcontroller, etc. The processor 11 performs the various methods and processes described above, such as the repair method of data.

In some embodiments, the method of repairing data may be implemented as a computer program tangibly embodied on a computer-readable storage medium, such as the storage unit 18. In some embodiments, part or all of the computer program may be loaded and/or installed onto the electronic device 10 via the ROM 12 and/or the communication unit 19. When the computer program is loaded into RAM 13 and executed by processor 11, one or more steps of the data restoration method described above may be performed. Alternatively, in other embodiments, the processor 11 may be configured to perform the method of repairing data in any other suitable manner (e.g., by means of firmware).

Various implementations of the systems and techniques described here above may be implemented in digital electronic circuitry, integrated circuit systems, field Programmable Gate Arrays (FPGAs), application Specific Integrated Circuits (ASICs), application Specific Standard Products (ASSPs), systems On Chip (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and/or combinations thereof. These various embodiments may include: implemented in one or more computer programs, the one or more computer programs may be executed and/or interpreted on a programmable system including at least one programmable processor, which may be a special purpose or general-purpose programmable processor, that may receive data and instructions from, and transmit data and instructions to, a storage system, at least one input device, and at least one output device.

A computer program for carrying out methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus, such that the computer programs, when executed by the processor, cause the functions/acts specified in the flowchart and/or block diagram block or blocks to be implemented. The computer program may execute entirely on the machine, partly on the machine, as a stand-alone software package, partly on the machine and partly on a remote machine or entirely on the remote machine or server.

In the context of the present invention, a computer-readable storage medium may be a tangible medium that can contain, or store a computer program for use by or in connection with an instruction execution system, apparatus, or device. The computer readable storage medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. Alternatively, the computer readable storage medium may be a machine readable signal medium. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

To provide for interaction with a user, the systems and techniques described here can be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to a user; and a keyboard and a pointing device (e.g., a mouse or a trackball) through which a user can provide input to the electronic device. Other kinds of devices may also be used to provide for interaction with a user; for example, feedback provided to the user may be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form, including acoustic input, speech input, or tactile input.

The systems and techniques described here can be implemented in a computing system that includes a background component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front-end component (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such background, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: local Area Networks (LANs), wide Area Networks (WANs), blockchain networks, and the internet.

The computing system may include clients and servers. The client and server are typically remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other. The server can be a cloud server, also called a cloud computing server or a cloud host, and is a host product in a cloud computing service system, so that the defects of high management difficulty and weak service expansibility in the traditional physical hosts and VPS service are overcome.

Example five

Embodiments of the present application also provide a computer program product comprising a computer program which, when executed by a processor, implements a method of repairing data as provided by any of the embodiments of the present application.

Computer program product in the implementation, the computer program code for carrying out operations of the present invention may be written in one or more programming languages, including an object oriented programming language such as Java, smalltalk, C ++ and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computer (for example, through the Internet using an Internet service provider).

It should be noted that, in the embodiments of the present application, some existing solutions in the industry such as software, components, models, etc. may be mentioned, and they should be regarded as exemplary, only for illustrating the feasibility of implementing the technical solution of the present application, but it does not mean that the applicant has or must not use the solution.

Note that the above is only a preferred embodiment of the present invention and the technical principle applied. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, while the invention has been described in connection with the above embodiments, the invention is not limited to the embodiments, but may be embodied in many other equivalent forms without departing from the spirit or scope of the invention, which is set forth in the following claims.

Claims

1. A method of data repair, comprising:

receiving a task application of data restoration through a data restoration function interface, so that an approval user approves the task application;

2. The method of claim 1, wherein receiving a task application for data repair via a data repair function interface to enable an approval user to approve the task application, comprises:

When the data restoration request instruction is determined to be received, displaying the data restoration function interface, wherein the data restoration function interface comprises an attribute information filling item of the task application;

Receiving attribute information added in the filling item by an application user through the data restoration function interface, and generating the task application according to the attribute information, wherein the attribute information comprises a data restoration rule, a client range and a data restoration plan;

And receiving the approval user specified by the application user, and submitting the task application to the approval user so that the approval user performs compliance approval on the attribute information in the task application.

3. The method according to claim 2, wherein parsing the task application to obtain a data repair operation statement comprises:

analyzing attribute information in the task application to obtain repair parameters, wherein the repair parameters comprise a customer group, a data repair mode and a single repair quantity;

and acquiring an operation sentence template, and adding the repair parameters into the operation sentence template to generate the data repair operation sentence.

4. A method according to claim 3, wherein the parsing the attribute information in the task application to obtain repair parameters includes:

Determining the customer group according to the customer range, determining a data restoration mode according to the data restoration rule, and determining the single restoration quantity according to the data restoration plan;

and taking the guest group, the data restoration mode and the single restoration quantity as the restoration parameters.

5. The method of claim 3, wherein the adding the repair parameters to the operation statement template to generate the data repair operation statement comprises:

judging whether the number of the data restoration modes in the restoration parameters is one, if so, directly adding the restoration parameters into an operation statement template to generate a data restoration operation statement,

6. The method of claim 5, wherein the adding the repair parameters to the operation statement template to generate at least one data repair operation statement comprises:

obtaining a repair object corresponding to each data repair mode;

determining a specified number of the data restoration mode groups, wherein the number of the specified number is at least one;

and adding each data repair mode group, each data repair mode and each single repair quantity into a specified quantity of operation statement templates respectively to generate at least one data repair operation statement.

7. A method according to claim 3, wherein the performing the data repair operation statement for the database to be repaired to batch repair data in the database to be repaired comprises:

determining target data from the database to be repaired according to the guest group in the data repair operation statement;

Determining a data repair period according to the single repair number in the data repair operation statement and the target data;

and carrying out batch restoration on the target data in the restoration period according to the data restoration mode.

8. The method of claim 1, wherein after executing the data repair operation statement for the database to be repaired to batch repair data in the target customer information base, further comprising:

Obtaining a repair result of the data;

9. The method of claim 7, wherein the method further comprises;

tracking the execution process of the data repair operation statement to acquire the repair progress of the target data;

And receiving a progress query instruction of an application user, and displaying the repair progress on the repair function interface according to the progress query quality.

10. The method of claim 9, wherein after the presenting the repair progress on the repair function interface according to the progress query quality, further comprising:

receiving a repair pause instruction of an application user, wherein the repair pause instruction is triggered when the repair progress is abnormal;

And stopping the execution of the data repair operation statement according to the repair pause instruction.

11. A data retrieval device, comprising:

The task application approval module is used for receiving a task application of data restoration through the data restoration function interface so as to enable an approval user to approve the task application;

12. The apparatus of claim 11, wherein the task application approval module is configured to display the data repair function boundary when it is determined that the data repair request instruction is received, and wherein the data repair function interface includes an attribute information filling item of the task application;

13. An electronic device, comprising: a processor, and a memory communicatively coupled to the processor;

The memory stores computer-executable instructions;

the processor executes computer-executable instructions stored in the memory to implement the method of any one of claims 1-10.

14. A computer readable storage medium having stored therein computer executable instructions which when executed by a processor are adapted to carry out the method of any one of claims 1-10.

15. A computer program product comprising a computer program which, when executed by a processor, implements the method of any of claims 1-10.