What is a good stopword in full text indexation?

Posted by Benoit on Programmers See other posts from Programmers or by Benoit
Published on 2011-02-04T13:19:48Z Indexed on 2011/02/04 15:33 UTC
Read the original article Hit count: 334

Filed under:

indexation

|

stopword

When you go to the Appendix D in Oracle Text Reference they provide lists of stopwords used by Oracle Text when indexing table contents.

When I see the English list, nothing puzzles me. But the reason why the French list includes moyennant (French for in view of which) for example is unclear. Oracle has probably thought it through more than once before including it.

How would you constitute a list of appropriate stopwords if you were to design an indexer?

© Programmers or respective owner

Related posts about indexation

What is a good stopword in full text indexation?

as seen on Programmers - Search for 'Programmers'
When you go to the Appendix D in Oracle Text Reference they provide lists of stopwords used by Oracle Text when indexing table contents. When I see the English list, nothing puzzles me. But the reason why the French list includes moyennant (French for in view of which) for example is unclear. Oracle… >>> More
NoSQL : JSON, indexation distribuée et géoréplication débarquent dans Couchbase, le concurrent de MongoDB

as seen on Developper.com - Search for 'Developper.com'
Base de données NoSQL : documents JSON, indexation distribuée et géoréplication débarquent dans Couchbase Le concurrent de MongoDB Couchbase Server, le système de gestion de bases de données NoSQL, vient de subir une mise à jour assez importante. La version 2.0 de Couchbase introduit un modèle… >>> More
Tutoriel OpenGL Moderne : indexation VBO, optimisez vos tampons GPU en OpenGL 3 et supérieur

as seen on Developper.com - Search for 'Developper.com'
Bonjour à tous,La rubrique 2D/3D/Jeux est heureuse de vous présenter une la suite de la série de tutoriels consacrée à OpenGL moderne (les versions à partir d'OpenGL 3.3). Ces tutoriels vous permettront d'intégrer facilement les nouveaux concepts d'OpenGL afin de profiter au maximum des dernières… >>> More
Prevent azure subdomain indexation

as seen on Pro Webmasters - Search for 'Pro Webmasters'
Let me explain my situation, I have an azure website (with azurewebsites.net sub domain), and a custom domain.com, built with asp.net MVC Both are being indexed by Google, but I've noticed the custom domain is being penalized and it doesn't show up in results, it only shows when I search for "site:domain… >>> More
Le moteur de recherche Google utilisé pour des injections SQL, un expert en sécurité présente un scénario d'attaque

as seen on Developper.com - Search for 'Developper.com'
Le moteur de recherche Google utilisé pour des injections SQL un expert en sécurité présente un scénario d'attaque Les pirates ne manquent pas d'idées pour parvenir à leur fin. Les robots d'indexation du moteur Google auraient été exploités par certains pour effectuer des attaques par injection… >>> More

Related posts about stopword

What is a good stopword in full text indexation?

as seen on Programmers - Search for 'Programmers'
When you go to the Appendix D in Oracle Text Reference they provide lists of stopwords used by Oracle Text when indexing table contents. When I see the English list, nothing puzzles me. But the reason why the French list includes moyennant (French for in view of which) for example is unclear. Oracle… >>> More
Custom StopWord List In SQL Server 2005 Full-Text-Search

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there anyway to add some custom stop words to SQL Server 2005? >>> More
Filter items from a feed using words in a text file, with Yahoo Pipes

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a pipe that filters an RSS feed and removes any item that contains "stopwords" that I've chosen. Currently I've manually created a filter for each stopword in the pipe editor, but the more logical way is to read these from a file. I've figured out how to read the stopwords out of the text file… >>> More
Yahoo Pipes: filter items in a feed based on words in a text file

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a pipe that filters an RSS feed and removes any item that contains "stopwords" that I've chosen. Currently I've manually created a filter for each stopword in the pipe editor, but the more logical way is to read these from a file. I've figured out how to read the stopwords out of the text file… >>> More
ft_stopword_file not picked up

as seen on Server Fault - Search for 'Server Fault'
I have a VPS server with a company called Webfusion. I want to remove some or all of the FULLTEXT stopwords because some specific words needs to be searchable with my DB content. I opened /etc/mysql/my.cnf and added the line ft_stopword_file="". I restarted the mysql service, ran a repair table and… >>> More