Say you've been given a list of keywords, and you want to find every news item in the database that matches at least one of those keywords. This problem might occur if someone has selected (or typed in) a series of words and wants to do an "OR" search, that is: find all items that match word-one, or word-two, or word-three, etc.
Find Match In A Set
A Stopwords Module
In recent post I discussed the creation of a stopwords database. The next step was to create a more reusable perl module to access that database. This isn't terribly complex: essentially we just want to know if a particular word is in the database or not. We are, however, going to use an object oriented interface.
A Stopwords Database with SQLite
I'll be explaining how the On Perl search engine works in the next several posts but first a few preliminary items need to be addressed. The database I'm using is SQLite, and if you haven't heard of it yet, trust me, you soon will.