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.
2
votes
2answers
24 views
Installing Full Text Search to SQL Server 2008 R2
I installed sql server 2008 R2 Express successfully, then realised I need to get Full Text Search. So I downloaded the "Advanced Services Installation Package", but when I run it there is no option in ...
1
vote
0answers
27 views
Mysql key_buffer_size already 16GB but some fulltext searches are still slow
I have a query w/ full text search which takes 5 - 10 secs. key_buffer_size is already 16GB.
Table has 15 million records and has a compound fulltext index on fields: categories and company.
Table ...
1
vote
1answer
44 views
Full-text Catalog Corruption
I have a SQL Server 2005 database that I backed up and restored onto a new server running SQL Server 2012. So far so good. This morning I had a really bad power outage and the new server went down. ...
2
votes
1answer
34 views
How do I rebuild single full text catalog (or why is “rebuild” full text catalog option disabled)
In SSMS. I have Full Text Catalog defined. If I select "Full Text Catalogs" folder - there is an option "Rebuild All" and it is enabled.
But if I select individual FTC - "Rebuild" option (in context ...
0
votes
1answer
124 views
What are safe characters to use in SQL Server Full Text Search? [closed]
I've been playing with full text search on SQL Server 2012. I must say my attempts to target special characters in search queries were futile - SS does not understand them. What's more, sometimes the ...
0
votes
2answers
35 views
MYSQL matching one column to another in a different table via a FULLTEXT index
I current have two different tables.
The first table has a list of titles and IDs associated to these titles, the second table is a list of random heading.
What I would like to know is if there is a ...
0
votes
1answer
71 views
Full text search on multiple tables in PostgreSQL
I have several tables that have related data. I want to have a search input box on the dashboard of the system that will search for anything (client, invoice, delivery note, ...).
Is it possible to ...
0
votes
1answer
27 views
Searching for keywords in fulltext indexes using the “contains” function
Lets assume "and" is not a stopword, in my language it should not be.
How do I search for it using the contains function?
It is a keyword, but how do I escape the keywordness?
No luck with:
SELECT ...
1
vote
0answers
20 views
Fulltext search limiting users possibilities
We have a web site with a search box. The search uses a fulltext index column. However, we just cant feed the text the user has input into this stored procedure.
CREATE PROCEDURE [dbo].[SearchPages]
...
3
votes
0answers
41 views
Full-text search with german umlauts
I created a table using German (Germany) as the Full-text language, in the settings I tried setting accent sensitivity to both sensitive and insensitive. I, however, get following odd results.
The ...
1
vote
1answer
32 views
Updating an FTS indexed column returns “Invalid InnoDB FTS Doc ID”
Environment:
Ubuntu 12.04 (and 13.04)
MySQL 5.6.11
I have a table which has a full text index on it (real table has much more columns and rows):
DROP TABLE IF EXISTS articles;
CREATE TABLE ...
4
votes
1answer
56 views
How much data can SQL Server full text indexing handle?
I realize that the question is vague and it depends on hardware and our needs.
We currently have 5 million rows of data, a total of 5GB of data which we want to index using full text indexing. Our ...
2
votes
0answers
73 views
Why does GO affect my SELECT? [closed]
I am experiencing a very weird behaviour from the Management Studio GO.
I am following the full-Text Search tutorial and I run the following query over adventure works
SELECT ...
2
votes
1answer
59 views
Longest prefix search in Oracle
I have a list of phone number prefixes defined for large number of zones (in query defined by gvcode and cgi).
I need to efficiently find a longest prefix that matches given number PHONE_NR.
I use ...
3
votes
0answers
35 views
custom population of full text index
Is there any way to populate a full text search index without storing the backing information in the database?
I don't mean using remote-blob-storage or FILESTREAM types. The backing information is a ...
2
votes
1answer
34 views
Audit full text activity
I need to find when and which user created full text catalog, and who added/modified/deleted the columns (that were full text indexed) in that full text catalog.
0
votes
1answer
57 views
Can I use the database and query it while full-text indexing?
I need to index my database, but I need to query it while it is indexing, it may take a long time, can I do that?
2
votes
1answer
86 views
Reorganize full text catalog is offline or online?
I need to schedule a Full Text Search Maintenance and I was reading this link: http://msdn.microsoft.com/en-us/library/ms176095.aspx. Reading this documentation I am supposing that I need to ...
6
votes
1answer
89 views
BM25 (full-text search) implementation in SQL Server
I've hit a stump, while trying to implement the BM25 algorithm in SQL Server 2008 R2. I know that SQL Server includes the Full-Text Search option, which already implements a variant of BM25, but I ...
1
vote
1answer
77 views
Full-text search migration 2005 -> 2012 (.ndf file?)
So I'm trying to figure out the details for migrating from SQL Server 2005 to SQL Server 2012.
I tried to do restore and backup of a DB from 2005 to 2012. This worked well and for the text search ...
2
votes
0answers
26 views
Combining full-text-search queries
I have two tables in a SQL Server database with basic fulltext indexes:
CREATE FULLTEXT CATALOG table1_catalog;
CREATE FULLTEXT INDEX ON table1
(
name1
)
KEY INDEX pk_table1
ON ...
3
votes
2answers
66 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 ...
4
votes
1answer
39 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
117 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
61 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
46 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
50 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
175 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
37 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
88 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
39 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
79 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
143 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
83 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
61 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 ...
0
votes
1answer
31 views
Which text-index I should create for xooops engine to achieve better search results?
In one of projects we use xoops engine to manage content. In mysql slow query log most of queries are following :
SELECT p.uid,f.forum_id, p.topic_id, p.poster_name, p.post_time, f.forum_name, ...
1
vote
1answer
151 views
postgres GROUP BY and ORDER BY problem
I have two tables like this:
CREATE TABLE cmap5 (
name VARCHAR(2000),
lexemes TSQUERY
);
and
CREATE TABLE IF NOT EXISTS synonyms_all_gin_tsvcolumn (
cid int NOT NULL ...
0
votes
1answer
147 views
slow queries - set weight to token type in tsquery - postgresql
Postgresql version 9.2.3!
I'm working on a database for mapping of chemical names. My main table contains aprox 91 million records and it's indexed by gin. I want to query it with multiple names (I'm ...
1
vote
1answer
80 views
Avoiding performance hit from GROUP BY during FULLTEXT search?
Is there any clever way to avoid the performance hit from using group by during fulltext search?
SELECT p.topic_id, min(p.post_id)
FROM forum_posts AS p
WHERE MATCH (p.post_text) AGAINST ('baby ...
2
votes
1answer
60 views
Are there differences in performance of getting data between FullText Search and indexed columns
In SQL Server 2008 R2 I have a query which looks like
create stored procedure give_me_art @filter varchar(15),@skl_id int
begin
select
id,naziv,sifra,isnull(lager.kolicina,0) as lager
from art
...
0
votes
1answer
115 views
Why does MATCH() give Score 0, if there are less rows in the database?
I followed this example from the Mysql Documentation:
CREATE TABLE articles (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
title VARCHAR(200),
body TEXT,
FULLTEXT ...
1
vote
1answer
128 views
Installing Full Text Search on SQL Server 2008 R2 Express
I can't for the life of me install full text search on my SQL Server 2008 R2 instance.
Every installer I have tried shows me this:
I've tried:
SQLEXPRADV_x64_ENU.exe
SQLEXPRWT_x64_ENU.exe
...
1
vote
0answers
31 views
Fulltext indexes and issuers with server startup
I have a windows server for host about 4500 data bases for same application. And this application have 34 fulltext catalogs on it, and the CHANGE_TRACKING for this fulltext index are AUTO.
And the ...
2
votes
1answer
467 views
Using Solr/Lucene for searching non-text tables?
I am creating a web application to retrieve subsets of one large (4m rows) table. The 4m rows only change once a year. The table has 200+ columns of types boolean and numeric. It has no text columns.
...
2
votes
1answer
345 views
Privileges needed for Oracle Text
I'm new to Oracle Text and I am using it to support a search feature in an application I have written. The everything seems to be working correctly except I'm not happy with the fact that I had to ...
3
votes
2answers
195 views
Full Text Search With PostgreSQL
i have a table with this rows:
Stickers
------------------------------------------------------
ID | Title |Keywords (ts_vector)
------------------------------------------------------
...
3
votes
2answers
325 views
How to search for a specific column name in all the tables in MySQL Workbench?
In MySQL Workbench, is it possible to search for a specific column name in all the tables?
(Writing the string to look for in the field at the top right does nothing).
Thank you.
2
votes
0answers
39 views
improving this goal query
Goal
joining the two tables: tbl_quickSearchParam (fulltext search results) against tbl_product ( active products : prod_status = 1, group by prod_image_name)
create table tbl_product (
...
0
votes
1answer
281 views
Find fulltext indexes in SQL Server 2008
How do I find a list of tables that have a FULLTEXT INDEX applied to them on a given database?
For example, you can enable and disable a FULLTEXT INDEX like this:
ALTER FULLTEXT INDEX ON ...
