Illustra

Last updated
Illustra
Developer(s) Illustra Information Technologies
Final release
3.3 / July, 1997
Type DBMS, ORDBMS
License Commercial proprietary software

Illustra was a commercialized version of the Postgres object-relational database management system (DBMS) sold by Illustra Information Technologies, a company founded in 1992 and formed by Michael Stonebraker, Gary Morgenthaler and several of Michael Stonebraker's current and former students including: Wei Hong, Jeff Meredith, Michael Olson, Paula Hawthorn, Jeff Anton, Cimarron Taylor and Michael Ubell.

The technology's extensibility model centered on DataBlade modules that defined types and associated index methods, operators, and functions for purposes and data domains that included Web publishing, search and manipulation of text, and management of geospatial information. It enabled all kinds of structured and unstructured multimedia data types to be stored as true objects in existing databases, and not just as parcels of data with object wrappers a la Oracle Corp. [1]

In 1995, NASA decided Illustra would be the right tool to store and manipulate millions of satellite photographs. The only stumbling block was the company size: with only 150 employees, Illustra didn't have the manpower or the scale to support the NASA project. [2]

The company was sold to Informix Corporation in 1996 by $400 million in stock, 40 times revenue. Stonebraker's share was $6.5 million, and he became CTO of Informix after the merger, a position he held until September 2000. [2] [3] The technology was folded into the Informix 7 OnLine product line, shipped in December 1996, leading eventually to the creation of the unified Informix Universal Server (IUS) product line, or more generally, Version 9. [4]

The entire Informix product line was sold to IBM, which continued to extend Informix, offering several editions for use under various license metrics (including two editions which are free of charge). In April 2017, IBM delegated active development and support to HCL Technologies for 15 years while keeping part of the marketing responsibilities. [5]

Related Research Articles

<span class="mw-page-title-main">Object database</span> Type of database management system

An object database or object-oriented database is a database management system in which information is represented in the form of objects as used in object-oriented programming. Object databases are different from relational databases which are table-oriented. A third type, object–relational databases, is a hybrid of both approaches. Object databases have been considered since the early 1980s.

A relational database is a 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 for querying and updating the database.

<span class="mw-page-title-main">Informix</span> Database management software product family

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.

<span class="mw-page-title-main">Object–relational database</span> Database management system

An object–relational database (ORD), or object–relational database management system (ORDBMS), is a database management system (DBMS) similar to a relational database, but with an object-oriented database model: objects, classes and inheritance are directly supported in database schemas and in the query language. In addition, just as with pure relational systems, it supports extension of the data model with custom data types and methods.

<span class="mw-page-title-main">Ingres (database)</span>

Ingres Database is a proprietary SQL relational database management system intended to support large commercial and government applications.

<span class="mw-page-title-main">IBM Db2</span> Relational model database server

Db2 is a family of data management products, including database servers, developed by IBM. It initially supported the relational model, but was extended to support object–relational features and non-relational structures like JSON and XML. The brand name was originally styled as DB/2, then DB2 until 2017 and finally changed to its present form.

<span class="mw-page-title-main">Physical schema</span> Representation of a data design

A physical data model is a representation of a data design as implemented, or intended to be implemented, in a database management system. In the lifecycle of a project it typically derives from a logical data model, though it may be reverse-engineered from a given database implementation. A complete physical data model will include all the database artifacts required to create relationships between tables or to achieve performance goals, such as indexes, constraint definitions, linking tables, partitioned tables or clusters. Analysts can usually use a physical data model to calculate storage estimates; it may include specific storage allocation details for a given database system.

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.

Apache Derby is a relational database management system (RDBMS) developed by the Apache Software Foundation that can be embedded in Java programs and used for online transaction processing. It has a 3.5 MB disk-space footprint.

ArcSDE is a server-software sub-system that aims to enable the usage of Relational Database Management Systems for spatial data. The spatial data may then be used as part of a geodatabase.

IBM InfoSphere DataStage is an ETL tool and part of the IBM Information Platforms Solutions suite and IBM InfoSphere. It uses a graphical notation to construct data integration solutions and is available in various versions such as the Server Edition, the Enterprise Edition, and the MVS Edition. It uses a client-server architecture. The servers can be deployed in both Unix as well as Windows.

IBM Informix C-ISAM is an X/Open standards-compliant Application programming interface (API) to an Indexed Sequential Access Method or ISAM.

IBM Data magazine is a U.S.-based custom, online magazine published by TDA Group for IBM Corp. With a worldwide readership of more than 100,000, the magazine provides how-to information about Db2, Informix, UniVerse, and UniData, along with coverage of related tools, software, and solutions.

An embedded database system is a database management system (DBMS) which is tightly integrated with an application software; it is embedded in the application. It is a broad technology category that includes:

<span class="mw-page-title-main">Michael Stonebraker</span> American computer scientist (born 1943)

Michael Ralph Stonebraker is a computer scientist specializing in database systems. Through a series of academic prototypes and commercial startups, Stonebraker's research and products are central to many relational databases. He is also the founder of many database companies, including Ingres Corporation, Illustra, Paradigm4, StreamBase Systems, Tamr, Vertica and VoltDB, and served as chief technical officer of Informix. For his contributions to database research, Stonebraker received the 2014 Turing Award, often described as "the Nobel Prize for computing."

<span class="mw-page-title-main">Vertica</span> Software company

Vertica is an analytic database management software company. Vertica was founded in 2005 by the database researcher Michael Stonebraker with Andrew Palmer as the founding CEO. Ralph Breslauer and Christopher P. Lynch served as CEOs later on.

Informix Corporation was a software company located in Menlo Park, California. It was a developer of relational database software for computers using the Unix, Microsoft Windows, and Apple Macintosh operating systems.

Roger J. Sippl, an American entrepreneur in the computer software industry, was described in 2012 by The Wall Street Journal as a serial entrepreneur. Sippl was the founder and CEO of Informix Corporation, later becoming IBM Informix. Other sippl accomplishments included being co-founder and chairman of Vantive, and the CEO and founder of Visigenic: three companies he took public. Currently, he is the CEO of Elastic Intelligence located in Menlo Park, California.

Paula Birdwell Hawthorn is an American computer scientist. She is recognised as an expert and pioneer in database systems. She has also founded organisations for women in computer science and created affirmative action programs to support students in the field.

References

  1. "INFORMIX FINALIZES ILLUSTRA ACQUISITION, WILL SHIP OBJECT-RELATIONAL SERVER DATABASE BY YEAR-END". Tech Monitor. February 16, 1996. Retrieved 2023-04-12.
  2. 1 2 "Michael Stonebraker The ultimate database". Forbes. July 7, 1997.
  3. "Informix History" . Retrieved 2023-04-12.
  4. McNally, John; Miller, Glenn; Prajesh, Jim; Prajesh, Jim (1996). Informix, with CD-ROM (Unleashed). USA: Sams. p. 9. ISBN   0672306506.
  5. "IIUG" (PDF). Archived from the original (PDF) on 2017-09-08. Retrieved 2017-04-24.