CN117667978A - Computer system for operating database by Chinese instruction - Google Patents
Computer system for operating database by Chinese instruction Download PDFInfo
- Publication number
- CN117667978A CN117667978A CN202311678912.XA CN202311678912A CN117667978A CN 117667978 A CN117667978 A CN 117667978A CN 202311678912 A CN202311678912 A CN 202311678912A CN 117667978 A CN117667978 A CN 117667978A
- Authority
- CN
- China
- Prior art keywords
- chinese
- database
- module
- instructions
- user
- 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
- 238000006243 chemical reaction Methods 0.000 claims abstract description 22
- 238000013507 mapping Methods 0.000 claims abstract description 6
- 238000013461 design Methods 0.000 claims abstract description 5
- 238000012545 processing Methods 0.000 claims description 32
- 230000006870 function Effects 0.000 claims description 18
- 238000000034 method Methods 0.000 claims description 17
- 230000004044 response Effects 0.000 claims description 17
- 238000012800 visualization Methods 0.000 claims description 17
- 239000008186 active pharmaceutical agent Substances 0.000 claims description 13
- 238000003032 molecular docking Methods 0.000 claims description 11
- 238000005457 optimization Methods 0.000 claims description 7
- 230000000007 visual effect Effects 0.000 claims description 7
- 230000000295 complement effect Effects 0.000 claims description 5
- 238000002347 injection Methods 0.000 claims description 4
- 239000007924 injection Substances 0.000 claims description 4
- 206010000117 Abnormal behaviour Diseases 0.000 claims description 3
- 238000012550 audit Methods 0.000 claims description 3
- 238000012360 testing method Methods 0.000 description 10
- 238000002372 labelling Methods 0.000 description 8
- 230000008569 process Effects 0.000 description 7
- 239000012634 fragment Substances 0.000 description 6
- 239000011159 matrix material Substances 0.000 description 6
- 238000012549 training Methods 0.000 description 6
- 230000011218 segmentation Effects 0.000 description 5
- 238000011161 development Methods 0.000 description 3
- 230000018109 developmental process Effects 0.000 description 3
- 230000014509 gene expression Effects 0.000 description 3
- 210000001503 joint Anatomy 0.000 description 3
- 238000004140 cleaning Methods 0.000 description 2
- 230000007704 transition Effects 0.000 description 2
- 238000012795 verification Methods 0.000 description 2
- 230000007547 defect Effects 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000003780 insertion Methods 0.000 description 1
- 230000037431 insertion Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000003825 pressing Methods 0.000 description 1
- 238000005096 rolling process Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Abstract
The present invention relates to the field of database operations, and more particularly, to a computer system for operating a database using chinese instructions. In the field of internet, database operating systems are too many, english is mostly used as an operating language of data, but some database instructions are not easy to memorize, when the instructions are not used for a long time, the instructions are forgotten, a great deal of time is required to search data, and english is not friendly to a clerk with poor english as an operating language. The present invention aims at overcoming the disadvantages in the prior art and provides a computer system for operating a database by Chinese instructions. The invention uses modularized design to ensure the usability of the invention, and uses BiLSTM-CRF to perform Chinese instruction conversion and semantic mapping, thereby improving the understanding capability of the Chinese instruction operation database.
Description
Technical Field
The present invention relates to the field of database operations, and more particularly, to a computer system for operating a database using chinese instructions.
Background
The database is a warehouse for storing structured data, and the database management system is computer software designed for managing the database, so that in the development of back-end language, learning how to operate the database is an essential ring. However, in the prior art, database systems are too many in variety, basically each database system has own operation instructions and languages, and when developers use the database systems, the developers need to learn the operation languages from scratch, so that the investment cost is too high. Most of the database systems on the market use english or other languages as operation instructions, when people use english or other languages to operate the database, a certain operation instruction or grammar is forgotten for a long time, and the operation instruction or grammar needs to be searched on site, so that a great deal of time is wasted.
Therefore, there is a need to develop a computer system for operating a database with Chinese instructions to overcome the disadvantages of the prior art.
Disclosure of Invention
(1) Technical problem to be solved
The invention aims to overcome the defects that the database system in the prior art is too many in variety, the input of the operation language is too large, english or other languages are used as the operation instructions of the database system, and the method is not friendly to people in China.
(2) Technical proposal
In order to solve the above technical problems, the present invention provides a computer system for operating a database by using chinese instructions, which specifically includes the following modules:
the input module is responsible for inputting Chinese instructions of users; the Chinese processing module is used for analyzing Chinese instructions input by a user; the instruction conversion module is responsible for converting the information analyzed by the Chinese processing module into a query language which can be understood by the database; the database docking module is responsible for interacting with the database; the system optimization module is responsible for optimizing the performance of the system; the visualization module is in charge of carrying out visual display on data queried by a user; and the system safety protection module is responsible for user data and database safety in the system.
Further, in the input module, a user inputs a Chinese instruction through a Chinese input method in a command line input box, and the module supports processing characters generated by various Chinese input methods; meanwhile, when a user inputs a Chinese instruction, the system searches for providing automatic complement for the user instruction according to the typed Chinese instruction, and when the user needs, the user can press the enter key to realize automatic complement; or when the user inputs Chinese instructions, providing a user history record according to the typed Chinese instructions for the user to select.
Further, in the Chinese processing module, the input Chinese instructions are analyzed by using a BiLSTM-CRF model, and in the Chinese processing module, the input Chinese instructions are analyzed by using the BiLSTM-CRF model, so that the Chinese text is divided into separate words and the relationship between the entities is identified; the specific operation steps for establishing the BiLSTM-CRF model are as follows:
s1, collecting a large number of Chinese instructions for operating a database, establishing a training set and a testing set according to the Chinese instructions, cleaning the data set, removing irrelevant contents in the data set, performing word segmentation on the Chinese instructions in the data set, performing part-of-speech labeling on a word segmentation result, and labeling entities such as table names and field names and operations such as inquiry and update; word2Vec is then used to convert chinese instructions in the dataset into Word vector x= (X) 1 ,x 2 ,…x n ) Labeling each word to obtain Y= (Y) 1 ,y 2 ,…y n ) Wherein x is i And y is i One-to-one correspondence;
s2, inputting the converted word vector as an input characteristic into a BiLSTEM-CRF model, firstly converting the input word vector into a matrix W by a BiLSTM layer, wherein each row represents a characteristic vector of a time step t, then capturing forward and backward dependency relations in a sequence, and calculating a forward hiding state h f And a backward hidden state h b Then the forward and backward hidden states are connected to obtain the final hidden state h t ＝(h f ；h b ) The method comprises the steps of carrying out a first treatment on the surface of the Then the CRF layer receives the hidden state sequence h= (h) output by the BiLSTM layer 1 ,h 2 ,…h n ) Wherein h is 1 、h 2 …h n Representing the hidden state at the nth time, and then learning a transition matrix and a transmitting matrix to calculate the probability of the hidden state label sequence h, wherein the hidden state label has the highest probabilityThe signature sequence is the optimal signature sequence;
and S3, finally, testing and optimizing the BiLSTM-CRF model by using the test set data.
Further, the instruction conversion module is responsible for converting the information analyzed in the Chinese processing module into a query language which can be understood by the database, and the specific steps of the specific instruction conversion module are as follows:
s4.1, firstly, processing a Chinese instruction in a Chinese processing module, sending a prediction result to an instruction conversion module, after receiving the prediction result, carrying out deep semantic analysis on the prediction result, using information such as entity names, operations, labels and the like in the prediction result to construct an abstract syntax tree AST, creating AST nodes for each entity and each operation, creating edges in the abstract syntax tree AST according to the relation between the entity and the operation, and when a complex expression exists in the Chinese instruction, needing to create a subtree, and then merging the subtree into a main abstract syntax tree AST; labeling each node with the function of the node in the query and associating necessary attributes, checking grammar and semantic rules of the abstract syntax tree AST to ensure no ambiguity or error, optimizing the abstract syntax tree AST, and eliminating redundant nodes;
s4.2, after the abstract syntax tree AST is optimized, extracting necessary parameters such as column names, values and operators from the nodes for determining the type of each node of the abstract syntax tree AST, such as a selector, a function and conditions; then selecting SQL templates for each type of node, and then filling the templates with parameters extracted from the nodes;
s4.3, combining the SQL template fragments filled with parameters into a complete SQL clause, firstly determining the correct sequence of the SQL clause, AND connecting the SQL template fragments by using a logic connector AND OR OR after determining the sequence;
s4.4, if the user is performing multi-round inquiry, the instruction conversion module needs to consider the Chinese instructions in the context, and fuses the current abstract syntax tree AST with the abstract syntax tree AST in the context so as to construct complete inquiry;
s4.5, combining all SQL clauses formed by combining the SQL template fragments filled by the parameters into a final SQL query statement, executing the SQL query statement in a database to verify performance and correctness, continuously performing training test according to data of a training set and a testing set, and adjusting semantic mapping and generating processes until the function of the instruction conversion module reaches expectations.
Further, the database docking module is responsible for interacting with the database, firstly, the SQL query language converted by the instruction module is sent to the database, the database responds to the query of the database docking module, the query result is returned, and the data docking module processes the response result of the database; when the response result of the database is normal data, converting the data into a format readable by a user, and displaying the format to the user through a visualization module; when the response result is an error prompt or operation failure, any execution error is captured, the error prompt or failure result is converted into a Chinese description readable by a user, and the Chinese description is displayed through a visualization module.
Further, the system optimization module is responsible for optimizing the system, and a database which is in butt joint with a computer system of the Chinese instruction operation database adopts a distributed database, so that the whole crash of the computer system caused by the crash of the database is prevented; meanwhile, the computer system of the Chinese instruction operation database should ensure that the user's instructions can be responded quickly, some common Chinese instructions can be cached, after the Chinese instructions are input by the input module, whether the Chinese instructions are stored in the cache is checked, if the Chinese instructions exist in the cache, the SQL query statement mapped by the instructions in the cache is directly used, the processing and conversion of the Chinese processing module and the instruction conversion module are not needed, if the Chinese instructions do not exist in the cache, the Chinese instructions are processed and converted into the SQL query statement, and the Chinese instructions are stored in the cache for the next use.
Furthermore, the visualization module is responsible for carrying out visual display on the data queried by the database, displaying the execution result of the user input instruction in a form of a table or a chart, and supporting paging or scrolling viewing if the data volume is large; meanwhile, the user can customize the interface and the function according to personal preference and working habit, customize the color and layout of the computer system, or add functional plug-ins required when the computer system is used.
Further, the computer system of the Chinese instruction operation database provides an API interface for the Chinese instruction operation database to the outside, so that other systems or programs can obtain the function of the Chinese instruction operation database through the API interface, and have an API document for describing how to use the API, the request and the response format.
Furthermore, the computer system of the Chinese instruction operation database uses modularization to carry out system design, and when one module in the system has bug or interface structure outdated condition, a worker can independently update and replace one module; when new functions are required to be added to the system, interface connection between the system and each module is determined, and the new functions can be developed into a new module to be added into the computer system.
Further, the Chinese instruction operates a system security module of a computer system of the database, and user data and database security in the protection system are protected by adopting user identity verification and SQL injection; when the user inputs the Chinese instruction to operate the database, checking whether the user has authority to execute the operation in the Chinese instruction, executing the database data according to the Chinese instruction, and prompting the user without authority; when Chinese instructions input by a user are subjected to Chinese processing and semantic mapping, the Chinese instructions are verified to conform to an expected format, potential malicious structures are not contained, and security audit is regularly carried out on the computer to monitor abnormal behaviors.
(3) Advantageous effects
The computer system for operating the database by the Chinese instructions adopts a modularized design, when a certain module is in a problem, the module can be directly upgraded and maintained, the development efficiency is improved, the subsequent development and maintenance cost is reduced, and the database adopts a distributed database, so that the condition that the database is crashed due to the problem of a certain node is reduced.
The computer system of the Chinese instruction operation database uses the data to visualize, and the page can be set according to the user's needs, has reduced the study cost of the user, has optimized user's use experience, offer API interface for other systems or external use of the procedure at the same time, have raised the usability of this system.
The computer system of the Chinese instruction operation database uses the BiLSTM-CRF model to process Chinese instructions and further performs semantic analysis and instruction mapping on the processed Chinese instructions, so that the understanding capability of the system on the Chinese instructions is improved, the Chinese instructions input by a user are more accurately identified and understood by the system, and the accuracy of the system is improved.
Drawings
FIG. 1 is a schematic diagram of the modules of the present invention.
Fig. 2 is a flow chart of an instruction converting module according to the present invention.
Detailed Description
The invention is further described below with reference to the drawings and examples.
Example 1
The invention is further described below with reference to the drawings and examples.
After a user opens a computer system for operating a database by using Chinese instructions, inputting the Chinese instructions used when the database to be operated is input in an instruction input interface in the system, performing word segmentation, part-of-speech labeling, intention recognition and entity recognition on the Chinese instructions in an input box by a Chinese processing module of the computer system, then transmitting processed structured information to an instruction conversion module, converting the structured information output by the Chinese processing module into a query language which can be understood by the database by the instruction conversion module, then transmitting the query language to a database docking module, querying in the database after the query language is received, transmitting a response result of the database to a visualization module by the database docking module after the database query is completed, displaying the response result on a screen in a visual form such as a table, a chart and the like by the visualization module after the response result of the database is received, and scrolling or paging the visual display such as the table, the chart and the like can be checked when the data amount is too large. The only specific steps of the computer system where the user operates the database using chinese instructions are described. As described below, a specific implementation of the modules of the computer system for operating a database with Chinese instructions is provided.
The computer system of the Chinese instruction operation database adopts a modularized design mode, and when one module in the system has bug or interface structure outdated condition, a worker can independently update and replace one module. The specific module mainly comprises a Chinese processing module which is responsible for analyzing Chinese instructions input by a user; the instruction conversion module is responsible for converting the information analyzed by the Chinese processing module into a query language which can be understood by the database; the database docking module is responsible for interacting with the database; the system optimization module is responsible for optimizing the performance of the system; the visualization module is in charge of carrying out visual display on data queried by a user; and the system safety protection module is responsible for user data and database safety in the system.
The input module is responsible for inputting Chinese instructions in the command line input box by a user, when the user inputs the Chinese instructions in the command line input box through a Chinese input method, the input module searches the history according to the Chinese instructions input by the user and displays the commands which are most in line with the instructions input by the user, if the user needs to search the prompting information provided by the history by the input module, the user can quickly key the history into the command line input box by pressing an enter key, and Chinese instruction complement is automatically provided for the user; meanwhile, the input module also supports the processing of characters generated by inputting various Chinese input methods.
The Chinese processing module processes the Chinese instruction input by the user in the input module, identifies the relationship between the entities in the Chinese instruction, separates the Chinese instruction text into separate words and identifies the relationship between the entities by analyzing the input Chinese instruction using the BiLSTM-CRF model, and establishes the BiLSTM-CRF modelRelationship between them. The specific operation steps of establishing the BiLSTM-CRF model are that a large number of Chinese instructions for operating a database are collected, a training set and a testing set are established according to the Chinese instructions, data cleaning is carried out on the data set, irrelevant contents in the data set are removed, word segmentation processing is carried out on the Chinese instructions in the data set, part-of-speech labeling is carried out on the results after the word segmentation processing, and entities such as table names, field names and operations such as inquiry and update are marked; word2Vec is then used to convert chinese instructions in the dataset into Word vector x= (X) 1 ,x 2 ,…x n ) Labeling each word to obtain Y= (Y) 1 ,y 2 ,…y n ) Wherein x is i And y is i One-to-one correspondence. The converted word vector is input into a BiLSTEM-CRF model as input features, firstly, the BiLSTM layer converts the input word vector into a matrix W, wherein each row represents the feature vector of a time step t, then the forward and backward dependency relationship in the sequence is captured, and the forward hidden state h is calculated f And a backward hidden state h b Then the forward and backward hidden states are connected to obtain the final hidden state ht= (h) f ；h b ) The method comprises the steps of carrying out a first treatment on the surface of the Then the CRF layer receives the hidden state sequence h= (h) output by the BiLSTM layer 1 ,h 2 ,…h n ) Wherein h is 1 、h 2 …h n The hidden state at the nth time is represented, and then a transition matrix and a transmitting matrix are learned, so that the probability of a hidden state tag sequence h is calculated, and the hidden state tag sequence with the highest probability is the optimal tag sequence. And finally, testing and optimizing the BiLSTM-CRF model by using the test set data to ensure that the Chinese processing module reaches the operation expectation of the computer system of the Chinese instruction operation data.
The instruction conversion module is mainly responsible for converting information analyzed in the Chinese processing module into a structured query language which can be understood by a database, firstly, processing a Chinese instruction in the Chinese processing module, sending a prediction result to the instruction conversion module, after receiving the prediction result, carrying out deep semantic analysis on the prediction result, using information such as entity names, operations, labels and the like in the prediction result to construct an abstract syntax tree AST, creating AST nodes for each entity and each operation, wherein one table name can be a node, one comparison operation such as operations greater than or equal to one node and the like can also be a node, creating an edge in the abstract syntax tree AST according to the relation between the entity and the operation, and connecting one column name node with one comparison operation node through the edge to indicate that the column needs to meet a certain condition; when there is a complex expression in the Chinese instruction, one Chinese instruction containing a plurality of conditions may need to create a plurality of comparison nodes and logic operation nodes, and these nodes need to be built into subtrees, and then the subtrees are merged into the main abstract syntax tree AST; and then labeling each node with the function of the node in the query and associating necessary attributes, then checking grammar and semantic rules of the abstract syntax tree AST to ensure no ambiguity or error, and then optimizing the abstract syntax tree AST to eliminate redundant nodes, simplify expressions and the like, thereby improving the execution efficiency of SQL sentences. When the abstract syntax tree AST is optimized, extracting necessary parameters such as column names, values and operators from the nodes for determining the type, such as selector, function and condition, of each node of the abstract syntax tree AST; the SQL templates are then selected for each type of node according to the type of operation, e.g., query, insert, update, delete, and then populated with parameters extracted from the abstract syntax tree AST nodes. AND combining the SQL template fragments filled with the parameters into a complete SQL clause, firstly determining the correct sequence of the SQL clause, AND connecting the SQL template fragments by using a logic connector AND OR OR after determining the sequence. If the user is doing multiple rounds of inquiry, the instruction conversion module needs to consider the Chinese instruction in the context, fuse the current abstract syntax tree AST with the abstract syntax tree AST in the context, so as to construct complete inquiry, and enable the current operation to be connected with the Chinese instruction operation of the context. And combining all SQL clauses combined by the SQL template fragments filled by the parameters into corresponding SQL query sentences of a final queriable database, then sending the SQL query sentences to a data docking module, executing the SQL query sentences in the database to verify the performance and correctness of the SQL query sentences, continuously carrying out training test on the instruction conversion module according to the Chinese instruction data of the training set and the testing set according to the feedback result of the database, and adjusting the Chinese instruction semantic mapping and the process of generating the SQL query instructions until the function of the instruction conversion module reaches the operation expectation of a computer system of the Chinese instruction operation database.
The database interfacing module is mainly responsible for interacting with the database by using the corresponding instructions converted by the instruction converting module, firstly, the SQL query language converted by the instruction converting module is sent to the database, the database responds to the query command of the database interfacing module, returns the query result of the query statement of the database interfacing module, and the database interfacing module processes the response result of the database. When the response result of the database is data obtained by normal query, converting the response result into a format readable by a user, such as a JSON format, and displaying the JSON format data to the user in a form of a table or a chart through a visualization module; when the response result is an error prompt or operation failure, the database docking module captures execution errors of any database, converts the error prompt or failure result into a Chinese description readable by a user, and displays the errors to the user through the visualization module.
The system optimization module is mainly responsible for optimizing a computer system for operating the database by the medium instruction, determines that the database which is in butt joint with the computer system adopts a distributed database, prevents the whole crash of the computer system caused by the crash of the database, and improves the response speed when the database is operated; meanwhile, in order to ensure quick response of the user's instructions, the computer system of the Chinese instruction operation database caches some common Chinese instructions frequently used by the user, after the Chinese instructions are input by the input module, the system optimization module firstly checks the cache to see whether the Chinese instructions are stored in the cache, if the Chinese instructions exist in the cache, the SQL query statement mapped by the commands in the cache is directly used, the processing and conversion of the Chinese processing module and the instruction conversion module are not needed, and if the Chinese instructions are not in the cache, the Chinese instructions are processed and converted into the SQL query statement, and the Chinese instructions are stored in the cache for the next use.
The visualization module is mainly responsible for carrying out visualization display on data queried by the database, after the database docking module processes the query result of the data, the execution result processed by the visualization module is displayed in a form of a table, a chart and other visualization forms, and if the data volume is large, paging or rolling check is supported; meanwhile, the user can customize the system interface and functions according to personal preference and working habit, and the personal requirement of the user is met.
Meanwhile, the computer system of the Chinese instruction operation database also provides an API interface capable of providing the Chinese instruction operation database to the outside, so that other systems or programs can obtain the function of the Chinese instruction operation database through the API interface, the popularity and the availability of the computer system of the Chinese instruction operation database are improved, and when a user cannot operate an API, the user can inquire an API document provided by the computer system.
The computer system of the Chinese instruction operation database is designed by using modularization, and when one module in the system has bug or interface structure outdated condition, a worker can independently update and replace one module; when new functions are needed to be added to the system, the interface connection between each module is determined, and the new functions can be developed into a new module to be added into the computer system
In order to consider the safety of the computer system for operating the database by Chinese instructions, the system is also provided with a system safety module, and user data in the system and data of the database are protected from being revealed or tampered by taking measures such as user identity verification, data encryption, SQL injection protection and the like. When the user inputs the Chinese instruction to operate the database, checking whether the user has authority to execute the operation in the Chinese instruction, executing the database data according to the Chinese instruction, and prompting the user without authority; ensuring that only the authority required by the operation of necessary inquiry, deletion, update, insertion and the like is executed on the database account which is in butt joint with the computer system, and limiting that an attacker cannot execute unauthorized operation instead of all the authority of the database; when Chinese instructions input by a user are processed and mapped semantically, the Chinese instructions are verified to conform to an expected format, potential malicious structures are not contained, security audit is carried out on the computer regularly, abnormal behaviors are monitored, and therefore SQL injection attacks are found and prevented.
The foregoing examples have shown only the preferred embodiments of the invention, which are described in more detail and are not to be construed as limiting the scope of the invention. It should be noted that modifications, improvements and substitutions can be made by those skilled in the art without departing from the spirit of the invention, which are all within the scope of the invention. Accordingly, the scope of protection of the present invention is to be determined by the appended claims.
Claims (8)
1. A computer system for operating a database of chinese instructions, comprising:
the input module is responsible for inputting Chinese instructions of users; the Chinese processing module is used for analyzing Chinese instructions input by a user; the instruction conversion module is responsible for converting the information analyzed by the Chinese processing module into a query language which can be understood by the database; the database docking module is responsible for interacting with the database; the system optimization module is responsible for optimizing the performance of the system; the visualization module is in charge of carrying out visual display on data queried by a user; and the system safety protection module is responsible for user data and database safety in the system.
2. A computer system for operating a database according to a chinese instruction of claim 1, wherein in the input module, the user inputs chinese instructions in the command line input box by chinese input methods, and the module supports processing characters generated by various chinese input methods; meanwhile, when a user inputs a Chinese instruction, the system searches for providing automatic complement for the user instruction according to the typed Chinese instruction, and when the user needs, the user can press the enter key to realize automatic complement; or when the user inputs Chinese instructions, providing a user history record according to the typed Chinese instructions for the user to select.
3. The computer system for operating a database according to a chinese instruction of claim 1, wherein the database interfacing module is responsible for interacting with the database, first sending the SQL query language converted by the instruction module to the database, the database responding to the query of the database interfacing module, returning the query result, and the data interfacing module processing the response result of the database; when the response result of the database is normal data, converting the data into a format readable by a user, and displaying the format to the user through a visualization module; when the response result is an error prompt or operation failure, any execution error is captured, the error prompt or failure result is converted into a Chinese description readable by a user, and the Chinese description is displayed through a visualization module.
4. The computer system for operating a database according to claim 1, wherein the system optimization module is responsible for optimizing the system, and the database of the computer system interface of the Chinese instruction operation database adopts a distributed database to prevent the whole crash of the computer system caused by the crash of the database; meanwhile, the computer system of the Chinese instruction operation database should ensure that the user's instructions can be responded quickly, some common Chinese instructions can be cached, after the Chinese instructions are input by the input module, whether the Chinese instructions are stored in the cache is checked, if the Chinese instructions exist in the cache, the SQL query statement mapped by the instructions in the cache is directly used, the processing and conversion of the Chinese processing module and the instruction conversion module are not needed, if the Chinese instructions do not exist in the cache, the Chinese instructions are processed and converted into the SQL query statement, and the Chinese instructions are stored in the cache for the next use.
5. The computer system for operating a database according to a chinese instruction of claim 1, wherein the visualization module is configured to perform visual presentation of data queried from the database, and present an execution result of the user input instruction in a form of a table or a graph, and support paging or scrolling viewing if the amount of data is large; meanwhile, the user can customize the interface and the function according to personal preference and working habit, customize the color and layout of the computer system, or add functional plug-ins required when the computer system is used.
6. A computer system for a chinese instruction manipulation database according to claim 1, wherein said computer system for a chinese instruction manipulation database provides an API interface for the chinese instruction manipulation database to the outside, so that other systems or programs can obtain the functions of the chinese instruction manipulation database through the API interface, and has an API document describing how to use the API, the format of the request and the response.
7. The computer system of the chinese instruction manipulation database of claim 1, wherein the computer system of the chinese instruction manipulation database is configured to use modularization to perform system design, and when one of the modules in the system is bug-or interface structure-outdated, a worker can independently update and replace the one module; when new functions are required to be added to the system, interface connection between the system and each module is determined, and the new functions can be developed into a new module to be added into the computer system.
8. A computer system for operating a database according to chinese instructions of claim 1, wherein the system security module of the computer system for operating a database protects user data and database security in the system by employing user authentication, SQL injection, and security; when the user inputs the Chinese instruction to operate the database, checking whether the user has authority to execute the operation in the Chinese instruction, executing the database data according to the Chinese instruction, and prompting the user without authority; when Chinese instructions input by a user are subjected to Chinese processing and semantic mapping, the Chinese instructions are verified to conform to an expected format, potential malicious structures are not contained, and security audit is regularly carried out on the computer to monitor abnormal behaviors.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311678912.XA CN117667978A (en) | 2023-12-07 | 2023-12-07 | Computer system for operating database by Chinese instruction |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311678912.XA CN117667978A (en) | 2023-12-07 | 2023-12-07 | Computer system for operating database by Chinese instruction |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117667978A true CN117667978A (en) | 2024-03-08 |
Family
ID=90069487
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311678912.XA Pending CN117667978A (en) | 2023-12-07 | 2023-12-07 | Computer system for operating database by Chinese instruction |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117667978A (en) |
-
2023
- 2023-12-07 CN CN202311678912.XA patent/CN117667978A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP6714024B2 (en) | Automatic generation of N-grams and conceptual relationships from language input data | |
| US10592505B2 (en) | Natural language interfaces for databases using autonomous agents and thesauri | |
| US11797607B2 (en) | Method and apparatus for constructing quality evaluation model, device and storage medium | |
| CN1815477B (en) | Method and system for providing semantic subjects based on mark language | |
| US7447624B2 (en) | Generation of localized software applications | |
| CN111026319B (en) | Intelligent text processing method and device, electronic equipment and storage medium | |
| US20130124194A1 (en) | Systems and methods for manipulating data using natural language commands | |
| CN105550206B (en) | The edition control method and device of structured query sentence | |
| EP2044529A1 (en) | Reuse of available source data and localizations | |
| US20110320431A1 (en) | Strong typing for querying information graphs | |
| CN111026320B (en) | Multi-mode intelligent text processing method and device, electronic equipment and storage medium | |
| CN112395843A (en) | PHP code-based service processing method, device, equipment and medium | |
| US8219905B2 (en) | Automatically detecting keyboard layout in order to improve the quality of spelling suggestions | |
| JP2022538704A (en) | Regular expression generation with span highlight alignment | |
| US20170154029A1 (en) | System, method, and apparatus to normalize grammar of textual data | |
| CN113297251A (en) | Multi-source data retrieval method, device, equipment and storage medium | |
| US9189249B2 (en) | Method for automatically defining icons | |
| US20230132720A1 (en) | Multiple input machine learning framework for anomaly detection | |
| CN113687827B (en) | Data list generation method, device and equipment based on widget and storage medium | |
| CN117667978A (en) | Computer system for operating database by Chinese instruction | |
| CN110727428B (en) | Method and device for converting service logic layer codes and electronic equipment | |
| WO2010025062A1 (en) | Automatic test map generation for system verification test | |
| US11113300B2 (en) | System and method for enabling interoperability between a first knowledge base and a second knowledge base | |
| Zhang et al. | Automated Root Causing of Cloud Incidents using In-Context Learning with GPT-4 | |
| CN116340398B (en) | Method and system for deriving online custom report query |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |