从SQL Server全文搜索中获取单词频率 [英] Get word frequencies from SQL Server Full Text Search

问题描述

SQL Server全文搜索计算基于单词在文档中和所有文档（TFIDF）中的词频。是否可以直接访问这些值？

我想在表格中找到前n个最频繁的单词。是否有可能从全文搜索索引中获取此列表？

我使用的是SQL Server 2005.

我不知道在SQL Server 2005上执行此操作的简单方法，但在2008年，有两个Transact-SQL命令可以完全满足您的需求。

• sys.dm_fts_index_keywords_by_document
  
  
  
  
  • http://technet.microsoft.com/en-us/library/cc280607.aspx
  
  


• sys.dm_fts_index_keywords
  
  
  
  
  • http://technet.microsoft.com/en-us/library/cc280900。 aspx
  
  

SQL Server Full-Text Search computes rank based on the frequency of the word in the document and in the set of all documents (TFIDF). Is it possible to access these values directly ?

I would like to find the top-n most frequent words in my table. Is it possible to obtain this list from the full-text search index?

I'm using SQL Server 2005.

解决方案

I don't know of an easy way to do this on SQL Server 2005, but on 2008 there are two Transact-SQL commands do exactly what you need.

• sys.dm_fts_index_keywords_by_document
  • http://technet.microsoft.com/en-us/library/cc280607.aspx
• sys.dm_fts_index_keywords
  • http://technet.microsoft.com/en-us/library/cc280900.aspx

这篇关于从SQL Server全文搜索中获取单词频率的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！