Hi, I'm looking to compare two documents to determine what percentage of their text matches based on keywords. To do this I could easily chop them into a set word of sanitised words and compare, but I would like something a bit smarter, something that can match words based on their root, ie. even if their tense or plurality is differen...
How can i pass additional parameters to SOLR, while importing from database, using dataimport. Example: I have sql query, smth like this: Select * from documents where documentId > [myParameterHere] Can i somehow insert value to [myParameterHere]? ...
So I'm using SQL Full Text Search and from what I read, CONTAINS returns matches near words, while FREETEXT returns words that have similar meaning, however I can't find any examples that validate this. Anyway, to the point, I am using Full Text Search on a table with a description field that is max 2500 chars long and want to use FTS o...
Hi I have 2 following 2 queries: SELECT FT_TBL.JobId, FT_TBL.Title, FT_TBL.[Description], FT_TBL.Location, KEY_TBL.RANK FROM Jobs AS FT_TBL INNER JOIN FREETEXTTABLE (Jobs, (Title, [Description], Location), 'asp.net software') AS KEY_TBL on FT_TBL.JobId = KEY_TBL.[KEY] WHERE CONTAINS (Location, '"luton*"') order by KEY_TB...
I can't seem to find any recent talk on the choice. Back in '06 there was criticism on Hibernate Search as being incomplete and not being ready to compete with Compass, is it now? Has anyone used both and have some perspective on making the decision. I am developing a web app in Java in my free time, its just me so I'm looking to cut co...
I'm trying to get Lucene.NET to work on a shared hosting environment. Mascix over on codeproject outlines here how he got this to work on godaddy. I'm attempting this on isqsolutions. Both examples he posted run fine on my local machine and both throw the same error on the the shared hosting server: Compiler Error Message: CS0246: T...
I am using SQL Server Full Text Search, with the keyword FREETEXTTABLE to return a table of results based on a few columns, searching for a keyword. Now I have 2 main columns that I am searching on, Title and Description, I want to give precedence to the Title column as this will most likely have my results but Description might contain...
I've got a MySQL query somewhat like the following: SELECT * FROM products LEFT JOIN descriptions ON products.DescriptionID = descriptions.ID WHERE MATCH (name, overview, specs) AGAINST ('ram'); All columns I'm trying to search with MATCH() AGAINST() are FULLTEXT, but I get the following error when testing in phpMyAdmin: #1210 - I...
We host websites in a shared hosting environment where Microsoft SQL Server full text searching is not allowed. We would love an ASP.NET API that allowed similar functionality to get around this restriction. We can't easily install software on the shared servers, so the API would have to be written in ASP.NET. SQL "like" queries are o...
Hi guys, Just wondering if there is any tips on improving search times (full-text). How do large sites like stackoverflow, reddit, etc, implement their search functions? (Sorry for the vagueness - i am a newbie) ...
Ok I have a full text search index created on my JobsToDo table, but what I'm concerned about is if this is rendering my other indexes on the table useless. I have a normal nonclustered index on the CreatedDate field in this table. So when I run my full text search it returns results, I then filter my full text search by CreatedDate >= G...
Example: I want to search results only from the research papers or I want to search results only from opensource tools/packages/codes Kindly help me ...
I'm just trying out full text search in SQL Server 2008 and am failing at the first hurdle. I've created an index, but when I try to populate it using: ALTER FULLTEXT INDEX ON TableName SET CHANGE_TRACKING AUTO; I get the following error: Msg 7644, Level 17, State 1, Line 1 Full-text crawl manager has not been initialized. An...
I'm trying to improve our search capabilities for short phrases (in our case movie titles) and am currently looking at SQL Server 2008 Full Text Search, which provides some of the functionality we would like: Word stemming (e.g. "saw" also means "see", "seen", etc.) Synonyms (e.g. "6" is synonymous with "VI") However the ranking algo...
I am trying to figure out how to add search to my rails application. I am brand new so go slow. I have created a blog and done quite a bit of customizing including adding some AJAX, pretty proud of myself so far. I am having trouble finding any good tutorials about how to add this functionality. Basically I just want to enable a full sea...
does any one now the code for the search function on ebay, in particular the ebay suggestion function thanks ...
The django-sphinx documentation shows that django-sphinx layer also supports some basic querying over multiple indexes. http://github.com/dcramer/django-sphinx/blob/master/README.rst from djangosphinx.models import SphinxSearch SphinxSearch('index1 index2 index3').query('hello') It seems SphinxSearch does not contain the function qu...
I have the following parent <-> child datamodel: (almost every line is a table, indented means child-of) consumerGoods food meat item fruit item vegetable item The child-items of meat, fruit and vegetables are in the same table (named items) because they have identical a...
Hey guys, I have this small file search engine here made in VB.NET: ListBox1.Items.Clear() ListBox3.Items.Clear() ChDir("C:\") Try For Each foundFile As String In My.Computer.FileSystem.GetFiles( _ My.Computer.FileSystem.CurrentDirectory, _ FileIO.SearchOption.SearchAllSubDirectories, Te...
Hi, I'm looking to add full text indexing to a Linux desktop application written in C++. I am thinking that the easiest way to do this would be to call an existing library or utility. This article reviews various open source utilities available for the Gnome and KDE desktops; metatracker, recoll and stigi are all written in C++ so they...