Stack Overflow
Stack Overflow

Questions tagged [full-text-indexing]

indexing for full-text search

569 questions
5
votes
2 answers

Cannot get right results from postgre full-text search

I'm developing a simple articles website in brazilian portuguese language. The search feature is based on a full-text search, but it isn't returning expected results. I made this on postgresql. Here is the simplified table: Artigos -id -title --…
Davis Peixoto
  • 5,695
  • 2
  • 23
  • 35
5
votes
0 answers

oracle cat index throws invalid sql name exception

We recently upgraded our database to Oracle 12c and since then it throws ORA-44003: invalid sql name exception while inserting on a table which has cat index. We only have cat index on one column, which was working fine with Oracle 11g. The…
mersen
  • 51
  • 3
5
votes
3 answers

How to get frequently occurring phrases with Lucene

I would like to get some frequently occurring phrases with Lucene. I am getting some information from TXT files, and I am losing a lot of context for not having information for phrases e.g. "information retrieval" is indexed as two separate…
Julia
  • 1,217
  • 8
  • 23
  • 46
5
votes
5 answers

Tell me SQL Server Full-Text searcher is crazy, not me

i have some customers with a particular address that the user is searching for: 123 generic way There are 5 rows in the database that match: ResidentialAddress1 ============================= 123 GENERIC WAY 123 GENERIC WAY 123 GENERIC WAY 123…
Ian Boyd
  • 246,734
  • 253
  • 869
  • 1,219
5
votes
2 answers

What is the difference between FULLTEXT and FULLTEXT KEY/INDEX?

MySQL documentations gives this format for creating a FULLTEXT index: | {FULLTEXT|SPATIAL} [INDEX|KEY] [index_name] (index_col_name,...) [index_option] To implement full-text search with MySQL you can either create index by writing : CREATE…
simo
  • 290
  • 8
  • 24
5
votes
3 answers

How to setup Lucene/Solr for a B2B web app?

Given: 1 database per client (business customer) 5000 clients Clients have between 2 to 2000 users (avg is ~100 users/client) 100k to 10 million records per database Users need to search those records often (it's the best way to navigate their…
Bill Paetzke
  • 13,332
  • 6
  • 44
  • 46
5
votes
1 answer

postgresql. full text search for queries with misprints

Is it possible to implement full text search using postgresql when queries can be with misprints? I couldn't find it in manual.
varan
  • 795
  • 2
  • 10
  • 29
5
votes
2 answers

ms sql - why does GO affect my select (Free Text Search)

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 FT_TBL.ProductDescriptionID, FT_TBL.Description, KEY_TBL.RANK FROM…
Bick
  • 17,833
  • 52
  • 146
  • 251
4
votes
2 answers

MySQL MATCH AGAINST when searching e-mail addresses

I am writing a newsletter script and I need to implement searching in the addresses. I indexed the table with FULLTEXT but when I do a query such as: SELECT * FROM addresses WHERE MATCH(email) AGAINST("name@example.com" IN BOOLEAN MODE) I get…
Vladimir
  • 818
  • 5
  • 13
4
votes
5 answers

Determining the Similarity Between Items in a Database

We have a database with hundreds of millions of records of log data. We're attempting to 'group' this log data as being likely to be of the same nature as other entries in the log database. For instance: Record X may contain a log entry…
Dan
  • 3,389
  • 5
  • 34
  • 44
4
votes
2 answers

Not indexing parts of HTML

Is there any method for limiting the indexing of HTML to increase the page content relevancy? E.g. excluding menus, etc. from robots. I remember seeing some special tags for this long time ago, but I couldn't find the information anymore. How does…
Mikko Ohtamaa
  • 82,057
  • 50
  • 264
  • 435
4
votes
2 answers

How to use ts_headline() in PostgreSQL while doing efficient full-text search? Comparing two query plans

I am experimenting with a full-text search system over my PostgreSQL database, where I am using tsvectors with ts_rank() to pull out relevant items to a user search query. In general this works really fantastic as a simple solution (i.e. no major…
Jason
  • 14,517
  • 25
  • 92
  • 153
4
votes
0 answers

Springboot query MongoDb Atlas search index

I have a MongoDb that has a collection of cars which includes fields like: price: "49,500" brand: "Mercedes-benz", model: "E 400d" power: "340 PS" engine: "2995 cmc" etc. On my Springboot backend I want to create and endpoint which will return…
user17941323
  • 51
  • 1
4
votes
3 answers

Should I use Lucene.Net for full text search with SQL Compact Edition 4, or is there a better option?

I'm trying to create a full text search facility for a small blog which is running against a SQL Compact Edition 4 database. There seems to be almost no information out there about this (though I'd be happy if someone can prove me wrong), but as…
Mark Bell
  • 28,985
  • 26
  • 118
  • 145
4
votes
2 answers

How do I keep a MySQL Fulltext Index up to date?

Creating an index MySQL After I have added the FULLTEXT index, how do I keep it up to date? Added it this way : ALTER TABLE search_index ADD FULLTEXT(si_fulltext) Tried to update it like this : ALTER TABLE search_index MODIFY…
JoeyH
  • 335
  • 2
  • 10
1 2 3
…
37 38