Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Easily-extensible multi-level classification search method and system

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

Problems solved by technology

The classification update efficiency of this method is low, and it is not easy to expand

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
  • Easily-extensible multi-level classification search method and system
  • Easily-extensible multi-level classification search method and system
  • Easily-extensible multi-level classification search method and system

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

No 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
no application Login to View More
IPC IPC(8): G06F17/30
Inventor 彭丹
Owner PEKING UNIV FOUNDER GRP CO LTD
Features
  • Generate Ideas
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com