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.

Advanced

Inglês

Depois de concluir este módulo, você deverá ser capaz de:

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.

Disponível na seguinte missão:

Infrastructure and Architecture v1

Tópicos

Inclusive and exclusive queries

30 min

Queries based on generated or reformatted data

30 min

SQL functions

30 min

Reports and performance

10 min

Configuring rules to improve report performance 

25 min

Database tuning to improve report performance

20 min

Reports databases

10 min

Aggregated data

10 min

Basics of the Common Data Model

10 min

Class structure of the Common Data Model

10 min

Designing enterprise data access with Pega Live Data

10 min

Quiz do módulo

25 min