This would go a long way to facilitate data warehousing type tasks http://code.google.com/p/googleappengine/issues/detail?id=112
add your star to support it :) On 06/05/2009, bruno.braga <bruno.br...@gmail.com> wrote: > > Hi Ryan, > > Thanks for the quick reply, and for clarifying this to me, even if > those are not good news to me. > > If complex reporting system is required, I think it is reasonable > enough to count on third-part solutions (even you own) to do that, and > do not get away from the purpose of GAE. I will think of something on > how to manage that on my end. > > Just a thought though, as this service spreads, more and more people > will require this kind of things, because it would just be so cool to > leave the reporting integrated in a single solution. > > Thinking about a third-party solution, we could also do something > stupid as downloading the datastore data (let's say, on a daily basis, > and only incremental to avoid spending all available quota on this), > processing all data mining required and uploading back to datastore. > Dirty, but sounds like a solution. > > Thanks anyway for your help! > > > On May 6, 3:12 am, ryan <ryanb+appeng...@google.com> wrote: > > hi bruno! thanks for the post, this is a great question. > > > > the short answer is that the datastore simply doesn't support data > > warehouse or data mining well. it's doable, but far from ideal, for > > the reasons you've mentioned. it's aimed at serving webapps, which > > it's good at, but not at ad hoc reports or queries. > > > > for use cases like counters, if they're needed for end user requests, > > we usually recommend updating them on writes, as you mentioned, but > > you're right that that doesn't work for the arbitrary number of > > reports or queries that data warehouses traditionally support, nor > > does it work for the ad hoc queries often needed for data mining and > > business intelligence. > > > > right now, if you need an industrial strength data warehouse, i'd > > recommend bulk downloading your data and using a third party solution. > > > -- Barry - www.nearby.org.uk - www.geograph.org.uk - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to google-appengine@googlegroups.com To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en -~----------~----~----~----~------~----~------~--~---