CN110941630A - Database operation and maintenance method, device and system - Google Patents

Database operation and maintenance method, device and system Download PDF

Info

Publication number
CN110941630A
CN110941630A CN201911024783.6A CN201911024783A CN110941630A CN 110941630 A CN110941630 A CN 110941630A CN 201911024783 A CN201911024783 A CN 201911024783A CN 110941630 A CN110941630 A CN 110941630A
Authority
CN
China
Prior art keywords
sql script
result
auditing
server
request
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN201911024783.6A
Other languages
Chinese (zh)
Inventor
王振兴
刘伟
黄非凡
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Taikang Insurance Group Co Ltd
Original Assignee
Taikang Insurance Group Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Taikang Insurance Group Co Ltd filed Critical Taikang Insurance Group Co Ltd
Priority to CN201911024783.6A priority Critical patent/CN110941630A/en
Publication of CN110941630A publication Critical patent/CN110941630A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/242—Query formulation
    • G06F16/2433—Query languages
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00—Arrangements for software engineering
    • G06F8/30—Creation or generation of source code
    • G06F8/31—Programming languages or programming paradigms

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • Software Systems (AREA)
  • General Physics & Mathematics (AREA)
  • Mathematical Physics (AREA)
  • Computational Linguistics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Computing Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The embodiment of the invention provides a database operation and maintenance method, device and system, which are used for solving the technical problems of low database operation and maintenance efficiency and high cost in the prior art. The method comprises the following steps: responding to a first request sent by a request end, and returning a first data modification template to the request end; receiving a second data modification template sent by the request end, wherein the second data modification template is obtained after the request end fills modification parameters into the first data modification template; generating a target Structured Query Language (SQL) script based on the second data modification template; and sending the target SQL script to an auditing end.

Description

Database operation and maintenance method, device and system
Technical Field
The present application relates to the field of computers, and in particular, to a database operation and maintenance method, apparatus, and system.
Background
At present, in terms of operation and maintenance databases, Structured Query Language (SQL) scripts are often written and checked manually. The specific scheme is as follows: outsourcing personnel compile SQL scripts for modifying the production database when processing daily operation and maintenance work orders, and in the process, scripts with different formats and different naming principles are compiled respectively according to different modification contents of the operation and maintenance work orders. And then submitting the SQL script for modifying the production database to a staff member for manual examination. And (4) the approved SQL script needs to be executed in a production database by the internal staff in a manual mode, and the execution result is returned to the outsourcing staff for confirmation. And if the outsourcing personnel determine that the execution result of the SQL script is normal, the work order is ended, and if the execution result is abnormal, the outsourcing personnel manually write the database rollback script again, perform rollback operation on the database and restore the data modified by the database block.
In the scheme in the prior art, due to the fact that levels and capabilities of outsourcing personnel are different, submitted script formats and naming rules are various, and an error SQL script is often generated, the outsourcing personnel are required to repeatedly modify, the workload of the outsourcing personnel is increased, meanwhile, the auditing links of the auditing personnel are more, and the labor cost is higher. Therefore, the database operation and maintenance method in the prior art has the technical problems of multiple manual operation links, low operation and maintenance efficiency and high cost.
Disclosure of Invention
The embodiment of the invention provides a database operation and maintenance method, device and system, which are used for solving the technical problems of low database operation and maintenance efficiency and high cost in the prior art.
In a first aspect, an embodiment of the present invention provides a database operation and maintenance method, which is applied to a server, where a database is stored in the server, and the method includes:
responding to a first request sent by a request end, and returning a first data modification template to the request end;
receiving a second data modification template sent by the request end, wherein the second data modification template is obtained after the request end fills modification parameters into the first data modification template;
generating a target Structured Query Language (SQL) script based on the second data modification template;
and sending the target SQL script to an auditing end.
In the embodiment of the invention, outsourcing personnel only need to fill the modification parameters in the first data modification template, and then send the first data modification template (namely the second data modification template) filled with the parameters to the server, so that the server can generate the corresponding target SQL script according to the second data modification template and the SQL script template and send the SQL script to the auditing end for auditing. In the scheme, the target SQL script is generated according to the second data modification template and the SQL script template, and is not written by outsourcing personnel, so that the manual participation amount is small, the error amount of the script can be reduced to a large extent, the workload of auditing personnel at an auditing end is further reduced, the operation and maintenance efficiency of the database is improved, the technical requirements of the outsourcing personnel are also reduced, more personnel can operate and maintain the database, and the user experience is improved.
Optionally, generating the target SQL script based on the second data modification template includes: determining a first SQL script template matched with the second data modification template from at least one SQL script template stored by the server; and filling the modification parameters in the second data modification template into the first SQL script template to obtain a target SQL script.
By the method, the target SQL script with high accuracy can be quickly obtained.
Optionally, before sending the target SQL script to the auditing end, the method further includes: auditing the target SQL script according to a preset auditing rule to obtain a first auditing result; wherein the audit rule comprises at least one of a grammar rule, an authority rule, a business rule and a logic rule.
By the method, before the target SQL script is sent to the auditing end, the server end automatically audits the target SQL script for grammar rules, permission rules, business rules or logic rules and the like, so that the auditing end can obtain the more accurate target SQL script, the workload of auditors is further reduced, and the operation and maintenance efficiency is improved.
Optionally, after obtaining the first review result, the method further includes: if the first audit result is that the audit is not passed, sending the target SQL script, the first audit result and the reason that the first audit result is that the audit is not passed to the request end so as to modify the target SQL script by the request end; and if the first auditing result is that the auditing is passed, sending the target SQL script to an auditing end.
By the method, when the server side does not check the target SQL script, the request side can modify the target SQL script, so that the target SQL script can be modified manually under the condition that the target SQL script is wrong, and the user experience is further improved.
Optionally, after sending the target SQL script to the auditing end, the method includes: receiving a second auditing result fed back by the auditing end; if the second audit result is that the audit is passed, operating the target SQL script to modify the data of the database based on the modification parameters; and if the second audit result is that the audit is not passed, sending the target SQL script, the second audit result and the reason that the second audit result is that the audit is not passed to the request end so as to modify the target SQL script by the request end.
By the method, data modification can be performed on the database, and the target SQL script can be modified by the request end when the target SQL script is not checked by the checking end, so that the target SQL script can be modified manually under the condition that the target SQL script is wrong, and user experience is further improved.
Optionally, before the running the target SQL script, the method further includes: and backing up the data to be modified in the database. By the method, the data to be modified in the database can be backed up, so that the modification of the database data is reversible, and the security of the database data is improved. Optionally, after the target SQL script is executed, the method further includes: and sending the operation result to the request end so that the request end confirms the operation result.
By the method, the request end can acquire the operation result and confirm the operation result, so that the accuracy of the operation result is further ensured.
Optionally, after sending the operation result to the request end, the method further includes: receiving a rollback request sent by an auditing end; the rollback request is sent to the server side by the auditing side after receiving the rollback application sent by the sending side, and the rollback application is initiated when the request side confirms that the operation result is abnormal after receiving the operation result; and responding to the rollback request, and restoring the data in the database to the state before modification.
By the method, the data in the database can be restored before modification, so that the safety of the database data is further improved, and the user experience is improved.
In a second aspect, an embodiment of the present invention provides a database operation and maintenance method, applied to a request end, including: receiving an operation and maintenance work order, and sending a first request to a server according to the content of the operation and maintenance work order; wherein the operation and maintenance work order carries modification parameters; receiving a first data modification template from the server, and filling the modification parameters into the first data modification template to obtain a second data modification template; and sending the second data modification template to the server.
Optionally, after sending the second data modification template to the server, the method further includes: receiving a target SQL script, a first auditing result and a reason that the first auditing result is not passed from the server; and modifying the target SQL script based on the reason that the first auditing result is not passed.
Optionally, after sending the second data modification template to the server, the method further includes: receiving the reason why the target SQL script, the second auditing result and the second auditing result returned by the auditing end fail; and modifying the target SQL script based on the reason that the second auditing result is not passed.
Optionally, after sending the second data modification template to the server, the method includes: receiving a running result from the server; and initiating a rollback application to the auditing end when the operating result is confirmed to be abnormal.
In a third aspect, an embodiment of the present invention provides a database operation and maintenance method, applied to an audit end, including: receiving a target SQL script sent by a server, wherein the target SQL script is generated by the server based on a second data modification template, and the second data modification template carries modification parameters; and auditing the target SQL script to obtain a second auditing result.
Optionally, after the target SQL script is checked, the method includes: if the second audit result is that the audit is passed, sending an operation instruction to the server so that the server responds to the operation instruction to operate the target SQL script; otherwise, returning the target SQL script, the second examination result and the reason that the second examination result is failed to the request end so that the request end modifies the target SQL script.
Optionally, after sending the second review result to the server, the method includes: receiving a rollback application from the request terminal, and auditing the rollback request to obtain a third auditing result; if the third audit result is that the audit is passed, sending a rollback request to the server, so that the server responds to the rollback request and restores the data in the database to the state before modification; otherwise, returning the third audit result and the reason that the third audit result is not passed to the request end.
In a fourth aspect, an embodiment of the present invention further provides a server, including: the communication module is used for responding to a first request sent by a request end and returning a first data modification template to the request end; receiving a second data modification template sent by the request end, wherein the second data modification template is obtained after the request end fills modification parameters into the first data modification template; the processing module is used for generating a target Structured Query Language (SQL) script based on the second data modification template; and the communication module is also used for sending the target SQL script to an auditing end.
Optionally, the processing module is specifically configured to: determining a first SQL script template matched with the second data modification template from at least one SQL script template stored by the server; and filling the modification parameters in the second data modification template into the first SQL script template to obtain a target SQL script.
Optionally, the processing module is further configured to: before the communication module sends the target SQL script to an auditing end, auditing the target SQL script according to a preset auditing rule to obtain a first auditing result; wherein the audit rule comprises at least one of a grammar rule, an authority rule, a business rule and a logic rule.
Optionally, the communication module is further configured to: when the first audit result is that the audit is not passed, sending the target SQL script, the first audit result and the reason that the first audit result is that the audit is not passed to the request end so as to modify the target SQL script by the request end; and when the first auditing result is that the auditing is passed, sending the target SQL script to an auditing end.
Optionally, the communication module is further configured to: after the target SQL script is sent to an auditing end, receiving a second auditing result fed back by the auditing end; the processing module is further configured to: when the second auditing result is that the auditing is passed, the target SQL script is operated to modify the data of the database based on the modification parameters; the communication module is further configured to: and if the second audit result is that the audit is not passed, sending the target SQL script, the second audit result and the reason that the second audit result is that the audit is not passed to the request end so as to modify the target SQL script by the request end.
Optionally, the processing module is further configured to: and backing up the data to be modified in the database before the target SQL script is operated.
Optionally, the communication module is further configured to: and after the processing unit runs the target SQL script, sending a running result to the request end so that the request end confirms the running result.
Optionally, the communication module is further configured to: after the operation result is sent to the request end, a rollback request sent by the auditing end is received; the rollback request is sent to the server side by the auditing side after receiving the rollback application sent by the sending side, and the rollback application is initiated when the request side confirms that the operation result is abnormal after receiving the operation result; and the processing module is also used for responding to the rollback request and restoring the data in the database to the state before modification.
In a fifth aspect, an embodiment of the present invention further provides a request end, including: the communication module is used for receiving the operation and maintenance work order; the processing module is used for generating a first request according to the content of the operation and maintenance work order; wherein the operation and maintenance work order carries modification parameters; the communication module is further used for sending a first request to the server; receiving a first data modification template from the server; the processing module is further configured to fill the modification parameters in the first data modification template to obtain a second data modification template; the communication module is further configured to send the second data modification template to the server.
Optionally, the communication module is further configured to: after the second data modification template is sent to the server, receiving a target SQL script, a first auditing result and a reason why the first auditing result is not passed from the server; the processing module is further configured to modify the target SQL script based on the first audit result as a reason that the audit is not passed.
Optionally, the communication module is further configured to: after the second data modification template is sent to the server, the reasons that the target SQL script, the second auditing result and the second auditing result which are returned by the auditing end do not pass are received; the processing module is further configured to modify the target SQL script based on the second audit result as a reason that the audit is not passed.
Optionally, the communication module is further configured to: after the second data modification template is sent to the server, receiving an operation result from the server; and initiating a rollback application to the auditing end when the operating result is confirmed to be abnormal.
In a sixth aspect, an embodiment of the present invention further provides an audit end, including: the system comprises a communication module, a service end and a database module, wherein the communication module is used for receiving a target SQL script sent by the service end, the target SQL script is generated by the service end based on a second data modification template, and the second data modification template carries modification parameters; and the processing module is used for auditing the target SQL script to obtain a second auditing result.
Optionally, the communication module is further configured to: after the processing module audits the target SQL script, if the second audit result is that the audit is passed, sending an operation instruction to the server, so that the server responds to the operation instruction to operate the target SQL script; otherwise, returning the target SQL script, the second examination result and the reason that the second examination result is failed to the request end so that the request end modifies the target SQL script.
Optionally, the processing module is further configured to: after the communication module receives the rollback application from the request end, the rollback request is checked to obtain a third checking result; the communication module is further configured to: if the third audit result is that the audit is passed, sending a rollback request to the server, so that the server responds to the rollback request and restores the data in the database to the state before modification; otherwise, returning the third audit result and the reason that the third audit result is not passed to the request end.
In a seventh aspect, an embodiment of the present invention further provides a database operation and maintenance system, including: a server according to the first aspect of the embodiment of the present invention, a request according to the second aspect of the embodiment of the present invention, and an audit according to the third aspect of the embodiment of the present invention.
In an eighth aspect, an embodiment of the present invention provides an electronic device, including: the system comprises at least one processor, a memory and a communication interface, wherein the memory and the communication interface are in communication connection with the at least one processor; wherein the memory stores instructions executable by the at least one processor, and the at least one processor is configured to execute the instructions in the memory to perform the method according to any of the alternative embodiments of the first, second or third aspect of the embodiments of the present invention when the instructions are executed.
In a ninth aspect, embodiments of the present invention provide a computer-readable storage medium, which stores computer instructions that, when executed on a computer, cause the computer to perform the method according to any one of the optional implementation manners of the first, second or third aspect of the embodiments of the present invention.
The beneficial effects brought by the embodiments in the second aspect to the ninth aspect may be referred to the beneficial effects brought by the corresponding embodiments in the first aspect, and are not described in detail again.
The invention has the following beneficial effects:
in the embodiment of the invention, outsourcing personnel only need to fill the modification parameters in the first data modification template, and then send the first data modification template (namely the second data modification template) filled with the parameters to the server, so that the server can generate the corresponding target SQL script according to the second data modification template and the SQL script template and send the SQL script to the auditing end for auditing. In the scheme, the target SQL script is generated according to the second data modification template and the SQL script template, and is not written by outsourcing personnel, so that the manual participation amount is small, the error amount of the script can be reduced to a large extent, the workload of auditing personnel at an auditing end is further reduced, the operation and maintenance efficiency of the database is improved, the technical requirements of the outsourcing personnel are also reduced, more personnel can operate and maintain the database, and the user experience is improved.
Drawings
Fig. 1 is a schematic structural diagram of a database operation and maintenance system according to an embodiment of the present invention;
FIG. 2 is a schematic flow chart illustrating a database operation and maintenance method according to an embodiment of the present invention;
FIG. 3 is a schematic diagram illustrating a flow of auditing a target SQL script by a server in the embodiment of the present invention;
FIG. 4 is a schematic diagram illustrating a process of auditing a target SQL script by an auditing end in the embodiment of the present invention;
FIG. 5 is a flowchart illustrating a process of executing a target SQL script by a server according to an embodiment of the present invention;
FIG. 6 is a flowchart illustrating a rollback operation performed in an embodiment of the present invention;
fig. 7 is a schematic structural diagram of a server according to an embodiment of the present invention;
FIG. 8 is a diagram illustrating a structure of a requester according to an embodiment of the present invention;
fig. 9 is a schematic structural diagram of an auditing end according to an embodiment of the present invention;
fig. 10 is a schematic structural diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
The embodiment of the invention provides a database operation and maintenance method, device and system, which are used for solving the technical problems of low operation and maintenance efficiency and high cost of a database in the prior art.
The technical solutions of the present invention are described in detail below with reference to the drawings and the specific embodiments, and it should be understood that the specific features in the embodiments and the embodiments of the present invention are not intended to limit the technical solutions of the present invention, but may be combined with each other without conflict.
It is to be understood that the terms first, second, and the like in the description of the embodiments of the invention are used for distinguishing between the descriptions and not necessarily for describing a sequential or chronological order. "plurality" in the description of the embodiments of the present invention means two or more.
The term "and/or" in the embodiment of the present invention is only one kind of association relationship describing an associated object, and indicates that three relationships may exist, for example, a and/or B may indicate: a exists alone, A and B exist simultaneously, and B exists alone. In addition, the character "/" herein generally indicates that the former and latter related objects are in an "or" relationship.
Fig. 1 is a schematic structural diagram of a database operation and maintenance system according to an embodiment of the present invention. Referring to fig. 1, the system may include a requesting side, an auditing side, and a serving side.
The request end may be an electronic device of the outsourcing personnel, for example, the electronic device may be any electronic device with computing capability, such as a mobile phone, a tablet computer, a notebook computer, a server, a wearable device, an audio/video playing device, or an electronic device system composed of a plurality of such electronic devices, which is not limited in the embodiment of the present invention. In the embodiment of the invention, the request end can interact with the auditing end and the server end, and can respond to an operation instruction input by outsourcing personnel, such as receiving an operation of filling in a modification parameter in the first data modification template by the outsourcing personnel, an operation of modifying an SQL script, and the like. The specific embodiments will be described later.
The audit end may be an electronic device of an auditor, and the electronic device may be any electronic device with computing capability, such as a mobile phone, a tablet computer, a notebook computer, a server, a wearable device, an audio/video playing device, or an electronic device system composed of a plurality of such electronic devices, which is not limited in the embodiments of the present invention. In the embodiment of the invention, the auditing end can be used for auditing the SQL script, executing the SQL script run by the server end, auditing the rollback application of the request end, initiating the rollback request and the like. The specific embodiments will be described later.
The server may be an electronic device storing at least one database, and the server may be any electronic device with computing capability, such as a tablet computer, a notebook computer, a server, a wearable device, an audio/video playing device, or an electronic device system composed of a plurality of such electronic devices, which is not limited in the embodiments of the present invention. The server is provided with at least one database, and the database contains information data of different insurance policies. In the embodiment of the present invention, the server may receive the request of the request end and the request of the audit end, and execute corresponding operations in response to the requests, and a specific scheme will be described later.
Referring to fig. 2, a schematic flow chart of a database operation and maintenance method according to an embodiment of the present invention is shown, where the method includes:
s201, a request end receives an operation and maintenance work order and generates a first request according to the content of the operation and maintenance work order.
Specifically, the request end receives the operation and maintenance work order, wherein the operation and maintenance work order may include a work order number, a type of a service to be modified, a modification parameter, and the like. The request end generates a first request according to the service type and/or the modification parameter, wherein the first request is a request and a first data modification template corresponding to the modification parameter, and the type of the service to be modified and/or the modification parameter are carried in the first request.
Illustratively, if an outsourcing person in charge of a certain business system receives an operation and maintenance work order application for data modification, and needs to modify a final refund sum in a case with a case number of 00T018122038255 of the business system, the outsourcing person may select a required data modification template through an operation page provided by a configuration management tool running on a request end (for example, input the case number of 00T018122038255 in the configuration management tool); after receiving a selection instruction input by outsourcing personnel, the configuration management tool of the request end sends a first request to the server end to request a data modification template (namely, a first data modification template) corresponding to the business modification. The configuration management tool may be an application package running on the request end, and is mainly used for providing services related to database operation and maintenance. The first request can be used to indicate the type of service to be modified by carrying the case number "00T 018122038255".
S202, the request end sends a first request to the server end.
S203, the server side responds to the first request sent by the request side and returns the first data modification template to the request side.
Specifically, the server receives the first request, matches the first data modification template according to the type modification parameter of the service to be modified carried in the first request, and then returns the first data modification template to the request.
S204, the request end receives the first data modification template, fills the first data modification template based on the modification parameters, and obtains a second data modification template.
Specifically, the request end receives a first data modification template returned by the server end, and the second data modification template is obtained after the modification parameters are filled in the first data modification template. When the modification parameters are filled into the first data modification template, the modification parameters can be manually filled into the first data modification template, or the modification parameters can be read from the work order by the request terminal and automatically filled into the first data modification template.
Illustratively, after receiving the first data modification template, the configuration management tool at the request end displays a modification page corresponding to the first data modification template. Through the steps S201 to S204, the outsourcing personnel only need to input the case number "00T 018122038255" on the configuration management tool page, and click "query", and then the configuration management tool automatically acquires the first data modification template and displays the acquired first data modification template.
Then, the outsourcing personnel can input the data (i.e. the modification parameters) to be modified into the relevant fields provided by the first data modification template according to the operation and maintenance work order requirements, that is, generate a second data modification template. Or the configuration management tool automatically inputs the data to be modified (namely, the modification parameters) into the relevant fields provided by the first data modification template according to the operation and maintenance work order requirement.
Of course, in the embodiment of the present invention, the request end may also store at least one data modification template locally in advance, after receiving the operation and maintenance work order, first match whether there is a first data modification template matching the operation and maintenance work order from the at least one data modification template locally stored, if yes, the first data modification template may be directly obtained from the local without initiating the first request, and if there is no first data modification template in the at least one data modification template locally stored, the first request is initiated to the server end, so as to obtain the first data modification template from the server end.
S205, the request end sends the second data modification template to the server end.
Specifically, after the outsourcing personnel finish filling in the data to be modified, the outsourcing personnel click the 'generation data modification script' on the page, and trigger the configuration management tool of the request end to send the second data modification template to the server end.
S206, the server receives the second data modification template and generates a target SQL script based on the second data modification template.
Specifically, the server locally stores at least one SQL script template, different SQL script templates correspond to different data modification templates, after receiving the second data modification template, the server determines a first SQL script template matched with the second data modification template from the at least one SQL script template stored in the server, and then introduces modification parameters in the second data modification template into the first SQL script template, so as to generate the target SQL script.
And S207, the server side sends the target SQL script to the auditing side.
Through the above steps S205 to S207, outsourcing personnel only need to fill the data to be modified into the page corresponding to the first data modification template, and then click the "generated data modification script", so as to generate the data modification script (i.e. the target SQL script). Certainly, in specific implementation, the request end may locally store at least one SQL script template, and the request end may determine the first SQL script template from the at least one locally stored SQL script template based on the second data modification template without sending the second data modification template to the server end, generate the target SQL script, and finally send the target SQL script to the review end, or send the target SQL script to the server end, and send the target SQL script to the review end by the server end.
In the above scheme, outsourcing personnel only need to fill the modification parameters in the first data modification template, and then send the first data modification template (i.e. the second data modification template) filled with the parameters to the server, so that the server can generate a corresponding target SQL script according to the second data modification template and the SQL script template, and send the SQL script to the auditing terminal for auditing. In the scheme, the target SQL script is generated according to the second data modification template and the SQL script template, and is not written by outsourcing personnel, so that the manual participation amount is small, the error amount of the script can be reduced to a large extent, the workload of auditing personnel at an auditing end is further reduced, the operation and maintenance efficiency of the database is improved, the technical requirements of the outsourcing personnel are also reduced, more personnel can operate and maintain the database, and the user experience is improved.
Optionally, referring to fig. 3, before the server sends the target SQL script to the auditing end, the method may further include:
and S208, the server side checks the target SQL script according to preset checking rules.
Specifically, the server checks the generated target SQL script according to a preset checking rule to obtain a first checking result. The preset audit rule may include a syntax rule, an authority rule, a business rule, or a logic rule, and the embodiment of the present invention is not limited here.
Illustratively, the server may check the validity of the syntax rule of the target SQL script, for example, the delete/update statement in the current modified amount script must contain a where condition; the server side can also audit the target SQL script according to the permission setting rule, for example, only the operation of increasing or decreasing the business information table data and the characteristic table data is allowed, but the operation of changing the business information table data and the characteristic table data cannot be performed; the server side can also check the target SQL script according to the business check rule, for example, the final refund sum of the case modified this time should be the sum of the refund sum of the related insurance policy, and the adjustment sum should also be the sum of the adjustment sum of the related insurance policy.
If the first review result is that the review passes, please continue to refer to fig. 3, the above step S207 is executed: and the server sends the target SQL script to the auditing terminal, and the auditing terminal is enabled to audit the target SQL script.
If the first audit result is that the audit is not passed, please continue to refer to fig. 3, step S209 is executed: and the server side sends the target SQL script, the first auditing result and the reason that the first auditing result is not passed to the request side. In this way, the request end can modify the target SQL script based on the reason that the first audit result is not passed.
In the embodiment, before the server sends the target SQL script to the auditing terminal, the server automatically audits the target SQL script for syntax rules, permission rules, business rules or logic rules, and the like, so that the auditing terminal can obtain a more accurate target SQL script, the workload of auditors is further reduced, and the operation and maintenance efficiency is improved.
Optionally, referring to fig. 4, after the auditing end receives the target SQL script, the method may further include:
s401, the auditing end receives the target SQL script sent by the server end, and audits the target SQL script to generate a second auditing result.
Specifically, the auditor checks the target SQL script and determines that the data modified by the target SQL script is the type of the service to be modified and/or the modification parameter corresponding to the operation and maintenance work order.
Illustratively, the auditor performs service audit on the target SQL script, for example, if the content of the operation and maintenance work order is the information of the insured person with the modified case number "00T 018122038255", but the target SQL script is the total amount of the modified guarantee order, and the modified objects are inconsistent, the audit is not passed, or if the content of the operation and maintenance work order is the amount of the modified case number "00T 018122038255", but the amount of the modified amount of the target SQL script is different from the amount of the content of the operation and maintenance work order, the audit is not passed.
If the second review result is that the review is passed, please continue to refer to fig. 4, then step S402 is executed: and the auditing end sends a second auditing result or an operating instruction to the server end to indicate the server end to operate the target SQL script, so that the server end can modify the data of the database based on the modification parameters.
If the second audit result is that the audit is not passed, please continue to refer to fig. 4, step S403 is executed: and the auditing end returns the target SQL script, the second auditing result and the reason that the second auditing result is failed to the requesting end. Therefore, the request end can modify the target SQL script for the reason that the second audit is not passed based on the second audit result.
In the embodiment, the auditing end further audits the target SQL script, so that the reliability of the target SQL script is ensured, and the operation and maintenance efficiency is improved.
Optionally, referring to fig. 5, after the auditing end sends the second auditing result or the running instruction to the server end, the method further includes:
s501, after receiving a second auditing result or an operating instruction sent by the auditing end, the server end operates the target SQL script.
Specifically, the server may immediately run the target SQL script when it is determined that the second audit result is that the audit is passed or when an operation instruction is received, so as to modify the data of the database based on the modification parameter.
In a specific implementation, in consideration of the load of the server (operation and maintenance server) during the operation and maintenance peak, the server (operation and maintenance server) may also run the target SQL script after determining that the second review result is that the review passes for a certain period of time (for example, 30 minutes, an hour, and the like, or a specified time (for example, 0-3 points in the morning every day is the operation and maintenance server load trough). Thus, the load of the server in the operation and maintenance peak period can be reduced.
Optionally, before the server runs the target SQL, the server may also back up the data to be modified or all the data in the database, so that the security and the reversibility of the data to be modified or all the data in the database may be ensured.
And S502, after the server side obtains the operation result, the operation result is sent to the request side.
By the implementation mode, the modification of the database data by the server side can be realized, and the modification result is returned to the request side for confirmation, so that the operation and maintenance reliability is further improved, and the user experience is improved.
Optionally, in the embodiment of the present invention, when the receiving operation result of the request end is abnormal, a rollback application may also be initiated to the audit end. Referring to fig. 6, the method includes:
s601, the request end receives the operation result.
S602, verifying the operation result by the request end.
Specifically, after the request end receives the operation result sent by the server end, the outsourcing personnel of the request end may verify the operation result manually (for example, if the content of the operation and maintenance work order is the insured person information of the modification case number "00T 018122038255", it is verified whether the operation result is the modified insured person information, if the modification objects are consistent, the verification is considered to be passed, and if the modification objects are not consistent, the verification is considered to be not passed). Further, the request end may determine the verification result of the operation result according to an instruction input by the outsourcing staff, for example, after the request end receives an "verification pass" instruction input by the outsourcing staff, it is determined that the operation result is normal, and after the "verification fail" instruction input by the outsourcing staff is received, it is determined that the operation result is abnormal. Of course, in specific implementation, the request end may also automatically verify the operation result, and the embodiment of the present invention is not limited herein.
If the operation result is verified to be abnormal, please continue to refer to fig. 6, step S603 may be executed: and the request end initiates a rollback application to the auditing end.
And if the operation result is verified to be normal, finishing data modification and closing the operation and maintenance work order.
And S603, the request end initiates a rollback application to the audit end.
And S604, verifying the rollback application by the auditing end.
Specifically, the audit end audits the rollback request to obtain a third audit result. Illustratively, when the outsourcing personnel misjudge that the target SQL script is wrong and send the rollback application to the auditor, the auditor can reject the rollback application, or the reason for the rollback application of the outsourcing personnel is not good, the auditor can reject the rollback application.
Continuing to refer to fig. 6, if the third audit result is that the audit is passed, steps S605 and S606 are sequentially executed; if the third audit result is that the audit is not passed, step S607 is executed.
And S605, the auditing end initiates a rollback request to the server end.
And S606, the server responds to the rollback operation and runs a rollback script so as to restore the data in the database to the state before modification.
And S607, the auditing end returns the third auditing result and the reason that the third auditing result is not passed to the requesting end.
By the implementation mode, when the operation result received by the request end is abnormal, the server end can execute the rollback operation, so that the data in the original database can still be found under the condition that the execution result is wrong after the target SQL script is executed; in addition, before rollback, the server needs to check the rollback application by the check end, so that the problems of unstable database and large power consumption waste caused by frequent rollback of outsourcing personnel due to no reason can be solved. According to the embodiment, the database modification operation is searchable and reversible, and the reliability of operation and maintenance is further improved.
Optionally, when the step S203 is executed, if the server does not match the first data modification template corresponding to the modification parameter, the request end may be notified to manually write the target SQL script, and then the request end sends the manually written script to the auditing end, and then the step S207 or S208 is executed.
By the embodiment, when the server side does not match the first data modification template corresponding to the modification parameter, outsourcing personnel can still manually write the target SQL script, so that the user experience is improved; in addition, the manually written target SQL script can be audited by the server side and the auditing side, so that the accuracy of the target SQL script is improved, the workload of auditing personnel is reduced, and the operation and maintenance efficiency is improved.
Based on the same inventive concept, an embodiment of the present invention further provides a server 700, with reference to fig. 7, including:
a communication module 701, configured to respond to a first request sent by a request end, and return a first data modification template to the request end; receiving a second data modification template sent by the request end, wherein the second data modification template is obtained after the request end fills modification parameters into the first data modification template;
a processing module 702, configured to generate a target structured query language SQL script based on the second data modification template;
the communication module 701 is further configured to send the target SQL script to an auditing end.
Optionally, the processing module 702 is specifically configured to: determining a first SQL script template matched with the second data modification template from at least one SQL script template stored by the server; and filling the modification parameters in the second data modification template into the first SQL script template to obtain a target SQL script.
Optionally, the processing module 702 is further configured to: before the communication module 701 sends the target SQL script to an auditing end, auditing the target SQL script according to a preset auditing rule to obtain a first auditing result; wherein the audit rule comprises at least one of a grammar rule, an authority rule, a business rule and a logic rule.
Optionally, the communication module 701 is further configured to: when the first audit result is that the audit is not passed, sending the target SQL script, the first audit result and the reason that the first audit result is that the audit is not passed to the request end so as to modify the target SQL script by the request end; and when the first auditing result is that the auditing is passed, sending the target SQL script to an auditing end.
Optionally, the communication module 701 is further configured to: after the target SQL script is sent to an auditing end, receiving a second auditing result fed back by the auditing end; the processing module is further configured to: when the second auditing result is that the auditing is passed, the target SQL script is operated to modify the data of the database based on the modification parameters; the communication module is further configured to: and if the second audit result is that the audit is not passed, sending the target SQL script, the second audit result and the reason that the second audit result is that the audit is not passed to the request end so as to modify the target SQL script by the request end.
Optionally, the processing module 702 is further configured to: and backing up the data to be modified in the database before the target SQL script is operated.
Optionally, the communication module 701 is further configured to: after the processing module 702 runs the target SQL script, the running result is sent to the request end, so that the request end confirms the running result.
Optionally, the communication module 701 is further configured to: after the operation result is sent to the request end, a rollback request sent by the auditing end is received; the rollback request is sent to the server side by the auditing side after receiving the rollback application sent by the sending side, and the rollback application is initiated when the request side confirms that the operation result is abnormal after receiving the operation result; the processing module 702 is further configured to respond to the rollback request, and restore the data in the database to a state before modification.
Based on the same inventive concept, an embodiment of the present invention further provides a request end 800, referring to fig. 8, including:
the communication module 801 is used for receiving an operation and maintenance work order;
a processing module 802, configured to generate a first request according to the content of the operation and maintenance work order; wherein the operation and maintenance work order carries modification parameters;
the communication module 801 is further configured to send a first request to a server; receiving a first data modification template from the server;
the processing module 802 is further configured to fill the modification parameter in the first data modification template to obtain a second data modification template;
the communication module 801 is further configured to send the second data modification template to the server.
Optionally, the communication module 801 is further configured to: after the second data modification template is sent to the server, receiving a target SQL script, a first auditing result and a reason why the first auditing result is not passed from the server; the processing module 802 is further configured to modify the target SQL script based on the reason that the first audit result is not passed.
Optionally, the communication module 801 is further configured to: after the second data modification template is sent to the server, the reasons that the target SQL script, the second auditing result and the second auditing result which are returned by the auditing end do not pass are received; the processing module 802 is further configured to modify the target SQL script based on the second audit result as a reason that the audit is not passed.
Optionally, the communication module 801 is further configured to: after the second data modification template is sent to the server, receiving an operation result from the server; and initiating a rollback application to the auditing end when the operating result is confirmed to be abnormal.
Based on the same inventive concept, an embodiment of the present invention further provides an auditing end 900, with reference to fig. 9, including:
a communication module 901, configured to receive a target SQL script sent by a server, where the target SQL script is generated by the server based on a second data modification template, and the second data modification template carries modification parameters;
and the processing module 902 is configured to audit the target SQL script to obtain a second audit result.
Optionally, the communication module 901 is further configured to:
after the processing module 902 checks the target SQL script, if the second checking result is that the check is passed, sending an operation instruction to the server, so that the server responds to the operation instruction to operate the target SQL script; otherwise, returning the target SQL script, the second examination result and the reason that the second examination result is failed to the request end so that the request end modifies the target SQL script.
Optionally, the processing module 902 is further configured to: after the communication module 901 receives the rollback application from the request terminal, the rollback request is checked to obtain a third checking result; the communication module 901 is further configured to: if the third audit result is that the audit is passed, sending a rollback request to the server, so that the server responds to the rollback request and restores the data in the database to the state before modification; otherwise, returning the third audit result and the reason that the third audit result is not passed to the request end.
Based on the same inventive concept, an embodiment of the present invention further provides an electronic device, with reference to fig. 10, including: at least one processor 1001, and a memory 1002, a communication interface 1003 communicatively coupled to the at least one processor 1001; the memory 1002 stores instructions executable by the at least one processor 1001, and the at least one processor 1001 executes the instructions stored in the memory 1002 to cause the apparatus 1000 to perform the database operation and maintenance method according to the embodiment of the present invention.
Based on the same inventive concept, the embodiment of the present invention further provides a computer-readable storage medium, where the computer-readable storage medium stores computer instructions, and when the computer instructions are run on a computer, the computer is caused to execute the database operation and maintenance method according to the embodiment of the present invention.
As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to the application. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
It will be apparent to those skilled in the art that various changes and modifications may be made in the present application without departing from the spirit and scope of the application. Thus, if such modifications and variations of the present application fall within the scope of the claims of the present application and their equivalents, the present application is intended to include such modifications and variations as well.

Claims (19)

1. A database operation and maintenance method is applied to a server, wherein the server stores a database, and the method comprises the following steps:
responding to a first request sent by a request end, and returning a first data modification template to the request end;
receiving a second data modification template sent by the request end, wherein the second data modification template is obtained after the request end fills modification parameters into the first data modification template;
generating a target Structured Query Language (SQL) script based on the second data modification template;
and sending the target SQL script to an auditing end.
2. The method of claim 1, wherein generating a target SQL script based on the second data modification template comprises:
determining a first SQL script template matched with the second data modification template from at least one SQL script template stored by the server;
and filling the modification parameters in the second data modification template into the first SQL script template to obtain a target SQL script.
3. The method of claim 1, before sending the target SQL script to a reviewing end, further comprising:
auditing the target SQL script according to a preset auditing rule to obtain a first auditing result; wherein the audit rule comprises at least one of a grammar rule, an authority rule, a business rule and a logic rule.
4. The method of claim 3, wherein after obtaining the first review result, further comprising:
if the first audit result is that the audit is not passed, sending the target SQL script, the first audit result and the reason that the first audit result is that the audit is not passed to the request end so as to modify the target SQL script by the request end;
and if the first auditing result is that the auditing is passed, sending the target SQL script to an auditing end.
5. The method according to any one of claims 1-4, wherein after sending the target SQL script to a reviewing end, comprising:
receiving a second auditing result fed back by the auditing end;
if the second audit result is that the audit is passed, operating the target SQL script to modify the data of the database based on the modification parameters;
and if the second audit result is that the audit is not passed, sending the target SQL script, the second audit result and the reason that the second audit result is that the audit is not passed to the request end so as to modify the target SQL script by the request end.
6. The method of claim 5, after running the target SQL script, further comprising:
and sending the operation result to the request end so that the request end confirms the operation result.
7. The method of claim 6, after sending the run result to the requestor, further comprising:
receiving a rollback request sent by an auditing end; the rollback request is sent to the server side by the auditing side after receiving the rollback application sent by the sending side, and the rollback application is initiated when the request side confirms that the operation result is abnormal after receiving the operation result;
and responding to the rollback request, and restoring the data in the database to the state before modification.
8. A database operation and maintenance method is applied to a request end, and comprises the following steps:
receiving an operation and maintenance work order, and sending a first request to a server according to the content of the operation and maintenance work order; wherein the operation and maintenance work order carries modification parameters;
receiving a first data modification template from the server, and filling the modification parameters into the first data modification template to obtain a second data modification template;
and sending the second data modification template to the server.
9. The method of claim 8, wherein after sending the second data modification template to the server, further comprising:
receiving a target SQL script, a first auditing result and a reason that the first auditing result is not passed from the server;
and modifying the target SQL script based on the reason that the first auditing result is not passed.
10. The method of claim 8, wherein after sending the second data modification template to the server, further comprising:
receiving the reason why the target SQL script, the second auditing result and the second auditing result returned by the auditing end fail;
and modifying the target SQL script based on the reason that the second auditing result is not passed.
11. The method of claim 8, after sending the second data modification template to the server, comprising:
receiving a running result from the server;
and initiating a rollback application to the auditing end when the operating result is confirmed to be abnormal.
12. A database operation and maintenance method is applied to an auditing end, and comprises the following steps:
receiving a target SQL script sent by a server, wherein the target SQL script is generated by the server based on a second data modification template, and the second data modification template carries modification parameters;
and auditing the target SQL script to obtain a second auditing result.
13. The method of claim 12, after reviewing the target SQL script, comprising:
if the second audit result is that the audit is passed, sending an operation instruction to the server so that the server responds to the operation instruction to operate the target SQL script;
otherwise, returning the target SQL script, the second examination result and the reason that the second examination result is failed to the request end so that the request end modifies the target SQL script.
14. The method of claim 13, wherein after sending the second review result to the server, comprising:
receiving a rollback application from the request terminal, and auditing the rollback request to obtain a third auditing result;
if the third audit result is that the audit is passed, sending a rollback request to the server, so that the server responds to the rollback request and restores the data in the database to the state before modification;
otherwise, returning the third audit result and the reason that the third audit result is not passed to the request end.
15. A server, comprising:
the communication module is used for responding to a first request sent by a request end and returning a first data modification template to the request end; receiving a second data modification template sent by the request end, wherein the second data modification template is obtained after the request end fills modification parameters into the first data modification template;
the processing module is used for generating a target Structured Query Language (SQL) script based on the second data modification template;
and the communication module is also used for sending the target SQL script to an auditing end.
16. A requesting end, comprising:
the communication module is used for receiving the operation and maintenance work order;
the processing module is used for generating a first request according to the content of the operation and maintenance work order; wherein the operation and maintenance work order carries modification parameters;
the communication module is further used for sending a first request to the server; receiving a first data modification template from the server;
the processing module is further configured to fill the modification parameters in the first data modification template to obtain a second data modification template;
the communication module is further configured to send the second data modification template to the server.
17. An audit end, comprising:
the system comprises a communication module, a service end and a database module, wherein the communication module is used for receiving a target SQL script sent by the service end, the target SQL script is generated by the service end based on a second data modification template, and the second data modification template carries modification parameters;
and the processing module is used for auditing the target SQL script to obtain a second auditing result.
18. An electronic device, comprising:
at least one processor, and
a memory communicatively coupled to the at least one processor, a communication interface;
wherein the memory stores instructions executable by the at least one processor, the at least one processor being configured to execute the instructions in the memory to cause the apparatus to perform the method of any of claims 1-14 when the instructions are executed.
19. A computer-readable storage medium having stored thereon computer instructions which, when executed on a computer, cause the computer to perform the method of any one of claims 1-14.
CN201911024783.6A 2019-10-25 2019-10-25 Database operation and maintenance method, device and system Pending CN110941630A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201911024783.6A CN110941630A (en) 2019-10-25 2019-10-25 Database operation and maintenance method, device and system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201911024783.6A CN110941630A (en) 2019-10-25 2019-10-25 Database operation and maintenance method, device and system

Publications (1)

Publication Number Publication Date
CN110941630A true CN110941630A (en) 2020-03-31

Family

ID=69906203

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201911024783.6A Pending CN110941630A (en) 2019-10-25 2019-10-25 Database operation and maintenance method, device and system

Country Status (1)

Country Link
CN (1) CN110941630A (en)

Cited By (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111931955A (en) * 2020-07-22 2020-11-13 北京字节跳动网络技术有限公司 Information processing method and device and electronic equipment
CN112162994A (en) * 2020-09-08 2021-01-01 杭州涂鸦信息技术有限公司 SQL (structured query language) generation method and system for system entry data
CN112256672A (en) * 2020-10-22 2021-01-22 中国联合网络通信集团有限公司 Database change approval method and device
CN112464175A (en) * 2020-11-11 2021-03-09 中国建设银行股份有限公司 Script auditing and executing method, system, equipment and storage medium
CN112685077A (en) * 2020-12-29 2021-04-20 平安普惠企业管理有限公司 Data modification method, system, computer device and computer readable storage medium
CN112748909A (en) * 2021-01-22 2021-05-04 平安普惠企业管理有限公司 Data modification method, device, equipment and medium based on neural network model
CN112948181A (en) * 2021-03-22 2021-06-11 深圳闪回科技有限公司 Data modification backup recovery system
CN113190408A (en) * 2021-05-07 2021-07-30 北京金融资产交易所有限公司 Data operation and maintenance system
CN113190407A (en) * 2021-05-07 2021-07-30 北京金融资产交易所有限公司 Data operation and maintenance system
CN115150168A (en) * 2022-06-30 2022-10-04 北京天融信网络安全技术有限公司 Filling replacing method and device and electronic equipment

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20050120014A1 (en) * 2003-07-11 2005-06-02 Deffler Tad A. System and method for generating SQL using templates
CN104391995A (en) * 2014-12-15 2015-03-04 北京趣拿软件科技有限公司 SQL (Structured Query Language) statement auditing method, and database operation and maintenance method and system
CN107908631A (en) * 2017-07-25 2018-04-13 平安科技（深圳）有限公司 Data processing method, device, storage medium and computer equipment
CN109522324A (en) * 2018-11-02 2019-03-26 平安医疗健康管理股份有限公司 A kind of SQL scenario generation method, device and computer equipment
CN109783509A (en) * 2019-01-04 2019-05-21 中国银行股份有限公司 SQL scenario generation method and device

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20050120014A1 (en) * 2003-07-11 2005-06-02 Deffler Tad A. System and method for generating SQL using templates
CN104391995A (en) * 2014-12-15 2015-03-04 北京趣拿软件科技有限公司 SQL (Structured Query Language) statement auditing method, and database operation and maintenance method and system
CN107908631A (en) * 2017-07-25 2018-04-13 平安科技（深圳）有限公司 Data processing method, device, storage medium and computer equipment
CN109522324A (en) * 2018-11-02 2019-03-26 平安医疗健康管理股份有限公司 A kind of SQL scenario generation method, device and computer equipment
CN109783509A (en) * 2019-01-04 2019-05-21 中国银行股份有限公司 SQL scenario generation method and device

Cited By (14)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111931955A (en) * 2020-07-22 2020-11-13 北京字节跳动网络技术有限公司 Information processing method and device and electronic equipment
CN112162994A (en) * 2020-09-08 2021-01-01 杭州涂鸦信息技术有限公司 SQL (structured query language) generation method and system for system entry data
CN112256672B (en) * 2020-10-22 2023-05-30 中国联合网络通信集团有限公司 Database change approval method and device
CN112256672A (en) * 2020-10-22 2021-01-22 中国联合网络通信集团有限公司 Database change approval method and device
CN112464175A (en) * 2020-11-11 2021-03-09 中国建设银行股份有限公司 Script auditing and executing method, system, equipment and storage medium
CN112685077A (en) * 2020-12-29 2021-04-20 平安普惠企业管理有限公司 Data modification method, system, computer device and computer readable storage medium
CN112748909A (en) * 2021-01-22 2021-05-04 平安普惠企业管理有限公司 Data modification method, device, equipment and medium based on neural network model
CN112948181A (en) * 2021-03-22 2021-06-11 深圳闪回科技有限公司 Data modification backup recovery system
CN113190407A (en) * 2021-05-07 2021-07-30 北京金融资产交易所有限公司 Data operation and maintenance system
CN113190408A (en) * 2021-05-07 2021-07-30 北京金融资产交易所有限公司 Data operation and maintenance system
CN113190408B (en) * 2021-05-07 2024-03-26 北京金融资产交易所有限公司 Data operation and maintenance system
CN113190407B (en) * 2021-05-07 2024-06-07 北京金融资产交易所有限公司 Data operation and maintenance system
CN115150168A (en) * 2022-06-30 2022-10-04 北京天融信网络安全技术有限公司 Filling replacing method and device and electronic equipment
CN115150168B (en) * 2022-06-30 2023-12-01 北京天融信网络安全技术有限公司 Substitution filling method and electronic equipment

Similar Documents

Publication Publication Date Title
CN110941630A (en) Database operation and maintenance method, device and system
CN109791591B (en) Method and system for identity and credential protection and verification via blockchain
CN110782240B (en) Business data processing method and device, computer equipment and storage medium
US20190050855A1 (en) Blockchain-based systems, methods, and apparatus for securing access to information stores
CN110209650B (en) Data normalization and migration method and device, computer equipment and storage medium
CN110458562B (en) Bill reimbursement method, device and equipment and computer storage medium
WO2016141491A1 (en) Systems and methods for managing data
CN111091358B (en) Unified processing method and system for multiple payment channels
US9998450B2 (en) Automatically generating certification documents
WO2015195590A1 (en) Tenant provisioning for testing a production multi-tenant service
US20200387417A1 (en) Database optimized disaster recovery testing
CN113515549B (en) Financial data query method and device and readable storage medium
CN110309099A (en) Interface managerial method, device, equipment and computer readable storage medium
CN108460068A (en) Method, apparatus, storage medium and the terminal that report imports and exports
CN108255967B (en) Method and device for calling storage process, storage medium and terminal
US8463755B2 (en) System and method for providing collaborative master data processes
WO2019195482A9 (en) Database lock
CN112288400A (en) Multi-system data interaction method and device, computer equipment and storage medium
US10664653B2 (en) Automated structured cloud datatester
US20150310390A1 (en) Aggregation and workflow engines for managing project information
CN111522881B (en) Service data processing method, device, server and storage medium
CN117036062A (en) Accounting resource calculation method and device
US20230195792A1 (en) Database management methods and associated apparatus
CN112907220B (en) System, method and device for engineering cost
CN111221817B (en) Service information data storage method, device, computer equipment and storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication

Application publication date: 20200331

RJ01 Rejection of invention patent application after publication