{"id":528,"date":"2011-09-11T19:07:00","date_gmt":"2011-09-11T19:07:00","guid":{"rendered":"\/blogs\/bobb\/post\/Contents-and-purpose-of-SemanticsDB-in-Denali.aspx"},"modified":"2011-09-11T19:07:00","modified_gmt":"2011-09-11T19:07:00","slug":"contents-and-purpose-of-semanticsdb-in-denali","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/bobb\/contents-and-purpose-of-semanticsdb-in-denali\/","title":{"rendered":"Contents and purpose of SemanticsDB in Denali"},"content":{"rendered":"<p>\nThe new Semantic Search feature of SQL Server Denali enhances full-text search by letting you do a search on the meaning of documents. To use this feature, its required that you install the SemanticsDB. The SemanticsDB ships with SQL Server or can be downloaded as part of the SQL Server Denali CTP3 Feature Pack. One you have attached the SemanticsDB to your SQL Server instance and provided appropriate access to it, you can use the STATISTICAL_SEMANTICS keyword of CREATE FULLTEXT INDEX or ALTER FULLTEXT INDEX to build semantic indices, and use them with the three table-valued functions I mentioned in an earlier blog post. So what does the SemanticsDB provide?\n<\/p>\n<p>\nThe SemanticsDB contains Statistical Language Models. A <a href=\"http:\/\/en.wikipedia.org\/wiki\/Language_model\">starter description<\/a> of this can be found in Wikipedia, but these models are used to build the semantic indexes that are used with the semantic search table-valued functions. There is actually one language model internal table for each supported language. The SemanticDB is static and you can&#39;t customize it or provide your own. It&#39;s not updated during semantic index processing, in fact, you can make the SemanticDB read-only with no ill effects to the feature. It&#39;s used to make the index-building scalable, as the speed of semantic index building is not dependant on the size of the corpus of documents.\n<\/p>\n<p>\nHope this gets you intrigued about this interesting new feature.\n<\/p>\n<p>\n@bobbeauch<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The new Semantic Search feature of SQL Server Denali enhances full-text search by letting you do a search on the meaning of documents. To use this feature, its required that you install the SemanticsDB. The SemanticsDB ships with SQL Server or can be downloaded as part of the SQL Server Denali CTP3 Feature Pack. One [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31,35],"tags":[],"class_list":["post-528","post","type-post","status-publish","format-standard","hentry","category-sql-server-2012","category-sql-server-semantic-search"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.9.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Contents and purpose of SemanticsDB in Denali - Bob Beauchemin<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/bobb\/contents-and-purpose-of-semanticsdb-in-denali\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Contents and purpose of SemanticsDB in Denali - Bob Beauchemin\" \/>\n<meta property=\"og:description\" content=\"The new Semantic Search feature of SQL Server Denali enhances full-text search by letting you do a search on the meaning of documents. To use this feature, its required that you install the SemanticsDB. The SemanticsDB ships with SQL Server or can be downloaded as part of the SQL Server Denali CTP3 Feature Pack. One [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/bobb\/contents-and-purpose-of-semanticsdb-in-denali\/\" \/>\n<meta property=\"og:site_name\" content=\"Bob Beauchemin\" \/>\n<meta property=\"article:published_time\" content=\"2011-09-11T19:07:00+00:00\" \/>\n<meta name=\"author\" content=\"Bob Beauchemin\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bob Beauchemin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/contents-and-purpose-of-semanticsdb-in-denali\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/contents-and-purpose-of-semanticsdb-in-denali\/\",\"name\":\"Contents and purpose of SemanticsDB in Denali - Bob Beauchemin\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website\"},\"datePublished\":\"2011-09-11T19:07:00+00:00\",\"dateModified\":\"2011-09-11T19:07:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/contents-and-purpose-of-semanticsdb-in-denali\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/bobb\/contents-and-purpose-of-semanticsdb-in-denali\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/contents-and-purpose-of-semanticsdb-in-denali\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2012\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/category\/sql-server-2012\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Contents and purpose of SemanticsDB in Denali\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/\",\"name\":\"Bob Beauchemin\",\"description\":\"SQL Server Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e\",\"name\":\"Bob Beauchemin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g\",\"caption\":\"Bob Beauchemin\"},\"sameAs\":[\"http:\/www.sqlskills.com\/blogs\/bobb\/\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/author\/bobb\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Contents and purpose of SemanticsDB in Denali - Bob Beauchemin","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlskills.com\/blogs\/bobb\/contents-and-purpose-of-semanticsdb-in-denali\/","og_locale":"en_US","og_type":"article","og_title":"Contents and purpose of SemanticsDB in Denali - Bob Beauchemin","og_description":"The new Semantic Search feature of SQL Server Denali enhances full-text search by letting you do a search on the meaning of documents. To use this feature, its required that you install the SemanticsDB. The SemanticsDB ships with SQL Server or can be downloaded as part of the SQL Server Denali CTP3 Feature Pack. One [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/contents-and-purpose-of-semanticsdb-in-denali\/","og_site_name":"Bob Beauchemin","article_published_time":"2011-09-11T19:07:00+00:00","author":"Bob Beauchemin","twitter_misc":{"Written by":"Bob Beauchemin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/contents-and-purpose-of-semanticsdb-in-denali\/","url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/contents-and-purpose-of-semanticsdb-in-denali\/","name":"Contents and purpose of SemanticsDB in Denali - Bob Beauchemin","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website"},"datePublished":"2011-09-11T19:07:00+00:00","dateModified":"2011-09-11T19:07:00+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/contents-and-purpose-of-semanticsdb-in-denali\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/bobb\/contents-and-purpose-of-semanticsdb-in-denali\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/contents-and-purpose-of-semanticsdb-in-denali\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/bobb\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2012","item":"https:\/\/www.sqlskills.com\/blogs\/bobb\/category\/sql-server-2012\/"},{"@type":"ListItem","position":3,"name":"Contents and purpose of SemanticsDB in Denali"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/","name":"Bob Beauchemin","description":"SQL Server Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/bobb\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e","name":"Bob Beauchemin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g","caption":"Bob Beauchemin"},"sameAs":["http:\/www.sqlskills.com\/blogs\/bobb\/"],"url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/author\/bobb\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/posts\/528","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/comments?post=528"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/posts\/528\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/media?parent=528"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/categories?post=528"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/tags?post=528"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}