Reporting data architecture and performance optimization

This module focuses on architecting scalable and high‑performing reporting solutions in Pega applications. You learn how data modeling, query design, aggregation strategies, and reporting architectures influence system performance and scalability, and how to apply design patterns that improve reporting efficiency. You explore how Pega Platform™ generates SQL for reports, how query and aggregation choices impact performance, and how to use structures such as the Pega Common Application and reporting databases to support reusable, optimized reporting data architectures. The module emphasizes performance optimization and alignment with Pega Platform and database best practices.

上級

英語

このモジュールを完了したら、以下の目的を達成できるようになります。

Evaluate data modeling and reporting architecture impacts on performance and scalability.

Design efficient queries for reporting data retrieval and aggregation.

Apply the Common Application for standardized and reusable reporting structures.

Optimize report and database performance using rule‑ and database‑level techniques.

Align reporting designs with Pega Platform and database best practices.

このモジュールは、下記のミッションにも含まれています。

Infrastructure and Architecture v1

トピック

Inclusive and exclusive queries

30 分

Queries based on generated or reformatted data

30 分

SQL functions

30 分

Reports and performance

10 分

Configuring rules to improve report performance 

25 分

Database tuning to improve report performance

20 分

Reports databases

10 分

Aggregated data

10 分

Basics of the Common Data Model

10 分

Class structure of the Common Data Model

10 分

Designing enterprise data access with Pega Live Data

10 分

モジュールクイズ

25 分