CN106874411B - A kind of searching method and search platform of table - Google Patents
A kind of searching method and search platform of table Download PDFInfo
- Publication number
- CN106874411B CN106874411B CN201710046729.6A CN201710046729A CN106874411B CN 106874411 B CN106874411 B CN 106874411B CN 201710046729 A CN201710046729 A CN 201710046729A CN 106874411 B CN106874411 B CN 106874411B
- Authority
- CN
- China
- Prior art keywords
- keyword
- database
- information
- relational tree
- user
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2452—Query translation
- G06F16/24522—Translation of natural language queries to structured queries
-
- 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/242—Query formulation
- G06F16/2425—Iterative querying; Query formulation based on the results of a preceding query
-
- 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
- G06F16/2455—Query execution
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- Artificial Intelligence (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of searching methods of table, comprising: is searched in the table of database according to the first keyword and a line or multirow data of first Keywords matching；Wherein, the database purchase multiple tables, each table includes multirow data；First unit lattice information is extracted from a line or multirow data with first Keywords matching as the second keyword；It is searched in the table of the database according to second keyword and a line or multirow data of second Keywords matching.Correspondingly, the invention also discloses a kind of search platforms of table.The present invention obtains the data that part includes destination-related information by once search, later using the result that first time searches for as the second keyword, utilize the incidence relation that the second keyword and other include between the table of related information, execute binary search, obtain more fully target data, operational intelligence is improved, is searched for more flexible.
Description
Technical field
The present invention relates to information search fields, and in particular, to a kind of searching method and search platform of table.
Background technique
In the prior art, the development of various projects has increasing need for being worked by the association table collaboration of magnanimity.With trip
For play, with going deep into for game design, plans numerical tabular and be increasingly becoming essential a part in game item, it makes
Planning can more freely carry out the adjustment of numerical value, it is most important that it reduces workflow and links up cost, improves
Working efficiency.For more complicated system, usual Planning Work person can design multiple numerical tabulars, therefore game is
System, playing method it is abundanter, plan the quantity of documents of table, data volume will be more.
Summary of the invention
Inventor is in implementing the present invention, it may, have found that the prior art is defective.It is abundant in system, the playing method of game
In the case where, the information type of table is very more, such as the various welfare activities in game, just contain activity SN, title,
Various types of information such as activity declaration, time started, trigger condition, advertising map and publicity time, and these associated information
It is not distributed across in same table, using existing table search method, single keyword is carried out on search platform
Search, if keyword can only cannot include in the table of related information with other with the content matching of certain tables
Hold matching, then can search for less than comprehensive related information, inefficiency.
The technical problem to be solved in the present invention is that a kind of searching method of table is provided, energy thorough search to target
The associated information of data improves search efficiency.
In order to solve the above-mentioned technical problem, the one side of the embodiment of the present invention provides a kind of searching method of table, comprising:
It is searched in the table of database according to the first keyword and a line or multirow number of first Keywords matching
According to；Wherein, the database purchase multiple tables, each table includes multirow data；
First unit lattice information is extracted from a line or multirow data with first Keywords matching to close as second
Keyword；
It is searched in the table of the database according to second keyword and a line of second Keywords matching
Or multirow data.
The implementation of the embodiments of the present invention has the following beneficial effects:
The searching method of table provided in an embodiment of the present invention is obtained and the first Keywords matching by first time search
Part includes the data of destination-related information, later using the result that first time searches for as the second keyword, utilizes the second key
Word and other include the incidence relation between the table of related information, execute binary search, get more fully target
Data, while operational intelligence is improved, search for more flexible, raising search efficiency.
Further, it is searched in the table of the database described according to second keyword and is closed with described second
After the matched a line of keyword or multirow data, further includes:
One or more second unit lattice information are extracted from a line or multirow data with second Keywords matching；
Establish table set of relationship；Wherein, to include first information type same with the second information type for the table set of relationship
Table incidence relation, across the table relation of equality of the second information type and third information type and third information type and the 4th information
The same table incidence relation of type；The first information type is to be located at the first of the same table with the first unit lattice information
Information type belonging to keyword, second information type is information type belonging to the first unit lattice information, described
Third information type is to be located at information type belonging to the second keyword of the same table, institute with the second unit lattice information
Stating the 4th information type is information type belonging to the second unit lattice information；
The relational tree for the information type that the table set of relationship is related to is established, and the relational tree is stored in the data
In library；
According to the relational tree look-up command that user inputs, call the relational tree look-up command institute right from the database
The relational tree answered meets the search result of the relational tree look-up command according to relational tree output.
In further scheme, according to the table incidence relation used when searching for twice, table set of relationship, Jin Erjian are established
Vertical relational tree, this relational tree have clearly reproduced the process manually tabled look-up, it is shown that the incidence relation between multilist, subsequent
Search in, can realize the richer searching method for meeting user demand with call relation tree.
Further, it is described establish table set of relationship after, further includes: according to the table set of relationship create indicate by
The customized label of 4th information type described in the first information type queries；
The then relational tree look-up command inputted according to user is called the relational tree to search from the database and is referred to
Corresponding relational tree is enabled, the search result of the relational tree look-up command is met according to relational tree output, is specifically included:
The customized label being easily selected by a user is identified from the relational tree look-up command that user inputs；
Relational tree corresponding to the customized label being easily selected by a user is called from the database, and exports the relationship
Tree checks for user.
The further scheme is an application scheme for relational tree, and search platform closes after establishing table set of relationship for table
Assembly closes creation customized label, and as relational tree is configured with customized label, and customized label is searched for for user, selected,
After user has selected customized label, relevant relational tree can be shown.Facilitate user to check table relational structure, improves planning
The working efficiency filled in a form.
Further, the relational tree look-up command inputted according to user, calls the relationship from the database
Relational tree corresponding to look-up command is set, the search result of the relational tree look-up command is met according to relational tree output,
Further include:
The third keyword of user's input is received, it is corresponding using the root node of third keyword as the relational tree
Cell information；
Tree automatically generates query statement according to the relationships；
It is scanned in the database using the query statement, it is right respectively to obtain all nodes in the relational tree
The cell information answered, and the relational tree of output token all nodes corresponding cell information checks for user.
The further scheme is another application scheme of relational tree, after user has selected customized label, Ji Kezhan
Show relevant relational tree.When user proposes third keyword, the i.e. corresponding cell information of root node, search platform can be automatic
It generates SQL statement and carries out global search, show the corresponding cell information of all nodes on relational tree, return and believe with the cell
The associated all target datas of manner of breathing substantially increase the efficiency of search and comprehensive.
Further, the relational tree look-up command is natural language sentence；
It is described to identify the customized label being easily selected by a user from the relational tree look-up command that user inputs, it is specific to wrap
It includes:
The natural language sentence that user inputs is handled by segmentation methods, obtains multiple phrases；
The multiple phrase is referred to the customized label with the multiple phrase matching by subsumption algorithm；
Extracting the customized label with the multiple phrase matching is the customized label being easily selected by a user.
The further scheme is another application scheme of relational tree, after user has selected customized label, Ji Kezhan
Show relevant relational tree.And since the relationship between information type is clearly marked in customized label, user can be with
Natural language sentence scans for target data.For example, user will check " price of stage property rice-pudding leaf is how many ", by participle and
Subsumption algorithm can get label " by stage property name query price " and third keyword " rice-pudding leaf ".Use natural language sentence
Target data is searched for, user's search is more convenient.
Further, first unit lattice letter is extracted in described a line or multirow data from first Keywords matching
Breath is used as the second keyword, specifically includes:
Receive the binary search instruction of user；Wherein, the binary search instruction includes selection instruction, the selection instruction
For selecting a cell information from described a line or multirow data with first Keywords matching；
Marking cell information corresponding to the selection instruction is first unit lattice information, and by the first unit lattice
Information is as the second keyword；
It is then described to be searched in the table of the database according to second keyword and second Keywords matching
A line or multirow data, specifically include:
It whether identifies in the binary search instruction comprising the 4th keyword；
If including the 4th keyword in the binary search instruction, according to the 4th keyword in the database
A line or multirow data with second Keywords matching are searched in partial table；Wherein, the partial table is list name
It include the table of the 4th keyword in title；
If not comprising the 4th keyword in the binary search instruction, according to second keyword in the data
A line or multirow data with second Keywords matching are searched in all forms in library.
Further, the configuration method of the database includes:
Read the original form document that user uploads；It wherein, include multiple original tables in the original form document, it is each
The original table includes multiple sublists；
The title of all original tables and the title of the sublist are read, generates and records title and form serial number
Summary table；
All data in each sublist are read, table corresponding with each sublist is automatically created；
The summary table and the table corresponding with each sublist are added into the database；
Then it is described searched in the table of database according to the first keyword with a line of first Keywords matching or
Multirow data, comprising:
N-th title is read from the summary table of the database；
The search of the first keyword is carried out in the table corresponding to n-th title；
If in table corresponding to the n-th title including first keyword, to described in user's output
First keyword all data of the row and the title of the n-th table are checked for user；And read the number
According to next title in the summary table in library；
If not reading the number comprising first keyword in table corresponding to the n-th title
According to next title in the summary table in library.
The another aspect of the embodiment of the present invention provides a kind of search platform of table, comprising:
First searching module, for being searched in the table of database according to the first keyword and first keyword
The a line or multirow data matched；Wherein, the database purchase multiple tables, each table includes multirow data；
First extraction module, for extracting first unit from a line or multirow data with first Keywords matching
Lattice information is as the second keyword；
Second searching module, for being searched in the table of the database according to second keyword and described second
A line or multirow data of Keywords matching.
The implementation of the embodiments of the present invention has the following beneficial effects:
The search platform of table provided in an embodiment of the present invention is obtained and the first Keywords matching by first time search
Part includes the data of destination-related information, later using the result that first time searches for as the second keyword, utilizes the second key
Word and other include the incidence relation between the table of related information, execute binary search, get more fully target
Data, while operational intelligence is improved, search for more flexible, raising search efficiency.
Further, described search platform further include:
Second extraction module, for extracting one or more from a line or multirow data with second Keywords matching
A second unit lattice information；
Set establishes module, for establishing table set of relationship；Wherein, the table set of relationship include first information type with
The same table incidence relation of second information type, across the table relation of equality of the second information type and third information type and third are believed
Cease the same table incidence relation of type and the 4th information type；The first information type is to be located at the first unit lattice information
Information type belonging to first keyword of the same table, second information type are belonging to the first unit lattice information
Information type, the third information type is the second keyword institute for being located at the same table with the second unit lattice information
The information type of category, the 4th information type are information type belonging to the second unit lattice information；
Relational tree establishes module, for establishing the relational tree for the information type that the table set of relationship is related to, and will be described
Relational tree is stored in the database；
Deep search module, the relational tree look-up command for being inputted according to user, from the database described in calling
Relational tree corresponding to relational tree look-up command meets the search knot of the relational tree look-up command according to relational tree output
Fruit.
Further, described search platform further includes tag creation module, for it is described establish table set of relationship after,
The customized label for indicating the 4th information type as described in the first information type queries is created according to the table set of relationship；
Then the deep search module includes:
First recognition unit, for identified from the relational tree look-up command that user inputs be easily selected by a user it is customized
Label；
First output unit, for calling relationship corresponding to the customized label being easily selected by a user from the database
Tree, and export the relational tree and checked for user.
Further, the deep search module, further includes:
Second recognition unit, the third for identifying user's input from the relational tree look-up command that user inputs are crucial
Word, using the corresponding cell information of the root node of third keyword as the relational tree；
Sentence generation unit automatically generates query statement for setting according to the relationships；
Second output unit obtains the relationship for scanning in the database using the query statement
The corresponding cell information of all nodes in tree, and the output token relational tree of the corresponding cell information of all nodes
It is checked for user.
Further, the relational tree look-up command is natural language sentence；
First recognition unit includes:
Participle subelement is obtained for being handled by segmentation methods the natural language sentence that user inputs
Multiple phrases；
Sort out subelement, for by subsumption algorithm by the multiple phrase be referred to the multiple phrase matching oneself
Define label；
Tag extraction subelement is to be easily selected by a user for extracting the customized label with the multiple phrase matching
Customized label.
Further, which is characterized in that first extraction module includes:
Receiving unit, the binary search for receiving user instruct；Wherein, the binary search instruction includes that selection refers to
It enables, the selection instruction is used to select a cell from described a line or multirow data with first Keywords matching
Information；
Marking unit is first unit lattice information for marking cell information corresponding to the selection instruction, and will
The first unit lattice information is as the second keyword；
Then second searching module includes:
Whether third recognition unit includes for identification the 4th keyword in the binary search instruction；
First search unit, if being closed for including the 4th keyword in binary search instruction according to the described 4th
Keyword is searched and a line or multirow data of second Keywords matching in the partial table of the database；Wherein, institute
State partial table be title in include the 4th keyword table；
Second search unit, if in binary search instruction not comprising the 4th keyword, according to described the
Two keywords are searched and a line or multirow data of second Keywords matching in all forms of the database.
Further, the configuration method of the database includes:
Read the original form document that user uploads；It wherein, include multiple original tables in the original form document, it is each
The original table includes multiple sublists；
The title of all original tables and the title of the sublist are read, generates and records title and form serial number
Summary table；
All data in each sublist are read, table corresponding with each sublist is automatically created；
The summary table and the table corresponding with each sublist are added into the database；
Then first searching module includes:
Reading unit, for reading n-th title from the summary table of the database；
Third search unit, for carrying out the search of the first keyword in the table corresponding to n-th title；
Asynchronous loading unit, if for including first keyword in table corresponding to the n-th title,
Then looked into the title that user exports first keyword all data of the row and the n-th table for user
It sees；And read next title in the summary table of the database；
Secondary reading unit, if for not closed comprising described first in table corresponding to the n-th title
Keyword then reads next title in the summary table of the database.
Detailed description of the invention
Fig. 1 is the flow chart of the searching method for the table that the embodiment of the present invention one provides；
Fig. 2 is the update flow chart of database of the invention；
Fig. 3 is a kind of schematic illustration of embodiment of step S11 in Fig. 1；
Fig. 4 is a citing for relational tree in the embodiment of the present invention one；
Fig. 5 is the result schematic diagram that is scanned for using relational tree shown in Fig. 4 after user inputs third keyword；
Fig. 6 is the schematic diagram according to the corresponding cell information of nodes all on third keyword search relational tree；
Fig. 7 is the structural schematic diagram of the search platform of table provided by Embodiment 2 of the present invention.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description, it is clear that described embodiments are only a part of the embodiments of the present invention, instead of all the embodiments.It is based on
Embodiment in the present invention, it is obtained by those of ordinary skill in the art without making creative efforts every other
Embodiment shall fall within the protection scope of the present invention.
It is the flow chart of the searching method for the table that the embodiment of the present invention one provides referring to Fig. 1；A kind of searcher of table
Method, comprising:
S11, it is searched in the table of database according to the first keyword and a line of first Keywords matching or more
Row data；Wherein, the database purchase multiple tables, each table includes multirow data；
S12, first unit lattice information is extracted from a line or multirow data with first Keywords matching as the
Two keywords；
S13, it is searched in the table of the database according to second keyword and second Keywords matching
A line or multirow data.
A kind of configuration method of preferred database is provided below, comprising:
Read the original form document that user uploads；It wherein, include multiple original tables in the original form document, it is each
The original table includes multiple sublists；
The title of all original tables and the title of the sublist are read, generates and records title and form serial number
Summary table；
All data in each sublist are read, table corresponding with each sublist is automatically created；
The summary table and the table corresponding with each sublist are added into the database.
The form document of user's local computer can all be imported database by the configuration method of above-mentioned database.First read
The title of original table and the title of sublist are taken, specifically, original table can be Excel table one by one, and sublist is then in Excel table
Sheet；According to Excel table name, sheet generation summary tables, every row records the sheet name of each Excel table in summary table, each
One table serial number of sheet correspondences, such as the third line secondary series, table serial number B3；Summary table can play the role of index, be convenient for logarithm
According to the search of all tables in library.It is successively read the data class of the gauge outfit, each column of every sheet in original form document again
Type, wherein gauge outfit corresponds to information type of the invention, is documented in the first row of every sheet, to pull in former sheet table
All data, including information type, each unit lattice information corresponding with information type are loaded into table in the database
Lattice.
It further, referring to fig. 2, is the update flow chart of database of the invention；The update of database is by platform timing
Table SVN warehouse information is pulled, it is automatic to read SVN change record when form document has new submission, to modification in summary table
(comprising increased), the table deleted be marked respectively, then the corresponding table of tab file is accordingly grasped
Make --- it is loaded into or deletes again.Since the prior art pulls form document on search platform server, by form document one
Secondary property all reads in memory, and subsequent inquiry operation all carries out in memory, if form document is more, can occupy more
Memory source has higher requirement to server performance, and each any table has modification, requires manual operation and updates memory number
According to, and the data in memory require all to be loaded into one time again, rather than modification file is pointedly only imported again.This
A little problems lead to portable poor, the low efficiency of existing search platform.And the present invention utilizes the table characteristic of form document, it will be literary
For number of packages according to all importeding into database, the submission record timing further according to SVN is updated the table content of variation.It reduces
Data maintenance cost, improves search efficiency.
It is a kind of schematic illustration of embodiment of step S11 referring to Fig. 3；Step S11, described crucial according to first
Word is searched and a line or multirow data of first Keywords matching in the table of database, comprising:
N-th title is read from the summary table of the database；
The search of the first keyword is carried out in the table corresponding to n-th title；
If in table corresponding to the n-th title including first keyword, to described in user's output
First keyword all data of the row and the title of the n-th table are checked for user；And read the number
According to next title in the summary table in library；
If not reading the number comprising first keyword in table corresponding to the n-th title
According to next title in the summary table in library.
Generally, search platform includes the server-side and database of the front end interacted with user, the above-mentioned searching method of execution,
Platform service end successively scans for each table according to summary table record, returns the result if inquiring keyword.It is looking into
There is interaction with front end during inquiry, realizes the inquiry and display pattern of repeatedly request, asynchronous load.This implementation improves
User experience, in face of the search of mass data table, user can see first query result in front end in 1-2s, substantially
Reduce the waiting time of user.And continue to inquire remaining table and return knot while user checks existing result
Fruit improves platform response efficiency.In addition, the identical form with form document can be used to the display of row data in front end, symbol
Share the use habit at family.Target data is positioned in order to facilitate user, keyword can also be dyed.
Be specifically described below it is that step S11~S13 is played the utility model has the advantages that
Step S11~S13 obtains with the part of the first Keywords matching including destination-related information by first time search
Data, the result searched for later using first time is as the second keyword, using the second keyword with other comprising being associated with
Incidence relation between the table of information executes binary search, gets more fully target data, while improving operational
More flexible, raising search efficiency is searched in intelligence.
For example, in game plan table, be related to game item planning table often have it is multiple.For example it is directly used in record road
The stage property tables of data of tool number, title and silver coin price is further related to since game item can sell in gaming, auction
The store commodity list of goods number and commodity price is recorded, and records auction room's allocation list of Item Number and gold coin official price.
The method for obtaining destination-related information is scanned for single keyword using the prior art, aqueduct, which is signed, to be claimed, such as " rice-pudding
Leaf " is only capable of searching the content in the stage property tables of data for containing stage property title " rice-pudding leaf ", number 001 and silver including rice-pudding leaf
Coin price 800, and due to not being related to stage property title in store commodity list and auction room's allocation list, it cannot be searched.And
Using the searching method of table provided by the invention, obtained and the matched rice-pudding leaf number of rice-pudding leaf and silver coin by search for the first time
After price, with one of information, such as the number 001 of rice-pudding leaf, as the second keyword, can search in the commodity list of store with
It is relevant to Item Number 001 in the commodity price and auction room's allocation list of the relevant information of goods number 001 --- rice-pudding leaf
The gold coin official price of information --- rice-pudding leaf.
It should be noted that in the present invention, the structure of table is illustrated with the words such as " row ", " column ", merely to description side
Just, the arrangement mode description to table generally used using those skilled in the art are met, it should be appreciated that in planning table knot
The arrangement of " row ", " column " can be rearranged in structure, for example is turned, and the present invention is not defined the arrangement of table.
In the present invention, according to the use habit of those skilled in the art, table includes multirow data, and wherein each row data recordation is each
The information of project includes multiple cell information, Mei Yidan in data line since each project has different information
Column where first lattice record a kind of data of information type.By taking game plan table as an example, such as in stage property tables of data, Mei Gexiang
Mesh refers to every kind of stage property, and information type refers to number and title.After being scanned for the first keyword " rice-pudding leaf ", if there is multirow rice-pudding leaf
Data, such as rice-pudding leaf 1, rice-pudding leaf 2 and rice-pudding leaf 3 then extract a cell information, the cell information pair in multirow data
A kind of information type is answered, using across the table relation of equality of the information type and the information type of other tables, searches for more numbers
According to.
Specifically, " first unit lattice information is extracted from a line or multirow data with first Keywords matching " to wrap
Including and extracting a cell information flag from a line or multirow data with first Keywords matching is first unit lattice
Information, or two or more cell information are extracted from a line or multirow data with first Keywords matching,
And wherein each cell information is marked as lattice information；For extracting two or more cell information flags
The case where for first unit lattice information, using each first unit lattice information as the second keyword, execute search with it is described
The step of a line or multirow data of second Keywords matching；
In addition, " first unit lattice information is extracted from a line or multirow data with first Keywords matching ", it can
With there are many embodiments, for example extracted in a manner of preset algorithm: according to historical data, platform automatic identification is retrieved
The most one or more cell information of across table relation of equality are as first unit lattice information in multirow data；Either export
The multirow data of the title and table that search are checked for user, extract first unit lattice information with being selected as user
Criterion.
I.e. further, it is single that first is extracted step S12, from a line or multirow data with first Keywords matching
First lattice information is specifically included as the second keyword:
Receive the binary search instruction of user；Wherein, the binary search instruction includes selection instruction, the selection instruction
For selecting a cell information from described a line or multirow data with first Keywords matching；
Marking cell information corresponding to the selection instruction is first unit lattice information, and by the first unit lattice
Information is as the second keyword.
In order to improve search efficiency, user can also increase information and reduce search range when selecting first unit lattice information,
That is it step S13, is searched in the table of the database according to second keyword and the one of second Keywords matching
Capable or multirow data, specifically include:
It whether identifies in the binary search instruction comprising the 4th keyword；
If including the 4th keyword in the binary search instruction, according to the 4th keyword in the database
A line or multirow data with second Keywords matching are searched in partial table；Wherein, the partial table is list name
It include the table of the 4th keyword in title；
If not comprising the 4th keyword in the binary search instruction, according to second keyword in the data
A line or multirow data with second Keywords matching are searched in all forms in library.
Further, in step S13, searched in the table of the database according to second keyword and described the
After a line or multirow data of two Keywords matchings, further includes:
S14, one or more second unit lattice are extracted from a line or multirow data with second Keywords matching
Information；
S15, table set of relationship is established；Wherein, the table set of relationship includes first information type and the second information type
Same table incidence relation, the second information type and third information type across table relation of equality and third information type and the 4th
The same table incidence relation of information type；The first information type is to be located at the same table with the first unit lattice information
Information type belonging to first keyword, second information type are information type belonging to the first unit lattice information,
The third information type is to be located at info class belonging to the second keyword of the same table with the second unit lattice information
Type, the 4th information type are information type belonging to the second unit lattice information；
S16, the relational tree for establishing the information type that the table set of relationship is related to, and the relational tree is stored in described
In database；
S17, the relational tree look-up command inputted according to user, call the relational tree look-up command from the database
Corresponding relational tree meets the search result of the relational tree look-up command according to relational tree output.
In further scheme, according to the table incidence relation used when searching for twice, table set of relationship, Jin Erjian are established
Vertical relational tree, this relational tree have clearly reproduced the process manually tabled look-up, it is shown that the incidence relation between multilist, subsequent
Search in, can realize the richer searching method for meeting user demand with call relation tree.Generally, the foundation of relational tree
DFS (Depth First Search, depth-first search) algorithm can be used to realize.
It referring to fig. 4, is a citing for relational tree in the embodiment of the present invention one；After inputting the first keyword " rice-pudding leaf ",
It is obtained after fixing a price with the matched number of rice-pudding leaf and silver coin by first time search, with one of information, such as the number of rice-pudding leaf
001, as the second keyword, the silver coin price in stage property tables of data can be searched again for, can also be searched in the commodity list of store
It is related with Item Number 001 in the commodity price and auction room's allocation list of information relevant to goods number 001 --- rice-pudding leaf
Information --- the gold coin official price of rice-pudding leaf.In this process:
A, at the data of the same a line found with the first keyword, each cell information and other cell information
In same planning table, have each other with table incidence relation；Wherein, information type belonging to the first keyword and first has been used
Information type belonging to cell information is closed with table incidence relation, the i.e. same table of stage property title and number in stage property tables of data
Connection relationship；
B, according to first unit lattice the second keyword of information acquisition, search obtains containing the multirow number of the second keyword
According to, necessarily include multiple cell information with the second Keywords matching in multirow data, these matched cell information with
The affiliated information type of first unit lattice information is equal, has across table relation of equality；Wherein, it has used belonging to first unit lattice information
Information type, and between information type belonging to the second keyword for going together with the subsequent second unit lattice information being extracted
Across table relation of equality；Number i.e. in stage property tables of data and across the table relation of equality between the goods number of store commodity list,
And across the table relation of equality numbered between the Item Number of auction room's allocation list in stage property tables of data；
C, in the multirow data for the second keyword that search obtains, in addition to the cell information with the second Keywords matching
Outside, there are also other cell information gone together with the second keyword, these cell information are extracted through screening, are second unit lattice
Information belongs to same table incidence relation with the second keyword gone together；Goods number and commodity price i.e. in the commodity list of store are clapped
Sell the Item Number and gold coin official price in row allocation list.
D, according to first unit lattice the second keyword of information acquisition, search obtains containing the multirow number of the second keyword
According to necessarily including other cell information gone together with the second keyword, the first keyword, such as stage property data in multirow data
Silver coin price in table, this silver coin price and number are same table incidence relation.
According to above-mentioned table relationship, relational tree as shown in Figure 4 can be established.Deep search is executed using relational tree.Below
Specifically tell about a variety of application schemes of relational tree:
(1) step S15, it is described establish table set of relationship after, further includes: according to the table set of relationship create indicate
The customized label of the 4th information type as described in the first information type queries；
Step S17, the described relational tree look-up command inputted according to user, calls the relational tree from the database
Relational tree corresponding to look-up command meets the search result of the relational tree look-up command, tool according to relational tree output
Body includes:
The customized label being easily selected by a user is identified from the relational tree look-up command that user inputs；
Relational tree corresponding to the customized label being easily selected by a user is called from the database, and exports the relationship
Tree checks for user.
The program is an application scheme for relational tree, and search platform is table set of relationship after establishing table set of relationship
Customized label is created, as relational tree is configured with customized label, and customized label is searched for for user, selected, and works as user
After having selected customized label, relevant relational tree can be shown.Facilitate user to check table relational structure, improves what planning was filled in a form
Working efficiency.
(2) step S15, it is described establish table set of relationship after, further includes: according to the table set of relationship create indicate
The customized label of the 4th information type as described in the first information type queries；
Step S17, the relational tree look-up command inputted according to user calls the relational tree to search from the database
The corresponding relational tree of instruction meets the search result of the relational tree look-up command according to relational tree output, comprising:
The customized label being easily selected by a user is identified from the relational tree look-up command that user inputs；
Relational tree corresponding to the customized label being easily selected by a user is called from the database, and exports the relationship
Tree checks for user；
The third keyword of user's input is received, it is corresponding using the root node of third keyword as the relational tree
Cell information；
Tree automatically generates query statement according to the relationships；
It is scanned in the database using the query statement, it is right respectively to obtain all nodes in the relational tree
The cell information answered, and the relational tree of output token all nodes corresponding cell information checks for user.
The program is another application scheme of relational tree, after user has selected customized label, can show correlation
Relational tree.As shown in figure 5, Fig. 5 is the knot that is scanned for using relational tree shown in Fig. 4 after user inputs third keyword
Fruit.When user proposes third keyword " rice-pudding leaf ", i.e., the corresponding cell information of the root node in relational tree is " rice-pudding leaf ", search
Platform can automatically generate query statement and carry out global search, show the corresponding cell information of all nodes on relational tree, return
All target datas associated with the cell information are returned, the efficiency of search and comprehensive is substantially increased.Specific search
Method is as shown in Figure 6.Wherein, query statement can be SQL query statement；When user selectes the occurrence an of root node as pass
When key word, on the basis of DFS algorithm forms relational tree, same to table, across table SQL query statement are automatically generated, in table database
In scan for, then continue pop down recursive lookup when there is result return, until inquiring all target informations.
(3) step S15, it is described establish table set of relationship after, further includes: according to the table set of relationship create indicate
The customized label of the 4th information type as described in the first information type queries；
The relational tree look-up command is natural language sentence；
Then step S17, the relational tree look-up command inputted according to user, call the relational tree to look into from the database
The relational tree for looking for instruction corresponding meets the search result of the relational tree look-up command according to relational tree output, comprising:
The customized label being easily selected by a user is identified from the relational tree look-up command that user inputs；
Relational tree corresponding to the customized label being easily selected by a user is called from the database, and exports the relationship
Tree checks for user；
The third keyword of user's input is received, it is corresponding using the root node of third keyword as the relational tree
Cell information；
Tree automatically generates query statement according to the relationships；
It is scanned in the database using the query statement, it is right respectively to obtain all nodes in the relational tree
The cell information answered, and the relational tree of output token all nodes corresponding cell information checks for user.
Wherein, described " identifying the customized label being easily selected by a user from the relational tree look-up command that user inputs ",
It specifically includes:
The natural language sentence that user inputs is handled by segmentation methods, obtains multiple phrases；
The multiple phrase is referred to the customized label with the multiple phrase matching by subsumption algorithm；
Extracting the customized label with the multiple phrase matching is the customized label being easily selected by a user.
The program is another application scheme of relational tree, after user has selected customized label, can show correlation
Relational tree.And since the relationship between information type is clearly marked in customized label, user can be with natural language
Speech sentence scans for target data.For example, user will check " price of stage property rice-pudding leaf is how many ", by segmenting and sorting out calculation
Method can get label " by stage property name query price ", can search corresponding with label " by stage property name query price "
Relational tree；Further, it also may recognize that third keyword " rice-pudding leaf ".It is more square using natural language sentence data search target data
Just user searches for.
In conclusion the embodiment of the present invention one is effectively simplified table relationship configuration flow, manually matched by traditional administrator
The configuration mode for becoming automatically saving table relationship in search process is set, relational tree is shown to user, reduces search process, it is real
Show table relationship to automatically generate.And search step is simplified, table relationship allocative efficiency is improved, also reduces the configuration of table relationship
Error rate；It provide the user the approach that inquiry, iterative modifications query configuration are custom-configured according to respective demand simultaneously, it is full
The demand of same keyword different target data, user only need to stick to different inquiry targets during foot is actually tabled look-up
Different labels can save personalized query configuration, can call directly in subsequent inquiry.
The searching method of table provided in an embodiment of the present invention is obtained and the first Keywords matching by first time search
Part includes the data of destination-related information, later using the result that first time searches for as the second keyword, utilizes the second key
Word and other include the incidence relation between the table of related information, execute binary search, get more fully target
Data, while operational intelligence is improved, search for more flexible, raising search efficiency.
It is the structural schematic diagram of the search platform of table provided by Embodiment 2 of the present invention referring to Fig. 7, comprising:
First searching module 71, for being searched in the table of database according to the first keyword and first keyword
Matched a line or multirow data；Wherein, the database purchase multiple tables, each table includes multirow data；
Further, described search platform further include:
Set establishes module 75, for establishing table set of relationship；Wherein, the table set of relationship includes first information type
With across the table relation of equality and third of the same table incidence relation of the second information type, the second information type and third information type
The same table incidence relation of information type and the 4th information type；The first information type be and the first unit lattice information bit
The information type belonging to the first keyword of the same table, second information type are first unit lattice information institute
The information type of category, the third information type are the second keyword for being located at the same table with the second unit lattice information
Affiliated information type, the 4th information type are information type belonging to the second unit lattice information；
Relational tree establishes module 76, for establishing the relational tree for the information type that the table set of relationship is related to, and by institute
Relational tree is stated to be stored in the database；
Further, described search platform further includes tag creation module, for it is described establish table set of relationship after,
The customized label for indicating the 4th information type as described in the first information type queries is created according to the table set of relationship；
Then the deep search module includes:
First recognition unit, for identified from the relational tree look-up command that user inputs be easily selected by a user it is customized
Label；
First output unit, for calling relationship corresponding to the customized label being easily selected by a user from the database
Tree, and export the relational tree and checked for user.
Further, the deep search module, further includes:
Second recognition unit, for receiving the third keyword of user's input, using the third keyword as the pass
It is the corresponding cell information of root node of tree；
Sentence generation unit automatically generates query statement for setting according to the relationships；
Second output unit obtains the relationship for scanning in the database using the query statement
The corresponding cell information of all nodes in tree, and the output token relational tree of the corresponding cell information of all nodes
It is checked for user.
Further, the relational tree look-up command is natural language sentence；
First recognition unit includes:
Participle subelement is obtained for being handled by segmentation methods the natural language sentence that user inputs
Multiple phrases；
Sort out subelement, for by subsumption algorithm by the multiple phrase be referred to the multiple phrase matching oneself
Define label；
Tag extraction subelement is to be easily selected by a user for extracting the customized label with the multiple phrase matching
Customized label.
Further, which is characterized in that first extraction module includes:
Receiving unit, the binary search for receiving user instruct；Wherein, the binary search instruction includes that selection refers to
It enables, the selection instruction is used to select a cell from described a line or multirow data with first Keywords matching
Information；
Marking unit is first unit lattice information for marking cell information corresponding to the selection instruction, and will
The first unit lattice information is as the second keyword；
Then second searching module includes:
Whether third recognition unit includes for identification the 4th keyword in the binary search instruction；
First search unit, if being closed for including the 4th keyword in binary search instruction according to the described 4th
Keyword is searched and a line or multirow data of second Keywords matching in the partial table of the database；Wherein, institute
State partial table be title in include the 4th keyword table；
Second search unit, if in binary search instruction not comprising the 4th keyword, according to described the
Two keywords are searched and a line or multirow data of second Keywords matching in all forms of the database.
Further, which is characterized in that the configuration method of the database includes:
Read the original form document that user uploads；It wherein, include multiple original tables in the original form document, it is each
The original table includes multiple sublists；
The title of all original tables and the title of the sublist are read, generates and records title and form serial number
Summary table；
All data in each sublist are read, table corresponding with each sublist is automatically created；
The summary table and the table corresponding with each sublist are added into the database；
Then first searching module includes:
Reading unit, for reading n-th title from the summary table of the database；
Third search unit, for carrying out the search of the first keyword in the table corresponding to n-th title；
Asynchronous loading unit, if for including first keyword in table corresponding to the n-th title,
Then looked into the title that user exports first keyword all data of the row and the n-th table for user
It sees；And read next title in the summary table of the database；
Secondary reading unit, if for not closed comprising described first in table corresponding to the n-th title
Keyword then reads next title in the summary table of the database.
The search platform of table provided in an embodiment of the present invention is obtained and the first Keywords matching by first time search
Part includes the data of destination-related information, later using the result that first time searches for as the second keyword, utilizes the second key
Word and other include the incidence relation between the table of related information, execute binary search, get more fully target
Data, while operational intelligence is improved, search for more flexible, raising search efficiency.
It is the preferred embodiment of the present invention above, it is noted that for those skilled in the art,
Without departing from the principle of the present invention, several improvement and deformations can also be made, these improvement and deformations are also considered as this hair
Bright protection scope.
Claims (12)
1. a kind of searching method of table characterized by comprising
It is searched in the table of database according to the first keyword and a line or multirow data of first Keywords matching；Its
In, the database purchase multiple tables, each table include multirow data；
First unit lattice information is extracted from a line or multirow data with first Keywords matching as the second keyword；
It is searched in the table of the database according to second keyword and a line of second Keywords matching or more
Row data；
One or more second unit lattice information are extracted from a line or multirow data with second Keywords matching；
Establish table set of relationship；Wherein, the table set of relationship includes the same table pass of first information type and the second information type
Connection relationship, across the table relation of equality of the second information type and third information type and third information type and the 4th information type
Same table incidence relation；The first information type is to be located at the first key of the same table with the first unit lattice information
Information type belonging to word, second information type are information type belonging to the first unit lattice information, the third
Information type is to be located at information type belonging to the second keyword of the same table with the second unit lattice information, described the
Four information types are information type belonging to the second unit lattice information；
The relational tree for the information type that the table set of relationship is related to is established, and the relational tree is stored in the database
In；
According to the relational tree look-up command that user inputs, called corresponding to the relational tree look-up command from the database
Relational tree meets the search result of the relational tree look-up command according to relational tree output.
2. searching method as described in claim 1, which is characterized in that it is described establish table set of relationship after, further includes: press
The customized label for indicating the 4th information type as described in the first information type queries is created according to the table set of relationship；
The then relational tree look-up command inputted according to user, calls the relational tree look-up command institute from the database
Corresponding relational tree meets the search result of the relational tree look-up command according to relational tree output, specifically includes:
The customized label being easily selected by a user is identified from the relational tree look-up command that user inputs；
Relational tree corresponding to the customized label being easily selected by a user is called from the database, and is exported the relational tree and supplied
User checks.
3. searching method as claimed in claim 2, which is characterized in that the relational tree look-up command inputted according to user,
Relational tree corresponding to the relational tree look-up command is called from the database, is met according to relational tree output described
The search result of relational tree look-up command, further includes:
The third keyword for receiving user's input, using the corresponding unit of root node of third keyword as the relational tree
Lattice information；
Tree automatically generates query statement according to the relationships；
It is scanned in the database using the query statement, it is corresponding to obtain all nodes in the relational tree
Cell information, and the relational tree of output token all nodes corresponding cell information checks for user.
4. searching method as claimed in claim 2 or claim 3, which is characterized in that the relational tree look-up command is natural language language
Sentence；
It is described to identify the customized label being easily selected by a user from the relational tree look-up command that user inputs, it specifically includes:
The natural language sentence that user inputs is handled by segmentation methods, obtains multiple phrases；
The multiple phrase is referred to the customized label with the multiple phrase matching by subsumption algorithm；
Extracting the customized label with the multiple phrase matching is the customized label being easily selected by a user.
5. searching method as described in any one of claims 1 to 3, which is characterized in that it is described from first keyword
First unit lattice information is extracted in a line or multirow data matched as the second keyword, is specifically included:
Receive the binary search instruction of user；Wherein, the binary search instruction includes selection instruction, and the selection instruction is used for
A cell information is selected from described a line or multirow data with first Keywords matching；
Marking cell information corresponding to the selection instruction is first unit lattice information, and by the first unit lattice information
As the second keyword；
Then one searched in the table of the database according to second keyword with second Keywords matching
Capable or multirow data, specifically include:
It whether identifies in the binary search instruction comprising the 4th keyword；
If including the 4th keyword in the binary search instruction, according to the 4th keyword in the part of the database
A line or multirow data with second Keywords matching are searched in table；Wherein, the partial table is in title
It include the table of the 4th keyword；
If not comprising the 4th keyword in the binary search instruction, according to second keyword in the database
A line or multirow data with second Keywords matching are searched in all forms.
6. searching method as described in any one of claims 1 to 3, which is characterized in that the configuration method of the database includes:
Read the original form document that user uploads；It wherein, include multiple original tables in the original form document, it is each described
Original table includes multiple sublists；
It reads the title of all original tables and the title of the sublist, generates and record the total of title and form serial number
Table；
All data in each sublist are read, table corresponding with each sublist is automatically created；
The summary table and the table corresponding with each sublist are added into the database；
It is then described to be searched in the table of database according to the first keyword and a line or multirow of first Keywords matching
Data, comprising:
N-th title is read from the summary table of the database；
The search of the first keyword is carried out in the table corresponding to n-th title；
If in table corresponding to the n-th title including first keyword, to user's output described first
Keyword all data of the row and the title of the n-th table are checked for user；And read the database
Summary table in next title；
If not reading the database comprising first keyword in table corresponding to the n-th title
Summary table in next title.
7. a kind of search platform of table characterized by comprising
First searching module, for being searched in the table of database according to the first keyword and first Keywords matching
A line or multirow data；Wherein, the database purchase multiple tables, each table includes multirow data；
First extraction module, for extracting first unit lattice letter from a line or multirow data with first Keywords matching
Breath is used as the second keyword；
Second searching module, for being searched in the table of the database according to second keyword and second key
The matched a line of word or multirow data；
Second extraction module, for extracting one or more the from a line or multirow data with second Keywords matching
Two cell information；
Set establishes module, for establishing table set of relationship；Wherein, the table set of relationship includes first information type and second
Across the table relation of equality and third info class of the same table incidence relation of information type, the second information type and third information type
The same table incidence relation of type and the 4th information type；The first information type is with the first unit lattice information positioned at same
Information type belonging to first keyword of a table, second information type are letter belonging to the first unit lattice information
Type is ceased, the third information type is to be located at belonging to the second keyword of the same table with the second unit lattice information
Information type, the 4th information type are information type belonging to the second unit lattice information；
Relational tree establishes module, for establishing the relational tree for the information type that the table set of relationship is related to, and by the relationship
Tree is stored in the database；
Deep search module, the relational tree look-up command for being inputted according to user, calls the relationship from the database
Relational tree corresponding to look-up command is set, the search result of the relational tree look-up command is met according to relational tree output.
8. search platform as claimed in claim 7, which is characterized in that described search platform further includes tag creation module, is used
In it is described establish table set of relationship after, according to the table set of relationship creation indicate by the first information type queries institute
State the customized label of the 4th information type；
Then the deep search module includes:
First recognition unit, for identifying the customized mark being easily selected by a user from the relational tree look-up command that user inputs
Label；
First output unit, for calling relational tree corresponding to the customized label being easily selected by a user from the database,
And it exports the relational tree and is checked for user.
9. search platform as claimed in claim 8, which is characterized in that the deep search module, further includes:
Second recognition unit, for receiving the third keyword of user's input, using the third keyword as the relational tree
The corresponding cell information of root node；
Sentence generation unit automatically generates query statement for setting according to the relationships；
Second output unit is obtained in the relational tree for being scanned in the database using the query statement
All nodes corresponding cell information, and the relational tree of the output token corresponding cell information of all nodes for
Family is checked.
10. search platform as claimed in claim 8 or 9, which is characterized in that the relational tree look-up command is natural language language
Sentence；
First recognition unit includes:
Participle subelement obtains multiple for being handled by segmentation methods the natural language sentence that user inputs
Phrase；
Sort out subelement, it is customized with the multiple phrase matching for being referred to the multiple phrase by subsumption algorithm
Label；
Tag extraction subelement is oneself being easily selected by a user for extracting the customized label with the multiple phrase matching
Define label.
11. such as the described in any item search platforms of claim 7 to 9, which is characterized in that first extraction module includes:
Receiving unit, the binary search for receiving user instruct；Wherein, the binary search instruction includes selection instruction, institute
Selection instruction is stated for selecting a cell information from described a line or multirow data with first Keywords matching；
Marking unit is first unit lattice information for marking cell information corresponding to the selection instruction, and will be described
First unit lattice information is as the second keyword；
Then second searching module includes:
Whether third recognition unit includes for identification the 4th keyword in the binary search instruction；
First search unit, if for including the 4th keyword in binary search instruction, according to the 4th keyword
A line or multirow data with second Keywords matching are searched in the partial table of the database；Wherein, the portion
Point table is in title include the 4th keyword table；
Second search unit, if for, not comprising the 4th keyword, being closed according to described second in binary search instruction
Keyword is searched and a line or multirow data of second Keywords matching in all forms of the database.
12. such as the described in any item search platforms of claim 7 to 9, which is characterized in that the configuration method packet of the database
It includes:
Read the original form document that user uploads；It wherein, include multiple original tables in the original form document, it is each described
Original table includes multiple sublists；
It reads the title of all original tables and the title of the sublist, generates and record the total of title and form serial number
Table；
All data in each sublist are read, table corresponding with each sublist is automatically created；
The summary table and the table corresponding with each sublist are added into the database；
Then first searching module includes:
Reading unit, for reading n-th title from the summary table of the database；
Third search unit, for carrying out the search of the first keyword in the table corresponding to n-th title；
Asynchronous loading unit, if for including first keyword in table corresponding to the n-th title, to
User exports first keyword all data of the row and the title of the n-th table is checked for user；
And read next title in the summary table of the database；
Secondary reading unit, if in table corresponding to the n-th title not comprising first keyword,
Then read next title in the summary table of the database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710046729.6A CN106874411B (en) | 2017-01-22 | 2017-01-22 | A kind of searching method and search platform of table |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710046729.6A CN106874411B (en) | 2017-01-22 | 2017-01-22 | A kind of searching method and search platform of table |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106874411A CN106874411A (en) | 2017-06-20 |
| CN106874411B true CN106874411B (en) | 2019-10-15 |
Family
ID=59157982
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710046729.6A Active CN106874411B (en) | 2017-01-22 | 2017-01-22 | A kind of searching method and search platform of table |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106874411B (en) |
Families Citing this family (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110019307B (en) * | 2017-12-28 | 2023-09-01 | 阿里巴巴集团控股有限公司 | Data processing method and device |
| CN108228898A (en) * | 2018-02-06 | 2018-06-29 | 广州市西美信息科技有限公司 | Searching method, device and the server of customs's data |
| CN108553901A (en) * | 2018-03-28 | 2018-09-21 | 沈宝亮 | A method of being established based on UE engines has the warehouse of search and collection function |
| CN109359275B (en) * | 2018-09-20 | 2021-10-29 | 郑州云海信息技术有限公司 | Data conversion method and device |
| CN109670028A (en) * | 2018-12-27 | 2019-04-23 | 天津字节跳动科技有限公司 | Table search method and device in online document |
| CN110489423B (en) * | 2019-08-26 | 2021-10-08 | 北京香侬慧语科技有限责任公司 | Information extraction method and device, storage medium and electronic equipment |
| CN110866042B (en) * | 2019-10-11 | 2023-05-12 | 平安科技（深圳）有限公司 | Intelligent query method and device for table and computer readable storage medium |
| CN113779058B (en) * | 2020-10-16 | 2024-06-14 | 北京京东振世信息技术有限公司 | Method, apparatus, device and computer readable medium for obtaining service data |
| CN116737777B (en) * | 2023-08-16 | 2023-11-28 | 北京壁仞科技开发有限公司 | Method, computing device and computer readable storage medium for searching for target operators |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101963977A (en) * | 2010-09-19 | 2011-02-02 | 北京腾瑞万里科技有限公司 | A search method and mobile terminal without urban search |
| CN104778176A (en) * | 2014-01-13 | 2015-07-15 | 阿里巴巴集团控股有限公司 | Data search processing method and device |
| CN105378724A (en) * | 2014-06-10 | 2016-03-02 | 华为技术有限公司 | Data query method, device and system |
| CN106095948A (en) * | 2016-06-13 | 2016-11-09 | 网易（杭州）网络有限公司 | The querying method of form, device and equipment |
-
2017
- 2017-01-22 CN CN201710046729.6A patent/CN106874411B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101963977A (en) * | 2010-09-19 | 2011-02-02 | 北京腾瑞万里科技有限公司 | A search method and mobile terminal without urban search |
| CN104778176A (en) * | 2014-01-13 | 2015-07-15 | 阿里巴巴集团控股有限公司 | Data search processing method and device |
| CN105378724A (en) * | 2014-06-10 | 2016-03-02 | 华为技术有限公司 | Data query method, device and system |
| CN106095948A (en) * | 2016-06-13 | 2016-11-09 | 网易（杭州）网络有限公司 | The querying method of form, device and equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106874411A (en) | 2017-06-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106874411B (en) | A kind of searching method and search platform of table | |
| CN104331449B (en) | Query statement and determination method, device, terminal and the server of webpage similarity | |
| US8185509B2 (en) | Association of semantic objects with linguistic entity categories | |
| CN103314371B (en) | A kind of method and system of retrieval | |
| CN105975531B (en) | Robot dialog control method and system based on dialogue knowledge base | |
| CA2836220C (en) | Methods and systems for matching records and normalizing names | |
| CN101167075B (en) | Characteristic expression extracting device, method, and program | |
| EP1875388B1 (en) | Classification dictionary updating apparatus, computer program product therefor and method of updating classification dictionary | |
| US20210018332A1 (en) | Poi name matching method, apparatus, device and storage medium | |
| CN102982076A (en) | Multi-dimensionality content labeling method based on semanteme label database | |
| CN107798123B (en) | Knowledge base and establishing, modifying and intelligent question and answer methods, devices and equipment thereof | |
| JP5410514B2 (en) | Method for mapping an X500 data model to a relational database | |
| CN103440232A (en) | Automatic sScientific paper standardization automatic detecting and editing method | |
| CN109447266A (en) | A kind of agricultural science and technology service intelligent sorting method based on big data | |
| CN103440233A (en) | Automatic sScientific paper standardization automatic detecting and editing system | |
| CN110008309A (en) | A kind of short phrase picking method and device | |
| CN109582831A (en) | A kind of chart database management system for supporting unstructured data storage and inquiry | |
| CN104391969B (en) | Determine the method and device of user's query statement syntactic structure | |
| CN112632239A (en) | Brain-like question-answering system based on artificial intelligence technology | |
| CN117290376A (en) | Two-stage Text2SQL model, method and system based on large language model | |
| CN112989811B (en) | History book reading auxiliary system based on BiLSTM-CRF and control method thereof | |
| CN115329753B (en) | Intelligent data analysis method and system based on natural language processing | |
| CN108628631B (en) | The method that abbreviation in a kind of pair of parameter is extended automatically | |
| CN116049376A (en) | Method, device and system for retrieving and replying information and creating knowledge | |
| JPH08305724A (en) | Device for managing design supporting information document |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |