IBM Informix - SQL & NoSQL
keshavamurthy 0600019DXM Tags:  quality ibm checklist conference iod atul informix gawande 8,066 Views
IBM IOD Conference started with big bang today morning. Tomorrow, Atul Gawande will be the general session's guest speaker at IBM IOD conference 2010. He has long list of accomplishments, but did you know he also contributed to Informix v11.70? Here's how.
When we were starting v11.70 work, I saw his interview with Charlie Rose where he was talking about simple checklists saving lives in hospitals by reducing mistakes in routine things like proper installation of IV lines. He had written an article on it in New Yorker, was discussing results of world wide study of results using 90-second checklist for surgery. Here's a quote from the article: If a new drug were as effective at saving lives as Peter Pronovost’s checklist, there would be a nationwide marketing campaign urging doctors to use it. Later in 2009, He wrote the book , The Checklist Manifesto: How to Get Things Right.
Within Informix, we've had checklist for a long time(e.g. what all the code to make when we do parser changes), but didn't have a feature wide checklist. In analyzing customer bugs for the last few years, I had observed, even though we try to cover all cases between unit, functional, integration, stress and interoperability testing, we do miss some cases and combination. We would depend on the requirements, design and test specs and their review to catch all scenarios. At the start of Informix v11.70 development, I created a simple checklist, that started with something like this.
We added all the statements from ALLOCATE to UNLOCK, all major features which would bring new scenarios (MACH11, Enterprise replication, Administrative API, etc), all the tools, and other features planned for v11.70. Development, QA analyzed these from requirements (both externally visible and engineering requirement), design issues that may crop up in that combination, what relevant tests are necessary for that scenario.
Every checklist analysis yielded new scenarios to consider, decide what should be the requirement, do design to include scenario and test in house. We saw improvements internally in scenarios we caught and addressed before we released the product. Hopefully you've tried Informix v11.70 by now and hope you see the improvements to the product and quality. Checklist is not an alternative to good requirement collection or good design, but it helps doing things right.
keshavamurthy 0600019DXM Tags:  with ibm data analysis atul gawande iod lives saving war 8,747 Views
With the backdrop of vision, strategy and sales pitch, Atul Gawande gave a poignant talk on saving lives. As a surgeon, saving lives is his day job. Here, he was talking saving lives of soldiers. From American Civil War to Persian Gulf war in early ‘90s, and average of 25% wounded soldiers died. In that period, there has been tremendous increase in killing machines and healing machines. Although the number of wounded, died substantially decreased, the percentage remained about the same until Afghan-Iraq war. Suddenly, the percentage of soldiers died dropped to 10% of the wounded.
What happened? Was there a miracle drug or medical breakthrough?
One bright person after another asked, how can we save more?
Surgeons know, first hour after injury – called the golden hour – is the most critical. Smaller, agile troops go farther from the base and trip back to the base will take longer. Army created cavalry of about 6 trucks who could reach much farther than typical bases and could be setup to perform 4 patients simultaneously in about 60 minutes. This was an improvement of logistics.
these clinic outputs, they wouldn’t try to heal the patients completely and
many times wouldn’t even complete the surgery itself. They would bring the patients to a stage so
they could be transported to the big base. Doctors would wrap the wounds and patients;
leave a clear note on diagnosis, procedures done, next steps on the patient. The base would do the similar effort and
transport the soldier to the American base in
When army saw too many soldiers were dying because it was too heavy, they made it responsibility of the commanding officer to ensure this was enforced and change the culture.
When army saw too many soldiers were getting eye injuries from data analysis, they interviewed the young soldiers, who said, the protection goggles were ugly. Army redesigned the goggles’ with the help eyewear designing companies. Now, the very same soldiers wouldn’t even take them out even indoors.
Even though, changing the percentage from 25% to 10% was dramatic, at every stage, someone had to provide the data (doctors who send the information from the battle field after 20-hour work!) analyze the data deeply, be on the field to understand and verify.
Samuel Gorovitz and Alasdair MacIntyre wrote human deficiency has two reasons: ignorance and ineptitude. Ignorance is not knowing the right answer and ineptitude is lack of applying known, proven knowledge consistently. Until recently, in most fields, ignorance was the issue. In the last century, there has been so many improvements, ineptitude is catching up to be an issue. Modern work is complex. Any tool that removes the practitioner to remember things is a good thing. Feature built into product or an external checklist can help.
Lesson is, dramatic improvements in any field do not have come from Nobel winning ideas, although they are helpful. Consistent application of state of art will reduce the number of customers, patients who fall on the wrong side of statistics.
Everyone can do more with data: provide, analyze, feedback.
Now, what can you provide and what can you analyze?
-- I’m writing this more than a week after I listened to this talk. This was about 25 minute talk. This is what I recall. Any mistakes are mine.
-- I had a brief conversation with Atul when I got his autograph on Checklist Manifesto. When I thanked him for giving the idea for my checklist, he asked me if I was the one who blogged about using it and he would be interested in seeing the full checklist. I was pleased he knew about it.
IBM Informix group (as well as many other groups within IBM) have been collaborating with Intel to create and improve products.
I wrote earlier about the benchmark we did earlier with Nehalem and Westmere. Recently, Intel gave us a machine with 8 socket Nehalem (64 cores) and 2TB RAM.... It's been a great to do some performance measurements on this.. More on this as we progress.
At IBM Information on Demand conference at Las Vegas next week, Intel is going to exhibit their latest processors, servers based on those. Tran Jantz from Intel and I will be presenting Intel-Informix talk on Thursday, 11.30, focused on the technologies within Intel and how Informix Warehouse Accelerator is exploiting each of those technologies. To entice you to explore all Intel booths and Intel-IBM talks at IOD, Intel will have a raffle Intel 160GB SSDs -- one at the talk and another at expo. Amazon prize for this is $280.. pretty good deal!
We'll have continuous demo of Informix Warehouse Accelerator. There will also be continuous demo of OAT, Genero, Flex Grid, Smart Data, at the demo room.
Just in time for IOD, updated, reformatted white paper on IBM Informix Warehouse Accelerator is available.
keshavamurthy 0600019DXM Tags:  pronto ibm iod informix time analysis on demad real integration cognos erp 8,295 Views
Couple of years ago, at IOD, Nestle CIO said, enterprises are moving from "reporting model" to "tooling model".
What does that mean? Executives are no longer satisfied with simply using canned reports and taking decisions on it.
They need to have drill down and interact with the data to get the right data to make right decision in real time.
While this trend has been going on for some years, it took incredible investment from CIO and the organization to get
all the pieces together and working together.
That's where Pronto Software comes in.
They have built an incredible award winning ERP application suite
Pronto has complete ERP solution with Informix server and have tightly integrated Cognos BI into the same solution.
From asset management to analytics, distribution to data intelligence, financials to forecasting -- It's all in there.
In this solution, not only they run the business, they help analysts have a conversation with the real-data in real time.
This helps SMB and enterprise, "find their moment"!
At IOD Conference in Las wegas, Wednesday, Oct 24th. 2.30 to 3.30PM, Chad Gates, Senior Development Manager at Pronto
will be talking about this solution and how they've integrated the stack. Should be very interesting.
Look up for session 4202: Pronto Xi, Informix and IBM Cognos 10 – Designing integrated ERP and real-time BI for Mid-Market:
fyi: Pronto also has the demo at the Expo floor.
keshavamurthy 0600019DXM Tags:  pronto cognos on ibm audiocast analysis real informix iod integration time demad erp 9,037 Views
Here are the slides and audiocast of the IOD session:
It's a great guide to ISV/application developers for application, database and BI (Cognos) integration.
I was aware of Pronto's tight integration of ERP, Cognos and Informix.
I was very impressed with how they've implemented multi-tenancy on Informix using multiple databases.
Chad talks about that in slides 45-54, 66 and 67.
Recently, there has been talk about multi-tenancy for public/private Cloud. Here is an implementation of
multi-tenancy on Informix. A good subject to explore further.