Best practices for data warehouse development - - Alibaba Cloud Documentation Center

This topic lists the best practices of typical data development scenarios. You can click any of the best practices listed below to view details.

Best practices

Develop a new real-time online data warehouse solution by using AnalyticDB for MySQL. For more information, see Generate report data periodically by using AnalyticDB for MySQL and DMS.
Archive data periodically by using Data Development. For more information, see Use data development to archive data.
Analyze data and generate daily, weekly, and monthly reports by using Data Development. For more information, see Create analysis reports.
Perform full data migration tasks at a scheduled time by using Data Transmission Service (DTS). For more information, see Periodically migrate data.
Use AnalyticDB for PostgreSQL instances as an example to describe how data warehouse development works. For more information, see Develop a data warehouse based on AnalyticDB for PostgreSQL.