Given the recent 55 minute Google service interruption, it seems obvious to me that internet search is too important to leave in the hands of one company (no matter how hard they try not to be evil). So are there some (possibly p2p) free open source alternative internet search/information storage and retrieval systems that might work or...
What's the best way to convert search terms entered by a user, into a query that can be used in a where clause for full-text searching to query a table and get back relevant results? For example, the following query entered by the user: +"e-mail" +attachment -"word document" -"e-learning" Should translate into something like: SELECT...
What would be the search condition for the query below if we wanted to retrieve all the keys for which the columnName does not contain "thisWord" ? SELECT [key] AS someValue FROM CONTAINSTABLE ( table ,columnName, ??what goes here?? ) Note: This is a full-text based search. ...
I am mainly curious as to the inner workings of the engine itself. I couldnt find anything about the index format itself (IE in detail as though you were going to build your own compatible implementation) and how it works. I have poked through the code, but its a little large to swallow for what must be described somewhere since there ar...
Hello, everyone! I have a problem with simple full-text search dictionary template in Pg. It's simply passes through any non-English words not bothering lower-casing em. Is it by design or I miss some kind of setting here? CREATE TEXT SEARCH DICTIONARY russian_simple ( TEMPLATE = simple, StopWords = russian ); SELECT ts_lexize(...
I just setup full-text search on my development database. I setup a new full-text index on a table and included 2 columns in the index. The first column is called 'description' and is a 'varchar(100)' and the other column is called 'notes' and is a 'text' column. I am trying to perform a simple search like this: select * from myTable w...
30 million distinct phrases, not documents, ranging from one word to a 10 word sentence and I need to support word/phrase searching. Basically what where contains(phrase, "'book' or 'stack overflow'") offers. I have an instance of SQL Server 2005 (32 bit, 4 proc, 4gb) going against several full text catalogs and performance is awful for...
I would like to run a search with MSSQL Full text engine where given the following user input: "Hollywood square" I want the results to have both Hollywood and square[s] in them. I can create a method on the web server (C#, ASP.NET) to dynamically produce a sql statement like this: SELECT TITLE FROM MOVIES WHERE CONTAINS(TITLE,'"holly...
Now that SQL Server 2008 has full text search built in. I'm looking to use it to power my website's search. I'm also looking at using ADO.NET entity framework for my ORM but I was wondering how do you do full text search (FTS) with Linq to ADO.NET entity framework? Is there any support in ADO.NET entity framework or am I stuck using the...
Consider there is one MS SQL server 2005 instance with 3 databases on it ... Dev, RC and Production. All of them have (more or less) the same schema. All of them have a "same" table with full text index on it. What happens if the name of full text index catalog is the same on all 3 databases? Do they share the same physical catalog? Is...
I need to do a Full Text Search with NO word stemming...I tried to wrap the term I'm searching in double quotes, but no joy... I still get results like "bologna" when I search for '"bolognalo"' Any help is appreciated.. ...
So why does the first search example below return no results? And any ideas on how to modify the below code to make number searches possible would be much appreciated. Create the index $index = new Zend_Search_Lucene('/myindex', true); $doc->addField(Zend_Search_Lucene_Field::Text('ssn', '123-12-1234')); $doc->addField(Zend_Search_Luce...
We're currently running MySQL on a LAMP stack and have been looking at implementing a more thorough, full-text search on our site. We've looked at MySQL's own freetext search, but it doesn't seem to cope well with large databases, which makes it far too slow for our needs. Our main requirements are: speed returning results simple upd...
I have a table that was doing a fine job of full-text search until last week. There are over seven million records, and I see it has over seven million entries in the full-text index. But nothing more recent than a week old shows up in the search results. I can see in the table's full-text index properties that there are a growing n...
I want to match an input string to my PHP page the same way a match done by the LIKE command in SQL (MySQL) for consistency of other searches. Since (I have seen but don't comprehend) some of the PHP syntax includes SQL commands I am wondering if this is possible? The reason for this is I am now implementing a search of a keyword versu...
I have a database with regular full-text catalogs. I want to detach this database, copy it to a different server and attach it under a different name (same name but with '_BAK' appended to it). I am using SQL Server 2005. Here is the error trying to attach DATABASE with full-text catalogs under the name DATABASE_BAK Warning: Identity ...
There's no full text search built into Linq and there don't seem to be many posts on the subject so I had a play around and came up with this method for my utlity class: public static IEnumerable<TSource> GenericFullTextSearch<TSource>(string text, MyDataContext context) { //Find LINQ Table attribute object[] info = typeof(TSour...
Hi folks, i have the following data in a field, which is being indexed by a Full Text Catalog. Pamorama City, Los Angeles, California, United States Simple. (I also have lots of others, but they are working fine). Now, if the user provides this incorrect, mispelt search word pamorma city <-- notice the middle 'a' is missi...
I need to index a lot of text. The search results must give me the name of the files containing the query and all of the positions where the query matched in each file - so, I don't have to load the whole file to find the matching portion. What libraries can you recommend for doing this? update: Lucene has been suggested. Can you give m...
I have a Products table in a SQL Server database and I am having to troubleshoot a legacy stored procedure that uses Full-Text indexing. For our purposes here, lets suppose that the Products table has two fields ID, Keywords. And the Keywords field is populated with the following: ROLAND SA-300 This Roland SA-300 is in MINT conditi...