Reports databases
In some situations, executing reports may impact performance because of the high demand on database processing. To reduce the performance impact of running reports, you can specify that some reports obtain data from a separate reports database (known as an alternate database), which is a copy of all or part of the PegaDATA database schema.
The separate database can contain only a subset of the tables in the PegaDATA database schema. Only those tables used by a report definition using the "Prefer reporting data source if defined" option in the "Reporting database" field need to be mirrored in the separate database. The tables in the separate reports database typically have a similar structure as the PegaDATA database schema. This approach offloads the demand of the production database to the replicated database. Mirroring of the data in the tables of the separate database schema is configured using the database vendor's functionality.
Important Considerations
As a lead system architect (LSA), you need to remember the following points while using a reports database:
- The system does not automatically create the tables in a reports database, you need to work with a database administrator to create the reports database and identifying the tables, indexes, and views to include.
- The system does not sync between the reports database and the regular PegaDATA database, so you need to work with a database administrator to set up database replication, which uses a mirroring technique.
- Data pulled out from the report may not contain real-time data. The inclusion of real-time data depends on the mirroring technique that the system uses to sync between the reports database and the regular PegaDATA database.
Whether or not you select the Prefer reporting source if defined option on the Data access tab in one or more report definition rule forms, you can prevent reports from using the reports database by adding the following entry to your prconfig.xml file:
<env name = "database/useReportingDatabase" value="false" />
For more information about how to configure a reports database, see Specifying a data source for reports.
This Topic is available in the following Module:
Want to help us improve this content?