Automatic operating instruction generating device based on structured query language and method
A technology of structured query and operation instructions, which is applied in the direction of program control devices, special data processing applications, instruments, etc., can solve the problems of reduced system work efficiency and performance, poor command code reusability, and increased maintenance costs, so as to improve the system Work efficiency and performance, ensure real-time and accuracy, high reusability effect
Active Publication Date: 2015-03-25
CHINA UNIONPAY
View PDF3 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0004] However, as the types of business become more and more abundant, the operations on the database become more and more frequent, so the number of interactions with the database increases significantly
Therefore, the above-mentioned existing technical solutions have the following problems: the method of manually writing instruction codes to perform operations on the database cannot meet the real-time requirements of the system; Due to the cumbersome and error-prone process, the work efficiency and performance of the entire system are reduced; in addition, the reusability of manually written instruction codes is poor
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0048] figure 1 It is a structural diagram of the device for automatically generating operation instructions based on structured query language according to an embodiment of the present invention. Such as figure 1 As shown, exemplarily, the device 1 for automatically generating operation instructions based on structured query language disclosed in the present invention is used to automatically generate operation instructions for the database according to configuration files. Such as figure 1 As shown, the automatic operation instruction generation device 1 includes a configuration file generation module 2 , a configuration file analysis module 3 and an operation instruction generation module 4 . Wherein, the configuration file generation module 2 is used to generate and store a configuration file based on user input, the configuration file includes a structured query statement (SQL) and parameters (for example, the configuration file includes an SQL statement and several inp...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More PUM
Login to View More Abstract
The invention provides an automatic operating instruction generating device based on structured query language and a method. The automatic operating instruction generating device based on structured query language comprises a configuration file generating module, a configuration file analyzing module and an operating instruction generating module, wherein a configuration file consists of structured query language statements and parameters. The automatic operating instruction generating device based on the structured query language and the method are easy to be operated, generated instruction codes have high reusability, timeliness and accuracy can be guaranteed, and work efficiency and performance of a system can be improved.
Description
technical field [0001] The present invention relates to a device and method for generating operation instructions, and more specifically, to a device and method for automatically generating operation instructions based on structured query language. Background technique [0002] At present, with the increasing demand for information and data processing and the increasing variety of business types in different fields, it is becoming more and more important to perform dynamic operations on databases based on Structured Query Language (SQL) (such as adding, deleting, modifying or querying, etc.) more important. [0003] Generally, the basic principles of existing methods and devices for dynamically operating databases based on Structured Query Language (SQL) are as follows: according to requirements, relevant personnel manually define host variables for each operation, and based on the host variables Write the corresponding sqc instruction code (that is, the SQL embedded in the...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More Application Information
Patent Timeline
Login to View More Patent Type & Authority Patents(China)
IPC IPC(8): G06F9/44G06F17/30
Inventor 丰朋周超
Owner CHINA UNIONPAY