SUS03-BP05 Use software patterns and architectures that best
support data access and storage patterns
Understand how data is used within your workload, consumed by your users, transferred, and stored. Select technologies to minimize data processing and storage requirements.
Level of risk exposed if this best practice is not established: Low
Implementation guidance
-
Analyze your data access and storage patterns.
-
Store data files in efficient file formats such as Parquet to prevent unnecessary processing (for example, when running analytics) and to reduce the total storage provisioned.
-
Use technologies that work natively with compressed data.
-
Use the database engine that best supports your dominant query pattern.
-
Manage your database indexes to ensure index designs support efficient query execution.
-
Select network protocols that reduce the amount of network capacity consumed.
Resources
Related documents:
Related videos: