Sumanth Rajagopal, IBM developer for the OpenAdmin Tool (OAT), recently published a new developerWorks article on how to use OAT to create data marts in the Informix Warehouse Accelerator (IWA). Following is the summary of this article:
Summary: The IBM® OpenAdmin Tool (OAT) for Informix® is a web application for administering and analyzing the performance of IBM Informix database servers. You can now use OAT to administer Informix Warehouse Accelerator. Informix Warehouse Accelerator processes warehouse queries more quickly than the Informix database server does. With OAT, you can create data marts based on workload analysis, which is a process that analyzes the query workload in a data warehouse. You can use OAT to schedule loads to refresh the data in the data marts. You can also use OAT to create and drop accelerators and enable and disable data marts. In this article, learn how to create data marts using OAT.
The underlying techniques were described in this blog before as the so-called "SmartMart" feature. However, that involved using a rather inflexible shell script which usually needed editing to be adapted to specific needs. With OAT, all this can be done in an elegant way using the graphical user interface of OAT without needing to worry about shell scripting and similar arcane detail.
The article also contains a URL to the YouTube OAT Channel, where you can find a video demonstrating how to create a data mart with OAT. The direct URL to this video is: