{"id":104,"date":"2012-01-11T15:26:34","date_gmt":"2012-01-11T20:26:34","guid":{"rendered":"http:\/\/www.thefaberfamily.org\/search-smith\/?p=104"},"modified":"2012-01-11T21:57:39","modified_gmt":"2012-01-12T02:57:39","slug":"moving-from-oracle-text-to-solr","status":"publish","type":"post","link":"http:\/\/www.thefaberfamily.org\/search-smith\/2012\/01\/moving-from-oracle-text-to-solr\/","title":{"rendered":"Moving from Oracle Text to Solr"},"content":{"rendered":"<p>I&#8217;ve not had the opportunity to use Oracle&#8217;s full text search, but I thought I would offer this link for consideration:<\/p>\n<p><a title=\"Moving from Oracle Text to Solr\/Lucene\" href=\"http:\/\/blog.digicol.de\/2009\/01\/13\/moving-from-oracle-text-to-solrlucene\/\" target=\"_blank\">Moving from Oracle Text to Solr\/Lucene<\/a><\/p>\n<p>I did have the opportunity some years ago to utilize SQL Server&#8217;s full-text searching ability (this was first available in SQL Server 7 if memory serves). At the time we were using ColdFusion with Verity as our search engine. I did not see a good way to get around the custom field limitations in Verity, so I searched for my criteria using &lt;CFSEARCH&gt;, then used those results to query a SQL Server database (hopefully using the IN clause instead of querying row-by-row, but it was several years ago and I could not say for certain). Things got much better when I switched to SQL Server&#8217;s full-text search as I was then able to do the keyword search and retrieve related data all in one query.<\/p>\n<p><strong>Update:<\/strong> The following article might also be interesting:<\/p>\n<p><a title=\"Text Search, your Database or Solr\" href=\"http:\/\/www.packtpub.com\/article\/text-search-your-database-or-solr\" target=\"_blank\">Text Search, your Database or Solr<\/a><\/p>\n<p>One possible issue with Oracle&#8217;s full text search is that there is no provision for faceted search. That might, of course, not be an issue if one can integrate regular queries with full-text queries. This was certainly possible with SQL Server, but I don&#8217;t know if Oracle offers this capability.<\/p>\n<div class=\"simple_likebuttons_container_small\">\r\n      <div class=\"simple_likebuttons_googleplus\">\r\n        <g:plusone size=\"medium\" count=\"false\" href=\"http:\/\/www.thefaberfamily.org\/search-smith\/2012\/01\/moving-from-oracle-text-to-solr\/\"><\/g:plusone>\r\n      <\/div>\r\n    \r\n      <div class=\"simple_likebuttons_twitter simple_likebuttons_twitter_s\">\r\n        <a href=\"https:\/\/twitter.com\/share\" class=\"twitter-share-button\" data-count=\"none\" data-url=\"http:\/\/www.thefaberfamily.org\/search-smith\/2012\/01\/moving-from-oracle-text-to-solr\/\" data-lang=\"en\">Tweet<\/a>\r\n      <\/div>\r\n    \r\n      <div class=\"simple_likebuttons_facebook\">\r\n        <div id=\"fb-root\"><\/div>\r\n        <script>(function(d, s, id) {\r\n          var js, fjs = d.getElementsByTagName(s)[0];\r\n          if (d.getElementById(id)) {return;}\r\n          js = d.createElement(s); js.id = id;\r\n          js.src = \"\/\/connect.facebook.net\/en_US\/all.js#xfbml=1\";\r\n          fjs.parentNode.insertBefore(js, fjs);\r\n        }(document, \"script\", \"facebook-jssdk\"));<\/script>\r\n        <div class=\"fb-like\" data-href=\"http:\/\/www.thefaberfamily.org\/search-smith\/2012\/01\/moving-from-oracle-text-to-solr\/\" data-send=\"false\" data-layout=\"button_count\" data-show-faces=\"false\" data-width=\"90\"><\/div>\r\n      <\/div>\r\n    <\/div>","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve not had the opportunity to use Oracle&#8217;s full text search, but I thought I would offer this link for consideration: Moving from Oracle Text to Solr\/Lucene I did have the opportunity some years ago to utilize SQL Server&#8217;s full-text searching ability (this was first available in SQL Server 7 if memory serves). At the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,3,10],"tags":[42,89,88,41,5],"class_list":["post-104","post","type-post","status-publish","format-standard","hentry","category-oracle","category-solr","category-sql","tag-full-text","tag-oracle","tag-solr","tag-sql-server","tag-verity"],"_links":{"self":[{"href":"http:\/\/www.thefaberfamily.org\/search-smith\/wp-json\/wp\/v2\/posts\/104","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.thefaberfamily.org\/search-smith\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.thefaberfamily.org\/search-smith\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.thefaberfamily.org\/search-smith\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.thefaberfamily.org\/search-smith\/wp-json\/wp\/v2\/comments?post=104"}],"version-history":[{"count":5,"href":"http:\/\/www.thefaberfamily.org\/search-smith\/wp-json\/wp\/v2\/posts\/104\/revisions"}],"predecessor-version":[{"id":106,"href":"http:\/\/www.thefaberfamily.org\/search-smith\/wp-json\/wp\/v2\/posts\/104\/revisions\/106"}],"wp:attachment":[{"href":"http:\/\/www.thefaberfamily.org\/search-smith\/wp-json\/wp\/v2\/media?parent=104"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.thefaberfamily.org\/search-smith\/wp-json\/wp\/v2\/categories?post=104"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.thefaberfamily.org\/search-smith\/wp-json\/wp\/v2\/tags?post=104"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}