CN106372238A - 一种基于数据库的非递归无限分类的实现方法 - Google Patents
一种基于数据库的非递归无限分类的实现方法 Download PDFInfo
- Publication number
- CN106372238A CN106372238A CN201610820879.3A CN201610820879A CN106372238A CN 106372238 A CN106372238 A CN 106372238A CN 201610820879 A CN201610820879 A CN 201610820879A CN 106372238 A CN106372238 A CN 106372238A
- Authority
- CN
- China
- Prior art keywords
- classification
- level
- cat
- catid
- data
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 17
- 238000012986 modification Methods 0.000 claims description 7
- 230000004048 modification Effects 0.000 claims description 7
- 238000004378 air conditioning Methods 0.000 claims description 3
- 238000003780 insertion Methods 0.000 claims description 3
- 230000037431 insertion Effects 0.000 claims description 3
- 238000013461 design Methods 0.000 abstract description 4
- 230000008901 benefit Effects 0.000 abstract description 3
- 238000007792 addition Methods 0.000 description 5
- 238000012217 deletion Methods 0.000 description 5
- 230000037430 deletion Effects 0.000 description 5
- 238000004458 analytical method Methods 0.000 description 3
- 230000009286 beneficial effect Effects 0.000 description 2
- 125000004122 cyclic group Chemical group 0.000 description 2
- 235000013305 food Nutrition 0.000 description 2
- 238000004364 calculation method Methods 0.000 description 1
- 238000013499 data model Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 235000013399 edible fruits Nutrition 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000004927 fusion Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 238000001228 spectrum Methods 0.000 description 1
- 238000000547 structure data Methods 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
- G06F16/2246—Trees, e.g. B+trees
-
- 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/21—Design, administration or maintenance of databases
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
- G06F16/2272—Management thereof
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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/23—Updating
- G06F16/2358—Change logging, detection, and notification
-
- 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/2433—Query languages
- G06F16/2445—Data retrieval commands; View definitions
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Catid | 分类ID | |
Cat_name | 分类名字 | |
Cat_code | 分类编码 |
Catid | Cat_name | Cat_code | |
10000000 | 家用电器 | 10000000 | |
10001000 | 大家电 | 10001000 | |
10001001 | 平板电视 | 10001001 |
Catid | 分类ID | |
Superiorid | 上级分类ID | |
superiorlevel | 上级分类的级别 |
Catid | Superiorid | superiorlevel | 说明 |
10001001 | 10001000 | 2 | 三级->二级 |
10001001 | 10000000 | 1 | 三级->一级 |
10001000 | 10000000 | 1 | 二级->一级 |
Catid | Superiorid | superiorlevel | 说明 |
10001002 | 10001000 | 2 | 三级->二级 |
10001002 | 10000000 | 1 | 三级->一级 |
10001000 | 10000000 | 1 | 二级->一级 |
Claims (2)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610820879.3A CN106372238A (zh) | 2016-09-13 | 2016-09-13 | 一种基于数据库的非递归无限分类的实现方法 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610820879.3A CN106372238A (zh) | 2016-09-13 | 2016-09-13 | 一种基于数据库的非递归无限分类的实现方法 |
Publications (1)
Publication Number | Publication Date |
---|---|
CN106372238A true CN106372238A (zh) | 2017-02-01 |
Family
ID=57897293
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201610820879.3A Pending CN106372238A (zh) | 2016-09-13 | 2016-09-13 | 一种基于数据库的非递归无限分类的实现方法 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN106372238A (zh) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109766439A (zh) * | 2018-12-15 | 2019-05-17 | 内蒙航天动力机械测试所 | 统计查询软件的无限树状分类定义与指派方法 |
CN110019006A (zh) * | 2017-10-16 | 2019-07-16 | 航天信息股份有限公司 | 一种用于无限级分类及排序的方法及*** |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2001014948A2 (en) * | 1999-08-19 | 2001-03-01 | Matrix Device Limited | Recursive dynamic access to a data model having a hierarchical tree structure |
CN101840400A (zh) * | 2009-03-19 | 2010-09-22 | 北大方正集团有限公司 | 一种多级分类检索方法及*** |
CN103942267A (zh) * | 2014-03-26 | 2014-07-23 | 上海德上网络科技有限公司 | 应用于在线教育***中的树形数据结构的建立方法 |
-
2016
- 2016-09-13 CN CN201610820879.3A patent/CN106372238A/zh active Pending
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2001014948A2 (en) * | 1999-08-19 | 2001-03-01 | Matrix Device Limited | Recursive dynamic access to a data model having a hierarchical tree structure |
CN101840400A (zh) * | 2009-03-19 | 2010-09-22 | 北大方正集团有限公司 | 一种多级分类检索方法及*** |
CN103942267A (zh) * | 2014-03-26 | 2014-07-23 | 上海德上网络科技有限公司 | 应用于在线教育***中的树形数据结构的建立方法 |
Non-Patent Citations (1)
Title |
---|
CAIGAN: "《"http://www.cnblogs.com/caicaizi/p/5238471.html"》", 3 March 2016 * |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110019006A (zh) * | 2017-10-16 | 2019-07-16 | 航天信息股份有限公司 | 一种用于无限级分类及排序的方法及*** |
CN110019006B (zh) * | 2017-10-16 | 2022-03-04 | 航天信息股份有限公司 | 一种用于无限级分类及排序的方法及*** |
CN109766439A (zh) * | 2018-12-15 | 2019-05-17 | 内蒙航天动力机械测试所 | 统计查询软件的无限树状分类定义与指派方法 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US5257365A (en) | Database system with multi-dimensional summary search tree nodes for reducing the necessity to access records | |
US6199059B1 (en) | System and method for classifying and retrieving information with virtual object hierarchy | |
US7124148B2 (en) | User-friendly search results display system, method, and computer program product | |
CN104063523B (zh) | 一种电子商务搜索评分与排名的方法及*** | |
CN103218719B (zh) | 一种电子商务网站导航方法及*** | |
Kotidis et al. | An alternative storage organization for ROLAP aggregate views based on cubetrees | |
CN103678620B (zh) | 一种基于用户历史行为特征的知识文档推荐方法 | |
CN103314371B (zh) | 一种检索的方法和*** | |
US20040158567A1 (en) | Constraint driven schema association | |
CN104794242B (zh) | 一种搜索方法 | |
Yiu et al. | Ranking spatial data by quality preferences | |
CN103186550A (zh) | 一种视频的相关视频列表的生成方法及*** | |
AU2004292680A1 (en) | Method of constructing preferred views of hierarchical data | |
CN104008171A (zh) | 一种法律数据库构建方法及法律检索服务方法 | |
US20080162446A1 (en) | Linked logical fields | |
US8065343B2 (en) | Data storage and retrieval system with optimized categorization of information items based on category selection | |
CN106997390A (zh) | 一种设备配件或零部件商品交易信息搜索方法 | |
CN102306176A (zh) | 一种基于数据仓库内在特征的olap关键词查询方法 | |
US20010042060A1 (en) | Attribute tagging and matching system and method for database management | |
CN106372238A (zh) | 一种基于数据库的非递归无限分类的实现方法 | |
CN106127863B (zh) | 一种冰箱发泡模具系列化设计***及其方法 | |
CN109062921B (zh) | 一种提取船舶托盘管理信息的方法及*** | |
CN105159898A (zh) | 一种搜索的方法和装置 | |
CN102033886A (zh) | 一种织物检索方法及*** | |
Sapir et al. | A methodology for the design of a fuzzy data warehouse |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
CB03 | Change of inventor or designer information | ||
CB03 | Change of inventor or designer information |
Inventor after: Zhou Zhen Inventor after: Liu Huiping Inventor after: Yu Liming Inventor before: Zhou Zhen Inventor before: Liu Huiping Inventor before: Yu Liming Inventor before: Zhi Fanglong Inventor before: Lu Wenkai |
|
TA01 | Transfer of patent application right |
Effective date of registration: 20170313 Address after: 510000 Guangzhou science and Technology Industrial Development Zone, Guangdong Province, science Avenue, room 101, No. 808 Applicant after: Guangzhou Electric Technology Co., Ltd. Address before: 510000 Guangzhou science and Technology Industrial Development Zone, Guangdong Province, science Avenue, room 101, No. 808 Applicant before: Guangzhou Mdt InfoTech Ltd |
|
TA01 | Transfer of patent application right | ||
CB03 | Change of inventor or designer information | ||
CB03 | Change of inventor or designer information |
Inventor after: Zhou Zhen Inventor after: Liu Huiping Inventor after: Yu Liming Inventor before: Zhou Zhen Inventor before: Liu Huiping Inventor before: Yu Liming Inventor before: Zhi Fanglong Inventor before: Lu Wenkai |
|
TA01 | Transfer of patent application right | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20170324 Address after: 510000 Guangzhou science and Technology Industrial Development Zone, Guangdong Province, science Avenue, room 101, No. 808 Applicant after: Guangzhou Electric Technology Co., Ltd. Address before: 510000 Guangzhou science and Technology Industrial Development Zone, Guangdong Province, science Avenue, room 101, No. 808 Applicant before: Guangzhou Mdt InfoTech Ltd |
|
RJ01 | Rejection of invention patent application after publication | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170201 |