Repeat -> Review Data modeling Avoid relational database patterns, use one table Access patterns • Read Write Workloads • Query dimensions and aggregations • Nature of the app (OLTP, OLAP, DSS) • ER Model • Data Lifecycle (TTL, Backup) • Data Sources • Query aggregations • Document all workflows • 1 application service = 1 table • Identify primary keys • Define indexes for secondary access
patterns