我想知道如果任何人有从一个EC2 Asp.Net应用程序执行在Amazon SimpleDB的关键字搜索的最佳途径的任何想法。

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.

一对夫妇的选择，我正在考虑是：

A couple options I am considering are:

1）添加关键字，以一个多值属性和搜索用类似这样的查询： 从keywordTable选择id其中关键词='firstword'交集关键字='secondword'交集关键字='thirdword

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'

亚马逊查询示例

2）创建一个web服务的前端，以凯塔：

2) Create a webservice frontend to Katta:

凯塔在EC2上

3）排队的周期性推动Lucene索引到云Lucene.Net更新服务。 （避开了锁定的问题）

3) A queued Lucene.Net update service that periodically pushes the Lucene index to the cloud. (to get around the 'locking' issue)

负载均衡的Lucene（计算器后）

的Lucene的S3（博客文章）

推荐答案

只是为了收拾这个问题......我们结束了用光速的SimpleDB提供商，Solr的和SolrNet通过编写自定义搜索提供程序的光速。

Just to tidy up this question... We wound up using Lightspeed's SimpleDB provider, Solr and SolrNet by writing a custom search provider for Lightspeed.

在实现ISearchEngine接口光速信息： http://www.mindscape.co.nz/blog/index.php/2009/02/25/lightspeed-writing-a-custom-search-engine/

Info on implementing ISearchEngine interface for Lightspeed: http://www.mindscape.co.nz/blog/index.php/2009/02/25/lightspeed-writing-a-custom-search-engine/

这是我们使用的是Solr的图书馆： HTTP：//$c$c.google.com/p/solrnet/

And this is the Solr Library we are using: http://code.google.com/p/solrnet/

由于Solr的可以使用EC2的机器很容易地扩展，这是最有意义给我们。

Since Solr can be easily scaled using EC2 machines, this made the most sense to us.