16 Oct 2018

Simple Database Design Rules

  1. Remove aggregated data from non-aggregated tables.
  2. Normalise and only denormalise with parent-keys (key enrichment)
  3. Consolidate new and small DB instances to a large DB instance in separate schemas
  4. Use DB Views for cross service data reading
  5. Use compound primary key when auto_inc id is not needed. 

No comments:

Post a Comment