Hi I'm similarly trying to implement faceted/attribute search with Google App Engine for blog entries (months, tags facets) and products (product attributes, category, price facets).
My current approach, but I've not done too complex examples, is to return broad result sets from the datastore (filtered simply by a single root category or isPublished boolean type field), or even the complete set of products/posts and memcache the results. Then have a querying/indexing layer that takes a user query and applies ordering/ filtering/paging against this cached dataset and in memory use Google Collections with a Multiset to calculate on demand the sets/groupings and counts for each facet, like price. It's pretty custom, as each facet like price and label/category stored as different field types require different processing to know which value to add to the set. http://google-collections.googlecode.com/svn/trunk/javadoc/index.html?com/google/common/collect/Multiset.html http://www.scribd.com/doc/14283136/Using-the-Google-Collections-Library-for-Java Then for common collections of facets, again memcaching the stats for how many results following a user request or following a scheduled task. My other reason for liking Google Collections as a base for some of this processing is using Maps.uniqueIndex(values, keyFunction) to save the initial resultset in memcache with keys pre-processed to quickly return individual records for details pages. Or iterate the full map in the above indexing layer. I'd certainly be interested on other's thoughts on reusable and scalable approaches. Andy On Dec 12, 1:36 pm, gopoto <[email protected]> wrote: > Hi, > > I try to develop an eCommerce solution on GAE for Java. The solution > has to manage up to 100 000 products. Customers can search by > different ways like by theme, category, brand, price as you can do for > example with Amazon. > > I have some difficulties to find a good way to implement the fact that > I want to show the number of products in each sort of filters in > fonction of the current choice of the customer: for ex, the customer > has choosen to see all the products like toys, with price between 10 > and 30 $ and I want to display how many toys in each brands and each > themes fit the filters. > > I don't know how to implement such a fonctionnality on top of the > Google App Engine Datastore. > > An idea ? > > Philippe -- You received this message because you are subscribed to the Google Groups "Google App Engine for Java" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en.
