Searching the text of a collection of documents or free text fields in a database to find those containing a word or combination of words.
3
votes
2answers
42 views
maintaining full text index on large table
I'm on SQL Server 2008 and have a table, for reporting purposes, with 500,000 records that will easily reach the millions. The table will employ a full text index for rapid searching
on a handful of ...
3
votes
0answers
10 views
Fulltext stoplist replication
In MS SQL Server 2008 R2 there is replication of table with fulltext index on it.
But stoplist that is associated with replicated fulltext index doesn't replicate.
Is there any possibility to ...
2
votes
2answers
31 views
MySQL - SQL statement to test minimum length of the word 'ft_min_word_len'
I'm trying to understand FULLTEXT indexes.
Is there some SQL query to test 'ft_min_word_len' variable?
I've tried to match four characters only in the example below but it doesn't work. Why the ...
2
votes
1answer
24 views
MySQL Full Text search increase relevance for exact matches?
I have a MySQL database of ~10,000 organisation names that I want to be able to search. I would like to use a full text search because this would enable me to find "institute of doobry" by searching ...
0
votes
1answer
29 views
viewing the population? (sql server full text search)
I'm thinking that when we are working on full text search, we might want to view how sql server FT engine breaks the data and indexes it. For my case the column being indexed are simple nvarchar ...
0
votes
0answers
30 views
mySQL- large database
I need guideline to setup DBMS(MYSQL or SQL Server 2008). The database size is expected upto 80-100GB in next few months. One main table will contain textual content like essays. Can MySQL handle such ...
1
vote
0answers
67 views
sql server full text search - fuzzy searching?
Is there a way to configure fuzzy searches in sql server full text search. Meaning if I search for a term called POWDER, I must get matches (i.e. strings) which contain any variations of it within an ...
0
votes
1answer
25 views
MySQL not allowing text columns?
I'm using MySQL 5.5.27. I currently have a BLOB column, that I want to convert to text to allow fulltext searching. The ALTER TABLE command to create a text column is successful, but the ALTER TABLE ...
0
votes
2answers
60 views
Bypass MyISAM table lock
I have a big MyISAM table with a fulltext index for searching. Problem is that inserting data into that table results in a table lock and in the meantime no other sql query can perform any action ...
0
votes
0answers
28 views
Full-text search index size
Is there any analysis about this topic? For example what is the estimated index file size of 1 GB .txt files?
1
vote
1answer
56 views
I would like to query a range of criteria on multiple columns in MySQL
I have 3 columns in a mysql table. I'm using Innodb engine. I want to be able to search for some values on those columns and also anything close to those values. For example :
We have 3 columns as ...
0
votes
1answer
77 views
MySQL Fulltext match with forward slashes
I'm trying to run a fulltext match against a product database, where the product names have forward slashes in them. These are staple sizes, so it's quite important that they get matched.
However, ...
2
votes
0answers
49 views
How do I get more details on a full text catalog error?
I have an error that is repeatedly generated on a SQL Server 2005 instance running the databases for MS Team Foundation Server.
'Severity 16' occurred on INSTANCENAME
Looking in the SQL Server ...
0
votes
0answers
13 views
Which triplestores have support for full-text search
Which RDF triplestores support full-text search and what performance can be expected from them.
I am assuming that they will have to extend SPARQL in some way as the only way that I can think of for ...
0
votes
1answer
60 views
Book / Tutorials / Website - Creating Custom C Database [closed]
I want to create the custom database for my project. Kindly recommend me Good Book or Tutorials or Website which provide the detailed information.
The features want to implement are full text ...
