All Products
Search
Document Center

Best practices of data warehouse development

Last Updated: Jun 29, 2020

This topic collects the best practices of typical data development scenarios. You can find required information in a scenario that suits your business needs.

  1. Use AnalyticDB for MySQL and DMS to generate reports on a regular basis: This topic describes how to build a real-time online data warehouse based on AnalyticDB for MySQL.

  2. Use data development to archive data: This topic describes how to use the data development feature to periodically archive and manage data.

  3. Report analysis: This topic describes how to use the data development feature to analyze data and generate daily, weekly, or monthly reports for typical scenarios.

  4. Periodic data migration: This topic describes how to use Data Transmission Service (DTS) to schedule and manage tasks for full data migration.

  5. Develop a data warehouse based on AnalyticDB for PostgreSQL: This topic gets you started with data warehouse development based on AnalyticDB for PostgreSQL.