Data maintenance tool and data maintenance method

Abstract

The invention discloses a data maintenance tool and a data maintenance method, and relates to the technical field of computers, the data maintenance tool comprises a network WEB layer, a service layer coupled with the WEB layer and a data layer coupled with the service layer; wherein the WEB layer is used for providing a visual operation interface for a user, and the service layer is used for carrying out business rule logic processing according to the operation of the user on the visual operation interface and maintaining a database in the data layer. When the data maintenance tool provided by the invention is used for updating the database, operation and maintenance personnel only need to simply operate on the visual operation interface to finish updating, and do not need to write a corresponding script for each problem, so that the data maintenance process is simplified, the workload of the operation and maintenance personnel is reduced, and the working pressure of the operation and maintenance personnel is reduced.

Description

Technical Field

[0001] The present application relates to the field of computer technology, and in particular to a data maintenance tool and a data maintenance method. Background Art

[0002] After the system (such as a call center system) is built and implemented online, it will enter the daily operation and maintenance stage of the system. For operation and maintenance personnel, the most common work is basically the processing of system data, such as data errors, or adding a batch of data or modifying a batch of order data, address data, etc. This data processing method has the characteristics of large workload, prone to errors, cumbersome maintenance, long response cycle, unmanageable, poor data quality, and single-point maintenance. This makes the system's data maintenance process cumbersome and labor-intensive, resulting in high work pressure for operation and maintenance personnel. Summary of the invention

[0003] The present application provides a data maintenance tool and a data maintenance method, which solves the problem that the data maintenance process of the current system is cumbersome and labor-intensive, resulting in high work pressure for operation and maintenance personnel.

[0004] In a first aspect, in order to achieve the above-mentioned purpose, an embodiment of the present application provides a data maintenance tool, including: a network WEB layer, a service layer coupled to the WEB layer, and a data layer coupled to the service layer;

[0005] The WEB layer is used to provide a visual operation interface for users, and the service layer is used to maintain the database in the data layer by performing business rule logic processing according to the user's operations on the visual operation interface.

[0006] The visual operation interface includes one or more of a first control related to data maintenance, a second control related to maintenance service configuration, a third control related to maintenance service query, and a fourth control related to maintenance log.

[0007] Wherein, the first control includes: a business data maintenance control and a high-frequency maintenance operation control.

[0008] The database also includes:

[0009] a first form, wherein the first form is related to the first control and the third control;

[0010] a second form, the second form being associated with the fourth control;

[0011] a third form, the third form being related to the second control;

[0012] A fourth form, wherein the fourth form is related to the business data maintenance control;

[0013] A fifth form, wherein the fifth form is used to associate the first form with the fourth form.

[0014] Wherein: the first form includes at least one of a business number field, a creation time field, a business maintenance category field, a business maintenance start status field, a business maintenance name field, a business maintenance brief description field, a business process number field, an editor field, a business maintenance operation field and a remarks field;

[0015] The second form includes at least one of a log number field, a business number field, an operator field, an operation time field, an input parameter field, a business parameter field, an execution result field, and a remarks field;

[0016] The third form includes at least one of a rule number field, a process number field, a parameter number field, a parameter type field, a parameter constraint field, a parameter constraint condition field, and a remark field;

[0017] The fourth form includes at least one of a process number field, a structured query language sql type field, a sql statement field, a parameter chain field, a description chain field, a result name field, a transaction status field, a description field, an editor field, and a remarks field;

[0018] The fifth form includes at least one of a relationship code field, a business number field, a process number field, and a dependency order field.

[0019] Among them, the sub-operation interface associated with the second control is used to set the data maintenance business rule script, and the sub-operation interface includes multiple SQL statement setting areas, wherein the SQL statement setting area has: process number control, SQL type control, deactivation status control, modification control, modification parameter rule control, cancel control, confirmation control, SQL statement control, SQL parameter control, Chinese name control and at least one of the remarks control.

[0020] Wherein, the service layer includes:

[0021] A verification plug-in, used to verify the format of the parameters in the file provided by the WEB layer;

[0022] A script parser, used to parse the file and extract data from the file if the verification plug-in passes the verification;

[0023] The data maintenance rule module is used to determine the data range that needs to be maintained in the database based on the maintenance business configuration information, and process the data within the data range according to the data extracted by the script parser.

[0024] Wherein, the service layer also includes:

[0025] A process control module is used to perform process control on the business that needs to be maintained written by the user in the visual operation interface;

[0026] The execution management module is used to manage the business that needs to be maintained.

[0027] Wherein, the data layer also includes:

[0028] A business maintenance configuration module, the business maintenance configuration module is used to provide data maintenance configuration information to the service layer, and the service layer maintains the data in the database based on the data maintenance configuration information, wherein the business maintenance configuration information includes business rules and execution logic of the business rules.

[0029] The data maintenance tool supports at least one update mode of a single table update, a multi-table update and a batch update of a database.

[0030] In a second aspect, in order to achieve the above-mentioned purpose, an embodiment of the present application provides a data maintenance method, using the data maintenance tool as described in the first aspect, the method comprising:

[0031] Receiving a first operation of the user on the visual operation interface;

[0032] The database is maintained according to the maintenance service configuration information corresponding to the first operation and the data in the file corresponding to the first operation.

[0033] The step of maintaining the database according to the maintenance service configuration information corresponding to the first operation and the data in the file corresponding to the first operation includes:

[0034] Performing format check on parameters in the file corresponding to the first operation;

[0035] When the verification is passed, the database is maintained according to the maintenance service configuration information corresponding to the first operation and the data in the file corresponding to the first operation.

[0036] The step of maintaining the database according to the maintenance service configuration information corresponding to the first operation and the data in the file corresponding to the first operation includes:

[0037] Parsing the file to obtain data in the file;

[0038] Determining the data range that needs to be maintained in the database according to the business rules in the maintenance business configuration information;

[0039] The data range is maintained according to the execution logic of the business rule in the maintenance business configuration information, the business rule and the data.

[0040] Wherein, the method further comprises:

[0041] receiving a second operation of the user on the visual operation interface, where the second operation is an operation on a second control related to the maintenance service configuration;

[0042] In response to the second operation, maintenance service configuration information is configured in the sub-operation interface associated with the second control, wherein the maintenance service configuration information includes service rules and execution logic of the service rules.

[0043] After maintaining the database according to the business rules corresponding to the first operation and the data in the file corresponding to the first operation, the method further includes:

[0044] A maintenance log is generated in relation to the updating process of the database.

[0045] The beneficial effects of the above technical solution of the present application are:

[0046] The data maintenance tool of the present application includes a network WEB layer, a service layer coupled to the WEB layer, and a data layer coupled to the service layer; wherein the WEB layer is used to provide a visual operation interface for users, and the service layer is used to maintain the database in the data layer by performing business rule logic processing according to the user's operation on the visual operation interface. In this way, the operation and maintenance personnel only need to perform simple operations on the visual operation interface to complete the data update, without having to write corresponding scripts for each problem, which simplifies the maintenance process and reduces the difficulty and pressure of the operation and maintenance personnel. BRIEF DESCRIPTION OF THE DRAWINGS

[0047] Figure 1 A schematic diagram of the structure of a data maintenance tool according to an embodiment of the present application;

[0048] Figure 2 A schematic diagram of a query interface of a data maintenance tool according to an embodiment of the present application;

[0049] Figure 3 A schematic diagram of a maintenance service displayed by a data maintenance tool according to an embodiment of the present application;

[0050] Figure 4 A schematic diagram showing the relationship between various forms in the data maintenance tool of an embodiment of the present application;

[0051] Figure 5 A schematic diagram of an interface for setting scripts in a data maintenance tool according to an embodiment of the present application;

[0052] Figure 6 A schematic diagram of a self-operation interface associated with a second control in a data maintenance tool according to an embodiment of the present application;

[0053] Figure 7 This is one of the interface diagrams related to batch updating of the data maintenance tool in the embodiment of the present application;

[0054] Figure 8 This is a second interface diagram related to batch updating of the data maintenance tool according to an embodiment of the present application;

[0055] Fig. 9 A flowchart of a data maintenance method according to an embodiment of the present application. DETAILED DESCRIPTION

[0056] In order to make the technical problems, technical solutions and advantages to be solved by the application clearer, the following will be described in detail in conjunction with the accompanying drawings and specific embodiments. In the following description, specific details such as specific configurations and components are provided only to help fully understand the embodiments of the application. Therefore, it should be clear to those skilled in the art that various changes and modifications can be made to the embodiments described herein without departing from the scope and spirit of the application. In addition, for clarity and brevity, the description of known functions and structures has been omitted.

[0057] It should be understood that the references to "one embodiment" or "an embodiment" throughout the specification mean that the specific features, structures, or characteristics associated with the embodiment are included in at least one embodiment of the present application. Therefore, the references to "in one embodiment" or "in an embodiment" appearing throughout the specification do not necessarily refer to the same embodiment. In addition, these specific features, structures, or characteristics may be combined in any suitable manner in one or more embodiments.

[0058] In the various embodiments of the present application, it should be understood that the size of the serial numbers of the following processes does not mean the order of execution. The execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiments of the present application.

[0059] Additionally, the terms "system" and "network" are often used interchangeably herein.

[0060] In the embodiments provided in the present application, it should be understood that "B corresponding to A" means that B is associated with A, and B can be determined according to A. However, it should also be understood that determining B according to A does not mean determining B only according to A, and B can also be determined according to A and / or other information.

[0061] Before describing the embodiments of the present application, the relevant technical points are described first.

[0062] Database entry operation: refers to the operation and maintenance personnel directly logging into the system production database to perform entry operations when performing system data maintenance, and writing scripts in the production database to complete data query and update operations.

[0063] SQL script: SQL script is a collection of SQL commands to complete a specific task. It is usually used to perform batch operations, such as creating database objects (such as tables, views, stored procedures, etc.), inserting data, performing batch updates, etc.

[0064] The data maintenance tool and data maintenance method provided in the embodiments of the present application are described in detail below in conjunction with the accompanying drawings.

[0065] The embodiment of the present application provides a data maintenance tool, such as Figure 1 As shown, it includes: a network WEB layer, a service layer coupled with the WEB layer, and a data layer coupled with the service layer;

[0066] The WEB layer is used to provide a visual operation interface for users, and the service layer is used to maintain the database in the data layer by performing business rule logic processing according to the user's operations on the visual operation interface.

[0067] The WEB layer of the data maintenance tool in the embodiment of the present application provides a visual operation interface for users, so that when users need to perform database maintenance, they can perform corresponding operations on the visual operation interface. Through the interaction between the WEB layer and the service layer, the service layer performs business rule logic processing according to the user's operations on the visual operation interface, thereby realizing the maintenance of the database of the data layer. In this way, on the one hand, users do not need to write corresponding scripts for each maintenance, which simplifies the data maintenance process, makes the operation and maintenance work more standardized and convenient, reduces the user's workload and work pressure, and has relatively low requirements for new operation and maintenance personnel. On the other hand, users do not need to directly operate the system production library, avoiding the risk of database abnormalities.

[0068] As an optional implementation, Figure 1 As shown, the visual operation interface has one or more of: a first control related to data maintenance, a second control related to maintenance service configuration, a third control related to maintenance service query, and a fourth control related to maintenance log.

[0069] Wherein, the first control is used for the user to create / display the business data that needs to be maintained;

[0070] The second control is used to configure the relevant information of the service that needs to be maintained;

[0071] The third control is used to display the services that can be maintained by the data maintenance tool; for example, when a user clicks the third control, the data maintenance tool will display the following information: Figure 2 The query interface shown in the figure, the user enters the data maintenance name, keywords and other information on this interface, and clicks query, the data maintenance tool will display the following Figure 3 The next level interface shown shows the maintenance services that the data maintenance tool can perform;

[0072] The fourth control is used to display the log of data maintenance performed by the operation and maintenance personnel using the data maintenance tool.

[0073] As a specific implementation manner, the first control includes: a business data maintenance control and a high-frequency maintenance operation control.

[0074] In the above specific implementation, the first control is split into a business data maintenance control and a high-frequency maintenance operation control. In this way, for businesses that require high-frequency maintenance, maintenance can be performed by operating the high-frequency maintenance operation control, further improving the efficiency of data maintenance.

[0075] As an optional implementation, the database also includes:

[0076] A first form, wherein the first form is related to the first control and the third control; wherein, Figure 4 As shown, the first form includes at least one of a business number field, a creation time field, a business maintenance category field, a business maintenance start status field, a business maintenance name field, a business maintenance brief description field, a business process number field, an editor field, a business maintenance operation field and a remark field; wherein the first form can also be called a data maintenance business table, which is used to store information / data input by the user through the operation of the first control and / or the third control;

[0077] A second form, wherein the second form is related to the fourth control; wherein, Figure 4 As shown, the second form includes at least one of a log number field, a business number field, an operator field, an operation time field, an input parameter field, a business parameter field, an execution result field, and a remark field; wherein the second form may also be referred to as an execution log table, which is used to store the log generated when the user uses the data maintenance tool to perform data maintenance, so that the user can view and understand the specific situation of the data maintenance;

[0078] A third form, the third form is related to the second control; wherein, Figure 4As shown, the third form includes at least one of a rule number field, a process number field, a parameter number field, a parameter type field, a parameter constraint field, a parameter constraint condition field and a remark field; here, the third form can also be called a parameter chain rule table, which is used to store configuration information related to business maintenance input by the user through the operation of the second control, such as the configuration information is business data that needs to be maintained, for example, name, address, password, etc.;

[0079] A fourth form, the fourth form is related to the first control; wherein, if Figure 4 As shown, the fourth form includes at least one of a process number field, a structured query language sql type field, a sql statement field, a parameter chain field, a description chain field, a result name field, a transaction status field, a description field, an editor field, and a remark field; here, the fourth form can also be called a data maintenance business table, which is used to store information input by the user through the operation of the first control, wherein the information is related to the maintenance process of the business data to be maintained; wherein each of the fourth forms corresponds to a business number in the first form;

[0080] A fifth form, the fifth form is used to associate the first form with the fourth form; wherein the fifth form includes at least one of a relationship code field, a business number field, a process number field, and a dependency sequence field. That is, the fifth form is an intermediate table used to associate the first form with the second form.

[0081] In the above optional implementation method, by setting the above form, the data corresponding to the user's operations in the visual operation interface can be stored, so that the service layer can maintain the database based on these data. In this way, when maintaining the data, the user only needs to input the relevant information of the data to be maintained into the above form through the various controls in the visual operation interface. The user does not need to write scripts for each maintenance process, which simplifies the maintenance process, makes the operation and maintenance work more standardized and convenient, and makes the data maintenance work manageable and analyzable. There is no need for the user to directly operate the production library, thereby avoiding the risk of database abnormalities.

[0082] As an optional implementation, the sub-operation interface associated with the second control is used to set the data maintenance business rule script, such as Figure 5 As shown, the sub-operation interface includes multiple SQL statement setting areas, wherein the SQL statement setting area has at least one of: a process number control, a SQL type control, a deactivated status control, a modification control, a modification parameter rule control, a cancel control, a confirmation control, a SQL statement control, a SQL parameter control, a Chinese name control, and a remark control.

[0083] The sub-operation interface is an interface for configuring scripts for daily data maintenance, that is, according to business rules, the scripts for daily data maintenance are configured in the business processing interface. The process number control is used for users to write the process number corresponding to the sql statement; the sql type control is used for users to write the sql type, wherein the sql type includes query class, update class or insert class, etc.; the deactivation state control is used for users to select whether the business corresponding to the sql is enabled or disabled; the modification control is used for users to modify the sql script; the modification parameter rule control is used for users to modify the parameter rules, for example, the modification parameter rule control can be associated with the next level sub-interface to modify the parameter rules through operations on the next level sub-interface; the sql statement control is used for users to write sql statements, and the sql parameter control is used for users to write sql parameters; the Chinese name control is used for users to write Chinese corresponding to the parameters written by the sql parameter control; the remarks control is used for users to explain the sql statement, for example, to explain the role or purpose of the sql statement.

[0084] As an optional implementation, Figure 1 As shown, the service layer includes:

[0085] A verification plug-in is used to verify the format of the parameters in the file provided by the WEB layer; here, the verification plug-in is specifically used to verify whether the parameter type, parameter quantity, etc. in the file provided by the WEB layer meet the requirements;

[0086] A script parser, used to parse the file and extract data from the file if the verification plug-in passes the verification;

[0087] The data maintenance rule module is used to determine the data range that needs to be maintained in the database based on the maintenance business configuration information, and process the data within the data range according to the data extracted by the script parser. Here, the maintenance business configuration information can be specifically provided by the business maintenance configuration module of the data layer, wherein the maintenance business configuration information in the business maintenance configuration module is the information (such as scripts, script execution logic, rules, etc.) written by the user based on the controls (such as the aforementioned second controls) in the visual operation interface.

[0088] As an optional implementation, the service layer further includes:

[0089] A process control module is used to perform process control on the business that needs to be maintained written by the user in the visual operation interface; here, the process control module can be used to control the activation / deactivation status of each business, for example;

[0090] The execution management module is used to manage the services that need to be maintained. Here, the execution management module is used to manage the services that can be executed by the data maintenance tool (ie, the services that have been approved), for example, the validity period of the services that can be executed.

[0091] In the above optional implementation method, by setting the process control module and the execution management module, it is possible to manage the business that uses the data maintenance tool for data management as needed. For example, the status of a business that has not been maintained for a long time can be adjusted to be disabled or deleted; or, the validity period of each business can be monitored, etc., to achieve flexible configuration of the business that needs to be maintained.

[0092] As an optional implementation, the data layer further includes:

[0093] A business maintenance configuration module, the business maintenance configuration module is used to provide data maintenance configuration information to the service layer, and the service layer maintains the data in the database based on the data maintenance configuration information, wherein the business maintenance configuration information includes business rules and execution logic of the business rules.

[0094] In the above optional implementation, the business maintenance configuration information may be information used to be input based on the second control, wherein the data maintenance tool further includes a sub-operation interface associated with the second control, such as Figure 6 As shown, the sub-operation interface associated with the second control includes a data maintenance basic information area and multiple SQL statement setting areas; wherein the data maintenance basic information area has: data maintenance name control, business category control, error category control, query control, execution control and process code control, etc.; each SQL statement setting area has: process code control, SQL type control, stop and start status control, SQL statement control, SQL parameter value control and at least one of the remarks control.

[0095] As an optional implementation, the data maintenance tool supports at least one update mode of a single table update, a multi-table update, and a batch update of a database.

[0096] The sample code for updating a single table is: update ttt set field1=? Where field2=? andfield3=?

[0097] The sample code for multi-table update is:

[0098] update ttt set field1=? Where field2=? and field3=?

[0099] update ttt2 set field1=? Where field2=? and field3=?

[0100] For batch updates, for example, it can be customer address modification, batch adding of customer address information, modifying customer status, etc. Here, take batch adding of user addresses as an example to illustrate:

[0101] First, based on the operation of the first control, determine the business data that needs to be maintained, and then create Figure 7 The page shown in the figure includes labels or text boxes such as process code, start and stop status, sql type, delete, save, sql1 statement, table name 1, sql1 field 1, Chinese field description 1, etc.; secondly, in the Figure 8 In the page shown, write the script for data maintenance name and editing batch user addresses.

[0102] In addition, the data maintenance tool also supports dependent updates or complex updates, etc.; wherein:

[0103] The sample code for dependency update is:

[0104] Select field1,field2 from ttt where field2=? ;

[0105] Update ttt2 set field3=? Where filed4=field1 and filed5=field2;

[0106] The sample code for complex update is:

[0107] Select field1,field2 from ttt where field2=? ;

[0108] Select fielda,fieldb from ttt2 Where filed4=field1 and filed5=field2;

[0109] Update ttt3 set field3=? Where filed8=fielda and filed9=fieldb;

[0110] Among them, the above-mentioned update methods belong to the category of directional business processing. The data maintenance tool of the embodiment of the present application also supports non-directional business processing, wherein the non-directional business processing includes dependent update, and its sample code is:

[0111] Select field1,field2 from ttt where field2=? ;

[0112] If (whether to process data) {

[0113] Update ttt2 set field3=? Where filed4=field1 and filed5=field2;

[0114] }.

[0115] When using the data maintenance tool of the above embodiment of the present application for data maintenance, the system operation and maintenance personnel only need to add the business processing scripts with high frequency of daily data maintenance to the data maintenance tool. After the configuration is completed, the daily data maintenance work can be completed uniformly through the interface, without the need to directly log in to the database for storage operations, which simplifies the operation and maintenance process and reduces the workload of the operation and maintenance personnel. Among them, the above data maintenance tool can solve daily system data maintenance problems, such as: data fault query and location, data-oriented fault handling, business-oriented fault handling, batch similar business fault handling, data or business configuration management, data maintenance data audit, data attribution authority, etc.

[0116] Here, the development process of the above data maintenance tool is briefly described: first, sort out the high-frequency maintenance business and the corresponding tables and operations; second, analyze the system interaction and design the corresponding data flow diagram and data model; third, compile the corresponding business rules; then, complete the corresponding script configuration; complete the corresponding rule loader and validator; and complete the corresponding log module processing; finally, form a unified data maintenance tool operation interface.

[0117] The embodiment of the present application also provides a data maintenance method, which is a method for performing data maintenance using the data maintenance tool as described above. Fig. 9 As shown, the method includes:

[0118] Step 901, receiving a first operation of a user on a visual operation interface;

[0119] Step 902: Maintain the database according to the maintenance service configuration information corresponding to the first operation and the data in the file corresponding to the first operation.

[0120] In the data maintenance method of the embodiment of the present application, first, a first operation of the user in the visual operation interface is received; secondly, the database is maintained according to the maintenance business configuration information corresponding to the first operation and the data in the file corresponding to the first operation. In this way, the user only needs to perform the corresponding operation in the visual operation interface, and the data maintenance tool background can maintain the database based on the operation. In this way, the user does not need to directly enter the database, which avoids the risk of database abnormalities and simplifies the data maintenance process, making the operation and maintenance work more standardized and convenient.

[0121] As an optional implementation, step 902 includes:

[0122] Performing format verification on parameters in the file corresponding to the first operation; this step is specifically implemented by a verification plug-in in the service layer of the data maintenance tool;

[0123] When the verification is passed, the database is maintained according to the maintenance business configuration information corresponding to the first operation and the data in the file corresponding to the first operation; this step is specifically implemented by the script parser and the data maintenance rule module in the service layer of the data maintenance tool.

[0124] As a specific implementation manner, maintaining the database according to the maintenance service configuration information corresponding to the first operation and the data in the file corresponding to the first operation includes:

[0125] Parse the file to obtain the data in the file; this step is specifically implemented by a script parser;

[0126] According to the business rules in the maintenance business configuration information, determine the data range that needs to be maintained in the database; in this step, the maintenance business configuration information is provided by the business maintenance configuration module of the data layer, and this step is implemented by the data maintenance rule module;

[0127] The data range is maintained according to the execution logic of the business rule in the maintenance business configuration information, the business rule and the data. This step is specifically implemented by a data maintenance rule module.

[0128] Furthermore, as an optional implementation, the method further includes:

[0129] Receive a second operation of the user on the visual operation interface, where the second operation is an operation on a second control related to the maintenance service configuration; this step is used to configure configuration information of the maintenance service / data;

[0130] In response to the second operation, maintenance service configuration information is configured in the sub-operation interface associated with the second control, wherein the maintenance service configuration information includes service rules and execution logic of the service rules.

[0131] The above optional implementation method is the process of configuring relevant information for newly added services that require data maintenance tools. Later, the configured information can be directly used for maintenance of the service, so that the operation and maintenance personnel do not need to write scripts for each service maintenance, which simplifies the maintenance process and reduces the workload of the operation and maintenance personnel.

[0132] Further, as an optional implementation, after step 902, the method further includes:

[0133] A maintenance log is generated in relation to the updating process of the database.

[0134] In the above optional implementation, by generating and saving a maintenance log, it is convenient for operation and maintenance personnel to view the data maintenance process based on the fourth control in the visual operation interface.

[0135] In the data maintenance method of the embodiment of the present application, the data flow during data maintenance is as follows: first, data maintenance input, that is, the user writes the parameters involved in data maintenance (for example, the parameters contained in the file) through the visual operation interface; second, the data maintenance tool obtains the business processing rules, for example, when this data maintenance is not the first maintenance, the pre-stored business processing rules related to this data maintenance task are obtained, and when this data maintenance is the first maintenance, the business processing rules accessed by the user through the visual operation interface are obtained (for example, based on the rules written in the second control); third, the data maintenance tool performs data maintenance business processing based on the obtained parameters and business processing rules; finally, the data processing result information is displayed.

[0136] Next, taking the use of the data maintenance tool of the embodiment of the present application to maintain the data of the call center system as an example, the working process of the operation and maintenance personnel using the data maintenance tool of the embodiment of the present application is explained.

[0137] Here, it should be explained that the call center system is a comprehensive information management system that accepts various questions from customers calling from various channels and provides interactive voice response (IVR) telephone voice navigation function, customer evaluation, telephone recording function, work order management, customer information management and other functions.

[0138] After the data maintenance tool of the embodiment of the present application has been put into use for a period of time, the operation and maintenance personnel have integrated and sorted out the daily data maintenance work, sorting out the maintenance work with frequent daily maintenance tasks and a lot of data updates. Some of the core businesses included are shown in Table 1 below, and some of the high-frequency maintenance businesses included are shown in Table 2 below:

[0139] Table 1 Part of the core business table

[0140]

[0141]

[0142] Table 2 Part of high-frequency maintenance business table

[0143]

[0144]

[0145] Based on the above content, the process of data processing by the data maintenance tool of the embodiment of the present application is as follows:

[0146] High-frequency maintenance services and corresponding processing logic are managed and configured through maintenance tools. Next time, similar services are performed, data can be updated and maintained through the data maintenance tool interface, which can effectively reduce workload and errors and ensure the effectiveness and efficiency of work.

[0147] The specific implementation and processing process are as follows:

[0148] Step 1: Use the high-frequency maintenance job control at the WEB layer of the data maintenance tool interface to create the high-frequency maintenance jobs sorted out in the early stage according to the page operation prompts;

[0149] Step 2: Use the second control related to the maintenance business configuration on the WEB layer of the data maintenance tool interface to complete the writing and creation of the tables, business logic, and business processing SQL corresponding to the high-frequency maintenance operations according to the page operation prompts, and perform self-verification of the corresponding scripts and logic. If there are no problems, proceed to step 3;

[0150] Step 3: This step mainly involves publishing and reviewing the high-frequency maintenance jobs created by the data maintenance tool. After the review is passed, the jobs can be displayed and used on the WEB layer of the data maintenance tool interface.

[0151] The specific usage process is as follows:

[0152] Take adding user address information in batches as an example:

[0153] A certain operator recently implemented grid management, which required sorting out the user addresses within the grid and adjusting and adding information to the user addresses in batches and stages. This work involves irregular data processing and maintenance, and the workload is large and irregular.

[0154] When system operation and maintenance personnel receive such tasks, they can handle them through data maintenance tools.

[0155] Log in to the data maintenance tool, enter the third control page related to the WEB layer page and query whether there is a corresponding maintenance business. If so, you can check the corresponding detailed information and whether the script is adapted.

[0156] If applicable, click the execution link corresponding to this data maintenance job page, and import the added user address information provided by the customer into the system through the system page according to the page prompts;

[0157] After receiving the execution task, the system will perform corresponding verification, script analysis and script execution. The maintenance personnel only need to wait for the final execution of the system. Specifically, the system will automatically execute the script according to the corresponding business rules in the early stage to complete the update and maintenance of the overall data.

[0158] If the business related to the maintenance business query is not found through the third control of the WEB layer page maintenance, create a maintenance task according to the previous steps one to three. After the creation is approved, execute it according to the above description.

[0159] Those skilled in the art will understand that all or part of the steps to implement the above embodiments may be accomplished by hardware, or may be accomplished by instructing relevant hardware through a computer program, wherein the computer program includes instructions for executing part or all of the steps of the above method; and the computer program may be stored in a readable storage medium, and the storage medium may be any form of storage medium.

[0160] In addition, it should be noted that in the device and method of the present application, it is obvious that each component or each step can be decomposed and / or recombined. These decompositions and / or recombinations should be regarded as equivalent schemes of the present application. In addition, the steps of performing the above-mentioned series of processes can be naturally performed in chronological order according to the order of description, but it is not necessary to perform in chronological order, and some steps can be performed in parallel or independently of each other. For those of ordinary skill in the art, it is possible to understand that all or any steps or components of the method and device of the present application can be implemented in any computing device (including processors, storage media, etc.) or a network of computing devices with hardware, firmware, software or a combination thereof, which can be realized by those of ordinary skill in the art using their basic programming skills after reading the description of the present application.

[0161] Therefore, the purpose of the present application can also be achieved by running a program or a group of programs on any computing device. The computing device can be a well-known general device. Therefore, the purpose of the present application can also be achieved by simply providing a program product containing a program code that implements the method or device. That is to say, such a program product also constitutes the present application, and the storage medium storing such a program product also constitutes the present application. Obviously, the storage medium can be any well-known storage medium or any storage medium developed in the future. It should also be pointed out that in the device and method of the present application, it is obvious that each component or each step can be decomposed and / or recombined. These decompositions and / or recombinations should be regarded as equivalent schemes of the present application. In addition, the steps of performing the above-mentioned series of processing can naturally be performed in chronological order according to the order of description, but it is not necessary to perform them in chronological order. Some steps can be performed in parallel or independently of each other.

[0162] The above is a preferred embodiment of the present application. It should be pointed out that for ordinary technicians in this technical field, several improvements and modifications can be made without departing from the principles described in the present application. These improvements and modifications should also be regarded as the scope of protection of the present application.

Claims

1. A data maintenance tool, characterized in that: include: A network WEB layer, a service layer coupled to the WEB layer, and a data layer coupled to the service layer; The WEB layer is used to provide a visual operation interface for users, and the service layer is used to maintain the database in the data layer by performing business rule logic processing according to the user's operations on the visual operation interface.

2. The data maintenance tool according to claim 1, characterized in that: The visual operation interface has one or more of: a first control related to data maintenance, a second control related to maintenance service configuration, a third control related to maintenance service query, and a fourth control related to maintenance log.

3. The data maintenance tool according to claim 2, characterized in that: The first control includes: a business data maintenance control and a high-frequency maintenance operation control.

4. The data maintenance tool according to claim 3, characterized in that: The database also includes: a first form, wherein the first form is related to the first control and the third control; a second form, the second form being associated with the fourth control; a third form, the third form being related to the second control; a fourth form, wherein the fourth form is related to the first control; A fifth form, wherein the fifth form is used to associate the first form with the fourth form.

5. The data maintenance tool according to claim 4, characterized in that: The first form includes at least one of a business number field, a creation time field, a business maintenance category field, a business maintenance start status field, a business maintenance name field, a business maintenance brief description field, a business process number field, an editor field, a business maintenance operation field, and a remarks field; The second form includes at least one of a log number field, a business number field, an operator field, an operation time field, an input parameter field, a business parameter field, an execution result field, and a remarks field; The third form includes at least one of a rule number field, a process number field, a parameter number field, a parameter type field, a parameter constraint field, a parameter constraint condition field, and a remark field; The fourth form includes at least one of a process number field, a structured query language sql type field, a sql statement field, a parameter chain field, a description chain field, a result name field, a transaction status field, a description field, an editor field, and a remarks field; The fifth form includes at least one of a relationship code field, a business number field, a process number field, and a dependency order field.

6. The data maintenance tool according to claim 2, characterized in that: The sub-operation interface associated with the second control is used to set the data maintenance business rule script, and the sub-operation interface includes multiple SQL statement setting areas, wherein the SQL statement setting area has at least one of: process number control, SQL type control, deactivation status control, modification control, modification parameter rule control, cancel control, confirmation control, SQL statement control, SQL parameter control, Chinese name control and remarks control.

7. The data maintenance tool according to claim 1, characterized in that: The service layer includes: A verification plug-in, used to verify the format of the parameters in the file provided by the WEB layer; A script parser, used to parse the file and extract data from the file if the verification plug-in passes the verification; The data maintenance rule module is used to determine the data range that needs to be maintained in the database based on the maintenance business configuration information, and process the data within the data range according to the data extracted by the script parser.

8. The data maintenance tool according to claim 1 or 7, characterized in that: The service layer also includes: A process control module is used to perform process control on the business that needs to be maintained written by the user in the visual operation interface; The execution management module is used to manage the business that needs to be maintained.

9. The data maintenance tool according to claim 1, characterized in that: The data layer also includes: A business maintenance configuration module, the business maintenance configuration module is used to provide data maintenance configuration information to the service layer, and the service layer maintains the data in the database based on the data maintenance configuration information, wherein the business maintenance configuration information includes business rules and execution logic of the business rules.

10. The data maintenance tool according to claim 1, characterized in that: The data maintenance tool supports at least one update mode of a single table update, a multi-table update and a batch update of a database.

11. A data maintenance method, characterized in that: Using the data maintenance tool according to any one of claims 1 to 10, the method comprises: Receiving a first operation of the user on the visual operation interface; The database is maintained according to the maintenance service configuration information corresponding to the first operation and the data in the file corresponding to the first operation.

12. The method according to claim 11, characterized in that Maintaining a database according to the maintenance service configuration information corresponding to the first operation and the data in the file corresponding to the first operation includes: Performing format check on parameters in the file corresponding to the first operation; When the verification is passed, the database is maintained according to the maintenance service configuration information corresponding to the first operation and the data in the file corresponding to the first operation.

13. The method according to claim 11 or 12, characterized in that: Maintaining a database according to the maintenance service configuration information corresponding to the first operation and the data in the file corresponding to the first operation includes: Parsing the file to obtain data in the file; Determining the data range that needs to be maintained in the database according to the business rules in the maintenance business configuration information; The data range is maintained according to the execution logic of the business rule in the maintenance business configuration information, the business rule and the data.

14. The method according to claim 11, characterized in that The method further comprises: receiving a second operation of the user on the visual operation interface, where the second operation is an operation on a second control related to the maintenance service configuration; In response to the second operation, maintenance service configuration information is configured in the sub-operation interface associated with the second control, wherein the maintenance service configuration information includes service rules and execution logic of the service rules.

15. The method according to claim 11, characterized in that After maintaining the database according to the business rules corresponding to the first operation and the data in the file corresponding to the first operation, the method further includes: A maintenance log is generated in relation to the updating process of the database.

Images