CN112131247A - Method and device for safety isolation of host data query - Google Patents
Method and device for safety isolation of host data query Download PDFInfo
- Publication number
- CN112131247A CN112131247A CN202011066121.8A CN202011066121A CN112131247A CN 112131247 A CN112131247 A CN 112131247A CN 202011066121 A CN202011066121 A CN 202011066121A CN 112131247 A CN112131247 A CN 112131247A
- Authority
- CN
- China
- Prior art keywords
- host system
- production data
- text
- data query
- keyboard
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- 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/21—Design, administration or maintenance of databases
- G06F16/217—Database tuning
-
- 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/2453—Query optimisation
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Mathematical Physics (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The invention provides a method and a device for safety isolation of host data query, wherein the method comprises the following steps: compiling a query SQL statement according to the production data query task, and determining an operation text; determining a simulation manual operation script according to the production data query task; simulating keyboard operation to generate a keyboard operation instruction according to the simulated manual operation script and the operation text; and sending the keyboard operation instruction to the host system, inquiring production data and storing the production data to the server. The invention isolates the production environment of the operator and the host system, so that the operator can not directly log in the host system for operation, namely, the data query can be completed, and the data query can only be performed in the host system for fixed operation; the data query based on the host can be standardized and automated, so that the working efficiency is improved, the operation safety is improved, and the automated operation of a host system is realized.
Description
Technical Field
The invention relates to the technical field of computer data processing, in particular to a method and a device for safety isolation of host data query.
Background
This section is intended to provide a background or context to the embodiments of the invention that are recited in the claims. The description herein is not admitted to be prior art by inclusion in this section.
At present, data is inquired on a host system by adopting an operation mode of manually logging in a terminal, and when the production data is inquired on the host system, an operator needs to log in the terminal of the host system and operate the terminal by using a command line.
The operation of directly logging in the host needs to be familiar to the host operating system, and an operator needs additional training to log in the host for operation.
The operation of directly logging in a host system is a relatively high risk. And the manual login of the host system cannot control which instructions are input by an operator. The operator submitting an erroneous instruction, or submitting a performance affecting job, can affect the financial transaction. This mode of operation can be subject to operator error, leading to potential risk of production failure.
Therefore, how to provide a new solution, which can solve the above technical problems, is a technical problem to be solved in the art.
Disclosure of Invention
The embodiment of the invention provides a method for safely isolating host data query, which isolates an operator from the production environment of a host system, so that the operator can not directly log in the host system to operate, namely, the data query can be completed, the data query can only be performed on the host system in a fixed operation mode, and the method comprises the following steps:
compiling a query SQL statement according to the production data query task, and determining an operation text;
determining a simulation manual operation script according to the production data query task;
simulating keyboard operation to generate a keyboard operation instruction according to the simulated manual operation script and the operation text;
and sending the keyboard operation instruction to the host system, inquiring production data and storing the production data to the server.
The embodiment of the invention also provides a device for the safety isolation of the data query of the host, which comprises the following components:
the job text determining module is used for compiling query SQL sentences according to the production data query tasks and determining job texts;
the simulation manual operation script determining module is used for determining a simulation manual operation script according to the production data query task;
the keyboard operation instruction generation determining module is used for simulating keyboard operation to generate a keyboard operation instruction according to the simulated manual operation script and the operation text;
and the production data query module is used for sending the keyboard operation instruction to the host system, and querying and storing the production data to the server.
The embodiment of the invention also provides computer equipment which comprises a memory, a processor and a computer program which is stored on the memory and can run on the processor, wherein the processor executes the computer program to realize the method for the host data query security isolation.
An embodiment of the present invention further provides a computer-readable storage medium, where a computer program for executing the above method for host data query security isolation is stored in the computer-readable storage medium.
According to the method and the device for the host data query safety isolation, provided by the embodiment of the invention, firstly, a query SQL statement is compiled according to a production data query task, and an operation text is determined; then, according to the production data query task, determining a simulation manual operation script; simulating keyboard operation to generate a keyboard operation instruction according to the simulated manual operation script and the operation text; and finally, sending the keyboard operation instruction to the host system, inquiring production data and storing the production data to the server. In the embodiment of the invention, an operator does not need to know the operation of the host terminal, and can generate the optimal operation text only by compiling SQL statements; recording manual single-time keyboard operation to an operation text, generating a manual operation simulation script for manual repeated operation by using a script program, reading the operation text by using the manual operation simulation script, simulating keyboard operation, realizing only fixed standard operation, and avoiding operation outside a range; the production environment of an operator and the host system is isolated, so that the operator can not directly log in the host system for operation, namely, data query can be completed, and the data query can only be performed on the host system for fixed operation; the data query based on the host can be standardized and automated, so that the working efficiency is improved, the operation safety is improved, and the automated operation of a host system is realized.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts. In the drawings:
fig. 1 is a schematic diagram of a method for security isolation of host data query according to an embodiment of the present invention.
Fig. 2 is a schematic diagram illustrating a process of determining a job text in a method for querying security isolation of host data according to an embodiment of the present invention.
Fig. 3 is a schematic diagram of a process of querying production data according to a method for querying security isolation of host data according to an embodiment of the present invention.
FIG. 4 is a schematic diagram of a computer device for executing a method for host data query security isolation according to an embodiment of the present invention.
Fig. 5 is a schematic diagram of a device for host data query security isolation according to an embodiment of the present invention.
FIG. 6 is a flowchart illustrating another embodiment of a device for host data query security isolation according to the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the embodiments of the present invention are further described in detail below with reference to the accompanying drawings. The exemplary embodiments and descriptions of the present invention are provided to explain the present invention, but not to limit the present invention.
Fig. 1 is a schematic diagram of a method for security isolation of host data query according to an embodiment of the present invention, and as shown in fig. 1, an embodiment of the present invention provides a method for security isolation of host data query, which isolates an operator from a production environment of a host system, so that the operator cannot directly log in the host system to perform operations, i.e., data query can be completed, and data query can only be performed in a fixed manner in the host system, including:
step 101: compiling a query SQL statement according to the production data query task, and determining an operation text;
step 102: determining a simulation manual operation script according to the production data query task;
step 103: simulating keyboard operation to generate a keyboard operation instruction according to the simulated manual operation script and the operation text;
step 104: and sending the keyboard operation instruction to the host system, inquiring production data and storing the production data to the server.
The embodiment of the invention provides a method for safely isolating host data query, which comprises the steps of firstly compiling query SQL sentences according to a production data query task and determining operation texts; then, according to the production data query task, determining a simulation manual operation script; simulating keyboard operation to generate a keyboard operation instruction according to the simulated manual operation script and the operation text; and finally, sending the keyboard operation instruction to the host system, inquiring production data and storing the production data to the server. In the embodiment of the invention, an operator does not need to know the operation of the host terminal, and can generate the optimal operation text only by compiling SQL statements; recording manual single-time keyboard operation to an operation text, generating a manual operation simulation script for manual repeated operation by using a script program, reading the operation text by using the manual operation simulation script, simulating keyboard operation, realizing only fixed standard operation, and avoiding operation outside a range; the production environment of an operator and the host system is isolated, so that the operator can not directly log in the host system for operation, namely, data query can be completed, and the data query can only be performed on the host system for fixed operation; the data query based on the host can be standardized and automated, so that the working efficiency is improved, the operation safety is improved, and the automated operation of a host system is realized.
In order to prevent an operator from submitting an incorrect instruction or submitting a job which affects performance and affects financial services, the embodiment of the invention provides a method for security isolation of host data query, which can be implemented specifically as follows:
compiling a query SQL statement according to the production data query task, and determining an operation text;
determining a simulation manual operation script according to the production data query task;
simulating keyboard operation to generate a keyboard operation instruction according to the simulated manual operation script and the operation text;
and sending the keyboard operation instruction to the host system, inquiring production data and storing the production data to the server.
Fig. 2 is a schematic diagram of a process of determining a job text of a method for host data query security isolation according to an embodiment of the present invention, and as shown in fig. 2, when the method for host data query security isolation according to an embodiment of the present invention is implemented specifically, in an embodiment, the writing of a query SQL statement according to a production data query task and determining a job text includes:
step 201: compiling a query SQL statement according to a production data query task, inputting a WEB page, and generating an operation preset text by combining preset host parameters;
step 202: and (4) carrying out prior grammar check and parameter check on the operation preset text, outputting the operation preset text after the check is passed, and storing the operation preset text to a server.
In implementation, in order to isolate an operator from a production environment of a host system, so that the operator cannot directly log in the host system for operation, a query instruction manually input by an operation source needs to be converted into a programmed execution language, which specifically includes:
firstly, compiling a query SQL statement according to a production data query task, inputting a WEB page, and generating an operation preset text by combining preset host parameters; an operator does not need to know the operation of the host terminal, and can generate an optimal operation text only by compiling SQL sentences; recording manual single-time keyboard operation to an operation preset text; in order to prevent the problematic operation from being submitted to the production environment, the operation preset text is subjected to prior grammar check and parameter check, and the operation preset text is output as an operation text after the check is passed and is stored in a server; in the embodiment, each query job can be subjected to prior grammar check and parameter check, so that the problem job is prevented from being submitted to a production environment. Before submitting the operation text, the SQL statement is also checked to check whether the specification is met.
When the method for host data query security isolation provided by the embodiment of the present invention is implemented specifically, in an embodiment, the determining a simulated manual operation script according to a production data query task includes:
analyzing the production data query task, and acquiring the name, the user name, the account, a host system operation instruction and a host system operation sequence of the login server;
and programming the name, the user name, the account, the host system operation instruction and the host system operation sequence of the login server to generate a simulated manual operation script.
In the embodiment, in order to realize the simulation of manual login of the host system, a script capable of realizing the simulation of manual operation is needed, firstly, a production data query task is analyzed, and the name, the user name, the account, the host system operation instruction and the host system operation sequence of a login server are obtained; the name, the user name, the account, the host system operation instruction and the host system operation sequence of the login server can be obtained from the job name of the production data query task; and then programming the name, the user name, the account, the host system operation instruction and the host system operation sequence of the login server to generate a simulated manual operation script, so that the operation programming is realized, the problem that the performance of the host system is influenced or the system is wrong due to manual instruction input is solved, and the safe, stable and efficient operation of the host system is ensured. In an embodiment, as described in Table 1, a specific program code is provided that simulates a manual operation script.
TABLE 1
When the method for host data query security isolation provided by the embodiment of the present invention is implemented specifically, in an embodiment, the simulating a keyboard operation to generate a keyboard operation instruction according to a simulated manual operation script and a job text includes:
and on a terminal capable of logging in the host system, a planning task is run, a job text is obtained from the server at regular time, a simulated manual operation script is executed, the job text is read in a keyboard operation simulating mode, and a keyboard operation instruction is generated.
In the embodiment, in order to enable the host system to recognize the job text, a keyboard operation instruction needs to be generated, and the main process includes:
on a terminal capable of logging in a host system, a planning task is run, an operation text is obtained from a server at regular time, a simulated manual operation script is executed, the operation text is read in a keyboard operation simulating mode, and a keyboard operation instruction is generated; on a production terminal capable of logging in a host system, a planning task is run, a job text is obtained from a server at regular time, a simulation manual operation script is executed, the operation of logging in the host manually and submitting the job is simulated in a simulation keyboard operation mode, and the operation is mainly stored in a text mode through the simulation keyboard operation mode. The keyboard operation instruction is read by the program and sent to the terminal tool of the host system, so that the query operation submission and result storage operation of the host are realized.
Recording manual single keyboard operation to an operation text, generating a manual operation simulation script for manual repeated operation by a script program, reading the operation text by the manual operation simulation script, simulating keyboard operation, realizing only fixed standard operation, and avoiding out-of-range operation
Fig. 3 is a schematic diagram of a process of querying production data of a method for querying security isolation of host data according to an embodiment of the present invention, as shown in fig. 3, when the method for querying security isolation of host data according to an embodiment of the present invention is implemented specifically, in an embodiment, the sending the keyboard operation instruction to the host system, and storing the query production data in the server includes:
step 301: acquiring a handle of a terminal operation window, and sending a keyboard operation instruction to a host system;
step 302: and responding to the keyboard operation instruction in the host system, inquiring to obtain production data, and storing the production data to the server.
In the embodiment, in order to realize the production data query, the main steps comprise: the terminal runs under a windows system, and needs to compile a windows application program, acquire a terminal operation window handle and send a keyboard operation instruction to a host system; and then responding to the keyboard operation instruction in the host system, inquiring and acquiring production data, storing the production data to the server, and downloading the production data from the server to the local when the production data is required to be used. The aforementioned server may be an FTP server.
The production environment of an operator and the host system is isolated, so that the operator can not directly log in the host system for operation, namely, data query can be completed, and the data query can only be performed on the host system for fixed operation; the data query based on the host can be standardized and automated, thereby not only improving the working efficiency, but also improving the operation safety and realizing the automated operation of the host system
For the embodiment of the invention, the most core part is to simulate the operation of a manual keyboard; and opening the host operating terminal by using the simulated manual operation script, defaulting manual operation, sending a keyboard operation instruction according to the pre-designed script, and inquiring production data.
Fig. 4 is a schematic diagram of a computer device for executing a method for host data query security isolation implemented by the present invention, and as shown in fig. 4, an embodiment of the present invention further provides a computer device including a memory, a processor, and a computer program stored in the memory and executable on the processor, where the processor executes the computer program to implement the method for host data query security isolation.
An embodiment of the present invention further provides a computer-readable storage medium, where the computer-readable storage medium stores a computer program for executing the method for implementing the above-mentioned host data query security isolation.
The embodiment of the invention also provides a device for the security isolation of the data query of the host, which is described in the following embodiment. Because the principle of the device for solving the problems is similar to that of a method for the host data query security isolation, the implementation of the device can refer to the implementation of the method for the host data query security isolation, and repeated details are not repeated.
Fig. 5 is a schematic diagram of a device for host data query security isolation according to an embodiment of the present invention, and as shown in fig. 5, an embodiment of the present invention further provides a device for host data query security isolation, which may include:
a job text determining module 501, configured to compile a query SQL statement according to the production data query task, and determine a job text;
a simulated manual operation script determining module 502, configured to determine a simulated manual operation script according to the production data query task;
a keyboard operation instruction generation determination module 503, configured to simulate a keyboard operation to generate a keyboard operation instruction according to the simulated manual operation script and the job text;
and a production data query module 504, configured to send the keyboard operation instruction to the host system, and query production data and store the query production data in the server.
In an embodiment of the present invention, when the apparatus for host data query security isolation provided in the embodiment of the present invention is implemented specifically, the job text determining module is specifically configured to:
compiling a query SQL statement according to a production data query task, inputting a WEB page, and generating an operation preset text by combining preset host parameters;
and (4) carrying out prior grammar check and parameter check on the operation preset text, outputting the operation preset text after the check is passed, and storing the operation preset text to a server.
In an embodiment of the present invention, when the apparatus for host data query security isolation provided in the embodiment of the present invention is implemented specifically, the module for determining simulated manual operation script is specifically configured to:
analyzing the production data query task, and acquiring the name, the user name, the account, a host system operation instruction and a host system operation sequence of the login server;
and programming the name, the user name, the account, the host system operation instruction and the host system operation sequence of the login server to generate a simulated manual operation script.
In an embodiment of the present invention, when the device for host data query security isolation is implemented specifically, the keyboard operation instruction generation determining module is specifically configured to:
and on a terminal capable of logging in the host system, a planning task is run, a job text is obtained from the server at regular time, a simulated manual operation script is executed, the job text is read in a keyboard operation simulating mode, and a keyboard operation instruction is generated.
In an embodiment of the present invention, when the apparatus for host data query security isolation provided in the embodiment of the present invention is implemented specifically, the production data query module is specifically configured to:
acquiring a handle of a terminal operation window, and sending a keyboard operation instruction to a host system;
and responding to the keyboard operation instruction in the host system, inquiring to obtain production data, and storing the production data to the server.
Fig. 6 is a relationship flow chart of another embodiment of the apparatus for host data query security isolation according to the present invention, as shown in fig. 6, including:
firstly, a job text generation module: and inputting a standard sql statement, adding preset host parameters, and generating a job text which can be run on a target host.
Secondly, a simulated manual operation script generation module: and generating a manual operation script according to the job name of the production data query task to be submitted. The manual operation script records the name of the login server, the user name, the account, the operation instruction related to the host computer and the operation sequence.
And thirdly, a keyboard operation instruction generating module reads the simulation manual operation script and sends a keyboard operation instruction. And sending a keyboard operation instruction to the host login terminal by reading the simulation manual operation script.
Fourthly, a production data query module sends the keyboard operation instruction to the host system, and the query production data is stored in the server
And fifthly, the ftp module uploads the operation text and downloads the data query result to the local.
To sum up, the embodiment of the invention provides a method and a device for host data query security isolation, which first compile query SQL statements and determine job texts according to a production data query task; then, according to the production data query task, determining a simulation manual operation script; simulating keyboard operation to generate a keyboard operation instruction according to the simulated manual operation script and the operation text; and finally, sending the keyboard operation instruction to the host system, inquiring production data and storing the production data to the server. In the embodiment of the invention, an operator does not need to know the operation of the host terminal, and can generate the optimal operation text only by compiling SQL statements; recording manual single-time keyboard operation to an operation text, generating a manual operation simulation script for manual repeated operation by using a script program, reading the operation text by using the manual operation simulation script, simulating keyboard operation, realizing only fixed standard operation, and avoiding operation outside a range; the production environment of an operator and the host system is isolated, so that the operator can not directly log in the host system for operation, namely, data query can be completed, and the data query can only be performed on the host system for fixed operation; the data query based on the host can be standardized and automated, so that the working efficiency is improved, the operation safety is improved, and the automated operation of a host system is realized.
In the embodiment of the invention, each query job can be subjected to prior grammar check and parameter check, so that the problem job is prevented from being submitted to a production environment. Before submitting the operation, the SQL statement is also checked to check whether the SQL statement meets the specification.
The invention realizes the automatic operation of the host system and makes a foundation preparation for the subsequent artificial intelligence operation and maintenance. In the future, the artificial intelligence operation and maintenance can generate different operation scripts, and the implementation of the operation scripts is realized through the method and the system. By using the invention, the future version deployment and data query based on the host can be standardized and automated, thereby not only improving the working efficiency, but also improving the operation safety.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
The above-mentioned embodiments are intended to illustrate the objects, technical solutions and advantages of the present invention in further detail, and it should be understood that the above-mentioned embodiments are only exemplary embodiments of the present invention, and are not intended to limit the scope of the present invention, and any modifications, equivalent substitutions, improvements and the like made within the spirit and principle of the present invention should be included in the scope of the present invention.
Claims (12)
1. A method for secure isolation of host data queries, comprising:
compiling a query SQL statement according to the production data query task, and determining an operation text;
determining a simulation manual operation script according to the production data query task;
simulating keyboard operation to generate a keyboard operation instruction according to the simulated manual operation script and the operation text;
and sending the keyboard operation instruction to the host system, inquiring production data and storing the production data to the server.
2. The method of claim 1, wherein writing a query SQL statement to determine job text based on the production data query task comprises:
compiling a query SQL statement according to a production data query task, inputting a WEB page, and generating an operation preset text by combining preset host parameters;
and (4) carrying out prior grammar check and parameter check on the operation preset text, outputting the operation preset text after the check is passed, and storing the operation preset text to a server.
3. The method of claim 1, wherein determining a simulated manual operation script based on the production data query task comprises:
analyzing the production data query task, and acquiring the name, the user name, the account, a host system operation instruction and a host system operation sequence of the login server;
and programming the name, the user name, the account, the host system operation instruction and the host system operation sequence of the login server to generate a simulated manual operation script.
4. The method of claim 2, wherein simulating keyboard operations generates keyboard operation instructions based on the simulated manual operation script and the job text, comprising:
and on a terminal capable of logging in the host system, a planning task is run, a job text is obtained from the server at regular time, a simulated manual operation script is executed, the job text is read in a keyboard operation simulating mode, and a keyboard operation instruction is generated.
5. The method of claim 4, wherein sending keyboard operation commands to the host system, querying production data for storage to the server, comprises:
acquiring a handle of a terminal operation window, and sending a keyboard operation instruction to a host system;
and responding to the keyboard operation instruction in the host system, inquiring to obtain production data, and storing the production data to the server.
6. An apparatus for secure isolation of host data queries, comprising:
the job text determining module is used for compiling query SQL sentences according to the production data query tasks and determining job texts;
the simulation manual operation script determining module is used for determining a simulation manual operation script according to the production data query task;
the keyboard operation instruction generation determining module is used for simulating keyboard operation to generate a keyboard operation instruction according to the simulated manual operation script and the operation text;
and the production data query module is used for sending the keyboard operation instruction to the host system, and querying and storing the production data to the server.
7. The apparatus of claim 6, wherein the job text determination module is specifically configured to:
compiling a query SQL statement according to a production data query task, inputting a WEB page, and generating an operation preset text by combining preset host parameters;
and (4) carrying out prior grammar check and parameter check on the operation preset text, outputting the operation preset text after the check is passed, and storing the operation preset text to a server.
8. The apparatus of claim 6, wherein the simulated manual operation script determination module is specifically configured to:
analyzing the production data query task, and acquiring the name, the user name, the account, a host system operation instruction and a host system operation sequence of the login server;
and programming the name, the user name, the account, the host system operation instruction and the host system operation sequence of the login server to generate a simulated manual operation script.
9. The apparatus of claim 7, wherein the keyboard operation instruction generation determination module is specifically configured to:
and on a terminal capable of logging in the host system, a planning task is run, a job text is obtained from the server at regular time, a simulated manual operation script is executed, the job text is read in a keyboard operation simulating mode, and a keyboard operation instruction is generated.
10. The apparatus of claim 9, wherein the production data query module is specifically configured to:
acquiring a handle of a terminal operation window, and sending a keyboard operation instruction to a host system;
and responding to the keyboard operation instruction in the host system, inquiring to obtain production data, and storing the production data to the server.
11. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the method of any of claims 1 to 5 when executing the computer program.
12. A computer-readable storage medium, characterized in that the computer-readable storage medium stores a computer program for executing a method according to any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011066121.8A CN112131247A (en) | 2020-09-30 | 2020-09-30 | Method and device for safety isolation of host data query |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011066121.8A CN112131247A (en) | 2020-09-30 | 2020-09-30 | Method and device for safety isolation of host data query |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112131247A true CN112131247A (en) | 2020-12-25 |
Family
ID=73845012
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011066121.8A Pending CN112131247A (en) | 2020-09-30 | 2020-09-30 | Method and device for safety isolation of host data query |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112131247A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120284719A1 (en) * | 2011-05-03 | 2012-11-08 | Microsoft Corporation | Distributed multi-phase batch job processing |
| CN106569783A (en) * | 2015-10-08 | 2017-04-19 | 腾讯科技（深圳）有限公司 | Task script executing method and apparatus |
| CN109213813A (en) * | 2018-09-14 | 2019-01-15 | 汉能移动能源控股集团有限公司 | Data export method and device |
| CN110968601A (en) * | 2019-11-28 | 2020-04-07 | 中国银行股份有限公司 | Data query processing method and device |
| CN111026800A (en) * | 2019-12-09 | 2020-04-17 | 爱信诺征信有限公司 | Data export method and device, electronic equipment and storage medium |
| CN111125598A (en) * | 2019-12-20 | 2020-05-08 | 深圳壹账通智能科技有限公司 | Intelligent data query method, device, equipment and storage medium |
-
2020
- 2020-09-30 CN CN202011066121.8A patent/CN112131247A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120284719A1 (en) * | 2011-05-03 | 2012-11-08 | Microsoft Corporation | Distributed multi-phase batch job processing |
| CN106569783A (en) * | 2015-10-08 | 2017-04-19 | 腾讯科技（深圳）有限公司 | Task script executing method and apparatus |
| CN109213813A (en) * | 2018-09-14 | 2019-01-15 | 汉能移动能源控股集团有限公司 | Data export method and device |
| CN110968601A (en) * | 2019-11-28 | 2020-04-07 | 中国银行股份有限公司 | Data query processing method and device |
| CN111026800A (en) * | 2019-12-09 | 2020-04-17 | 爱信诺征信有限公司 | Data export method and device, electronic equipment and storage medium |
| CN111125598A (en) * | 2019-12-20 | 2020-05-08 | 深圳壹账通智能科技有限公司 | Intelligent data query method, device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8898635B2 (en) | System and method for automatic impact variable analysis and field expansion in mainframe systems | |
| US7895575B2 (en) | Apparatus and method for generating test driver | |
| US6934940B2 (en) | Source code transformation-temporary object reduction | |
| US9619212B2 (en) | Providing code, code generator and software development environment | |
| KR20110045853A (en) | A method and system for testing industrial machine | |
| KR101722856B1 (en) | Apparatus for test plc using programming language | |
| US7272753B2 (en) | Methods and apparatus for translating application tests for execution with simulation software tools | |
| US10310961B1 (en) | Cognitive dynamic script language builder | |
| US10656922B2 (en) | Systems and methods for providing an application transformation tool | |
| EP4073626B1 (en) | Method and system for generating engineering diagrams in an engineering system | |
| US20150020051A1 (en) | Method and apparatus for automated conversion of software applications | |
| CN109491919B (en) | Software testing method and testing platform | |
| CN112131247A (en) | Method and device for safety isolation of host data query | |
| Pardo et al. | Documenting and implementing DevOps good practices with test automation and continuous deployment tools through software refinement | |
| CN113051262B (en) | Data quality inspection method, device, equipment and storage medium | |
| CN109977019B (en) | Compiler optimization sequence test method based on incremental sampling | |
| EP2782005A1 (en) | Verifying state reachability in a statechart model having computer program code embedded therein | |
| Ribeiro | Large Language Models for Automated Program Repair | |
| Tran-Jørgensen et al. | Enhancing Testing of VDM-SL models | |
| US20240078435A1 (en) | Systems and methods for unit test generation using reinforcement learning augmented transformer architectures | |
| Bussenot et al. | A domain specific test language for systems integration | |
| JP7426493B2 (en) | Auxiliary processing methods, equipment, electronic equipment, storage media and programs for software development | |
| Drobintsev et al. | Conversion of abstract behavioral scenarios into scenarios applicable for testing | |
| Li et al. | Iaso: Enhancing Syntax Error Correction using Deep Learning Techniques | |
| US20230281482A1 (en) | Systems and methods for rule-based machine learning model promotion |
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 |