View source for Informix

{{Short description|Database management software product family}}
{{use American English|date=October 2022}}
{{use MDY dates|date=October 2022}}
{{For|the company|Informix Corporation}}
{{Infobox software
| name                   = IBM Informix
| logo                   = IBM logo.svg
| programming language = <!--Citation is needed to add this-->
| developer              = [[IBM]] / [[HCLTech | HCL Technologies]]
| latest release version = 15.0.0.1
| latest release date    = {{release date|2025|3|15}}<ref>{{cite web |url=https://www.ibm.com/docs/en/informix-servers/14.10?topic=overview-whats-new-in-informix#xc10_new |title=Informix V15.0.0.1 documentation |website=[[IBM]] |date=May 24, 2023 |access-date=2023-05-24 |archive-date=May 24, 2023 |archive-url=https://web.archive.org/web/20230524224705/https://www.ibm.com/docs/en/informix-servers/14.10?topic=overview-whats-new-in-informix#xc10_new |url-status=live }}</ref>
| genre = [[Multi-model database]]
| license                = [[Commercial software|Commercial]] [[proprietary software]]
| website                = {{URL|www.ibm.com/products/informix}}
}}
{{Infobox software
| name                   = HCL Informix
| logo                   = HCLTech-new-logo.svg
| programming language = <!--Citation is needed to add this-->
| developer              = [[HCLTech | HCL Technologies]]
| latest release date    = {{release date|2025|3|31}}<ref>{{cite web
|url=https://help.hcltechsw.com/hclinformix/1infocenter/idsfmx/xc10/relnotes_ifx1410xc10.html
   |title=Release documentation and machine notes for HCL Informix, v15.0.0.1
 |date=May 24, 2023 |access-date=2023-05-24}}</ref>
| latest release version = 15.0.0.1
| genre = [[Multi-model database]]
| license                = [[Commercial software|Commercial]] [[proprietary software]]
| website                = {{URL|https://www.hcltechsw.com/informix}}
}}
{{Infobox software
| name                   = OneDB
| logo                   = HCLTech-new-logo.svg
| programming language = <!--Citation is needed to add this-->
| developer              = [[HCLTech | HCL Technologies]]
| latest release date    = {{release date|2023|5|1}}<ref>{{cite web
|url=https://help.hcltechsw.com/onedb/2.0.1.3/1infocenter/new_features_ce.html|title=What's new in HCL OneDB 2.0.1|access-date=2023-05-25}}</ref>
| latest release version = 2.0.1.3
| genre = [[Multi-model database]]
| license                = [[Commercial software|Commercial]] [[proprietary software]]
| website                = {{URL|https://www.hcltechsw.com/onedb}}
}}
'''Informix'''<ref name=IFXaqdByIBM2001NYT>{{cite news
|newspaper=[[The New York Times]]
|url=https://www.nytimes.com/2001/04/25/business/technology-ibm-will-acquire-database-unit-of-informix-for-1-billion.html
|title=I.B.M. Will Acquire Database Unit of Informix for $1 Billion
|author=Barnaby J. Feder
|date=April 25, 2001
|access-date=October 25, 2022
|archive-date=October 25, 2022
|archive-url=https://web.archive.org/web/20221025230638/https://www.nytimes.com/2001/04/25/business/technology-ibm-will-acquire-database-unit-of-informix-for-1-billion.html
|url-status=live
}}</ref><ref>{{cite news |last=Morgan |first=Timothy Prickett
  |title=IBM Buys Other Half of Informix with Ascential Acquisition
  |url=http://www.itjungle.com/tfh/tfh032105-story04.html  |accessdate=September 12, 2012|newspaper=IT Jungle |date=March 21, 2005
  |url-status=dead |archive-url=https://web.archive.org/web/20130309040232/http://www.itjungle.com/tfh/tfh032105-story04.html |archive-date=March 9, 2013}}</ref><ref name=IBMifx2022Datamation>{{cite news
  |newspaper=[[Datamation]]
  |url=https://www.datamation.com/big-data/data-replication-market/
  |title=The Data Replication Market in 2022
  |author=Anina Ot
  |date=February 24, 2022
  |access-date=October 25, 2022
  |archive-date=October 26, 2022
  |archive-url=https://web.archive.org/web/20221026071242/https://www.datamation.com/big-data/data-replication-market/
  |url-status=live
  }}</ref> is a product family within IBM's Information Management division that is centered on several [[relational database management system]] (RDBMS) and [[multi-model database]] offerings. The Informix products were originally developed by [[Informix Corporation]], whose Informix Software subsidiary was acquired by IBM in 2001.

In April 2017, IBM delegated active development and support to [[HCL Technologies]] for 15 years, with a number of IBM employees working on Informix also moving to HCL. As part of this arrangement IBM will continue to market and sell it as IBM Informix to their customers, with HCLTech able to market and sell it as HCL Informix.<ref>{{Cite web |url=http://iiug2017.org/guide.pdf |title=IIUG |access-date=2017-04-24 |archive-url=https://web.archive.org/web/20170908221745/http://iiug2017.org/guide.pdf |archive-date=2017-09-08 |url-status=dead }}</ref>

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 [[online transaction processing|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.<ref name=WarehousIW2009>{{cite news |newspaper=[[InformationWeek]]
  |url=https://www.informationweek.com/software/information-management/informix-gets-optional-data-warehousing-feature-from-ibm/d/d-id/1077362
  |title=Informix Gets Optional Data Warehousing Feature From IBM
  |date=March 6, 2009}}</ref> Through extensions, Informix supports data types that are not a part of the [[SQL]] standard.

On July 24, 2020, HCL announced OneDB Database Server V1.0.0.0 as a multi-model (relational, object-relational, and dimensional) DBMS based on Informix.<ref>{{Cite web |url=https://help.hcltechsw.com/onedb/1.0.0.0/1infocenter/po.html |title=HCL OneDB V1.0.0.0 Product overview |access-date=2023-05-25 |archive-date=May 25, 2023 |archive-url=https://web.archive.org/web/20230525181114/https://help.hcltechsw.com/onedb/1.0.0.0/1infocenter/po.html |url-status=live }}</ref> On August 19, 2021 HCL released OneDB 2.0 as a cloud native, multi-cloud, Kubernetes-orchestrated offering.<ref>{{Cite web|url=https://blog.hcltechsw.com/onedb/introducing-hcl-onedb-2-0/|title=Introducing HCL OneDB 2.0|date=August 19, 2021|author=Amanda Tevis|work=Blog HCLSoftware|access-date=2023-05-25|archive-date=May 25, 2023|archive-url=https://web.archive.org/web/20230525181119/https://blog.hcltechsw.com/onedb/introducing-hcl-onedb-2-0/|url-status=live}}</ref>

On December 29, 2021, [[Actian]] (formerly Ingres Corporation) became fully owned by HCL America.<ref>{{Cite web |url=https://www.moneycontrol.com/news/business/announcements/hcl-america-acquires-remaining-stake-in-hcl-technologies-sep-holdings-7881821.html|title=HCL Technologies subsidiary boosts stake to fully own Actian Corporation's parent|date=December 30, 2021 |access-date=2023-05-25}}</ref> Actian remained a separate entity, now acting as the ''Data, Analytics and Insights'' division of HCLSoftware.<ref>{{Cite web|url=https://www.actian.com/company/news-and-events/press-releases/hcl-technologies-and-sumeru-equity-partners-acquire-actian-corporation/|title=HCL Technologies and Sumeru Equity Partners to Acquire Actian Corporation|access-date=2023-05-25|archive-date=May 25, 2023|archive-url=https://web.archive.org/web/20230525181114/https://www.actian.com/company/news-and-events/press-releases/hcl-technologies-and-sumeru-equity-partners-acquire-actian-corporation/|url-status=live}}</ref> It is expected that the Informix portfolio will be transferred from HCL to Actian, with HCL Informix and OneDB already available for download at Actian's Electronic Software Distribution (ESD) portal.

==Key products==
As of 2025, the current version of both IBM and HCL Informix is 15.0. The major enhancement in v15.0 over previous releases is the removal of most internal limits including limits on the number of rows per data page, the number of data pages in a table partition,availability of additional larger page sizes, and the total storage that can be managed by a single Informix instance. 

The major enhancements made in v14.10 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 [[Shard (database architecture)|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.

IBM 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 used to be an advanced data warehouse edition, including the Informix Warehouse Accelerator (IWA), but it was deprecated in favor of the Advanced Enterprise Edition (which give entitlement rights to IWA).

Regarding HCL Informix, there is a single commercial version available, which is compatible with the IBM Informix Advanced Enterprise Edition, also having rights to IWA. There is also a trial version available, with no known limits, except for an expiration date.

HCL Informix 14.10 key highlights include:  
* Functional parity with IBM Informix 14.10 for on-premises deployment  
* Replacement of FlexNet license management with a script-based monitoring solution, consistent with other Actian offerings  
* Expanded O/S support with the addition of Linux on Power Little Endian and Solaris Sparc.

==Positioning==
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 data-handling requirements can be handled with gateways that embed Informix and connect sensors and devices to the internet.

==Other products==
In addition to the products based on the version 15.0 engine the 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 Informix family also includes:
* '''Informix Client-SDK''': a client-side development environment which supports a number of different environments including .net for Windows developers and a variety of protocols for Unix and Linux environments.
* '''[[IBM_Informix-4GL|Informix-4GL]]''': a fourth generation language for application programming development.
* '''Informix Warehouse Accelerator (IWA)''': an in-memory database based on IBM BLU acceleration technology,<ref>{{cite web |url=https://docs.deistercloud.com/content/Databases.30/IBM%20Informix%20IWA.4/index.xml?embedded=true |title=Informix Warehouse Accelerator |publisher=Deister |access-date=2024-01-30 |archive-date=January 30, 2024 |archive-url=https://web.archive.org/web/20240130161835/https://docs.deistercloud.com/content/Databases.30/IBM%20Informix%20IWA.4/index.xml?embedded=true |url-status=live }}</ref> 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. IWA can be installed on the same computer as the Informix database server or another one. It receives copies of data from the database server and organizes it into data marts.<ref>{{cite web |url=https://www.ibm.com/docs/pt-br/informix-servers/14.10?topic=accelerator-overview-informix-warehouse |title=Overview of Informix Warehouse Accelerator |publisher=IBM |date=2023-03-15 |access-date=2024-01-30 |archive-date=January 30, 2024 |archive-url=https://web.archive.org/web/20240130164836/https://www.ibm.com/docs/pt-br/informix-servers/14.10?topic=accelerator-overview-informix-warehouse |url-status=live }}</ref>
* '''Informix Enterprise Gateway''': it connects the Informix environment with that of any shared-library ODBC Level 2-compliant driver manager and driver on UNIX or Linux.<ref>{{cite web |url=https://www.ibm.com/docs/en/informix-servers/14.10?topic=dbspaces-importing-data-enterprise-gateway-products |title=Importing data with Enterprise Gateway products |publisher=IBM |date=2024-01-08 |access-date=2024-01-30 |archive-date=January 30, 2024 |archive-url=https://web.archive.org/web/20240130164838/https://www.ibm.com/docs/en/informix-servers/14.10?topic=dbspaces-importing-data-enterprise-gateway-products |url-status=live }}</ref> Enterprise Gateway allows Informix database application developers and users to access information on DB2, Oracle, Sybase and other non-Informix databases as easily and transparently as if they were accessing an Informix database server.
[[Informix Corporation|Obsolete and non-IBM Informix heritage products]] can run via emulation on modern hardware. {{CN|date=October 2022}}

==Training and certification==
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.<ref>{{cite web |url=http://www-306.ibm.com/software/data/education/ |title=IBM - IBM Information Management Training and Certification |publisher=306.ibm.com |date=2010-04-01 |access-date=2010-06-16 |archive-date=March 6, 2008 |archive-url=https://web.archive.org/web/20080306092806/http://www-306.ibm.com/software/data/education/ |url-status=live }}</ref>

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",<ref>[https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/Informix%20on%20Campus developerWorks: Wikis - Informix on Campus - Informix in a Box] {{Webarchive|url=https://web.archive.org/web/20210128224502/https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/Informix%20on%20Campus |date=January 28, 2021 }}</ref> 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==
Users groups remain active<ref>{{cite web | title=Local User Groups | url=http://www.iiug.org/community/lug.html}}</ref> in Belgium,<ref>{{cite web | title=Welcome to the Benelux Informix User Group | url=http://www.informix-clubhouse.org/ | access-date=June 8, 2014 | archive-date=May 17, 2014 | archive-url=https://web.archive.org/web/20140517111045/http://www.informix-clubhouse.org/ | url-status=live }}</ref> Croatia,<ref>{{cite web | title=Adria IUG (Udruga Informix korisnika Adria) | url=http://www.adria-iug.org/ | access-date=June 8, 2014 | archive-date=June 10, 2014 | archive-url=https://web.archive.org/web/20140610093943/http://www.adria-iug.org/ | url-status=live }}</ref> 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==
* [[Comparison of relational database management systems]]
* [[List of relational database management systems]]

==References==
{{Reflist}}

==External links==
* {{Official website|https://www.ibm.com/products/informix}}

{{Databases|cat=no}}
{{IBM Db2 product family}}
{{IBM}}
{{Authority control}}

<!-- try to maintain a sorted appearance -->
[[Category:Client-server database management systems]]
[[Category:Data companies]]
[[Category:Informix|Informix]]
[[Category:Proprietary database management systems]]
[[Category:Relational database management systems]]
[[Category:Relational database management software for Linux]]