Example 1: Find the Top Key Phrases in a Specific Document
The following example retrieves the top 10 key phrases from the document specified by the @DocumentId variable in the Document column of the Production.Document table of the AdventureWorks sample database. The @DocumentId variable represents
a value from the key column of the full-text index.
SELECT TOP(10) KEYP_TBL.keyphrase
FROM SEMANTICKEYPHRASETABLE
(
Production.Document,
Document,
@DocumentId
) AS KEYP_TBL
ORDER BY KEYP_TBL.score DESC;
GO
Example 2: Find the Top Documents that Contain a Specific Key Phrase
The following example retrieves the top 25 documents that contain the key phrase “Bracket” from the Document column of the Production.Document table of the AdventureWorks sample database.
SELECT TOP (25) DOC_TBL.DocumentID, DOC_TBL.DocumentSummary
FROM Production.Document AS DOC_TBL
INNER JOIN SEMANTICKEYPHRASETABLE
(
Production.Document,
Document
) AS KEYP_TBL
ON DOC_TBL.DocumentID = KEYP_TBL.document_key
WHERE KEYP_TBL.keyphrase = 'Bracket'
ORDER BY KEYP_TBL.Score DESC;
GO
Example 3: Find the Top Documents That Are Similar to Another Document
The following example retrieves the top 10 candidates who are similar to the candidate specified by
@CandidateID from the HumanResources.JobCandidate table in the AdventureWorks2012 sample database.
SELECT TOP(10) KEY_TBL.matched_document_key AS Candidate_ID
FROM SEMANTICSIMILARITYTABLE
(
HumanResources.JobCandidate,
Resume,
@CandidateID
) AS KEY_TBL
ORDER BY KEY_TBL.score DESC;
GO
Example 4: Find the Top Key Phrases That Are Similar between Documents
The following example retrieves the 5 key phrases that have the highest similarity score between the specified candidates in
HumanResources.JobCandidate table of the AdventureWorks2012 sample database.
SELECT TOP(5) KEY_TBL.keyphrase, KEY_TBL.score
FROM SEMANTICSIMILARITYDETAILSTABLE
(
HumanResources.JobCandidate,
Resume, @CandidateID,
Resume, @MatchedID
) AS KEY_TBL
ORDER BY KEY_TBL.score DESC;
GO
分享到:
相关推荐
GoogleTM Semantic Search Search Engine Optimization (SEO) Techniques That Get Your Company More Traffic, Increase Brand Impact, and Amplify Your Online Presence
open-semantic-search_20.01.17.deb ,官方下载 的安装包,官网下载太慢。
藏经阁-Semantic Search.pdf
semantic search 综述 非常赞的 入门
藏经阁-Semantic Search--Fast Results from Large,Foreign Language Corpora.pdf
开放式语义搜索设备(VM) 打开语义搜索服务器作为Virtual Box的基于Debian的虚拟机依存关系Debian软件包src / packages.chroot中的Open Semantic Search Server open-semantic-search_xx.xx.xx.deb 虚拟盒子Virtual...
Semantic Matching in Search。原微软,现在华为诺亚方舟实验室的李航的小册子哦。
semantic-ui离线文档,帮助我们更快的对semantic-ui的一 掌握
semantic
Semantic-Admin-Template 是 Semantic UI 的后台模板。 标签:Semantic
Web search performance and efficiency is critical for many people and organizations in emerging knowledge society.
官网下载直接引用semantic.css与semantic.min.css区别3.NodeJS、Gulp方式安装二、测试1.测试代码2.测试结果(成功)三、本节完整代码 官方地址 https://semantic-ui.com 一、使用 1.CDN加速 ```javascript CDN介绍...
Debian 包 Open Semantic Search Server open-semantic-search_xx.xx.xx.deb in src/packages.chroot 虚拟盒子 Virtual Box 来宾添加 ISO Debian 软件包 vmdebootstrap(安装:“apt-get install vmdebootstrap”...
Semantic UI 框架,Semantic UI中文官方网站, 当前版本:Semantic UI 2.2.4... Semantic作为一款开发框架,帮助开发者使用对人类友好的HTML语言构建优雅的响应式布局。
Semantic作为一款开发框架,帮助开发者使用对人类友好的HTML语言构建优雅的响应式布局。
Probabilistic Latent Semantic Indexing
Semantic-UI-CSS-master
资源内容:Semantic-ui 官方文档英文版,中文版可借助浏览器插件翻译,前端开发人员福利
Question Answer / Semantic Parsing 问答系统,语义解析 PPT 课件文档