Information Store database properties

The Information Store database properties files specify the names and details of database objects that are used in the Information Store. There are separate files for IBM® Db2®, Microsoft® SQL Server, and PostgreSQL.

The InfoStoreNamesDb2.properties, InfoStoreNamesSQLServer.properties, and InfoStoreNamesPostgres.properties files are in the toolkit\configuration\fragments\opal-services-is\WEB-INF\classes directory.

The settings in these files control the following database objects:

  • The names of the database schemas

  • The name of the deletion by rule role

  • The collation sequence

  • For Db2, the page size

  • For Db2, the names of the buffer pools

  • For SQL Server, the logical names and locations of the filegroup files

Note: If you change the values for any of the settings after the Information Store is created, you must either manually change the names of the database objects in your database management system or re-create the database.

Settings for Db2, SQL Server, and PostgreSQL

The InfoStoreNamesDb2.properties, InfoStoreNamesSQLServer.properties, and InfoStoreNamesPostgres.properties files contain the following settings:

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

The collation sequence used for the Information Store. You can only change this setting before you create the Information Store database. Defaults to CLDR181_LEN_S1 for Db2 and Latin1_General_100_CI_AI_SC for SQL Server.

Note: For PostgreSQL, collation works a little differently and there are three settings instead of one. For more information, see The InfoStoreNamesPostgres.properties file.