Explore free trials for IBM Software products and try them before you buy. Download software or try products in the cloud. 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. DataDirect's broad range of industry leading data connectors, drivers and connectivity tools provide instant access to any data source for faster time to market. DbVisualizer is tested and verified for Microsoft Windows 7/Vista/XP, Linux Fedora, Ubuntu and macOS. We also test with the databases and JDBC drivers listed on this page.

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. In April 2017, IBM and HCL Technologies (Products & Platforms Division) agreed to a long-term, 15-year partnership to co-develop, support, and market the product.^[2]

IBM has delegated active development and support to HCL and shares marketing of the key Informix products with HCL. The current version of Informix is 14.10 and 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 improve its support for data warehouse workloads.

Ibm Informix Jdbc Driver

The data model exposed by our JDBC Drivers can easily be customized to add or remove tables/columns, change data types, etc. Without requiring a new build. These customizations are supported at runtime using human-readable schema files that are easy to edit.

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 JSON, BSON, 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 data sets based on semi-structured, time series, and spatial data.

Key products[edit]

The current^[when?] version of IBM Informix is 14.10. The major enhancements made over previous releases were adding built-in index compression, integration of JSON collections with support for MongoDB JSON drivers into the server, and an enhancement permitting database objects to be partitioned across multiple servers in a cluster or grid (aka sharding). Queries can optionally return data from the locally connected server instance or from an entire grid with the same SQL. Informix version 14.10 introduced support for partial indexing where only a subset of the rows in a table are indexed and for multi-valued key indexes which support indexing the elements within multi-valued data types such as LIST, SET, MULTISET, and BSON array fields.

Heterogeneous 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 is offered in a number of editions, including free developer editions, editions for small and mid-sized business, and editions supporting the complete feature set and designed to be used in support of the largest enterprise applications.

There is also an advanced data warehouse edition of Informix. This version includes the Informix Warehouse Accelerator which uses a combination of newer technologies including in-memory data, tokenization, deep compression, and columnar database technology to provide extreme high performance on business intelligence and data warehouse style queries.

Informix TimeSeries is a unique^{[citation needed]} 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.

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 zSeries platform as well as on Windows, 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 it offers, such as Netezza, a data warehouse appliance, and Cloudant, a NoSQL database. IBM has described its 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 for in-store deployments.

With the ability to deeply embed Informix in gateways and routers, timeseries support, small footprint, and low administration requirements, Informix is also targeted at Internet-of-Things solutions, where many of the.

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]

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]}

Ibm Informix Jdbc Driver Programmer's Guide

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.^[3]

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',^[4] 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.

Users groups[edit]

Users groups remain active^[5] in Belgium,^[6] Croatia,^[7] France, Germany, the United States, and many other countries. The IIUG (International Informix Users Group) acts as a federation of those user groups and provides numerous services to its members.

See also[edit]

References[edit]

1. ^'Informix V14.10 documentation'. 2021-01-22. Retrieved 2021-01-22.
2. ^'IIUG'(PDF). Archived from the original(PDF) on 2017-09-08. Retrieved 2017-04-24.
3. ^'IBM - IBM Information Management Training and Certification'. 306.ibm.com. 2010-04-01. Retrieved 2010-06-16.
4. ^developerWorks: Wikis - Informix on Campus - Informix in a Box
5. ^'Local User Groups'.
6. ^'Welcome to the Benelux Informix User Group'.
7. ^'Adria IUG (Udruga Informix korisnika Adria)'.

External links[edit]

Ibm Informix Jdbc Driver Download