名称: 分类架构 描述: 用于设计分类层次结构、标签系统、面分类或词汇管理,以便内容组织。涵盖扁平与层次分类、术语关系、多分类内容以及用于无头CMS的分类API。 允许工具: 读取, 全局搜索, 查找, 任务, 技能
分类架构
用于内容分类的设计分类系统的指导,包括类别、标签和面导航。
何时使用此技能
- 为内容设计类别层次结构
- 实施标签系统
- 规划面搜索和过滤
- 创建受控词汇表
- 在CMS平台之间迁移分类结构
分类类型
扁平分类(标签)
最适合用户生成的灵活分类。
public class Tag
{
public Guid Id { get; set; }
public string Name { get; set; } = string.Empty;
public string Slug { get; set; } = string.Empty;
public int UsageCount { get; set; }
}
public class ContentTag
{
public Guid ContentItemId { get; set; }
public Guid TagId { get; set; }
public int Order { get; set; }
}
用例:
- 博客帖子标签
- 产品关键词
- 用户生成的标签
- 民间分类系统
层次分类(类别)
最适合结构化、受控的分类。
public class Category
{
public Guid Id { get; set; }
public string Name { get; set; } = string.Empty;
public string Slug { get; set; } = string.Empty;
public string? Description { get; set; }
// 层次结构
public Guid? ParentId { get; set; }
public Category? Parent { get; set; }
public List<Category> Children { get; set; } = new();
// 物化路径用于高效查询
public string Path { get; set; } = string.Empty; // 例如,"/tech/programming/csharp"
public int Depth { get; set; }
public int Order { get; set; }
}
用例:
- 产品类别(电子 > 手机 > 智能手机)
- 文档分类
- 地理层次结构
- 组织结构
多分类系统
支持多个独立分类。
public class Taxonomy
{
public Guid Id { get; set; }
public string Name { get; set; } = string.Empty;
public string Slug { get; set; } = string.Empty;
public TaxonomyType Type { get; set; } // 扁平, 层次
public bool AllowMultiple { get; set; } = true;
public bool IsRequired { get; set; }
public List<string> ApplicableContentTypes { get; set; } = new();
}
public class TaxonomyTerm
{
public Guid Id { get; set; }
public Guid TaxonomyId { get; set; }
public string Name { get; set; } = string.Empty;
public string Slug { get; set; } = string.Empty;
// 用于层次分类
public Guid? ParentTermId { get; set; }
public string? Path { get; set; }
public int Depth { get; set; }
public int Order { get; set; }
// 元数据
public Dictionary<string, object?> Metadata { get; set; } = new();
}
public enum TaxonomyType
{
Flat, // 标签, 关键词
Hierarchical, // 具有父/子关系的类别
Faceted // 多维分类
}
层次结构模式
邻接表(简单)
CREATE TABLE Categories (
Id UNIQUEIDENTIFIER PRIMARY KEY,
Name NVARCHAR(200) NOT NULL,
ParentId UNIQUEIDENTIFIER NULL REFERENCES Categories(Id),
[Order] INT NOT NULL DEFAULT 0
);
-- 查询子项(一级)
SELECT * FROM Categories WHERE ParentId = @parentId ORDER BY [Order];
-- 递归CTE用于完整树
WITH CategoryTree AS (
SELECT Id, Name, ParentId, 0 AS Depth
FROM Categories WHERE ParentId IS NULL
UNION ALL
SELECT c.Id, c.Name, c.ParentId, ct.Depth + 1
FROM Categories c
INNER JOIN CategoryTree ct ON c.ParentId = ct.Id
)
SELECT * FROM CategoryTree;
物化路径(快速读取)
CREATE TABLE Categories (
Id UNIQUEIDENTIFIER PRIMARY KEY,
Name NVARCHAR(200) NOT NULL,
Path NVARCHAR(1000) NOT NULL, -- '/root/parent/child'
Depth INT NOT NULL,
[Order] INT NOT NULL
);
CREATE INDEX IX_Categories_Path ON Categories(Path);
-- 查询所有后代
SELECT * FROM Categories WHERE Path LIKE '/electronics/phones/%';
-- 查询祖先
SELECT * FROM Categories
WHERE '/electronics/phones/smartphones' LIKE Path + '%'
ORDER BY Depth;
嵌套集(复杂但强大)
CREATE TABLE Categories (
Id UNIQUEIDENTIFIER PRIMARY KEY,
Name NVARCHAR(200) NOT NULL,
Lft INT NOT NULL, -- 左边界
Rgt INT NOT NULL, -- 右边界
Depth INT NOT NULL
);
-- 查询所有后代
SELECT * FROM Categories
WHERE Lft > @parentLft AND Rgt < @parentRgt
ORDER BY Lft;
-- 查询祖先
SELECT * FROM Categories
WHERE Lft < @childLft AND Rgt > @childRgt
ORDER BY Lft;
面分类
面设计
public class Facet
{
public Guid Id { get; set; }
public string Name { get; set; } = string.Empty;
public string Slug { get; set; } = string.Empty;
public FacetType Type { get; set; }
public List<FacetValue> Values { get; set; } = new();
}
public class FacetValue
{
public Guid Id { get; set; }
public Guid FacetId { get; set; }
public string Value { get; set; } = string.Empty;
public string? DisplayValue { get; set; }
public int Order { get; set; }
}
public enum FacetType
{
SingleSelect, // 单选按钮
MultiSelect, // 复选框
Range, // 价格范围, 日期范围
Boolean, // 是/否
Hierarchy // 嵌套选项
}
// 带面的产品
public class ProductFacets
{
public List<Guid> BrandIds { get; set; } = new();
public List<Guid> ColorIds { get; set; } = new();
public decimal? PriceMin { get; set; }
public decimal? PriceMax { get; set; }
public bool? InStock { get; set; }
}
面搜索查询
public class FacetedSearchQuery
{
public string? SearchTerm { get; set; }
public Dictionary<string, List<string>> Facets { get; set; } = new();
public int Page { get; set; } = 1;
public int PageSize { get; set; } = 20;
}
public class FacetedSearchResult<T>
{
public List<T> Items { get; set; } = new();
public int TotalCount { get; set; }
public Dictionary<string, List<FacetCount>> FacetCounts { get; set; } = new();
}
public class FacetCount
{
public string Value { get; set; } = string.Empty;
public string DisplayValue { get; set; } = string.Empty;
public int Count { get; set; }
public bool IsSelected { get; set; }
}
分类API设计
REST端点
GET /api/taxonomies # 列出所有分类
GET /api/taxonomies/{id} # 获取带术语的分类
GET /api/taxonomies/{id}/terms # 列出术语(扁平或树)
GET /api/taxonomies/{id}/terms/{termId} # 获取单个术语
# 层次导航
GET /api/categories # 根类别
GET /api/categories/{id}/children # 子类别
GET /api/categories/{id}/ancestors # 面包屑路径
GET /api/categories/{id}/descendants # 完整子树
# 按分类的内容
GET /api/articles?category={slug}
GET /api/articles?tags=tag1,tag2
GET /api/products?facets[brand]=apple&facets[color]=black
GraphQL架构
type Taxonomy {
id: ID!
name: String!
slug: String!
type: TaxonomyType!
terms(parentId: ID): [TaxonomyTerm!]!
termTree: [TaxonomyTerm!]!
}
type TaxonomyTerm {
id: ID!
name: String!
slug: String!
path: String
depth: Int!
parent: TaxonomyTerm
children: [TaxonomyTerm!]!
contentCount: Int!
}
type Query {
taxonomies: [Taxonomy!]!
taxonomy(id: ID, slug: String): Taxonomy
categoryByPath(path: String!): TaxonomyTerm
}
最佳实践
命名约定
| 模式 | 示例 | 用于 |
|---|---|---|
| 单数 | 类别, 标签 | 实体名称 |
| 复数 | 类别, 标签 | 集合端点 |
| 简化格式 | web-development |
URL安全标识符 |
| 路径格式 | /tech/web/frontend |
层次路径 |
性能优化
// 缓存分类树(它们不经常变化)
public class TaxonomyCacheService
{
private readonly IMemoryCache _cache;
private readonly TimeSpan _cacheDuration = TimeSpan.FromMinutes(30);
public async Task<List<TaxonomyTerm>> GetTermTreeAsync(Guid taxonomyId)
{
var cacheKey = $"taxonomy:tree:{taxonomyId}";
if (!_cache.TryGetValue(cacheKey, out List<TaxonomyTerm>? tree))
{
tree = await BuildTermTreeAsync(taxonomyId);
_cache.Set(cacheKey, tree, _cacheDuration);
}
return tree!;
}
public void InvalidateCache(Guid taxonomyId)
{
_cache.Remove($"taxonomy:tree:{taxonomyId}");
}
}
内容计数反规范化
// 在内容发布/取消发布时更新计数
public class ContentPublishedHandler : INotificationHandler<ContentPublishedEvent>
{
public async Task Handle(ContentPublishedEvent notification, CancellationToken ct)
{
// 递增术语计数
foreach (var termId in notification.TaxonomyTermIds)
{
await _termRepository.IncrementCountAsync(termId);
}
}
}
相关技能
content-type-modeling- 将分类附加到内容类型content-relationships- 术语到内容的关系headless-api-design- 分类API端点