Why standard views are just aliases and how materialized views act as an ‘in-database cache’ to solve the cross-shard query problem.

Command Query Responsibility Segregation - why you might want separate models for reading and writing data. When it helps, when it’s overkill, and implementation patterns.