How to create a cache object

1	Choose File→New→Cache Object.

2	In Choose a Cache DCD, select the cache connection definition for the appropriate cache database, as shown in Figure 4-3. Choose Next.

Figure 4-3

Selecting a cache connection definition

3	In Choose an object to cache, select the map or information object you want to cache, as shown in Figure 4-4. Choose Next.

Figure 4-4

Selecting an information object

4	In Choose a name, type a name for the cache object, as shown in Figure 4-5. Choose Finish.

Figure 4-5

Typing a name for the cache object

5	In Columns:

In Default table name, type the default name for the cache table, as shown in Figure 4-6. You can override the default when you activate the cache object using Management Console.

In Name, type the names for the columns in the cache table.

Figure 4-6

Specifying cache table and column names

Choose Optimization.

6	In Optimization:

To define a primary key, in Define primary key (optional):

In Available Columns, select the appropriate column(s).

Choose > to move the column(s) to Columns in Primary Key, as shown in Figure 4-7.

Figure 4-7

Defining a primary key

To define an index, in Define table indices (optional):

Choose Add.

In New Index, type a name for the index. Choose OK.

In Available Columns, select the appropriate column(s).

Choose > to move the column(s) to Columns in Index, as shown in Figure 4-8.

Figure 4-8

Defining an index

Choose Updates.

7	In Updates:

In Post-cache replacement DDL statements (optional), type the DDL statements, as shown in Figure 4-9.

Figure 4-9

Typing DDL statements

In Update column, choose an update column from the drop-down list.

Choose Use column as filter or Use column as parameter into data source. If you choose Use column as parameter into data source, browse to the appropriate map or information object, as shown in Figure 4-10.

Figure 4-10

Specifying an incremental update method

You specify automatic cache replacement or incremental cache update when you schedule the cache job using Management Console.

 

 

Copyright Actuate Corporation 2012