Data modification processing method and device, computer equipment and storage medium

Abstract

The invention relates to the technical field of data processing, and discloses a data modification processing method and device, computer equipment and a storage medium in the fields of financial science and technology and medical health. The method comprises the steps of obtaining a data modification request, and determining a target script name according to the data modification request; performing field searching processing on a preset script configuration list according to the target script name to obtain a modified data address, a modified operation type and modified data; determining to-be-modified data according to the modification data address, obtaining a modification script template corresponding to the modification operation type, and generating a target modification script according to the modification data address, the modification operation type, the modified data and the modification script template; and script scheduling information associated with the target script name is determined from a preset script scheduling association table, and after the target modification script is successfully operated in the database based on the script scheduling information, completion of modification processing operation of the to-be-modified data is confirmed. According to the invention, the data modification processing efficiency is improved.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of data processing, in particular to a data modification processing method and device, computer equipment and storage medium in the fields of financial technology and medical health. BACKGROUND

[0002] In daily business in the fields of financial technology and medical health, database data access scenarios are becoming more and more common. The database is used to store various types of data, and when data errors occur, the data needs to be modified to ensure the normal operation of the business. In addition, when the version of the server is changed or the type of business is replaced, the data in the database also needs to be modified. In the financial and insurance industry, with the growth of data volume and the increase of business complexity, new insurance businesses are constantly launched, requiring the database to store more detailed insurance claim data and user data, etc. In order to meet the growing storage and analysis needs, the database needs to be expanded or re-integrated. In the medical and health industry, traditional offline diagnosis and treatment has developed into online and offline combined remote medical services, and the database needs to add data recording remote diagnosis and treatment related information, such as remote diagnosis and treatment time, video recording link, patient and doctor network equipment information, etc.

[0003] In the prior art, when a business personnel needs to modify business data, a complete version development process is required to implement data modification. At the same time, when there is incomplete modification or mis-modification operation, a new version needs to be released again, and a complete process needs to be implemented again for modification. This data modification method causes a lot of time and manpower and material resources to be wasted, reduces the data modification efficiency, and cannot adapt to the growing database business needs of data volume and business complexity.

[0004] Therefore, there is an urgent need for a more efficient data modification scheme that can adapt to complex business needs. SUMMARY

[0005] Therefore, it is necessary to provide a data modification processing method, device, computer equipment and storage medium to solve the problems of time-consuming and labor-intensive, low processing efficiency of the existing data modification processing method.

[0006] A data modification processing method comprises: obtaining a data modification request, and determining a target script name according to the data modification request; performing field search processing on a preset script configuration list according to the target script name, to obtain modification data address, modification operation type and modified data corresponding to the target script name; determine to-be-modified data in the database according to the modification data address, obtain a modification script template corresponding to the modification operation type, and generate a target modification script corresponding to the to-be-modified data according to the modification data address, the modification operation type, the modified data, and the modification script template; determine script scheduling information associated with the target script name from a preset script scheduling association table, and confirm completion of the modification processing operation of the to-be-modified data after successfully running the target modification script in the database based on the script scheduling information.

[0007] A data modification processing apparatus, comprising: a script name determination module configured to obtain a data modification request and determine a target script name according to the data modification request; a field search processing module configured to perform field search processing on a preset script configuration list according to the target script name, to obtain a modification data address, a modification operation type, and modified data corresponding to the target script name; a modification script generation module configured to determine to-be-modified data in the database according to the modification data address, obtain a modification script template corresponding to the modification operation type, and generate a target modification script corresponding to the to-be-modified data according to the modification data address, the modification operation type, the modified data, and the modification script template; a modification script running module configured to determine script scheduling information associated with the target script name from a preset script scheduling association table, and confirm completion of the modification processing operation of the to-be-modified data after successfully running the target modification script in the database based on the script scheduling information.

[0008] A computer device, comprising a memory, a processor, and computer readable instructions stored in the memory and executable on the processor, wherein the processor executes the computer readable instructions to implement the data modification processing method.

[0009] A computer readable storage medium, storing computer readable instructions, wherein the computer readable instructions are executed by one or more processors to cause the one or more processors to perform the data modification processing method.

[0010] In the above-mentioned data modification processing method, device, computer equipment and storage medium, the data modification processing method obtains a data modification request and determines the target script name according to the data modification request; performs field search processing on the preset script configuration list according to the target script name to obtain the modification data address, modification operation type and modified data corresponding to the target script name; determines the data to be modified in the database according to the modification data address, obtains the modification script template corresponding to the modification operation type, and generates the target modification script corresponding to the data to be modified according to the modification data address, modification operation type, modified data and modification script template; determines the script scheduling information associated with the target script name from the preset script scheduling association table, and confirms the completion of the modification processing operation of the data to be modified after the target modification script is successfully run in the database based on the script scheduling information. The present invention utilizes the field information in the preset script configuration list and the scheduling information in the preset script scheduling association table to realize the automated data modification operation of the database based on the field-level script, simplifies the data modification operation process, greatly speeds up the speed of script modification online, saves a lot of time and manpower and material resources, and improves data modification efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0011] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the following briefly introduces the drawings required for use in the description of the embodiments of the present invention. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative labor.

[0012] Figure 1 This is a schematic diagram of an application environment of a data modification processing method according to an embodiment of the present invention; Figure 2 This is a flow chart of a data modification processing method according to an embodiment of the present invention; Figure 3 It is a structural diagram of a data modification processing device in one embodiment of the present invention; Figure 4 FIG. 1 is a schematic diagram of a computer device according to an embodiment of the present invention. DETAILED DESCRIPTION

[0013] The following will clearly and completely describe the technical solutions in the embodiments of the present invention in conjunction with the accompanying drawings. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of them. All other embodiments derived by persons of ordinary skill in the art based on the embodiments of the present invention without inventive effort shall fall within the scope of protection of the present invention.

[0014] The data modification processing method provided in this embodiment can be applied toFigure 1 In an application environment, a client communicates with a server. Clients include, but are not limited to, various personal computers, laptops, smartphones, tablets, and portable wearable devices. The server can be implemented as a standalone server or a server cluster consisting of multiple servers.

[0015] The data modification and processing method of this embodiment can be applied to the financial and insurance industries. The financial and insurance industries are subject to strict regulatory oversight. When regulations change, the storage and processing methods of data in the database also need to be adjusted accordingly. For example, if data privacy protection regulations require stricter encryption and storage of sensitive information of insurance users, or restrict access to certain data, the database will need to be modified to meet these requirements. The method used to protect user sensitive information is divided into three main stages: adding ciphertext fields, switching to ciphertext downstream, and removing plaintext fields.

[0016] The data modification processing method of this embodiment can also be applied to the healthcare industry. With the development of medical information technology, collaboration between different medical institutions is becoming increasingly frequent. Medical and health institutions may need to upgrade or migrate their systems. This process requires data modification to ensure cross-institutional data sharing and integration.

[0017] In actual applications, after the server triggers the process of the data modification processing method, it obtains a data modification request and determines the target script name based on the data modification request; performs field search processing on the preset script configuration list based on the target script name to generate a target modification script corresponding to the data to be modified; determines the script scheduling information associated with the target script name from the preset script scheduling association table, and confirms the completion of the modification processing operation of the data to be modified after successfully running the target modification script in the database based on the script scheduling information. Therefore, this embodiment can realize automated data modification operations on the database, encrypt and protect user privacy information in financial and insurance business scenarios, and meet the data migration needs in medical and health business scenarios.

[0018] In one embodiment, if Figure 2 As shown, a data modification processing method is provided, comprising the following steps S10-S40: S10: Obtain a data modification request, and determine a target script name according to the data modification request.

[0019] Understandably, the server obtains the data modification request, parses the data modification request, and extracts the target script name. The data modification request is a request information used to represent that the specified database needs to be modified. The script refers to a code set used to perform add, delete, modify, and query operations on the data stored in the database. The target script name refers to the unique identification name information of the script used to achieve the data modification function required by the data modification request.

[0020] S20, field lookup processing is performed on the preset script configuration list according to the target script name, and modification data address, modification operation type, and modified data corresponding to the target script name are obtained.

[0021] Understandably, the preset script configuration list is a list configured in advance for storing script metadata corresponding to different scripts. Script metadata refers to data used to describe the characteristics of a script. Script metadata does not contain the actual logic or code of the script, but provides additional information about the script, which can help the server better understand, manage, and use the script. Each script corresponds to a set of script metadata, and each set of script metadata includes script name and script field information in a corresponding relationship. Script field information refers to description information of script function from the field dimension, such as data address field, operation type field, etc.

[0022] The preset script configuration list includes multiple script metadata composed of script names and script field information corresponding to each script name. After the server obtains the target script name, field lookup processing is performed on the preset script configuration list according to the target script name, and modification data address, modification operation type, and modified data corresponding to the target script name are obtained. The modification data address is used to represent the data storage location information in the database that needs to be modified. The modification operation type is used to represent the type of modification operation to be performed, such as data deletion operation, data replacement operation, etc. The modified data refers to the stored data corresponding to the modification data address after the modification operation is completed, such as the replaced data.

[0023] S30, according to the modification data address, determine the data to be modified in the database, obtain the modification script template corresponding to the modification operation type, and generate the target modification script corresponding to the data to be modified according to the modification data address, modification operation type, modified data, and modification script template.

[0024] Understandably, the server can determine the to-be-modified data in the database according to the modified data address, where the to-be-modified data refers to the stored data corresponding to the modified data address before the modification operation is executed. The server can also obtain a modification script template corresponding to the modification operation type, where the modification script template refers to a reusable script code framework that is pre-written for implementing different modification operations. Different modification operation types correspond to different modification script templates. The server fills the modified data address, the modification operation type, and the modified data into the modification script template as parameters to obtain a target modification script corresponding to the to-be-modified data. The target modification script refers to a code set for transforming the to-be-modified data into the modified data in response to a data modification request.

[0025] S40, determine the script scheduling information associated with the target script name from the preset script scheduling association table, and confirm that the modification processing operation of the to-be-modified data is completed after successfully running the target modification script in the database based on the script scheduling information.

[0026] Understandably, the preset script scheduling association table is a data list pre-configured for associatively storing the script names and script scheduling information of different scripts. Each script corresponds to a script name and script scheduling information, and the script name and script scheduling information of the same script have an association relationship. The script scheduling information refers to the description information for representing the order and time arrangement of automatically executing the script. Based on the script scheduling information, the target modification script can be controlled to run at what time and in what way to achieve the automation and efficient management of the data modification task.

[0027] The server determines the script scheduling information associated with the target script name from the preset script scheduling association table, then runs the target modification script in the database according to the script scheduling information, and judges whether the target modification script is successfully run. If the target modification script fails to run in the database, the target modification script is run in the database, and the number of retries of the target modification script is recorded until the target modification script is successfully run or the number of retries reaches the maximum number of retries, and the retry is stopped. The maximum number of retries can be set as a default value, or can be adjusted as needed, such as 3 times by default. If the target modification script is successfully run in the database, it is confirmed that the modification processing operation of the to-be-modified data is completed.

[0028] The embodiment obtains a data modification request, determines a target script name according to the data modification request, performs field search processing on a preset script configuration list according to the target script name, obtains modification data address, modification operation type and modified data corresponding to the target script name, determines to-be-modified data in the database according to the modification data address, obtains a modification script template corresponding to the modification operation type, generates a target modification script corresponding to the to-be-modified data according to the modification data address, the modification operation type, the modified data and the modification script template, determines script scheduling information associated with the target script name from a preset script scheduling association table, and confirms completion of the modification processing operation of the to-be-modified data after successfully running the target modification script in the database based on the script scheduling information. The embodiment uses field information in the preset script configuration list and scheduling information in the preset script scheduling association table to realize automatic data modification operation of a script on a database based on a field level, simplifies a data modification operation process, greatly accelerates the speed of script modification online, saves a large amount of time, manpower and material resources, and improves data modification efficiency.

[0029] In an embodiment, before the data modification request is obtained in step S10, the following steps are included: S101, detecting whether a configuration modification field exists in the preset script configuration list in a time manner; S102, when the configuration modification field exists in the preset script configuration list, determining a script name corresponding to the configuration modification field as a target script name, and generating a data modification request according to the target script name.

[0030] Understandably, before the data modification request is obtained on the server side, an operation and maintenance personnel user can edit and modify script field information of one or more scripts in the preset script configuration list through the client side as needed, so as to generate a data modification request and trigger the process of the data modification processing method by using the data modification request. Therefore, the server side detects whether a configuration modification field exists in the preset script configuration list in a time manner at a preset time interval (such as 3 seconds). The configuration modification field refers to record information of editing and modifying script field information in script metadata by the user through the client side.

[0031] When the configuration modification field exists in the preset script configuration list, the script name corresponding to the configuration modification field is determined as the target script name, and a data modification request is generated according to the target script name. The target script name can be one or more. If the user only edits and modifies the script field information of one script in the preset script configuration list, the target script name is only one. If the user edits and modifies the script field information of two or more scripts in the preset script configuration list at the same time, the target script name is more than one. When the configuration modification field does not exist in the preset script configuration list, the flow of the data modification processing method does not need to be triggered.

[0032] The embodiment can quickly identify script configuration changes through timing detection, automatically generate a data modification request and trigger the flow of the subsequent data modification processing method, realize the automatic connection of configuration changes to data updates, avoid the trouble of re-writing scripts, and improve system stability and operation and maintenance efficiency. At the same time, multiple scripts can be combined into one data modification request when they are changed at the same time, improving data modification processing efficiency and being suitable for scenarios of frequent configuration changes and batch changes.

[0033] In an embodiment, in step S20, i.e., the field lookup processing of the preset script configuration list according to the target script name, the modification data address, the modification operation type and the modified data corresponding to the target script name are obtained, including: S201, according to the data address field in the preset script configuration list, determining the sub-database name, the data table name and the data cell position corresponding to the target script name, and obtaining the modification data address according to the sub-database name, the data table name and the data cell position; S202, according to the operation type field in the preset script configuration list, determining the modification operation type corresponding to the target script name; S203, according to the data field in the preset script configuration list, determining the modified data corresponding to the target script name.

[0034] Understandably, the script metadata of the preset script configuration list includes script field information, and the script field information is divided into a data address field, an operation type field and a data field. The data address field is a data attribute unit for storing the data storage location information of the data to be modified in the database. The operation type field is a data attribute unit for storing the type of modification operation to be performed. The data field is a data attribute unit for storing the storage data corresponding to the modification data address after the completion of the modification operation.

[0035] The server finds a data address field corresponding to the target script name from the preset script configuration list, obtains a sub-database name, a data table name and a data cell position, and determines a modified data address according to the sub-database name, the data table name and the data cell position. The server finds an operation type field corresponding to the target script name from the preset script configuration list, and obtains a modification operation type. The modification operation type is one of a data deletion operation, a data replacement operation and a data addition operation. The server finds a data field corresponding to the target script name from the preset script configuration list, and determines modified data.

[0036] The embodiment based on field-level searching of the preset script configuration list can dynamically obtain detailed parameters of data modification processing according to a target script name, realizes automatic data modification processing, and can meet a data modification business scenario that needs frequent adjustment and dynamic expansion.

[0037] In an embodiment, before the step S40, that is, before the script scheduling information associated with the target script name is determined from the preset script scheduling association table, the following steps are included. S401, obtain scheduling association configuration information, and determine script sorting information and scheduling time information corresponding to each script name according to the scheduling association configuration information; S402, generate a script scheduling association data group corresponding to the script name according to the script sorting information and the scheduling time information corresponding to the same script name; S403, generate the preset script scheduling association table according to all the script scheduling association data groups.

[0038] Understandably, before the server determines the script scheduling information associated with the target script name from the preset script scheduling association table, the preset script scheduling association table needs to be generated based on the obtained scheduling association configuration information. The scheduling association configuration information refers to configuration information entered by a user through a client to specify an association relationship between different script names and script scheduling information.

[0039] The server parses the obtained scheduling association configuration information, and can determine the script ordering information and the scheduling time information corresponding to each script name. The script scheduling information includes the script ordering information and the scheduling time information. The script ordering information is used to represent the execution priority of the script in multiple data modification tasks, such as “order=10” indicating that the execution priority of the target script is the 10th. The scheduling time information is used to represent the specified execution time of the script, such as “03XXXX” indicating that the target script is executed at 3 o'clock in the morning. Then, the server generates a script scheduling association data group corresponding to the script name according to the script ordering information and the scheduling time information corresponding to the same script name, and generates a preset script scheduling association table according to all script scheduling association data groups. The script scheduling association data group refers to the data combination information used to associate and store the script name and the script scheduling information.

[0040] The embodiment generates a preset script scheduling association table based on the scheduling association configuration information, which can concentrate the scheduling configuration of all scripts in one data table, facilitating unified management and maintenance of the development and operation personnel. At the same time, it is helpful to realize automatic scheduling through the preset script scheduling association table, to automatically execute scripts in order and at a time, and to improve the data modification processing efficiency.

[0041] In an embodiment, after the target modification script is successfully run in the database based on the script scheduling information in step S40, the method further includes: S404, obtaining a script running result of the target modification script; S405, when the script running result is data modification exception, generating a target rollback script corresponding to the modified data according to the modification data address corresponding to the target script name, the modification operation type, and the modified data; S406, successfully running the target rollback script in the database based on the script scheduling information associated with the target script name, to complete the data rollback processing operation of the modified data in the database.

[0042] Understandably, after the target modification script is successfully run in the database based on the script scheduling information, the server obtains a script running result of the target modification script. The script running result is result information used to represent whether all the to-be-modified data in the database are changed into modified data after the execution of the target modification script, that is, whether there are errors and omissions in response to the data modification request in the database. The script running result is divided into data modification normal and data modification exception. The data modification normal means that all the to-be-modified data in the database are changed into modified data. The data modification exception means that part of the to-be-modified data in the database has not been changed into modified data, that is, there are errors and omissions in response to the data modification request in the database.

[0043] When the script running result is a data modification exception, the server generates a target rollback script corresponding to the modified data according to the modification data address corresponding to the target script name, the modification operation type, and the modified data. The target rollback script refers to a code set for restoring the modified data in the last data modification processing flow to the to-be-modified data. Based on the script scheduling information associated with the target script name, the target rollback script is successfully run in the database to complete the data rollback processing operation of the modified data in the database.

[0044] When the script running result of the target modification script is a data modification exception, the embodiment automatically generates and executes a rollback script to restore the data to the state before modification, which can ensure that all operations of the database are either all successful or all rolled back, avoids inconsistent data or residual dirty data caused by partial operation failure, and ensures the safety and consistency of the data.

[0045] In an embodiment, in step S405, i.e., the target rollback script corresponding to the modified data is generated according to the modification data address corresponding to the target script name, the modification operation type, and the modified data, which includes: S4051, determining a rollback data address according to the modification data address corresponding to the target script name, determining a rollback operation type as the modification operation type, and determining backup data according to the modified data corresponding to the target script name. S4052, obtaining a rollback script template corresponding to the rollback operation type, and generating a target rollback script according to the rollback data address, the rollback operation type, the backup data, and the rollback script template.

[0046] Understandably, the server determines a rollback data address according to the modification data address corresponding to the target script name, determines a rollback operation type as the modification operation type, and determines backup data according to the modified data corresponding to the target script name. The rollback data address is used to represent the data storage location information in the database that needs to be rolled back. The rollback operation type is used to represent the type information of the rollback operation that needs to be executed. The backup data refers to the initial storage data before the last data modification operation is executed, i.e., the to-be-modified data in the last data modification processing flow. In addition, the server obtains a rollback script template corresponding to the rollback operation type, fills the rollback data address, the rollback operation type, and the backup data as parameters into the rollback script template, and generates a target rollback script. The rollback script template refers to a reusable script code framework for implementing a data rollback operation.

[0047] The embodiment can quickly generate a target rollback script corresponding to the modified data based on the target script name, and the developer does not need to write a corresponding rollback script for each modified script. For a complex transaction involving multiple tables and multiple operations, the development process is simplified, the development efficiency is improved, and the operation and maintenance efficiency of data modification and rollback is significantly improved.

[0048] In an embodiment, before step S405, i.e., generating a target rollback script corresponding to the modified data according to the modified data address corresponding to the target script name, the modified operation type, and the modified data, the following steps are included: S4053, updating the operation type field corresponding to the target script name in the preset script configuration list to a rollback operation type; S4054, updating the data field corresponding to the target script name in the preset script configuration list to the backup data of the data to be modified.

[0049] Understandably, after the server determines that the script running result of the target modified script is data modification exception, and before generating a target rollback script corresponding to the modified data, the script field information of the corresponding target modified script in the preset script configuration list needs to be updated, so as to trigger the process of data rollback operation. The server updates the operation type field corresponding to the target script name in the preset script configuration list to a rollback operation type, and updates the data field corresponding to the target script name in the preset script configuration list to the backup data of the data to be modified. Since the data rollback operation and the last data modification operation correspond to the same position data, the data address field corresponding to the target script name in the preset script configuration list is kept unchanged.

[0050] After determining that the script running result of the target modified script is data modification exception, the embodiment updates the script field information in the preset script configuration list in time, and triggers the subsequent data rollback processing, which simplifies the data rollback operation process, speeds up the modification of the rollback script online, and improves the development and operation efficiency.

[0051] It should be understood that the size of the serial number of each step in the above embodiments does not mean the order of execution, and the execution order of each process should be determined according to its function and inherent logic, and should not constitute any limitation on the implementation process of the embodiment of the present application.

[0052] In an embodiment, a data modification processing device is provided, which corresponds to the data modification processing method in the above embodiments. As shown in the figure, the data modification processing device includes a script name determination module 10, a field search processing module 20, a modified script generation module 30, and a modified script running module 40. The functions of each module are described in detail as follows: Figure 3 The functions of each module are described in detail as follows: The script name determining module 10 is configured to obtain a data modification request and determine a target script name according to the data modification request. The field searching processing module 20 is configured to perform field searching processing on a preset script configuration list according to the target script name, and obtain modification data address, modification operation type and modified data corresponding to the target script name. The modification script generating module 30 is configured to determine to-be-modified data in a database according to the modification data address, obtain a modification script template corresponding to the modification operation type, and generate a target modification script corresponding to the to-be-modified data according to the modification data address, the modification operation type, the modified data and the modification script template. The modification script running module 40 is configured to determine script scheduling information associated with the target script name from a preset script scheduling association table, and confirm completion of a modification processing operation of the to-be-modified data after successfully running the target modification script in the database based on the script scheduling information.

[0053] In an embodiment, the script name determining module 10 includes: The timing detection unit is configured to detect whether there is a configuration modification field in the preset script configuration list. The request generating unit is configured to determine a script name corresponding to the configuration modification field as a target script name when there is a configuration modification field in the preset script configuration list, and generate a data modification request according to the target script name.

[0054] In an embodiment, the field searching processing module 20 includes: The data address field searching unit is configured to determine a sub-database name, a data table name and a data cell position corresponding to the target script name according to a data address field in the preset script configuration list, and obtain the modification data address according to the sub-database name, the data table name and the data cell position. The operation type field searching unit is configured to determine a modification operation type corresponding to the target script name according to an operation type field in the preset script configuration list. The data field searching unit is configured to determine modified data corresponding to the target script name according to a data field in the preset script configuration list.

[0055] In an embodiment, the modification script running module 40 includes: The association configuration information obtaining unit is configured to obtain scheduling association configuration information, and determine script sorting information and scheduling time information corresponding to each script name according to the scheduling association configuration information. The association data set determination unit is configured to generate a script scheduling association data set corresponding to the script name according to the script scheduling information and the scheduling time information corresponding to the same script name. The association table generation unit is configured to generate the preset script scheduling association table according to all the script scheduling association data sets.

[0056] In an embodiment, the modified script running module 40 further comprises: The script running result acquisition unit is configured to acquire a script running result of the target modified script. The target rollback script generation unit is configured to, when the script running result is a data modification exception, generate a target rollback script corresponding to the modified data according to the modified data address, the modification operation type and the modified data corresponding to the target script name. The data rollback processing unit is configured to successfully run the target rollback script in the database based on the script scheduling information associated with the target script name, and complete a data rollback processing operation of the modified data in the database.

[0057] In an embodiment, the modified script running module 40 further comprises: The rollback information determination unit is configured to determine a rollback data address according to the modified data address corresponding to the target script name, determine a rollback operation type according to the modification operation type, and determine backup data according to the modified data corresponding to the target script name. The rollback information integration unit is configured to acquire a rollback script template corresponding to the rollback operation type, and generate a target rollback script according to the rollback data address, the rollback operation type, the backup data and the rollback script template.

[0058] In an embodiment, the modified script running module 40 further comprises: The operation type field updating unit is configured to update an operation type field corresponding to the target script name in the preset script configuration list to a rollback operation type. The data field updating unit is configured to update a data field corresponding to the target script name in the preset script configuration list to backup data of the data to be modified.

[0059] The specific limitations of the data modification processing apparatus can refer to the limitations of the data modification processing method described above, which will not be repeated here. Each module in the above data modification processing apparatus can be realized by software, hardware and their combinations in whole or in part. The above modules can be embedded in or independent of the processor in the computer device in hardware form, or stored in the memory in the computer device in software form, so as to be called and executed by the processor to perform the operations corresponding to each module.

[0060] In one embodiment, a computer device is provided. The computer device may be a server, and its internal structure diagram may be as follows: Figure 4 As shown. The computer device includes a processor, a memory, a network interface and a database connected via a system bus. The processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a readable storage medium and an internal memory. The readable storage medium stores an operating system, computer-readable instructions and a database. The internal memory provides an environment for the operation of the operating system and computer-readable instructions in the readable storage medium. The database of the computer device is used to store data involved in the data modification processing method. The network interface of the computer device is used to communicate with an external terminal via a network connection. When the computer-readable instructions are executed by the processor, a data modification processing method is implemented. The readable storage medium provided in this embodiment includes a non-volatile readable storage medium and a volatile readable storage medium.

[0061] In one embodiment, a computer device is provided, comprising a memory, a processor, and computer-readable instructions stored in the memory and executable on the processor. When the processor executes the computer-readable instructions, the following steps are implemented: Obtaining a data modification request, and determining a target script name according to the data modification request; Performing a field search process on the preset script configuration list according to the target script name to obtain the modified data address, modification operation type and modified data corresponding to the target script name; Determine the data to be modified in the database according to the modification data address, obtain a modification script template corresponding to the modification operation type, and generate a target modification script corresponding to the data to be modified according to the modification data address, the modification operation type, the modified data, and the modification script template; The script scheduling information associated with the target script name is determined from a preset script scheduling association table, and after the target modification script is successfully run in the database based on the script scheduling information, the modification processing operation of the data to be modified is confirmed to be completed.

[0062] In one embodiment, one or more computer-readable storage media storing computer-readable instructions are provided. The computer-readable storage media provided in this embodiment include non-volatile computer-readable storage media and volatile computer-readable storage media. The computer-readable instructions stored on the computer-readable storage media, when executed by one or more processors, implement the following steps: Obtaining a data modification request, and determining a target script name according to the data modification request; According to the target script name, field lookup processing is performed on a preset script configuration list to obtain modification data address, modification operation type and modified data corresponding to the target script name; According to the modification data address, the modification operation type corresponding modification script template is obtained, and the target modification script corresponding to the modification data is generated according to the modification data address, the modification operation type, the modified data and the modification script template. From the preset script scheduling association table, the script scheduling information associated with the target script name is determined, and after the target modification script is successfully run in the database based on the script scheduling information, it is confirmed that the modification processing operation of the modification data is completed.

[0063] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be completed by computer readable instructions instructing related hardware, and the computer readable instructions can be stored in a non-volatile readable storage medium or a volatile readable storage medium. When the computer readable instructions are executed, the processes of the above-mentioned embodiments can be included. Any reference to memory, storage, database or other medium used in each embodiment provided by the present application can include non-volatile and / or volatile memory. Non-volatile memory can include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM) or flash memory. Volatile memory can include random access memory (RAM) or external cache memory. As an illustration but not limitation, RAM is available in various forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double data rate SDRAM (DDR SDRAM), enhanced SDRAM (ESDRAM), synchronous link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).

[0064] Those skilled in the art can clearly understand that, for the convenience and brevity of description, only the division of the above-mentioned functional units and modules is exemplified, and in actual application, the above-mentioned functions can be completed by different functional units and modules according to needs, that is, the internal structure of the device is divided into different functional units or modules to complete all or part of the functions described above.

[0065] The non-company software tools or components appearing in the embodiments of the present application are only used for example introduction, and do not represent actual use. The above-described embodiments are only used to illustrate the technical solutions of the present application, and not to limit them; although the foregoing embodiments of the present application have been described in detail, those skilled in the art should understand that the technical solutions recorded in the foregoing embodiments can be modified, or some technical features can be replaced by equivalents; and these modifications or replacements do not make the essence of the corresponding technical solutions deviate from the spirit and scope of the technical solutions of the embodiments of the present application, and should be included in the protection scope of the present application.

Claims

1. A data modification processing method, characterized in that: include: Obtaining a data modification request, and determining a target script name according to the data modification request; Performing a field search process on the preset script configuration list according to the target script name to obtain the modified data address, modification operation type and modified data corresponding to the target script name; Determine the data to be modified in the database according to the modification data address, obtain a modification script template corresponding to the modification operation type, and generate a target modification script corresponding to the data to be modified according to the modification data address, the modification operation type, the modified data, and the modification script template; The script scheduling information associated with the target script name is determined from a preset script scheduling association table, and after the target modification script is successfully run in the database based on the script scheduling information, the modification processing operation of the data to be modified is confirmed to be completed.

2. The data modification processing method according to claim 1, wherein: Before obtaining the data modification request, the following steps are included: Regularly check whether there is a configuration modification field in the preset script configuration list; When there is a configuration modification field in the preset script configuration list, the script name corresponding to the configuration modification field is determined as the target script name, and a data modification request is generated according to the target script name.

3. The data modification processing method according to claim 1, wherein: The process of performing a field search on a preset script configuration list according to the target script name to obtain a modified data address, a modification operation type, and modified data corresponding to the target script name includes: Determine the sub-database name, data table name, and data grid position corresponding to the target script name according to the data address field in the preset script configuration list, and obtain the modified data address according to the sub-database name, data table name, and data grid position; Determine the modification operation type corresponding to the target script name according to the operation type field in the preset script configuration list; According to the data fields in the preset script configuration list, the modified data corresponding to the target script name is determined.

4. The data modification processing method according to claim 1, wherein: Before determining the script scheduling information associated with the target script name from the preset script scheduling association table, the method includes: Obtaining scheduling association configuration information, and determining script sorting information and scheduling time information corresponding to each script name according to the scheduling association configuration information; Generate a script scheduling associated data group corresponding to the script name according to the script sorting information and scheduling time information corresponding to the same script name; The preset script scheduling association table is generated according to all the script scheduling association data groups.

5. The data modification processing method according to claim 1, wherein: After the target modification script is successfully executed in the database based on the script scheduling information, the method further includes: Obtaining the script execution result of the target modification script; When the script execution result is a data modification exception, generating a target rollback script corresponding to the modified data according to the modified data address, modification operation type and modified data corresponding to the target script name; The target rollback script is successfully run in the database based on the script scheduling information associated with the target script name, thereby completing the data rollback processing operation of the modified data in the database.

6. The data modification processing method according to claim 5, characterized in that: The step of generating a target rollback script corresponding to the modified data according to the modified data address, modification operation type, and modified data corresponding to the target script name includes: Determine a rollback data address according to the modified data address corresponding to the target script name, determine the modification operation type as a rollback operation type, and determine backup data according to the modified data corresponding to the target script name; A rollback script template corresponding to the rollback operation type is obtained, and a target rollback script is generated according to the rollback data address, the rollback operation type, the backup data, and the rollback script template.

7. The data modification processing method according to claim 5, characterized in that: Before generating a target rollback script corresponding to the modified data according to the modified data address, modification operation type, and modified data corresponding to the target script name, the method includes: Update the operation type field corresponding to the target script name in the preset script configuration list to a rollback operation type; The data field corresponding to the target script name in the preset script configuration list is updated with the backup data of the data to be modified.

8. A data modification processing device, characterized in that: include: A script name determination module is used to obtain a data modification request and determine a target script name according to the data modification request; A field search processing module is used to perform field search processing on the preset script configuration list according to the target script name to obtain the modified data address, modification operation type and modified data corresponding to the target script name; a modification script generation module, configured to determine the data to be modified in the database according to the modification data address, obtain a modification script template corresponding to the modification operation type, and generate a target modification script corresponding to the data to be modified according to the modification data address, the modification operation type, the modified data, and the modification script template; The modification script running module is used to determine the script scheduling information associated with the target script name from the preset script scheduling association table, and confirm the completion of the modification processing operation of the data to be modified after the target modification script is successfully run in the database based on the script scheduling information.

9. A computer device comprising a memory, a processor, and computer-readable instructions stored in the memory and executable on the processor, wherein: When the processor executes the computer-readable instructions, the data modification processing method according to any one of claims 1 to 7 is implemented.

10. A computer-readable storage medium storing computer-readable instructions, characterized in that: When the computer-readable instructions are executed by one or more processors, the one or more processors are caused to perform the data modification processing method according to any one of claims 1 to 7.

Images