Explaining Data Modeling Concepts and Their Impact on the Database’s Design

Standard Salesforce objects are normalized. They store data efficiently in tables with relationships that minimize redundancy and ensure data integrity.

You can create custom objects that are normalized or denormalized. Due to the nature of Salesforce objects, you can use patterns that are considered sub-optimal in typical database systems, such as defining objects with a huge number of fields.

Records in Salesforce consume around 2 KB of data storage, regardless of the number of fields/columns (with few exceptions). Creating a denormalized object to store aggregated data is one of the LDV mitigation strategies you can use. It is considered a special case of data archiving.

Note

For more details about normalized and denormalized datasets, review Chapter 2, Core Architectural Concepts: Data Life Cycle.

In addition to that, you need to become familiar with data skew. Salesforce utilizes...