William, Could you explain how the update can be enormous with demoralized table? My understanding is a flat table is easier to update that normalized one.
Thanks. On Aug 5, 2011 1:36 PM, "Ikai Lan (Google)" <ika...@google.com> wrote: > Why isn't denormalization a real option? A lot of companies denormalize with > great success, including Google. > > The thing about joins is this: they have to happen at some point in memory. > Datastore or local instance. > > -- > Ikai Lan > Developer Programs Engineer, Google App Engine > plus.ikailan.com | twitter.com/ikai > > > > On Thu, Aug 4, 2011 at 6:00 PM, William Levesque <billleves...@gmail.com >wrote: > >> Alright, so I've spent a lot of time contemplating this whole BigTable >> isn't relational limitation. I've tried two techniques for joining >> different tables. The solution described here... >> >> http://gae-java-persistence.**blogspot.com/2010/03/** >> executing-simple-joins-across-**owned.html?showComment=**1298589845909#** >> c7562859098617623831< http://gae-java-persistence.blogspot.com/2010/03/executing-simple-joins-across-owned.html?showComment=1298589845909#c7562859098617623831 > >> >> and joining with loops inside my code. The former eats a lot of CPU, the >> latter is just silly. Denormalizing isn't a real option. There are very >> good reasons normalization was developed. >> >> So I'm trying to get a definitive strategy from Google that is considered >> the best way to support a system with complex data relationships. I >> appreciate your help. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Google App Engine for Java" group. >> To view this discussion on the web visit >> https://groups.google.com/d/msg/google-appengine-java/-/UCYoAoRaI6QJ. >> To post to this group, send email to >> google-appengine-java@googlegroups.com. >> To unsubscribe from this group, send email to >> google-appengine-java+unsubscr...@googlegroups.com. >> For more options, visit this group at >> http://groups.google.com/group/google-appengine-java?hl=en. >> > > -- > 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 google-appengine-java@googlegroups.com. > To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.com. > For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en. > -- 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 google-appengine-java@googlegroups.com. To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en.
