IBM updated its Informix database with a number of performance enhancements.
IBM has released an updated version of
its Informix database with an emphasis on improved performance.
In Informix 11.7, IBM is touting a number
"There are quite
a few features
that contributed to the performance [improvements]-for
warehouse improvement the primary ones were star/snowflake schema optimizations
and multi-index scans," noted Bernie Spang, director of database software
and systems marketing. "We are taking the best features from our XPS
warehouse product and merging them into Informix. ... For OLTP [online
transaction processing] there are a number of features. There is a new feature
called Forrest of Trees that improves certain kinds of queries. There are other
features that allow you to do things as online operations rather than having to
kick users off-things like attaching and detaching a new table fragment.
"We also did a lot of work to improve client connection performance.
Related to that, we also have demonstrated improved performance on P7 hardware-compared
to P6 we have 60 percent improvement," he added.
IBM also introduced the new IBM
Informix Flexible Grid, which is designed to keep data available to
applications at all times and gives clients flexibility to scale data
management across regional or global clusters while mixing different hardware
and operating systems. Previously, distributed clusters required maintaining
consistent hardware and software levels, according to IBM.
IBM is offering multiple editions of
Informix, including the new Innovator-C Edition, which is free to download and
deploy and includes a redistribution option available for partners. This
enables use of Informix on-demand by removing the initial cost barrier while
offering optional fee-based support when needed, IBM
"The different Informix editions have different grid/clustering
capabilities built-in, with different limits, depending on which edition,"
Spang said. "For example, the Innovator-C Edition and Choice Edition allow
a two-node grid. The Growth Edition allows a three-node grid. The Ultimate
Edition has unlimited grid/clustering capabilities."
All new editions run on Windows, Linux, Unix and Mac OS X operating systems.