Hybrid data storage model (pzPVStream BLOB)
Most columns in the database schema correspond to scalar properties of property mode
Single Value. The column name is the same as the property name. These columns are known as exposed columns.
For example, the
column is the primary key of every table, which corresponds to the value of the
property, present in every instance of every class. Similarly, the column named
table corresponds to the property
Properties of many
property types, including
Decimal, correspond to string (VARCHAR) database data types. Properties of mode
can be stored as NUMBER database data types. Techniques for storing
property values differ by database vendor.
Values of properties with a mode other than
(such as mode
) are stored in a special column named
pzPVStream. This column is known as the Storage Stream and has a BLOB
(Binary Large Object) data type.
The size of the Storage Stream values can have a significant effect on memory demand, network traffic, and overall performance. To help detect and address issues related to the BLOB size, multiple types of alerts (PEGA0004, PEGA0025, PEGA0039, and PEGA0040) monitor database activity and report exceptional conditions involving Storage Stream values.
You can set up data compression for the BLOB column by using the
setting in the prconfig.xml file or Dynamic System
Settings. When enabled, compression and decompression occur on the
server using the
class. See the
How to compress BLOB values in the PegaRULES database.