Informix 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.
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. Through extensions, Informix supports data types that are not a part of the SQL standard.
On 24th Jul, 2020 HCL announced OneDB Database Server V1.0.0.0 as a multi-model (relational, object-relational, and dimensional) DBMS based on Informix. On August 19, 2021 HCL released OneDB 2.0 as a cloud native, multi-cloud, Kubernetes-orchestrated offering.
On December 29, 2021 Actian (formerly Ingres Corporation) became fully owned by HCL America. Actian remained a separate entity, now acting as the Data, Analytics and Insights division of HCLSoftware. It's expected 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.
As of 2023, the current version of both IBM and HCL 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).
This page is automatically generated and may contain information that is not correct, complete, up-to-date, or relevant to your search query. The same applies to every other page on this website. Please make sure to verify the information with EPFL's official sources.
Ingres Database (ɪŋˈɡrɛs ) is a proprietary SQL relational database management system intended to support large commercial and government applications. Actian Corporation, which announced April 2018 that it is being acquired by HCL Technologies, controls the development of Ingres and makes certified binaries available for download, as well as providing worldwide support. There was an open source release of Ingres but it is no longer available for download from Actian. However, there is a version of the sourcecode still available on GitHub.
The following tables compare general and technical information for a number of relational database management systems. Please see the individual products' articles for further information. Unless otherwise specified in footnotes, comparisons are based on the stable versions without any add-ons, extensions or external programs. The operating systems that the RDBMSes can run on. Information about what fundamental RDBMS features are implemented natively. Note (1): Currently only supports read uncommited transaction isolation.
A relational database is a (most commonly digital) database based on the relational model of data, as proposed by E. F. Codd in 1970. A system used to maintain relational databases is a relational database management system (RDBMS). Many relational database systems are equipped with the option of using SQL (Structured Query Language) for querying and updating the database. The term "relational database" was first defined by E. F. Codd at IBM in 1970. Codd introduced the term in his research paper "A Relational Model of Data for Large Shared Data Banks".
For several decades, online transaction processing has been one of the main applications that drives innovations in the data management ecosystem, and in turn the database and computer architecture communities. Despite the novel approaches from industry an ...