IBM Informix - SQL & NoSQL
From archive: April 2011 X
keshavamurthy 0600019DXM Tags:  faster performance update tuning informix smarter statistics 3,380 Views
At 2010 IIUG conference, when Jack Parker saw the preview of Informix warehouse accelerator, he offered his Amex card to buy the product. Two problems: I couldn't sell since the product was not released. I presume his Amex card has some credit limits :-) I suspect, after that incident, Jack started working on his performance tuning in the old route and produced nice article on Informix Performance tuning (part 1).
Note to Jack -- Good news is Informix Ultimate Warehouse Edition with Informix Warehouse Accelerator is now GA. You can buy it any time, even with your Amex.
Nita Dembla developed smarter, faster update statistics for Informix 11.70 and has a good article on it. If you're on 11.70, you should automatically be experiencing the the faster update statistics. With little bit of time, you can make it way faster!. Check out the article.
keshavamurthy 0600019DXM Tags:  grid phoenix informix group user flexible warehouse accelerator ultimate edition arizona 3,240 Views
On May 2nd, we have a Arizona Informix user group meeting. Mahesh, Madison and I will be talking and demoing at the event.
We're in conference room 539, 2929 N. Central Ave, Phoenix, AZ 85012
Here's the agenda:
12:30 - 1:00 Lunch
1:00 - 1:30 Roadmap + future directions. Mahesh dashora, Senior Manager, IBM Informix Development
1:30 - 2:30 Informix Ultimate Warehouse + IWA + IWA Demo. Keshav Murthy. STSM, Informix Development
2:30 - 4:00 Flexible Grid Madison Pruet. STSM, Informix Development.
4.00+ Q&A, Networking.
Looking forward to seeing our AZ customers.
keshavamurthy 0600019DXM Tags:  group conference prize iiug informix user 4gl ibm free genero 3,702 Views
To celebrate the CHANGING of The Guard with Anita McKeithen from IBM taking over the CHAT WITH THE LABS, the IIUG is going to give away ONE full conference pass INCLUDING a Full Day of Tutorials at its annual conference, more than a $1000 value to one lucky attendee of the first CHAT with the LABS that Anita is hosting, this Thursday April 21, 2011. For details about the IIUG conference May 15 - 18, 2011 in Overland Park (KC area), KS, USA visit http://www.iiug.org/conf
And anyone on the call can get a FREE day of Sunday tutorials included with their registration if they are on the call.... For details, join the call and we will tell you how to get this VERY limited one time offer. (New Registrations Only)
The Call Details
April 21, 2011
11:30 AM - 1:00 PM Eastern (GMT-05:00)
10:30 AM Central
8:30 AM Pacific
16:30 hrs London
17:30 hrs Frankfurt, Paris
10:00 PM India
IBM Informix Genero
Speakers: Jerry Keesee (Director of Informix worldwide, IBM), Shawn Moe(IBM Technical Product Manager)
IBM Informix Genero is a new product that we are happy to be able to offer in partnership with Four Js. Informix Genero offers an exciting set of functionality for the modernization of Informix 4GL applications. In this Chat with the Labs session, we will discuss the business aspects of the new Informix Genero offering, including packaging, sales, and technical support. Informix Genero is offered in both development and runtime editions. We will discuss some of the new language constructs, platform support, and other functionality that Informix Genero offers to Informix 4GL developers. We'll discuss the Informix Genero architecture, some approaches for converting from Informix 4GL to Informix Genero, and some options for extending your applications with the new Informix Genero user interface functionality. We'll wrap it up with a discussion on Informix Genero web services and how they extend the new Informix 4GL web services support.
Jerry Keesee, Director of the Informix Lab will introduce the call and Shawn Moe, IBM Technical Product Manager will be our technical speaker.
Presentation material will be available at http://www.ibm.com/informix/labchats prior to the event.
To register and receive instructions for attending this webinar, point your browser to:
keshavamurthy 0600019DXM Tags:  ibm informix sap accelerator ex5 warehouse hana 2 Comments 4,850 Views
The Doloitte technology trends 2011 report point to new in-memory technologies like SAP HANA changing the business intelligence is done.
This trend bodes well for IBM Informix warehouse accelerator (IWA) we recently released. SAP HANA and IWA both try to exploit in-memory systems to accelerate query performance and reduce administration+tuning at the same time. These used to be inversely correlated, but with 3rd generation database technology, we're trying to get both together! It's like talking and browsing together on the phone! :-)
I saw one of their videos indicating queries on 700m row fact tables returned in 5-7 seconds... IWA has similar numbers with queries on more than billion row fact tables returning 2-4 seconds. IWA is transparent to Informix applications, runs in virtualized environment, on the cloud, etc -- are plus points for IWA. It'll be interesting to see if someone spends time to do a full blown comparison.
The improvements in hardware configurations are aiding this trent as well.
Recently, IBM announced new versions of eX5 systems. New MAX5 expansion capabilities include:
• Eight-socket x3850 X5: up to 192 DIMM slots (6 TB)
• Four-socket x3850 X5: up to 96 DIMM slots (3 TB)
• Two-socket x3690 X5: up to 64 DIMM slots (2 TB)
• Two-socket HX5: up to 32 DIMM slots (512 GB)
Having these large memory systems enable more VMs and enable improved CPU usage.
These systems bring down the overall cost and improve the cpu utilization for existing software.
New generation of software like IWA automatically maximize the CPU usage and larger memory systems enable larger data warehouse.
The eX5 tagline is:Maximize your memory, minimize cost, simplify deployment.
This -- and maximize performance -- could very well have been tag line for IWA as well :-)
Database deployments are increasing on the cloud. Data management requirements are increasing. There are couple database-as-a-services already in place (SQL Azure from Microsoft and database.com from salesforce)... There could be more..I haven't done exhaustive search.
The promise of perceived unlimited hardware in the cloud -- public, private, hybrid -- requires change in the database approach/architecture/etc. The traditional single machine or cluster assumptions won't work. Although, I've referenced Amazon cloud many times, these should be applicable to any cloud. I plan to do more with IBM Cloud soon... :-)
1. Automatic installation, patching and upgrade: Customer requiring the database service should have no requirement to request/copy/install/etc. What if customer running a app on the cloud can simply connect to database service, specify some high level sizing (low/med/high), start creating databases/tables/etc without having to worry about *anything else*. This should be part of the service rather than a customer/IT/DBA worrying about it. Eventually, we'll probably have sense the data growth and transparently handle via instance migration/scale out/etc.
2. Automatic High Availability and failover. Because this is a service, high availability should be part of the infrastructure/installation and not something DBA/etc have to setup. Amazon storage services comes with HA automatically... There's nothing for the user of this service to do. When you request for database service, the database/etc should have HA as a built-in feature.
3. Automatic Scaling: The mechanism to add or subtract the servers will be very domain specific. Amazon itself has a scaling service (http://aws.amazon.com/autoscaling/). However, at the database level, scaling brings multitude of issues. Does that mean replicated servers or application aware data partitioning (aka sharding). When you have grid of servers, do you support grid object reference or support query partitioning based on workload? This is a big question. With Hadoop, customers have scaled out to 1000s of nodes. We've to define the domain for database and deal with it.
4. Automatic Tuning: Based on the instance (small, medium, large) and policy (oltp/warehouse/mixed) the tuning (initial and feedback based) should be done (mostly) automatically and behind the scene. Some of the recent products like Informix Warehouse Accelerator, SAP's HANA try to limit or eliminate tuning altogether.
5. Automatic Backup. In the EC2 for example, the databases should be automatically backed up to S3. IBM Cloud will have its equivalent. With HA available, restore will be required lesser for recovery, but more for cloning across data centers/zones/etc.
6. Automatic Syncronization: public, private, hybrid cloud is the reality. Enterprises need to export and import data between on premise and cloud or between cloud to cloud deployment. The service should provide very easy way to do this synchronization without customers having to write programs/maintain it/etc.
7. Automatic Security: For customers who haven't used (or are not going to use) Cloud, Security is the biggest concern. Obviously, many customers have solved/moved beyond this. We've to implement the industry best practices and enable standard protocol (SSL,etc) for data access.
I'll have some blogs in later on to see how Informix is addressing these as a product...we don't have a cloud service... yet!