CN112364048A - Data processing method and device, electronic equipment and computer storage medium - Google Patents
Data processing method and device, electronic equipment and computer storage medium Download PDFInfo
- Publication number
- CN112364048A CN112364048A CN202011247157.6A CN202011247157A CN112364048A CN 112364048 A CN112364048 A CN 112364048A CN 202011247157 A CN202011247157 A CN 202011247157A CN 112364048 A CN112364048 A CN 112364048A
- Authority
- CN
- China
- Prior art keywords
- user
- file
- data
- edited
- parameter
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 21
- 238000012986 modification Methods 0.000 claims abstract description 43
- 230000004048 modification Effects 0.000 claims abstract description 43
- 238000000034 method Methods 0.000 claims abstract description 32
- 238000012545 processing Methods 0.000 claims description 17
- 238000004590 computer program Methods 0.000 claims description 5
- 238000012795 verification Methods 0.000 claims description 2
- 238000012423 maintenance Methods 0.000 description 7
- 230000008569 process Effects 0.000 description 7
- 238000013523 data management Methods 0.000 description 6
- 238000007726 management method Methods 0.000 description 6
- 238000010586 diagram Methods 0.000 description 4
- 238000013515 script Methods 0.000 description 4
- 238000005516 engineering process Methods 0.000 description 3
- 230000002159 abnormal effect Effects 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000004422 calculation algorithm Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 230000008570 general process Effects 0.000 description 1
- 238000002715 modification method Methods 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 230000001960 triggered effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24564—Applying rules; Deductive queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- User Interface Of Digital Computer (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application discloses a data processing method and device, electronic equipment and a computer storage medium, wherein the method comprises the following steps: when receiving a query instruction, checking whether a parameter interface file currently edited by a user accords with a parameter editing rule; the parameter interface file at least comprises a data item to be inquired and an expected value; if the parameter interface file is verified to be in accordance with the parameter editing rule, generating a query statement by using each parameter in the parameter interface file; the query statements are respectively issued to each designated pipe-receiving machine in the target IP file; the target IP file comprises IP information of a plurality of the pipe machines; receiving data corresponding to the data items to be inquired fed back by each pipe machine, and displaying the data to a user; if a modification instruction issued by a user is received, modifying the data corresponding to the data item to be inquired in each managed machine to be modified into an appointed modification value; the to-be-modified pipe-to-be-modified machine is the pipe-to-be-modified machine in which the feedback data in the pipe-to-be-modified machine is not equal to the expected value.
Description
Technical Field
The present application relates to the field of data processing technologies, and in particular, to a data processing method and apparatus, an electronic device, and a computer storage medium.
Background
With the increase of data volume and the increase of importance of data, many enterprises or institutions, etc. today have multiple devices installed, so as to deploy multiple databases for storing the generated large amount of data, and how to maintain the devices effectively is very critical.
In the current maintenance mode of the device, the target device is mainly logged in, and acquires and executes a corresponding query command input by a database administrator, so as to query a corresponding device parameter, and then feeds the device parameter back to the database administrator. If the fed back parameters are abnormal or the parameters need to be modified, the database administrator needs to manually adjust the target device, that is, the target device responds to the modification operation of the data administrator to modify the abnormal data or the data to be modified.
However, because the number of the devices is large, each device needs to log in separately for query, and needs to be modified manually separately, the maintenance method is extremely inefficient, and different administrators may have different parameter understandings, so that the maintenance of each device cannot guarantee the unification of device parameters.
Disclosure of Invention
Based on the defects of the prior art, the application provides a data processing method and device, electronic equipment and a computer storage medium, so as to solve the problems that the existing data maintenance mode is extremely low in efficiency and the unification of parameters cannot be guaranteed.
In order to achieve the above object, the present application provides the following technical solutions:
a first aspect of the present application provides a data processing method, including:
when receiving a query instruction, checking whether a parameter interface file currently edited by a user accords with a parameter editing rule; the parameter interface file at least comprises a data item to be queried edited by the user and an expected value;
if the parameter interface file is verified to be in accordance with the parameter editing rule, generating a query statement by using each parameter in the parameter interface file;
the query statements are respectively sent to each designated pipe-receiving machine in the target IP file; the target IP file comprises IP information of a plurality of pipe machines;
receiving data corresponding to the data items to be inquired fed back by each pipe machine, and displaying the data to the user;
if a modification instruction issued by the user is received, modifying the data corresponding to the data item to be inquired in each managed machine to be modified into an appointed modification value; wherein the to-be-modified pipe machine is the pipe machine with the data fed back in the pipe machine not equal to the expected value.
Optionally, in the data processing method provided above, after receiving the query instruction, the method further includes:
judging whether the IP file edited by the user exists or not;
if the IP file edited by the user does not exist, determining a full amount of IP files as the target IP file; the system comprises a receiving terminal, a management terminal and a management server, wherein the full-amount IP file is pre-deployed and comprises IP information of all managed machines;
if the IP file edited by the user exists, checking whether the IP file edited by the user accords with an IP editing rule;
if the IP file edited by the user accords with the IP editing rule, determining the IP file edited by the user as the target IP file;
if the IP file edited by the user does not accord with the IP editing rule, prompting the user to modify the IP file edited by the user, and returning to execute the check whether the IP file edited by the user accords with the IP editing rule after the user modifies the IP file edited by the user.
Optionally, in the data processing method provided above, before verifying whether the parameter interface file currently edited by the user meets the parameter editing rule, the method further includes:
judging whether a parameter interface file currently edited by the user exists;
if the parameter interface file edited by the user currently does not exist, prompting the user to edit the parameter interface file;
and if the parameter interface file currently edited by the user exists, executing the verification to check whether the parameter interface file currently edited by the user accords with the parameter editing rule.
Optionally, in the data processing method provided above, the receiving data corresponding to the data item to be queried and fed back by each of the pipe machines, and displaying the data to the user includes:
receiving a query result obtained after the query statement is executed and fed back by each managed machine;
analyzing the query results respectively to obtain data corresponding to the data items to be queried, which are queried by the pipe machine;
dividing each of the data into an expected result and an unexpected result based on a comparison result of each of the data with the expected value; wherein each of the data in the expected result is equal to the expected value and each of the data in the undesired result is not equal to the expected value;
and respectively displaying the expected result and the unexpected result to the user.
Optionally, in the data processing method provided above, after modifying the data corresponding to the data item to be queried in each to-be-modified managed machine to a specified modification value, the method further includes:
and respectively issuing the query statements to each designated managed machine in the target IP file, receiving data corresponding to the data items to be queried fed back by each managed machine, and displaying the data to the user.
A second aspect of the present application provides a data processing apparatus comprising:
the first checking unit is used for checking whether the parameter interface file edited by the user currently conforms to the parameter editing rule or not when the inquiry instruction is received; the parameter interface file at least comprises a data item to be queried edited by the user and an expected value;
the statement generating unit is used for generating query statements by utilizing various parameters in the parameter interface file when the first checking unit checks that the parameter interface file conforms to the parameter editing rule;
the issuing unit is used for respectively issuing the query sentences to each designated managed machine in the target IP file; the target IP file comprises IP information of a plurality of pipe machines;
the data feedback unit is used for receiving data corresponding to the data item to be inquired and fed back by each pipe machine and displaying the data to the user;
the modification unit is used for modifying the data corresponding to the data items to be inquired in each to-be-modified pipe machine into a specified modification value if receiving a modification instruction issued by the user; wherein the to-be-modified pipe machine is the pipe machine with the data fed back in the pipe machine not equal to the expected value.
Optionally, in the data processing apparatus provided above, further comprising a file determining unit, wherein the file determining unit includes:
a first judging unit, configured to judge whether an IP file edited by the user exists;
a first determining unit, configured to determine, when the first determining unit determines that the IP file edited by the user does not exist, a full IP file as the target IP file; the system comprises a receiving terminal, a management terminal and a management server, wherein the full-amount IP file is pre-deployed and comprises IP information of all managed machines;
the second checking unit is used for checking whether the IP file edited by the user accords with an IP editing rule or not when the first judging unit judges that the IP file edited by the user exists;
a second determining unit, configured to determine, when the check unit checks that the IP file edited by the user conforms to an IP editing rule, the IP file edited by the user as the target IP file;
and the prompting unit is used for prompting the user to modify the IP file edited by the user when the second checking unit checks that the IP file edited by the user does not conform to the IP editing rule, and returning to the second checking unit to execute the check whether the IP file edited by the user conforms to the IP editing rule after the user modifies the IP file edited by the user.
Optionally, in the data processing apparatus provided above, further comprising:
the second judging unit is used for judging whether a parameter interface file edited by the user currently exists or not;
the second prompting unit is used for prompting the user to edit the parameter interface file when the second judging unit judges that the parameter interface file edited by the user currently does not exist;
if the second judging unit judges that the parameter interface file edited by the user currently exists, the first verifying unit executes to verify whether the parameter interface file edited by the user currently conforms to the parameter editing rule.
Optionally, in the data processing apparatus provided above, the data feedback unit includes:
the receiving unit is used for receiving the query result obtained after the query statement is executed and fed back by each of the managed machines;
the analysis unit is used for analyzing the query results respectively to obtain data which are queried by the pipe machine and correspond to the data items to be queried;
a classification unit configured to classify each of the data into an expected result and an unexpected result based on a comparison result of each of the data with the expected value; wherein each of the data in the expected result is equal to the expected value and each of the data in the undesired result is not equal to the expected value;
and the display unit is used for respectively displaying the expected result and the unexpected result to the user.
Optionally, in the data processing apparatus provided above, after modifying the data corresponding to the data item to be queried in each data to be modified by the pipe machine to a specified modification value, the method further includes:
and the modified result query unit is used for respectively sending the query statement to each designated managed machine in the target IP file again, receiving data corresponding to the data item to be queried and fed back by each managed machine, and displaying the data to the user.
A third aspect of the present application provides an electronic device comprising:
a memory and a processor;
wherein the memory is used for storing programs;
the processor is configured to execute the program, and when the program is executed, the program is specifically configured to implement the data processing method according to any one of the above items.
A fourth aspect of the present application provides a computer storage medium for storing a computer program which, when executed, is adapted to implement a data processing method as claimed in any one of the preceding claims.
The application provides a data processing method, and a user can realize data processing by editing a parameter interface file at least comprising a data item to be inquired and an expected value edited by the user. Specifically, when a query instruction is received, whether a parameter interface file currently edited by a user accords with a parameter editing rule is verified, and if the parameter interface file accords with the parameter editing rule, a query statement is generated by using each parameter in the parameter interface file; and then, the query statements are respectively issued to each specified managed machine in the target IP file, so that batch query is realized. And then, the data corresponding to the data items to be inquired fed back by each managed machine can be received, and the data are displayed to the user. And if a modification instruction issued by a user is received, modifying the data corresponding to the data items to be inquired in each to-be-modified managed machine into an appointed modification value, wherein the to-be-modified managed machine is a managed machine in which the data fed back by the to-be-modified managed machine is not equal to the expected value, so that batch modification of the data is realized, the uniformity of equipment parameters is ensured, and the maintenance efficiency is improved.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly introduced below, it is obvious that the drawings in the following description are only embodiments of the present application, and for those skilled in the art, other drawings can be obtained according to the provided drawings without creative efforts.
Fig. 1 is a schematic flowchart of a method for constructing a data management system according to an embodiment of the present application;
fig. 2 is a schematic flowchart of a data processing method according to another embodiment of the present application;
fig. 3 is a schematic flowchart of a method for determining a target IP file according to another embodiment of the present application;
fig. 4 is a flowchart illustrating a method for feeding back query data according to another embodiment of the present application;
fig. 5 is a schematic structural diagram of a data processing apparatus according to another embodiment of the present application;
fig. 6 is a schematic structural diagram of a file determining unit according to another embodiment of the present application;
fig. 7 is a schematic structural diagram of a data feedback unit according to another embodiment of the present application;
fig. 8 is a schematic structural diagram of an electronic device according to another embodiment of the present application.
Detailed Description
The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
In this application, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
The application provides a data processing method, which aims to solve the problems that the efficiency of the existing data maintenance mode is extremely low, and the uniformity of parameters cannot be guaranteed.
Optionally, in order to implement the data processing method provided by the present application, a data management system may be constructed in advance based on a Secure Shell (SSH).
Specifically, firstly, it may be determined that the configured management machine and the SSH public key of the managed group are authenticated and trusted, and at the same time, a default full IP file of the managed group is configured, and its compliance is checked; wherein the full IP file includes IP information for each managed machine. Then, corresponding scripts are deployed on the manager, and after the deployment of the scripts is completed, the scripts are configured under a specified directory, parameter baseline files named according to the name of the manager, and knowledge base files of all parameters supporting modification are configured. The knowledge base file comprises explanation and modification method display of each parameter, recommended values of the parameters and suggested modification values aiming at different version databases and different configuration managed machines. Furthermore, a storage directory for modifying the history file and a storage directory for reporting can be configured. Meanwhile, an editable parameter interface file and an IP file can be generated, namely a template of the parameter interface file and the IP file is generated for a user to edit
Based on the above description, the general process of constructing the data management system, as shown in fig. 1, may specifically include the following several main steps:
and S101, deploying a corresponding script on the supervisor.
S102, generating a parameter baseline file and a knowledge base file, and configuring a plurality of required catalogues.
And S103, prompting to modify the full-amount IP file.
It should be noted that, if the full IP file has not been edited, the full IP file is modified, which is essentially to edit a full IP file, and if the full IP file has been edited, the full IP file is modified, which is to modify illegal information.
And S104, detecting whether the full amount of IP files are legal or not.
If the total number of IP files is detected to be illegal, the process returns to step S103. If it is detected that the full IP file is valid, step S104 is executed.
And S105, detecting whether mutual trust between the management machine and each managed machine is successful.
If the mutual trust is not detected successfully, step S106 is executed, and if the mutual trust is detected successfully, step S107 is executed.
S106, reconfiguring mutual trust.
After step S106 is executed, the process returns to step S105.
S107, the data management system is determined to be constructed.
Based on the data management system constructed as described above, an embodiment of the present application provides a data processing method, as shown in fig. 2, which specifically includes the following steps:
s201, receiving an inquiry instruction.
Specifically, when a user determines to query and starts to call a program, a query instruction is triggered correspondingly.
It should be noted that, before determining the query, the user needs to edit the parameter interface file. The user can edit on the generated editable parameter interface file when the system is built. The parameter interface file at least comprises a data item to be queried edited by a user and an expected value, namely at least comprises content to be queried by the user and a query result expected to be obtained. Specifically, after the user inputs parameters such as a data item to be queried and an expected value, the parameters input by the user are filled into a parameter interface file template, and a parameter interface file currently edited by the user is generated.
Since the user has to edit the query before performing the query, before performing step S202, the following steps may be further performed: and judging whether the parameter interface file currently edited by the user exists.
If the parameter interface file edited by the user currently does not exist, prompting the user to edit the parameter interface file; if it is determined that the parameter interface file currently edited by the user exists, the step S202 may be executed.
It should be further noted that, each data processing operation is performed by default on all managed machines, that is, by default, the configured full IP file is used as the target IP file to implement data processing. Optionally, in another embodiment of the present application, the user is allowed to edit the IP file, so that the managed machine to which the operation is directed may be specified. In the embodiment of the present application, the operation is specifically performed by the pipe machine, and is implemented depending on the target IP file, so after step S201, the target IP file used in the data operation needs to be determined. Optionally, as shown in fig. 3, a method for determining a target IP file is shown, which specifically includes the following steps:
s301, traversing all IP files.
S302, judging whether the IP file edited by the user exists.
If it is determined that the IP file edited by the user does not exist, step S303 is executed. If it is determined that the IP file edited by the user exists, step S304 is executed.
S303, determining the full IP file as a target IP file.
The full IP file is pre-deployed and comprises IP information of all managed machines. A managed machine refers to a machine managed by a supervisor, on which a managed database is deployed.
S304, checking whether the IP file edited by the user accords with the IP editing rule.
Specifically, it may be checked whether each piece of IP information in the IP file is correct, that is, whether the piece of IP information is IP information of the managed machine, and whether an editing format of the IP information is correct. If it is verified that the IP file edited by the user conforms to the IP editing rule, step S305 is executed. If it is verified that the IP file edited by the user does not conform to the IP editing rule, step S306 is executed.
S305, determining the IP file edited by the user as a target IP file.
S306, prompting the user to modify the IP file edited by the user.
It should be noted that, after the user modifies the IP file edited by the user, the step S304 is returned to check whether the IP file edited by the user meets the IP editing rule.
S202, verifying whether the parameter interface file edited by the user currently conforms to the parameter editing rule.
The parameter interface file at least comprises a data item to be queried edited by a user and an expected value.
Specifically, it may be configured to use a knowledge base file configured when the data management system is constructed, check whether formats and the like of parameters in the parameter interface file are compliant, and check whether parameters in the parameter interface file are in a support modification list in the knowledge base file. If the format of any parameter is not in compliance or is not in the support modification list, determining that the parameter interface file currently edited by the user is not in compliance with the parameter editing rule, and prompting the user to modify the parameter interface file. If the parameter interface file currently edited by the user is verified to conform to the parameter editing rule, step S203 is executed.
And S203, generating a query statement by using each parameter in the parameter interface file.
Specifically, according to a preset rule, each parameter in the parameter interface file is used to generate a query statement, and then step S204 is executed.
And S204, respectively sending the query statements to each of the designated managed machines in the target IP file, wherein the target IP file comprises IP information of a plurality of managed machines.
Specifically, the query statement is issued to each managed machine according to the IP information of each managed machine in the target IP file. After each managed machine receives the query statement, the managed machine executes the query statement, queries corresponding parameters on the managed machine, namely queries data corresponding to the data item to be queried input by the user and feeds back the data.
S205, receiving data corresponding to the data items to be inquired fed back by each managed machine, and displaying the data to a user.
Optionally, in another embodiment of the present application, as shown in fig. 4, a specific implementation manner of step S205 specifically includes the following steps:
s401, receiving query results obtained after the query statements are executed and fed back by the pipe machine.
S402, analyzing the query results respectively to obtain data corresponding to the data items to be queried, which are queried by the pipe machine.
And S403, dividing each data into an expected result and an unexpected result based on the comparison result of each data and the expected value, wherein each data in the expected result is equal to the expected value, and each data in the unexpected result is not equal to the expected value.
Since the subsequent user may need to modify the data that is not equal to the expected value, in the embodiment of the present application, the fed-back data is divided into two types to be displayed, so that the user can clearly determine which data is not equal to the expected value and can be modified.
And S404, respectively displaying the expected result and the unexpected result to the user.
Specifically, the data can be displayed normally for data that is already at the expected value, and the data can be highlighted for data that is not equal to the expected value. Optionally, the modification transaction may be displayed to the user according to the knowledge base file, and the user may be prompted whether to modify the transaction.
And S206, monitoring whether a modification instruction sent by a user is received in real time.
If a modification instruction issued by the user is received, step S207 is executed.
Specifically, the user may use the suggested value given by the knowledge base file as a formulated modification value, or may modify the set specified modification value according to the requirement, and then issue a modification instruction.
Optionally, if the user does not modify according to the suggested value given by the knowledge base file, after the user issues a modification instruction, the user may be prompted again whether to determine the modification, and step S207 is executed after the user determines the modification, so as to prevent the risk caused by the manual accidental operation of the user.
S207, modifying the data corresponding to the data items to be inquired in each to-be-modified by-pipe machine into a specified modification value, wherein the to-be-modified by-pipe machine is the to-be-modified by-pipe machine with the feedback data not equal to the expected value.
It should be noted that since the designated modification value is usually a desired value, it is essential to modify a batch of data that does not belong to the desired value.
Optionally, after the data is modified, in order to let the user know about the modification, the method may further include:
and respectively issuing the query statements to each designated managed machine in the target IP file, receiving data corresponding to the data items to be queried fed back by each managed machine, and displaying the data to the user.
The user can know whether the modification result is expected according to the displayed result of the re-inquiry, so as to decide whether to quit or modify again.
The embodiment of the application provides a data processing method, and a user can realize data processing by editing a parameter interface file at least comprising a data item to be inquired and an expected value edited by the user. Specifically, when a query instruction is received, whether a parameter interface file currently edited by a user accords with a parameter editing rule is verified, and if the parameter interface file accords with the parameter editing rule, a query statement is generated by using each parameter in the parameter interface file; and then, the query statements are respectively issued to each specified managed machine in the target IP file, so that batch query is realized. And then, the data corresponding to the data items to be inquired fed back by each managed machine can be received, and the data are displayed to the user. And if a modification instruction issued by a user is received, modifying the data corresponding to the data items to be inquired in each to-be-modified managed machine into an appointed modification value, wherein the to-be-modified managed machine is a managed machine in which the data fed back by the to-be-modified managed machine is not equal to the expected value, so that batch modification of the data is realized, the uniformity of equipment parameters is ensured, and the maintenance efficiency is also improved.
Another embodiment of the present application provides a data processing apparatus, as shown in fig. 5, including the following units:
the first checking unit 501 is configured to, when receiving the query instruction, check whether a parameter interface file currently edited by the user meets a parameter editing rule.
The parameter interface file at least comprises a data item to be queried edited by a user and an expected value.
The statement generating unit 502 is configured to generate a query statement by using each parameter in the parameter interface file when the first verifying unit 501 verifies that the parameter interface file conforms to the parameter editing rule.
The issuing unit 503 is configured to issue the query statements to each managed machine specified in the target IP file.
The target IP file comprises IP information of a plurality of managed machines.
The data feedback unit 504 is configured to receive data corresponding to the data item to be queried, which is fed back by each managed machine, and display the data to the user.
And the modifying unit 505 is configured to modify, if receiving a modification instruction issued by a user, data corresponding to the data item to be queried in each managed machine to be modified to a specified modification value.
The to-be-modified pipe-to-be-modified pipe machine is the pipe-to-be-modified pipe machine, and the feedback data in the pipe-to-be-modified pipe-to.
Optionally, another embodiment of the present application provides the data processing apparatus provided above, further including a file determining unit. As shown in fig. 6, the file determination unit includes the following units:
a first judging unit 601, configured to judge whether there is an IP file edited by a user.
A first determining unit 602, configured to determine the full IP file as the target IP file when the first judging unit 601 judges that there is no IP file edited by the user.
The full IP file is pre-deployed and comprises IP information of all managed machines.
A second checking unit 603 configured to check whether the IP file edited by the user complies with the IP editing rule when the first judging unit 601 judges that the IP file edited by the user exists.
A second determining unit 604, configured to determine the IP file edited by the user as a target IP file when the check unit 603 checks that the IP file edited by the user conforms to the IP editing rule.
A prompting unit 605, configured to prompt the user to modify the IP file edited by the user when the second checking unit 603 checks that the IP file edited by the user does not conform to the IP editing rule, and return to the second checking unit 603 to perform checking whether the IP file edited by the user conforms to the IP editing rule after the user modifies the IP file edited by the user.
Optionally, in a data processing apparatus provided in another embodiment of the present application, the apparatus further includes the following unit:
and the second judging unit is used for judging whether the parameter interface file edited by the user currently exists.
And the second prompting unit is used for prompting the user to edit the parameter interface file when the second judging unit judges that the parameter interface file edited by the user currently does not exist.
If the second judging unit judges that the parameter interface file edited by the user currently exists, the first verifying unit verifies whether the parameter interface file edited by the user currently conforms to the parameter editing rule.
Optionally, in a data processing apparatus provided in another embodiment of the present application, a data feedback unit, as shown in fig. 7, includes the following units:
the receiving unit 701 is configured to receive a query result obtained after each query statement is executed and fed back by the pipelayer.
And the analyzing unit 702 is configured to analyze the query results respectively to obtain data corresponding to the data items to be queried, which are queried by the pipe machine.
A classification unit 703 for classifying the respective data into an expected result and an unexpected result based on the comparison result of the respective data with the expected value.
Wherein each data in the expected result is equal to the expected value and each data in the undesired result is not equal to the expected value.
And a presentation unit 704 for presenting the expected result and the unexpected result to the user, respectively.
Optionally, in the data processing apparatus provided above, after modifying data corresponding to the data item to be queried in each managed machine to be modified to a specified modification value, the method further includes:
and the modified result query unit is used for respectively issuing the query statements to each designated managed machine in the target IP file again, receiving data corresponding to the data items to be queried and fed back by each managed machine, and displaying the data to the user.
It should be noted that, for the specific working processes of each unit provided in the foregoing embodiments of the present application, reference may be made to the implementation processes of corresponding steps in the foregoing method embodiments, and details are not described here again.
Another embodiment of the present application provides an electronic device, as shown in fig. 8, including:
a memory 801 and a processor 802.
The memory 801 is used for storing a program, the processor 802 is used for executing the program, and the program is specifically used for implementing the method for pushing the offer message provided by any one of the above embodiments when executed.
Another embodiment of the present application provides a computer storage medium for storing a computer program, and when the computer program is executed, the computer program is used to implement the method for pushing the offer message provided in any one of the above embodiments.
Computer storage media, including permanent and non-permanent, removable and non-removable media, may implement the information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), Static Random Access Memory (SRAM), Dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), Read Only Memory (ROM), Electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), Digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information that can be accessed by a computing device. As defined herein, computer readable media does not include transitory computer readable media (transmyedia) such as modulated data signals and carrier waves.
Those of skill would further appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware, computer software, or combinations of both, and that the various illustrative components and steps have been described above generally in terms of their functionality in order to clearly illustrate this interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present application.
The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present application. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the application. Thus, the present application is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
Claims (10)
1. A data processing method, comprising:
when receiving a query instruction, checking whether a parameter interface file currently edited by a user accords with a parameter editing rule; the parameter interface file at least comprises a data item to be queried edited by the user and an expected value;
if the parameter interface file is verified to be in accordance with the parameter editing rule, generating a query statement by using each parameter in the parameter interface file;
the query statements are respectively sent to each designated pipe-receiving machine in the target IP file; the target IP file comprises IP information of a plurality of pipe machines;
receiving data corresponding to the data items to be inquired fed back by each pipe machine, and displaying the data to the user;
if a modification instruction issued by the user is received, modifying the data corresponding to the data item to be inquired in each managed machine to be modified into an appointed modification value; wherein the to-be-modified pipe machine is the pipe machine with the data fed back in the pipe machine not equal to the expected value.
2. The method of claim 1, wherein after receiving the query instruction, further comprising:
judging whether the IP file edited by the user exists or not;
if the IP file edited by the user does not exist, determining a full amount of IP files as the target IP file; the system comprises a receiving terminal, a management terminal and a management server, wherein the full-amount IP file is pre-deployed and comprises IP information of all managed machines;
if the IP file edited by the user exists, checking whether the IP file edited by the user accords with an IP editing rule;
if the IP file edited by the user accords with the IP editing rule, determining the IP file edited by the user as the target IP file;
if the IP file edited by the user does not accord with the IP editing rule, prompting the user to modify the IP file edited by the user, and returning to execute the check whether the IP file edited by the user accords with the IP editing rule after the user modifies the IP file edited by the user.
3. The method of claim 1, wherein before verifying whether the parameter interface file currently edited by the user complies with the parameter editing rule, the method further comprises:
judging whether a parameter interface file currently edited by the user exists;
if the parameter interface file edited by the user currently does not exist, prompting the user to edit the parameter interface file;
and if the parameter interface file currently edited by the user exists, executing the verification to check whether the parameter interface file currently edited by the user accords with the parameter editing rule.
4. The method according to claim 1, wherein the receiving data corresponding to the data item to be queried, which are fed back by each of the pipe machines, and presenting the data to the user comprises:
receiving a query result obtained after the query statement is executed and fed back by each managed machine;
analyzing the query results respectively to obtain data corresponding to the data items to be queried, which are queried by the pipe machine;
dividing each of the data into an expected result and an unexpected result based on a comparison result of each of the data with the expected value; wherein each of the data in the expected result is equal to the expected value and each of the data in the undesired result is not equal to the expected value;
and respectively displaying the expected result and the unexpected result to the user.
5. The method according to claim 1, wherein after the modifying the data corresponding to the data item to be queried in each data item to be modified into a specified modification value, the method further comprises:
and respectively issuing the query statements to each designated managed machine in the target IP file, receiving data corresponding to the data items to be queried fed back by each managed machine, and displaying the data to the user.
6. A data processing apparatus, comprising:
the first checking unit is used for checking whether the parameter interface file edited by the user currently conforms to the parameter editing rule or not when the inquiry instruction is received; the parameter interface file at least comprises a data item to be queried edited by the user and an expected value;
the statement generating unit is used for generating query statements by utilizing various parameters in the parameter interface file when the first checking unit checks that the parameter interface file conforms to the parameter editing rule;
the issuing unit is used for respectively issuing the query sentences to each designated managed machine in the target IP file; the target IP file comprises IP information of a plurality of pipe machines;
the data feedback unit is used for receiving data corresponding to the data item to be inquired and fed back by each pipe machine and displaying the data to the user;
the modification unit is used for modifying the data corresponding to the data items to be inquired in each to-be-modified pipe machine into a specified modification value if receiving a modification instruction issued by the user; wherein the to-be-modified pipe machine is the pipe machine with the data fed back in the pipe machine not equal to the expected value.
7. The apparatus of claim 6, further comprising a file determining unit, wherein the file determining unit comprises:
a first judging unit, configured to judge whether an IP file edited by the user exists;
a first determining unit, configured to determine, when the first determining unit determines that the IP file edited by the user does not exist, a full IP file as the target IP file; the system comprises a receiving terminal, a management terminal and a management server, wherein the full-amount IP file is pre-deployed and comprises IP information of all managed machines;
the second checking unit is used for checking whether the IP file edited by the user accords with an IP editing rule or not when the first judging unit judges that the IP file edited by the user exists;
a second determining unit, configured to determine, when the check unit checks that the IP file edited by the user conforms to an IP editing rule, the IP file edited by the user as the target IP file;
and the prompting unit is used for prompting the user to modify the IP file edited by the user when the second checking unit checks that the IP file edited by the user does not conform to the IP editing rule, and returning to the second checking unit to execute the check whether the IP file edited by the user conforms to the IP editing rule after the user modifies the IP file edited by the user.
8. The apparatus of claim 6, further comprising:
the second judging unit is used for judging whether a parameter interface file edited by the user currently exists or not;
the second prompting unit is used for prompting the user to edit the parameter interface file when the second judging unit judges that the parameter interface file edited by the user currently does not exist;
if the second judging unit judges that the parameter interface file edited by the user currently exists, the first verifying unit executes to verify whether the parameter interface file edited by the user currently conforms to the parameter editing rule.
9. An electronic device, comprising:
a memory and a processor;
wherein the memory is used for storing programs;
the processor is configured to execute the program, which when executed is specifically configured to implement the data processing method of any of claims 1 to 5.
10. A computer storage medium storing a computer program which, when executed, implements a data processing method as claimed in any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011247157.6A CN112364048B (en) | 2020-11-10 | 2020-11-10 | Data processing method and device, electronic equipment and computer storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011247157.6A CN112364048B (en) | 2020-11-10 | 2020-11-10 | Data processing method and device, electronic equipment and computer storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112364048A true CN112364048A (en) | 2021-02-12 |
| CN112364048B CN112364048B (en) | 2024-08-02 |
Family
ID=74508578
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011247157.6A Active CN112364048B (en) | 2020-11-10 | 2020-11-10 | Data processing method and device, electronic equipment and computer storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112364048B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113778551A (en) * | 2021-08-20 | 2021-12-10 | 中国南方电网有限责任公司超高压输电公司贵阳局 | Method and device for remotely modifying parameters based on multiple clients and computer equipment |
| CN114781349A (en) * | 2022-04-22 | 2022-07-22 | 重庆长安汽车股份有限公司 | Method for automatically checking software interface table for software integration of embedded controller |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101459543A (en) * | 2009-01-07 | 2009-06-17 | 浪潮通信信息系统有限公司 | System for telecommunication equipment centralized login and implementing method thereof |
| CN103023702A (en) * | 2012-12-14 | 2013-04-03 | 武汉烽火网络有限责任公司 | Method for processing batched management information bases (MIB) |
| CN103986605A (en) * | 2014-05-23 | 2014-08-13 | 杭州华三通信技术有限公司 | Network management server, processing server, network management system and corresponding method |
| CN106547600A (en) * | 2016-11-22 | 2017-03-29 | 郑州云海信息技术有限公司 | A kind of remote auto installs the method and system of whole machine cabinet host operating system |
| CN106707894A (en) * | 2017-02-24 | 2017-05-24 | 广州华胜塑料制品有限公司 | Remote monitoring system for injection molding machine and monitoring method thereof |
| CN109101812A (en) * | 2018-08-28 | 2018-12-28 | 北京神州绿盟信息安全科技股份有限公司 | A kind of parameter verification method, apparatus, computing device and storage medium |
| CN109413222A (en) * | 2018-10-24 | 2019-03-01 | 广东微云科技股份有限公司 | The orderly automatic setting method of the batch of cloud terminal and its system |
-
2020
- 2020-11-10 CN CN202011247157.6A patent/CN112364048B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101459543A (en) * | 2009-01-07 | 2009-06-17 | 浪潮通信信息系统有限公司 | System for telecommunication equipment centralized login and implementing method thereof |
| CN103023702A (en) * | 2012-12-14 | 2013-04-03 | 武汉烽火网络有限责任公司 | Method for processing batched management information bases (MIB) |
| CN103986605A (en) * | 2014-05-23 | 2014-08-13 | 杭州华三通信技术有限公司 | Network management server, processing server, network management system and corresponding method |
| CN106547600A (en) * | 2016-11-22 | 2017-03-29 | 郑州云海信息技术有限公司 | A kind of remote auto installs the method and system of whole machine cabinet host operating system |
| CN106707894A (en) * | 2017-02-24 | 2017-05-24 | 广州华胜塑料制品有限公司 | Remote monitoring system for injection molding machine and monitoring method thereof |
| CN109101812A (en) * | 2018-08-28 | 2018-12-28 | 北京神州绿盟信息安全科技股份有限公司 | A kind of parameter verification method, apparatus, computing device and storage medium |
| CN109413222A (en) * | 2018-10-24 | 2019-03-01 | 广东微云科技股份有限公司 | The orderly automatic setting method of the batch of cloud terminal and its system |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113778551A (en) * | 2021-08-20 | 2021-12-10 | 中国南方电网有限责任公司超高压输电公司贵阳局 | Method and device for remotely modifying parameters based on multiple clients and computer equipment |
| CN114781349A (en) * | 2022-04-22 | 2022-07-22 | 重庆长安汽车股份有限公司 | Method for automatically checking software interface table for software integration of embedded controller |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112364048B (en) | 2024-08-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10184882B2 (en) | System and method for providing user guidance for electronic device processing | |
| CN107896244B (en) | Version file distribution method, client and server | |
| CN110088744B (en) | Database maintenance method and system | |
| CN107092535B (en) | Method and apparatus for data storage of test interface | |
| CN110099130B (en) | Configuration updating method and device and server | |
| CN110063042B (en) | Database fault response method and terminal thereof | |
| CN112364048A (en) | Data processing method and device, electronic equipment and computer storage medium | |
| CN110941632A (en) | Database auditing method, device and equipment | |
| CN114493551A (en) | Contract generation method and device, electronic equipment and storage medium | |
| CN117762799A (en) | Test environment difference detection method and device, storage medium and electronic equipment | |
| WO2017167015A1 (en) | Method and device for server device security management and computer storage medium | |
| CN111737351A (en) | Transaction management method and device for distributed management system | |
| CN112015715A (en) | Industrial Internet data management service testing method and system | |
| CN111241547A (en) | Detection method, device and system for unauthorized vulnerability | |
| CN115757318A (en) | Log query method and device, storage medium and electronic equipment | |
| CN109412861B (en) | Method for establishing security association display of terminal network | |
| CN103036720A (en) | Maintenance method and system for telecommunications service | |
| CN115860696B (en) | Electronic job ticket management method and system based on block chain | |
| CN113609162B (en) | Query method and device for operation records, server and storage medium | |
| US20230102816A1 (en) | Automatic updating of application functionality | |
| CN109408270B (en) | Read-write operation processing method and device | |
| CN115982780A (en) | File detection method and device, electronic equipment and storage medium | |
| CN118689529A (en) | Parameter configuration method, system, device and medium for application service | |
| CN117874833A (en) | Non-invasive electronic signature method, equipment and medium for EPR system | |
| CN117033476A (en) | Data aggregation method, device and medium for region |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |