Glossary:Column Populator

Column Populator, column populator

A utility that you can use for database and schema maintenance. Column Populator is a command-line script that allows you to update rows of database tables after database schema changes.

This utility can populate values for a new column that corresponds to a newly exposed property, expose values that were previously stored only in the Storage Stream (BLOB) column, and optionally rebuild database indexes and Index- instances that are defined by Declare Index rules.

A utility that you can use for database and schema maintenance. Column Populator is a command-line script that allows you to update rows of database tables after database schema changes. This utility can populate values for a new column that corresponds to a newly exposed property, expose values that were previously stored only in the Storage Stream (BLOB) column, and optionally rebuild database indexes and Index- instances that are defined by Declare Index rules.

A utility that you can use for database and schema maintenance. Column Populator is a command-line script that allows you to update rows of database tables after database schema changes. This utility can populate values for a new column that corresponds to a newly exposed property, expose values that were previously stored only in the Storage Stream (BLOB) column, and optionally rebuild database indexes and Index- instances that are defined by Declare Index rules.

A single-value property that is stored as a column in a database table, in addition to the Storage Stream BLOB, to enhance record selection operations in reporting. Exposed properties are also referred to as "optimized properties."

A column in a PegaRULES database table that contains property data in a compressed format. Most tables in the database contain a Storage Stream column, identified as the pzPVStream column.

A value that identifies one element (or member) of an aggregate data structure. These indexes are sometimes called subscripts. In addition, an index is a PegaRULES database feature that provides faster access and improved database performance. Use Declare Index rules to add and delete index objects.

The basic building blocks of an application, rules define the behavior of an application. There are many types of rules, each defining a different type of behavior. For example, rules define the display of a form, the fields that are used in your application, and the flows that define the process of completing work.

The system can reuse rules throughout your application. For example, in an application for ordering replacements parts, you can define a user interface to capture an address, and reuse the same rule for the UI to capture both the mailing address and the billing address for the order.

You define rules in an application to create a business solution for your organization and customers. Rules provide flexibility during the development process and help you design applications more efficiently, so that they can be implemented again in future projects.