The InfoStoreNamesPostgres.properties file

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

By default, the value is IS_Core

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

By default, the value is IS_Meta

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

By default, the value is IS_Data

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

By default, the value is IS_WC

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

By default, the value is IS_Vq

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

By default, the value is IS_FP

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

By default, the value is IS_Staging

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

The deletion-by-rule role name.

By default, the value is Deletion_By_Rule

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

By default, the values are false and en-US-u-ks-level1 (US English, case- and accent-insensitive).

The case- and accent-sensitivity of the "like" operator when Collation_Deterministic is false. The value must be one of CIAI, CIAS, CSAI, or CSAS.

By default, the value is CIAI (case- and accent-insensitive).

The collation used throughout columns in the Information Store in PostgreSQL. This setting is required for correct sorting of text-based columns when using non-deterministic collation. If you plan to use deterministic collation (such as case-sensitive collation), set this property to be empty.

By default, the value is COLLATE public.istore_collation.

The default tablespace for the Information Store database. This tablespace, like all the others, must be present in the PostgreSQL cluster before the database is created.

By default, the value is pg_default.

The tablespace for big data tables.

By default, the value is pg_default.

The tablespace for indexes on big data tables.

By default, the value is pg_default.

The tablespace for small data tables.

By default, the value is pg_default.

The tablespace for indexes on small data tables.

By default, the value is pg_default.