CN103577560B - Method and device for inputting data base operating instructions - Google Patents
Method and device for inputting data base operating instructions Download PDFInfo
- Publication number
- CN103577560B CN103577560B CN201310507296.1A CN201310507296A CN103577560B CN 103577560 B CN103577560 B CN 103577560B CN 201310507296 A CN201310507296 A CN 201310507296A CN 103577560 B CN103577560 B CN 103577560B
- Authority
- CN
- China
- Prior art keywords
- characteristic information
- operational order
- information
- similarity
- 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.)
- Active
Links
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, more particularly to a kind of method and apparatus of input database operational order.
Background technology
As computer technology, network technology are developed rapidly, database technology also having obtained continuous development therewith,
The application of database is more and more extensive.
During the use of database, user can realize the operation to database by operational order, such as increase number
According to, delete data, modification data, inquiry data etc..User can be in terminal operating database front-end application program, in application journey
In the instruction input window that sequence is provided, corresponding operational order is input into by keyboard etc.（Such as SQL（Structured Query
Language, SQL）The operational order of statement form）, and click on executive button execution operational order.
Realize it is of the invention during, inventor find prior art at least there is problems with：
User multiple can enter the operating instructions during use is carried out to database, wherein, may be repeatedly defeated
Enter content identical operational order, or the close operational order of meeting input content, general front-end application can be chronologically right
The record that the operational order that history is performed is enumerated, the operational order that history execution is directly transferred in order to user is compiled
Collect to simplify the operation of input, however, historical record is arranged according to sequential, user wants to find and currently want input
The same or similar operational order of operational order searched in historical record, it is necessary to waste longer time, this cause input
The efficiency of operational order is more low.
The content of the invention
In order to solve problem of the prior art, a kind of method of input database operational order is the embodiment of the invention provides
And device.The technical scheme is as follows：
On the one hand, there is provided a kind of method of input database operational order, methods described includes：
Obtain the characteristic information of the operational order that history is performed；
According to default classifying rules, the characteristic information to obtaining carries out classification storage；
After receiving characteristic information and transferring request, the corresponding characteristic information of request is transferred according to the characteristic information, entered
The input of row operational order.
Preferably, the characteristic information for obtaining the operational order that history is performed, including：
Obtain the characteristic information of the operational order that history is performed and run succeeded.
Preferably, the characteristic information of the operational order, is the sentence skeleton of the operational order, wherein, the operation
The sentence skeleton of instruction is standardized format to be carried out to the sentence of the operational order and by the sentence of the operational order
Variate-value or clause replace with the content of text obtained after corresponding type identification.
Preferably, described according to default classifying rules, the characteristic information to obtaining carries out classification storage, including：
Obtain at least one reference characteristic information；
According to each characteristic information and the similarity information of each reference characteristic information for obtaining, to the characteristic information for obtaining
Carry out classification storage.
Preferably, at least one reference characteristic information of the acquisition, including：
Obtain at least one default reference characteristic information；Or,
According to the similarity information between each characteristic information for obtaining, in each characteristic information, at least one is obtained
Characteristic information, as reference characteristic information.
Preferably, it is described according to each characteristic information and the similarity information of each reference characteristic information for obtaining, to obtaining
The characteristic information for taking carries out classification storage, including：
Using each reference characteristic information an as node for pre-set level, characteristic information tree is set up；
Travel through each characteristic information for obtaining, when a characteristic information is traversed, according to the characteristic information that traverses with
The similarity information of each reference characteristic information, it is determined that special with first benchmark of characteristic information similarity highest for traversing
Reference ceases；
If the characteristic information for traversing meets default bar with the similarity information of the first reference characteristic information
Part, then using the characteristic information for traversing as the child node of the first reference characteristic information, traverse if described
Characteristic information be unsatisfactory for the similarity information of the first reference characteristic information it is pre-conditioned, then by the feature for traversing
Information as the first reference characteristic information the brother of node.
Preferably, it is described when receive characteristic information transfer request after, according to the characteristic information transfer request correspondence
Characteristic information, before carrying out the input of operational order, also include：
According to the result of the classification storage, classification is carried out to the characteristic information that classification is stored and is shown.
Preferably, after the characteristic information of described pair of acquisition carries out classification storage, also include：
Receive operational order；
According to the default classifying rules and the result of storage of classifying before, the characteristic information of the operational order that will be received
Carry out classification storage.
Preferably, described according to the default classifying rules and the result of storage of classifying before, the operation that will be received refers to
The characteristic information of order carries out classification storage, including：
When the quantity of the operational order for receiving reaches default value, classify according to the default classifying rules and before
The result of storage, the characteristic information of the operational order that will be received carries out classification storage.
On the other hand, there is provided a kind of device of input database operational order, described device includes：
Acquisition module, the characteristic information of the operational order for obtaining history execution；
Sort module, for according to default classifying rules, the characteristic information to obtaining to carry out classification storage；
Input module, for when receive characteristic information transfer request after, according to the characteristic information transfer request correspondence
Characteristic information, carry out the input of operational order.
Preferably, the acquisition module, is used for：
Obtain the characteristic information of the operational order that history is performed and run succeeded.
Preferably, the characteristic information of the operational order, is the sentence skeleton of the operational order, wherein, the operation
The sentence skeleton of instruction is standardized format to be carried out to the sentence of the operational order and by the sentence of the operational order
Variate-value or clause replace with the content of text obtained after corresponding type identification.
Preferably, the sort module, is used for：
Obtain at least one reference characteristic information；
According to each characteristic information and the similarity information of each reference characteristic information for obtaining, to the characteristic information for obtaining
Carry out classification storage.
Preferably, the sort module, is used for：
Obtain at least one default reference characteristic information；Or,
According to the similarity information between each characteristic information for obtaining, in each characteristic information, at least one is obtained
Characteristic information, as reference characteristic information.
Preferably, the sort module, is used for：
Using each reference characteristic information an as node for pre-set level, characteristic information tree is set up；
Travel through each characteristic information for obtaining, when a characteristic information is traversed, according to the characteristic information that traverses with
The similarity information of each reference characteristic information, it is determined that special with first benchmark of characteristic information similarity highest for traversing
Reference ceases；
If the characteristic information for traversing meets default bar with the similarity information of the first reference characteristic information
Part, then using the characteristic information for traversing as the child node of the first reference characteristic information, traverse if described
Characteristic information be unsatisfactory for the similarity information of the first reference characteristic information it is pre-conditioned, then by the feature for traversing
Information as the first reference characteristic information the brother of node.
Preferably, also including display module, it is used for：
Described after receiving characteristic information and transferring request, request corresponding feature letter is transferred according to the characteristic information
Breath, before carrying out the input of operational order, according to the result of the classification storage, the characteristic information to classification storage is classified
Display.
Preferably, the sort module, after the characteristic information of described pair of acquisition carries out classification storage, is additionally operable to：
Receive operational order；
According to the default classifying rules and the result of storage of classifying before, the characteristic information of the operational order that will be received
Carry out classification storage.
Preferably, the sort module, is used for：
When the quantity of the operational order for receiving reaches default value, classify according to the default classifying rules and before
The result of storage, the characteristic information of the operational order that will be received carries out classification storage.
The beneficial effect that technical scheme provided in an embodiment of the present invention is brought is：
In the embodiment of the present invention, the characteristic information of the operational order that history is performed is obtained, according to default classifying rules, to obtaining
The characteristic information for taking carries out classification storage, when receive characteristic information transfer request after, according to characteristic information transfer request correspondence
Characteristic information, carry out the input of operational order.So, can rapidly be searched according to classification and transfer corresponding feature and believed
Breath, completes the input of operational order, it is thus possible to improve enter the operating instructions by transferring the characteristic information of classification storage
Efficiency.
Brief description of the drawings
Technical scheme in order to illustrate more clearly the embodiments of the present invention, below will be to that will make needed for embodiment description
Accompanying drawing is briefly described, it should be apparent that, drawings in the following description are only some embodiments of the present invention, for
For those of ordinary skill in the art, on the premise of not paying creative work, other can also be obtained according to these accompanying drawings
Accompanying drawing.
Fig. 1 is the method flow diagram of input database operational order provided in an embodiment of the present invention；
Fig. 2 is the structural representation of characteristic information tree provided in an embodiment of the present invention；
Fig. 3 is the apparatus structure schematic diagram of input database operational order provided in an embodiment of the present invention.
Specific embodiment
To make the object, technical solutions and advantages of the present invention clearer, below in conjunction with accompanying drawing to embodiment party of the present invention
Formula is described in further detail.
Embodiment one
A kind of method of input database operational order is the embodiment of the invention provides, as shown in figure 1, the treatment of the method
Flow may include steps of：
Step 101, obtains the characteristic information of the operational order that history is performed.
Step 102, according to default classifying rules, the characteristic information to obtaining carries out classification storage.
Step 103, after receiving characteristic information and transferring request, request corresponding feature letter is transferred according to characteristic information
Breath, carries out the input of operational order.
In the embodiment of the present invention, the characteristic information of the operational order that history is performed is obtained, according to default classifying rules, to obtaining
The characteristic information for taking carries out classification storage, when receive characteristic information transfer request after, according to characteristic information transfer request correspondence
Characteristic information, carry out the input of operational order.So, can rapidly be searched according to classification and transfer corresponding feature and believed
Breath, completes the input of operational order, it is thus possible to improve enter the operating instructions by transferring the characteristic information of classification storage
Efficiency.
Embodiment two
A kind of method of input database operational order is the embodiment of the invention provides, the executive agent of the method can be
Terminal or server, the terminal can be the terminals for being provided with database front-end application program, and the server can be data
The background server of storehouse front-end application, while can also be the server for setting up the database.
Below in conjunction with specific processing mode, the handling process shown in Fig. 1 is described in detail, content can be as
Under：
Step 101, obtains the characteristic information of the operational order that history is performed.
Wherein, operational order refers to that user operates to database（Such as increase data, delete data, modification number
According to, inquiry data etc.）When the instruction that is input into, operational order is generally the sentence of certain database language, can be text formatting, such as
Operational order of SQL statement form etc..The characteristic information of operational order, can be much information, for example, it may be operational order
Sentence.Preferably, the characteristic information of operational order can be the sentence skeleton of operational order, wherein, the sentence of operational order
Skeleton is variate-value in standardized format and the sentence by operational order to be carried out to the sentence of operational order or clause replaces with
The content of text obtained after corresponding type identification.
In force, the Operation Log of database can be obtained, and obtains the sentence of wherein each operational order.For every
Individual sentence obtains its corresponding sentence skeleton, and process can be：
First, the sentence to operational order carries out standardized format.
The treatment of standardized format can unitize including capital and small letter, remove unnecessary AS clause, space unitizes（Such as
It is unified to use two spaces etc. using a space or unification）, removal noise character（Such as #, //）, remove unnecessary returning
Car, one or more treatment removed in the treatment such as unnecessary space.
Then, the variate-value in the sentence of operational order or clause are replaced with into corresponding type identification.
Variate-value can be understood as the object that keyword in operational order is operated, and the type of variate-value is determined by database
Justice, can be including field, table, view etc..For example, certain SQL statement " SELECT score, name FROM exam;", wherein,
SELECT and FROM is keyword, and score, name and exam are variate-value.Definition based on database understands, according to variate-value
The corresponding keyword in sentence, it may be determined that the type of variate-value, for example, the change behind the keyword such as SELECT, DELETE
The type of value is field, i.e., the type of score, name above in sentence is field, the variable behind the keyword such as FROM
The type of value is table, i.e., the type of exam above in sentence is table.
The type identification of variate-value is the mark of the type for representing variate-value for pre-setting.For example, can set
The corresponding type identification of field is F, and the corresponding type of table is T, and the corresponding type of view is V.For example, the sentence bone of sentence above
Frame can be " SELECT F, F FROM T;”.Additionally, it is preferred that, can also in type identification arranged side by side similar of record position
The quantity of variate-value or same clause, for example, " SELECT score, name FROM exam;" in score, the type of name
It is designated 2F, the type identification of exam is " SELECT2F FROM1T for the sentence skeleton of 1T, the i.e. sentence;”.
Clause is one section of sentence of any definition, for example, certain SQL statement " DATEPART (1F, CONVERT (1F)) AS1F "
In, " CONVERT (1F) " can be defined for a clause, or, " 1F, CONVERT (1F) " can be defined for a clause.Can
Think that the different clauses of definition set different type identifications, i.e. the type identification of clause is pre-set for representing different
The mark of clause, such as clause mark can be E, H or 1E, 1H etc..In the processing procedure of the characteristic information for obtaining operational order
In, can set：If certain clause is provided with type identification, then, as long as the clause occurred in any operational order, is obtaining
During taking characteristic information, the clause is all replaced with into the type mark.
Preferably, the operational order that the history for being obtained in the step is performed can be the operational order for running succeeded, that is,
The treatment of step 101 can obtain the characteristic information of the operational order that history is performed and run succeeded.So, can not be right
The operational order for statement error etc. occur is processed, and can improve treatment effeciency.
Preferably, the characteristic information for obtaining in this step, can be obtained after the characteristic information for getting rid of repetition
Individual or multiple characteristic informations.
Step 102, according to default classifying rules, the characteristic information to obtaining carries out classification storage.
Wherein, default classifying rules can arbitrarily be set according to the actual requirements, for example, can by keyword it is identical and order
Identical operational order is divided into a class.
Preferably, can be classified according to the similarity between each characteristic information, the processing procedure of corresponding step 102
Can be as follows：
First, at least one reference characteristic information is obtained.
Wherein, reference characteristic information is for use as the characteristic information that benchmark compares similarity with further feature information.Phase
The parameter of similarity degree between two texts is intended to indicate that like degree information, similarity information can use similarity distance, such as
Editing distance, longest common subsequence length, manhatton distance etc..
In force, at least one default reference characteristic information can be obtained, that is, obtains one or more default bases
Quasi- characteristic information.Preferably, a default reference characteristic information can be only set, and can set SELECT1F FROM1T is
Default reference characteristic information.
Or, it is also possible to according to the similarity information between each characteristic information for obtaining, in each characteristic information, obtain extremely
A few characteristic information, as reference characteristic information.Specifically, similarity letter that can first according to each characteristic information between any two
All characteristic informations are divided into some groups by breath（It is one or more groups of）, the condition of packet can be any two characteristic information in organizing
Between similarity reach predetermined requirement（As similarity distance is no more than predeterminable range value）, then, one is chosen in every group
Individual characteristic information（Can randomly select, it is also possible to according to pre-conditioned selection）As reference characteristic information.
Then, according to each characteristic information and the similarity information of each reference characteristic information for obtaining, to the spy for obtaining
Reference breath carries out classification storage.Specific processing procedure can be as follows：
Step one, using each reference characteristic information an as node for pre-set level, sets up characteristic information tree.
Wherein, characteristic information tree can be a multiway tree, and its structure can be with as shown in Fig. 2 in the characteristic information tree of Fig. 2
It is " SELECT1F FROM1T to have a reference characteristic information;", corresponding node is node 2.It is sentence bone for characteristic information
The situation of frame, characteristic information tree is also referred to as sentence skeletal tree.Preferably, the root node of characteristic information tree can be a dummy section
Point, does not correspond to any characteristic information, and each reference characteristic information can distinguish a two-level node in character pair inforamtion tree.
Total rank of multiway tree can arbitrarily be set according to demand, preferably could be arranged to three-level.It is sentence skeleton for characteristic information
Situation, reference characteristic information can be referred to as seed skeleton.
Step 2, travels through each characteristic information for obtaining, when a characteristic information is traversed, according to the feature for traversing
The similarity information of information and each reference characteristic information, it is determined that with characteristic information similarity the first benchmark of highest for traversing
Characteristic information.
According to the difference that similarity information is selected, different functions can be corresponded to out to calculate similarity information.
Step 3, if the similarity information of the characteristic information for traversing and the first reference characteristic information meets default bar
Part, then using this feature information as the first reference characteristic information child node, if this feature information and the first reference characteristic are believed
The similarity information of breath be unsatisfactory for it is pre-conditioned, then using this feature information as the first reference characteristic information the brother of node.
Wherein, if similarity information is similarity distance, pre-conditioned can be that similarity distance is less than present count
Value.
During optionally, for the characteristic information that traverses this as the child node of the first reference characteristic information, also
Can further be handled as follows：First, in other child nodes of the first reference characteristic information（Respectively different feature letters
Breath）In, it is determined that the characteristic information similarity highest fisrt feature information traversed with this；Then, if the feature for traversing
Information meets pre-conditioned with the similarity information of fisrt feature information, then using this feature information as fisrt feature information son
Node, if this feature information be unsatisfactory for the similarity information of fisrt feature information it is pre-conditioned, by this feature information make
It is the brother of node of fisrt feature information.Optionally, for the characteristic information that traverses this as fisrt feature information son
The situation of node, method can also be continued with according to this, be not repeated herein.
By above-mentioned steps one, two, three, in the characteristic information tree obtained after traveling through all characteristic informations, it is believed that
One classification of each two-level node correspondence, each two-level node and its child node belong to the corresponding classification of the two-level node.
Step 103, after receiving characteristic information and transferring request, request corresponding feature letter is transferred according to characteristic information
Breath, carries out the input of operational order.
Wherein, characteristic information transfers request and transfers corresponding characteristic information for request（Can be transferred in characteristic information please
Seek the mark of middle carrying characteristic information）, to show the framework of corresponding operational order according to characteristic information, can be wrapped in the framework
The input room of variate-value in keyword and the respective operations instruction of operational order is included, user can be input into room is input into and become
Value.
Preferably, before the step is performed, can also be according to the result of the classification storage, to the feature of classification storage
Information carries out classification and shows.
Specifically, all classification during classification results can be shown, and display belongs to all of the classification in each classification
Characteristic information.For above-mentioned foundation and when storing characteristic information tree, this feature inforamtion tree can be transferred and shown.
During in force, for executive agent for terminal, can be provided with the front-end application of database
History performs record option, and after user clicks on the option, terminal can then show that history performs record window, and transfer its storage
Characteristic information tree, be displayed in history perform record window in, including each node of this feature inforamtion tree, can be each
The information content of each characteristic information of position display of node.When user clicks on certain node selects corresponding characteristic information, eventually
Then generation characteristic information transfers request at end, and the mark of the characteristic information of user's selection can be carried in characteristic information transfers request
（That is the mark of node, in such as Fig. 21,2,3,4）.Hereafter, terminal can transfer the feature letter in request according to characteristic information
The mark of breath, transfers corresponding characteristic information, according to the characteristic information transferred, this feature information is shown in instruction input window
The framework of corresponding operational order, in can including that the keyword and respective operations of operational order are instructed in the framework of operational order
The input room of variate-value, the prompt message of the type of variate-value can also be shown in input empty place, and user can be in input
The variate-value of needs is manually entered in room（Such as score, exam）, for example, by input through keyboard, or be able to can also adopt
With the mode of dragging, the variate-value shown in the display window of library of object is dragged to and is input into room.
When executive agent is server, processing procedure is similar with THP terminal handler process, and difference is：Eventually
When end display history performs record window, to server request characteristic information tree, the characteristic information tree that server will be stored sends
Shown to terminal；Characteristic information transfers request and is sent to server by terminal, and server is transferred corresponding characteristic information and returned
Back to terminal, it is input into accordingly in terminal.
After operational order input is finished, the operational order being input into can be performed by clicking on executive button.
The step of above-mentioned flow 102 be disposed after, classification can also be carried out to the operational order of subsequent execution and deposited
Storage, processing procedure can be as follows：
Step one, receives operational order.
Wherein, the operational order of reception is the operational order of execution after step 102.
Step 2, according to above-mentioned default classifying rules and the result of storage of classifying before, the operational order that will be received
Characteristic information carries out classification storage.
Before the new operational order for receiving is inserted into the result of classification storage, the operational order that will newly receive is divided
To in corresponding classification and store.
Can according to the actual requirements, for the treatment of the step sets arbitrary trigger condition, for example, each can performed
The treatment of the step is all carried out after operational order, it is also possible to carry out the step after every a number of operational order of execution
Treatment, the treatment of the step can also be carried out when cycle regular hour is often reached.
Preferably, the treatment of the step can be：When the quantity of the operational order for receiving reaches default value, according to
Above-mentioned default classifying rules and the result of storage of classifying before, the characteristic information of the operational order that will be received carry out classification and deposit
Storage.The default value can be any positive integer, such as 1,10,50.
In the embodiment of the present invention, the characteristic information of the operational order that history is performed is obtained, it is right according to default classifying rules
The characteristic information of acquisition carries out classification storage, when receive characteristic information transfer request after, according to characteristic information transfer request it is right
The characteristic information answered, carries out the input of operational order.So, can rapidly be searched according to classification and transfer corresponding feature and believed
Breath, completes the input of operational order, it is thus possible to improve enter the operating instructions by transferring the characteristic information of classification storage
Efficiency.
Embodiment three
Based on identical technology design, the embodiment of the present invention additionally provides a kind of device of input database operational order,
As shown in figure 3, described device includes：
Acquisition module 310, the characteristic information of the operational order for obtaining history execution；
Sort module 320, for according to default classifying rules, the characteristic information to obtaining to carry out classification storage；
Input module 330, for when receive characteristic information transfer request after, according to the characteristic information transfer request it is right
The characteristic information answered, carries out the input of operational order.
Preferably, the acquisition module 310, is used for：
Obtain the characteristic information of the operational order that history is performed and run succeeded.
Preferably, the characteristic information of the operational order, is the sentence skeleton of the operational order, wherein, the operation
The sentence skeleton of instruction is standardized format to be carried out to the sentence of the operational order and by the sentence of the operational order
Variate-value or clause replace with the content of text obtained after corresponding type identification.
Preferably, the sort module 320, is used for：
Obtain at least one reference characteristic information；
According to each characteristic information and the similarity information of each reference characteristic information for obtaining, to the characteristic information for obtaining
Carry out classification storage.
Preferably, the sort module 320, is used for：
Obtain at least one default reference characteristic information；Or,
According to the similarity information between each characteristic information for obtaining, in each characteristic information, at least one is obtained
Characteristic information, as reference characteristic information.
Preferably, the sort module 320, is used for：
Using each reference characteristic information an as node for pre-set level, characteristic information tree is set up；
Travel through each characteristic information for obtaining, when a characteristic information is traversed, according to the characteristic information that traverses with
The similarity information of each reference characteristic information, it is determined that special with first benchmark of characteristic information similarity highest for traversing
Reference ceases；
If the characteristic information for traversing meets default bar with the similarity information of the first reference characteristic information
Part, then using the characteristic information for traversing as the child node of the first reference characteristic information, traverse if described
Characteristic information be unsatisfactory for the similarity information of the first reference characteristic information it is pre-conditioned, then by the feature for traversing
Information as the first reference characteristic information the brother of node.
Preferably, also including display module, it is used for：
Described after receiving characteristic information and transferring request, request corresponding feature letter is transferred according to the characteristic information
Breath, before carrying out the input of operational order, according to the result of the classification storage, the characteristic information to classification storage is classified
Display.
Preferably, the sort module 320, after the characteristic information of described pair of acquisition carries out classification storage, is additionally operable to：
Receive operational order；
According to the default classifying rules and the result of storage of classifying before, the characteristic information of the operational order that will be received
Carry out classification storage.
Preferably, the sort module 320, is used for：
When the quantity of the operational order for receiving reaches default value, classify according to the default classifying rules and before
The result of storage, the characteristic information of the operational order that will be received carries out classification storage.
In the embodiment of the present invention, the characteristic information of the operational order that history is performed is obtained, it is right according to default classifying rules
The characteristic information of acquisition carries out classification storage, when receive characteristic information transfer request after, according to characteristic information transfer request it is right
The characteristic information answered, carries out the input of operational order.So, can rapidly be searched according to classification and transfer corresponding feature and believed
Breath, completes the input of operational order, it is thus possible to improve enter the operating instructions by transferring the characteristic information of classification storage
Efficiency.
It should be noted that：The device of the input database operational order that above-described embodiment is provided is operated in input database
During instruction, only carried out with the division of above-mentioned each functional module for example, in practical application, can be as needed and by above-mentioned work(
Can distribution completed by different functional module, will the internal structure of device be divided into different functional modules, more than completion
The all or part of function of description.In addition, the device and input number of the input database operational order that above-described embodiment is provided
Embodiment of the method according to storehouse operational order belongs to same design, and it implements process and refers to embodiment of the method, no longer goes to live in the household of one's in-laws on getting married here
State.
The embodiments of the present invention are for illustration only, and the quality of embodiment is not represented.
One of ordinary skill in the art will appreciate that realizing that all or part of step of above-described embodiment can be by hardware
To complete, it is also possible to instruct the hardware of correlation to complete by program, described program can be stored in a kind of computer-readable
In storage medium, storage medium mentioned above can be read-only storage, disk or CD etc..
The foregoing is only presently preferred embodiments of the present invention, be not intended to limit the invention, it is all it is of the invention spirit and
Within principle, any modification, equivalent substitution and improvements made etc. should be included within the scope of the present invention.
Claims (16)
1. a kind of method of input database operational order, it is characterised in that methods described includes：
Obtain the characteristic information of the operational order that history is performed；
According to default classifying rules, the characteristic information to obtaining carries out classification storage；
After receiving characteristic information and transferring request, the corresponding characteristic information of request is transferred according to the characteristic information, grasped
The input that work is instructed；
It is described that according to default classifying rules, the characteristic information to obtaining carries out classification storage, including：
Obtain at least one reference characteristic information；
According to each characteristic information and the similarity information of each reference characteristic information for obtaining, the characteristic information to obtaining is carried out
Classification storage.
2. method according to claim 1, it is characterised in that the feature letter of the operational order that the acquisition history is performed
Breath, including：
Obtain the characteristic information of the operational order that history is performed and run succeeded.
3. method according to claim 1, it is characterised in that the characteristic information of the operational order, is that the operation refers to
The sentence skeleton of order, wherein, the sentence skeleton of the operational order is to carry out standardized format to the sentence of the operational order
And the variate-value in the sentence of the operational order or clause are replaced with the content of text obtained after corresponding type identification.
4. method according to claim 1, it is characterised in that the reference characteristic information of the acquisition at least one, including：
Obtain at least one default reference characteristic information；Or,
According to the similarity information between each characteristic information for obtaining, in each characteristic information, at least one feature is obtained
Information, as reference characteristic information.
5. method according to claim 1, it is characterised in that described according to each characteristic information for obtaining and each benchmark
The similarity information of characteristic information, the characteristic information to obtaining carries out classification storage, including：
Using each reference characteristic information an as node for pre-set level, characteristic information tree is set up；
Travel through obtain each characteristic information, when a characteristic information is traversed, according to the characteristic information for traversing and each
The similarity information of reference characteristic information, it is determined that believing with first reference characteristic of characteristic information similarity highest for traversing
Breath；
If the characteristic information for traversing meets pre-conditioned with the similarity information of the first reference characteristic information,
Using the characteristic information for traversing as the first reference characteristic information child node, if it is described traverse feature letter
Breath is unsatisfactory for pre-conditioned with the similarity information of the first reference characteristic information, then make the characteristic information that traverses
It is the brother of node of the first reference characteristic information.
6. method according to claim 1, it is characterised in that described after receiving characteristic information and transferring request, root
The corresponding characteristic information of request is transferred according to the characteristic information, before carrying out the input of operational order, is also included：
According to the result of the classification storage, classification is carried out to the characteristic information that classification is stored and is shown.
7. method according to claim 1, it is characterised in that the characteristic information of described pair of acquisition carries out storage of classifying
Afterwards, also include：
Receive operational order；
According to the default classifying rules and the result of storage of classifying before, the characteristic information of the operational order that will be received is carried out
Classification storage.
8. method according to claim 7, it is characterised in that described to be deposited with classification before according to the default classifying rules
The result of storage, the characteristic information of the operational order that will be received carries out classification storage, including：
When the quantity of the operational order for receiving reaches default value, stored with classification before according to the default classifying rules
Result, the characteristic information of the operational order that will be received carries out classification storage.
9. a kind of device of input database operational order, it is characterised in that described device includes：
Acquisition module, the characteristic information of the operational order for obtaining history execution；
Sort module, for according to default classifying rules, the characteristic information to obtaining to carry out classification storage；
Input module, for after receiving characteristic information and transferring request, the corresponding spy of request being transferred according to the characteristic information
Reference ceases, and carries out the input of operational order；
The sort module, is used for：
Obtain at least one reference characteristic information；
According to each characteristic information and the similarity information of each reference characteristic information for obtaining, the characteristic information to obtaining is carried out
Classification storage.
10. device according to claim 9, it is characterised in that the acquisition module, is used for：
Obtain the characteristic information of the operational order that history is performed and run succeeded.
11. devices according to claim 9, it is characterised in that the characteristic information of the operational order, are that the operation refers to
The sentence skeleton of order, wherein, the sentence skeleton of the operational order is to carry out standardized format to the sentence of the operational order
And the variate-value in the sentence of the operational order or clause are replaced with the content of text obtained after corresponding type identification.
12. devices according to claim 9, it is characterised in that the sort module, are used for：
Obtain at least one default reference characteristic information；Or,
According to the similarity information between each characteristic information for obtaining, in each characteristic information, at least one feature is obtained
Information, as reference characteristic information.
13. devices according to claim 9, it is characterised in that the sort module, are used for：
Using each reference characteristic information an as node for pre-set level, characteristic information tree is set up；
Travel through obtain each characteristic information, when a characteristic information is traversed, according to the characteristic information for traversing and each
The similarity information of reference characteristic information, it is determined that believing with first reference characteristic of characteristic information similarity highest for traversing
Breath；
If the characteristic information for traversing meets pre-conditioned with the similarity information of the first reference characteristic information,
Using the characteristic information for traversing as the first reference characteristic information child node, if it is described traverse feature letter
Breath is unsatisfactory for pre-conditioned with the similarity information of the first reference characteristic information, then make the characteristic information that traverses
It is the brother of node of the first reference characteristic information.
14. devices according to claim 9, it is characterised in that also including display module, be used for：
The corresponding characteristic information of request is transferred according to the characteristic information after receiving characteristic information and transferring request described,
Before carrying out the input of operational order, according to the result of the classification storage, the characteristic information to classification storage carries out classifying aobvious
Show.
15. devices according to claim 9, it is characterised in that the sort module, in the described pair of characteristic information of acquisition
Carry out after classification storage, be additionally operable to：
Receive operational order；
According to the default classifying rules and the result of storage of classifying before, the characteristic information of the operational order that will be received is carried out
Classification storage.
16. devices according to claim 15, it is characterised in that the sort module, are used for：
When the quantity of the operational order for receiving reaches default value, stored with classification before according to the default classifying rules
Result, the characteristic information of the operational order that will be received carries out classification storage.
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 CN103577560A (en) | 2014-02-12 |
| CN103577560B true 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) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US10706368B2 (en) * | 2015-12-30 | 2020-07-07 | Veritas Technologies Llc | Systems and methods for efficiently classifying data objects |
| CN106126195B (en) * | 2016-06-30 | 2019-01-15 | 联想(北京)有限公司 | A kind of information processing method and electronic equipment |
Citations (4)
| 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 |
| 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 |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102110111A (en) * | 2009-12-29 | 2011-06-29 | 北京大学 | Method and system for processing database operating command |
| CN101853182A (en) * | 2010-05-05 | 2010-10-06 | 中兴通讯股份有限公司 | Task execution method and device based on database |
| CN102096717B (en) * | 2011-02-15 | 2013-01-16 | 百度在线网络技术（北京）有限公司 | Search method and search engine |
-
2013
- 2013-10-24 CN CN201310507296.1A patent/CN103577560B/en active Active
Patent Citations (4)
| 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 |
| 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103577560A (en) | 2014-02-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11120344B2 (en) | Suggesting follow-up queries based on a follow-up recommendation machine learning model | |
| US11461320B2 (en) | Determining a user-specific approach for disambiguation based on an interaction recommendation machine learning model | |
| US10885026B2 (en) | Translating a natural language request to a domain-specific language request using templates | |
| CN110471916B (en) | Database query method, device, server and medium | |
| US10713269B2 (en) | Determining a presentation format for search results based on a presentation recommendation machine learning model | |
| CN112214611B (en) | Enterprise knowledge graph construction system and method | |
| US11170016B2 (en) | Navigating hierarchical components based on an expansion recommendation machine learning model | |
| CN104636478A (en) | Information query method and device | |
| CN105335402B (en) | Searching method, index data generation method and device based on static Cache | |
| CN107515878A (en) | The management method and device of a kind of data directory | |
| US11494395B2 (en) | Creating dashboards for viewing data in a data storage system based on natural language requests | |
| US11106713B2 (en) | Sampling data using inverted indexes in response to grouping selection | |
| CN103324701A (en) | Data searching device and method | |
| CN108446391A (en) | Processing method, device, electronic equipment and the computer-readable medium of data | |
| US20190034430A1 (en) | Disambiguating a natural language request based on a disambiguation recommendation machine learning model | |
| CN106776668A (en) | Search servomechanism, terminal installation and the method for searching for distributed network | |
| CN104820700B (en) | The processing method of substation's unstructured data | |
| CN111125199B (en) | Database access method and device and electronic equipment | |
| CN112256880A (en) | Text recognition method and device, storage medium and electronic equipment | |
| CN108287889A (en) | A kind of multi-source heterogeneous date storage method and system based on elastic table model | |
| CN103577560B (en) | Method and device for inputting data base operating instructions | |
| KR101955376B1 (en) | Processing method for a relational query in distributed stream processing engine based on shared-nothing architecture, recording medium and device for performing the method | |
| CN110019380B (en) | Data query method, device, server and storage medium | |
| CN106933844A (en) | Towards the construction method of the accessibility search index of extensive RDF data | |
| CN108959584A (en) | A kind of method and device of the processing diagram data based on community structure |
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 |