Home
Data warehousingIn addition to designing and implementing Informix® dimensional databases, you can use tools to create data warehouse applications and optimize your data warehouse queries. The resources that are external to the information center are marked as such.
Informix® Warehouse AcceleratorThe Informix® Warehouse Accelerator Administration Guide includes information about installing and configuring the accelerator server, creating data marts, accelerators, and accelerated query tables (AQTs).
Data marts and AQTsFor efficient query processing, the accelerator server must have its own copy of the data. The data is stored in logical collections of related data, or data marts. A data mart specifies the collection of tables that are loaded into an accelerator and the relationships, or references, between these tables.
Create a data martAfter you configure the accelerator server and set up the connection between an accelerator and the database server, you need to create the data marts.

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.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.