IBM Informix
 |
|
| Developer(s) | IBM |
|---|---|
| Stable release | IBM Informix 11.7xC5 / May 26, 2012 |
| Development status | Active |
| Written in | C, C++, assembly |
| Operating system | Cross-platform |
| Type | RDBMS |
| License | Proprietary EULA |
| Website | Official IBM website |
IBM Informix is a product family within IBM's Information Management division that is centered on several relational database management system (RDBMS) offerings. The Informix products were originally developed by Informix Corporation, whose Informix Software subsidiary was acquired by IBM in 2001.
IBM has continued active development and marketing of the key Informix products, the current version of which 11.7 forms the basis of several product editions with variation in capacity and functionality. The Informix database has been used in many high transaction rate OLTP applications in the retail, finance, energy and utilities, manufacturing and transportation sectors. More recently the server has been enhanced to support data warehouse workloads.
The Informix server supports the object-relational model, which has permitted IBM to offer extensions that support data types that are not a part of the SQL standard. The most widely used of these are the time series and spatial extensions, which provide both data type support and language extensions that permit high performance domain specific queries and efficient storage for datasets based around time series and spatial data.
Contents |
Key Products [edit]
The current version of IBM Informix is 11.7, it was code-named "Panther" during development. The major enhancements made were adding built-in data compression and a major enhancement of the ability of the database engine to run on clusters. Heterogenous clusters are fully supported, and there are several deployment options that are available, including some that provide very high levels of data redundancy and fault tolerance. This feature is marketed by IBM as Informix Flexible Grid.
Informix 11.7 is offered in a number of editions, including free developer editions, editions for small and midsized business, and editions supporting the complete feature set and designed to be used in support of the largest enterprise applications.
There is also a data warehouse edition of Informix 11.7. This version includes the Informix Warehouse Accelerator which uses a combination of newer technologies including in-memory data, tokenization and columnar database technology to provide high performance on business intelligence and data warehouse style queries.
Informix TimeSeries is a unique feature of the database system that allows for efficient and fast manipulation of time series data, such as that generated by devices such as smart electric meters, or as found in financial trading systems with time stamped stock 'ticks'. This type of data is not well suited to storage or use in the normal SQL supported style of data organization.
Unique among IBM database products the Apple Mac environment is supported by Informix 11.7.
Positioning [edit]
IBM has several database products with capabilities which overlap in some areas. Informix is often compared to IBM's other major database product, DB2, which is offered on the mainframe Z series platform as well as on Unix and Linux. Speculation that IBM would combine Informix with DB2, or with other database products has proven to be unfounded.
IBM has instead continued to expand the variety of database products they offer, through the acquisition of SolidDB, an in-memory database, and Netezza a data warehouse appliance. They have described their approach to the market as providing "workload optimized systems".
Informix is generally considered to be optimized for environments with very low or no database administration, including use as an embedded database. It has a long track record of supporting very high transaction rates and providing uptime characteristics needed for mission critical applications such as manufacturing lines and reservation systems. Informix has been widely deployed in the retail sector, where the low administration overhead makes it useful as an in-store deployment.
Other Products [edit]
In addition to the products based on the version 11.7 engine the IBM Informix family also includes a number of legacy database products which are still supported in market. These include Informix OnLine, Informix Standard Edition (SE) and Informix C-ISAM. These products are simpler and smaller footprint database engines that are also frequently embedded in third party applications. Collectively these products are often referred to as the "Informix Classics".
The IBM Informix family also includes a client side development environment, the Client-SDK, which supports a number of different environments including .net for Windows developers and a variety of protocols for Unix and Linux environments.
Obsolete and Non-IBM Informix Heritage Products [edit]
The article on the history of the Informix Software company prior to the acquisition by IBM contains an overview of many other products which were offered by the company in its 20 year history. Many were discontinued prior to the acquisition by IBM, including Wingz an early spreadsheet.
Some products that were at one time owned by Informix are still in market, either through other divisions of IBM, or through completely different companies. The UniVerse and UniData (U2) products, for instance, are now sold by Rocket Software as Rocket U2.
Plans [edit]
IBM has long-term plans for both Informix and DB2, with both databases sharing technology with each other, although IBM has continually denied fusion of the two products[citation needed].
Training and certification [edit]
IBM Training includes a complete set of core Data Servers Training courses that apply to Informix. These courses delve into many essential Informix concepts, from fundamentals to advanced SQL topics.[1]
As part of IBM's Academic Initiative, IBM is offering Informix software, documentation and training to higher education institutions worldwide through its new Informix on Campus program. IBM is offering an inclusive package of Informix materials to college faculty called "Informix In a Box",[2] which offers hands-on labs and PowerPoints to use in lessons, recorded training for teachers, DVDs with class material and VMware virtual appliance images, as well as T-shirts for students.
See also [edit]
References [edit]
- ^ "IBM - IBM Information Management Training and Certification". 306.ibm.com. 2010-04-01. Retrieved 2010-06-16.
- ^ developerWorks: Wikis - Informix on Campus - Informix in a Box
External links [edit]
- IBM Informix site
- The Real Story of Informix Software and Phil White, promotion website for a book (ISBN 0972182225) published in 2005 by Sand Hill Publishing
- IIUG (International Informix Users Group) IIUG
- Informix India and South East Asia, a User Group Community
- The Informix Zone, a community website
- planetIDS, an Informix Blog Aggregator
- The (good) problem with Informix from theregister.co.uk
- Free Informix Books and Guides from freebookcentre.net
|
||||||||||||||||||||
|
||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
