CN105335366A - SQL statement processing method and apparatus and server - Google Patents
SQL statement processing method and apparatus and server Download PDFInfo
- Publication number
- CN105335366A CN105335366A CN201410240354.3A CN201410240354A CN105335366A CN 105335366 A CN105335366 A CN 105335366A CN 201410240354 A CN201410240354 A CN 201410240354A CN 105335366 A CN105335366 A CN 105335366A
- Authority
- CN
- China
- Prior art keywords
- syntax tree
- sql
- sql statement
- converted
- statement
- 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
- 238000003672 processing method Methods 0.000 title abstract 3
- 238000000034 method Methods 0.000 claims abstract description 23
- 230000009466 transformation Effects 0.000 claims description 17
- 238000006243 chemical reaction Methods 0.000 abstract description 19
- 241000283726 Bison Species 0.000 description 4
- 238000010586 diagram Methods 0.000 description 4
- 230000006870 function Effects 0.000 description 3
- 241001269238 Data Species 0.000 description 2
- 230000007547 defect Effects 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 230000026676 system process Effects 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides an SQL statement processing method and apparatus and a server. The method comprises: acquiring a to-be-converted SQL statement; analyzing the obtained SQL statement to generate a first syntax tree; converting the first syntax tree into a non-SQL second syntax tree, wherein semantics of the second syntax tree is the same as that of the first syntax; and traversing the second syntax tree to obtain a non-SQL statement corresponding to the second syntax tree. According to the SQL statement processing method and apparatus and the server provided by the present invention, an SQL statement is converted into a non-SQL statement by conversion of a syntax tree without the need for manual conversion, thereby lowering the error-rate of the conversion process, and improving the SQL statement conversion efficiency.
Description
Technical field
The present invention relates to data processing field, particularly relate to a kind of SQL statement disposal route, device and server.
Background technology
XML data base management system (XMLDBMS) is in recent years fast-developing a kind of novel data base management system (DBMS) (DBMS), and it is XML document for the data storing and retrieve.XML data is a kind of non-relational data, and its retrieval and renewal are completed by XQuery and XQueryUpdate of standard.And the data in the relevant databases such as SQL can not directly be applied in XMLDBMS, could apply in XMLDBMS after needing that SQL statement is converted into XQuery statement and supply user to inquire about.
The deficiencies in the prior art part is: for the user of SQL accustomed to using, and learn and grasp the new query language of use one needs cost plenty of time and energy; And, existing query statement SQL statement being converted into relational data carries out craft by database manipulation personnel to be completed, cannot accomplish that large batch of statement is changed in this manner, and easily occur corresponding grammer, semantic conversion mistake in transfer process.
Summary of the invention
For overcoming above-mentioned defect, the invention provides a kind of SQL statement disposal route, device and server.
First aspect, the embodiment of the present invention provides a kind of SQL statement disposal route, and described method comprises:
Obtain SQL statement to be converted;
Resolve the described SQL statement obtained, generate the first syntax tree;
Described first syntax tree is converted to second syntax tree of non-SQL, the semanteme of described second syntax tree is identical with described first syntax tree;
Travel through described second syntax tree, obtain the non-SQL statement that described second syntax tree is corresponding.
Preferably, described method also comprises:
Obtained described non-SQL statement is stored in Native mode.
Preferably, described the second syntax tree described first syntax tree being converted to non-SQL specifically comprises:
Travel through all nodes of described first syntax tree;
According to the transformation rule preset, all nodes of described first syntax tree are converted to the corresponding node of described second syntax tree of non-SQL.
Preferably, described non-SQL is XQuery language.
Second aspect, the embodiment of the present invention provides a kind of SQL statement treating apparatus, and described device comprises:
Acquisition module, for obtaining SQL statement to be converted;
Parsing module, for resolving the described SQL statement of acquisition, generates the first syntax tree;
First processing module, for described first syntax tree being converted to second syntax tree of non-SQL, the semanteme of described second syntax tree is identical with described first syntax tree;
Second processing module, for traveling through described second syntax tree, obtains the non-SQL statement that described second syntax tree is corresponding.
Preferably, described device also comprises:
Memory module, for storing obtained described non-SQL statement in Native mode.
Preferably, described first processing module specifically for:
Travel through all nodes of described first syntax tree;
According to the transformation rule preset, all nodes of described first syntax tree are converted to the corresponding node of described second syntax tree of non-SQL.
Preferably, described non-SQL is XQuery.
The third aspect, the embodiment of the present invention provides a kind of server, and described server comprises above-mentioned SQL statement treating apparatus.
SQL statement disposal route, device and server that the embodiment of the present invention provides, SQL statement is converted to the statement of non-SQL by the mode set by Transformational Grammar, without the need to artificial conversion, reduce the error rate in the middle of transfer process, improve the conversion efficiency of SQL statement; And the user of SQL accustomed to using is without the need to require efforts and the time learns and grasps the new query language of use one, convenient for users to use.
Accompanying drawing explanation
In order to be illustrated more clearly in the embodiment of the present invention or technical scheme of the prior art, be briefly described to the accompanying drawing used required in embodiment or description of the prior art below, apparently, accompanying drawing in the following describes is some embodiments of the present invention, for those of ordinary skill in the art, under the prerequisite not paying creative work, other accompanying drawing can also be obtained according to these accompanying drawings.
Fig. 1 represents the process flow diagram of SQL statement disposal route.
Fig. 2 represents the syntax tree schematic diagram of SQL statement in the another embodiment of SQL statement disposal route.
Fig. 3 represents the syntax tree schematic diagram of XQuery statement in the another embodiment of SQL statement disposal route.
Fig. 4 represents the structural representation of SQL statement treating apparatus.
Embodiment
For making the object of the embodiment of the present invention, technical scheme and advantage clearly, below in conjunction with the accompanying drawing in the embodiment of the present invention, technical scheme in the embodiment of the present invention is clearly and completely described, obviously, described embodiment is the present invention's part embodiment, instead of whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art, not making the every other embodiment obtained under creative work prerequisite, belong to the scope of protection of the invention.
As shown in Figure 1, described method comprises a kind of process flow diagram of SQL statement disposal route:
Step 100. obtains SQL statement to be converted;
Step 101. resolves the described SQL statement obtained, and generates the first syntax tree;
Described first syntax tree is converted to second syntax tree of non-SQL by step 102., and the semanteme of described second syntax tree is identical with described first syntax tree;
Step 103. travels through described second syntax tree, obtains the non-SQL statement that described second syntax tree is corresponding.
Particularly, described SQL statement is SQL query statement.
By description above, SQL statement is converted to the statement of non-SQL by the mode set by Transformational Grammar, without the need to artificial conversion, reduces the error rate in the middle of transfer process, improves the conversion efficiency of SQL statement.
The SQL statement disposal route that the present embodiment provides can be used for user in digital library and retrieves books, the place that the user that also can be used for website retrieves information.
Present has something to do database can operate non-relation data in xml form, but these non-relation datas are not with Native mode storing X ML data, but then advanced row Data Division stores with the form of relation data, and when this will inevitably cause processing non-relation data, system performance is low.
In the present embodiment, described method also comprises:
Obtained described non-SQL statement is stored in Native mode.
By aforesaid operations, store obtained described non-SQL statement in Native mode, store again after non-relation data is converted to relation data, improve the efficiency of the non-relation data of system process.
Particularly, described the second syntax tree described first syntax tree being converted to non-SQL specifically comprises:
Travel through all nodes of described first syntax tree;
According to the transformation rule preset, all nodes of described first syntax tree are converted to the corresponding node of described second syntax tree of non-SQL.
Particularly, the present embodiment does not make specific restriction to the direction of traversal, can from the root node of syntax tree, can also from the leaf node of syntax tree.
Transformation rule comprises:
1) the where clause in SQL statement, be converted into XQuery where clause and using the parameter information in the where clause in SQL statement as the parameter information in the Where clause of Xquery;
2) the from clause in SQL, is converted into for clause in XQuery and using doc or container of the table information in from clause as clause in XQuery, the parameter of collection function;
3) the select clause in SQL, is converted into return clause in XQuery and using the return clause parameter of the parameter in select clause as XQuery;
4) the insert clause in SQL, is converted into insert clause in XQuery and using the parameter of the parameter in the insert clause of SQL as the insert clause in XQuery;
5) the update clause in SQL, is converted into replace clause in XQuery and using the parameter of the parameter in the update clause of SQL as replace clause in XQuery;
6) the delete clause in SQL, is converted into delete clause in XQuery and using the parameter of the parameter in the delete clause of SQL as delete clause in XQuery.
The SQL statement transformation rule proposed in the present embodiment is not limited to above-mentioned several, in the transformation rule that other transformation rules that SQL statement can be converted to non-SQL statement can describe in the present embodiment, is not repeating here.
Particularly, described non-SQL is XQuery language.
Further, described non-SQL can also be the language of other existing non-relation datas, and the present embodiment repeats no more.
Further, resolve described the described SQL statement obtained, generate in the first syntax tree:
According to the described SQL statement obtained, by the first syntax tree described in parser generation.
Particularly, described syntax analyzer includes but not limited to: Lex and Bison.
By following be that embodiment is further described SQL statement disposal route.
A corresponding SQL query statement, it needed to experience several step before real being processed, and one of them is: generate corresponding abstract syntax tree according to its grammer defined, semantic rules by Lex/Bison.We claim this stage to be parsing (Parse) stage of query statement.In the query parse stage, system can according to the predefined grammer of people, and semantic rules is resolved the query statement that we will perform and generated corresponding abstract syntax tree according to corresponding semantic rules.
SQL query statement in relational database has a set of grammatical and semantic rule, and XQuery has a set of syntax and semantics rule of oneself too.Although SQL and XQuery has distinct syntax and semantics rule, a SQL statement and an XQuery statement can produce similar output object after resolving through Lex/Bison: abstract syntax tree.Abstract syntax tree (abstractsyntaxtree or be abbreviated as AST), or syntax tree (syntaxtree) are the tree-shaped forms of expression of the abstract syntax structure of SQL query statement or Xquery query statement source code.Each node on tree represents a kind of structure in query statement.Such as, be similar to select, the such statement of where, for all represents with the node of branch.For query statement selectnamefromNamewhereperson_id=1 and its syntax tree at relation data of for $ iindoc (" Name.xml ") where $ i/person/id=1return $ i/person/name as shown in Figure 2 with its abstract syntax tree under XML data storehouse as shown in Figure 3.
In order to can better and dynamic-configuration SQL statement to the conversion of XQuery statement, we are based on the basis of abstract syntax tree defining one group of transformation rule based on abstract syntax tree, after a SQL statement generates abstract syntax tree, one group of rule that we define is applied on this abstract syntax tree, the node of abstract syntax tree SQL statement generated is changed according to rule, be converted into the abstract syntax tree form required for Xquery statement, after completing conversion, can according to this abstract syntax tree generate this SQL statement corresponding XQuery statement of equal value.
Wherein transformation rule is as follows:
1) the where clause in SQL statement, be converted into XQuery where clause and using the parameter information in the where clause in SQL statement as the parameter information in the Where clause of Xquery.
2) the from clause in SQL, is converted into for clause in XQuery and using doc or container of the table information in from clause as clause in XQuery, the parameter of collection function.
3) the select clause in SQL, is converted into return clause in XQuery and using the return clause parameter of the parameter in select clause as XQuery.
4) the insert clause in SQL, is converted into insert clause in XQuery and using the parameter of the parameter in the insert clause of SQL as the insert clause in XQuery.
5) the update clause in SQL, is converted into replace clause in XQuery and using the parameter of the parameter in the update clause of SQL as replace clause in XQuery.
6) the delete clause in SQL, is converted into delete clause in XQuery and using the parameter of the parameter in the delete clause of SQL as delete clause in XQuery.
For above-mentioned transformation rule, we can be saved in predefine rule file, so that user can self-defined transformation rule, thus can meet the demand of different user dynamically.
After completing the definition of above-mentioned transformation rule, the concrete steps of SQL statement conversion XQuery statement can be divided into following process:
1) generation phase of primitive abstractions syntax tree.
When after a SQL statement arrival system, first this SQL statement can be generated the first original syntax tree by us, and this process is generated according to predefined SQL semantic rules by we above-mentioned said Lex/Bison.
2) regular fetch phase
After generating the first abstract syntax tree for SQL statement, predefined rule file is read in system so that subsequent step uses by we.
3) the predefine rule application stage
Above-mentioned predefined transformation rule is applied to primitive abstractions that SQL statement generates grammatically, first the rule of process for processing the leaf node of primitive abstractions syntax tree: apply the corresponding node on second syntax tree of the XQuery of above-mentioned generate rule corresponding to it respectively according to the type of leaf node, if the type that the type nonsystematic of this node is supported, then system throw exception mistake and termination rules application.
After processing leaf node, the processed leaf node completed removes by we from abstract syntax tree, now father's node of this leaf node becomes leaf node by original non-leaf nodes, then to this new leaf node application transformation rule, the node of the XQuery abstract syntax tree that this node generates is as the father node of just now generated existing XQuery abstract syntax tree node.We repeat above-mentioned processing procedure until the first abstract syntax tree that SQL generates has completed rule conversion all.
4) XQuery statement generation phase
After the conversion of the first syntax tree completing SQL, we obtain new XQuery second syntax tree, just can obtain after we travel through it its for XQuery statement.
We are to after the process of the abstract syntax tree of SQL, we will obtain an XQuery abstract syntax tree corresponding to it, our known XQuery abstract syntax tree is being semantically two syntax trees of equal value with SQL abstract syntax tree, and therefore this kind of conversion can not cause semantic loss or the escape of semanteme.
By the description of above-mentioned two embodiments, the SQL statement disposal route that the application provides, SQL statement is converted to the statement of non-SQL by the mode set by Transformational Grammar, without the need to artificial conversion, reduce the error rate in the middle of transfer process, improve the conversion efficiency of SQL statement; And the user of SQL accustomed to using is without the need to require efforts and the time learns and grasps the new query language of use one, convenient for users to use.
As shown in Figure 4, described device comprises a kind of example structure of SQL statement treating apparatus:
Acquisition module 10, for obtaining SQL statement to be converted;
Parsing module 20, for resolving the described SQL statement of acquisition, generates the first syntax tree;
First processing module 30, for described first syntax tree being converted to second syntax tree of non-SQL, the semanteme of described second syntax tree is identical with described first syntax tree;
Second processing module 40, for traveling through described second syntax tree, obtains the non-SQL statement that described second syntax tree is corresponding.
Particularly, described device also comprises:
Memory module, for storing obtained described non-SQL statement in Native mode.
Particularly, described first processing module specifically for:
Travel through all nodes of described first syntax tree;
According to the transformation rule preset, all nodes of described first syntax tree are converted to the corresponding node of described second syntax tree of non-SQL.
Particularly, described non-SQL is XQuery.
Also propose a kind of server in the present embodiment, described server comprises above-mentioned SQL statement treating apparatus.
The SQL statement treating apparatus device provided in the present embodiment and the function of server and treatment scheme, see the flow process of the SQL statement disposal route embodiment provided above, can repeat no more herein.
By the description of above-described embodiment, the SQL statement treating apparatus that the application provides and server, SQL statement is converted to the statement of non-SQL by the mode set by Transformational Grammar, without the need to artificial conversion, reduce the error rate in the middle of transfer process, improve the conversion efficiency of SQL statement; And the user of SQL accustomed to using is without the need to require efforts and the time learns and grasps the new query language of use one, convenient for users to use.
One of ordinary skill in the art will appreciate that: all or part of step realizing said method embodiment can have been come by the hardware that programmed instruction is relevant.Aforesaid program can be stored in a computer read/write memory medium.This program, when performing, performs the step comprising above-mentioned each embodiment of the method; And aforesaid storage medium comprises: ROM, RAM, magnetic disc or CD etc. various can be program code stored medium.
Last it is noted that above each embodiment is only in order to illustrate technical scheme of the present invention, be not intended to limit; Although with reference to foregoing embodiments to invention has been detailed description, those of ordinary skill in the art is to be understood that: it still can be modified to the technical scheme described in foregoing embodiments, or carries out equivalent replacement to wherein some or all of technical characteristic; And these amendments or replacement, do not make the essence of appropriate technical solution depart from the scope of various embodiments of the present invention technical scheme.
Claims (9)
1. a SQL statement disposal route, is characterized in that, described method comprises:
Obtain SQL statement to be converted;
Resolve the described SQL statement obtained, generate the first syntax tree;
Described first syntax tree is converted to second syntax tree of non-SQL, the semanteme of described second syntax tree is identical with described first syntax tree;
Travel through described second syntax tree, obtain the non-SQL statement that described second syntax tree is corresponding.
2. SQL statement disposal route according to claim 1, is characterized in that, described method also comprises:
Obtained described non-SQL statement is stored in Native mode.
3. SQL statement disposal route according to claim 1, is characterized in that, described the second syntax tree described first syntax tree being converted to non-SQL specifically comprises:
Travel through all nodes of described first syntax tree;
According to the transformation rule preset, all nodes of described first syntax tree are converted to the corresponding node of described second syntax tree of non-SQL.
4. SQL statement disposal route according to claim 1, is characterized in that, described non-SQL is XQuery language.
5. a SQL statement treating apparatus, is characterized in that, described device comprises:
Acquisition module, for obtaining SQL statement to be converted;
Parsing module, for resolving the described SQL statement of acquisition, generates the first syntax tree;
First processing module, for described first syntax tree being converted to second syntax tree of non-SQL, the semanteme of described second syntax tree is identical with described first syntax tree;
Second processing module, for traveling through described second syntax tree, obtains the non-SQL statement that described second syntax tree is corresponding.
6. SQL statement treating apparatus according to claim 5, is characterized in that, described device also comprises:
Memory module, for storing obtained described non-SQL statement in Native mode.
7. SQL statement treating apparatus according to claim 5, is characterized in that, described first processing module specifically for:
Travel through all nodes of described first syntax tree;
According to the transformation rule preset, all nodes of described first syntax tree are converted to the corresponding node of described second syntax tree of non-SQL.
8. SQL statement treating apparatus according to claim 5, is characterized in that, described non-SQL is XQuery.
9. a server, is characterized in that, described server comprises the SQL statement treating apparatus described in claim 5-8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410240354.3A CN105335366A (en) | 2014-05-30 | 2014-05-30 | SQL statement processing method and apparatus and server |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410240354.3A CN105335366A (en) | 2014-05-30 | 2014-05-30 | SQL statement processing method and apparatus and server |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105335366A true CN105335366A (en) | 2016-02-17 |
Family
ID=55285909
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410240354.3A Pending CN105335366A (en) | 2014-05-30 | 2014-05-30 | SQL statement processing method and apparatus and server |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105335366A (en) |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105787044A (en) * | 2016-02-26 | 2016-07-20 | 广州品唯软件有限公司 | MySQL based SQL parser and parsing method thereof |
| CN107273504A (en) * | 2017-06-19 | 2017-10-20 | 浪潮软件集团有限公司 | A Kudu-based data query method and device |
| CN108182069A (en) * | 2017-12-28 | 2018-06-19 | 深圳市创梦天地科技股份有限公司 | Programming language transformation method, terminal device and computer-readable medium |
| CN109857757A (en) * | 2019-01-22 | 2019-06-07 | 珠海格力电器股份有限公司 | Statement conversion method, system and terminal between databases |
| WO2019237333A1 (en) * | 2018-06-15 | 2019-12-19 | Entit Software Llc | Converting database language statements between dialects |
| CN110806999A (en) * | 2018-07-19 | 2020-02-18 | 上海擎感智能科技有限公司 | Method and device for managing CSV file |
| CN112765209A (en) * | 2021-02-07 | 2021-05-07 | 浪潮云信息技术股份公司 | SQL statement syntax migration method and system between databases |
| CN114764558A (en) * | 2021-01-14 | 2022-07-19 | 京东科技控股股份有限公司 | SQL dialect conversion method, device, system and storage medium |
| CN115237938A (en) * | 2022-07-13 | 2022-10-25 | 中国平安财产保险股份有限公司 | Data processing method and device based on artificial intelligence, electronic equipment and medium |
| CN115859956A (en) * | 2022-12-02 | 2023-03-28 | 中孚安全技术有限公司 | Self-adaptive method and system for parsing SQL grammar based on abstract syntax tree |
| CN115981791A (en) * | 2019-05-23 | 2023-04-18 | 创新先进技术有限公司 | System interaction method, device, equipment and storage medium |
| CN116701235A (en) * | 2023-08-04 | 2023-09-05 | 上海安般信息科技有限公司 | Fuzzy test method based on grammar correct variation and semantic effective instantiation |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101561817A (en) * | 2009-06-02 | 2009-10-21 | 天津大学 | Conversion algorithm from XQuery to SQL query language and method for querying relational data |
| CN101667190A (en) * | 2009-09-29 | 2010-03-10 | 天津大学 | XQuery-based query engine system |
| CN101719156A (en) * | 2009-12-30 | 2010-06-02 | 南开大学 | System of seamless integrated pure XML query engine in relational database |
-
2014
- 2014-05-30 CN CN201410240354.3A patent/CN105335366A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101561817A (en) * | 2009-06-02 | 2009-10-21 | 天津大学 | Conversion algorithm from XQuery to SQL query language and method for querying relational data |
| CN101667190A (en) * | 2009-09-29 | 2010-03-10 | 天津大学 | XQuery-based query engine system |
| CN101719156A (en) * | 2009-12-30 | 2010-06-02 | 南开大学 | System of seamless integrated pure XML query engine in relational database |
Non-Patent Citations (1)
| Title |
|---|
| 刘永伟: "基于Web服务的SQL到XQuery查询转换系统的研究", 《中国优秀硕士论文全文数据库 信息科学辑》 * |
Cited By (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105787044A (en) * | 2016-02-26 | 2016-07-20 | 广州品唯软件有限公司 | MySQL based SQL parser and parsing method thereof |
| CN107273504A (en) * | 2017-06-19 | 2017-10-20 | 浪潮软件集团有限公司 | A Kudu-based data query method and device |
| CN108182069A (en) * | 2017-12-28 | 2018-06-19 | 深圳市创梦天地科技股份有限公司 | Programming language transformation method, terminal device and computer-readable medium |
| CN108182069B (en) * | 2017-12-28 | 2021-03-02 | 深圳市创梦天地科技股份有限公司 | Program language conversion method, terminal device and computer readable medium |
| US12204528B2 (en) | 2018-06-15 | 2025-01-21 | Micro Focus Llc | Converting database language statements between dialects |
| WO2019237333A1 (en) * | 2018-06-15 | 2019-12-19 | Entit Software Llc | Converting database language statements between dialects |
| CN110806999A (en) * | 2018-07-19 | 2020-02-18 | 上海擎感智能科技有限公司 | Method and device for managing CSV file |
| CN109857757A (en) * | 2019-01-22 | 2019-06-07 | 珠海格力电器股份有限公司 | Statement conversion method, system and terminal between databases |
| CN115981791A (en) * | 2019-05-23 | 2023-04-18 | 创新先进技术有限公司 | System interaction method, device, equipment and storage medium |
| CN114764558A (en) * | 2021-01-14 | 2022-07-19 | 京东科技控股股份有限公司 | SQL dialect conversion method, device, system and storage medium |
| CN112765209A (en) * | 2021-02-07 | 2021-05-07 | 浪潮云信息技术股份公司 | SQL statement syntax migration method and system between databases |
| CN115237938A (en) * | 2022-07-13 | 2022-10-25 | 中国平安财产保险股份有限公司 | Data processing method and device based on artificial intelligence, electronic equipment and medium |
| CN115859956A (en) * | 2022-12-02 | 2023-03-28 | 中孚安全技术有限公司 | Self-adaptive method and system for parsing SQL grammar based on abstract syntax tree |
| CN116701235A (en) * | 2023-08-04 | 2023-09-05 | 上海安般信息科技有限公司 | Fuzzy test method based on grammar correct variation and semantic effective instantiation |
| CN116701235B (en) * | 2023-08-04 | 2023-10-31 | 上海安般信息科技有限公司 | Fuzzy test method based on grammar correct variation and semantic effective instantiation |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20240012810A1 (en) | Clause-wise text-to-sql generation | |
| CN105868204B (en) | A kind of method and device for converting Oracle scripting language SQL | |
| CN104391730B (en) | A kind of software source codes language translation system and method | |
| CN115525768A (en) | Visual construction method and device for domain knowledge graph | |
| CN107515887B (en) | An Interactive Query Method Applicable to Various Big Data Management Systems | |
| CN107291807B (en) | SPARQL query optimization method based on graph traversal | |
| CN107451153A (en) | The method and apparatus of export structure query statement | |
| Comyn-Wattiau et al. | Model driven reverse engineering of NoSQL property graph databases: The case of Neo4j | |
| CN113094449A (en) | Large-scale knowledge map storage scheme based on distributed key value library | |
| US20190387056A1 (en) | Irc-infoid data standardization for use in a plurality of mobile applications | |
| CN107491476B (en) | Data model conversion and query analysis method suitable for various big data management systems | |
| CN106933869A (en) | A kind of method and apparatus of operating database | |
| CN116204660A (en) | Multi-source heterogeneous data driven domain knowledge graph construction system method | |
| CN114116779A (en) | Deep learning-based power grid regulation and control field information retrieval method, system and medium | |
| CN115878814A (en) | Knowledge graph question-answering method and system based on machine reading understanding | |
| CN105302842A (en) | Data processing method and device | |
| CN113220800B (en) | ANTLR-based data field blood-edge analysis method and device | |
| CN118760734A (en) | A machining process information query method, device and storage medium | |
| Demey et al. | A markup language for ORM business rules | |
| CN117608652A (en) | A SQL statement translation method based on high-level abstract syntax tree | |
| CN114610724B (en) | KV-based database logic plan caching method and device | |
| WO2020259460A1 (en) | Method and apparatus for acquiring command line multiway tree of data network device | |
| CN103902651B (en) | Cloud code query method and device based on MongoDB | |
| Su-Cheng et al. | Mapping of extensible markup language-to-ontology representation for effective data integration | |
| CN115344714A (en) | Academic knowledge question-answering method, system, equipment and storage medium based on semantic component |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20160217 |