I am getting started with Meteor for an app I am working on. I have a data model which is quite normalised and for a few reasons I want to keep it normalised as much as possible. For doing reactive joins, I see two options: Using the https://github.com/englue/meteor-publish-composite package A…

Denormalisation is an optimization technic that brings its bunch of problems. I never use it unless I actually need to optimize. The two options you describe are fine. Choosing the right one depends on your project. Usually, I use client-side join (your second option) whenever possible (i.e. when I…

Hi Steve, I am curious about the situations when client side join would not be possible. Can we not always just publish the required data to the client? or are there some scenarios when doing that is not recommended?

in my experience, denormalization will only effectively work on 1 to many relationships in terms of data modeling.

[image] ayushchd: I am curious about the situations when client side join would not be possible. Can we not always just publish the required data to the client? or are there some scenarios when doing that is not recommended? Sometimes the required data is secret. For example, you might want…

Secret data is a valid reason for doing server side joins. But I hope you aren’t relying on keeping user ids secret, the ids generated by Mongo are predictable and should never be assumed to be secret. Make sure you always do proper authentication and authorization on resources and never rely on a …

fyi relying on joins may make your application less scalable. Maybe not an issue for you, but thought it should be mentioned. So the way I think about MongoDB is that if you take MySql, and change the data model from relational to document based, you get a lot of great features: embedded docs for …

normalizing documents in mongodb might be a bit like using Excel as a word processor Transitioning from Relational Databases to MongoDB - Data Models http://blog.mongodb.org/post/72874267152/transitioning-from-relational-databases-to-mongodb

@maxhodges : IMO the extracts you have copied are just marketing nonsense :- ) More clarification here: [image] What's wrong with just one collection? MongoDB Have you just said that graphs and hierarchical models are not relational?!! :- ) There is a confusio…

This should help clear is up. It’s really quite common to denormalize data in mongo. Without knowing the specifics of the data @ayushchd is trying to model, I can’t say much. But hearing that someone wants to keep their data as normalized as possible makes be wonder if they are mismatching RDBMS app…

I do understand the denormalised data model. However, in most real-world data, there is a fair degree of relation among the data points and denormalising everything is probably not the best way to go in all situations - given the redundancy and increased complexity of update operations. I personally…

Denormalisation vs reactive joins

help

Steve August 31, 2015, 4:47pm 9

@maxhodges: IMO the extracts you have copied are just marketing nonsense :- ) More clarification here: