建议选择数据库/设计

时间:2021-11-21 12:57:01

Okay, i'm building a search engine based on urls stored in a database

好的,我正在建立一个基于存储在数据库中的网址的搜索引擎

| link_id || link_url || link_tags| <== schema

| link_id || link_url || link_tags | <==架构

link_tags for a site say w3schools.com represent [web-design,html,php,js] etc..

网站的link_tags说w3schools.com代表[web-design,html,php,js]等。

and the database(MySql) has like 10,00,000+ rows

数据库(MySql)有10,00,000多行

Now, i need them to be searchable by a search engine which also takes the link_tags into consideration while processing queries such as "best html tutorial" to return optimal results, also the entire web content of each url would also need to be stored to generate additional input to the engine based on keywords. Which opensource search engine or any previous implementation should i be looking at to acheive this?

现在,我需要通过搜索引擎搜索它们,搜索引擎在处理诸如“最佳html教程”之类的查询时也会考虑link_tags以返回最佳结果,同时还需要存储每个网址的整个网络内容以生成基于关键字对引擎的附加输入。我应该考虑哪个开源搜索引擎或任何以前的实现来实现这个目标?

1 个解决方案

#1


0  

There is a small opensource search engine here. It is written in php and uses mysql. it my be able to be stretched for your needs.

这里有一个小型的开源搜索引擎。它是用PHP编写的,并使用mysql。我能够满足你的需求。

#1


0  

There is a small opensource search engine here. It is written in php and uses mysql. it my be able to be stretched for your needs.

这里有一个小型的开源搜索引擎。它是用PHP编写的,并使用mysql。我能够满足你的需求。