About IBM Data Warehousing

IBM offers a wide variety of data warehousing and analytic solutions enabling the best approach for each situation. From traditional multidimensional and data mining to mashups and industry models, IBM has the right solution for gleaning insight from information.

Inspiring “Aha” Data Moments: Lester Knutsen

PS: This is a republished blogpost from Mastering Data Management

One of our inaugural IBM Champions, Lester Knutsen, summed up his Informix work in a single sentence: “I like building databases.” While working at Aberdeen Proving Ground in 1983, one of the first Unix boxes arrived, bundled with Informix – and Lester marveled at how quickly he could get into it.

This passion drives everything he does. Lester is president of Advanced DataTools, an Advanced IBM Partner that focuses on Informix consulting, training, support and software. Lester is also a founding member of IIUG (the International Informix Users Group), president of the Washington, DC area Informix Users Group and an IBM Gold Consultant.

Lester and his Advanced DataTools team engage users in every step of the data warehouse process. Lester explains, “End users don’t really know what they want until they see it. Anybody who thinks you can just design a project on paper and then go implement it, unchanged, is dead wrong. You’ve got to have user involvement – and that’s the key part of agile development.”

Starting with user requirements, the team loads the data and builds a prototype that lets clients “kick the tires” and see how their data actually works within the warehouse. Clients are often surprised at what they find in the prototype. For the first time, they can identify their biggest customers or find missing transactions.

Even more important, though, is the ability to change direction as clients have “aha” moments about their data. Sometimes, seeing the prototype in action inspires an even better idea.

Besides building databases, Lester and his team spend a lot of time helping clients navigate an ever-changing regulatory environment. While regulations are important, Lester has noticed that some very large organizations use them as “an excuse not to get things done.” These organizations often lack a truly cooperative team or a clear mission.

In contrast, Lester is proud of his team, noting he’s built, “the best pool of Informix talent in the world, outside of IBM.” The team includes two additional IBM Champions, Cindy Lichtenauer and Art Kagel, with whom we did a follow-up interview. (Stay tuned.) Lester firmly believes that, “Good people attract good people,” and he’s committed to developing talent. Advanced DataTools has a unique internship program for high school seniors and college students who show promise in technology. Several participants have come to work for Advanced DataTools after graduation.

Through it all, Lester tries to foster an environment that’s “fun, interesting and challenging.” His team works hard, but they also list their passions on the company’s website. In Lester’s case, he travels extensively to scuba dive and take underwater photos and videos. You can view his incredible collection at http://www.lesterknutsen.com. Currently, he’s using his database skills to organize his growing video library before heading to Indonesia this summer.

Listen to our interview for more from Lester, and be sure to watch this space for our follow-up conversation with the trio of Champions from Advanced DataTools. You can also follow Lester on Twitter @LesterKnutsen.


The Secret of Informix: Stuart Litel

PS : This is republished blopost from Mastering Data Management

During our recent interview with International Informix User Group (IIUG) president Stuart Litel, he shared the best-kept secret about Informix. Working with Informix since the mid-1980s, Stuart is well-qualified to share such secrets. But we’ll get to that in a bit.

Stuart first encountered Informix when he was hired by Sheraton to replace the worldwide Sheraton reservation service. During testing, the team discovered that “this thing called Informix” worked best. Overnight, Sheraton became the world’s largest non-governmental user of Informix.

IBM’s 2001 acquisition of Informix changed the game, adding resources that have made Informix even more stable and useful. Stuart points to the prevalence of releases offering new features as a huge reason that users choose – and stick with – Informix.

“We buy technical products for technical reasons, or to solve a technical problem,” he explained, noting that he’s never met a person who left Informix for technical reasons – which says a lot. Informix is “too stable for its own good,” Stuart said, joking that the biggest job of an Informix DBA is to search the internet. “When a person gets a hold of [Informix] and has used it for awhile, they really dread using another database product.”

As president of IIUG, Stuart spoke highly of the users, saying, “The people who use it are a testament to the product.” He’s currently very busy preparing for the April IIUG Conference, which will be the biggest ever, and the first time the conference will be in San Diego. Stuart praised the host hotel’s wifi – it even works by the pool – and food.

But more importantly, the larger hotel will allow for more sessions. Organizers have added two educational tracks, bringing the total to seven tracks with over 80 sessions. Stuart is especially enthusiastic about David Barnes’ keynote on Big Data. David is Program Director, Strategy and Emerging Technologies with IBM.

Join Stuart and IIUG April 22-25 in San Diego for the IIUG Conference. While you’re there, get certified and attend the hands-on labs.

Oh, and what was Stuart’s best-kept secret about Informix? “It works.”

IBM Informix Business Partner Montage

IBM Informix Business Partner Montage : A new video was developed recently, where we tried to find out why our business partners rely on IBM Informix, for their business. The outcome of the video was really promising, as our Business Partners summarized the benefits of IBM Informix, just in the way we are all familiar with it:

  • “Low cost of owner ship”
  • “Extremely reliable”
  • “Flexible”
  • “Scalable”
  • “Reliable”
  • “It just keeps running, without the need of any maintenance”
  • “Set it and forget about it”
  • “High availability”
  • “It is designed to work, and it works just the way it is designed to do”

And at the end of the video, it is great to hear from our business partner, perhaps a very unique and distinguishing fact, that only an Informix user would have the luxury of saying, “I am not just an Informix user, I am an Informix fan!”

A special thanks to all our Business Partners who were a part of this video, for making it a very special and successful one for Informix.

You can watch the complete video here or clink on the link : http://www.youtube.com/watch?v=wWgUtnwiFbM&feature=plcp

Until next time,


Jerry Keesee talks about his blog post on Informix future and IOD 2012

I had the opportunity to interview Jerry Keesee (World Wide Director, Informix Software, IBM Data Management) where he spoke about his blog post on Informix future and IOD 2012 during the Discover Informix event, which was help in Singapore (September 2012). He then touched upon the achievements of Informix in the past 10 years and also spoke about how IBM is continually making investments to Informix. He also highlighted the importance of attending the IOD conference and why it becomes an exciting proposition for an Informix user to be a part of IOD.

Watch the complete video to know more.

Link to the video : http://youtu.be/E-FdpxiT3U8

Until next time,


IBM Informix at Information on Demand (IOD) 2012

Dear Informix fans,

IOD 2012 is almost on its way, and I thought it would be good time now, to capture all the Informix sessions that will be presented at IOD 2012. Please have a look at the sessions below and plan your agenda for IOD 2012 using the agenda builder http://sample.iodsmartsite.com/

Monday, October 22

1. Session ID: IDS-1765A 10:15 AM – 11:15 AM

Venue : Mandalay Bay North, Convention Center – Tradewinds D

Informix Warehouse Accelerator: A Year in Perspective: Customers have many technology choices that can accelerate their data warehouses. This session will examine technology trends, discuss why customers choose Informix Warehouse Accelerator (IWA), present customer use cases, review applications and summarize lessons learned across a diverse set of customer adoptions.

2. Session ID: IDS-2612A 11:30 AM – 12:30 PM

Venue : Mandalay Bay North,Convention Center -Tradewinds D

How Informix TimeSeries Differentiates the IBM Distribution Grid Monitoring Solution:

IBM Distribution Grid Monitoring (DGM) is a medium and low-voltage grid monitoring and device management system. It offers a visualization interface that can help socialize Smart Grid data with the rest of the enterprise. The extensible data warehouse has powerful analytics that can aid in grid operation and planning. This session will give an overview of DGM and how Informix provides a single platform solution that is designed to meet complex requirements. Informix with the TimeSeries feature strengthens the Historian module by managing operational data efficiently and establishing its referential integrity with context such as network models. The Informix Warehouse Accelerator adds analytical strengths that complement these features.

3. Session ID: IDS-1888B 12:45 PM – 01:45 PM

Venue : Mandalay Bay South

Convention Center -Bayside Dining IM BoF,Tables 20&21

BOF – Achieving High Availability and Scalability Across Heterogeneous Environments: Exchange challenges, strategies and success stories during these informal discussions over lunch.

4. IDS-1889B 12:45 PM – 01:45 PM

Mandalay Bay South, Convention Center – Bayside Dining IM BoF, Tables 22&23

BOF – Enabling Cost Effective Applications that use Interval (Time Series) or Spatial Data Types: Exchange challenges, strategies and success stories during these informal discussions over lunch.

5. IDS-1402A 02:00 PM – 05:00 PM

Mandalay Bay South, Convention Center – Shorelines B Lab Rm. 11

Hands-On With Informix 11.70: New Features Can Be Implemented Wherever Appropriate: Attend this session to experience the many new futures that have been introduced in Informix 11.70. These features are designed to enhance the core strengths of Informix: high availability, reliability, scale out, ease of use, simple administration, security and performance.

6. IDS-1052A 02:15 PM – 03:15 PM

Mandalay Bay North, Convention Center -Tradewinds D,

Informix Warehouse Accelerator: Billion Rows Benchmark Demo: After one year of using the Informix Warehouse Accelerator there is considerable evidence of its amazingly fast performance. In one set of benchmarks it took 14 minutes to run queries that used to take 9 hours. This session will demonstrate current benchmarks with this exciting new database technology. It will include a demonstration of ad-hoc queries on a bookstore database with 250 million customer records and over a billion sales transaction records in the fact table. Attend this session and learn how to achieve very fast performance with your data warehouse.

7. IDS-2866A 03:45 PM – 05:00 PM

Mandalay Bay North : Convention Center -Tradewinds D

How Informix Clustering Technology Helps European Retailer NKD to Improve Operations and Reduce Costs: NKD is a rapidly-growing fashion retailer with roughly 1700 stores in central Europe. This presentation will show how NKD is able to use Informix to fulfill its growing availability and scalability demands. The session will explain how a cost-conscious retailer like NKD was able to move to a new Informix version on Linux, thereby improving its IT operation while reducing costs at the same time. The NKD solution combines state-of-the-art hardware technology such as SSDs with new Informix features. For instance, NKD has implemented high availability with a shared disk cluster that allowed them to reduce failover time to just a few seconds.

Tuesday, October 23

1. IDS-3659A 08:15 AM – 09:30 AM

Mandalay Bay North,Convention Center – Tradewinds D

Informix in the Cloud: Businesses are embracing the virtualization and automation of cloud computing to help decrease costs and increase the efficiency of their IT departments. Informix offers time-tested characteristics such as stability, low cost of administration and performance, in addition to recent new features. This combination makes Informix an excellent choice for cloud computing applications. Attend this session to explore how a business implementing a private cloud could benefit from Informix Flexible Grid. Attendees will also hear about the new Informix Hypervisor Edition and what it can mean for cloud computing.

2. IDS-1871A 10:00 AM – 11:00 AM

Mandalay Bay North

Convention Center – Tradewinds D

IBM Informix Innovations: Where We Are and Where We Are Going: Come to this session to hear the Director of Informix Development talk about how the latest Informix innovations are helping Informix win new clients and partners across industries. You will also hear how Informix is uniquely positioned with a critical role among the IBM solutions for big data. The discussion will include a glimpse of the Informix roadmap and strategy that will continue to enable smarter solutions.

3. IDS-1062A 10:00 AM – 01:00 PM

Mandalay Bay South, Convention Center – Shorelines B Lab Rm. 11

Hands-On With Informix Warehouse Accelerator: In March 2011 IBM introduced market-changing data warehouse technology that dramatically enhanced the ability of Informix to operate as a data warehouse or data analysis server. The accelerator technology uses compression and a columnar approach to storing and accessing data in-memory, as opposed to the row-based approach of most database engines. The IBM approach is designed to provide data response times that are hundreds of times faster than those achieved with conventional systems. In this lab, you will have the opportunity to use this technology.


4. IDS-2154A 11:15 AM – 12:15 PM

Mandalay Bay North, Convention Center – Tradewinds D

How the Malaysian Inland Revenue Board Improved Performance with an IBM Informix Genero-Based Framework: The Inland Revenue Board Malaysia (IRBM) is one of the largest revenue-collecting agencies of the Malaysian government. It is responsible for tax administration for the nation’s taxpayers. In 2006, Censof implemented the Standard Accounting System for Government Agencies (SAGA)-compliant Century Financials (Government) at the IRBM. This solution was built on IBM Informix Genero and IBM Informix. The functionality and performance of this solution helped Censof win the subsequent Electronic Revenue Accounting System (e-RAS) project. The e-RAS project was implemented to provide greater efficiency in dealing with the public sector as outlined in the IRBM Client Charter

5. IDS-1879B 12:45 PM – 01:45 PM

Mandalay Bay South, Convention Center – Bayside Dining IM BoF Tables 17&18

BOF – Informix Application Development: Exchange challenges, strategies and success stories during these informal discussions over lunch.

6. IDS-1875B 01:15 PM – 02:15 PM

Mandalay Bay South,Convention Center – Bayside Dining IM BoF, Tables 11&12

BOF – Accelerating Data Warehouses with Informix: Exchange challenges, strategies and success stories during these informal discussions over lunch.

7. ID-3428B 01:45 PM – 02:45 PM

Mandalay Bay North, Convention Center – Tradewinds D

Accelerating Data Life Cycle Management With Informix Warehouse Accelerator and Intel Xeon: IWA works with a snapshot of the data in Informix data mart. Once you have defined the data mart on IWA and loaded the data, you need to periodically refresh the data. You can choose to refresh all of the data or just the partitions that were added, dropped or modified. Whether you have hundreds of gigabytes or many terabytes, faster refresh will help you analyze recent data more rapidly and get closer to real-time  business. This session will explain the options for data refresh, review their performance and explain how  to correctly implement a refresh plan. IBM and Intel will demonstrate live data refresh on the Intel Xeon platform and examine the impact on performance.

8. IDS-3647B 03:00 PM – 04:00 PM

Mandalay Bay North, Convention Center – Tradewinds D

Informix 11.7 Performance Landscape: This session will present a detailed overview of Informix 11.7 performance, including new features, tuning and monitoring options, and best practices.

9. IDS-3459A 04:30 PM – 05:45 PM

Mandalay Bay North,Convention Center – Tradewinds D

Rapid Application Development With Informix Genero: Additional Benefits for New Applications: You have heard about the benefits of Informix Genero for modernizing 4GL, but what about using Genero for new application development? Genero provides all of the expected benefits of developing in a 4th-generation language, including simple constructs for working with your Informix database. This session explores the capabilities of the Genero graphical development environment, and how it streamlines the development process.If you are developing new apps for mobile, web or the desktop, Informix Genero should be on your shortlist.

Wednesday, October 24

1. IDS-1786A 10:30 AM – 01:30 PM

Mandalay Bay South, Convention Center – Shorelines B Lab Rm. 11

Modernizing 4GL Applications and Providing Web Services Using IBM Informix Genero: The lab will give users an understanding of IBM Informix Genero. Attendees will learn how to modernize existing 4GL applications with minimal user interaction. They will also see how Informix Genero is designed to help you develop applications once, and then deploy them over the web, on mobile devices, on desktops and more. The session will present case studies ranging from simple to complex, and will also explain the IBM experience and best practices for using Informix Genero.

2. IDS-3055A 10:45 AM – 11:45 AM

Mandalay Bay North, Convention Center – Tradewinds D

Using Informix Warehouse Accelerator to Accelerate Data Warehousing at Westfleisch: Data warehouses, must simultaneously provide fast answers to user queries while maintaining a low total cost of ownership. This presentation shows how one of the top five meat marketers in Europe, Westfleisch, employed Informix Warehouse Accelerator (IWA) to achieve these two goals. The project followed a 2011 proof-of-concept and decision by Westfleisch to move their data warehouse to IWA. This session will describe how this task was performed and what lessons were learned.

3. IDS-3560A 12:00 PM – 01:00 PM

Mandalay Bay North, Convention Center -, Tradewinds D

Informix TimeSeries and Informix Spatial: What are Database Extensions and How Can I Use Them? Informix includes support for special data types such as interval (time series) data and spatial data. Applications utilizing these data types are becoming increasingly popular across industries. This session will discuss several use scenarios and answer the kinds of questions that arise when considering special data types. How can existing applications be enhanced to use location data or interval data? How much work is involved? What will it cost? What should we think about when designing a new spatial or time series application? Finally, the discussion will address the extensibility of the Informix database.

4. IDS-1875B 01:15 PM – 02:15 PM

Mandalay Bay South Convention Center – Bayside Dining IM BoF Tables 11&12

BOF – Accelerating Data Warehouses with Informix: Exchange challenges, strategies and success stories during these informal discussions over lunch.

5. IDS-4202A 02:30 PM – 03:30 PM

Mandalay Bay North, Convention Center – Tradewinds D

Pronto Xi, Informix and IBM Cognos 10 – Designing integrated ERP and real-time BI for Mid-Market: Pronto Software was the first ERP vendor globally to release a fully integrated package of ERP and Cognos 10 BI. We’ll discuss how it was done and how we leveraged the IBM Informix Database to provide simultaneous transactional and real time business intelligence in a single seamless environment. The World has moved from simple, static reporting to dynamic, real-time dashboards, widgets and reports. Learn how Pronto has integrated the three pillars of this solution: Pronto ERP application, IBM Informix and IBM Cognos BI from a technical,change management and market perspective to provide a world leading solution in the mid-market.

6. IDS-1935A 03:45 PM – 04:45 PM

Mandalay Bay North, Convention Center , Tradewinds D

Getting the Most From Informix Compression and Other Storage Optimization Features: To get the most out of Informix Storage, you should utilize exciting new features such as data compression and index compaction. If you understand how to optimize data and index storage, your disk drives essentially work for you. Attend this session to learn how these new features can help you reduce backup times, improve query performance and lower administration costs.


7. IDS-2762A 05:00 PM – 06:00 PM

Mandalay Bay North, Convention Center -, Tradewinds D

Retail Management System With Embedded Informix Database: This session will discuss how the Avanti retail management system, with Informix as its underlying database, has helped many retail customers to implement a faster solution, save record maintenance costs and offer an easy-to-operate system.

Thursday, October 25

1. IDS-1504A 08:15 AM – 09:30 AM

Mandalay Bay North

Convention Center – Tradewinds D

Accelerating Business Process Management with Informix 11.7: IBM BPM 7.5 has a process instance repository, but sometimes it is necessary to interact with an external database. The Maricopa County Attorney’s office has integrated BPM 7.5 with Informix 11.7 and found the performance to be substantially faster than what their prior system achieved. This session will explore why.

2. IDS-1581A 10:00 AM – 11:00 AM

Mandalay Bay North Convention Center – Tradewinds D

Improving Performance With Query Rewrite and External Tables: This session will explore two areas of Informix that are important for achieving maximum performance: query rewrite and external tables. Attendees will learn various techniques for doing query rewrite and hear about its use in different customer environments. The session will also cover internals of external tables and why it is important to replace many existing tools. Attend this session to hear about the most important factors to consider when using external tables to make your environment better, faster and more efficient.

3. IDS-2717A 11:30 AM – 12:30 PM

Mandalay Bay North, Convention Center -, Tradewinds D

Delivering True Offline Capabilities to Mobile Devices With IBM solidDB and Worklight: The prevalence of mobile devices presents a unique challenge for businesses to deliver their capabilities by fully engaging their users. The fidelity of application interaction on these devices becomes extremely important. This presentation will cover how you can achieve this fidelity for any mobile app developed by utilizing IBM solidDB and the first-class MEAP (mobile enterprise app platform), IBM Worklight. This session will also explore how you can maintain interaction fidelity for mobile apps while achieving true offline capabilities such as security, maximum storage, a familiar programming model and sync when connectivity is available. You will witness a real-world scenario of a mobile app built using Worklight and utilizing solidDB.


4. IDS-1932A 02:00 PM – 03:00 PM

Mandalay Bay North,Convention Center – Tradewinds D

The Informix Graphical OpenAdmin Tool for OATs: This session will help participants understand the capabilities and architecture of OAT, the OpenAdmin Tool for Informix. The discussion will include an overview of the capabilities of OAT, highlighting such features as replication, query tracing, storage optimization, performance history graphs, auto-update statistics and space management, along with many other capabilities.

5. IDS-2397A 03:30 PM – 04:30 PM

Mandalay Bay North, Convention Center – Tradewinds D

Best Practices for Embedding Informix in a Constrained Environment: One of the primary strengths of Informix is its hands-free administration. This means Informix is often the best choice for an embedded application. In this session, participants can learn about the best practices for embedding Informix in a constrained environment where resources are limited. Informix customers could also reduce their overall administration cost by taking advantage of features that make Informix embeddable.

If you have not registered already for IOD 2012, please do so by clicking on this link http://www-01.ibm.com/software/data/2012-conference/

Until next time,



Coming soon : Informix Infobahn roadshow 2012 in Germany, Austria and Switzerland!

Informix is coming to Germany, Austria and Switzerland from September 26 through October 2nd and you don’t want to miss this opportunity to attend to the latest Informix sessions, and also meet with IBM executives and thought leaders.

Take a look at the schedule of events : 


  • September 26th : Berlin
  • September 27th : Dusseldorf
  • September 28th : Munich


  • October 1st : Zurich


  • October 2nd : Vienna

The list of international speakers for the Informix Infobahn roadshow 2012 include :

  • Jerry Keesee (Director, IBM Informix Database Development)
  • Frederick Ho ( IBM Chief Technologist Informix)
  • Steve Shoaf (IBM WW Sales Executive Informix & SolidDB)
  • Stuart Litel (President International Informix Users Group)

You will also get a chance to meet with the local Informix experts like Michael Koester, Dr. Andreas Weininger and Alexander Koerner.

For additional details, the Infobahn agenda and the registration links for Germany here: http://www.ibm.com/de/events/informix

For Austria and Switzerland please send an email to gerhard.fuersatz@at.ibm.com

We hope to meet with you during these events.

Until next time,

Discover Informix in Singapore on the 6th of September 2012 (Thursday)

It was a great opportunity for us to meet in person with 100’s of Informix users in Malaysia and Thailand through the series of Discover Informix events we are conducting in the ASEAN region. I would like to personally thank all Informix users who made it to the event – Thank you so much for your support and dedication. The results of these events have been very positive and motivating, and going forward we certainly look forward to meeting with you more often!

After successfully conducting Discover Informix events in Malaysia and Thailand in August, we are now all set to visit Singapore on the 6th of September 2012 (Thursday). The event is scheduled to start from 9:00 AM to 12:30 PM at the Marina Bay Sands Convention center, 10 Bayfront Avenue, Singapore 018956.

If you are in (or around) Singapore during the 6th of September, please try and make it to this event. The half a day event, is filled with exciting sessions, taking you through IBM’s commitment to Informix, Informix Warehouse Accelerator (IWA), Genero, Use case scenario, and How we could make a better Informix community through social media etc.,

Register for the event today : You could register for the event by calling up Irene at +65 6743 1277 or Email her at  ibm_informix@projectvaults.com.sg

Looking forward to meeting with you in Singapore, do not forget to register for the event please.


Until next time,