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 |