Use software patterns and architectures that best support data access and storage patterns - Sustainability Pillar

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.

Recommendations

  • 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