Easily-extensible multi-level classification search method and system
What is Al technical title?
Al technical title is built by PatSnap Al team. It summarizes the technical point description of the patent document.
A multi-level classification and easy-to-expand technology, applied in the field of database retrieval, can solve the problems of low efficiency and inconvenient expansion, and achieve the effect of easy expansion and improved efficiency
Inactive Publication Date: 2012-05-23
PEKING UNIV FOUNDER GRP CO LTD +1
View PDF5 Cites 30 Cited by
Summary
Abstract
Description
Claims
Application Information
AI Technical Summary
This helps you quickly interpret patents by identifying the three key elements:
Problems solved by technology
Method used
Benefits of technology
Problems solved by technology
The classification update efficiency of this
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more
Image
Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
Click on the blue label to locate the original text in one second.
Reading with bidirectional positioning of images and text.
Smart Image
Examples
Experimental program
Comparison scheme
Effect test
Embodiment 1
[0091] In this embodiment, it is assumed that the data has the following classification methods: A, B, C, and D. Among them, A is the root node, the level ID is 1, and the classification node ID is 100; B is the child node of A node, the level ID is 2, and the classification node ID is 101; C is the child node of B node, the level ID is 3, The classification node ID is 102; D is a child node of node C, the level ID is 4, and the classification node ID is 103.
[0092] The structure of the classification table is as follows:
[0093] Classification Hierarchy ID
Classification node ID
Category Name
parent node
1
100
A
0
2
101
B
1
3
102
C
2
4
103
D
3
[0094] After the classification node ID is obtained according to the classification table, data table 1 is established, and its structure is as follows:
[0095]
[0096] The "_" in the categor...
Embodiment 2
[0105] On the basis of Example 1, two categories are added to Data Table 1, namely "100_101_102" and "101_102_103". The structure of the updated Data Table 1 is shown in the following table:
[0106]
[0107] According to the updated data table 1, the classification field association table is automatically updated, and its structure is as follows:
[0108] Data Sheet 1
[0109] When assigning values to classification field 2 or classification field 3 of the updated data table 1, according to the association relationship in the classification field association table, all the classification field values associated with data table 1 are summed up and written into the summary classification field , as shown in the table below:
[0110]
[0111] In the above table, the hierarchical relationship between different classification levels in the summary classification field is separated by ";", of course, other symbols can also be used, as long as different classific...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more
PUM
Login to view more
Abstract
The invention discloses an easily-extensible multi-level classification search method and an easily-extensible multi-level classification search system, belonging to the technical field of database search. The easily-extensible multi-level classification search method comprises the following steps of: setting classification fields in a data table according to data classification information and storing hierarchical relationships among classification nodes; storing the associations between the data table and the classification fields in the data table into an association table of classification fields; splitting each node into independent fields according to the hierarchical relationships among the classification nodes, and combining the independent fields with the other fields in the datatable to generate a classification association table; searching data in the classification association table by using database indexes during search; when more classification fields are added to the data table, storing the associations between the added classification fields and the data table automatically to the association table of classification fields; and when values are assigned to the added classification fields, aggregating all classification field values related to the data table automatically together according to the associations in the association table of the classification fields and writing the aggregated classification field values into aggregated classification fields of the data table.
Description
technical field [0001] The invention belongs to the technical field of database retrieval, and in particular relates to an easily expandable multi-level classification retrieval method and system. The invention is especially suitable for database retrieval of massive data. Background technique [0002] In information systems, data is often classified and stored, which is convenient for users to classify and retrieve data and view classified data, especially in the case of massive data, which can improve the efficiency of retrieval. For example, suppose an article contains a region classification attribute: Asia→China→Beijing. This is a typical multi-level classification structure. If the classification attribute of the region is set to "China", the system usually stores only one node, that is, "China" or hard-codes the classification path to one or more fields. . When searching, perform fuzzy query through the like statement in SQL. On the one hand, this retrieval method...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more
Application Information
Patent Timeline
Application Date:The date an application was filed.
Publication Date:The date a patent or application was officially published.
First Publication Date:The earliest publication date of a patent with the same application number.
Issue Date:Publication date of the patent grant document.
PCT Entry Date:The Entry date of PCT National Phase.
Estimated Expiry Date:The statutory expiry date of a patent right according to the Patent Law, and it is the longest term of protection that the patent right can achieve without the termination of the patent right due to other reasons(Term extension factor has been taken into account ).
Invalid Date:Actual expiry date is based on effective date or publication date of legal transaction data of invalid patent.