> This is said because the datastore has cheap diskspace and there isn't > good support for joins here.
Actually, that's not why folks say denormalize on app engine. They say denormalize because the app engine infrastructure makes a lot of normalization difficult. That difficulty is a consequence of an architecture designed for absurd amounts of scalability and a "read mostly" assumption. Note that this is true regardless of the cost of doing the required multiple updates. There are applications that can't run on app engine because those updates take too long. (Some of that update cost is a consequence of the app engine consistency model, which also has costs and benefits.) Normalization is not a free lunch - the general cases have inherent costs. By supporting normalization only in very specific cases, app engine avoided paying those costs and got some benefits. If normalization is worth more to you than those other benefits, app engine is not for you. If those other benefits are worth more than normalization, app engine may be an option. On Sep 29, 3:48 am, clay <[email protected]> wrote: > This is said because the datastore has cheap diskspace and there isn't > good support for joins here. > > However, we'll "relearn" why normalization is good. > > Denormalization means that what would normally modify a single cell > will have to modify many rows. This isn't ideal in a relational > database, nor in the datastore. > > I wouldn't drink the "normalization isn't for the datastore" coolaid > too much. ;) > > On Sep 28, 6:06 pm, Wooble <[email protected]> wrote: > > > > > The datastore isn't a relational database, so articles about > > relational databases for the most part don't apply. > > > On Sep 28, 7:54 am, jerry ramphisa <[email protected]> wrote: > > > > Hi there, > > > > I hear normalizing the database is bad if you are using google > > > datastore. On other other hand, most articles mention people should > > > normalize databases, it doesn't matter what kind. > > > > Can someone give me light here.- Hide quoted text - > > > - Show quoted text -- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google App Engine" 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?hl=en -~----------~----~----~----~------~----~------~--~---
