Columnar tables implementation

Implementing columnar tables includes these actions:
  • Required: Define and run a data replication set for the business class associated with the columnar table.
  • Optional: Edit the LPL for the list that should display a columnar view, if the application does not already define the list with that
A replication set created for the first time creates a new columnar table named using these formats:
  • <BusClass>_C - for tables created from current business class data.
  • <BusClass>_CA - for tables created for the audit log entries of a business class.
  • <BusClass>_CV - for tables created from current business class data and with the columnar variation pattern.
  • <BusClass>_CAV - for tables created for the audit log entries of a business class and with the columnar variation pattern.

Subsequent replications update those existing tables but note that resetting a columnar replication set results in the table being dropped and then rebuilt starting over from scratch.

When a list is accessed that is defined to implement a columnar view, it automatically accesses the latest variation of the table. If no replication set exists for the business class or has never been run, an error is shown asking for the user to create or run a columnar replication set, or both.

External views need to query the appropriate columnar table and use the last variation ID for the current record when data is replicated using the columnar variation pattern.

To define and run the required replication set, ensure the Export Format is set to Columnar and contains all the fields on the list that use the columnar table. All field types supported in ordinary data replication are supported in columnar replications except for CLOBs. For audit log entry replication, use audit fields.

See Creating replication sets.

If the LPL for the list intended to display a columnar view does not already implement one, access the list's LPL in the Configuration Console and add implements ColumnarView to the listdefinition. For an audit list, the LPL definition must define the list as is an AuditList..