title: Best way to keyword search Amazon SimpleDB using EC2 and Asp.Net?
body: <p>I am wondering if anyone has any thoughts on the best way to perform keyword searches on Amazon SimpleDB from an EC2 Asp.Net application.  </p>
  
  <p>A couple options I am considering are:</p>
  
  <p>1) Add keywords to a multi-value attribute and search with a query like:
  select id from keywordTable where keyword ='firstword' intersection keyword='secondword' intersection keyword = 'thirdword'</p>
  
  <p><a href="http://docs.amazonwebservices.com/AmazonSimpleDB/2007-11-07/DeveloperGuide/index.html?MultipleAttributeQueries.html" rel="nofollow noreferrer">Amazon Query Example</a></p>
  
  <p>2) Create a webservice frontend to Katta:</p>
  
  <p><a href="http://katta.sourceforge.net/documentation/running-katta-on-ec2" rel="nofollow noreferrer">Katta on EC2</a></p>
  
  <p>3) A queued Lucene.Net update service that periodically pushes the Lucene index to the cloud. (to get around the 'locking' issue)</p>
  
  <p><a href="https://stackoverflow.com/questions/304934/how-do-i-load-balance-lucene-net">Load balance Lucene(StackOverflow post)</a> </p>
  
  <p><a href="http://www.kimchy.org/lucene-and-amazon-s3/comment-page-1/" rel="nofollow noreferrer">Lucene on S3 (blog post)</a></p>