More and more, I'm seeing searches that not only find a substring in a specific column, but they appear to search in all columns. An example is in Amazon, where you can search for "Arnold" and it finds both the movie Running Man starring Arnold Schwarzeneggar, and the Gund toy Arnold the Snoring Pig. I don't know what the term is for t...
I'm using a CONTAINSTABLE query with MS SQL Server's full-text indexing engine to search within a textual column; e.g.: SELECT * FROM MyTable INNER MERGE JOIN CONTAINSTABLE(MyTable, sDescription, 'FORMSOF(INFLECTIONAL, "brains")') AS TBL1 ON TBL1.[key]=MyTable.ixKey This does a great job of finding rows with a description includi...
I am looking to do some benchmarking on Full Text Search indexes in PostgreSQL, SQLServer and Lucene. Any ideas on where to find a good big sample database to perform queries against? Thanks a lot in advance. ...
Error message: Warning : SQM1014: Unable to extract function 'dbo.ProductFamilyIndex_EN' from SqlServer. Null or empty full-text predicate. function defined as: CREATE FUNCTION [dbo].[ProductFamilyIndex_EN] ( @topn int, @keywords nvarchar(4000) ) RETURNS TABLE AS RETURN ( select top (@topn) ProductFamilyID from ...
I have a problem with SQL Server 2008 full text search I have the following query SELECT * FROM cigars WHERE CONTAINS(cigars.*, @Search ) @Search is a value that is passed in through a stored procedure. But, thats not the problem. What is is if someone searches for say 'Punch' it works fine and I get all cigars that match. Where the...
Hi: Suppose I have a MySQL database named DB, and a table named ContactInfo. The following is its structure and some example data(Just one item): Table----ContactInfo: ----------------------------------------------------------- name fullname phone -----------------------------------------------...
I have an Indexed View with two columns, a primary key char and a field for full-text indexing varchar(300). I need to search from a MS Great Plains database, so I created the view to populate a field with concatenated values from my primary table IV00101. CREATE VIEW SearchablePartContent WITH SCHEMABINDING AS SELECT ITEMNMBR, rtrim(I...
User fill multi-field form (document) with date, time, title and description. Check, if similar documents are stored in Solr before document saved User can choose, save this document or not. How to implement in Solr "find similar documents"? in Lucene: FuzzyLikeThisQuery, MoreLikeThis? but in Solr? P.S. I use django-hastack ...
Hello everyone, I am new to SQL Server 2008 Full Text index function. I am learning from this tutorial, http://www.codeproject.com/KB/database/SQLServer2K8FullTextSearh.aspx. I am using SQL Server 2008 Enterprise. In the first step of the tutorial, it is mentioned that I need to "Create a Full-Text Catalog", but I did not find the New ...
I'm coding a resource site around a fairly large directory database, and I'd like to make some kind of in-site search available for my visitors. I'm debating between whether to use Google's premade site search (which I can drop right into my template) or coding a custom search that accesses the database directly. Obviously, the custom s...
Hello, My website stores several million entities. Visitors search for entities by typing words contained only in the titles. The titles are at most 100 characters long. This is not a case of classic document search, where users search inside large blobs. The fields are very short. Also, the main issue here is performance (and not r...
How does for example components like the "Total Commander " search can open every file format And search inside it ? Is there free library that offer me such feature ? Basically in the end I will like to extract texts from files be able to support all formats ( pdf,Microsoft doc ,chm …) ...
Note: This is a cross-post, it is firstly posted at the sphinx forum,however I got no answer, so I post it here. First take a look at a example: The following is my table(just for test used): +----+--------------------------+----------------------+ | Id | title | body | +----+----------------------...
Hello i'm using SQL server full-text search. when i use the FreeText predicate it need the language as parameter, but sql parameters name is different from .net culture names. So my question is How can i obtain an Sql Language name from a .Net Culture. ...
MS SQL Server 2005: table1 has a full text index. I want to run multiple freetexttable searches against it in a single query, but the two attempts i have fail. any help would be appreciated, thanks! p.s. am willing to upgrade to sql 2008 if it fixes this :) CREATE FUNCTION fnt_FullTextSearch ( @s NVARCHAR(4000) ) RETURNS TABLE AS ...
We are running SOLR 1.4.1 (Lucene 2.9.3) on a 2-CPU Linux host, but it seems that only 1 CPU is ever being used. It almost seems like something is single-threading inside the SOLR application. The CPU utilization is very seldom over 0.9 even under load. We are running on virtual Linux hosts and but our other apps in the same cluster a...
Hi, I need a full text search engine which should support internationalization. Thanks ...
I want to implement in desktop application in java searching and highlighting multiple phrases in html files, like it is done in web browsers, so html tags (within < and >) are ignored but some tags like <b> arent ignored. When searching for example each table in text ...each <b>table</b> has name... will be highlighted, but in text ...h...
I have a requirement to perform a search against Search Server Express that will return a list of search results filtered by Document Libraries. That is, I need to be able to identify Document Libraries themselves from within search results. Currently, we are using FullTextSqlQuery to return a DataTable. The query currently looks like ...
We are trying to build the categorization tool which should have a keyword match. Each category has it's keywords. Each asset may belongs to many categories. In order to categorize asset we need to find all categories that match the asset: all keywords defined for a category should match(full text search) the asset. Is there any way to...