2 Replies Latest reply on Feb 25, 2013 4:58 PM by Mircea Markus

    Maintaining the Integrity of Denormalised Data Automatically

    Peter Royle Newbie

      Are there any tools or techniques for automatically keeping denormalised data in sync when one instance is updated in one place and needs to be updated in several others?


      eg: An instance of Book might appear on a User's WishList, and also on a Bookshelf. In a relational DB you would store Book once and use FKs (normalised). In my very limited understanding of NoSQL, you either invent your own FK system, or store the same Book instance in both places (denormalised), and keep them up to date explicitly in the application code. (Sorry this is a bit of an entry-level, and not specifically infinispan question).


      I can imagine a tool might be able to do this housekeeping automatically, so wondering if there's anything existing? If not, is there a good reason why it can't be done that I'm unaware of?


      Cheers,  Pete R