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:

• 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.
• Java™ classes.