September 6, 2017 Martin Fuerderer, Advisory Development ENGINEER
The Informix Warehouse Accelerator (IWA) is a software appliance for the Informix database server, using in-memory, columnar data storage for business intelligence applications doing OLAP. For such workloads IWA typically can achieve a query acceleration of 10 - 100 times faster than running the workload within the Informix database server. With this post we start a casual series of articles on IWA in general as well as specifics for its deployment in cloud environments like Bluemix.
This is the second part of this multi-part series. In this part, we will take a closer look at setting up, configuring, and inserting data into Informix TimeSeries.
Create Database Structures We’ll start by creating a database executing the following SQL statement to create a working database. To keep things simple, we will create everything in the default dbspace (rootdbs).