Create a data mart
After you configure the accelerator server and set up the connection between an accelerator and the database server, you need to create the data marts.
A data mart specifies the collection of tables from a database that is loaded into an accelerator and the relationships, or references, between these tables. To create the data mart, you must determine which warehouse queries are good candidates for acceleration.
Create a data mart by using one of the following tools:
- HCL OpenAdmin Tool (OAT) for Informix®. You create a data mart that is based on a workload analysis from the page. The data mart is automatically deployed.
- The SQL administration ifx_createMart() function.
- Manual workload analysis requires that you run a series of statements, stored procedures, and functions that analyze the schema and the queries to create a data mart definition. After you create the data mart definition, you must deploy it to create the data mart.
- Informix Smart Analytics Optimizer Studio requires that you have a detailed knowledge about the schema of the database and the queries that the applications are sending to the database server. You create the data mart definition first, and then you deploy it to create the data mart.
- Java™ classes.