CN101788992A - Method and system for converting query sentence of database - Google Patents
Method and system for converting query sentence of database Download PDFInfo
- Publication number
- CN101788992A CN101788992A CN200910111755A CN200910111755A CN101788992A CN 101788992 A CN101788992 A CN 101788992A CN 200910111755 A CN200910111755 A CN 200910111755A CN 200910111755 A CN200910111755 A CN 200910111755A CN 101788992 A CN101788992 A CN 101788992A
- Authority
- CN
- China
- Prior art keywords
- compiler
- database
- statement
- query
- operation system
- 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
- 238000000034 method Methods 0.000 title claims abstract description 34
- 238000004458 analytical method Methods 0.000 claims abstract description 32
- 230000006870 function Effects 0.000 claims abstract description 19
- 238000012545 processing Methods 0.000 claims description 28
- 230000008569 process Effects 0.000 claims description 18
- 238000013519 translation Methods 0.000 claims description 13
- 230000002452 interceptive effect Effects 0.000 claims description 9
- 238000006243 chemical reaction Methods 0.000 claims description 8
- 238000012546 transfer Methods 0.000 claims description 6
- 238000013461 design Methods 0.000 claims description 5
- 230000008676 import Effects 0.000 claims description 5
- 241000239290 Araneae Species 0.000 claims description 3
- 238000010276 construction Methods 0.000 claims description 3
- 230000001419 dependent effect Effects 0.000 claims description 3
- 238000010200 validation analysis Methods 0.000 abstract 1
- 238000004519 manufacturing process Methods 0.000 description 8
- 230000000576 supplementary effect Effects 0.000 description 5
- 238000005516 engineering process Methods 0.000 description 4
- 238000009795 derivation Methods 0.000 description 3
- 238000010586 diagram Methods 0.000 description 3
- 230000000694 effects Effects 0.000 description 3
- 230000008901 benefit Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000012937 correction Methods 0.000 description 1
- 239000012467 final product Substances 0.000 description 1
- 238000007620 mathematical function Methods 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a method and a system for converting the query sentence of a database. After a database table and a field are set, the name and field of the required database are selected in the foreground and the self-defined query sentence is inputted by a user according to the service requirement, and the query sentence inputted by the user is subjected to grammar analysis and validation, thus finishing the analysis by scanning the query sentence for only one time. By converting the service Chinese query sentence into a standard English SQL (structured query language) query sentence required by a service system, the invention fulfills the function of converting a service database query sentence into a standard executable SQL sentence, wherein the sentence acquired by the service system is directly available to the system, so that a common user can flexibly and freely use the database without mastering the query tool, SQL syntax and other professional technique of the database.
Description
Technical field
The present invention relates to a kind of conversion method and converting system of query sentence of database.
Background technology
In the at present large-scale software application system, often need get up to use program and database combination.The inquiry of these databases can also can be undertaken by the data base tool that the database business men provides by the query function that software application system provided.Because the query function that provides in the software application system all is pre-designed, when the user need carry out new inquiry, can only realize by upgrade-system, exist on the time to lag behind, and still can't satisfy in the future possible new demand.Inquire about by data base tool and can satisfy the query demand that the user increases newly at any time, but if user's data base tool and be familiar with SQL (Structured Query Language (SQL)) grammer (be generally English) on top of, just can not be flexibly, Query Database freely, cause the inconvenience in the use.
Summary of the invention
The object of the present invention is to provide a kind ofly, make it under the situation of not grasping professional techniques such as database query tools and SQL grammer, the query statement of user's input is converted to the method and system of the query statement that database can carry out towards domestic consumer.
A kind of conversion method of query sentence of database comprises following step:
The user selects the required database table title and the field of this database table on the foreground, import self-defining query sentence of database according to service needed, compiler is after receiving query sentence of database, at first query sentence of database is scanned, the process of lexical analysis carried out in the reading inquiry statement, and the byte stream sequence is changed into the discernible mark stream of compiler; Described syntactic analyser obtains the streamed source code of mark from scanning sequence, according to the rule in the syntactic definition query sentence of database is carried out grammatical analysis;
After query sentence of database is carried out morphology and grammatical analysis, if find this statement mistake, then send grammer authentication error information, and miscue comparatively accurately is provided; If checking is correct, the grammer of representing this query sentence of database is correct, and then an abstract syntax tree that meets this statement will be constructed and be traveled through to compiler, and extract relevant nodal information as required, formed the compiler model object, sent the information that is proved to be successful, the grammer checking finishes;
Step 3, translation database query statement and obtain business datum
Receive after grammer is proved to be successful information, this compiler model object is responsible for receiving the business datum that translater is passed back, and carries out translating operation; Described translater provides the various interactive actions with the operation system query sentence of database, this translater is responsible for receiving the processing of information such as the table name, field name of operation system and related service data content, the data that compiler is required are passed to the compiler model object, and the result is returned to operation system, extract use for operation system, finish transfer control and processing business datum.
A kind of converting system of query sentence of database, mainly comprise translater and compiler two large divisions, described translater provide with the various interactive actions of operation system query statement and with the data processing function of compiler, translater is responsible for receiving the processing of information such as the table name, field name of operation system and related service data content, the data that compiler is required are passed to the compiler model object, and the result is returned to business is 3, extract use for operation system, finish transfer control and processing business datum; This compiler is responsible for the core work of grammer checking and data processing etc.; The model object of described compiler is used for constructing compiler model object base class, nodal information content when being used to carry out traversal syntax tree behind the common process of query sentence of database and the memory compiler syntax parsing, by this model object content is passed to translater, be responsible for carrying out alternately with operation system by translater.
Described query statement comprises conventional statement, appends statement, comparison statement, loop statement and self-defined inquiry statement.
Described translater mainly comprises:
Query statement receiver module 110: be used to receive the query sentence of database that operation system is imported into, and pass to compiler and resolve checking;
Storehouse table information setting module 111 and field information are provided with module 112: Chinese is shown in the storehouse that is used for obtaining according to compiler, receive storehouse table English name, the field Chinese and English title of operation system and be used for the supplementary of interim storage service related data, and pass these contents back compiler and handle;
Each calls information setting module 113: be used for the another name information obtained according to compiler, receive corresponding English another name and also pass compiler back;
Loop variant values is provided with module 114: be used for the loop variable obtained according to compiler, the value that receives the loop variable of operation system is also passed compiler back and is handled;
Query statement translation module 115: be used for giving compiler processes with business Chinese database query statement, the English query statement of the standard of translating into, and will comprise that the various results of sky query statement, empty perform statement, complete perform statement send to operation system;
Query statement changes XML format module 116: be used to the system data of managing business, and query sentence of database is changed into the XML form, content is dumped to the operation system database, make things convenient for the operation of operation system;
The XML form changes query statement module 117: be used for the content of the existing XML form of operation system database is changed into the discernible query sentence of database of converting system and other data, reach the positioning function of business processing;
Compiler model object acquisition module 118: be used to realize and the obtaining of each model object of compiler, and carry out interactive operation;
Authentication error information acquisition module 119: be used to obtain compiler grammer authentication error information, and this error message is sent to operation system;
Query statement format processing module 120: be used for being undertaken the format processing of query sentence of database by compiler;
Each clause's content acquisition module 121: be used for obtaining each clause's content, make things convenient for operation system to extract by each model object of compiler is handled;
Loop variable acquisition module 122 and each another name information acquisition module 124: the information such as loop variable, table alias, field another name that are used to obtain compiler.
Described compiler mainly comprises:
Morphology, grammer and syntax tree analysis module 21: be used for the query statement that translater is passed back is verified parsing work, receive the query statement of businessization, carry out the analysis of lexical analysis, grammatical analysis, syntax tree;
Statement model construction module 22: be used for type, construct corresponding model object in three types of conventional model object, table pooled model object, the table comparison model objects according to the query statement of operation system;
Statement spider module 23: be used to construct compiler model object base class, carry out the common process of query statement and the nodal information that storage travels through the dependent parser tree that is obtained in the syntax tree process;
Clause's constructing module 24: be used to design each generic clause model object, obtain the content item under each clause;
Clause's table, field contents module 25: be used for designing form model object, field model object, but the Chinese and English information of the Chinese and English information of stored data base table, field makes things convenient for the table of compiler, the Chinese and English translation and the format manipulation of field; Structure table alias, field another name, ordering alias object are realized obtaining of various another name information.
Used ANTLR meta-language technical tool (a kind of speech recognition instrument) in the conversion method of a kind of query sentence of database of the present invention and the converting system, use BNF Backus normal form (BNF) (Backus-Naur Form) to carry out syntactic definition, employing realizes based on the grammatical Principles ﹠ Technology of Compiler Design of LL (K), the flexible inquiry and the powerful grammer authentication function of query sentence of database have been realized, the grammer of Analysis of Complex exactly, and can be according to the database table of query sentence of database correspondence, information such as standard word segment table are translated into the executable standard SQL sentence of operation system (database) with the Chinese Query statement of businessization, extract for operation system and use.Five kinds of query statements commonly used such as the present invention supports conventional statement, appends statement, comparison statement, loop statement, self-defined statement.
The present invention is used for syntax parsing checking, the translation of query statement and the related service data extract of statement that the indirect activities system carries out query sentence of database, and the interface with the operation system independence is provided, and any system all can carry out seamless link with this interface.
Description of drawings
Fig. 1 is query sentence of database proof procedure process flow diagram among the present invention;
Fig. 2 is proved to be successful the abstract syntax tree that the back generates for query sentence of database grammer among the present invention;
The business process map that Fig. 3 obtains for query sentence of database translation and data among the present invention;
Fig. 4 is based on system logic Organization Chart of the present invention;
Fig. 5 is based on system architecture figure of the present invention;
Fig. 6 is the framework synoptic diagram of translater among the present invention;
Fig. 7 is the framework synoptic diagram of compiler among the present invention.
The invention will be further described below in conjunction with the drawings and specific embodiments.
Embodiment
The present invention is applicable to auditing system or the operation system based on J2EE framework technology platform, need depend on the underlying table of instrument or the database table of operation system, translation and the business data processing activity that the standard word segment table can carry out query sentence of database.
Shown in Fig. 4,5, comprise translater 1 (Translator) and compiler 2 (Compiler) two large divisions based on converting system of the present invention, translater 1 is responsible for the interworking with operation system 3, and compiler 2 is responsible for the core work of grammer checking and data processing etc.The present invention has used ANTLR meta-language technical tool (a kind of speech recognition instrument), use BNF Backus normal form (BNF) (Backus-Naur Form) to carry out syntactic definition, employing realizes based on the grammatical Principles ﹠ Technology of Compiler Design of LL (K), the flexible inquiry and the powerful grammer authentication function of query sentence of database have been realized, the grammer of Analysis of Complex exactly, and can be according to the database table of query sentence of database correspondence, information such as standard word segment table are translated into the executable standard SQL sentence of operation system (database) with the Chinese Query statement of businessization, extract for operation system and use.Five kinds of query statements 4 commonly used such as the present invention supports conventional statement, appends statement, comparison statement, loop statement, self-defined statement.
The present invention is used for indirect activities system 3 and carries out the syntax parsing checking of query sentence of database, the translation of query statement and the related service data extract of statement, interface with operation system 3 independences is provided, and any system all can carry out seamless link with this interface.
After the user carries out being provided with of Ku Biao and field, select required database table title, the field of this database table on the foreground, import self-defining query statement according to service needed, the present invention can carry out the query sentence of database of user's input the syntax parsing checking, and this query sentence of database of single pass can be finished parsing.The present invention can change into the Chinese Query statement 4 of businessization the English SQL query statement of operation system 3 needed standards, the invention provides the function that business query sentence of database 4 is changed into the SQL statement carried out of standard, operation system can be obtained this statement and directly use in system.
Shown in Fig. 4,6, described translater 1 provide with the various interactive actions of operation system query statement 4 and with the data processing function of compiler 2, query statement 3 comprises conventional statement, appends (merging) statement, comparison statement, loop statement, self-defined inquiry statement.Translater 1 is responsible for receiving the processing of information such as the table name, field name of operation system 3 and related service data content, compiler 2 required data are passed to the compiler model object, and the result is returned to operation system 3, extract use for operation system 3, finish transfer control and processing business datum.Described translater 1 mainly comprises:
Query statement receiver module 110: be used to receive the query sentence of database that operation system 3 is imported into, and pass to compiler 2 and resolve checking;
Storehouse table information setting module 111 and field information are provided with module 112: Chinese is shown in the storehouse that is used for obtaining according to compiler 2, receive storehouse table English name, field Chinese and English title and other supplementarys of operation system 3, and pass these contents (supplementary be used for interim storage service related data) back compiler 2 and handle;
Each calls information setting module 113: the another name information that is used for obtaining according to compiler 2 (table alias, field another name, ordering another name) receives corresponding English another name, and passes compiler 2 back;
Loop variant values is provided with module 114: be used for the loop variable obtained according to compiler 2, receive the value of the loop variable of operation system 3, and pass compiler 3 back and handle;
Query statement translation module 115: be used for giving compiler 2 and handle, translate into standard English query statement, and various results (empty query statement, empty perform statement, complete perform statement) are sent to operation system 3 with business Chinese database query statement 4;
Query statement changes XML format module 116: be used to the system data of managing business, and query sentence of database is changed into the XML form, content is dumped to the operation system database, make things convenient for the operation of operation system 3;
The XML form changes query statement module 117: be used for the content of the existing XML form of operation system database is changed into the discernible query sentence of database of converting system and other data, reach the positioning function of business processing;
Compiler model object acquisition module 118: be used to realize and the obtaining of compiler 2 each model object, and carry out interactive operation;
Authentication error information acquisition module 119: be used to obtain compiler 2 grammer authentication error information, and this error message is sent to operation system 3;
Query statement format processing module 120: be used for being undertaken the format processing of query sentence of database by compiler 2;
Each clause's content acquisition module 121: be used for obtaining each clause's content, make things convenient for operation system 3 to extract by compiler 2 each model object are handled;
Loop variable acquisition module 122 and each another name information acquisition module 123: the information such as loop variable, table alias, field another name that are used to obtain compiler 2.
As shown in Figure 7, the kernel model object (QueryModel) of described compiler 2, be used for constructing compiler 2 model object base class, node (root node, the leaf node) information content when being used to carry out traversal syntax tree behind the common process of query sentence of database and the memory compiler syntax parsing, by this model object content is passed to translater 1, be responsible for carrying out alternately with operation system 3 by translater 1.This compiler 2 mainly comprises:
Morphology, grammer and syntax tree analysis module 21: be used to carry out the query statement checking parsing work that translater 1 is passed back, receive the query statement 4 of businessization, carry out the analysis of lexical analysis, grammatical analysis, syntax tree;
Statement model construction module 22: be used for type (conventional statement, append statement, comparison statement, loop statement, self-defined inquiry statement), construct corresponding model object in three types of the conventional model objects, table pooled model object, table comparison model object according to the query statement 4 of operation system 3;
Statement spider module 23: be used to construct compiler 2 model object base class, carry out the common process of query statement and the nodal information that storage travels through the dependent parser tree (AST) that is obtained in the syntax tree process;
Clause's constructing module 24: be used to design each generic clause (SELECT clause, FROM clause, WHERE clause, GROUP BY clause, ORDER BY clause) model object, realization can be obtained the content item under each clause flexibly;
Clause's table, field contents module 25: be used for designing form model object, field model object, but the Chinese and English information of the Chinese and English information of stored data base table, field makes things convenient for the table of compiler, the Chinese and English translation and the format manipulation of field; Structure table alias, field another name, ordering alias object are realized obtaining of various another name information.
The conversion method of a kind of query sentence of database of the present invention comprises following step:
The user claims according to the English storehouse table name of operation system 3, corresponding service Chinese library table is set or the account table name claims, and corresponding supplementary, as the database (when using a plurality of database) at table place, storehouse, the classification of storehouse table etc.By the storehouse table is set, the user just can claim to get final product with the storehouse table name of direct selection businessization on the foreground, and need not to remember its English name, and certainly, above-mentioned business Chinese library table name claims also can select suitable language according to user's speech habits.
The user claims according to the English storehouse table name of operation system 3, table corresponding criteria field information in this storehouse is set, is mainly the English name in field Chinese, the corresponding operation system, corresponding storehouse table name claims and the data type of this field, maximum length, precision etc.After a certain Chinese library table name of user's selection claims, can directly obtain the corresponding field information of this table by shortcut, make things convenient for business personnel's operation.
LL (K) grammar definition
First L represents to scan from left to right input string, and second L represents to use leftmost derivation (leftmost nonterminal symbol is used production derives at every turn), and k represents to scan k symbol to the right just can determine to use for which production.
The morphology definition
Morphology is the set of all inputs that can accept of a query statement 4, during the text of scanning input, judges whether acceptable character of current character, such as us legal identifier has been descended such definition:
IDENTIFIER?options{testLiterals＝true；}
：’a’..’z’(’a’..’z’’0’..’9’’_’|’$’|’#’)*；
That is to say that an identifier is by beginning of letter, letter, numeral, underscore, " $ " symbol are formed with " # ".Abc and a01, a_01 etc. are exactly legal identifier so, and a (01) is not a legal identifier just.If certain position of definition needs an identifier in the syntax, and the character string that scans is the such text of a (01), this is not an identifier just so, can produce the information that grammer is unusual.
Syntactic definition
The syntactic definition G=of a statement (Vt, Vn, S, P).
Vt is a terminal symbol, comprises previously defined morphology (key word, identifier, punctuation mark etc. are exactly that all can be by the direct assemble of symbol of input of user), specifically have EOF, inquiry, from, COMMA, identifier, WS}, wherein EOF is an EOF; " inquiry ", " from " be character string constant, COMMA is a punctuation mark ", "; identifier is an identifier, WS is a separator.
Vn is a nonterminal symbol, and { start_rule, select_expression, select_list, table_reference_list, displayed_column, selected_table} are here arranged
S is a begin symbol, the inlet of grammer checking, here S=start_rule
P is production (also claiming rule), and is as follows:
start_rule＝(select_expression)
*EOF
Select_expression=" inquiry " select_list " from " table_reference_list
select_list＝displayed_column(COMMA?displayed_column)
*
table_reference_list＝selected_table(COMMA?selected_table)
*
displayed_column＝identifier
selected_table＝identifier
Statement derivation (grammatical analysis)
Can the derivation to the query sentence of database of user input be exactly the process of carrying out grammatical analysis, be applied to defined syntax rule according to statement and judge whether statement is correct.Be example with " question blank 1. fields 1, table 1. field 2 is from table 1 " below:
1, user input database query statement " question blank 1. fields 1, table 1. field 2 is from table 1 ";
2, at first to receive first speech of query statement be that " inquiry " just brings into use defined syntax rule to derive to compiler;
3, begin symbol is start_rule, and it has produced (select_expression)
*The production of EOF;
4, use the production of select_expression again, be " inquiry " select_list " from " table_reference_list, the key word of input this moment " inquiry " and production " inquiry " the match is successful.If at this time query statement finishes, then parse error will appear, and former because the inquiry back has lacked field;
5, continuing to obtain next speech is: " table 1. field 1 ", and its applied production is: select_list;
That 6, select_list produces is displayed_column (COMMAdisplayed_column)
*Rule, what displayed_column produced is the identifier of identifier, at this moment " table 1. field 1 " is defined identifier, then is proved to be successful;
7, continuing to obtain next speech is: ", ", its applied rule is COMMA, the match is successful;
8, continuing to obtain next speech is: " table 1. field 2 ", its applied rule is displayed_column, what displayed_column produced is the identifier of identifier, and at this moment " table 1. field 2 " is defined identifier, then is proved to be successful;
9, continuing to obtain next speech is: " from ", with the production of select_expression " from " consistent, the match is successful;
10, continuing to obtain next speech is: " table 1 ", and its applied rule is table_reference_list;
That 11, table_reference_list produces is selected_table (COMMAselected_table)
*Expression formula, what selected_table produced is the identifier of identifier, at this moment " table 1 " is defined identifier, then is proved to be successful.
12, be EOF at last, show that the statement checking finishes, the query statement of being imported 4 all can meet defined expression formula, resolves correctly, at this moment will generate an abstract syntax tree, as shown in Figure 2.
As shown in Figure 1, the user selects required database table title, the field of this database table on the foreground, import self-defining query sentence of database 4 according to service needed, compiler 2 is after receiving query sentence of database 4, at first query sentence of database 4 is scanned, be reading inquiry statement 4 (representing with byte stream usually), scanning sequence is carried out the process of lexical analysis (Lexer Analysis) exactly, and the byte stream sequence is changed into compiler 2 discernible mark streams (TOKEN).Described syntactic analyser obtains the streamed source code of mark from scanning sequence, according to the rule in the syntactic definition query sentence of database 4 is carried out grammatical analysis (Parser Analysis).
Described grammer checking has comprised key word (as: inquiry SELECT, from FROM, condition WHERE), punctuation mark, sign of operation (as: adds, subtract, take advantage of, remove), (as: aggregate function is averaged AVG, maximizing MAX), (as: mathematical function takes absolute value ABS, ask cosine value COS), the date function of time (as: getting current date time SYSDATE), character string function (as: is asked string length LENGTH, character string intercepting SUBSTR), the checking of data type conversion function (as: transferring date TO_DATE to) etc.
After query sentence of database 4 is carried out morphology and grammatical analysis, if find this statement mistake, then send grammer authentication error information, and miscue comparatively accurately is provided; If checking is correct, the grammer of then representing this query sentence of database 4 is correct, then an abstract syntax tree (AST) that meets this statement will be constructed and be traveled through to compiler 2, and extract relevant node (root node, leaf node) information as required, formed compiler model object (QueryModel), transmission is proved to be successful information, and the grammer checking finishes.
Step 3, translation database query statement and obtain business datum
As shown in Figure 3, receive the information of being proved to be successful after, this compiler model object is responsible for receiving the business datum that translater 1 is passed back, as information such as table name, field name, table alias, field another names, and carries out translating operation.Described translater 1 provides the various interactive actions with the operation system query sentence of database, this translater 1 is responsible for receiving the processing of information such as the table name, field name of operation system and related service data content, compiler 2 required data are passed to the compiler model object, and the result is returned to operation system 3, extract use for operation system 3, finish transfer control and processing business datum.
After the user carries out being provided with of Ku Biao and field, select required database table title, the field of this database table on the foreground, import self-defining query statement according to service needed, the present invention can carry out the statement of user's input the syntax parsing checking, and the single pass query statement can be finished parsing.
The present invention is the Chinese Query statement of businessization to be changed into the English SQL query statement of the needed standard of operation system to the final purpose of data library inquiry statement syntax checking, the invention provides the function that the business query sentence of database is changed into the SQL statement carried out of standard, operation system can be obtained this statement and directly use in system.Except operation system 3 can be to the obtaining of the English SQL query statement of standard, the present invention also can accurately discern and obtain the content item under the different clauses, comprises SELECT clause's query contents, FROM clause's table information, the conditional information of WHERE clause, GROUP BY clause's packet content, ORDER BY clause's ordering content, the table information that table merges, the variable parameter of loop statement etc.
During concrete enforcement, the operating process of user inquiring is:
1, use shortcut to select key word commonly used:
Shortcuts such as CTRL+1, CTRL+2 be can use, key word commonly used, function etc. selected fast.
Perhaps, select required account table, field, quick speech in the input frame optional position:
Can select the account table name to claim, select account literary name section, quick speech (key word commonly used, function, operational symbol etc.) in the optional position of Chinese Query statement input frame.
2, mate corresponding Chinese Fields automatically according to selected account table:
After having selected the account table name to claim, input ". " time, can claim to search automatically its corresponding Chinese Fields according to the account table name of current input.
3, read statement is carried out the grammer checking:
Syntax check is correct, is proved to be successful, and the self-defined Chinese Query statement of input can be translated into the English query statement of standard;
The syntax check mistake, authentication failed can comparatively prepare to point out error message, makes things convenient for user of service's error correction.
Claims (5)
1. the conversion method of a query sentence of database is characterized in that comprising following step:
Step 1, claim to be provided with corresponding service Chinese library table name according to the English storehouse table name of operation system and claim to claim and corresponding supplementary and criteria field information with standard word segment table, businessization Chinese library table or account table name;
Step 2, compiler are done morphology and the laggard lang method checking of grammatical analysis to query sentence of database
The user selects the required database table title and the field of this database table on the foreground, import self-defining query sentence of database according to service needed, compiler is after receiving query sentence of database, at first query sentence of database is scanned, the process of lexical analysis carried out in the reading inquiry statement, and the byte stream sequence is changed into the discernible mark stream of compiler; Described syntactic analyser obtains the streamed source code of mark from scanning sequence, according to the rule in the syntactic definition query sentence of database is carried out grammatical analysis;
After query sentence of database is carried out morphology and grammatical analysis, if find this statement mistake, then send grammer authentication error information, and miscue comparatively accurately is provided; If checking is correct, the grammer of representing this query sentence of database is correct, and then an abstract syntax tree that meets this statement will be constructed and be traveled through to compiler, and extract relevant nodal information as required, formed the compiler model object, sent the information that is proved to be successful, the grammer checking finishes;
Step 3, translation database query statement and obtain business datum
Receive after grammer is proved to be successful information, this compiler model object is responsible for receiving the business datum that translater is passed back, and carries out translating operation; Described translater provides the various interactive actions with the operation system query sentence of database, this translater is responsible for receiving the processing of information such as the table name, field name of operation system and related service data content, the data that compiler is required are passed to the compiler model object, and the result is returned to operation system, extract use for operation system, finish transfer control and processing business datum.
2. based on the converting system of the conversion method of the described a kind of query sentence of database of claim 1, it is characterized in that: mainly comprise translater and compiler two large divisions, described translater provide with the various interactive actions of operation system query statement and with the data processing function of compiler, translater is responsible for receiving the table name of operation system, the processing of information such as field name and related service data content, the data that compiler is required are passed to the compiler model object, and the result is returned to business is 3, extract use for operation system, finish transfer control and processing business datum; This compiler is responsible for the core work of grammer checking and data processing etc.; The model object of described compiler is used for constructing compiler model object base class, nodal information content when being used to carry out traversal syntax tree behind the common process of query sentence of database and the memory compiler syntax parsing, by this model object content is passed to translater, be responsible for carrying out alternately with operation system by translater.
3. the converting system of a kind of query sentence of database according to claim 2: it is characterized in that: described query statement comprises conventional statement, appends statement, comparison statement, loop statement and self-defined inquiry statement.
4. the converting system of a kind of query sentence of database according to claim 2: it is characterized in that: described translater mainly comprises:
Query statement receiver module: be used to receive the query sentence of database that operation system is imported into, and pass to compiler and resolve checking;
Storehouse table information setting module and field information are provided with module: Chinese is shown in the storehouse that is used for obtaining according to compiler, receive storehouse table English name, the field Chinese and English title of operation system and be used for the supplementary of interim storage service related data, and pass these contents back compiler and handle;
Each calls the information setting module: be used for the another name information obtained according to compiler, receive corresponding English another name and also pass compiler back;
Loop variant values is provided with module: be used for the loop variable obtained according to compiler, the value that receives the loop variable of operation system is also passed compiler back and is handled;
The query statement translation module: be used for giving compiler processes with business Chinese database query statement, the English query statement of the standard of translating into, and will comprise that the various results of sky query statement, empty perform statement, complete perform statement send to operation system;
Query statement changes the XML format module: be used to the system data of managing business, and query sentence of database is changed into the XML form, content is dumped to the operation system database, make things convenient for the operation of operation system;
The XML form changes the query statement module: be used for the content of the existing XML form of operation system database is changed into the discernible query sentence of database of converting system and other data, reach the positioning function of business processing;
Compiler model object acquisition module: be used to realize and the obtaining of each model object of compiler, and carry out interactive operation;
Authentication error information acquisition module: be used to obtain compiler grammer authentication error information, and this error message is sent to operation system;
Query statement format processing module: be used for being undertaken the format processing of query sentence of database by compiler;
Each clause's content acquisition module: be used for obtaining each clause's content, make things convenient for operation system to extract by each model object of compiler is handled;
Loop variable acquisition module and each another name information acquisition module: the information such as loop variable, table alias, field another name that are used to obtain compiler.
5. the converting system of a kind of query sentence of database according to claim 2: it is characterized in that: described compiler mainly comprises:
Morphology, grammer and syntax tree analysis module: be used for the query statement that translater is passed back is verified parsing work, receive the query statement of businessization, carry out the analysis of lexical analysis, grammatical analysis, syntax tree;
Statement model construction module: be used for type, construct corresponding model object in three types of conventional model object, table pooled model object, the table comparison model objects according to the query statement of operation system;
Statement spider module: be used to construct compiler model object base class, carry out the common process of query statement and the nodal information that storage travels through the dependent parser tree that is obtained in the syntax tree process;
Clause's constructing module: be used to design each generic clause model object, obtain the content item under each clause;
Clause's table, field contents module: be used for designing form model object, field model object, but the Chinese and English information of the Chinese and English information of stored data base table, field makes things convenient for the table of compiler, the Chinese and English translation and the format manipulation of field; Structure table alias, field another name, ordering alias object are realized obtaining of various another name information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200910111755A CN101788992A (en) | 2009-05-06 | 2009-05-06 | Method and system for converting query sentence of database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200910111755A CN101788992A (en) | 2009-05-06 | 2009-05-06 | Method and system for converting query sentence of database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101788992A true CN101788992A (en) | 2010-07-28 |
Family
ID=42532208
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN200910111755A Pending CN101788992A (en) | 2009-05-06 | 2009-05-06 | Method and system for converting query sentence of database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101788992A (en) |
Cited By (60)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102004766A (en) * | 2010-11-09 | 2011-04-06 | 北京神州泰岳软件股份有限公司 | Query method and system for configurable information based on information system |
| CN102184371A (en) * | 2011-04-15 | 2011-09-14 | 国都兴业信息审计系统技术（北京）有限公司 | Detecting method and system for database operation authority of SQL (Structured Query Language) |
| CN102541521A (en) * | 2010-12-17 | 2012-07-04 | 中国银联股份有限公司 | Automatic operating instruction generating device based on structured query language and method |
| CN102609541A (en) * | 2012-02-21 | 2012-07-25 | 德讯科技股份有限公司 | SQL information acquisition auditing system based on MSSQL database |
| CN103488797A (en) * | 2013-10-14 | 2014-01-01 | 德讯科技股份有限公司 | MYSQL database-based SQL information acquisition and audit system |
| CN103677952A (en) * | 2013-12-18 | 2014-03-26 | 华为技术有限公司 | Coder decoder generating device and method |
| CN103886021A (en) * | 2014-02-24 | 2014-06-25 | 上海上讯信息技术股份有限公司 | Database audit result translation method and system based on natural language |
| CN104063232A (en) * | 2014-07-21 | 2014-09-24 | 佛山市恒南微科技有限公司 | Rapid system development method based on utilization of database parameters |
| CN104216992A (en) * | 2014-09-09 | 2014-12-17 | 百度在线网络技术（北京）有限公司 | Information processing method and device |
| CN104252510A (en) * | 2013-11-05 | 2014-12-31 | 深圳市华傲数据技术有限公司 | SQL (Structural Query Language) language translation method and SQL language translation device |
| WO2015003452A1 (en) * | 2013-07-10 | 2015-01-15 | Tencent Technology (Shenzhen) Company Limited | Methods and systems for file processing |
| CN104714974A (en) * | 2013-12-17 | 2015-06-17 | 航天信息股份有限公司 | Method and device for parsing and reprocessing query statement |
| US9116714B2 (en) | 2013-07-10 | 2015-08-25 | Tencent Technology (Shenzhen) Company Limited | Methods and systems for file processing |
| CN105630475A (en) * | 2014-11-06 | 2016-06-01 | 阿里巴巴集团控股有限公司 | Data label organization system and organization method |
| CN103631778B (en) * | 2012-08-21 | 2016-12-21 | 南京大学 | Map based on data and the visual satellite rail position management method of B/S framework |
| CN106294468A (en) * | 2015-06-02 | 2017-01-04 | 阿里巴巴集团控股有限公司 | The method and apparatus processing business datum |
| CN106506661A (en) * | 2016-11-18 | 2017-03-15 | 浪潮软件集团有限公司 | A method, server and system for dynamically returning data |
| CN106528885A (en) * | 2016-12-16 | 2017-03-22 | 苏州市环亚数据技术有限公司 | Processing method and device of medical business data |
| CN106844380A (en) * | 2015-12-04 | 2017-06-13 | 阿里巴巴集团控股有限公司 | A kind of database operation method, information processing method and related device |
| CN107943995A (en) * | 2017-09-22 | 2018-04-20 | 国网重庆市电力公司电力科学研究院 | A kind of SQL query result row name and coding automatic switching method |
| CN108121701A (en) * | 2017-12-26 | 2018-06-05 | 深圳市海派通讯科技有限公司 | A kind of anti-harassment automatic identifying method and its intelligent terminal |
| CN108388606A (en) * | 2018-02-06 | 2018-08-10 | 福建星瑞格软件有限公司 | A kind of method and computer equipment verifying library literary name section name in Sql sentences |
| CN108710662A (en) * | 2018-05-14 | 2018-10-26 | 上海跬智信息技术有限公司 | Language transfer method and device, storage medium, data query system and method |
| CN109101516A (en) * | 2017-11-30 | 2018-12-28 | 新华三大数据技术有限公司 | A kind of data query method and server |
| CN109241076A (en) * | 2018-08-01 | 2019-01-18 | 上海依图网络科技有限公司 | A kind of data query method and device |
| CN109346108A (en) * | 2018-11-28 | 2019-02-15 | 广东小天才科技有限公司 | Operation checking method and system |
| CN109376220A (en) * | 2018-12-12 | 2019-02-22 | 北京字节跳动网络技术有限公司 | Method and apparatus for obtaining information |
| CN109408573A (en) * | 2018-10-11 | 2019-03-01 | 上海瀚银信息技术有限公司 | A kind of data collection system and collecting method of database |
| CN109656943A (en) * | 2018-12-12 | 2019-04-19 | 国网辽宁省电力有限公司信息通信分公司 | A data service method that shields the query complexity of heterogeneous databases |
| CN109919691A (en) * | 2019-02-27 | 2019-06-21 | 腾讯科技（深圳）有限公司 | A kind of system of data processing, method and device |
| CN110019335A (en) * | 2017-10-17 | 2019-07-16 | 航天信息股份有限公司 | A kind of method and system carrying out dynamic expansion to SQL query statement based on note |
| CN110020006A (en) * | 2017-07-27 | 2019-07-16 | 北京国双科技有限公司 | The generation method and relevant device of query statement |
| CN110188089A (en) * | 2019-05-31 | 2019-08-30 | 杭州安恒信息技术股份有限公司 | Method and device for database operation and maintenance management and control |
| CN110263055A (en) * | 2019-06-18 | 2019-09-20 | 上海达梦数据库有限公司 | A kind of parameter prompts method, apparatus, equipment and storage medium |
| CN110309171A (en) * | 2018-02-26 | 2019-10-08 | 华为技术有限公司 | Data base query method, server and system |
| CN110555030A (en) * | 2018-03-28 | 2019-12-10 | 北京京东尚科信息技术有限公司 | Method and device for processing SQL statements |
| CN110674162A (en) * | 2019-09-23 | 2020-01-10 | 税友软件集团股份有限公司 | Database statement execution method and related device |
| CN110909128A (en) * | 2019-11-08 | 2020-03-24 | 深圳市彬讯科技有限公司 | Method, equipment and storage medium for data query by using root table |
| CN107451153B (en) * | 2016-05-31 | 2020-03-31 | 北京京东尚科信息技术有限公司 | Method and device for outputting structured query statement |
| CN111563142A (en) * | 2020-07-14 | 2020-08-21 | 成都四方伟业软件股份有限公司 | SQL automatic benchmarking matching method and device |
| CN111967247A (en) * | 2020-10-23 | 2020-11-20 | 北京智源人工智能研究院 | Natural language semantic representation method and device based on function declaration and electronic equipment |
| CN106777278B (en) * | 2016-12-29 | 2021-02-23 | 海尔优家智能科技（北京）有限公司 | Spark-based data processing method and device |
| CN112463819A (en) * | 2020-11-26 | 2021-03-09 | 北京宏景世纪软件股份有限公司 | Computing method, device and equipment based on Chinese expression and storage medium |
| CN112541002A (en) * | 2020-12-09 | 2021-03-23 | 北京奇艺世纪科技有限公司 | Program language conversion method, device, electronic equipment and storage medium |
| CN113326282A (en) * | 2021-06-17 | 2021-08-31 | 中国农业银行股份有限公司 | SQL statement generation method and device, electronic equipment and storage medium |
| CN113434625A (en) * | 2021-08-27 | 2021-09-24 | 中汽研(天津)汽车信息咨询有限公司 | Patent retrieval type coding method, device and storage medium |
| CN113553411A (en) * | 2021-06-30 | 2021-10-26 | 北京百度网讯科技有限公司 | Query statement generation method and device, electronic equipment and storage medium |
| CN113760734A (en) * | 2021-02-02 | 2021-12-07 | 北京沃东天骏信息技术有限公司 | A data preparation method and device, device, and storage medium |
| CN113792027A (en) * | 2021-08-23 | 2021-12-14 | 浙江金惠科技有限公司 | Universal database conversion device |
| CN114116764A (en) * | 2021-11-25 | 2022-03-01 | 建信金融科技有限责任公司 | A method, device, medium and electronic device for index query based on syntax tree |
| CN114168720A (en) * | 2021-10-22 | 2022-03-11 | 福建亿榕信息技术有限公司 | Natural language data query method and storage device based on deep learning |
| CN114168622A (en) * | 2020-09-10 | 2022-03-11 | 北京达佳互联信息技术有限公司 | Data query method and device based on domain specific language |
| CN114661714A (en) * | 2022-03-15 | 2022-06-24 | 神策网络科技（北京）有限公司 | Data query method, device and electronic device |
| CN114896058A (en) * | 2022-04-27 | 2022-08-12 | 南京鼎华智能系统有限公司 | Dispatching system and dispatching method based on memory operation |
| CN115269627A (en) * | 2022-05-27 | 2022-11-01 | 上海迈伺通健康科技有限公司 | Method, system, apparatus and storage medium for operating database using Chinese instruction |
| CN115757462A (en) * | 2022-11-15 | 2023-03-07 | 中国科学院软件研究所 | Object-oriented database dynamic interface generation method and operation method |
| CN115964386A (en) * | 2021-10-13 | 2023-04-14 | 远光软件股份有限公司 | Database-based data access system |
| CN116010439A (en) * | 2022-12-23 | 2023-04-25 | 南京中孚信息技术有限公司 | Visual Chinese SQL system and query construction method |
| CN117171189A (en) * | 2023-07-12 | 2023-12-05 | 上海观安信息技术股份有限公司 | Data processing methods, devices and equipment |
| CN117667978A (en) * | 2023-12-07 | 2024-03-08 | 上海迈伺通健康科技有限公司 | Computer system for operating database by Chinese instruction |
-
2009
- 2009-05-06 CN CN200910111755A patent/CN101788992A/en active Pending
Cited By (88)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102004766A (en) * | 2010-11-09 | 2011-04-06 | 北京神州泰岳软件股份有限公司 | Query method and system for configurable information based on information system |
| CN102541521A (en) * | 2010-12-17 | 2012-07-04 | 中国银联股份有限公司 | Automatic operating instruction generating device based on structured query language and method |
| CN102541521B (en) * | 2010-12-17 | 2015-03-25 | 中国银联股份有限公司 | Automatic operating instruction generating device based on structured query language and method |
| CN102184371A (en) * | 2011-04-15 | 2011-09-14 | 国都兴业信息审计系统技术（北京）有限公司 | Detecting method and system for database operation authority of SQL (Structured Query Language) |
| CN102184371B (en) * | 2011-04-15 | 2013-03-20 | 国都兴业信息审计系统技术（北京）有限公司 | Detecting method and system for database operation authority of SQL (Structured Query Language) |
| CN102609541A (en) * | 2012-02-21 | 2012-07-25 | 德讯科技股份有限公司 | SQL information acquisition auditing system based on MSSQL database |
| CN103631778B (en) * | 2012-08-21 | 2016-12-21 | 南京大学 | Map based on data and the visual satellite rail position management method of B/S framework |
| WO2015003452A1 (en) * | 2013-07-10 | 2015-01-15 | Tencent Technology (Shenzhen) Company Limited | Methods and systems for file processing |
| US9116714B2 (en) | 2013-07-10 | 2015-08-25 | Tencent Technology (Shenzhen) Company Limited | Methods and systems for file processing |
| CN103488797A (en) * | 2013-10-14 | 2014-01-01 | 德讯科技股份有限公司 | MYSQL database-based SQL information acquisition and audit system |
| CN104252510A (en) * | 2013-11-05 | 2014-12-31 | 深圳市华傲数据技术有限公司 | SQL (Structural Query Language) language translation method and SQL language translation device |
| CN104714974A (en) * | 2013-12-17 | 2015-06-17 | 航天信息股份有限公司 | Method and device for parsing and reprocessing query statement |
| CN103677952A (en) * | 2013-12-18 | 2014-03-26 | 华为技术有限公司 | Coder decoder generating device and method |
| CN103677952B (en) * | 2013-12-18 | 2018-05-11 | 华为技术有限公司 | Codec generating means and method |
| CN103886021B (en) * | 2014-02-24 | 2018-10-02 | 上海上讯信息技术股份有限公司 | A kind of database audit result interpretation method and system based on natural language |
| CN103886021A (en) * | 2014-02-24 | 2014-06-25 | 上海上讯信息技术股份有限公司 | Database audit result translation method and system based on natural language |
| CN104063232A (en) * | 2014-07-21 | 2014-09-24 | 佛山市恒南微科技有限公司 | Rapid system development method based on utilization of database parameters |
| CN104063232B (en) * | 2014-07-21 | 2016-05-25 | 佛山市恒南微科技有限公司 | A kind of method of the system development utilizing based on database parameter |
| CN104216992B (en) * | 2014-09-09 | 2017-12-15 | 百度在线网络技术（北京）有限公司 | A kind of information processing method and device |
| CN104216992A (en) * | 2014-09-09 | 2014-12-17 | 百度在线网络技术（北京）有限公司 | Information processing method and device |
| US9898508B2 (en) | 2014-09-09 | 2018-02-20 | Baidu Online Network Technology (Beijing) Co., Ltd. | Method and device for processing information |
| CN105630475A (en) * | 2014-11-06 | 2016-06-01 | 阿里巴巴集团控股有限公司 | Data label organization system and organization method |
| CN105630475B (en) * | 2014-11-06 | 2018-12-21 | 阿里巴巴集团控股有限公司 | A kind of data label organization system and method for organizing |
| CN106294468B (en) * | 2015-06-02 | 2020-01-14 | 阿里巴巴集团控股有限公司 | Method and device for processing service data |
| CN106294468A (en) * | 2015-06-02 | 2017-01-04 | 阿里巴巴集团控股有限公司 | The method and apparatus processing business datum |
| CN106844380A (en) * | 2015-12-04 | 2017-06-13 | 阿里巴巴集团控股有限公司 | A kind of database operation method, information processing method and related device |
| CN107451153B (en) * | 2016-05-31 | 2020-03-31 | 北京京东尚科信息技术有限公司 | Method and device for outputting structured query statement |
| CN106506661A (en) * | 2016-11-18 | 2017-03-15 | 浪潮软件集团有限公司 | A method, server and system for dynamically returning data |
| CN106528885A (en) * | 2016-12-16 | 2017-03-22 | 苏州市环亚数据技术有限公司 | Processing method and device of medical business data |
| CN106777278B (en) * | 2016-12-29 | 2021-02-23 | 海尔优家智能科技（北京）有限公司 | Spark-based data processing method and device |
| CN110020006B (en) * | 2017-07-27 | 2021-04-27 | 北京国双科技有限公司 | Query statement generation method and related equipment |
| CN110020006A (en) * | 2017-07-27 | 2019-07-16 | 北京国双科技有限公司 | The generation method and relevant device of query statement |
| CN107943995B (en) * | 2017-09-22 | 2022-03-08 | 国网重庆市电力公司电力科学研究院 | A method for automatic conversion of column names and codes of SQL query results |
| CN107943995A (en) * | 2017-09-22 | 2018-04-20 | 国网重庆市电力公司电力科学研究院 | A kind of SQL query result row name and coding automatic switching method |
| CN110019335A (en) * | 2017-10-17 | 2019-07-16 | 航天信息股份有限公司 | A kind of method and system carrying out dynamic expansion to SQL query statement based on note |
| US11269881B2 (en) | 2017-11-30 | 2022-03-08 | New H3C Big Data Technologies Co., Ltd. | Data query |
| CN109101516B (en) * | 2017-11-30 | 2019-09-17 | 新华三大数据技术有限公司 | A kind of data query method and server |
| CN109101516A (en) * | 2017-11-30 | 2018-12-28 | 新华三大数据技术有限公司 | A kind of data query method and server |
| CN108121701A (en) * | 2017-12-26 | 2018-06-05 | 深圳市海派通讯科技有限公司 | A kind of anti-harassment automatic identifying method and its intelligent terminal |
| CN108388606B (en) * | 2018-02-06 | 2022-01-25 | 福建星瑞格软件有限公司 | Method for checking base table field names in Sql sentences and computer equipment |
| CN108388606A (en) * | 2018-02-06 | 2018-08-10 | 福建星瑞格软件有限公司 | A kind of method and computer equipment verifying library literary name section name in Sql sentences |
| CN110309171A (en) * | 2018-02-26 | 2019-10-08 | 华为技术有限公司 | Data base query method, server and system |
| CN110309171B (en) * | 2018-02-26 | 2021-08-20 | 华为技术有限公司 | Database query method, server and system |
| CN110555030A (en) * | 2018-03-28 | 2019-12-10 | 北京京东尚科信息技术有限公司 | Method and device for processing SQL statements |
| CN108710662B (en) * | 2018-05-14 | 2019-12-27 | 上海跬智信息技术有限公司 | Language conversion method and device, storage medium, data query system and method |
| CN108710662A (en) * | 2018-05-14 | 2018-10-26 | 上海跬智信息技术有限公司 | Language transfer method and device, storage medium, data query system and method |
| CN109241076A (en) * | 2018-08-01 | 2019-01-18 | 上海依图网络科技有限公司 | A kind of data query method and device |
| CN109408573A (en) * | 2018-10-11 | 2019-03-01 | 上海瀚银信息技术有限公司 | A kind of data collection system and collecting method of database |
| CN109346108A (en) * | 2018-11-28 | 2019-02-15 | 广东小天才科技有限公司 | Operation checking method and system |
| CN109376220B (en) * | 2018-12-12 | 2020-12-25 | 北京字节跳动网络技术有限公司 | Method and device for acquiring information |
| CN109376220A (en) * | 2018-12-12 | 2019-02-22 | 北京字节跳动网络技术有限公司 | Method and apparatus for obtaining information |
| CN109656943A (en) * | 2018-12-12 | 2019-04-19 | 国网辽宁省电力有限公司信息通信分公司 | A data service method that shields the query complexity of heterogeneous databases |
| CN109919691B (en) * | 2019-02-27 | 2021-06-08 | 腾讯科技（深圳）有限公司 | Data processing system, method and device |
| CN109919691A (en) * | 2019-02-27 | 2019-06-21 | 腾讯科技（深圳）有限公司 | A kind of system of data processing, method and device |
| CN110188089A (en) * | 2019-05-31 | 2019-08-30 | 杭州安恒信息技术股份有限公司 | Method and device for database operation and maintenance management and control |
| CN110263055A (en) * | 2019-06-18 | 2019-09-20 | 上海达梦数据库有限公司 | A kind of parameter prompts method, apparatus, equipment and storage medium |
| CN110674162A (en) * | 2019-09-23 | 2020-01-10 | 税友软件集团股份有限公司 | Database statement execution method and related device |
| CN110909128A (en) * | 2019-11-08 | 2020-03-24 | 深圳市彬讯科技有限公司 | Method, equipment and storage medium for data query by using root table |
| CN110909128B (en) * | 2019-11-08 | 2023-08-11 | 土巴兔集团股份有限公司 | Method, equipment and storage medium for carrying out data query by using root list |
| CN111563142A (en) * | 2020-07-14 | 2020-08-21 | 成都四方伟业软件股份有限公司 | SQL automatic benchmarking matching method and device |
| CN114168622A (en) * | 2020-09-10 | 2022-03-11 | 北京达佳互联信息技术有限公司 | Data query method and device based on domain specific language |
| CN111967247A (en) * | 2020-10-23 | 2020-11-20 | 北京智源人工智能研究院 | Natural language semantic representation method and device based on function declaration and electronic equipment |
| CN112463819A (en) * | 2020-11-26 | 2021-03-09 | 北京宏景世纪软件股份有限公司 | Computing method, device and equipment based on Chinese expression and storage medium |
| CN112463819B (en) * | 2020-11-26 | 2024-10-25 | 北京宏景世纪软件股份有限公司 | Calculation method, device, equipment and storage medium based on Chinese expression |
| CN112541002A (en) * | 2020-12-09 | 2021-03-23 | 北京奇艺世纪科技有限公司 | Program language conversion method, device, electronic equipment and storage medium |
| CN113760734A (en) * | 2021-02-02 | 2021-12-07 | 北京沃东天骏信息技术有限公司 | A data preparation method and device, device, and storage medium |
| CN113326282A (en) * | 2021-06-17 | 2021-08-31 | 中国农业银行股份有限公司 | SQL statement generation method and device, electronic equipment and storage medium |
| CN113553411A (en) * | 2021-06-30 | 2021-10-26 | 北京百度网讯科技有限公司 | Query statement generation method and device, electronic equipment and storage medium |
| CN113553411B (en) * | 2021-06-30 | 2023-08-29 | 北京百度网讯科技有限公司 | Query statement generation method and device, electronic equipment and storage medium |
| US12038955B2 (en) | 2021-06-30 | 2024-07-16 | Beijing Baidu Netcom Science Technology Co., Ltd. | Method for generating query statement, electronic device and storage medium |
| CN113792027A (en) * | 2021-08-23 | 2021-12-14 | 浙江金惠科技有限公司 | Universal database conversion device |
| CN113792027B (en) * | 2021-08-23 | 2023-06-16 | 浙江金惠科技有限公司 | General database conversion device |
| CN113434625A (en) * | 2021-08-27 | 2021-09-24 | 中汽研(天津)汽车信息咨询有限公司 | Patent retrieval type coding method, device and storage medium |
| CN115964386B (en) * | 2021-10-13 | 2025-09-12 | 远光软件股份有限公司 | Data access system based on database |
| CN115964386A (en) * | 2021-10-13 | 2023-04-14 | 远光软件股份有限公司 | Database-based data access system |
| CN114168720A (en) * | 2021-10-22 | 2022-03-11 | 福建亿榕信息技术有限公司 | Natural language data query method and storage device based on deep learning |
| CN114116764A (en) * | 2021-11-25 | 2022-03-01 | 建信金融科技有限责任公司 | A method, device, medium and electronic device for index query based on syntax tree |
| CN114661714A (en) * | 2022-03-15 | 2022-06-24 | 神策网络科技（北京）有限公司 | Data query method, device and electronic device |
| CN114661714B (en) * | 2022-03-15 | 2025-05-16 | 神策网络科技（北京）有限公司 | Data query method, device and electronic device |
| CN114896058A (en) * | 2022-04-27 | 2022-08-12 | 南京鼎华智能系统有限公司 | Dispatching system and dispatching method based on memory operation |
| CN114896058B (en) * | 2022-04-27 | 2023-09-22 | 南京鼎华智能系统有限公司 | Dispatching system and dispatching method based on memory operation |
| CN115269627A (en) * | 2022-05-27 | 2022-11-01 | 上海迈伺通健康科技有限公司 | Method, system, apparatus and storage medium for operating database using Chinese instruction |
| CN115757462B (en) * | 2022-11-15 | 2023-06-06 | 中国科学院软件研究所 | An Object-Oriented Database Dynamic Interface Generation Method and Operation Method |
| CN115757462A (en) * | 2022-11-15 | 2023-03-07 | 中国科学院软件研究所 | Object-oriented database dynamic interface generation method and operation method |
| CN116010439A (en) * | 2022-12-23 | 2023-04-25 | 南京中孚信息技术有限公司 | Visual Chinese SQL system and query construction method |
| CN116010439B (en) * | 2022-12-23 | 2025-07-18 | 南京中孚信息技术有限公司 | Visual Chinese SQL system and query construction method |
| CN117171189A (en) * | 2023-07-12 | 2023-12-05 | 上海观安信息技术股份有限公司 | Data processing methods, devices and equipment |
| CN117667978A (en) * | 2023-12-07 | 2024-03-08 | 上海迈伺通健康科技有限公司 | Computer system for operating database by Chinese instruction |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101788992A (en) | Method and system for converting query sentence of database | |
| US20230127193A1 (en) | System and Method for Recursive Transliteration of Machine Interpretable Languages | |
| CN107451153B (en) | Method and device for outputting structured query statement | |
| US7895611B2 (en) | Methods and apparatus for creation of parsing rules | |
| US6986104B2 (en) | Method and apparatus for normalizing and converting structured content | |
| US7707026B2 (en) | Multilingual translation memory, translation method, and translation program | |
| CN111177184A (en) | Natural language-based structured query language conversion method and related equipment | |
| CN100550020C (en) | A kind of method and apparatus that is used to solve the Chinese software issue of supporting multilanguage | |
| CN109241080B (en) | Construction and use method and system of FQL query language | |
| CN104657440A (en) | Structured query statement generating system and method | |
| CN111176650B (en) | Parser generation method, search method, server, and storage medium | |
| CN103020044A (en) | Machine-aided webpage translation method and system thereof | |
| CN112632185A (en) | Multi-type database synchronization method, device and equipment based on CPU environment | |
| CN113297251A (en) | Multi-source data retrieval method, device, equipment and storage medium | |
| CN116561172A (en) | DDL statement conversion method in incremental data migration and related equipment | |
| CN101859295A (en) | Simplified-Traditional Word Conversion System and Method with Marking Prompt | |
| CN101782910B (en) | SQLite visual management method | |
| CN101499015A (en) | Method and converter for converting high level language to other high level languages | |
| CN117453720A (en) | Structured query statement analysis method, device, equipment and storage medium | |
| CN112506488A (en) | Method for generating programming language class based on sql creating statement | |
| CN111241130A (en) | SQL language-based grammar statement extension method and system | |
| CN101013430A (en) | Searching method and apparatus | |
| CN103064885A (en) | System and method for achieving synchronous inputting of key words | |
| KR101282419B1 (en) | on line multi lingual searching method using by ortho-phonetic grapheme as middle language, and intermediate interchanging code | |
| CN117707548A (en) | Method and device for converting grammar of database script based on lexical 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 | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Open date: 20100728 |