Skip to main content


         This documentation site is for previous versions. Visit our new documentation site for current releases.      
 

Understanding the database structure

Updated on July 8, 2022

The Pega Platform database and the tables within it are structured in a unique way. By understanding how the database is structured, you are better able to support system updates and to be responsive to changes in data utilization.

To use other databases in your Pega application to accomplish your workflows, see Creating database data instances

  • Connection pool settings

    Pega Platform is an application requiring a high database connection request and return rate. In Pega Cloud environments, Pega manages the connection pool settings across the fleet of systems that are appropriate for the range of client’s business needs, based on our experience. Pega Cloud clients cannot change or request changes to the default configuration.

  • Custom connection properties required for disaster recovery

    To maintain the stability of your Pega application in the case of a network or database outage, your application must have an appropriate recovery time to clean up broken connection sockets caused by the outage.

  • Database tables and views

    You can make changes to database tables to support your Pega Platform needs. Because Data-Admin-DB-Table and Data-Admin-DB-Name instances control how the Pega Platform finds objects within the Pega Platform database, changes to the database table structure must be coordinated with changes to these data instances.

  • Database naming conventions

    When the Pega Platform database is initially installed, object names follow specific naming conventions. Tables and view that you add do not have to follow these conventions.

  • Split database architecture

    Pega Platform high availability is database-agnostic. The recommended database features are:

  • Java user-defined functions in your Pega database

    Beginning in Pega Platform version 8.6, Pega deprecated usage of the Java user-defined functions (UDFs) due to their severe performance impact. In a future release of Pega Platform, Pega will no longer support Java UDFs for on-premises deployments.

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us