The New Informix
rnair 120000QPR1 Tags:  otlp cloud database mumbai india informix in-memory analytics 3,595 Views
YES - I have been slow with my updates. Call me a slacker, but better late than never. My travels have taken me eastward in the last two months. My first trip was on an Informix event for customers and partners in Mumbai, India. We held a "unique" one of a kind one-day event for our Informix loyalists in India. This was our opportunity to present some of the key new Informix capabilities in 11.70 and especially gave me the opportunity to shed some more light on IWA or the Informix Warehouse Accelerator. The event was well attended and you can find all the details at the Informix India facebook page https://www.facebook.com/informixindia
Already knowing that Informix customers are Informix fans, it still pleasantly surprises me to see how passionate the Informix customers are about Informix. In a country where bottom line savings, reliability needs and low cost of ownership take on a whole new meaning, it's easy to see how Informix stands out with this user base.
I also got reprimanded for not blogging enough by one our loyalists (you know who you are :-)).
One of the goals out of this meeting was to kick-off a local user group in the region and I am happy to say that with the help of Stuart Litel our IIUG president, we have found a couple of our customer/partner representatives who have agreed to lead this important agenda for us. Stayed tuned to hear more about that from Louis Cherian. Additionally we know have regularly scheduled "Chat with the Lab" events that provide deeper insights from the lab on many of the Informix features.
For details of Informix things happening in India, be sure to bookmark the following pages:
Informix Product Manager
If you are looking to understand , read more about or trying to decide on choosing a warehouse technology that is right for you, this article on DBTA by Roger Gaskell should make an interesting read:
rnair 120000QPR1 Tags:  warehouse exadata in-memory analytics data mart informix sybase teradata 2,675 Views
Today, we announced the Informix Growth Warehouse Edition along with some pricing updates on the Informix Ultimate Warehouse Edition. The announcements can be found here:
Built around the same Informix Warehouse Accelerator technology available with the The Informix Ultimate Warehouse Edition, the Informix Growth Warehouse offering brings the same performance and capabilities to the mid-market. The Growth Warehouse can be put on a machine that has upto 16 cores and 48 GB of RAM allowing customers the potential to accelerate data mart sizes up to 250 GB or sometimes a little more, depending on the compression obtained.
rnair 120000QPR1 Tags:  in-memory accelerator data mart informix warehouse columnar 4,051 Views
A few weeks ago we delivered Informix 11.70xC3. Along with some other enhancements, there are three things I want to bring to your attention around the Informix Warehouse Accelerator component of the Informix Ultimate Warehouse Edition:
1) A Smart Mart Tool that can be used to generate data mart definitions from workload analysis
2) Multi-cultural support (IWA support for different locales)
3) the Informix Ultimate Warehouse Time-Limited Version for Evaluation (not really a 11.70xC3 enhancement )
The Smart Mart tool can significantly help reduce the efforts to designing a data mart for deployment with the Informix Warehouse Accelerator. This is really valuable when you are unfamiliar with the database schema or there are a large number of tables. The first step to generating a data mart definition is workload analysis. Workload analysis consists of "Query Probing" where information is gathered about the query workload. Based on the analysis of the probing data and database schema, the probing data can be converted into a data mart definition(probe2mart stored procedure). This definition is in the form of relation tables and can be used to generate the data mart definition as xml (genmartdef() ). This xml file can be imported using the ISAO studio administration interface.
The Informix Ultimate Warehouse Edition time-limited evaluation now allows you to conveniently try out and experience the extreme performance gains at your convenience. The download can be found here
rnair 120000QPR1 Tags:  in-memory warehouse mixed analytics edition in memory data informix ultimate workloads mart 1 Comment 4,411 Views
Fred Ho and Lester Knutsen talked about the Informix Ultimate Warehouse Edition on a very well attended web cast organized by InformationWeek. There were a lot of questions that Fred has documented as Q&A at this blog which can be found here
rnair 120000QPR1 Tags:  in-memory ultimate warehouse intelligence columnar informix business analytics bi 5,306 Views
This is the sign hanging on data warehouses today: "Wanted: Technology for Extreme Performance ".
Introducing the Informix Ultimate Warehouse Edition for our Informix customers - you can read the official announcements here:
So what's all the excitement about ? The IBM Informix Ultimate Warehouse offering is all about bringing extreme performance enhancements to Informix warehouse workloads using breakthrough warehouse acceleration technology. Yup I know that is a mouthful. But hold your questions right there!
First let me delve into the packaged contents of this offering before we get into the details. The offering is basically a brand new edition that consists of :
Here is how it all works in a nutshell :
Your warehouse continues to be managed by #Informix and your BI queries continue to run against Informix. When a query is run against a data mart that is configured for acceleration, the Informix optimizer ships off that query to the accelerator and returns the results from the accelerator back to the BI application. The following graphic attempts to illustrate this:
The Informix Ultimate Edition is supported on 64-bit versions of the following OSes: AIX, Sol, HP-UX and Linux:
The IWA component is supported on the following platforms:
To learn more about the Informix Ultimate Warehouse Edition visit the Informix Warehouse page or attend the various Discover Informix and IIUG events coming your way or look for other blogs from various Informix experts. Don't forget to register for and attend the IIUG Conference in May 2011.
To leave with a final thought, here's my favorite one for your warehousing environment : Take "NO" for an answer !!!!