MySQL和Solr中的分面搜索和类别 [英] Faceted searching and categories in MySQL and Solr

问题描述

我希望能够创建一个类似于ebay或newegg的搜索页面，您可以在其中选择类别以及根据类别选择不同的方面-有人可以向我指出正确的方向吗?

I'd like to be able to do a search page similar to ebay or newegg where you can select categories and different facets depending on the categories - could anybody point me in the right direction?

如何使用Solr中的产品存储和搜索此类构面和类别，以及如何使用MySQL查看哪种数据库模式. (我猜我会使用MySQL来提供Solr，是吗?)

How do I store and search such facets and categories with the products in Solr and what sort of DB schema would I be looking at with MySQL. (I'm guessing I'd use MySQL to feed Solr, yes?)

请原谅我在这些主题上的知识不足-我对所有这些知识都很陌生.

Please excuse my lack of knowledge on these subjects - I'm pretty new to all of this.

非常感谢您的帮助.预先感谢.

I'd greatly appreciate the help. Thanks in advance.

推荐答案

使用Solr进行分类树的转换并不简单，但是有可能.阅读此问题+答案.

Faceting through a category tree is not straightforward with Solr, but it's possible. Read this question + answer.

对于mysql，您将必须具有一个类别表，该表具有ID，名称和parent_id，该表链接到父类别(例如，如果是根节点，则为null)

For the mysql things you will have to have a category table with id, name and parent_id which links to the parent category (and is e.g. null if root node)

这篇关于MySQL和Solr中的分面搜索和类别的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！