Summary
In this chapter, we dug deep into the data architecture and its potential pitfalls and mitigation strategies. Understanding why data skew happens helps us design better parent/child record ownership strategies. Also, understanding the way Salesforce uses indexes ensures that we can create reports, list views, and build queries that work with the constraints of the multi-tenant architecture nature of the platform, not against them. Due to this, we looked at LDV issues and mitigation strategies, understanding how concepts such as selective filter conditions and skinny tables can be used to ensure we can work with our large amounts of data effectively.
Next, we turned our attention to data archiving strategies and the various options we have at our disposal, ensuring that we are keeping to regulatory requirements for data retention and archival (if appropriate) and ensuring that we only use the data that is relevant to our users.
In Chapter 7, Data Migration, we’re...