The InfoStoreNamesPostgres.properties file

The following properties are in the InfoStoreNamesPostgres.properties file:

Property

Description

Default value

ISSchema

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

IS_Core

MetadataSchema

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

IS_Meta

DataSchema

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

IS_Data

WebChartSchema

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

IS_WC

VisualQuerySchema

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

IS_Vq

FindPathSchema

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

IS_FP

StagingSchema

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

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.

IS_Public

DeletionByRuleRoleName

The deletion-by-rule role name.

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)

en-US-u-ks-level1

Collation_Deterministic

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)

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.

COLLATE public.istore_collation

DatabaseTablespace

The default tablespace for the Information Store database.

pg_default

BigDataTablespace

The tablespace for big data tables.

pg_default

BigIndexTablespace

The tablespace for indexes on big data tables.

pg_default

SmallDataTablespace

The tablespace for small data tables.

pg_default

SmallIndexTablespace

The tablespace for indexes on small data tables.

pg_default