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.

Fortgeschritten

Englisch

Nach Abschluss dieses Moduls können Sie Folgendes:

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.

In der folgenden Mission verfügbar:

Infrastructure and Architecture v1

Themen

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.

Modulquiz

25 Min.