semantic search examples

原创 2012年03月25日 00:35:28

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


相关文章推荐

Semantic Matching in Search

  • 2014年07月09日 10:15
  • 1.23MB
  • 下载

Semantic Search: The Myth and Reality 及其中文翻译

Semantic Search: The Myth and RealityWritten by Alex Iskold / May 29, 2008 2:15 PM / 15 CommentsFor ...

SPARK: Adapting Keyword Query to Semantic Search-ISWC2007

给出一个关键词,把关键词转换成一系列按照概率排序的SPARQL语句输出出来。 2.主要步骤   主要有三个步骤:术语匹配、查询图的构造、和查询排序。 2.1术语匹配:把关键词和知识库中的资源进行匹配...

Learning Deep Structured Semantic Models for Web Search using Clickthrough Data笔记

用于搜索的DSSM模型

Semantic SPARQL Similarity Search Over RDF Knowledge Graphs -VLDB2016

一.文章概括 本文的主要工作是在当用户对底层的知识库没有足够的了解的情况下,基于用户提供的查询,提出了一种新的相似性度量-语义图编辑距离,并返回top-k个最可能的查询结果。 动机: 当用户对底层知识...

spring,hibernate,semantic,百度API

  • 2015年08月18日 17:05
  • 2.8MB
  • 下载

DeepLab:深度卷积网络,多孔卷积 和全连接条件随机场 的图像语义分割 Semantic Image Segmentation with Deep Convolutional Nets, Atro

深度卷积网络,多孔卷积 和全连接条件随机场 的图像语义分割 DeepLab: Semantic Image Segmentation with Deep Convolutional Nets, At...

Handbook of Semantic Web Technologies

  • 2016年06月11日 16:38
  • 11.51MB
  • 下载
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:semantic search examples
举报原因:
原因补充:

(最多只允许输入30个字)