Database Parameter Management Method, Apparatus, and Computer Device

Abstract

The present application relates to a method, device, and computer equipment for database parameter management in the field of artificial intelligence. The method includes: obtaining an item application request, where the item application request carries a database parameter file; generating a file to be maintained according to the database parameter file, and identifying whether the item application request meets the acceptance passing condition according to the file to be maintained; when the item application request meets the acceptance passing condition, creating a maintenance application form according to the file to be maintained; entering the database parameter data in the file to be maintained into the maintenance application form, and submitting the maintenance application form. Using this method can improve the efficiency of database parameter management.

Description

Technical Field

[0001] This application relates to the field of artificial intelligence technology, and particularly to a database parameter management method, apparatus, computer device, storage medium, and computer program product. Background Art

[0002] With the continuous development of banks and financial enterprises, banks have transformed from informatization construction to digital transformation. Under this background, the internal information systems of enterprises have become increasingly large, and database parameters have gradually become more complex.

[0003] The traditional method of database parameter management is to manage database parameters through manual maintenance.

[0004] However, the traditional method has a large number of simple and repetitive manual operation links, resulting in a large amount of time and manpower being spent on database parameter management, and the efficiency of database parameter management is relatively low. Summary of the Invention

[0005] Based on this, in view of the above technical problems, it is necessary to provide a database parameter management method, apparatus, computer device, computer-readable storage medium, and computer program product that can improve the efficiency of database parameter management.

[0006] In a first aspect, this application provides a database parameter management method. The method includes:

[0007] Obtain a matter application request, where the matter application request carries a database parameter file;

[0008] Generate a to-be-maintained file according to the database parameter file, and identify whether the matter application request meets the acceptance passing condition according to the to-be-maintained file;

[0009] When the matter application request meets the acceptance passing condition, create a maintenance application form according to the to-be-maintained file;

[0010] Enter the database parameter data in the to-be-maintained file into the maintenance application form, and submit the maintenance application form.

[0011] In one embodiment, generating a to-be-maintained file according to the database parameter file includes:

[0012] Identify whether the format of the database parameter file is a preset template;

[0013] If the format of the database parameter file is a preset template, identify whether the maintenance strategy corresponding to the database parameter file meets the preset condition;

[0014] When the maintenance strategy corresponding to the database parameter file meets the preset condition, perform error correction processing on the database parameter data in the database parameter file to generate a to-be-maintained file.

[0015] In one embodiment, the above method further includes:

[0016] Identifying whether the number of database parameter data in the database parameter file after error correction processing is greater than a preset number threshold;

[0017] When the number of database parameter data is greater than the preset number threshold, performing data segmentation on the database parameter data to obtain a to-be-maintained file including multiple parameter tables.

[0018] In one embodiment, identifying whether the matter application request meets the acceptance passing condition according to the to-be-maintained file includes:

[0019] Verifying the to-be-maintained file;

[0020] If the verification passes, the matter application request meets the acceptance passing condition.

[0021] In one embodiment, submitting a maintenance application form includes:

[0022] When the to-be-maintained file includes a single parameter table, determining that the maintenance strategy corresponding to the to-be-maintained file is an interface maintenance strategy;

[0023] Comparing the database parameter data already entered in the maintenance application form with the corresponding database parameter data in the single parameter table according to the interface maintenance strategy;

[0024] When the comparison is consistent, submitting the maintenance application form.

[0025] In one embodiment, submitting a maintenance application form includes:

[0026] When the to-be-maintained file includes multiple parameter tables, determining that the maintenance strategy corresponding to the to-be-maintained file is a text import strategy;

[0027] Submitting the maintenance application form in batches according to the text import strategy.

[0028] In one embodiment, before obtaining the matter application request, the above method further includes:

[0029] Obtaining database parameter management information;

[0030] Determining the database parameter management mode in multiple preset parameter management modes according to the database parameter management information.

[0031] In one embodiment, the above method further includes:

[0032] When maintenance exception information is obtained during the entry of database parameter data, temporarily storing the maintenance application form;

[0033] Send the maintenance exception information to the target terminal.

[0034] In one embodiment, after submitting the maintenance application form after maintenance, the above method further includes:

[0035] Generate a maintenance prompt message according to the submitted maintenance application form;

[0036] Send the maintenance prompt message to a pre-configured processing terminal so that the processing terminal performs the next-level maintenance on the submitted maintenance application form.

[0037] In a second aspect, the present application further provides a database parameter management device. The device includes:

[0038] An item application module, configured to obtain an item application request, where the item application request carries a database parameter file;

[0039] An item acceptance module, configured to generate a file to be maintained according to the database parameter file, and identify whether the item application request meets the acceptance passing condition according to the file to be maintained;

[0040] An application form creation module, configured to create a maintenance application form according to the file to be maintained when the item application request meets the acceptance passing condition;

[0041] A data maintenance module, configured to enter the database parameter data in the file to be maintained into the maintenance application form and submit the maintenance application form.

[0042] In a third aspect, the present application further provides a computer device. The computer device includes a memory and a processor. When the processor executes the computer program, the following steps are implemented:

[0043] Obtain an item application request, where the item application request carries a database parameter file;

[0044] Generate a file to be maintained according to the database parameter file, and identify whether the item application request meets the acceptance passing condition according to the file to be maintained;

[0045] When the item application request meets the acceptance passing condition, create a maintenance application form according to the file to be maintained;

[0046] Enter the database parameter data in the file to be maintained into the maintenance application form and submit the maintenance application form.

[0047] In a fourth aspect, the present application further provides a computer-readable storage medium. The computer-readable storage medium stores a computer program. When the computer program is executed by a processor, the following steps are implemented:

[0048] Obtain an item application request, where the item application request carries a database parameter file;

[0049] Generate a file to be maintained according to the database parameter file, and identify whether the item application request meets the acceptance passing condition according to the file to be maintained;

[0050] When the item application request meets the acceptance passing condition, create a maintenance application form according to the file to be maintained;

[0051] Enter the database parameter data in the file to be maintained into the maintenance application form, and submit the maintenance application form.

[0052] In a fifth aspect, the present application also provides a computer program product. The computer program product includes a computer program, and when the computer program is executed by a processor, the following steps are implemented:

[0053] Obtain an item application request, where the item application request carries a database parameter file;

[0054] Generate a file to be maintained according to the database parameter file, and identify whether the item application request meets the acceptance passing condition according to the file to be maintained;

[0055] When the item application request meets the acceptance passing condition, create a maintenance application form according to the file to be maintained;

[0056] Enter the database parameter data in the file to be maintained into the maintenance application form, and submit the maintenance application form.

[0057] For the above database parameter management method, device, computer device, storage medium, and computer program product, an item application request is obtained, and the item application request carries a database parameter file. Thus, a file to be maintained is generated according to the database parameter file, and it is identified whether the item application request meets the acceptance passing condition according to the file to be maintained. Furthermore, when the item application request meets the acceptance passing condition, a maintenance application form is created according to the file to be maintained, the database parameter data in the file to be maintained is entered into the maintenance application form, and the maintenance application form is submitted. It realizes automatic acceptance of item applications and automatic entry of database parameter data during the parameter management process, and can automate the processing of database parameters. It changes the manual maintenance mode in the traditional method, reduces the intervention of simple and repetitive manual links, thereby improving the management efficiency of database parameters, and at the same time avoiding the problem of a relatively high risk of manual misoperation. Description of the Drawings

[0058] Figure 1 It is an application environment diagram of the database parameter management method in an embodiment;

[0059] Figure 2Schematic flow chart of a database parameter management method in an embodiment;

[0060] Figure 3 Schematic flow chart of steps for generating a file to be maintained according to a database parameter file in an embodiment;

[0061] Figure 4 Schematic flow chart of a database parameter management method in another embodiment;

[0062] Figure 5 Block diagram of a database parameter management device in an embodiment;

[0063] Figure 6 Internal structure diagram of a computer device in an embodiment. Detailed implementation manners

[0064] In order to make the objectives, technical solutions and advantages of the present application clearer and more understandable, the present application will be further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0065] The database parameter management method provided by the embodiments of the present application can be applied to an application environment as Figure 1 shown. Among them, the terminal 102 communicates with the server 104 through a network. The server 104 can be a server loaded with an RPA (Robotic Process Automation) system. The data storage system can store the data that the server 104 needs to process. The data storage system can be integrated on the server 104, or placed in the cloud or other network servers. The terminal 102 sends a matter application request to the server 104, and the server 104 obtains the matter application request. The matter application request carries a database parameter file, and thus generates a file to be maintained according to the database parameter file, and identifies whether the matter application request meets the acceptance passing condition according to the file to be maintained. When the matter application request meets the acceptance passing condition, a maintenance application form is created according to the file to be maintained, and then the database parameter data in the file to be maintained is entered into the maintenance application form, and the maintenance application form is submitted. Among them, the terminal 102 can be but is not limited to various personal computers, laptop computers, smart phones, tablet computers, Internet of Things devices and portable wearable devices. The Internet of Things devices can be smart speakers, smart TVs, smart air conditioners, smart in-vehicle devices, etc. The portable wearable devices can be smart watches, smart bracelets, head-mounted devices, etc. The server 104 can be implemented by an independent server or a server cluster composed of multiple servers.

[0066] In one embodiment, as Figure 2 shown, a database parameter management method is provided, and this method is applied toFigure 1 Taking the server in

[0067] Step 202: Obtain a matter application request, which carries a database parameter file.

[0068] Herein, the matter application request refers to an acceptance application generated based on parameter management matters, and is used to instruct the server to perform parameter maintenance processing on the parameter management matters. The database parameter file refers to the database parameter data that needs to be parameter-managed.

[0069] The user can log in to the RPA system through the terminal and send a matter application request to the server. Herein, RPA is a business process automation technology based on software robots and artificial intelligence. By simulating and enhancing the interaction process between humans and computers, executing repeatable tasks based on certain rules, and coordinating data interaction between heterogeneous business systems, etc., the purpose of reducing costs and increasing efficiency and reducing business operation risks is ultimately achieved. The "robot" therein is just a virtual concept and does not require a physical robot. It is just an executor of the process, or an execution unit. For example, in this embodiment, a computer program is used as the executor of the process, and this computer program can be embodied as the RPA system.

[0070] Specifically, the user can click on "My Workbench" in the RPA system. After the terminal receives the trigger operation of "My Workbench", it displays the interface of "Parameter Application Permission To-Do Matters". The user can click on "Process Matter" on this interface. After the terminal receives the trigger operation of "Process Matter", it obtains the attachment corresponding to the process matter. Herein, the process matter refers to the matter that needs to be parameter-managed. The attachment refers to the database parameter file corresponding to the process matter. The terminal receives the download request for the attachment and downloads the corresponding attachment according to the download request. The downloaded attachment is the database parameter file corresponding to the process matter. The database parameter file can be a maintenance list, and the maintenance list can include one or more parameter tables. Each parameter table includes the parameter fields of the database parameters to be maintained and the parameter values to be modified. Thus, the terminal generates a matter application request according to the database parameter file and sends it to the server.

[0071] Furthermore, before obtaining the matter application request, the server can also determine the database parameter management mode, that is, determine the running mode of the RPA system in the server. Specifically, the server can obtain the database parameter management information uploaded by the terminal, determine the database parameter management mode according to the database parameter management information, and thus configure the running mode of RPA to the determined database parameter management mode, so as to process the matter application request, etc. under the database parameter management mode. Herein, the database parameter management information refers to the parameter management requirement information. The database parameter management mode can be the RPA automatic cyclic operation mode or the manual start RPA operation mode.

[0072] Step 204: Generate a file to be maintained according to the database parameter file, and identify whether the matter application request meets the acceptance passing conditions based on the file to be maintained.

[0073] The file to be maintained refers to the database parameter data after error correction processing.

[0074] When the server receives a matter application request sent by the terminal, it identifies whether to execute the acceptance process of the matter application request according to the matter acceptance switch status corresponding to the matter application request. When the matter acceptance switch status corresponding to the matter application request is on, it indicates that the "automatic acceptance" switch is on. At this time, the server can automatically execute the acceptance process of the matter application request. The acceptance process specifically includes: parsing the matter application request to obtain a database parameter file, thereby generating a file to be maintained according to the database parameter file, and further identifying whether the matter application request meets the acceptance passing conditions based on the file to be maintained. Among them, the acceptance passing conditions refer to that there are no problems such as format errors and character errors in the file to be maintained.

[0075] When the matter acceptance switch status corresponding to the matter application request is off, it indicates that the "automatic acceptance" switch is off, and this matter application request needs to be manually accepted. The server only executes the subsequent data entry and submission processes for the matter application requests that have been manually accepted, and skips the processing of the "to be accepted" matter application requests. Specifically, when the server receives a matter application request that has been manually accepted, it parses the matter application request that has been manually accepted to obtain a file to be maintained that meets the acceptance conditions.

[0076] Further, identifying whether the matter application request meets the acceptance passing conditions based on the file to be maintained includes: verifying the file to be maintained; if the verification passes, then the matter application request meets the acceptance passing conditions.

[0077] The server's verification of the file to be maintained means checking whether there are format errors and character errors in the file to be maintained. Among them, format errors can include the existence of extra spaces, incorrect date formats, etc., and character errors can include garbled characters, etc. If there are no format errors and character errors, then the matter application request meets the acceptance passing conditions. By verifying the file to be maintained, the accuracy of database parameter management can be improved.

[0078] Further, determining whether the application request for the matter to be maintained meets the acceptance passing condition includes: if the pre-maintenance switch is turned on, the file to be maintained is pre-maintained; if the pre-maintenance is completely successful, the acceptance is passed and the next processing flow is entered; otherwise, it is selected as "data error" and the acceptance is not passed, and an error message is sent to the specified email. Among them, the server can send the file to be maintained to the test machine and enter the pre-configured test environment for pre-maintenance processing. Pre-maintenance refers to pre-entering the database parameter data in the file to be maintained. Through pre-maintenance processing, the application requests for matters with data errors are rejected, which can ensure that only the application requests with accurate data are accepted, improving the accuracy of database parameter management.

[0079] Step 206, when the application request for the matter meets the acceptance passing condition, create a maintenance application form according to the file to be maintained.

[0080] When the application request for the matter meets the acceptance passing condition, the server can automatically associate the application request for the matter and create a corresponding maintenance application form according to the file to be maintained, so that the corresponding maintenance application form can be directly queried according to the application request for the matter.

[0081] Optionally, when the file to be maintained only includes a single parameter table, a maintenance application form can be created according to the single parameter table. When the file to be maintained includes multiple parameter tables, corresponding maintenance application forms can be created one by one according to the multiple parameter tables.

[0082] Step 208, enter the database parameter data in the file to be maintained into the maintenance application form and submit the maintenance application form.

[0083] The server automatically identifies the database parameter data in the file to be maintained, enters the database parameter data into the maintenance application form at one time, submits the maintenance application form, and performs the next-level maintenance on the maintenance application form. Among them, the next-level maintenance can include tertiary maintenance or secondary maintenance. For example, tertiary maintenance is review and secondary maintenance is approval.

[0084] Optionally, before submitting the maintenance application form, the server can modify the database parameter data in the maintenance application form to improve the accuracy of parameter maintenance.

[0085] Further, the above method further includes: when maintenance exception information is obtained during the entry of the database parameter data, temporarily store the maintenance application form; send the maintenance exception information to the target terminal.

[0086] Among them, the target terminal refers to the terminal that processes the maintenance exception information.

[0087] The server can monitor the input process of database parameter data. When it detects abnormal maintenance information during the input process, it temporarily stores the maintenance application form. For example, the abnormal maintenance information can include abnormal pop-up windows, in-process warnings, comparison for existence, etc. The server can send the obtained abnormal maintenance information to the target terminal through the RPA system. At this time, the server skips the application request for this matter and processes the next application request. By sending the abnormal maintenance information obtained during the input process of database parameter data to the target terminal to prompt the relevant staff corresponding to the target terminal to handle the application request with abnormalities, it is conducive to quickly processing abnormal matters.

[0088] Optionally, the abnormal maintenance information can be sent to the target terminal by email, or can also be sent to the target terminal by means such as short messages and instant messaging accounts.

[0089] In the above database parameter management method, an application request for a matter is obtained. The application request for a matter carries a database parameter file, and thus a file to be maintained is generated according to the database parameter file. It is determined whether the application request for a matter meets the acceptance passing condition according to the file to be maintained. Furthermore, when the application request for a matter meets the acceptance passing condition, a maintenance application form is created according to the file to be maintained, the database parameter data in the file to be maintained is entered into the maintenance application form, and the maintenance application form is submitted. It realizes automatic acceptance of application requests for matters and automatic entry of database parameter data during the parameter management process, and can perform automated processing of database parameters. It changes the manual maintenance mode in the traditional method, reduces the intervention of simple and repetitive manual links, thereby improving the management efficiency of database parameters and avoiding the problem of a relatively high risk of manual misoperation.

[0090] In one embodiment, as Figure 3 shown, before obtaining the application request for a matter, the above method further includes:

[0091] Step 302, obtain database parameter management information.

[0092] Step 304, determine the database parameter management mode from multiple preset parameter management modes according to the database parameter management information.

[0093] Among them, the parameter management status refers to the parameter management situation of the financial enterprise itself. The multiple preset parameter management modes refer to parameter management modes that can be flexibly selected.

[0094] The multiple preset parameter management modes can include the RPA automatic loop operation mode and the manual start RPA operation mode. The database parameter management information can include the parameter maintenance frequency, the maintenance volume, and the parameter management status. The parameter management status can include the error rate during the maintenance process.

[0095] The server can determine the database parameter management mode among multiple preset parameter management modes according to the obtained database parameter management information, so as to obtain the matter application request in the database parameter management mode. Specifically, when any one of the parameter maintenance frequency, maintenance volume, and parameter management status in the database parameter management information meets the RPA automatic cyclic operation mode, the database parameter management mode is determined to be the RPA automatic cyclic operation mode. When none of the parameter maintenance frequency, maintenance volume, and parameter management status in the database parameter management information meets the RPA automatic cyclic operation mode, the database parameter management mode is determined to be the manual start RPA operation mode. Among them, the conditions for meeting the RPA automatic cyclic operation mode can include that the parameter maintenance frequency is greater than or equal to the frequency threshold, or the maintenance volume is greater than or equal to the maintenance volume threshold, or the error rate during the maintenance process is less than the error rate threshold. The parameter maintenance frequency, maintenance volume, and error rate during the maintenance process corresponding to the manual start RPA operation mode are less than the frequency threshold, less than the maintenance volume threshold, and greater than or equal to the error rate threshold, respectively.

[0096] Taking the frequency threshold of once a day, the maintenance volume threshold of 5000 records, and the error rate threshold of 40% as an example for illustration. When the parameter maintenance frequency in the database parameter management information is once a day, the database parameter management mode is determined to be the RPA automatic cyclic operation mode. When the maintenance volume in the database parameter management information exceeds 5000 records, the database parameter management mode is determined to be the RPA automatic cyclic operation mode. When the parameter management status in the database parameter management information is that the error rate during the maintenance process is 35%, the database parameter management mode is determined to be the RPA automatic cyclic operation mode.

[0097] Furthermore, when the database parameter management mode is determined to be the RPA automatic cyclic operation mode, that is, after being configured as the RPA automatic cyclic operation mode, the staff of the parameter application post can start the RPA system installed in the server, which can also be called the unified parameter management system, to obtain the matter application request. The server can set the interval time for parameter management according to the maintenance volume and parameter management status, and automatically run cyclically according to the interval time without manual intervention. For example, the server can automatically run cyclically every 30 minutes.

[0098] Optionally, in order to reduce the management risk of database parameters, the server can set to automatically cycle according to the maintenance frequency of five times a day (5*24-hour mode) every Monday in the RPA automatic cyclic operation mode. Before production is required, the maintenance frequency can be set to automatically cycle seven times a day (7*24-hour mode).

[0099] When it is determined that the database parameter management mode is the manual start RPA operation mode, that is, after it is configured as the manual start RPA operation mode, the server needs to manually click the "Execute" button in the "RPA Console" every time it runs to start the server operation. In this mode, parameter management processes can be carried out for specified matters, matters that have missed the time of the RPA loop automatic operation mode, temporarily generated matters, matters that need to be re-run after manual confirmation and handling of failed operations, etc.

[0100] In this embodiment, by obtaining database parameter management information based on RPA; determining the database parameter management mode among multiple preset parameter management modes according to the database parameter management information, various operation modes of RPA can be flexibly configured, enabling flexible processing of database parameters, thereby improving the efficiency of database parameter management.

[0101] In one embodiment, generating a file to be maintained according to a database parameter file includes: identifying whether the format of the database parameter file is a preset template; if the format of the database parameter file is a preset template, identifying whether the maintenance policy corresponding to the database parameter file meets preset conditions; when the maintenance policy corresponding to the database parameter file meets the preset conditions, performing error correction processing on the database parameter data in the database parameter file to generate a file to be maintained.

[0102] After the server obtains a matter application request, it executes the acceptance process of the matter application request. During the execution of the acceptance process, it is necessary to generate a file to be maintained according to the database parameter file. Specifically, the server identifies whether the format of the database parameter file is a preset template, and the preset template refers to a template in a standard or agreed format. If the format of the database parameter file is a preset template, it identifies whether the maintenance policy corresponding to the database parameter file meets the preset conditions. Among them, the preset conditions refer to that the maintenance policy is text import, no maintenance policy, or interface maintenance. If the format of the database parameter file is not a preset template, the matter application request is skipped and the next matter application request is processed. When the preset conditions are met, error correction processing is performed on the database parameter data in the database parameter file to generate a file to be maintained. Specifically, the server uses an existing text check tool to check for errors in the database parameter data in the database parameter file and performs error correction processing to obtain CRC (Cyclic Redundancy Check) text, and determines the CRC text as the file to be maintained. The file to be maintained can include one or more parameter tables. For example, the text check formula can be a CRC text check tool.

[0103] Furthermore, the server can also automatically process special templates. Specifically, the server can identify whether the format of the database parameter file is a special template according to the agreed rules. For example, the special template can be a vertical list template in non-standard formats such as a bond template or a fund template. If it is a special template, a special process will be executed.

[0104] In this embodiment, by identifying whether the format of the database parameter file is a preset template and whether the maintenance policy corresponding to the database parameter file meets the preset conditions, after meeting the preset conditions, error correction processing is performed on the database parameter data in the database parameter file to generate a file to be maintained. A file to be maintained that is accurate and meets the parameter management standard can be generated.

[0105] In an optional manner of this embodiment, the above method further includes: identifying whether the number of database parameter data in the database parameter file after error correction processing is greater than a preset number threshold; when the number of database parameter data is greater than the preset number threshold, data segmentation is performed on the database parameter data to obtain a file to be maintained including multiple parameter tables.

[0106] Error correction processing is performed on the database parameter data in the database parameter file, and it can be identified whether the number of database parameter data in the database parameter file after error correction processing is greater than a preset number threshold. For example, the preset number threshold can be 5000 entries. When the number of database parameter data is greater than the preset number threshold, data segmentation can be performed on the database parameter data according to the preset number threshold. Specifically, the server takes the preset number threshold as the standard and performs data segmentation on the database parameter data to obtain multiple parameter tables. The number of database parameter data in each parameter table is less than or equal to the preset number threshold. There is a maintenance order among the multiple parameter tables, and the multiple parameter tables are associated through the maintenance order. The maintenance order is determined according to the sequence of the database parameter data in the database parameter file.

[0107] For example, when the preset number threshold is 5000 entries and the number of database parameter data is within 10000 entries, using the database parameter data corresponding to the preset number threshold as the dividing line, data segmentation is performed. The database parameter data before the dividing line is used to construct a parameter table, and the database parameter data after the dividing line is used to construct a parameter table, thus obtaining a file to be maintained including two parameter tables.

[0108] In this embodiment, data segmentation is performed on the database parameter data to obtain a file to be maintained including multiple parameter tables, which can avoid the problem that the amount of data submitted at one time is too large, resulting in server jamming.

[0109] In one embodiment, submitting a maintenance application form includes: when the file to be maintained includes a single parameter table, determining that the maintenance strategy corresponding to the file to be maintained is an interface maintenance strategy; comparing the database parameter data entered in the maintenance application form with the corresponding database parameter data in the single parameter table according to the interface maintenance strategy; and submitting the maintenance application form when the comparison is consistent.

[0110] When the file to be maintained only includes a single parameter table, the maintenance strategy adopted for the file to be maintained is an interface maintenance strategy. When the interface maintenance strategy is adopted, the database parameter data entered in the maintenance application form can be compared with the corresponding database parameter data in the single parameter table. Specifically, the server can automatically click the "Preview" button to compare the database parameter data entered in the maintenance application form with the corresponding database parameter data in the single parameter table. When the comparison is consistent, the maintenance application form can be directly submitted. This can improve the maintenance accuracy of the single parameter table.

[0111] In one embodiment, submitting a maintenance application form includes: when the file to be maintained includes multiple parameter tables, determining that the maintenance strategy corresponding to the file to be maintained is a text import strategy; and submitting the maintenance application form in batches according to the text import strategy.

[0112] When the file to be maintained includes multiple parameter tables, the maintenance strategy adopted for the file to be maintained is a text import strategy. The text import strategy requires submitting the maintenance application form in batches. Since there is a maintenance order among multiple parameter tables and the multiple parameter tables are associated through the maintenance order, the server can submit the maintenance application files corresponding to the multiple parameter tables in batches according to the text import strategy in the maintenance order among the multiple parameter tables.

[0113] During the batch submission process, the server will identify whether the maintenance application form of the current batch is associated with a domestic or overseas parameter application form. If it is already associated, it will check whether all the previous batches have been successfully maintained. In this embodiment, it is default that the domestic parameter application form is associated. If not all the previous batches have been successfully maintained, the submission process of the maintenance application form will be exited and transferred to the manual submission process. If all the previous batches have been successfully maintained, the maintenance application form of the current batch will be edited. For example, the database parameter data in the maintenance application form can be modified. The server records the submission order of the current batch and submits the maintenance application form of the current batch until the last maintenance application form of the last batch is submitted. This can effectively improve the maintenance accuracy of multiple parameter tables.

[0114] In one embodiment, after submitting the maintained maintenance application form, the above method further includes: generating a maintenance prompt message according to the submitted maintenance application form; and sending the maintenance prompt message to a pre-configured processing terminal so that the processing terminal performs the next-level maintenance on the submitted maintenance application form.

[0115] Among them, the lower-level maintenance can include secondary maintenance or tertiary maintenance. For example, the secondary maintenance can be review, and the tertiary maintenance can be approval.

[0116] When the server adopts the interface maintenance strategy, there is only one maintenance application form submitted. After submitting the maintenance application form, maintenance prompt information can be generated according to the submitted maintenance application form. The maintenance prompt information is sent to a pre-configured processing terminal through the RPA system, so that the processing terminal can perform lower-level maintenance on the submitted maintenance application form.

[0117] Optionally, the maintenance prompt information can be sent to the processing terminal by email, or can also be sent to the processing terminal by means such as short message, instant messaging account, etc.

[0118] When the server adopts the text import strategy, there can be multiple maintenance application forms submitted. After submitting the last maintenance application form of any batch, maintenance prompt information can be generated according to the maintenance application forms of this batch submitted. The maintenance prompt information is sent to a pre-configured processing terminal through the RPA system, so that the processing terminal can perform lower-level maintenance on the maintenance application forms of this batch submitted.

[0119] In this embodiment, by setting the maintenance reminder function, the management of database parameter data can be carried out more efficiently.

[0120] In one embodiment, the server can also perform cross-region centralized maintenance on database parameters for different regions. For example, Bank A and Bank B do not belong to the same region, but Bank B is under the jurisdiction of Bank A, then Bank A needs to perform cross-region maintenance on Bank B.

[0121] In one embodiment, the server can also log the database parameter management situation by day through a table.

[0122] In another embodiment, as Figure 4 shown, a database parameter management method is provided. Taking the server in Figure 1 as an example for illustration, it includes the following steps:

[0123] Step 402, obtain database parameter management information.

[0124] Step 404, determine the database parameter management mode from multiple preset parameter management modes according to the database parameter management information.

[0125] Step 406, obtain an item application request, and the item application request carries a database parameter file.

[0126] Step 408, identify whether the format of the database parameter file is a preset template. If so, execute Step 410; if not, execute Step 412.

[0127] Step 410, identify whether the maintenance policy corresponding to the database parameter file meets the preset conditions. If it meets, continue to execute Step 414. If it does not meet, execute Step 412.

[0128] Step 412, skip to process the next matter application request.

[0129] Step 414, when the maintenance policy corresponding to the database parameter file meets the preset conditions, perform error correction processing on the database parameter data in the database parameter file to generate a file to be maintained.

[0130] Step 416, verify the file to be maintained. If the verification passes, execute Step 418; if the verification fails, execute Step 420.

[0131] Step 418, acceptance is passed. Continue to execute Step 422.

[0132] Step 420, acceptance fails.

[0133] Step 422, create a maintenance application form according to the file to be maintained.

[0134] Step 424, enter the database parameter data in the file to be maintained into the maintenance application form.

[0135] Step 426, when the file to be maintained includes a single parameter table, determine that the maintenance policy corresponding to the file to be maintained is an interface maintenance policy.

[0136] Step 428, compare the database parameter data entered in the maintenance application form with the corresponding database parameter data in the single parameter table according to the interface maintenance policy.

[0137] Step 430, when the comparison is consistent, submit the maintenance application form. Continue to execute Step 436.

[0138] Step 432, when the file to be maintained includes multiple parameter tables, determine that the maintenance policy corresponding to the file to be maintained is a text import policy.

[0139] Step 434, submit the maintenance application form in batches according to the text import policy.

[0140] Step 436, generate a maintenance prompt message according to the submitted maintenance application form.

[0141] Step 438, send the maintenance prompt message to a pre-configured processing terminal so that the processing terminal performs the next-level maintenance on the submitted maintenance application form.

[0142] In this embodiment, various operation modes of RPA can be flexibly configured to flexibly process database parameters, thereby improving the efficiency of database parameter management. An accurately generated maintenance file that complies with the parameter management standard can be generated. The maintenance accuracy of a single parameter table and multiple parameter tables can also be improved. By setting up the email reminder function, the management of database parameter data can be carried out more efficiently. Overall, this embodiment realizes the automatic acceptance of matter applications and the automatic input of database parameter data during the parameter management process, and can automate the processing of database parameters. It changes the manual maintenance mode in the traditional method, reduces the intervention of simple and repetitive manual links, thereby improving the management efficiency of database parameters and avoiding the problem of a relatively high risk of manual misoperation.

[0143] It should be understood that although the steps in the flowcharts involved in the above-described embodiments are sequentially displayed according to the arrows, these steps are not necessarily executed in the order indicated by the arrows. Unless clearly stated in this article, the execution of these steps has no strict order limit, and these steps can be executed in other orders. Moreover, at least a part of the steps in the flowcharts involved in the above-described embodiments may include multiple steps or multiple stages. These steps or stages are not necessarily executed at the same time, but can be executed at different times. The execution order of these steps or stages is not necessarily sequential, but can be executed alternately or alternately with at least a part of other steps or steps or stages in other steps.

[0144] Based on the same inventive concept, the embodiment of the present application also provides a database parameter management device for implementing the above-mentioned database parameter management method. The implementation solution provided by this device to solve the problem is similar to the implementation solution described in the above method. Therefore, the specific limitations in one or more embodiments of the database parameter management device provided below can refer to the limitations on the database parameter management method in the above text, and will not be repeated here.

[0145] In one embodiment, as Figure 5 shown, a database parameter management device is provided, including: a matter application module 502, a matter acceptance module 504, an application form creation module 506, and a data maintenance module 508, where:

[0146] The matter application module 502 is used to obtain a matter application request, and the matter application request carries a database parameter file.

[0147] The matter acceptance module 504 is used to generate a maintenance file according to the database parameter file, and identify whether the matter application request meets the acceptance passing condition according to the maintenance file.

[0148] An application creation module 506, configured to create a maintenance application form according to a file to be maintained when a matter application request meets the acceptance passing condition.

[0149] A data maintenance module 508, configured to enter database parameter data in the file to be maintained into the maintenance application form and submit the maintenance application form.

[0150] In one embodiment, the matter acceptance module 504 is further configured to identify whether the format of the database parameter file is a preset template; if the format of the database parameter file is a preset template, identify whether the maintenance policy corresponding to the database parameter file meets a preset condition; when the maintenance policy corresponding to the database parameter file meets the preset condition, perform error correction processing on the database parameter data in the database parameter file to generate a file to be maintained.

[0151] In one embodiment, the matter acceptance module 504 is further configured to identify whether the quantity of database parameter data in the database parameter file after error correction processing is greater than a preset quantity threshold; when the quantity of database parameter data is greater than the preset quantity threshold, perform data segmentation on the database parameter data to obtain a file to be maintained including multiple parameter tables.

[0152] In one embodiment, the matter acceptance module 504 is further configured to verify the file to be maintained; if the verification passes, the matter application request meets the acceptance passing condition.

[0153] In one embodiment, the data maintenance module 508 is further configured to, when the file to be maintained includes a single parameter table, determine that the maintenance policy corresponding to the file to be maintained is an interface maintenance policy; compare the database parameter data already entered in the maintenance application form with the corresponding database parameter data in the single parameter table according to the interface maintenance policy; when the comparison is consistent, submit the maintenance application form.

[0154] In one embodiment, the data maintenance module 508 is further configured to, when the file to be maintained includes multiple parameter tables, determine that the maintenance policy corresponding to the file to be maintained is a text import policy; submit the maintenance application form in batches according to the text import policy.

[0155] In one embodiment, the above device further includes: a management mode determination module, configured to obtain database parameter management information based on RPA; determine a database parameter management mode from multiple preset parameter management modes according to the database parameter management information.

[0156] In one embodiment, the above device further includes: a maintenance exception handling module, configured to, when maintenance exception information is obtained during the entry process of database parameter data, temporarily store the maintenance application form; send the maintenance exception information to a target terminal.

[0157] In one embodiment, the above device further includes: a mailbox reminder module, configured to generate a maintenance reminder message according to the submitted maintenance application form; and send the maintenance reminder message to a pre-configured processing terminal, so that the processing terminal performs a next-level maintenance on the submitted maintenance application form.

[0158] Each module in the above database parameter management device can be implemented in whole or in part by software, hardware, and their combination. Each of the above modules can be embedded in or independent of a processor in a computer device in the form of hardware, or stored in a memory in the computer device in the form of software, so that the processor can call and execute the operations corresponding to each of the above modules.

[0159] In one embodiment, a computer device is provided. The computer device can be a server, and its internal structure diagram can be as Figure 6 shown. The computer device includes a processor, a memory, an input / output interface (Input / Output, abbreviated as I / O), and a communication interface. Among them, the processor, the memory, and the input / output interface are connected through a system bus, and the communication interface is connected to the system bus through the input / output interface. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The database of the computer device is used to store data such as database parameter files and maintenance application forms. The input / output interface of the computer device is used to exchange information between the processor and external devices. The communication interface of the computer device is used to communicate with external terminals through a network connection. When the computer program is executed by the processor, it implements a database parameter management method.

[0160] Those skilled in the art can understand that Figure 6 the structure shown in

[0161] is only a block diagram of some structures related to the solution of this application, and does not constitute a limitation on the computer device to which the solution of this application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine some components, or have different component arrangements.

[0162] In one embodiment, a computer device is provided, including a memory and a processor. A computer program is stored in the memory, and when the processor executes the computer program, it implements the steps in the above method embodiments.

[0163] In one embodiment, a computer program product is provided, including a computer program that, when executed by a processor, implements the steps in the above method embodiments.

[0164] Specifically, the computer program product may be an RPA robot. The structure of the RPA robot may include three units: a robot component and process unit, a robot task unit, and a robot management unit. Among them, the component units in the robot component and process unit are independent modules that execute specific logical operations. They are written in a scripting language and can simulate daily manual operation processes, such as file generation, mouse clicks, keyboard simulation, copy / paste, etc. The process unit in the robot component and process unit is used to connect individual independent component units into a full-step process, forming a closed-loop business process and realizing the automation of the designed process. The robot task unit is responsible for configuring the time of automatic tasks and automatically executing the robot process unit according to the set task time parameters to achieve the automated execution of process tasks. The robot management unit is used for the resource scheduling, monitoring, and management of multiple robots, and monitors and tracks the current running status and historical execution status of the robots through a visual view. At the same time, for the historical processes executed by the robot each time, the operation log records all operation records such as the execution results and execution times of each node of the robot for the user to track and view.

[0165] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data for analysis, stored data, displayed data, etc.) involved in this application are all information and data that have been authorized by the user or fully authorized by all parties. Moreover, the collection, use, and processing of relevant data need to comply with the relevant laws, regulations, and standards of relevant countries and regions.

[0166] Those of ordinary skill in the art can understand that all or part of the processes in the above-described method embodiments can be completed by instructing relevant hardware through a computer program. The computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the method embodiments as described above. Among them, any reference to a memory, database, or other medium used in the embodiments provided in the present application can include at least one of non-volatile and volatile memories. Non-volatile memories can include read-only memory (ROM), magnetic tapes, floppy disks, flash memories, optical memories, high-density embedded non-volatile memories, resistive random access memories (ReRAM), magnetoresistive random access memories (MRAM), ferroelectric random access memories (FRAM), phase change memories (PCM), graphene memories, etc. Volatile memories can include random access memory (RAM) or external cache memories, etc. By way of illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM), etc. The databases involved in the embodiments provided in the present application can include at least one of relational databases and non-relational databases. Non-relational databases can include distributed databases based on blockchain, etc., without limitation. The processors involved in the embodiments provided in the present application can be general-purpose processors, central processing units, graphics processing units, digital signal processors, programmable logic devices, data processing logics based on quantum computing, etc., without limitation.

[0167] The technical features of the above embodiments can be combined arbitrarily. For the sake of concise description, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, it should be considered as the scope described in this specification.

[0168] The above-described embodiments only represent several implementation manners of the present application. The description is relatively specific and detailed, but it should not be construed as a limitation on the patent scope of the present application. It should be noted that for those of ordinary skill in the art, without departing from the concept of the present application, several modifications and improvements can still be made, and these all belong to the protection scope of the present application. Therefore, the protection scope of the present application should be subject to the appended claims.

Claims

1. A method for managing database parameters, the method being applied to a server loaded with a robotic process automation (RPA) system, characterized in that, The method includes: Obtaining an item application request, where the item application request carries a database parameter file; Identifying whether the format of the database parameter file is a preset template; If the format of the database parameter file is the preset template, identifying whether the maintenance policy corresponding to the database parameter file meets the preset conditions; When the maintenance policy corresponding to the database parameter file meets the preset conditions, performing error correction processing on the database parameter data in the database parameter file to generate a file to be maintained; identifying whether the item application request meets the acceptance passing conditions according to the file to be maintained; When the item application request meets the acceptance passing conditions, creating a maintenance application form according to the file to be maintained; Entering the database parameter data in the file to be maintained into the maintenance application form and submitting the maintenance application form; It further includes: identifying whether the quantity of the database parameter data after error correction processing is greater than a preset quantity threshold; when the quantity of the database parameter data is greater than the preset quantity threshold, performing data segmentation on the database parameter data to obtain a file to be maintained including multiple parameter tables; The submitting the maintenance application form includes: when the file to be maintained includes a single parameter table, determining that the maintenance policy corresponding to the file to be maintained is an interface maintenance policy; comparing the database parameter data already entered in the maintenance application form with the corresponding database parameter data in the single parameter table according to the interface maintenance policy; when the comparison is consistent, submitting the maintenance application form; When the file to be maintained includes multiple parameter tables, determining that the maintenance policy corresponding to the file to be maintained is a text import policy; submitting the maintenance application form in batches according to the text import policy.

2. The method according to claim 1, wherein The identifying whether the item application request meets the acceptance passing conditions according to the file to be maintained includes: Verifying the file to be maintained; If the verification passes, the item application request meets the acceptance passing conditions.

3. The method according to claim 1 or 2, characterized in that, Before the obtaining the item application request, the method further includes: Obtaining database parameter management information; Determining a database parameter management mode from multiple preset parameter management modes according to the database parameter management information.

4. The method according to claim 1 or 2, characterized in that The method further includes: When maintenance exception information is obtained during the entry of the database parameter data, temporarily storing the maintenance application form; Sending the maintenance exception information to a target terminal.

5. The method according to claim 1 or 2, characterized in that, After the submitting the maintenance application form, the method further includes: Generating a maintenance prompt message according to the submitted maintenance application form; Sending the maintenance prompt message to a pre-configured processing terminal so that the processing terminal performs the next-level maintenance on the submitted maintenance application form.

6. A database parameter management device, which is used to implement the database parameter management method according to any one of claims 1-5, characterized in that, The device includes: An item application module, configured to obtain an item application request, where the item application request carries a database parameter file; An item acceptance module, configured to generate a file to be maintained according to the database parameter file, and identify whether the item application request meets the acceptance passing conditions according to the file to be maintained; An application form creation module, configured to create a maintenance application form according to the file to be maintained when the item application request meets the acceptance passing conditions; A data maintenance module, configured to enter the database parameter data in the file to be maintained into the maintenance application form and submit the maintenance application form.

7. A computer device, comprising a memory and a processor, the memory storing a computer program, characterized in that, When the processor executes the computer program, it implements the steps of the method according to any one of claims 1 to 5.

8. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by a processor, it implements the steps of the method according to any one of claims 1 to 5.

9. A computer program product, comprising a computer program, characterized in that, When the computer program is executed by a processor, it implements the steps of the method according to any one of claims 1 to 5.

Images