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.
Types of tables for accelerationYou can load and accelerate data from tables, external tables, synonyms, views, and time series virtual tables.
Load data from time series virtual tablesYou can use time series virtual tables to create a data mart and load it with data.

Load data from time series virtual tables

You can use time series virtual tables to create a data mart and load it with data.

Time series virtual tables are a layer in the Informix® server that you can use to present data in a different way, similar to a view. Time series virtual tables do not store the original data in a different format, but rather they provide access to the data as through it was stored in relational tables

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.