CN103577560A - Method and device for inputting data base operating instructions - Google Patents
Method and device for inputting data base operating instructions Download PDFInfo
- Publication number
- CN103577560A CN103577560A CN201310507296.1A CN201310507296A CN103577560A CN 103577560 A CN103577560 A CN 103577560A CN 201310507296 A CN201310507296 A CN 201310507296A CN 103577560 A CN103577560 A CN 103577560A
- Authority
- CN
- China
- Prior art keywords
- characteristic information
- operational order
- information
- classifying
- obtaining
- 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.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/903—Querying
- G06F16/9032—Query formulation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
Abstract
The invention discloses a method and device for inputting data base operating instructions and belongs to the technical field of data bases. The method comprises the following steps: acquiring feature information of an operating instruction executed historically; carrying out classified storage to the acquired feature information according to a pre-set classification rule; after a feature information calling request is received, calling feature information corresponding to the request according to the feature information, and inputting the operating instruction. Through the adoption of the invention, the operating instruction inputting efficiency can be improved.
Description
Technical field
The present invention relates to database technical field, particularly a kind of method and apparatus of input database operational order.
Background technology
Along with the develop rapidly of computer technology, network technology, database technology is also obtaining continuous development thereupon, and the application of database is more and more extensive.
In the use procedure of database, user can realize the operation to database by operational order, as increases data, deletion data, Update Table, data query etc.User can be at terminal operating database front-end application, in the instruction input window providing in application program, by the corresponding operational order of the input such as keyboard (as SQL(Structured Query Language, the operational order of statement form), and click the instruction of executive button executable operations Structured Query Language (SQL)).
In realizing process of the present invention, inventor finds that prior art at least exists following problem:
User is in the process that database is used, can repeatedly enter the operating instructions, wherein, may repeat the operational order that input content is identical, or the close operational order of meeting input content, the record that the operational order that general front-end application can be carried out history is chronologically enumerated, so that directly transferring the historical operational order of carrying out, user edits, simplify the operation of input, yet, historical record is arranged according to sequential, user wants to find and the current same or similar operational order of operational order of wanting input, need the longer time of waste to search in historical record, this causes the efficiency that enters the operating instructions comparatively low.
Summary of the invention
In order to solve the problem of prior art, the embodiment of the present invention provides a kind of method and apparatus of input database operational order.Described technical scheme is as follows:
On the one hand, provide a kind of method of input database operational order, described method comprises:
Obtain the characteristic information of the historical operational order of carrying out;
According to default classifying rules, to the characteristic information the obtaining storage of classifying;
When receiving characteristic information, transfer after request, according to described characteristic information, transfer request characteristic of correspondence information, carry out the input of operational order.
Preferably, described in obtain the characteristic information of the historical operational order of carrying out, comprising:
Obtain the characteristic information of the historical operational order of carrying out and running succeeded.
Preferably, the characteristic information of described operational order, statement skeleton for described operational order, wherein, the statement skeleton of described operational order is that the statement of described operational order is carried out standardized format and the variate-value in the statement of described operational order or clause are replaced with to the content of text obtaining after corresponding type identification.
Preferably, the classifying rules that described basis is default, to the characteristic information the obtaining storage of classifying, comprising:
Obtain at least one reference characteristic information;
According to the similarity information of each characteristic information obtaining and each reference characteristic information, to the characteristic information the obtaining storage of classifying.
Preferably, described in obtain at least one reference characteristic information, comprising:
Obtain at least one default reference characteristic information; Or,
According to the similarity information between each characteristic information obtaining, in described each characteristic information, obtain at least one characteristic information, as reference characteristic information.
Preferably, each characteristic information that described basis is obtained and the similarity information of each reference characteristic information, to the characteristic information the obtaining storage of classifying, comprising:
Node using each reference characteristic information as a pre-set level, sets up characteristic information tree;
Each characteristic information of obtaining of traversal, when traversing a characteristic information, according to the similarity information of the characteristic information traversing and each reference characteristic information, determine and described in the highest the first reference characteristic information of the characteristic information similarity that traverses;
If described in the characteristic information that traverses and the similarity information of described the first reference characteristic information meet pre-conditioned, the child node using the described characteristic information traversing as described the first reference characteristic information, if described in the similarity information of the characteristic information that traverses and described the first reference characteristic information do not meet pre-conditioned, the brother of node using the described characteristic information traversing as described the first reference characteristic information.
Preferably, described, when receiving characteristic information, transfer after request, according to described characteristic information, transfer request characteristic of correspondence information, before carrying out the input of operational order, also comprise:
According to the result of described classification storage, to the demonstration of classifying of the characteristic information of classification storage.
Preferably, described to the characteristic information obtaining classify storage after, also comprise:
Receive operational order;
According to the result of described default classifying rules and classification storage before, by the storage of classifying of the characteristic information of the operational order receiving.
Preferably, described according to the result of described default classifying rules and classification storage before, by the storage of classifying of the characteristic information of the operational order receiving, comprising:
When the quantity of the operational order receiving reaches default value, according to the result of described default classifying rules and classification storage before, by the storage of classifying of the characteristic information of the operational order receiving.
On the other hand, provide a kind of device of input database operational order, described device comprises:
Acquisition module, for obtaining the characteristic information of the historical operational order of carrying out;
Sort module, for according to default classifying rules, to the characteristic information the obtaining storage of classifying;
Load module, for transferring after request when receiving characteristic information, transfers request characteristic of correspondence information according to described characteristic information, carries out the input of operational order.
Preferably, described acquisition module, for:
Obtain the characteristic information of the historical operational order of carrying out and running succeeded.
Preferably, the characteristic information of described operational order, statement skeleton for described operational order, wherein, the statement skeleton of described operational order is that the statement of described operational order is carried out standardized format and the variate-value in the statement of described operational order or clause are replaced with to the content of text obtaining after corresponding type identification.
Preferably, described sort module, for:
Obtain at least one reference characteristic information;
According to the similarity information of each characteristic information obtaining and each reference characteristic information, to the characteristic information the obtaining storage of classifying.
Preferably, described sort module, for:
Obtain at least one default reference characteristic information; Or,
According to the similarity information between each characteristic information obtaining, in described each characteristic information, obtain at least one characteristic information, as reference characteristic information.
Preferably, described sort module, for:
Node using each reference characteristic information as a pre-set level, sets up characteristic information tree;
Each characteristic information of obtaining of traversal, when traversing a characteristic information, according to the similarity information of the characteristic information traversing and each reference characteristic information, determine and described in the highest the first reference characteristic information of the characteristic information similarity that traverses;
If described in the characteristic information that traverses and the similarity information of described the first reference characteristic information meet pre-conditioned, the child node using the described characteristic information traversing as described the first reference characteristic information, if described in the similarity information of the characteristic information that traverses and described the first reference characteristic information do not meet pre-conditioned, the brother of node using the described characteristic information traversing as described the first reference characteristic information.
Preferably, also comprise display module, for:
Described, when receiving characteristic information, transfer after request, according to described characteristic information, transfer request characteristic of correspondence information, before carrying out the input of operational order, according to the result of described classification storage, to the demonstration of classifying of the characteristic information of classification storage.
Preferably, described sort module, described the characteristic information obtaining is classified storage after, also for:
Receive operational order;
According to the result of described default classifying rules and classification storage before, by the storage of classifying of the characteristic information of the operational order receiving.
Preferably, described sort module, for:
When the quantity of the operational order receiving reaches default value, according to the result of described default classifying rules and classification storage before, by the storage of classifying of the characteristic information of the operational order receiving.
The beneficial effect that the technical scheme that the embodiment of the present invention provides is brought is:
In the embodiment of the present invention, obtain the characteristic information of the historical operational order of carrying out, according to default classifying rules, to the characteristic information the obtaining storage of classifying, when receiving characteristic information, transfer after request, according to characteristic information, transfer request characteristic of correspondence information, carry out the input of operational order.Like this, can search rapidly and transfer corresponding characteristic information according to classification, by transferring the characteristic information of classification storage, carry out the input of complete operation instruction, thereby, the efficiency entering the operating instructions can be improved.
Accompanying drawing explanation
In order to be illustrated more clearly in the technical scheme in the embodiment of the present invention, below the accompanying drawing of required use during embodiment is described is briefly described, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skills, do not paying under the prerequisite of creative work, can also obtain according to these accompanying drawings other accompanying drawing.
Fig. 1 is the method flow diagram of the input database operational order that provides of the embodiment of the present invention;
Fig. 2 is the structural representation of the characteristic information tree that provides of the embodiment of the present invention;
Fig. 3 is the apparatus structure schematic diagram of the input database operational order that provides of the embodiment of the present invention.
Embodiment
For making the object, technical solutions and advantages of the present invention clearer, below in conjunction with accompanying drawing, embodiment of the present invention is described further in detail.
Embodiment mono-
The embodiment of the present invention provides a kind of method of input database operational order, and as shown in Figure 1, the treatment scheme of the method can comprise the steps:
In the embodiment of the present invention, obtain the characteristic information of the historical operational order of carrying out, according to default classifying rules, to the characteristic information the obtaining storage of classifying, when receiving characteristic information, transfer after request, according to characteristic information, transfer request characteristic of correspondence information, carry out the input of operational order.Like this, can search rapidly and transfer corresponding characteristic information according to classification, by transferring the characteristic information of classification storage, carry out the input of complete operation instruction, thereby, the efficiency entering the operating instructions can be improved.
Embodiment bis-
The embodiment of the present invention provides a kind of method of input database operational order, the executive agent of the method can be terminal or server, this terminal can be the terminal that database front-end application is installed, this server can be the background server of database front-end application, can also be the server of setting up this database simultaneously.
Below in conjunction with concrete processing mode, the treatment scheme shown in Fig. 1 is elaborated, content can be as follows:
Wherein, operational order refers to, the instruction of user's input when database being operated to (as increasing data, deletion data, Update Table, data query etc.), and operational order is generally the statement of certain database language, can be text formatting, as operational order of SQL statement form etc.The characteristic information of operational order, can be much information, for example, can be the statement of operational order.Preferably, the characteristic information of operational order can be the statement skeleton of operational order, wherein, the statement skeleton of operational order is that the statement of operational order is carried out standardized format and the variate-value in the statement of operational order or clause are replaced with to the content of text obtaining after corresponding type identification.
In force, can obtain the Operation Log of database, and obtain the statement of wherein each operational order.For each statement, obtain its corresponding statement skeleton, process can be:
First, the statement of operational order is carried out to standardized format.
The processing of standardized format can comprise capital and small letter unitize, remove unnecessary AS clause, space unitized (as unified, using a space or unified two spaces etc. of using), remove noise character (as #, // etc.), remove unnecessary carriage return, remove one or more processing in processing such as unnecessary space.
Then, the variate-value in the statement of operational order or clause are replaced with to corresponding type identification.
Variate-value can be understood as the object that in operational order, key word operates, and the type of variate-value, by database definition, can comprise field, table, view etc.For example, certain SQL statement " SELECT score, name FROM exam; ", wherein, SELECT and FROM are key word, score, name and exam are variate-value.Definition based on database is known, according to the key word of variate-value correspondence in statement, can determine the type of variate-value, for example, the type of the key word such as SELECT, DELETE variate-value is below field, the type of score, the name in statement is field above, and the type of the key words such as FROM variate-value is below table, and the type of the exam in statement is table above.
The type identification of variate-value be set in advance for representing the sign of the type of variate-value.For example, the type identification that Related fields can be set is F, and showing corresponding type is T, and the type that view is corresponding is V.For example,,, the statement skeleton of statement can be " SELECT F, F FROM T; ".In addition, preferred, can also be in type identification record position similar variate-value arranged side by side or the quantity of same clause, for example, " SELECT score, name FROM exam; " middle score, the type identification of name is 2F, and the type identification of exam is 1T, and the statement skeleton of this statement is " SELECT2F FROM1T; ".
Clause is one section of statement of definition arbitrarily, and for example, in certain SQL statement " DATEPART (1F; CONVERT (1F)) AS1F ", can define " CONVERT (1F) " is a clause, or, can define " 1F, CONVERT (1F) " is a clause.Can different type identifications be set for the different clauses of definition, clause's type identification be set in advance for representing different clauses' sign, such as clause sign, can be E, H or 1E, 1H etc.In the processing procedure of characteristic information of obtaining operational order, can arrange: if certain clause is provided with type identification, so, in any operational order, need only this clause who occurs, in obtaining the process of characteristic information, all this clause is replaced with to the type sign.
Preferably, the operational order that the history of obtaining in this step is carried out can be the operational order running succeeded, and also, the processing of step 101 can be to obtain the characteristic information of the historical operational order of carrying out and running succeeded.Like this, can be not to occurring that the operational order of statement mistake etc. processes, can improve treatment effeciency.
Preferably, the characteristic information obtaining in this step, can be to get rid of the one or more characteristic informations that obtain after the characteristic information of repetition.
Wherein, default classifying rules can arrange arbitrarily according to the actual requirements, for example, can be by key word the identical and identical operational order of order be divided into a class.
Preferably, can classify according to the similarity between each characteristic information, the processing procedure of corresponding step 102 can be as follows:
First, obtain at least one reference characteristic information.
Wherein, reference characteristic information is for the characteristic information as benchmark and further feature information comparison similarity.Similarity information is that similarity information can adopt similarity distance for representing the parameter of similarity degree between two texts, as editing distance, longest common subsequence length, manhatton distance etc.
In force, can obtain at least one default reference characteristic information, obtain one or more default reference characteristic information.Preferably, a default reference characteristic information can be only set, it is default reference characteristic information that SELECT1F FROM1T can be set.
Or, also can, according to the similarity information between each characteristic information obtaining, in each characteristic information, obtain at least one characteristic information, as reference characteristic information.Concrete, can be first according to each characteristic information similarity information between any two, all characteristic informations are divided into some groups (one or more groups), the condition of grouping can be, similarity in group between any two characteristic informations reaches predetermined requirement (as similarity distance is no more than predeterminable range value), then, in every group, choose a characteristic information (can choose at random, also can choose according to pre-conditioned) as reference characteristic information.
Then, according to the similarity information of each characteristic information obtaining and each reference characteristic information, to the characteristic information the obtaining storage of classifying.Concrete processing procedure can be as follows:
Step 1, the node using each reference characteristic information as a pre-set level, sets up characteristic information tree.
Wherein, characteristic information tree can be a multiway tree, and its structure can be as shown in Figure 2, in the characteristic information tree of Fig. 2, has a reference characteristic information for " SELECT1F FROM1T; ", corresponding node is node 2.For characteristic information, be the situation of statement skeleton, characteristic information tree also can be called statement skeletal tree.Preferably, the root node of characteristic information tree can be a dummy node, not corresponding any characteristic information, and each reference characteristic information can be distinguished a two-level node in character pair inforamtion tree.Total rank of multiway tree can arrange arbitrarily according to demand, preferably can be set to three grades.For characteristic information, be the situation of statement skeleton, reference characteristic information can be called seed skeleton.
Step 2, each characteristic information that traversal is obtained, when traversing a characteristic information, according to the similarity information of the characteristic information traversing and each reference characteristic information, determines the first reference characteristic information the highest with the characteristic information similarity traversing.
According to the difference of similarity Information Selection, can correspondence go out different functions, calculate similarity information.
Step 3, if the similarity information of the characteristic information traversing and the first reference characteristic information meets pre-conditioned, the child node using this characteristic information as the first reference characteristic information, if it is pre-conditioned that the similarity information of this characteristic information and the first reference characteristic information does not meet, the brother of node using this characteristic information as the first reference characteristic information.
Wherein, if similarity information is similarity distance, pre-conditioned can be that similarity distance is less than default value.
Optionally, situation for the characteristic information that this is traversed as the child node of the first reference characteristic information, can also further be handled as follows: first, in other child node (being respectively different characteristic informations) of the first reference characteristic information, determine the highest First Characteristic information of characteristic information similarity traversing therewith; Then, if the similarity information of the characteristic information traversing and First Characteristic information meets pre-conditioned, the child node using this characteristic information as First Characteristic information, if it is pre-conditioned that the similarity information of this characteristic information and First Characteristic information does not meet, the brother of node using this characteristic information as First Characteristic information.Optionally, the situation for the characteristic information that this is traversed as the child node of First Characteristic information, can also Using such method continue to process, and at this, is not repeated.
Through above-mentioned steps one, two, three, in the characteristic information tree obtaining, can think the corresponding classification of each two-level node after all characteristic informations of traversal, each two-level node and its child node belong to the classification that this two-level node is corresponding.
Wherein, characteristic information is transferred request and is transferred corresponding characteristic information (can transfer the sign that characteristic information is carried in request at characteristic information) for request, to show the framework of corresponding operational order according to characteristic information, the input room that can comprise variate-value in the key word of operational order and respective operations instruction in this framework, user can be in input room input variable value.
Preferably, before carrying out this step, can also be according to the result of described classification storage, to the demonstration of classifying of the characteristic information of classification storage.
Concrete, can show all classification in classification results, and show all characteristic informations that belong to this classification in each classification.For above-mentioned foundation and store the situation of characteristic information tree, can transfer and show this characteristic information tree.
In force, the situation that is terminal for executive agent, in the front-end application of database, can be provided with historical executive logging option, user clicks after this option, terminal can show historical executive logging window, and transfers the characteristic information tree of its storage, is presented in historical executive logging window, comprising each node of this characteristic information tree, can be in the information content of each characteristic information of position display of each node.When user clicks certain node and selects corresponding characteristic information, terminal generating feature information is transferred request, at characteristic information, transfers the sign that can carry the characteristic information that user selects in request (being the sign of node, as 1 in Fig. 2,2,3,4 etc.).After this, terminal can be transferred according to characteristic information the sign of the characteristic information in request, transfer characteristic of correspondence information, according to the characteristic information of transferring, the framework that shows the operational order that this characteristic information is corresponding in instruction input window, the input room that can comprise variate-value in the key word of operational order and respective operations instruction in the framework of operational order, the information that can also show the type of variate-value at input empty place, the variate-value that user can manually input needs in input room is (as score, exam etc.), for example, can input by keyboard, or also can adopt the mode dragging, the variate-value showing in the display window of library of object is dragged in input room.
The situation that is server for executive agent, processing procedure and THP terminal handler process are similar, difference is: when terminal shows historical executive logging window, to server request characteristic information tree, server sends to terminal to show the characteristic information tree of storage; Characteristic information is transferred request and is sent to server by terminal, and server is transferred corresponding characteristic information and returned to terminal, in terminal, inputs accordingly.
After operational order input, can carry out the operational order of having inputted by clicking executive button.
After the step 102 of above-mentioned flow process is disposed, can also be to the storage of classifying of the operational order of follow-up execution, processing procedure can be as follows:
Step 1, receives operational order.
Wherein, the operational order of reception is the operational order that step 102 is carried out afterwards.
Step 2, according to the result of above-mentioned default classifying rules and classification storage before, by the storage of classifying of the characteristic information of the operational order receiving.
Before the operational order newly receiving is inserted into, in the result of classification storage, is about to the new operational order receiving and is divided in corresponding classification and storage.
Can be according to the actual requirements, for the processing of this step arranges trigger condition arbitrarily, for example, can after carrying out each operational order, carry out the processing of this step, also the processing of this step can be after the operational order of every execution some, carried out, the processing of this step can also be when often reaching cycle regular hour, carried out.
Preferably, the processing of this step can be: when the quantity of the operational order receiving reaches default value, according to the result of above-mentioned default classifying rules and classification storage before, by the storage of classifying of the characteristic information of the operational order receiving.This default value can be any positive integer, as 1,10,50 etc.
In the embodiment of the present invention, obtain the characteristic information of the historical operational order of carrying out, according to default classifying rules, to the characteristic information the obtaining storage of classifying, when receiving characteristic information, transfer after request, according to characteristic information, transfer request characteristic of correspondence information, carry out the input of operational order.Like this, can search rapidly and transfer corresponding characteristic information according to classification, by transferring the characteristic information of classification storage, carry out the input of complete operation instruction, thereby, the efficiency entering the operating instructions can be improved.
Embodiment tri-
Technical conceive based on identical, the embodiment of the present invention also provides a kind of device of input database operational order, and as shown in Figure 3, described device comprises:
Preferably, described acquisition module 310, for:
Obtain the characteristic information of the historical operational order of carrying out and running succeeded.
Preferably, the characteristic information of described operational order, statement skeleton for described operational order, wherein, the statement skeleton of described operational order is that the statement of described operational order is carried out standardized format and the variate-value in the statement of described operational order or clause are replaced with to the content of text obtaining after corresponding type identification.
Preferably, described sort module 320, for:
Obtain at least one reference characteristic information;
According to the similarity information of each characteristic information obtaining and each reference characteristic information, to the characteristic information the obtaining storage of classifying.
Preferably, described sort module 320, for:
Obtain at least one default reference characteristic information; Or,
According to the similarity information between each characteristic information obtaining, in described each characteristic information, obtain at least one characteristic information, as reference characteristic information.
Preferably, described sort module 320, for:
Node using each reference characteristic information as a pre-set level, sets up characteristic information tree;
Each characteristic information of obtaining of traversal, when traversing a characteristic information, according to the similarity information of the characteristic information traversing and each reference characteristic information, determine and described in the highest the first reference characteristic information of the characteristic information similarity that traverses;
If described in the characteristic information that traverses and the similarity information of described the first reference characteristic information meet pre-conditioned, the child node using the described characteristic information traversing as described the first reference characteristic information, if described in the similarity information of the characteristic information that traverses and described the first reference characteristic information do not meet pre-conditioned, the brother of node using the described characteristic information traversing as described the first reference characteristic information.
Preferably, also comprise display module, for:
Described, when receiving characteristic information, transfer after request, according to described characteristic information, transfer request characteristic of correspondence information, before carrying out the input of operational order, according to the result of described classification storage, to the demonstration of classifying of the characteristic information of classification storage.
Preferably, described sort module 320, described the characteristic information obtaining is classified storage after, also for:
Receive operational order;
According to the result of described default classifying rules and classification storage before, by the storage of classifying of the characteristic information of the operational order receiving.
Preferably, described sort module 320, for:
When the quantity of the operational order receiving reaches default value, according to the result of described default classifying rules and classification storage before, by the storage of classifying of the characteristic information of the operational order receiving.
In the embodiment of the present invention, obtain the characteristic information of the historical operational order of carrying out, according to default classifying rules, to the characteristic information the obtaining storage of classifying, when receiving characteristic information, transfer after request, according to characteristic information, transfer request characteristic of correspondence information, carry out the input of operational order.Like this, can search rapidly and transfer corresponding characteristic information according to classification, by transferring the characteristic information of classification storage, carry out the input of complete operation instruction, thereby, the efficiency entering the operating instructions can be improved.
It should be noted that: the device of the input database operational order that above-described embodiment provides is when input database operational order, only the division with above-mentioned each functional module is illustrated, in practical application, can above-mentioned functions be distributed and by different functional modules, completed as required, the inner structure that is about to device is divided into different functional modules, to complete all or part of function described above.In addition, the device of the input database operational order that above-described embodiment provides and the embodiment of the method for input database operational order belong to same design, and its specific implementation process refers to embodiment of the method, repeats no more here.
The invention described above embodiment sequence number, just to describing, does not represent the quality of embodiment.
One of ordinary skill in the art will appreciate that all or part of step that realizes above-described embodiment can complete by hardware, also can come the hardware that instruction is relevant to complete by program, described program can be stored in a kind of computer-readable recording medium, the above-mentioned storage medium of mentioning can be ROM (read-only memory), disk or CD etc.
The foregoing is only preferred embodiment of the present invention, in order to limit the present invention, within the spirit and principles in the present invention not all, any modification of doing, be equal to replacement, improvement etc., within all should being included in protection scope of the present invention.
Claims (18)
1. a method for input database operational order, is characterized in that, described method comprises:
Obtain the characteristic information of the historical operational order of carrying out;
According to default classifying rules, to the characteristic information the obtaining storage of classifying;
When receiving characteristic information, transfer after request, according to described characteristic information, transfer request characteristic of correspondence information, carry out the input of operational order.
2. method according to claim 1, is characterized in that, described in obtain the characteristic information of the historical operational order of carrying out, comprising:
Obtain the characteristic information of the historical operational order of carrying out and running succeeded.
3. method according to claim 1, it is characterized in that, the characteristic information of described operational order, statement skeleton for described operational order, wherein, the statement skeleton of described operational order is that the statement of described operational order is carried out standardized format and the variate-value in the statement of described operational order or clause are replaced with to the content of text obtaining after corresponding type identification.
4. method according to claim 1, is characterized in that, the classifying rules that described basis is default, to the characteristic information the obtaining storage of classifying, comprising:
Obtain at least one reference characteristic information;
According to the similarity information of each characteristic information obtaining and each reference characteristic information, to the characteristic information the obtaining storage of classifying.
5. method according to claim 4, is characterized in that, described in obtain at least one reference characteristic information, comprising:
Obtain at least one default reference characteristic information; Or,
According to the similarity information between each characteristic information obtaining, in described each characteristic information, obtain at least one characteristic information, as reference characteristic information.
6. method according to claim 4, is characterized in that, each characteristic information that described basis is obtained and the similarity information of each reference characteristic information, to the characteristic information the obtaining storage of classifying, comprising:
Node using each reference characteristic information as a pre-set level, sets up characteristic information tree;
Each characteristic information of obtaining of traversal, when traversing a characteristic information, according to the similarity information of the characteristic information traversing and each reference characteristic information, determine and described in the highest the first reference characteristic information of the characteristic information similarity that traverses;
If described in the characteristic information that traverses and the similarity information of described the first reference characteristic information meet pre-conditioned, the child node using the described characteristic information traversing as described the first reference characteristic information, if described in the similarity information of the characteristic information that traverses and described the first reference characteristic information do not meet pre-conditioned, the brother of node using the described characteristic information traversing as described the first reference characteristic information.
7. method according to claim 1, is characterized in that, described, when receiving characteristic information, transfers after request, according to described characteristic information, transfers request characteristic of correspondence information, before carrying out the input of operational order, also comprises:
According to the result of described classification storage, to the demonstration of classifying of the characteristic information of classification storage.
8. method according to claim 1, is characterized in that, described to the characteristic information obtaining classify storage after, also comprise:
Receive operational order;
According to the result of described default classifying rules and classification storage before, by the storage of classifying of the characteristic information of the operational order receiving.
9. method according to claim 8, is characterized in that, described according to the result of described default classifying rules and classification storage before, by the storage of classifying of the characteristic information of the operational order receiving, comprising:
When the quantity of the operational order receiving reaches default value, according to the result of described default classifying rules and classification storage before, by the storage of classifying of the characteristic information of the operational order receiving.
10. a device for input database operational order, is characterized in that, described device comprises:
Acquisition module, for obtaining the characteristic information of the historical operational order of carrying out;
Sort module, for according to default classifying rules, to the characteristic information the obtaining storage of classifying;
Load module, for transferring after request when receiving characteristic information, transfers request characteristic of correspondence information according to described characteristic information, carries out the input of operational order.
11. devices according to claim 10, is characterized in that, described acquisition module, for:
Obtain the characteristic information of the historical operational order of carrying out and running succeeded.
12. devices according to claim 10, it is characterized in that, the characteristic information of described operational order, statement skeleton for described operational order, wherein, the statement skeleton of described operational order is that the statement of described operational order is carried out standardized format and the variate-value in the statement of described operational order or clause are replaced with to the content of text obtaining after corresponding type identification.
13. devices according to claim 10, is characterized in that, described sort module, for:
Obtain at least one reference characteristic information;
According to the similarity information of each characteristic information obtaining and each reference characteristic information, to the characteristic information the obtaining storage of classifying.
14. devices according to claim 13, is characterized in that, described sort module, for:
Obtain at least one default reference characteristic information; Or,
According to the similarity information between each characteristic information obtaining, in described each characteristic information, obtain at least one characteristic information, as reference characteristic information.
15. devices according to claim 13, is characterized in that, described sort module, for:
Node using each reference characteristic information as a pre-set level, sets up characteristic information tree;
Each characteristic information of obtaining of traversal, when traversing a characteristic information, according to the similarity information of the characteristic information traversing and each reference characteristic information, determine and described in the highest the first reference characteristic information of the characteristic information similarity that traverses;
If described in the characteristic information that traverses and the similarity information of described the first reference characteristic information meet pre-conditioned, the child node using the described characteristic information traversing as described the first reference characteristic information, if described in the similarity information of the characteristic information that traverses and described the first reference characteristic information do not meet pre-conditioned, the brother of node using the described characteristic information traversing as described the first reference characteristic information.
16. devices according to claim 10, is characterized in that, also comprise display module, for:
Described, when receiving characteristic information, transfer after request, according to described characteristic information, transfer request characteristic of correspondence information, before carrying out the input of operational order, according to the result of described classification storage, to the demonstration of classifying of the characteristic information of classification storage.
17. devices according to claim 10, is characterized in that, described sort module, described the characteristic information obtaining is classified storage after, also for:
Receive operational order;
According to the result of described default classifying rules and classification storage before, by the storage of classifying of the characteristic information of the operational order receiving.
18. devices according to claim 17, is characterized in that, described sort module, for:
When the quantity of the operational order receiving reaches default value, according to the result of described default classifying rules and classification storage before, by the storage of classifying of the characteristic information of the operational order receiving.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310507296.1A CN103577560B (en) | 2013-10-24 | 2013-10-24 | Method and device for inputting data base operating instructions |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310507296.1A CN103577560B (en) | 2013-10-24 | 2013-10-24 | Method and device for inputting data base operating instructions |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103577560A true CN103577560A (en) | 2014-02-12 |
| CN103577560B CN103577560B (en) | 2017-05-24 |
Family
ID=50049336
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310507296.1A Active CN103577560B (en) | 2013-10-24 | 2013-10-24 | Method and device for inputting data base operating instructions |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103577560B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106126195A (en) * | 2016-06-30 | 2016-11-16 | 联想(北京)有限公司 | A kind of information processing method and electronic equipment |
| CN108604239A (en) * | 2015-12-30 | 2018-09-28 | 华睿泰科技有限责任公司 | System and method for effective grouped data object |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101158973A (en) * | 2007-11-21 | 2008-04-09 | 华为技术有限公司 | Command inputting auxiliary means and equipment |
| CN101169712A (en) * | 2006-10-24 | 2008-04-30 | 英业达股份有限公司 | Command prompt system and method |
| CN102096717A (en) * | 2011-02-15 | 2011-06-15 | 百度在线网络技术（北京）有限公司 | Search method and search engine |
| CN102110111A (en) * | 2009-12-29 | 2011-06-29 | 北京大学 | Method and system for processing database operating command |
| WO2011137672A1 (en) * | 2010-05-05 | 2011-11-10 | 中兴通讯股份有限公司 | Method and device for task execution based on database |
| CN102323923A (en) * | 2011-05-18 | 2012-01-18 | 北京百纳威尔科技有限公司 | Method for processing historical record and equipment |
| CN103092970A (en) * | 2013-01-24 | 2013-05-08 | 华为技术有限公司 | Database operation method and device |
-
2013
- 2013-10-24 CN CN201310507296.1A patent/CN103577560B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101169712A (en) * | 2006-10-24 | 2008-04-30 | 英业达股份有限公司 | Command prompt system and method |
| CN101158973A (en) * | 2007-11-21 | 2008-04-09 | 华为技术有限公司 | Command inputting auxiliary means and equipment |
| CN102110111A (en) * | 2009-12-29 | 2011-06-29 | 北京大学 | Method and system for processing database operating command |
| WO2011137672A1 (en) * | 2010-05-05 | 2011-11-10 | 中兴通讯股份有限公司 | Method and device for task execution based on database |
| CN102096717A (en) * | 2011-02-15 | 2011-06-15 | 百度在线网络技术（北京）有限公司 | Search method and search engine |
| CN102323923A (en) * | 2011-05-18 | 2012-01-18 | 北京百纳威尔科技有限公司 | Method for processing historical record and equipment |
| CN103092970A (en) * | 2013-01-24 | 2013-05-08 | 华为技术有限公司 | Database operation method and device |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108604239A (en) * | 2015-12-30 | 2018-09-28 | 华睿泰科技有限责任公司 | System and method for effective grouped data object |
| CN108604239B (en) * | 2015-12-30 | 2022-01-28 | 华睿泰科技有限责任公司 | System and method for efficiently classifying data objects |
| CN106126195A (en) * | 2016-06-30 | 2016-11-16 | 联想(北京)有限公司 | A kind of information processing method and electronic equipment |
| CN106126195B (en) * | 2016-06-30 | 2019-01-15 | 联想(北京)有限公司 | A kind of information processing method and electronic equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103577560B (en) | 2017-05-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104951539B (en) | Internet data center's harmful information monitoring system | |
| US10095747B1 (en) | Similar document identification using artificial intelligence | |
| CN104636478A (en) | Information query method and device | |
| CN104991955A (en) | Method and system for automatically constructing template library | |
| CN103942220A (en) | Method used for intelligently linking work orders with knowledge of knowledge base and suitable for IT operation and maintenance system | |
| CN110276456A (en) | A kind of machine learning model auxiliary construction method, system, equipment and medium | |
| CN115061721A (en) | Report generation method and device, computer equipment and storage medium | |
| CN113254507B (en) | Intelligent construction and inventory method for data asset directory | |
| CN111652468A (en) | Business process generation method and device, storage medium and computer equipment | |
| CN111008521A (en) | Method and device for generating wide table and computer storage medium | |
| Zou et al. | LDA analyzer: A tool for exploring topic models | |
| CN112115313B (en) | Regular expression generation and data extraction methods, devices, equipment and media | |
| CN108829651A (en) | A kind of method, apparatus of document treatment, terminal device and storage medium | |
| CN111930912A (en) | Dialogue management method, system, device and storage medium | |
| CN114911915A (en) | Knowledge graph-based question and answer searching method, system, equipment and medium | |
| CN105550361A (en) | Log processing method and apparatus, and ask-answer information processing method and apparatus | |
| CN108027824B (en) | Future script generation device and method, and computer-readable storage medium | |
| CN102662929A (en) | Method and device for intelligent problem analyzing and processing based on ontology | |
| JP2020061136A (en) | Accessible machine learning backend | |
| Liu et al. | Designing discovery experience for big data interaction: a case of web-based knowledge mining and interactive visualization platform | |
| CN103577560A (en) | Method and device for inputting data base operating instructions | |
| CN116127047B (en) | Method and device for establishing enterprise information base | |
| CN116595191A (en) | Construction method and device of interactive low-code knowledge graph | |
| CN115329753B (en) | Intelligent data analysis method and system based on natural language processing | |
| KR102532216B1 (en) | Method for establishing ESG database with structured ESG data using ESG auxiliary tool and ESG service providing system performing the same |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |