Misplaced Pages

#963036

79-479: 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

158-590: 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 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. As of 2023,

237-427: A company with a history of mergers and acquisitions. That acquisition gave Informix the legacy MultiValue database platforms UniVerse and UniData, known collectively as U2 (now Rocket U2 ), as well as a small but growing set of Extract Transform and Load (ETL) and other information integration products, the latter were the target of the acquisition being well positioned in a fast-growing market segment. In July 2000,

316-642: A federal grand jury. However, he was a citizen and resident of Germany, and the United States was unable to secure his extradition. In November 2005, Steve W. Martin, a longtime Informix employee, published a book detailing the rise and fall of Informix Software and CEO Phil White, titled The Real Story of Informix Software and Phil White: Lessons in Business and Leadership for the Executive Team . In March 2000, Informix acquired Ardent Software,

395-415: A fine of $ 10,000, two years of supervised release, and 300 hours of community service. The announcement noted that the loss to shareholders caused by the violation could not reasonably be estimated under the facts of the case. White's earlier plea agreement had limited prison time to no more than 12 months. Walter Königseder, the company's vice president in charge of European operations, was also indicted by

474-435: A formal settlement negotiated between the two companies, the lawsuit was withdrawn and Informix issued a statement retracting their accusations against the former employees. Other details of the settlement were not made public. Corporate misgovernance overshadowed Informix's technical successes. On April 1, 1997, Informix announced that first quarter revenues fell short of expectations by $ 100 million. CEO Phillip White blamed

553-482: A multi-threaded core well suited towards the symmetric multiprocessing systems that Sequent pioneered and that major vendors like Sun Microsystems and Hewlett-Packard would eventually follow up on. The two forms of parallelism made the product capable of market-leading levels of scalability, both for OLTP and data warehousing. Now known as Informix Dynamic Server (after briefly entertaining the name Obsidian and then being named Informix OnLine Dynamic Server), Version 7 hit

632-660: A new application development product, Informix-NewEra, was soon overshadowed by the emerging Java programming language. Michael Stonebraker had promised that the Illustra technology would be integrated within a year after the late 1995 acquisition, but as Gartner Group had predicted, the integration required more than 2 years. Unhappy with the new direction of the company, XPS lead architect Gary Kelley suddenly resigned and joined arch-rival Oracle Corporation in early 1997, taking 11 of his developers with him. Informix ultimately sued Oracle to prevent loss of trade secrets. As part of

711-420: A new query engine, initially known as INFORMIX-Turbo. Turbo used the new Random Sequential Access Method (RSAM), with great multi-user performance benefits over C-ISAM. With the release of the version 4.00 products in 1989, Turbo was renamed INFORMIX-OnLine (in part because it permitted coherent database backups while the server was online and users were modifying the data), and the original server based on C-ISAM

790-399: A new row is written to the table, a new unique value for the primary key is generated; this is the key that the system uses primarily for accessing the table. System performance is optimized for PKs. Other, more natural keys may also be identified and defined as alternate keys (AK). Often several columns are needed to form an AK (this is one reason why a single integer column is usually made

869-454: 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

SECTION 10

#1732792987964

948-470: A rather updated GUI as Claris Resolve. With its failure in office automation products, Informix refocused on the growing database server market. In 1994, as part of a collaboration with Sequent Computer Systems , Informix released its version 6.00 database server, which featured its new Dynamic Scalable Architecture, DSA. DSA involved a major rework of the core engine of the product, supporting both horizontal parallelism and vertical parallelism, and based on

1027-445: A relational database system is composed of Codd's 12 rules . However, no commercial implementations of the relational model conform to all of Codd's rules, so the term has gradually come to describe a broader class of database systems, which at a minimum: In 1974, IBM began developing System R , a research project to develop a prototype RDBMS. The first system sold as an RDBMS was Multics Relational Data Store (June 1976). Oracle

1106-408: A route to increasing the desktop "grunt" required to run large financial models. For a brief period[not specific enough to verify], Wingz was successfully marketed into this niche. However it suffered from a lack of development and marketing resources. By the early 1990s WingZ had become uncompetitive, and Informix eventually sold it in 1995. Informix also sold a license to Claris, who combined it with

1185-455: A single relation, even though they may grab information from several relations. Also, derived relations can be used as an abstraction layer . A domain describes the set of possible values for a given attribute, and can be considered a constraint on the value of the attribute. Mathematically, attaching a domain to an attribute means that any value for the attribute must be an element of the specified set. The character string "ABC" , for instance,

1264-577: A small relational database based on ISAM techniques, as a part of a report-writer software package. Sippl and King left Cromemco to found Relational Database Systems (RDS) in 1980. Their first product, Marathon, was essentially a 16-bit version of their earlier ISAM work, made available first on the C8000 from Onyx Systems . At RDS, they turned their attention to the emerging RDBMS market and released their own product as Informix (INFORMation on unIX) in 1981. It included their own Informer language. It featured

1343-620: A spreadsheet program for the Apple Macintosh. WingZ provided a graphical user interface, supported larger, 32768x32768 dimension spreadsheets, and offered programming in a HyperCard-like language known as HyperScript. The original release proved successful, becoming the number two spreadsheet, behind Microsoft Excel. In 1990, WingZ ports started appearing for a number of other platforms, mostly Unix variants. During this period, many financial institutions began investing in Unix workstations as

1422-558: A system. For increased security, the system design may grant access to only the stored procedures and not directly to the tables. Fundamental stored procedures contain the logic needed to insert new and update existing data. More complex procedures may be written to implement additional rules and logic related to processing or selecting the data. The relational database was first defined in June 1970 by Edgar Codd , of IBM's San Jose Research Laboratory . Codd's view of what qualifies as an RDBMS

1501-558: A third party for an external package which remains an unconvincing solution. In 1997 Informix purchased a billboard on the interstate across from Oracle's headquarters in Redwood City, CA . The billboard read "Dinosaur Crossing", a tongue-in-cheek jab at Oracle's supposed lagging state in the industry. Although Informix took a technological lead in the database software market, product releases began to fall behind schedule by late 1996. Plagued with technical and marketing problems,

1580-414: A tuple (restricting combinations of attributes) or to an entire relation. Since every attribute has an associated domain, there are constraints ( domain constraints ). The two principal rules for the relational model are known as entity integrity and referential integrity . Every relation /table has a primary key, this being a consequence of a relation being a set . A primary key uniquely specifies

1659-476: A tuple within a table. While natural attributes (attributes used to describe the data being entered) are sometimes good primary keys, surrogate keys are often used instead. A surrogate key is an artificial attribute assigned to an object which uniquely identifies it (for instance, in a table of information about students at a school they might all be assigned a student ID in order to differentiate them). The surrogate key has no intrinsic (inherent) meaning, but rather

SECTION 20

#1732792987964

1738-503: Is analogous to using the index of a book to go directly to the page on which the information you are looking for is found, so that you do not have to read the entire book to find what you are looking for. Relational databases typically supply multiple indexing techniques, each of which is optimal for some combination of data distribution, relation size, and typical access pattern. Indices are usually implemented via B+ trees , R-trees , and bitmaps . Indices are usually not considered part of

1817-402: 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

1896-495: 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

1975-497: Is not in the integer domain, but the integer value 123 is. Another example of domain describes the possible values for the field "CoinFace" as ("Heads","Tails"). So, the field "CoinFace" will not accept input values like (0,1) or (H,T). Constraints are often used to make it possible to further restrict the domain of an attribute. For instance, a constraint can restrict a given integer attribute to values between 1 and 10. Constraints provide one method of implementing business rules in

2054-562: 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", 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 remain active in Belgium, Croatia, France, Germany,

2133-453: Is summarized in Codd's 12 rules . A relational database has become the predominant type of database. Other models besides the relational model include the hierarchical database model and the network model . The table below summarizes some of the most important relational database terms and the corresponding SQL term: In a relational database, a relation is a set of tuples that have

2212-446: Is useful through its ability to uniquely identify a tuple. Another common occurrence, especially in regard to N:M cardinality is the composite key . A composite key is a key made up of two or more attributes within a table that (together) uniquely identify a record. Foreign key refers to a field in a relational table that matches the primary key column of another table. It relates the two keys. Foreign keys need not have unique values in

2291-522: The Unix , Microsoft Windows , and Apple Macintosh operating systems. Informix Software, Inc., was a software company which sold database products, desktop software and development tools, and information integration products from 1980 until 2005, becoming approximately a $ 1 billion company in the process. The company was active in the Unix, PC, Linux and Macintosh markets, and grew through both organic development and acquisitions. Its best known products were

2370-417: The normal forms . Connolly and Begg define database management system (DBMS) as a "software system that enables users to define, create, maintain and control access to the database". RDBMS is an extension of that initialism that is sometimes used when the underlying database is relational. An alternative definition for a relational database management system is a database management system (DBMS) based on

2449-569: The relational model . Most databases in widespread use today are based on this model. RDBMSs have been a common option for the storage of information in databases used for financial records, manufacturing and logistical information, personnel data, and other applications since the 1980s. Relational databases have often replaced legacy hierarchical databases and network databases , because RDBMS were easier to implement and administer. Nonetheless, relational stored data received continued, unsuccessful challenges by object database management systems in

Informix - Misplaced Pages Continue

2528-406: The "Informix Classics". The Informix family also includes: Obsolete and non-IBM Informix heritage products can run via emulation on modern hardware. 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. As part of IBM's Academic Initiative, IBM

2607-534: The "big three" database companies (the others being Oracle and Sybase) to offer built-in O-R support. Commentators paid particular attention to the DataBlades, which soon became very popular: dozens appeared within a year, ported to the new architecture after partnerships with Illustra. This left other vendors scrambling, with Oracle introducing a "grafted on" package for time-series support in 1997, and Sybase turning to

2686-496: The 1980s and 1990s, (which were introduced in an attempt to address the so-called object–relational impedance mismatch between relational databases and object-oriented application programs), as well as by XML database management systems in the 1990s. However, due to the expanse of technologies, such as horizontal scaling of computer clusters , NoSQL databases have recently become popular as an alternative to RDBMS databases. Distributed Relational Database Architecture (DRDA)

2765-527: The ACE report writer, which is used to extract data from the database and present it to users for easy reading. It also featured the PERFORM screen form tool, which allowed a user to interactively query and edit the data in the database. The final release of this product was version 3.30 in early 1986. In 1985, they introduced a new SQL -based query engine as part of INFORMIX-SQL (or ISQL) version 1.10 (version 1.00

2844-480: The Informix databases, of which there were several different families. Other well known products included a development environment called 4GL, a spreadsheet called Wingz , and a data warehouse oriented database system called Redbrick, and the Ascential information integration family of products. The Informix brand and database products were acquired by IBM in 2001, and several of the most popular products remain on

2923-448: The PK). Both PKs and AKs have the ability to uniquely identify a row within a table. Additional technology may be applied to ensure a unique ID across the world, a globally unique identifier , when there are broader system requirements. The primary keys within a database are used to define the relationships among the tables. When a PK migrates to another table, it becomes a foreign key (FK) in

3002-549: 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. Relational database management system The concept of relational database was defined by E. F. Codd at IBM in 1970. Codd introduced the term relational in his research paper "A Relational Model of Data for Large Shared Data Banks". In this paper and later papers, he defined what he meant by relation . One well-known definition of what constitutes

3081-485: The basic server as options. These included solutions to a number of thorny SQL problems, namely time series, spatial and multimedia data. Informix integrated Illustra's O-R mapping and DataBlades into the 7.x OnLine product, resulting in Informix Universal Server (IUS), or more generally, Version 9. Both new versions, V8 (XPS) and V9 (IUS), appeared on the market in 1996, making Informix the first of

3160-438: The basis of interaction among these tables. These relationships can be modelled as an entity-relationship model . In order for a database management system (DBMS) to operate efficiently and accurately, it must use ACID transactions . Part of the programming within a RDBMS is accomplished using stored procedures (SPs). Often procedures can be used to greatly reduce the amount of information transferred within and outside of

3239-402: The columns represent values attributed to that instance (such as address or price). For example, each row of a class table corresponds to a class, and a class corresponds to multiple students, so the relationship between the class table and the student table is "one to many" Each row in a table has its own unique key. Rows in a table can be linked to rows in other tables by adding a column for

Informix - Misplaced Pages Continue

3318-484: The company continued to struggle with accounting practices, re-stating earnings again in early 1998. The capabilities of Informix Dynamic Server (IDS) began to strengthen. New leadership began to emerge as well. An excerpt from the September 22, 1998 issue of PC Magazine's article on the top 100 companies that are changing the way you compute: In November 2002, Phillip White, the former CEO of Informix ousted in 1997,

3397-617: The current understanding on the relational model, as expressed by Christopher J. Date , Hugh Darwen and others), it is not relational. This view, shared by many theorists and other strict adherents to Codd's principles, would disqualify most DBMSs as not relational. For clarification, they often refer to some RDBMSs as truly-relational database management systems (TRDBMS), naming others pseudo-relational database management systems (PRDBMS). As of 2009, most commercial relational DBMSs employ SQL as their query language . Alternative query languages have been proposed and implemented, notably

3476-406: 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 ). Queries can optionally return data from

3555-401: The database and support subsequent data use within the application layer. SQL implements constraint functionality in the form of check constraints . Constraints restrict the data that can be stored in relations . These are usually defined using expressions that result in a Boolean value, indicating whether or not the data satisfies the constraint. Constraints can apply to single attributes, to

3634-447: The database technology, the brand, the plans for future development (an internal project codenamed "Arrowhead"), and the customer base (over 100,000 customers) associated with these items. The deal closed on July 1, 2001. Approximately 2,000 Informix employees moved to IBM as part of the deal. Informix shareholders approved this deal, which delivered $ 1 billion in cash to the much smaller remaining company, which intended to focus on

3713-469: The database, as they are considered an implementation detail, though indices are usually maintained by the same group that maintains the other parts of the database. The use of efficient indexes on both primary and foreign keys can dramatically improve query performance. This is because B-tree indexes result in query times proportional to log(n) where n is the number of rows in a table and hash indexes result in constant time queries (no size dependency as long as

3792-480: The five leading proprietary software relational database vendors by revenue were Oracle (48.8%), IBM (20.2%), Microsoft (17.0%), SAP including Sybase (4.6%), and Teradata (3.7%). Informix Corporation Informix Corporation , formerly Informix Software, Inc. , was a software company located in Menlo Park, California. It was a developer of relational database software for computers using

3871-552: The former CEO of Ardent, Peter Gyenes, became the CEO of Informix, and soon re-organized Informix to make it more attractive as an acquisition target. The major step was separating the database engine technologies from the recently acquired Ardent Software ETL and Information Integration products. In April 2001, IBM negotiated with Informix to buy the core database business. Prompted by a suggestion from Wal-Mart, one of Informix's largest customers, Janet Perna led IBM's purchase of Informix

3950-404: The high growth ETL and information integration space, dominated at the time by Informatica. The company renamed itself Ascential Software, and continued to be led by CEO Peter Geyenes and President Peter Fiore. Ascential Software made use of its large cash holdings from the Informix sale to buy a number of smaller companies with technology. Many were had at bargain prices as the software industry

4029-450: The internet. In addition to the products based on the version 14.1 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

SECTION 50

#1732792987964

4108-479: The late 1995 purchase of Illustra, concentrated on object-relational database (O-R) technology. Illustra, written by ex-Postgres team members and led by database pioneer Michael Stonebraker, included various features that allowed it to return fully formed objects directly from the database, a feature that can significantly reduce programming time in many projects. Illustra also included a feature known as DataBlades that allowed new data types and features to be included in

4187-557: 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

4266-404: 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

4345-504: The market and are continuing to be enhanced by IBM. For information on the current Informix branded database software products see the article IBM Informix . At the time of the acquisition of Informix by IBM a smaller spin-off company was created, Ascential Software, focused on the information integration and ETL markets. Ascential Software was later acquired by IBM as well, in 2005. Founders Roger Sippl and Laura King worked at Cromemco , an early S-100 / CP/M company, where they developed

4424-584: The market in 1994. Version 7 consistently won performance benchmarks. Building on the success of Version 7, Informix split its core database development investment into two efforts. One effort, first known as XMP (for eXtended Multi-Processing), became the Version 8 product line, also known as XPS (for eXtended Parallel Server). This effort focused on enhancements in data warehousing and parallelism in high-end platforms, including shared-nothing platforms such as IBM's RS-6000/SP . The second focus, which followed

4503-519: The original eight including relational comparison operators and extensions that offer support for nesting and hierarchical data, among others. Normalization was first proposed by Codd as an integral part of the relational model. It encompasses a set of procedures designed to eliminate non-simple domains (non-atomic values) and the redundancy (duplication) of data, which in turn prevents data manipulation anomalies and loss of data integrity. The most common forms of normalization applied to databases are called

4582-506: The other table. When each cell can contain only one value and the PK migrates into a regular entity table, this design pattern can represent either a one-to-one or one-to-many relationship. Most relational database designs resolve many-to-many relationships by creating an additional table that contains the PKs from both of the other entity tables – the relationship becomes an entity;

4661-446: The pre-1996 implementation of Ingres QUEL . A relational model organizes data into one or more tables (or "relations") of columns and rows , with a unique key identifying each row. Rows are also called records or tuples . Columns are also called attributes. Generally, each table/relation represents one "entity type" (such as customer or product). The rows represent instances of that type of entity (such as "Lee" or "chair") and

4740-458: The referencing relation. A foreign key can be used to cross-reference tables, and it effectively uses the values of attributes in the referenced relation to restrict the domain of one or more attributes in the referencing relation. The concept is described formally as: "For all tuples in the referencing relation projected over the referencing attributes, there must exist a tuple in the referenced relation projected over those same attributes such that

4819-400: The relational model were from: The most common definition of an RDBMS is a product that presents a view of data as a collection of rows and columns, even if it is not based strictly upon relational theory . By this definition, RDBMS products typically implement some but not all of Codd's 12 rules. A second school of thought argues that if a database does not implement all of Codd's rules (or

SECTION 60

#1732792987964

4898-594: The relevant part of the index fits into memory). Queries made against the relational database, and the derived relvars in the database are expressed in a relational calculus or a relational algebra . In his original relational algebra, Codd introduced eight relational operators in two groups of four operators each. The first four operators were based on the traditional mathematical set operations : The remaining operators proposed by Codd involve special operations specific to relational databases: Other operators have been introduced or proposed since Codd's introduction of

4977-399: The resolution table is then named appropriately and the two FKs are combined to form a PK. The migration of PKs to other tables is the second major reason why system-assigned integers are used normally as PKs; there is usually neither efficiency nor clarity in migrating a bunch of other types of columns. Relationships are a logical connection between different tables (entities), established on

5056-522: 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 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. On August 19, 2021 HCL released OneDB 2.0 as

5135-435: The same attributes . A tuple usually represents an object and information about that object. Objects are typically physical objects or concepts. A relation is usually described as a table , which is organized into rows and columns . All the data referenced by an attribute are in the same domain and conform to the same constraints. The relational model specifies that the tuples of a relation have no specific order and that

5214-547: The shortfall on a loss of focus on the core database business while devoting too many resources to object-relational technology. Huge operating losses and job cuts followed. Informix re-stated earnings from 1994 through 1996. A significant amount of revenue from the mid-1990s involved software license sales to partners who did not sell through to an end-user customer; this and other irregularities led to overstating revenue by over $ 200 million. Even after White's departure in July, 1997,

5293-460: The standard declarative SQL syntax. Stored procedures are not part of the relational database model, but all commercial implementations include them. An index is one way of providing quicker access to data. Indices can be created on any combination of attributes on a relation . Queries that filter using those attributes can find matching tuples directly using the index (similar to Hash table lookup), without having to check each tuple in turn. This

5372-767: The tuple contains a candidate or primary key then obviously it is unique; however, a primary key need not be defined for a row or record to be a tuple. The definition of a tuple requires that it be unique, but does not require a primary key to be defined. Because a tuple is unique, its attributes by definition constitute a superkey . All data are stored and accessed via relations . Relations that store data are called "base relations", and in implementations are called "tables". Other relations do not store data, but are computed by applying relational operations to other relations. These relations are sometimes called "derived relations". In implementations these are called " views " or "queries". Derived relations are convenient in that they act as

5451-473: The tuples, in turn, impose no order on the attributes. Applications access data by specifying queries, which use operations such as select to identify tuples, project to identify attributes, and join to combine relations. Relations can be modified using the insert , delete , and update operators. New tuples can supply explicit values or be derived from a query. Similarly, queries identify tuples for updating or deleting. Tuples by definition are unique. If

5530-401: The unique key of the linked row (such columns are known as foreign keys ). Codd showed that data relationships of arbitrary complexity can be represented by a simple set of concepts. Part of this processing involves consistently being able to select or modify one and only one row in a table. Therefore, most physical implementations have a unique primary key (PK) for each row in a table. When

5609-689: The values in each of the referencing attributes match the corresponding values in the referenced attributes." A stored procedure is executable code that is associated with, and generally stored in, the database. Stored procedures usually collect and customize common operations, like inserting a tuple into a relation , gathering statistical information about usage patterns, or encapsulating complex business logic and calculations. Frequently they are used as an application programming interface (API) for security or simplicity. Implementations of stored procedures on SQL RDBMS's often allow developers to take advantage of procedural extensions (often vendor-specific) to

5688-652: Was caught up in the economic slump following the 9/11/2001 terrorist attacks. Despite these acquisitions Ascential was not able to ever come anywhere near matching the financial performance of Informix prior to the sale, and were eventually forced to perform a 4 for 1 reverse stock split to ensure that the stock was not delisted from NASDAQ for falling below the minimum share price. In May 2005, IBM bought Ascential, reuniting all of Informix's assets under IBM's Information Management Software portfolio. The deal paid Ascential shareholders $ 1.1 billion, however IBM assumed control of $ 481 million in cash that Ascential had retained from

5767-602: 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: Informix

5846-593: Was designed by a workgroup within IBM in the period 1988 to 1994. DRDA enables network connected relational databases to cooperate to fulfill SQL requests. The messages, protocols, and structural components of DRDA are defined by the Distributed Data Management Architecture . According to DB-Engines , in January 2023 the most popular systems on the db-engines.com web site were: According to research company Gartner , in 2011,

5925-465: Was indicted by a federal grand jury and charged with eight counts of securities, wire, and mail fraud. In a plea bargain thirteen months later, he pleaded guilty to a single count of filing a false registration statement with the U.S. Securities and Exchange Commission. In May 2004, the Department of Justice announced that White was sentenced to two months in federal prison for securities fraud, with

6004-514: Was known as C-ISAM. Through the early 1980s Informix remained a small player, but as Unix and SQL grew in popularity during the mid-1980s, their fortunes changed. By 1986 they had become large enough to float a successful IPO, and changed the company name to Informix Software. The products included INFORMIX-SQL version 2.00 and INFORMIX-4GL 1.00, both of which included the database engine as well as development tools (I4GL for programmers, ISQL for non-programmers). A series of releases followed, including

6083-461: Was never released). This product also included SQL variants of ACE and PERFORM. The most significant difference between ISQL and the previous Informix product was the separation of the database access code into an engine process (sqlexec), rather than embedding it directly in the client — thus setting the stage for client-server computing, with the database running on a separate machine from the user's machine. The underlying ISAM-based file storage engine

6162-412: Was released in 1979 by Relational Software, now Oracle Corporation . Ingres and IBM BS12 followed. Other examples of an RDBMS include IBM Db2 , SAP Sybase ASE , and Informix . In 1984, the first RDBMS for Macintosh began being developed, code-named Silver Surfer, and was released in 1987 as 4th Dimension and known today as 4D. The first systems that were relatively faithful implementations of

6241-433: Was separated from the tools (ISQL and I4GL) and named INFORMIX-SE (Standard Engine). Version 5.00 of Informix OnLine was released at the very end of 1990, and included full distributed transaction support with two-phase commit and stored procedures. Version 5.01 was released with support for triggers too. In 1988, Informix purchased Innovative Software, makers of a DOS and Unix-based office system called SmartWare and WingZ ,

#963036