I recently wrote a post called Data Denormalization Is Broken and am researching various systems that could implement a “denormalization engine”.
Would it be possible to define a projection to automatically update a value like User.numUnreadRooms shown in the post, which involves a nontrivial query?
I just looked into CouchDB, and unfortunately its MapReduce system lacks the expressive power to help me in this use case.
I’m more optimistic about Event Store but I’m not sure. I’ll appreciate if you guys can tell me whether it’s a feasible thing to hope for.