Extended Reference Pattern

• Joins are expensive
• so store some must have data into the child to avoid joins.
• This creates data duplicate, yes, but it's an expense we can pay in exchange for performance.
• Duplicated data should not change frequently in nature.
• If data needs to be updated, int most cases real-time update is not necessary, so period data sync is more than enough.