CN102541521B - Automatic operating instruction generating device based on structured query language and method - Google Patents
Automatic operating instruction generating device based on structured query language and method Download PDFInfo
- Publication number
- CN102541521B CN102541521B CN201010599456.6A CN201010599456A CN102541521B CN 102541521 B CN102541521 B CN 102541521B CN 201010599456 A CN201010599456 A CN 201010599456A CN 102541521 B CN102541521 B CN 102541521B
- Authority
- CN
- China
- Prior art keywords
- configuration file
- operational order
- structured query
- query language
- structure based
- 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.)
- Active
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
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
The present invention relates to operational order generating apparatus and method, more specifically, relate to operational order automatically generating device and the method for structure based query language.
Background technology
At present, along with the becoming increasingly abundant of class of business of the growing of information data processing demands and different field, structure based query language (SQL) operates (such as increase, delete, revise or inquiry etc.) dynamically to database and becomes more and more important.
Usually, the ultimate principle that existing structure based query language (SQL) carries out the method for dynamic operation and device to database is as follows: according to demand, be each Operation Definition host variable by related personnel artificially, and write corresponding sqc instruction code (namely embedding the SQL in C programmer) based on described host variable, according to described sqc instruction code, required operation is carried out to database subsequently.
But due to becoming increasingly abundant along with class of business, the described operation for database is also more and more frequent, thus and mutual quantity between database significantly increase.Therefore, there are the following problems for above-mentioned existing technical scheme: use manual compiling instruction code thus carry out can not meeting the requirement of system to real-time for the mode of the operation of database; Meanwhile, which is consuming time more, and thus maintenance cost raises, and due to process loaded down with trivial details and be easy to make mistakes, therefore reduce work efficiency and the performance of whole system; In addition, the reusability of the instruction code of manual compiling is poor.
Therefore, there is following demand: provide a kind of and be easy to operate, real-time and accuracy can be guaranteed and operational order automatically generating device and the method for the structure based query language of system works efficiency and performance can be improved.
Summary of the invention
In order to solve the defect existing for above-mentioned prior art, the present invention proposes a kind of operational order automatically generating device and method of structure based query language.
The object of the invention is to be achieved through the following technical solutions:
An operational order automatically generating device for structure based query language, the operational order automatically generating device of described structure based query language comprises:
Configuration file generation module, described configuration file generation module is used for generating and storing configuration file based on user's input;
Configuration file parsing module, described configuration file parsing module is for setting up with the connection of database and resolving described structured query sentence in described configuration file and parameter according to pre-defined rule, and storing and resolving result in a predetermined format;
Operational order generation module, described operational order generation module is for automatically generating the operational order for described database according to described analysis result;
Wherein, described configuration file comprises structured query sentence and parameter.
In scheme disclosed above, preferably, that determines the operational order of generation according to the title of described configuration file deposits path.
In scheme disclosed above, preferably, the title of described configuration file comprises the mark for identifying the operator scheme to database, and described operator scheme is at least one in vernier mode, generation patterns, preference pattern and ordered mode.
In scheme disclosed above, preferably, described configuration file parsing module comprises further:
Resolution unit, described resolution unit for resolving the content of described configuration file, and by the described structured query sentence in described configuration file and parameter respectively stored in global character pointer and global character array;
Storage unit, the input variable of the described structured query sentence parsed and result set information are stored in global structure body array for utilizing the specific command of embedded sql by described storage unit.
In scheme disclosed above, preferably, the input variable of the described structured query sentence parsed and result set information are stored into after in global structure body array and disconnect the connection with described database by described storage unit.
In scheme disclosed above, preferably, described operational order generation module comprises further:
Header file generation unit, described header file generation unit is used for the type determining described structured query sentence according to the title of described configuration file, and generates header file based on the described type determined;
Instruction generation unit, described instruction generation unit is used for the type determining described structured query sentence according to the title of described configuration file, and generates instruction code based on the described type determined.
In scheme disclosed above, preferably, described instruction code is sqc instruction code.
In scheme disclosed above, preferably, described storage unit utilizes the DESCRIBE order of embedded sql and SQLDA data structure to obtain input parameter and the result set information of structured query sentence.
In scheme disclosed above, preferably, the described instruction code generated is compiled into static state and/or kinematic function storehouse by the operational order automatically generating device of described structure based query language.
In scheme disclosed above, preferably, according to demand, to the input variable assignment of the function in described function library, to obtain the execution result under different condition.
Object of the present invention is also achieved through the following technical solutions:
An operational order automatic generation method for structure based query language, the operational order automatic generation method of described structure based query language comprises the steps:
(A1) generate and store configuration file based on user's input, described configuration file comprises structured query sentence and parameter;
(A2) set up with the connection of database and resolve described structured query sentence in described configuration file and parameter according to pre-defined rule, and storing and resolving result in a predetermined format;
(A3) operational order for described database is automatically generated according to described analysis result.
In scheme disclosed above, preferably, that determines the operational order of generation according to the title of described configuration file deposits path.
In scheme disclosed above, preferably, the title of described configuration file comprises the mark for identifying the operator scheme to database, and described operator scheme is at least one in vernier mode, generation patterns, preference pattern and ordered mode.
In scheme disclosed above, preferably, described step (A2) comprises further:
(B1) content of described configuration file is resolved, and by the described structured query sentence in described configuration file and parameter respectively stored in global character pointer and global character array;
(B2) specific command of embedded sql is utilized the input variable of the described structured query sentence parsed and result set information to be stored in global structure body array.
In scheme disclosed above, preferably, described step (A2) comprises further: the input variable of the described structured query sentence parsed and result set information are stored into after in global structure body array and disconnect the connection with described database by (B3).
In scheme disclosed above, preferably, described step (A3) comprises further:
(C1) determine the type of described structured query sentence according to the title of described configuration file, and generate header file based on the described type determined;
(C2) determine the type of described structured query sentence according to the title of described configuration file, and generate instruction code based on the described type determined.
In scheme disclosed above, preferably, described instruction code is sqc instruction code.
In disclosed scheme, preferably, in described step (B2), the DESCRIBE order of embedded sql and SQLDA data structure is utilized to obtain input parameter and the result set information of described structured query sentence above.
In scheme disclosed above, preferably, the described instruction code generated is compiled into static state and/or kinematic function storehouse.
In scheme disclosed above, preferably, according to demand, to the input variable assignment of the function in described function library, to obtain the execution result under different condition.
Operational order automatically generating device and the method tool of structure based query language disclosed in this invention have the following advantages: be easy to operation; Real-time and accuracy can be guaranteed and system works efficiency and performance can be improved; The instruction code generated has very high reusability.
Accompanying drawing explanation
By reference to the accompanying drawings, technical characteristic of the present invention and advantage will be understood better by those skilled in the art, wherein:
Fig. 1 is the structural drawing of the operational order automatically generating device of structure based query language according to an embodiment of the invention;
Fig. 2 is the process flow diagram of the operational order automatic generation method of structure based query language according to an embodiment of the invention;
Embodiment
Fig. 1 is the structural drawing of the operational order automatically generating device of structure based query language according to an embodiment of the invention.As shown in Figure 1, exemplarily, the operational order automatically generating device 1 of structure based query language disclosed in this invention is for automatically generating the operational order for database according to configuration file.As shown in Figure 1, described operational order automatically generating device 1 comprises configuration file generation module 2, configuration file parsing module 3 and operational order generation module 4.Wherein, described configuration file generation module 2 is for generating and storing configuration file based on user's input, described configuration file comprises structured query sentence (SQL) and parameter (exemplarily, described configuration file comprises a SQL statement and some input parameters).Described configuration file parsing module 3 is for setting up with the connection of database and resolving described structured query sentence in described configuration file and parameter according to pre-defined rule, and storing and resolving result in a predetermined format.Described operational order generation module 4 is for automatically generating the operational order for database according to described analysis result.
Preferably, in the operational order automatically generating device of structure based query language disclosed in this invention, that determines the operational order generated according to the title of described configuration file deposits path.Wherein, exemplarily, the title of described configuration file comprises the mark for identifying storehouse belonging to configuration file, be used to indicate the mark depositing path of the operational order of generation, for identifying in described configuration file the mark of the mode of operation of database (namely that define described operational order automatically generating device will according to which kind of schema creation code) and the reserved custom field for Function Extension.Wherein, exemplarily, described operational order automatically generating device 1 can with following four kinds of schema creation codes: vernier mode (i.e. DECLARE-OPEN-CLOSE mode), generation patterns (i.e. EXEXUTZ...USING... mode, represent renewal, insertion, deletion etc. to database), preference pattern (i.e. SELECT...INTO...USING... mode, represent the wall scroll read operation to database) and ordered mode (i.e. VALUES NEXTVAL FOR...INTO... mode, represents the read operation from increasing sequence to database).
As shown in Figure 1, in the operational order automatically generating device of structure based query language disclosed in this invention, exemplarily, described configuration file parsing module 3 comprises resolution unit 5 and storage unit 6 further.Wherein, described resolution unit 5 for resolving the content of described configuration file, and by the described structured query sentence in described configuration file and parameter respectively stored in global character pointer and global character array.The input variable of the described structured query sentence parsed and result set information are stored in global structure body array for utilizing the specific command of damascene structures query statement (such as DESCRIBE order) by described storage unit 6.Preferably, the input variable of the described structured query sentence parsed and result set information are stored into after in global structure body array and disconnect the connection with described database by described storage unit 6.
As shown in Figure 1, in the operational order automatically generating device of structure based query language disclosed in this invention, exemplarily, described operational order generation module 4 comprises header file generation unit 7 and instruction generation unit 8 further.Wherein, described header file generation unit 7 for determining the type of described structured query sentence according to the title of described configuration file, and generates header file based on the described type determined.Described instruction generation unit 8 for determining the type of described structured query sentence according to the title of described configuration file, and generates instruction code based on the described type determined.Preferably, described instruction code is sqc instruction code.
As shown in Figure 1, exemplarily, described parameter in described configuration file can with symbol "? " mark, and can following closely with two " # " symbols comprise this parameter another name (such as: select*from tb1_test where colum1=? #AGE#).
As shown in Figure 1, exemplarily, in the operational order automatically generating device of structure based query language disclosed in this invention, the basic functional principle of described resolution unit 5 is as follows: (1) is that separator is split to described structured query sentence with " # "; (2) part before " # " is taken out the part then continuing segmentation and be left; (3) if inseparable, then resolving terminates; (4) if can divide, then the variable parameter name after " # " taken out and continue to split remaining part; (5) if inseparable, then represent that variable parameter separator does not mate, thus report an error and exit; (6) if can divide, then step (2) is returned.
As shown in Figure 1, exemplarily, in the operational order automatically generating device of structure based query language disclosed in this invention, described storage unit 6 utilizes the DESCRIBE order of Embedded SQL and SQLDA (SQL Descriptor Area) data structure to obtain input parameter and the result set information of structured query sentence, wherein, described SQLDA data structure comprises information header and structure of arrays, and each element in described structure of arrays describes the row that a host variable or result data are concentrated.As from the foregoing, by applying described DESCRIBE order to described structured query sentence, the input variable of described structured query sentence and result set information can be written in described SQLDA.The basic functional principle of described storage unit 6 is as follows: carry out initialization procedure, is described SQLDA structure storage allocation (supposing to only have a data element in described SQLDA structure); Judge whether the parameter value imported into is 0, if be 0, then the input variable information utilizing DESCRIBE INPUT order described structured query sentence to be needed writes in described SQLDA structure; If be not 0, then the result set information utilizing DESCRIBE OUTPUT order described structured query sentence to be returned writes in described SQLDA structure; Read data element in described SQLDA structure to obtain actual input variable or result set number; Determine whether the entry often arranging establishment 2 particular variables types (such as sqlvar type); If so, then be again described SQLDA structure storage allocation space (such as, include 2* (sqld+1) individual data element, wherein sqld is actual input variable or result set number); If not, then be again described SQLDA structure storage allocation space (such as, include (sqld+1) individual data element, wherein sqld is actual input variable or result set number); Again judge whether the parameter value imported into is 0; If be 0, then the input variable information utilizing DESCRIBE INPUT order described structured query sentence to be needed writes in described SQLDA structure; If be not 0, then the result set information utilizing DESCRIBEOUTPUT order described structured query sentence to be returned writes in described SQLDA structure; Order reads the data element in described SQLDA structure, thus by input variable or result set information write global structure body array.
As shown in Figure 1, exemplarily, in the operational order automatically generating device of structure based query language disclosed in this invention, the basic functional principle of described header file generation unit 7 is as follows: the beginning annotation of spanned file; Define according to for the structure in the data genaration header file in the input variable of structured query statement and the described global structure body array of result set information; The function declaration in header file is generated according to the information in the title of configuration file.
As shown in Figure 1, exemplarily, in the operational order automatically generating device of structure based query language disclosed in this invention, the basic functional principle of described instruction generation unit 8 is as follows: the beginning annotation of spanned file; Generate header file comprise statement sum functions declarative statement according to the information in the title of described configuration file, header file name; According to the definition for the data genaration host variable in the input variable of structured query statement and the described global structure body array of result set information; With Form generation database manipulation function that is dynamic or static structure query statement.
As shown in Figure 1, exemplarily, the sqc code generated by described operational order automatically generating device 1 can be compiled into function library (static library or dynamic base), calls for netscape messaging server Netscape.
As shown in Figure 1, preferably, user can according to demand in the input variable assignment to the sqc function in described function library, to obtain the execution result under different condition.
As from the foregoing, what realize due to described sqc function is single operation to database, and the code therefore generated by described operational order automatically generating device 1 has very high reusability.
Fig. 2 is the process flow diagram of the operational order automatic generation method of structure based query language according to an embodiment of the invention.As shown in Figure 2, the operational order automatic generation method of structure based query language disclosed in this invention comprises the steps: that (A1) generates and stores configuration file based on user's input, described configuration file comprises structured query sentence (SQL) and parameter (exemplarily, described configuration file comprises a SQL statement and some input parameters); (A2) set up with the connection of database and resolve described structured query sentence in described configuration file and parameter according to pre-defined rule, and storing and resolving result in a predetermined format; (A3) operational order for described database is automatically generated according to described analysis result.
Preferably, in the operational order automatic generation method of structure based query language disclosed in this invention, that determines the operational order generated according to the title of described configuration file deposits path.Wherein, exemplarily, the title of described configuration file comprises the mark for identifying storehouse belonging to configuration file, be used to indicate the mark depositing path of the operational order of generation, for identifying in described configuration file the mark of the mode of operation of database (namely that define described operational order automatically generating device will according to which kind of schema creation code) and the reserved custom field for Function Extension.Wherein, exemplarily, described operational order automatic generation method can with following four kinds of schema creation codes: vernier mode (i.e. DECLARE-OPEN-CLOSE mode), generation patterns (i.e. EXEXUTZ...USING... mode, represent renewal, insertion, deletion etc. to database), preference pattern (i.e. SELECT...INTO...USING... mode, represent the wall scroll read operation to database) and ordered mode (i.e. VALUES NEXTVAL FOR...INTO... mode, represents the read operation from increasing sequence to database).
Preferably, in the operational order automatic generation method of structure based query language disclosed in this invention, described step (A2) comprises further: (B1) resolves the content of described configuration file, and by the described structured query sentence in described configuration file and parameter respectively stored in global character pointer and global character array; (B2) specific command of damascene structures query statement (such as DESCRIBE order) is utilized the input variable of the described structured query sentence parsed and result set information to be stored in global structure body array.Preferably, described step (A2) comprises further: the input variable of the described structured query sentence parsed and result set information are stored into after in global structure body array and disconnect the connection with described database by (B3).
Preferably, in the operational order automatic generation method of structure based query language disclosed in this invention, described step (A3) comprises further: (C1) determines the type of described structured query sentence according to the title of described configuration file, and generates header file based on the described type determined; (C2) determine the type of described structured query sentence according to the title of described configuration file, and generate instruction code based on the described type determined.
Preferably, described instruction code is sqc instruction code.
Exemplarily, in the operational order automatic generation method of structure based query language disclosed in this invention, described parameter in described configuration file can with symbol "? " mark, and can following closely with two " # " symbols comprise this parameter another name (such as: select*fromtb1_test where colum1=? #AGE#).
Exemplarily, in the operational order automatic generation method of structure based query language disclosed in this invention, described step (B1) comprises further: (1) is that separator is split to described structured query sentence with " # "; (2) part before " # " is taken out the part then continuing segmentation and be left; (3) if inseparable, then resolving terminates; (4) if can divide, then the variable parameter name after " # " taken out and continue to split remaining part; (5) if inseparable, then represent that variable parameter separator does not mate, thus report an error and exit; (6) if can divide, then step (2) is returned.
Exemplarily, in the operational order automatic generation method of structure based query language disclosed in this invention, in described step (B2), the DESCRIBE order of Embedded SQL and SQLDA (SQL Descriptor Area) data structure is utilized to obtain input parameter and the result set information of structured query sentence, wherein, described SQLDA data structure comprises information header and structure of arrays, and each element in described structure of arrays describes the row that a host variable or result data are concentrated.As from the foregoing, by applying described DESCRIBE order to described structured query sentence, the input variable of described structured query sentence and result set information can be written in described SQLDA.Described step (B2) comprises further: complete initialization procedure, is described SQLDA structure storage allocation (supposing to only have a data element in described SQLDA structure); Judge whether the parameter value imported into is 0, if be 0, then the input variable information utilizing DESCRIBE INPUT order described structured query sentence to be needed writes in described SQLDA structure; If be not 0, then the result set information utilizing DESCRIBE OUTPUT order described structured query sentence to be returned writes in described SQLDA structure; Read data element in described SQLDA structure to obtain actual input variable or result set number; Determine whether the entry often arranging establishment 2 particular variables types (such as sqlvar type); If so, then be again described SQLDA structure storage allocation space (such as, include 2* (sqld+1) individual data element, wherein sqld is actual input variable or result set number); If not, then be again described SQLDA structure storage allocation space (such as, include (sqld+1) individual data element, wherein sqld is actual input variable or result set number); Again judge whether the parameter value imported into is 0; If be 0, then the input variable information utilizing DESCRIBE INPUT order described structured query sentence to be needed writes in described SQLDA structure; If be not 0, then the result set information utilizing DESCRIBEOUTPUT order described structured query sentence to be returned writes in described SQLDA structure; Order reads the data element in described SQLDA structure, thus by input variable or result set information write global structure body array.
Exemplarily, in the operational order automatic generation method of structure based query language disclosed in this invention, described step (C1) comprises further: the beginning annotation of spanned file; Define according to for the structure in the data genaration header file in the input variable of structured query statement and the described global structure body array of result set information; The function declaration in header file is generated according to the information in the title of configuration file.
Exemplarily, in the operational order automatic generation method of structure based query language disclosed in this invention, described step (C2) comprises further: the beginning annotation of spanned file; Generate header file comprise statement sum functions declarative statement according to the information in the title of described configuration file, header file name; According to the definition for the data genaration host variable in the input variable of structured query statement and the described global structure body array of result set information; With Form generation database manipulation function that is dynamic or static structure query statement.
Exemplarily, in the operational order automatic generation method of structure based query language disclosed in this invention, the sqc code of generation can be compiled into function library (static library or dynamic base), calls for netscape messaging server Netscape.
Preferably, in the operational order automatic generation method of structure based query language disclosed in this invention, user can according to demand in the input variable assignment to the sqc function in described function library, to obtain the execution result under different condition.
Although the present invention is described by above-mentioned preferred implementation, its way of realization is not limited to above-mentioned embodiment.Should be realized that: when not departing from purport of the present invention and scope, those skilled in the art can make different changes and amendment to the present invention.
Claims (12)
1. an operational order automatically generating device for structure based query language, the operational order automatically generating device of described structure based query language comprises:
Configuration file generation module, described configuration file generation module is used for generating and storing configuration file based on user's input;
Configuration file parsing module, described configuration file parsing module is for setting up with the connection of database and resolving described structured query sentence in described configuration file and parameter according to pre-defined rule, and storing and resolving result in a predetermined format;
Operational order generation module, described operational order generation module is for automatically generating the operational order for described database according to described analysis result;
Wherein, described configuration file comprises structured query sentence and parameter;
Described configuration file parsing module comprises further: resolution unit, described resolution unit for resolving the content of described configuration file, and by the described structured query sentence in described configuration file and parameter respectively stored in global character pointer and global character array; Storage unit, the input variable of the described structured query sentence parsed and result set information are stored in global structure body array for utilizing the specific command of embedded sql by described storage unit; The input variable of the described structured query sentence parsed and result set information are stored into after in global structure body array and disconnect the connection with described database by described storage unit; Described operational order generation module comprises further: header file generation unit, and described header file generation unit is used for the type determining described structured query sentence according to the title of described configuration file, and generates header file based on the described type determined; Instruction generation unit, described instruction generation unit is used for the type determining described structured query sentence according to the title of described configuration file, and generates instruction code based on the described type determined; Described instruction code is sqc instruction code.
2. the operational order automatically generating device of structure based query language according to claim 1, is characterized in that, that determines the operational order generated according to the title of described configuration file deposits path.
3. the operational order automatically generating device of structure based query language according to claim 2, it is characterized in that, the title of described configuration file comprises the mark for identifying the operator scheme to database, and described operator scheme is at least one in vernier mode, generation patterns, preference pattern and ordered mode.
4. the operational order automatically generating device of structure based query language according to claim 1, it is characterized in that, described storage unit utilizes the DESCRIBE order of embedded sql and SQLDA data structure to obtain input parameter and the result set information of structured query sentence.
5. the operational order automatically generating device of structure based query language according to claim 4, it is characterized in that, the described instruction code generated is compiled into static state and/or kinematic function storehouse by the operational order automatically generating device of described structure based query language.
6. the operational order automatically generating device of structure based query language according to claim 5, is characterized in that, according to demand, to the input variable assignment of the function in described function library, to obtain the execution result under different condition.
7. an operational order automatic generation method for structure based query language, the operational order automatic generation method of described structure based query language comprises the steps:
(A1) generate and store configuration file based on user's input, described configuration file comprises structured query sentence and parameter;
(A2) set up with the connection of database and resolve described structured query sentence in described configuration file and parameter according to pre-defined rule, and storing and resolving result in a predetermined format;
(A3) operational order for described database is automatically generated according to described analysis result;
Described step (A2) comprises further: (B1) resolves the content of described configuration file, and by the described structured query sentence in described configuration file and parameter respectively stored in global character pointer and global character array; (B2) specific command of embedded sql is utilized to be stored in global structure body array by the input variable of the described structured query sentence parsed and result set information; Described step (A2) comprises further: the input variable of the described structured query sentence parsed and result set information are stored into after in global structure body array and disconnect the connection with described database by (B3); Described step (A3) comprises further: (C1) determines the type of described structured query sentence according to the title of described configuration file, and generates header file based on the described type determined; (C2) determine the type of described structured query sentence according to the title of described configuration file, and generate instruction code based on the described type determined; Described instruction code is sqc instruction code.
8. the operational order automatic generation method of structure based query language according to claim 7, is characterized in that, that determines the operational order generated according to the title of described configuration file deposits path.
9. the operational order automatic generation method of structure based query language according to claim 8, it is characterized in that, the title of described configuration file comprises the mark for identifying the operator scheme to database, and described operator scheme is at least one in vernier mode, generation patterns, preference pattern and ordered mode.
10. the operational order automatic generation method of structure based query language according to claim 7, it is characterized in that, in described step (B2), the DESCRIBE order of embedded sql and SQLDA data structure is utilized to obtain input parameter and the result set information of described structured query sentence.
The operational order automatic generation method of 11. structure based query languages according to claim 10, is characterized in that, the described instruction code generated is compiled into static state and/or kinematic function storehouse.
The operational order automatic generation method of 12. structure based query languages according to claim 11, is characterized in that, according to demand, to the input variable assignment of the function in described function library, to obtain the execution result under different condition.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201010599456.6A CN102541521B (en) | 2010-12-17 | 2010-12-17 | Automatic operating instruction generating device based on structured query language and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201010599456.6A CN102541521B (en) | 2010-12-17 | 2010-12-17 | Automatic operating instruction generating device based on structured query language and method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102541521A CN102541521A (en) | 2012-07-04 |
| CN102541521B true CN102541521B (en) | 2015-03-25 |
Family
ID=46348500
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201010599456.6A Active CN102541521B (en) | 2010-12-17 | 2010-12-17 | Automatic operating instruction generating device based on structured query language and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102541521B (en) |
Families Citing this family (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104102479B (en) * | 2013-04-10 | 2017-09-15 | 北汽福田汽车股份有限公司 | A kind of automatic generation method of OBD variable-definitions source file |
| CN105573774B (en) * | 2014-11-05 | 2019-04-05 | 中国银联股份有限公司 | Application Parameters management and configuration method |
| CN106095792A (en) * | 2016-05-27 | 2016-11-09 | 中国银联股份有限公司 | The method and apparatus generating database manipulation code |
| CN106301891A (en) * | 2016-08-02 | 2017-01-04 | 中国银联股份有限公司 | A kind of configuring information of network appliance processing method and processing device |
| CN106844772A (en) * | 2017-02-28 | 2017-06-13 | 东软集团股份有限公司 | The update method and device of application database |
| CN108694172B (en) * | 2017-04-05 | 2021-12-31 | 北京京东尚科信息技术有限公司 | Information output method and device |
| CN107133080A (en) * | 2017-06-14 | 2017-09-05 | 郑州云海信息技术有限公司 | The adding method and system of a kind of order line |
| CN107650123A (en) * | 2017-06-30 | 2018-02-02 | 哈尔滨工大特种机器人有限公司 | A kind of robotic programming method and apparatus of expansible instruction set |
| CN108182215B (en) * | 2017-12-22 | 2021-10-12 | 微梦创科网络科技（中国）有限公司 | Structured Query Language (SQL) performance statistics method and device |
| CN108388588B (en) * | 2018-01-30 | 2021-08-31 | 福建星瑞格软件有限公司 | Database function offline reading method and system of sql statement automatic generation tool |
| CN109509467B (en) * | 2018-11-01 | 2022-06-24 | 北京车和家信息技术有限公司 | Code generation method and device |
| CN109542953B (en) * | 2018-11-29 | 2021-01-05 | 成都四方伟业软件股份有限公司 | Presto-based data processing method and device |
| CN111367937B (en) * | 2020-02-28 | 2023-09-19 | 艾普阳科技（深圳）有限公司 | Data processing method and device |
| CN111897911B (en) * | 2020-06-11 | 2021-08-31 | 中国科学院计算机网络信息中心 | Unstructured data query method and system based on secondary attribute graph |
| CN112328624B (en) * | 2020-11-06 | 2022-07-01 | 瀚高基础软件股份有限公司 | SQL forwarding method and device and readable storage medium |
| CN112783921A (en) * | 2021-01-26 | 2021-05-11 | 中国银联股份有限公司 | Database operation method and device |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101464862A (en) * | 2007-12-21 | 2009-06-24 | 英业达股份有限公司 | SQL generating system and method |
| CN101673287A (en) * | 2009-10-16 | 2010-03-17 | 金蝶软件（中国）有限公司 | SQL sentence generation method and system |
| CN101788992A (en) * | 2009-05-06 | 2010-07-28 | 厦门东南融通系统工程有限公司 | Method and system for converting query sentence of database |
-
2010
- 2010-12-17 CN CN201010599456.6A patent/CN102541521B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101464862A (en) * | 2007-12-21 | 2009-06-24 | 英业达股份有限公司 | SQL generating system and method |
| CN101788992A (en) * | 2009-05-06 | 2010-07-28 | 厦门东南融通系统工程有限公司 | Method and system for converting query sentence of database |
| CN101673287A (en) * | 2009-10-16 | 2010-03-17 | 金蝶软件（中国）有限公司 | SQL sentence generation method and system |
Non-Patent Citations (1)
| Title |
|---|
| Streaming XPath Queries in XSQ:A Demonstration;Feng Peng,Sudarshan S.Chawathe;《Proceedings of the 19th International Conference on Data Engineering》;20031231;第780-782页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102541521A (en) | 2012-07-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102541521B (en) | Automatic operating instruction generating device based on structured query language and method | |
| CN104133772A (en) | Automatic test data generation method | |
| US8930919B2 (en) | Modernization of legacy software systems based on modeled dependencies | |
| CN106874244B (en) | Method for constructing automatic document generation model based on work sequence | |
| CN105335412A (en) | Method and device for data conversion and data migration | |
| CN102915242A (en) | Method for implementing code programming by graphical operations | |
| CN104360865A (en) | Serialization method, deserialization method and related equipment | |
| CN106648587A (en) | Annotation-based Web application code generation method | |
| CN103150165A (en) | Frame and method for building outdoor data acquisition program | |
| US9619212B2 (en) | Providing code, code generator and software development environment | |
| CN102591787B (en) | The data processing method of JAVA card and device | |
| CN101866315A (en) | Test method and system of software development tool | |
| CN103065000A (en) | MDE (model driven engineering)-based method for analyzing and verifying SysML state machine diagram | |
| CN103631590A (en) | Method for editing automated testing script | |
| CN104391731A (en) | Editing method based on C# and irrelevant to data types | |
| CN101154227A (en) | Code generation method based on ASN type object | |
| CN101561671A (en) | Method for deigning ladder diagram based on components | |
| CN103235757B (en) | Several apparatus and method that input domain tested object is tested are made based on robotization | |
| CN101826017B (en) | Granule-oriented programming, integrating and developing platform | |
| CN105468366A (en) | Intelligent interface based on Qt ground station | |
| CN111190814A (en) | Software test case generation method and device, storage medium and terminal | |
| CN101201750B (en) | Method of providing data for encoding/decoding using syntax lexical analysis tool | |
| CN103793653A (en) | Program dependence relationship analysis method and system based on tree optimization | |
| CN104281604A (en) | Method and system for generating Target Link data dictionary hierarchical tree | |
| CN112416367B (en) | Application resource change influence analysis system based on software reverse disassembly and analysis |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |