Table Connection Parameters

Given below are the parameters that you can specify for a table in a datagrid after you click the Add Table button.

Configuration

In the Configuration tab, you can specify the table name and define the fields.

A row of a table is associated with a name and a type.

To create a row, click .

The following table describes the fields in the Configuration tab of the Table shared resource:

Note: If you import a table, you cannot edit the table fields.

Field Module Property? Description
Name No Specifies a name for the Table shared resource.

The name must start with a letter or a digit and can include alphanumeric characters, "-", or "_".

The Table Fields panel includes the following fields:
Field Name No Specifies a field name. Choose column names that follow these rules for SQL identifiers.
  • Begin with a letter character.
    Note: ActiveSpaces® reserves column names that begin with an underscore character for internal use.
  • Subsequent characters can be letters, digits, or underscore characters.
  • Do not use SQL keywords as column names.
  • Column names are not case sensitive.
Field Type No Specifies a field type from the following options:

  • LONG
  • DOUBLE
  • STRING
  • DATETIME
  • OPAQUE

Key Definition

In the Key Definition tab, you must set at least one of the defined fields as the key field to make the table definition valid.

The following table describes the field in the Key Definition tab of the Table shared resource:

Field Module Property? Description
Key Field Names No Click to select the key fields.
Note: If the name of a field that is specified as a key is changed, you have to update the corresponding field name manually. Columns under key fields should be Long or String type.

Index Definition

In the Index Definition tab, you can select the defined fields as indexes to accelerate the filtering of data when processing queries. An index uses memory to locate matching records, which is faster than iterating through every record. This is optional.

To create an index, click .

The following table describes the fields in the Index Definition tab of the Table shared resource:

Field Description
Index Name Specifies the name of an index.

The index name is a string and must start with a letter or an underscore (_). The name can include any combination of letters and numbers.

Index Field Names Specifies the field names that are included in the index. You can create a composite index that includes more than one field.

Click to select the field names you want to be indexed.

Expiration Settings

In the Expiration Settings tab, you can select whether you want to enable expiration settings for the table. This is optional.

The following table describes the fields in the Expiration Settings tab of the Table shared resource:

Field Description
Time to Live (seconds) Specifies the time for which rows remain in the table.
Expiration Scan Period (seconds) Specifies the time interval at which the background job for deletion of expired rows is run.