Deploying and loading a data mart by using Informix® Smart Analytics Optimizer Studio

When you use Smart Analytics Optimizer Studio to deploy the data mart, the data mart definition is imported from an XML file into an accelerator project in Smart Analytics Optimizer Studio. When data is loaded into the data mart, it is enabled automatically and is in the ACTIVE state. You can disable or enable a loaded data mart to switch the query acceleration for the data mart on or off.

About this task

As part of creating a data mart definition, Informix® Smart Analytics Optimizer Studio estimates the amount of space required for the data mart and the data mart definition is validated.

Important: Loading data into a data mart can take several hours, depending on the size and the amount of data that is contained in the tables.

Procedure

  1. Import the file into Smart Analytics Optimizer Studio:
    1. On the computer where the Smart Analytics Optimizer Studio is installed, start Smart Analytics Optimizer Studio:
      • On Linux™, open the directory where you installed Smart Analytics Optimizer Studio, and then run the ./datastudio command.
      • On Windows™, select Start > Programs > Informix® Smart Analytics Optimizer Studio 1.1
    2. Create an accelerator project. Right-click the Accelerators folder and select New Accelerator or choose File > New > Accelerator project.
    3. Right-click the new accelerator project in the Project Explorer window. Select Import. The value Data Mart Import is selected by default. Click Next.
    4. Locate the generated file. Verify that Import into existing project and the name of the current project is selected. Click Finish.
  2. You can deploy the data mart from either the Data Source Explorer or from the Properties view of the data mart.
  3. You can start the load process from either the Data Source Explorer or from the Properties view of the data mart.
  4. Right-click the data mart and select Load.
  5. Choose the level of consistency that you want for the loaded data by specifying a value for the locking parameter for the data load. Following are the values that you can choose from:
    OptionDescription
    NONE No locking is done during the load. The data is read from the different tables similar to a dirty read. Other user sessions can change the data during the load operation. As a result the loaded data might be inconsistent.

    The data inconsistencies might be acceptable if the primary goal of the data mart is to create statistics and discover trends rather than to find the exact values of specific data rows.
    TABLE Each table is locked for the duration it takes to gather the load data from the table. The loaded data is consistent within each table, but not necessarily across different tables.
    MART All of the tables in the data mart are locked for the duration of the load. The loaded data is consistent from all of the tables. However, all of the other user sessions are blocked from changing the data in the tables that are involved in the load.