Tagging Keywords in Articles Stored in RDB

[timand]

I am getting ready to design a system that can update news articles that are stored in a relational database. I would like to use a list of company names. Then I would like to find these company names within each article in the db, and update the record by adding hypertext links around those company names.

I am getting ready to do a brute force looping and searching system. I was wondering if anyone knows of articles or books that might lead me to a more elegant solution?

Thanks!

 

[jtm111]

I don't have an exact answer to your question because I do not practice in the area, but I recommend you get a good text book on Information Retrieval. As far as I know there are three methodologies for storing, accessing, and updating large document databases for fast retrieval: lexicographical such as the inverted file, clustering, and hashing.

I recommend a very good book by William Frakes and Ricardo Baeza-Yates: Information Retrieval, Data Structures and Algorithms. ISBN: 0-13-463837-9. If you are really interested in optimizing your solution, I would strongly recommend getting grounded in standard IR theories. You won't regret it.