The InfoStoreNamesSQLServer.properties file
The following properties are in the InfoStoreNamesSQLServer.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 | The collation sequence used for the Information Store in SQL Server. You can only change this setting before you create the Information Store database. Defaults to Latin1_General_100_CI_AI_SC. | Latin1_General_100_CI_AI_SC |
PrimaryName | The SQL Server database primary data file contains the startup and configuration information for the Information Store database. The logical name of the primary data file. | IStore_System_Data |
PrimaryFilename | The filename or absolute path for the primary data file. | IStore-p1.mdf |
UserTableName | The user table filegroup contains all the tables and data for the Information Store database. The logical name of the user table in the user table filegroup. | User_Table_Data |
UserTableFilename | The filename or absolute path for the user table file. | IStore-ut1.ndf |
IndexName | The index filegroup contains the indexes for the Information Store database. The logical name of the index file. | IStore_Indexes |
IndexFilename | The filename or absolute path for the index file. | IStore-i1.ndf |
LobName | The LOB filegroup contains the tables that Store LOB data. The logical name of the lob file. | IStore_Lobs |
LobFilename | The filename or absolute path for the index file. | IStore-b1.ndf |
MemoryOptimizedName | The memory-optimized filegroup holds one or more containers that contain data files, delta files, or both for memory-optimized tables. The logical name of the memory-optimized file. | IStore_Memory_Optimized |
MemoryOptimizedFilename | The filename or absolute path for the memory-optimized file. | IStore-mo1.ndf |
SqlLogName1 | The transaction log files used for the Information Store. The logical name of the first SQL log. | IStore_Logs_1 |
SqlLogFilename1 | The filename or absolute path for the first SQL log file. | IStore-log1.ldf |
SqlLogName2 | The logical name of the second SQL log. | IStore_Logs_2 |
SqlLogFilename2 | The filename or absolute path for the second SQL log file. | IStore-log2.ldf |