"No one is harder on a talented person than the person themselves" - Linda Wilkinson ; "Trust your guts and don't follow the herd" ; "Validate direction not destination" ;

July 12, 2019

Data Modelling for Workloads

  • Denormalized way to suit query patterns
  • Data Properties - Concurrent writes 
  • Metadata - No continuous updates (Just store data, no update involved)
  • Indexes - Single Field, Multikey indexes, Text Indexes, Column Store Indexes
  • Sharding - Shardkey could be location_id (Distributed Storage)
  • Data Partitioning
  • Timeseries Info aggregation in storage level (NoSQL)
  • JSON Modelling - Collections in MongoDB, Establishing Hierarchy and Relationships
Happy Learning!!!

No comments: