title: Help with Search Engine Architecture .NET C#
body: <p>I'm trying to create a search engine for all literature (books, articles, etc), music, and videos relating to a particular spiritual group.  When a keyword is entered, I want to display a link to all the PDF articles where the keyword appears, and also all the music files and video files which are tagged with the keyword in question. The user should be able to filter it with information such as author/artist, place, date/time, etc.  When the user clicks on one of the results links (book names, for instance), they are taken to another page where snippets from that book everywhere the keyword is found are displayed.  </p>
  
  <p>I thought of using the Lucene library (or Searcharoo) to implement my PDF search, but I also need a database to tag all the other information so that results can be filtered by author/artist information, etc.  So I was thinking of having tables for Text, Music, and Videos, and a field containing the path to the file for each.  When a keyword is entered, I need to search the DB for music and video files, and also need to search the PDF's, and when a filter is applied, the music and video search is easy, but limiting the text search based on the filters is getting confusing.</p>
  
  <p>Is my approach correct?  Are there better ways to do this? Since the search content is limited only to the spiritual group, there is not an infinite number of items to search. I'd say about 100-500 books and 1000-5000 songs.  </p>