CN106547843A - Multiclass classification querying method and device - Google Patents
Multiclass classification querying method and device Download PDFInfo
- Publication number
- CN106547843A CN106547843A CN201610900239.3A CN201610900239A CN106547843A CN 106547843 A CN106547843 A CN 106547843A CN 201610900239 A CN201610900239 A CN 201610900239A CN 106547843 A CN106547843 A CN 106547843A
- Authority
- CN
- China
- Prior art keywords
- product
- item name
- classification
- inquiry request
- category
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
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/2453—Query optimisation
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to a kind of multiclass classification querying method and device, methods described includes：The inquiry request that receiving terminal sends, carries item name in the inquiry request；Product table is obtained according to the inquiry request, the product table includes item name, and the item name includes multiple ranks；Inquired about in the product table according to the item name carried in the inquiry request, obtained the product information of the product information and subclass of respective classes；The multiple product informations for inquiring are back to into terminal, so that terminal is shown.Query time can effectively be reduced using this method and improve search efficiency.
Description
Technical field
The present invention relates to field of computer technology, more particularly to a kind of multiclass classification querying method and device.
Background technology
With the development of computer technology, digital information is presented explosive growth.In the face of the digital information of magnanimity, classification is looked into
Inquiry has become a kind of effective means in digital content management.For example, it is desirable to the product information inquired about under certain classification, Ke Yitong
The mode for crossing classified inquiry can quickly obtain the category and its product information under all subclass.
In traditional mode, product information and classification information are respectively stored in the category table that product table and unlimited pole are classified
In.Product table and class table table all employ tree structure.If inquiring about the product information of certain classification and its subclass, need to close
Connection category table carries out recursive query with product table.When classification information and product information in the face of magnanimity, this traditional mode
Query time can be caused to increase, search efficiency declines.
The content of the invention
Based on this, it is necessary to for above-mentioned technical problem, there is provided one kind can effectively reduce query time and improve inquiry effect
The multiclass classification querying method of rate and device.
A kind of multiclass classification querying method, methods described include：
The inquiry request that receiving terminal sends, carries item name in the inquiry request；
Product table is obtained according to the inquiry request, the product table includes item name, and the item name includes
Multiple ranks；
Inquired about in the product table according to the item name carried in the inquiry request, obtained respective classes
The product information of product information and subclass；
The multiple product informations for inquiring are back to into terminal, so that terminal is shown.
Wherein in one embodiment, the receiving terminal send inquiry request the step of before, also include：
The product table before optimization and the category table before optimization are obtained, the product table before the optimization includes product identification,
Category table before the optimization includes classification logotype and item name；
It is associated by the product identification, classification logotype and item name, generates product category contingency table；
Item name is added to product identification in the product table before the optimization using the product category contingency table, obtained
Product table to after optimization；
The step of acquisition product table according to the inquiry request, includes：Obtained after optimization according to the inquiry request
Product table.
It is wherein in one embodiment, described to be associated by the product identification, classification logotype and item name, it is raw
The step of into product category contingency table, includes：
Extract the product identification in the product table, the classification logotype in the category table and item name；
Third party table is generated with corresponding classification logotype using the product identification；
Class Name field is generated in third party's table；
By in the Class Name field in the item name for extracting correspondence classification logotype redundancy to third party's table, produced
The other contingency table of category.
It is wherein in one embodiment, described right in the product table before the optimization using the product category contingency table
The step of product identification adds item name, product table after being optimized includes：
Multiple item names corresponding with product identification are extracted in the product category contingency table；
Classification field is generated in the product table；
The item name of multiple ranks is added into classification field corresponding with product identification, the product after being optimized
Table.
Wherein in one embodiment, the receiving terminal send inquiry request the step of before, also include：
Index file is generated according to the classification information；
It is described to be inquired about in the product table according to the item name carried in the inquiry request, obtain respective class
The step of product information of other product information and subclass, includes：
Line retrieval is entered by search engine indexed file according to the item name carried in the inquiry request, obtains many
The item name of individual rank；
Inquired about in the product table according to the item name of the index file and multiple ranks, obtained respective class
The product information of other product information and subclass.
A kind of multiclass classification inquiry unit, described device include：
Receiver module, for the inquiry request that receiving terminal sends, carries item name in the inquiry request；
Acquisition module, for obtaining product table according to the inquiry request, the product table includes item name, described
Item name includes multiple ranks；
Enquiry module, for being inquired about in the product table according to the item name carried in the inquiry request,
Obtain the product information of the product information and subclass of respective classes；
Sending module, for the multiple product informations for inquiring are back to terminal, so that terminal is shown.
Wherein in one embodiment, the acquisition module is additionally operable to obtain the product table before optimizing and the classification before optimization
Table, the product table before the optimization include product identification, and the category table before the optimization includes classification logotype and class name
Claim；
Described device also includes：
Relating module, for being associated by the product identification, classification logotype and item name, generates product category
Contingency table；
Optimization module, for being added to product identification in the product table before the optimization using the product category contingency table
Plus item name, the product table after being optimized；
The enquiry module is additionally operable to the product table after optimization is obtained according to the inquiry request.
Wherein in one embodiment, the relating module is additionally operable to extract product identification in the product table, described
Classification logotype and item name in category table；Third party table is generated with corresponding classification logotype using the product identification；
Class Name field is generated in third party's table；By the item name for extracting correspondence classification logotype redundancy into third party's table
Class Name field in, obtain product category contingency table.
Wherein in one embodiment, the optimization module is additionally operable to extract and product in the product category contingency table
Identify corresponding multiple item names；Classification field is generated in the product table；By the item name of multiple ranks add to
In classification field corresponding with product identification, the product table after being optimized.
Wherein in one embodiment, described device also includes：
Index generation module, for generating index file according to the classification information；
The enquiry module is additionally operable to according to the item name carried in the inquiry request by search engine in index
File enters line retrieval, obtains the item name of multiple ranks；According to the item name of the index file and multiple ranks in institute
Inquired about in stating product table, obtained the product information of the product information and subclass of respective classes.
Above-mentioned multiclass classification querying method and device, after the inquiry request for receiving terminal transmission, please according to inquiry
The item name of carrying is asked to be inquired about in product table.As the item name in product table includes multiple ranks, product
Table employs linear structure, thus, it is possible to soon in product table quick search goes out the product information and subclass of respective classes
Product information, effectively reduces query time and improves search efficiency.
Description of the drawings
Fig. 1 is the applied environment figure of multiclass classification querying method in one embodiment；
Fig. 2 is the flow chart of multiclass classification querying method in one embodiment；
Fig. 3 is the flow chart of multiclass classification querying method in another embodiment；
Fig. 4 is the structural representation of server in one embodiment；
Fig. 5 is the structural representation of multiclass classification inquiry unit in one embodiment；
Fig. 6 is the structural representation of multiclass classification inquiry unit in another embodiment；
Fig. 7 is the structural representation of multiclass classification inquiry unit in further embodiment.
Specific embodiment
In order that the objects, technical solutions and advantages of the present invention become more apparent, it is below in conjunction with drawings and Examples, right
The present invention is further elaborated.It should be appreciated that specific embodiment described herein is only to explain the present invention, not
For limiting the present invention.
Multiclass classification querying method provided in the embodiment of the present invention, can apply to applied environment as shown in Figure 1
In.Terminal 102 is connected with server 104 by network.Database is deployed on server 104, product in database, is stored
Table and category table.Wherein, product information is included in product table, category table includes the corresponding classification information of product information, classification
Information includes item name.Product table and category table adopt tree structure.Server 104 is by extracting the product in product table
Classification information in information and analogy table is associated, and generates product category contingency table.Server 104 is associated by product category
Table adds item name in product table, product table is optimized with this, the product table after being optimized.Product after optimization
Table adopts linear structure, and its item name includes multiple ranks.Terminal 102 sends inquiry request, inquiry request to server 104
In carry item name.Server 104 is according to carrying out in the item name carried in inquiry request product table after optimization
Inquiry, obtains the product information of the product information and subclass of respective classes, and the multiple product informations for inquiring is returned
It is back to terminal 102.Multiple product informations that 102 terminal the reception server 104 is returned, and be shown.
In one embodiment, as shown in Figure 1, there is provided a kind of multiclass classification querying method, clothes are applied in this way
Illustrate as a example by business device, specifically include：
Step 202, the inquiry request that receiving terminal sends, carries item name in inquiry request.
Terminal can send inquiry request to server by query interface.Specifically, terminal can be by browser
The query interface of display sends inquiry request to server, it is also possible to by the query interface of preassembled application rollouts
Inquiry request is sent to server.Item name is carried in inquiry request.Wherein, item name can be in advance for product point
The item name matched somebody with somebody.For example, user inquires about all of automobile on sale in certain area by terminal, and classification can be by area
Come what is distributed, such as Shenzhen.
Step 204, obtains product table according to inquiry request, and product table includes item name, and item name includes multiple
Rank.
Product table includes product information and classification information.Product information includes product identification and name of product etc..Classification
Information includes product identification correspondence item name, can include multiple ranks in item name.Wherein, subordinate's classification is properly termed as
The subclass of corresponding superclass, superclass are properly termed as the parent class of subordinate's classification, and the parent class of highest level can be with
Referred to as root classification.Item name includes that multiple ranks can include root classification, parent class and subclass and subclass
The item name of multiple ranks such as subclass.
For example, rank can be the rank of multiple administrative regions, including：Guangdong Province, Shenzhen, Nanshan District.Wherein, Guangdong
Province is properly termed as root classification, and Shenzhen is properly termed as parent class, and Nanshan District is properly termed as subclass.Multiple levels in item name
Can not be followed successively by：Guangdong Province, Shenzhen, Nanshan District.
Product identification in product table and the relation that item name can be man-to-man relation, or one-to-many,
Can also be many-to-one relation.That is, the corresponding item name of product identification can be with only one of which rank, one
The corresponding item name of product identification can also have multiple ranks, and multiple product identifications also correspond to the classification of same rank
Title.
The corresponding all of classification of the product identification is included in product table in the corresponding classification information of each product identification
Title.When item name includes multiple ranks, the item name of different stage can adopt preset characters or character string to enter
Row separates, so that the item name of multiple ranks is in linear dependence.For example, item name is administrative region, preset characters
For comma (), product table can be as shown in Table 1：
Table one：
| Sequence number | Name of product | Classification |
| 1 | Product 1 | Guangdong Province |
| 2 | Product 2 | Guangdong Province, Shenzhen |
| 3 | Product 3 | Guangdong Province, Shenzhen, Nanshan District |
| 4 | Product 4 | Guangdong Province, Shenzhen, Futian District |
Traditional product table includes product identification, name of product and classification logotype, but not including that item name.Tradition
Category table include classification logotype, item name and parent mark.Wherein, parent mark represents that the rank between classification is closed
System.Traditional product table and traditional category table adopt tree structure.Traditional product table can be traditional as shown in Table 2
Category table can be as shown in Table 3：
Table two：
| Product identification | Name of product | Classification logotype |
| 1 | Product 1 | 3 |
| 2 | Product 2 | 147 |
| 3 | Product 3 | 149 |
| 4 | Product 4 | 150 |
Table three：
| Classification logotype | Item name | Parent is identified |
| 3 | Product 1 | 0 |
| 147 | Product 2 | 3 |
| 149 | Product 3 | 147 |
| 150 | Product 4 | 147 |
As traditional product table and traditional category table employ tree structure, name of product is right with item name
Should be related to not directly perceived enough.When according to item name to inquire about corresponding name of product, need the product identification in product table
It is associated with classification logotype, is identified by way of recursive query to retrieve the class name of multiple ranks step by step according to parent
Claim, so as to inquire the product information of certain classification and its subclass according to the item name of multiple ranks in product table.By
When inquiring about to tree structure, required query statement is longer, if the data volume in product table and category table is larger,
The query performance of database can be caused to decline, query time increases.
In order to effectively overcome technical problem present in above-mentioned traditional approach, the product table in the present embodiment employs linear
Structure, product table can be directly according to linear structure come generating, or pass through transformation to traditional product table
Linear arrangement.Store as the product identification in linear structure is corresponding with item name, and it is corresponding with product identification
Item name can include multiple ranks, hence in so that product identification becomes very directly perceived with the corresponding relation of item name.And
And category table and product table need not be associated when being inquired about according to item name, directly can carry out in product table
Inquiry, not only so that query statement becomes succinct, inquiry velocity is also significantly improved.
Step 206, is inquired about in product table according to the item name carried in inquiry request, is obtained respective classes
The product information of product information and subclass.
After the inquiry request that server receiving terminal sends, product table is obtained according to inquiry request, according to inquiry request
The item name of middle carrying is inquired about in product table, obtains the product letter of the product information and subclass of respective classes
Breath.
For example, the item name for carrying in inquiry request is " Guangdong Province ", then server is being produced according to category title
Inquired about in product table, obtained the corresponding product 1 in Guangdong Province, the corresponding product 2 in Shenzhen City, Guangdong Province, Shenzhen City, Guangdong Province South Mountain
The corresponding product of the corresponding product 3 in area and Shenzhen City, Guangdong Province Futian District 4.
The multiple product informations for inquiring are back to terminal, so that terminal is shown by step 208.
The product information of the product information and subclass of the respective classes for inquiring is back to terminal by server.Terminal
These product informations are shown.Specifically, terminal can only show product information, it is also possible to show item name and product
Information.
In the present embodiment, after the inquiry request for receiving terminal transmission, according to the class name carried in inquiry request
Title is inquired about in product table.As the item name in product table includes multiple ranks, product table employs linear structure,
Thus, it is possible to soon in product table quick search goes out the product information of the product information and subclass of respective classes, effectively reduce
Query time and improve search efficiency.
In one embodiment, before the step of the inquiry request that receiving terminal sends, also include：Before obtaining optimization
Category table before product table and optimization, the product table before optimization include product identification, and the category table before optimization includes classification
Mark and item name；It is associated by product identification, classification logotype and item name, generates product category contingency table；Profit
Item name, the product table after being optimized are added to product identification with product category contingency table product table before optimization；
The step of product table is obtained according to inquiry request includes：Product table after optimization is obtained according to inquiry request.
In the present embodiment, if the product table in database uses tree structure, then receive inquiry request it
Before, server needs these are optimized using the product table of tree structure, so as to be converted to the product using linear structure
Table.Product table before optimizing is properly termed as again using the product table of tree structure.Before server obtains optimization in database
Class table table before product table and optimization.Product table before optimization includes product identification, but not including that product category.Before optimization
Category table in include classification logotype and item name.Server generates third party's table in database, in third party's table
Classification logotype and item name in category table before product identification in product table before optimization and optimization is associated,
Product category contingency table is generated from there through third party's table.Due to including item name in the product table after optimization, therefore
Server can be directly after optimization product table inquired about, and look into without the need for being associated product table with category table again
Ask, therefore server can not do similar optimization processing to category table.It is, optimization before category table and optimization after class
Other table can be identical.
In the present embodiment, the flow chart of multiclass classification querying method can be with as shown in figure 3, comprise the following steps：
Step 302, obtains the product table before optimization and the category table before optimization, and the product table before optimization includes product mark
Know, the category table before optimization includes classification logotype and item name；
Step 304, is associated by product identification, classification logotype and item name, generates product category contingency table；
Step 306, adds item name to product identification using in product category contingency table product table before optimization, obtains
Product table to after optimization；
Step 308, the inquiry request that receiving terminal sends, carries item name in inquiry request；
Step 310, obtains the product table after optimization according to inquiry request, and the product table after optimization includes item name,
Item name includes multiple ranks；
Step 312, according to being inquired about in the item name carried in inquiry request product table after optimization, obtains phase
Answer the product information of the product information and subclass of classification；
The multiple product informations for inquiring are back to terminal, so that terminal is shown by step 314.
Wherein in one embodiment, it is associated by product identification, classification logotype and item name, generates product class
The step of other contingency table, includes：Product identification, the classification logotype in category table and item name in extraction product table；Using product
Product are identified and generate third party's table with corresponding classification logotype；Class Name field is generated in third party's table；By the class extracted
In Class Name field in another name title correspondence classification logotype redundancy to third party's table, product category contingency table is obtained.
Server extracts product identification in product table, and classification logotype and item name are extracted in category table, using carrying
The product identification got and corresponding classification logotype generate third party's table in database.Server generates class in third party's table
Other name field, by the item name in the item name extracted in category table correspondence classification logotype redundancy to third party's table
In field, product type contingency table is thus obtained.
So that item name is as administrative region as an example, product type contingency table can be as shown in Table 4：
Table four：
| Sequence number | Product identification | Classification logotype | Item name |
| 1 | 1 | 3 | Guangdong Province |
| 2 | 2 | 147 | Shenzhen |
| 3 | 3 | 149 | Nanshan District |
| 4 | 4 | 150 | Futian District |
Due to product identification being associated with corresponding classification logotype and item name in product type contingency table, by
This can conveniently and efficiently extract the typonym of each rank corresponding with product identification.
Wherein in one embodiment, product identification is added using in product category contingency table product table before optimization
The step of item name, product table after being optimized, includes：Extract in product category contingency table corresponding with product identification
Multiple item names；Classification field is generated in product table；The item name of multiple ranks is added to corresponding with product identification
Classification field in, the product table after being optimized.
Due to product identification being associated with corresponding classification logotype and item name in product type contingency table, clothes
Business device can extract multiple item names corresponding with product identification in product class table contingency table.Accessed item name
Including the item name of multiple ranks.Server generates classification field in product table, by the multiple parents under same classification
The item name of other and/or multiple subclass adds into classification field corresponding with product identification successively.Specifically, for
The multiple item names extracted in product category contingency table, server according to the rank between classification, using preset characters or
Character string is separated, and the item name of multiple ranks is write into classification field corresponding with product identification.From there through
The product table of tree structure is conveniently converted to product category contingency table the product table of linear structure, is optimized then
Product table afterwards.
In one embodiment, before the step of the inquiry request that receiving terminal sends, also include：According to classification information
Generate index file；Item name according to carrying in inquiry request is inquired about in product table, obtains the product of respective classes
The step of product information of product information and subclass, includes：Search engine is passed through according to the item name carried in inquiry request
Indexed file enters line retrieval, obtains the item name of multiple ranks；Existed according to the item name of index file and multiple ranks
Inquired about in product table, obtained the product information of the product information and subclass of respective classes.
In the present embodiment, in the face of the product information and type information of magnanimity when, in order to effectively improve inquiry velocity, clothes
Business device can introduce search engine carries out retrieval and inquisition.For example, search engine can be lucene or sorl etc..Server can be with
Advance with classification information and generate index file.Specifically, server can extract classification field, classification field in product table
In include item name corresponding with product identification, wherein, multiple ranks can be included in item name.Server is to extracting
To classification field set up index file.
Server after the inquiry request for receiving terminal transmission, for the item name carried in inquiry request can be with
By entering line retrieval in search engine indexed file, the item name of corresponding multiple ranks is obtained.Using search engine
Inquired about in the product table of linear structure according to the item name of index file and multiple ranks, so as to quickly obtain multiple
Product information corresponding to the item name of rank.In the face of the product information and type information of magnanimity when, by introduce search draw
Hold up into line retrieval, inquiry velocity can be obviously improved.
In one embodiment, as shown in Figure 4, there is provided a kind of server.The server includes connecting by system bus
Processor, non-volatile memory medium, built-in storage and the network interface for connecing.Wherein, the non-volatile memories of the server are situated between
Matter is stored with operating system and multiclass classification inquiry unit.Multiclass classification inquiry unit is used to realize the one kind suitable for server
Multiclass classification querying method.The processor of the server is used to provide calculating and control ability, supports the operation of whole server.
The built-in storage of the server provides environment for the operation of the multiclass classification inquiry unit in non-volatile memory medium, the internal memory
Computer-readable instruction can be stored in reservoir, the computer-readable instruction is when executed by, and can cause computing device
A kind of multiclass classification querying method.The network interface of the server is used to communicate by network connection with outside terminal according to this,
Inquiry request that such as receiving terminal sends etc..Server can with independent server or multiple server groups into clothes
It is engaged in device cluster to realize.It will be understood by those skilled in the art that the structure illustrated in Fig. 4, only related to application scheme
Part-structure block diagram, do not constitute the restriction of the server being applied thereon to application scheme, specific server
Can include than more or less of part shown in figure, or combine some parts, or arrange with different parts.
As shown in figure 5, in one embodiment, there is provided a kind of multiclass classification inquiry unit, the device include：Receive mould
Block 502, acquisition module 504, enquiry module 506 and sending module 508, wherein：
Receiver module 502, for the inquiry request that receiving terminal sends, carries item name in inquiry request.
Acquisition module 504, for obtaining product table according to inquiry request, product table includes item name, item name
Including multiple ranks.
Enquiry module 506, for being inquired about in product table according to the item name carried in inquiry request, obtains phase
Answer the product information of the product information and subclass of classification.
Sending module 508, for the multiple product informations for inquiring are back to terminal, so that terminal is shown.
In one embodiment, the category table before product table and optimization before acquisition module 504 is additionally operable to obtain optimization, it is excellent
Product table before change includes product identification, and the category table before optimization includes classification logotype and item name；As shown in fig. 6,
The device also includes：Relating module 510 and optimization module 512, wherein：
Relating module 510, for being associated by product identification, classification logotype and item name, generates product category
Contingency table.
Optimization module 512, for using adding class to product identification in product category contingency table product table before optimization
Another name claims, the product table after being optimized.
Enquiry module 506 is additionally operable to the product table after optimization is obtained according to inquiry request.
In one embodiment, relating module 510 is additionally operable to the product identification in extraction product table, the classification in category table
Mark and item name；Third party table is generated with corresponding classification logotype using product identification；Classification is generated in third party's table
Name field；By in the Class Name field in the item name for extracting correspondence classification logotype redundancy to third party's table, obtain
Product category contingency table.
In one embodiment, optimization module 512 is additionally operable to extract corresponding with product identification in product category contingency table
Multiple item names；Classification field is generated in product table；By the item name of multiple ranks add to product identification pair
Product table in the classification field answered, after being optimized.
In one embodiment, as shown in fig. 7, the device also includes：Index generation module 514, for being believed according to classification
Breath generates index file；Enquiry module 506 is additionally operable to according to the item name carried in inquiry request by search engine in rope
Quotation part enters line retrieval, obtains the item name of multiple ranks；According to the item name of index file and multiple ranks in product
Inquired about in table, obtained the product information of the product information and subclass of respective classes.
Each technical characteristic of embodiment described above arbitrarily can be combined, to make description succinct, not to above-mentioned reality
Apply all possible combination of each technical characteristic in example to be all described, as long as however, the combination of these technical characteristics is not deposited
In contradiction, the scope of this specification record is all considered to be.
Embodiment described above only expresses the several embodiments of the present invention, and its description is more concrete and detailed, but and
Therefore can not be construed as limiting the scope of the patent.It should be pointed out that for one of ordinary skill in the art comes
Say, without departing from the inventive concept of the premise, some deformations and improvement can also be made, these belong to the protection of the present invention
Scope.Therefore, the protection domain of patent of the present invention should be defined by claims.
Claims (10)
1. a kind of multiclass classification querying method, methods described include：
The inquiry request that receiving terminal sends, carries item name in the inquiry request；
Product table is obtained according to the inquiry request, the product table includes item name, and the item name includes multiple
Rank；
Inquired about in the product table according to the item name carried in the inquiry request, obtained the product of respective classes
The product information of information and subclass；
The multiple product informations for inquiring are back to into terminal, so that terminal is shown.
2. method according to claim 1, it is characterised in that the step of the inquiry request that the receiving terminal sends it
Before, also include：
The product table before optimization and the category table before optimization are obtained, the product table before the optimization includes product identification, described
Category table before optimization includes classification logotype and item name；
It is associated by the product identification, classification logotype and item name, generates product category contingency table；
Item name is added to product identification in the product table before the optimization using the product category contingency table, obtain excellent
Product table after change；
The step of acquisition product table according to the inquiry request, includes：Product after optimization is obtained according to the inquiry request
Table.
3. method according to claim 2, it is characterised in that described by the product identification, classification logotype and classification
Title is associated, generate product category contingency table the step of include：
Extract the product identification in the product table, the classification logotype in the category table and item name；
Third party table is generated with corresponding classification logotype using the product identification；
Class Name field is generated in third party's table；
By in the Class Name field in the item name for extracting correspondence classification logotype redundancy to third party's table, product class is obtained
Other contingency table.
4. method according to claim 2, it is characterised in that it is described using the product category contingency table in the optimization
The step of adding item name, product table after being optimized to product identification in front product table includes：
Multiple item names corresponding with product identification are extracted in the product category contingency table；
Classification field is generated in the product table；
The item name of multiple ranks is added into classification field corresponding with product identification, the product table after being optimized.
5. method according to claim 1, it is characterised in that the step of the inquiry request that the receiving terminal sends it
Before, also include：
Index file is generated according to the classification information；
It is described to be inquired about in the product table according to the item name carried in the inquiry request, obtain respective classes
The step of product information of product information and subclass, includes：
Line retrieval is entered by search engine indexed file according to the item name carried in the inquiry request, multiple levels are obtained
Other item name；
Inquired about in the product table according to the item name of the index file and multiple ranks, obtained respective classes
The product information of product information and subclass.
6. a kind of multiclass classification inquiry unit, it is characterised in that described device includes：
Receiver module, for the inquiry request that receiving terminal sends, carries item name in the inquiry request；
Acquisition module, for obtaining product table according to the inquiry request, the product table includes item name, the classification
Title includes multiple ranks；
Enquiry module, for being inquired about in the product table according to the item name carried in the inquiry request, obtains
The product information of the product information and subclass of respective classes；
Sending module, for the multiple product informations for inquiring are back to terminal, so that terminal is shown.
7. device according to claim 6, it is characterised in that the acquisition module is additionally operable to the product table before obtaining optimization
With the category table before optimization, the product table before the optimization includes product identification, and the category table before the optimization includes class
Not Biao Shi and item name；
Described device also includes：
Relating module, for being associated by the product identification, classification logotype and item name, generates product category association
Table；
Optimization module, for adding class to product identification using the product category contingency table in the product table before the optimization
Another name claims, the product table after being optimized；
The enquiry module is additionally operable to the product table after optimization is obtained according to the inquiry request.
8. device according to claim 7, it is characterised in that the relating module is additionally operable to extract in the product table
Classification logotype and item name in product identification, the category table；Given birth to corresponding classification logotype using the product identification
Into third party's table；Class Name field is generated in third party's table；Will be the item name for extracting correspondence classification logotype superfluous
In Class Name field in the remaining table to third party, product category contingency table is obtained.
9. device according to claim 7, it is characterised in that the optimization module is additionally operable to associate in the product category
Multiple item names corresponding with product identification are extracted in table；Classification field is generated in the product table；By multiple ranks
Item name adds into classification field corresponding with product identification, the product table after being optimized.
10. device according to claim 6, it is characterised in that described device also includes：
Index generation module, for generating index file according to the classification information；
The enquiry module is additionally operable to pass through search engine indexed file according to the item name carried in the inquiry request
Enter line retrieval, obtain the item name of multiple ranks；According to the item name of the index file and multiple ranks in the product
Inquired about in product table, obtained the product information of the product information and subclass of respective classes.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610900239.3A CN106547843B (en) | 2016-10-14 | 2016-10-14 | Multi-stage classification query method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610900239.3A CN106547843B (en) | 2016-10-14 | 2016-10-14 | Multi-stage classification query method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106547843A true CN106547843A (en) | 2017-03-29 |
| CN106547843B CN106547843B (en) | 2020-02-07 |
Family
ID=58369164
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610900239.3A Active CN106547843B (en) | 2016-10-14 | 2016-10-14 | Multi-stage classification query method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106547843B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108460165A (en) * | 2018-04-19 | 2018-08-28 | 中山凯旋真空科技股份有限公司 | The information record queries method and system of vacuum equipment |
| WO2022143239A1 (en) * | 2020-12-31 | 2022-07-07 | 欧普照明股份有限公司 | Device information query method and query device for control system |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JPH06187194A (en) * | 1992-12-18 | 1994-07-08 | Hitachi Electron Service Co Ltd | Knowledge base for maintenance preparing method for information processor and classifying device based on knowledge base for maintenance of maintenance work report |
| CN102222100A (en) * | 2011-06-21 | 2011-10-19 | 青岛海信传媒网络技术有限公司 | Method and device for commodity information access |
| CN102467521A (en) * | 2010-11-08 | 2012-05-23 | 北大方正集团有限公司 | Easily-extensible multi-level classification search method and system |
| CN103793470A (en) * | 2013-12-31 | 2014-05-14 | 远光软件股份有限公司 | Data processing method and data processing device |
| CN105989457A (en) * | 2015-02-11 | 2016-10-05 | 阿里巴巴集团控股有限公司 | Information query method and apparatus thereof |
-
2016
- 2016-10-14 CN CN201610900239.3A patent/CN106547843B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JPH06187194A (en) * | 1992-12-18 | 1994-07-08 | Hitachi Electron Service Co Ltd | Knowledge base for maintenance preparing method for information processor and classifying device based on knowledge base for maintenance of maintenance work report |
| CN102467521A (en) * | 2010-11-08 | 2012-05-23 | 北大方正集团有限公司 | Easily-extensible multi-level classification search method and system |
| CN102222100A (en) * | 2011-06-21 | 2011-10-19 | 青岛海信传媒网络技术有限公司 | Method and device for commodity information access |
| CN103793470A (en) * | 2013-12-31 | 2014-05-14 | 远光软件股份有限公司 | Data processing method and data processing device |
| CN105989457A (en) * | 2015-02-11 | 2016-10-05 | 阿里巴巴集团控股有限公司 | Information query method and apparatus thereof |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108460165A (en) * | 2018-04-19 | 2018-08-28 | 中山凯旋真空科技股份有限公司 | The information record queries method and system of vacuum equipment |
| WO2022143239A1 (en) * | 2020-12-31 | 2022-07-07 | 欧普照明股份有限公司 | Device information query method and query device for control system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106547843B (en) | 2020-02-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101276361B (en) | Method and system for displaying related key words | |
| CN102053983B (en) | Method, system and device for querying vertical search | |
| CN108304444B (en) | Information query method and device | |
| CN102725755B (en) | Method and system of file access | |
| CN102955781B (en) | A kind of personage's searching method and device | |
| CN106484767A (en) | A kind of event extraction method across media | |
| CN111506621B (en) | Data statistical method and device | |
| CN108897874B (en) | Method and apparatus for processing data | |
| CN103428069A (en) | Method and device for adding friends in social network | |
| CN101916288B (en) | Mobile communication user search request responding system and processing method thereof | |
| CN103049496A (en) | Method, apparatus and device for dividing multiple users into user groups | |
| CN101685456B (en) | Search method, system and device | |
| US20190303384A1 (en) | Method and system for consolidating data retrieved from different sources | |
| CN103678575A (en) | Method and system for achieving unified processing on multiple database data through middleware | |
| CN104750776A (en) | Accessing information content in a database platform using metadata | |
| CN109726295A (en) | Brand knowledge map display methods, device, figure server and storage medium | |
| CN108984626B (en) | Data processing method and device and server | |
| CN105354283A (en) | Resource searching method and apparatus | |
| CN106547843A (en) | Multiclass classification querying method and device | |
| CN114066533A (en) | Product recommendation method and device, electronic equipment and storage medium | |
| CN112307318A (en) | Content publishing method, system and device | |
| CN105224555A (en) | A kind of methods, devices and systems of search | |
| CN102486775A (en) | Method and device for querying business data | |
| CN107977381B (en) | Data configuration method, index management method, related device and computing equipment | |
| CN109376154A (en) | Reading data, wiring method and reading data, writing system |
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 |