Data Store Configuration

Configure Data Stores

A data store is logical collection of tags used to store, organize, and manage tags according to the data source and storage requirements. A data store can have multiple archive files (*.IHA), and includes both logical and physical storage definitions.

Tags can be segregated into separate archives through the use of data stores. The primary use of data stores is to segregate tags by data collection intervals. For example, you can put a name plate or static tags where the value rarely changes into one data store, and your process tags into another data store. This can improve query performance.

Historian Data stores are stored archive files that contain data gathered from all data sources during a specific period of time. You can write and read data from the archives available under the data stores. Using data stores, you can store, organize, and manage tags according to the data source and storage requirements.

You can define two types of data stores:
  • Historical Data Store: Tags stored under historical data store will store data as long as disk space is available. Depending on your license, you may be able to create multiple historical data stores. The maximum number of Historical data stores supported depends on the license.
  • SCADA Buffer Data Store: Tags stored under the SCADA buffer data store will store data for a specific duration of time based on license.
When you install Historian 6.0 or greater, two historical data stores are installed by default.
  • System: Stores Historian messages and performance tags. This is only for internal usage within Historian, and you cannot add tags to this data store. You cannot rename or delete the System data store.
  • User: Stores the data for the tags. This is a default data store. You can rename and delete a user data store as long as there is another default data store set for tag addition.
Based on your license, a SCADA Buffer data store may also be installed.
  • SCADA Buffer: Stores short term tags and data in a SCADA Historian data store.

Adding a Data Store

About this task

Depending on your license, you can create or add multiple data stores.

Procedure

  1. In the Data Store Maintenance page, select Add Data Store.
    The Add New Data Store window appears.
  2. In the Data Store Name field, enter the name of the data store.
    Note: The following special characters cannot be used in data store names: /\ \ * ? < > |
  3. In the Description field, enter the description of the data store.
  4. Select the Default Data Store check box to set this data store as the default data store for adding tags. (optional)
  5. Select OK to add the data store.
    A message appears indicating that a data store has been added. When you add tags to the new data store, it will have its own set of .IHA (iHistorian Archive) files. Ensure that you back up the new data store archives periodically.

Renaming a Data Store

Procedure

  1. In the Data Store Maintenance page, select Rename Data Store.
    The Rename a Data Store window appears.
  2. In the New Data Store Name field, enter the new name. The Data Store Name field displays the existing name of the data store that you want to rename.
    Note: The following special characters cannot be used in data store names: /\ \ * ? < > |
  3. Select Rename.
    When the process is complete, a message appears indicating that the data store is renamed successfully.

Deleting a Data Store

About this task

You can delete a data store when it is no longer needed.

Before deleting the data store, if there are any tags assigned to the data store, you must reassign these tags and manually move the data to another data store.

Note:
  • You can only delete User data stores. You cannot delete the System data store. The Delete button will not be available, if you select a System data store.
  • You cannot delete a data store if there are tags assigned to it. Reassign or delete the tags and then delete the data store.
  • If you have only one User Store and System, you cannot delete the User Store.

    To delete a data store

Procedure

  1. In the Data Store Maintenance page, select Data Store Details.
    A login page appears.
  2. Select the data store to delete from the Data Stores drop-down list ox and then select Delete.
    A message appears asking you to confirm deletion.
  3. Select Yes to delete the data store.

Moving Tags Between Data Stores

About this task

You can move tags from one data store to another. However, moving a tag does not automatically move the data associated with it. If you want to retrieve the data stored before the tag was moved, you have to move the data manually using the migration utility tool.

To Move a tag between data stores

Procedure

  1. In the Tag Maintenance page, select a tag.
  2. Select Advanced.
    In the Data Store field, the existing data store that the tag belongs to is displayed.
  3. From the Data Store drop-down list box, select the data store you want to move the tag to.
    A message appears asking you to confirm the change.
  4. Select Yes.
    The Data Store field is highlighted in Blue indicating that the change has been made.
  5. Select the Update button.
    A message appears indicating that the data store will change for the tag, but the old data has to be manually moved using the Migration Tool (MigrateIHA.exe for 32 bit or MigrateIHA_x64.exe for 64 bit).

Migrating Tag Data

When you move a tag from one data store to another, the incoming data for the moved tag, from that time on, will be stored under the new data store. The data residing in old data store can optionally be moved to the new store. This data cannot be retrieved unless it is moved to the new data store. You can move data using the Migration Tool. You can either move all the tags, or some tags. Before you migrate data, you have to back up the archive file(s) that contain the old data.

For more information, refer to Backing up an Archive Manually.

Migrating Tag Data using the IHA Migration Utility

To migrate tag data using the IHA Migration Utility, refer to the IHMigration Tool documentation. Ensure that you select the A Migration Tool section in the product IPI (Important Product Information). You can move all or some of the tags.

Note: When migrating tags, use the Migrate using the tag mask option and specify the tag name or wildcard mask to migrate only the tags you want to include.