Implementing Columnar Tables

Use this procedure to implement columnar tables. The procedure consists of two main parts. The first part, defining and running a data replication set for the business class for the columnar table, is always required. The second part, editing the LPL for the list that you want to have a columnar view in, is needed if the application does not already define the list with that.

The first time a Replication Set is created it will create a new columnar table in the format: <BusClass>_C. Subsequent replications will update that existing table. However, please note that resetting a columnar replication set will cause the next replication to truncate and rebuild that table, starting over from scratch.

When a list that is defined to implement a columnar view is accessed, it will attempt to query data from the table named <BusClass>_C. If no replication set for that business class exists or has never been run, an error will be shown asking for the user to create and/or run a columnar replication set.

  1. To define the and run the required replication set, see the general instructions in Creating replication sets. The key points for defining a replication set for a columnar table is that the Export Format must be Columnar and the replication set must contain all of the fields that are on the list that will use the columnar table. All field types supported in ordinary data replication are supported in columnar replications except for CLOBs.
  2. If the LPL for the list that you want to have a columnar view in does not already implement a columnar view, access the list's LPL in the Configuration Console and add "implements ColumnarView" to the list definition. For more information, see the Configuration Console User Guide.