The InfoStoreNamesPostgres.properties file

The following properties are in the InfoStoreNamesPostgres.properties file.

ISSchema

The Information Store schema contains internal configuration information about the Information Store database.

By default, the value is IS_Core

MetadataSchema

The metadata schema contains objects that relate to the definitions of data structures in the Information Store.

By default, the value is IS_Meta

DataSchema

The data schema contains objects that store all the data that is available for analysis.

By default, the value is IS_Data

WebChartSchema

The web chart schema contains temporary objects used during manipulation of the web chart.

By default, the value is IS_WC

VisualQuerySchema

The visual query schema contains temporary objects used during visual query processing.

By default, the value is IS_Vq

FindPathSchema

The find path schema contains objects that support find path results.

By default, the value is IS_FP

StagingSchema

The staging schema contains temporary objects that support the ingestion process.

By default, the value is IS_Staging

PublicSchema

The public schema contains objects that represent a public API for the Information Store. It also contains procedures, tables, and views related to the deletion by rule feature.

By default, the value is IS_Public

DeletionByRuleRoleName

The deletion-by-rule role name.

By default, the value is Deletion_By_Rule

Collation_Locale

The (ICU) collation used for the Information Store in PostgreSQL. You can only change these settings before you create the Information Store database. If Collation_Deterministic is true, all operators are case- and accent-sensitive If Collation_Deterministic is false, "exact" operators follow the rules of the Collation_Locale the "like" operator is governed by Collation_Sensitivity Defaults to: en-US-u-ks-level1 and false (US English, case- and accent-insensitive)

By default, the value is en-US-u-ks-level1

Collation_Deterministic

By default, the value is false

Collation_Sensitivity

The case- and accent-sensitivity of the "like" operator when Collation_Deterministic is false Must be CIAI, CIAS, CSAI, or CSAS Defaults to: CIAI (case- and accent-insensitive)

By default, the value is CIAI

CollateClause

The collation used throughout columns in the Information Store in PostgreSQL. This setting defaults to 'COLLATE public.istore_collation'. It is required for correct sorting of text based columns when using a non-deterministic collation. If you plan on using a deterministic collation (such as a case-sensitive collation) then set this property to be empty.

By default, the value is COLLATE public.istore_collation

DatabaseTablespace

The default tablespace for the Information Store database.