NoSql Database Modelling Challenges

*Modelling Challenge: Related data

to embed or reference related data??

related data: embedding

Considerations:

1)data from entities are queried together

2)the child is a dependent e.g. order line depends on order

3)1:1 Relationship

4) similar volatility

5)the set of values or sub-documents is bounded(1:few)

Pros:Embedding data model gives you better read performance due to one round trip to database server

related data: reference

Considerations:

1)one to many relationship (unbounded)

2)many to many relationship

3)related data changes with differing volatility

4)referenced entity is a key entity used by many others.

Pros: Referencing provides better write performance.

* Modelling Challenges: Normalization vs De normalization

Normalization data :

a)saves your space but requires multiple reads

b)Provide faster write speed

Decriminalizing data:

a)Require multiple places updates

b)provide faster read speed

* Modelling Challenges: Homogeneous vs Heterogeneous collection