Ingres (database)

Database software

This article is about the technical development of the database. For the commercial history of the database and its ownership, see Actian.

Ingres

Original author(s)| University of California, Berkeley
Developer(s)| Actian
Stable release|

11.2 / May 6, 2022; 2 years ago (2022-05-06)[1]

Written in| C
Operating system| Cross-platform
Type| RDBMS
License| Proprietary, used to be open source GNU General Public License
Website| www.actian.com/products/operational-databases/ingres/

Logo used from 2005 to 2011

Ingres Database (/ɪŋˈɡrɛs/ ing-GRESS) 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,[2] 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.[3]

In its early years, Ingres was an important milestone in the history of database development. Ingres began as a research project at UC Berkeley, starting in the early 1970s and ending in 1985.[4] During this time Ingres remained largely similar to IBM's seminal System R in concept; it differed in more permissive licensing of source code, in being based largely on DEC machines, both under UNIX[5] and VAX/VMS,[6] and in providing QUEL as a query language instead of SQL. QUEL was considered at the time to run truer to Edgar F. Codd's relational algebra (especially concerning composability), but SQL was easier to parse and less intimidating for those without a formal background in mathematics.[7]

When ANSI preferred SQL over QUEL as part of the 1986 SQL standard (SQL-86), Ingres became less competitive against rival products such as Oracle until future Ingres versions also provided SQL.[8] Many companies spun off of the original Ingres technology, including Actian itself, originally known as Relational Technology Inc., and the NonStop SQL database originally developed by Tandem Computers but now offered by Hewlett Packard Enterprise.

## History

[edit]

Ingres began as a research project at the University of California, Berkeley, starting in the early 1970s and ending in 1985.[4] The original code, like that from other projects at Berkeley, was available at minimal cost under a version of the BSD license. Ingres spawned a number of commercial database applications, including Sybase, Microsoft SQL Server, NonStop SQL and a number of others.[9]

Postgres (Post Ingres), a project which started in the mid-1980s,[10] later evolved into PostgreSQL. It is ACID compatible and is fully transactional (including all DDL statements) and is part of the Lisog open-source stack initiative.

### 1970s

[edit]

In 1973 when the System R project was getting started at IBM, the research team released a series of papers describing the system they were building.[9] Two scientists at Berkeley, Michael Stonebraker and Eugene Wong, became interested in the concept after reading the papers, and started a relational database research project of their own.[11]

They had already raised money for researching a geographic database system for Berkeley's economics group, which they called Ingres, for INteractive Graphics REtrieval System. They decided to use this money to fund their relational project instead, and used this as a seed for a new and much larger project. They decided to re-use the original project name, and the new project became University INGRES.[11] For further funding, Stonebraker approached the DARPA, the obvious funding source for computing research and development at the time, but both the DARPA and the Office of Naval Research (ONR) turned them down[12] as they were already funding database research elsewhere. Stonebraker then introduced his idea to other agencies, and, with help from his colleagues he eventually obtained modest support from the NSF[13] and three military agencies: the Air Force Office of Scientific Research, the Army Research Office, and the Naval Electronic Systems Command.

Thus funded, Ingres was developed during the mid-1970s by a rotating team of students and staff. Ingres went through an evolution similar to that of System R, with an early prototype in 1974 followed by major revisions to make the code maintainable. Ingres was then disseminated to a small user community, and project members rewrote the prototype repeatedly to incorporate accumulated experience, feedback from users, and new ideas. The research project ended in 1985.[4]

### Commercialization (1980s)

[edit]

Ingres remained largely similar to IBM's System R in concept, but it was based largely on DEC machines, both under UNIX[5]

Unlike System R, the Ingres source code was available (on tape) for a nominal fee. By 1980 some 1,000 copies had been distributed,[14] primarily to universities. Many students from U.C. Berkeley and other universities who used the Ingres source code worked on various commercial database software systems.

Berkeley students Jerry Held and later Karel Youseffi moved to Tandem Computers, where they built a database system that evolved into NonStop SQL. The Tandem database system was a re-implementation of the Ingres technology.[15] It evolved into a system that ran effectively on parallel computers; that is, it included functionality for distributed data, distributed execution, and distributed transactions (the last being fairly difficult). Components of the system were first released in the late 1970s. By 1989, the system could run queries in parallel and the product became fairly famous for being one of the few systems that scales almost linearly with the number of processors in the machine: adding a second CPU to an existing NonStop SQL server will almost exactly double its performance. Tandem was later purchased by Compaq, which started a re-write in 2000, and now the product is at Hewlett-Packard Enterprise.

In the early 1980s, Ingres competed head-to-head with Oracle.[16] The two products were widely regarded as the leading hardware-independent relational database implementations; they had comparable functionality, performance, market share, and pricing, and many commentators considered Ingres to be a (perhaps marginally) superior product. From around 1985, however, Ingres steadily lost market share. One reason was Oracle's aggressive marketing; another was the increasing recognition of SQL as the preferred relational query language. Ingres originally had provided a different language, QUEL, and the conversion to SQL (delivered in Ingres version 6) took about three years, losing valuable time in the race.

Robert Epstein, the chief programmer on the project while he was at Berkeley, formed Britton Lee, Inc.[17] along with other students from the Ingres Project, Paula Hawthorn and Michael Ubell; they were joined later by Eric Allman. Later, Epstein founded Sybase. Sybase had been the #2 product (behind Oracle) for some time through the 1980s and into the 1990s, before Informix came "out of nowhere" and took over in 1997. Sybase's product line had also been licensed to Microsoft in 1992, who rebranded it as Microsoft SQL Server. This relationship soured in the late 1990s, and today SQL Server outsells Sybase by a wide margin.

### Relational Technologies, Inc. (RTI)

[edit]

Several companies used the Ingres source code to produce products. The most successful was a company named Relational Technology, Inc. (RTI), founded in 1980 by Stonebraker and Wong, and another Berkeley professor, Lawrence A. Rowe.[18] RTI was renamed Ingres Corporation in the late 1980s. The company ported the code to DEC VAX/VMS, which was the commercial operating system for DEC VAX computers. They also developed a collection of front-end tools for creating and manipulating databases (e.g., reporterwriters, forms entry and update, etc.) and application development tools. Over time, much of the source was rewritten to add functionality (for example, multiple-statement transactions, SQL, B-tree access method, date/time datatypes, etc.) and improve performance (for example, compiled queries, multithreaded server).

The company was purchased by ASK Corporation in November 1990. The founders left the company over the next several months.

### Computer Associates

[edit]

This article needs additional citations for verification. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed.
Find sources: "Ingres" database – news · newspapers · books · scholar · JSTOR (January 2024) (Learn how and when to remove this message)

|

In 1994, ASK/Ingres was purchased by Computer Associates[19][20]

In February 2000, Computer Associates announced the general availability of Ingres II 2.0 for Linux. Besides the components found in the SDK, the full edition contains more modules, such as:

* Net: this component makes possible for Ingres utilities and user applications to access databases residing on different installations.
* Replicator: support for replication functions.
* Star: for handling distributed databases.
* Enterprise Access: communication with different database management systems and other, non-relational data sources (used to be called Gateways).
* Protocol Bridge: for communicating with clients on different types of networks.
* Spatial Object Library: for handling two-dimensional spatial objects.

Ingres versions 6.4 and Ingres II have long been a commonly used database management system (DBMS), mainly in data center operations at universities and other public bodies. For a while, it was still able to resist Oracle's dominance due to low licensing costs.

In addition to the low license fees, Ingres II had the advantage of lower resource requirements over Oracle, for example, which is why it could also be used on smaller machines. Disadvantages were the more difficult usability, the lower number of platforms on which this system ran and fewer Ingres-capable applications.

On the grounds that the performance of Ingres was comparable to that of other large DBMS, Computer Associates raised the license fees sharply, thereby losing a key advantage over Oracle. Insufficient marketing by Computer Associates and the resulting lack of sales as well as a lack of IT technicians who master this system and who could be called on when necessary were partly responsible for a decline in marketshare. As a result, Ingres installations were increasingly replaced by Oracle implementations (only about 15,000 installations worldwide in 2004).

In 2004, Computer Associates (CA) released Ingres R3 under CA Trusted Open Source License (CATOSL), an open source license. The code includes the DBMS server and utilities and the character-based front-end and application-development tools. In essence, it shipped everything except OpenROAD, the Windows 4GL GUI-based development environment.

### Ingres Corporation

[edit]

In November 2005, Garnett & Helfrich Capital, in partnership with Computer Associates, created a new company called Ingres Corporation, which provided support and services for Ingres, OpenROAD, and the connectivity products.

In February 2006, Ingres Corporation released Ingres 2006 under the GNU General Public Licence. Ingres 9.3 was released on October 7, 2009.[21] It was a limited release targeted at new application development on Linux and Windows only.[22]

The company focused on the open-source community, with the following initiatives:

* Community Bundles – Alliances with other open-source providers and projects, such as Alfresco, JasperSoft, Hibernate, Apache Tomcat, and Eclipse, enable Ingres to provide its platform and technology with other open-source technologies.
* Ingres Icebreaker BI: in 2007, Ingres Corporation partnered with Jaspersoft and rPath start-up to released this Business Intelligence software based appliance.[23] It consisted of the Ingres 2006 database with rPath Linux and business intelligence tools from JasperSoft.[24] Although it included no hardware, Ingres called it an appliance because all the components of the software stack were tightly integrated and the company supported all the software itself.[25]
* Ingres CAFÉ (Consolidated Application Foundation for Eclipse), created by a team of developers at Carleton University, is an integrated environment that helps software architects accelerate and simplify Java application development.[26]
* Ingres Geospatial was community-based project to create industry-standards-compliant geospatial storage features in the Ingres DBMS. In other words, for storing map data and providing powerful analysis functions within the DBMS.[27]
* Established by Ingres and Carleton University, a series of Open Source Boot Camps were held in 2008 to work with other open-source communities and projects to introduce university and college students and staff to the concepts and realities of open source.[28]
* Other involvement includes: Global Ingres University Alliances, Ingres Engineering Summit, Ingres Janitors Project and several memberships in open-source initiatives.

Ingres 10 was released on October 12, 2010, as a full release, supporting upgrade from earlier versions of the product.[29] It was available on 32-bit and 64-bit Linux, and 32-bit Microsoft Windows.[30]

In November 2010 Garnett & Helfrich Capital acquired the last 20% of equity in Ingres Corp that it did not already own.[31]

### Actian

[edit]

Main article: Actian

On September 22, 2011, Ingres Corporation became Actian Corporation, focusing on data management and integration technologies, including Vectorwise/Vector, Btrieve/Pervasive PSQL/Zen, OpenROAD and the Ingres database.

Actian was acquired by HCL Technologies and Sumeru Equity Partners for $330 million.[32] In 2021, HCL Technologies became the sole owner of Actian, which became the Data and Analytics division of HCLSoftware.

## Actian X - The new Ingres

[edit]

In 18 April 2017, Actian X was announced as the first natively integrated hybrid database, designed to manage transactional, analytic and hybrid data workloads from a single database.[33]

Actian X combines the features and capabilities of Ingres and Vector, including column-based storage, vector processing, multi-core parallelism (and more):[34]

* DataConnect 11 for Actian X: DataConnect is an end-to-end application integration solution for designing and deploying data integration with Ingres applications. The bundle included a GUI and development engine, for designing and testing integrations, and a production engine for deployment.
* Enterprise Monitoring Appliance (EMA): helps maintain the health of databases and host systems by monitoring and setting alerts for key system functions like disk usage, I/O performance, transaction log files and network latency. EMA provides early warnings and alerts so problems and potential problems can be quickly resolved.
* Cloud Backup Service: a scalable, secure managed service for storing and managing Ingres backups. More than file or system backup, the service is designed with tight Ingres integration. Backup agents monitor Ingres for checkpoints and journals, and transfer them to cloud storage automatically ensuring consistent backups and successful restores.
* Geospatial: Several geospatial enhancements, highlighted by the ArcGIS plug-in for ESRI, which enables ArcGIS desktop tools to visualize and manipulate Ingres geospatial data. Added 3D support for R-Tree indexes and in-line geospatial functions improves query performance and greatly simplifies coding for geospatial features.
* New features and enhancements: MERGE support, a reuse heuristic for query optimization, compression of network communications, automatic log file rotation, blob encryption, etc.

## Version History

[edit]

* Berkeley-Ingres ("University" Ingres, currently 8.9,[35] public domain)
* RTI Ingres 5.x
* RTI Ingres 6.1 to 6.4
* CA OpenIngres 1.0 to 2.0
* CA Ingres II 2.0 to 2.5
* CA Advantage Ingres 2.6
* CA Ingres R3 (3.0) (under the CA Trusted Open Source License)
* Ingres 2006 (under version 2 of the GPL )
* Ingres 2006 Release 2
* Ingres Database 9.2
* Ingres Database 9.3
* Ingres Database 10
* Actian Ingres 10S (10.1)
* Actian Ingres 10.2
* Actian Ingres 11.0
* Actian Ingres 11.2 [36]
* Actian X 11.0 to 11.2 [37]

### Actian X Release history

[edit]

Release  | General availability  | End of Enterprise Support  | End of Extended Support  | End of Obsolescence Support  | Notes

|
|
|
|
|

Older version, yet still maintained: Actian X 11.0
(Linux and Windows)  | 31-Mar-17  | 30-Jun-22  | 30-Jun-25  | 30-Jun-29  |
Older version, yet still maintained: Actian X 11.1
(Linux and Windows)  | 17-Apr-19  | 30-Apr-23  | 30-Apr-27  | 30-Apr-31  |
Current stable version: Actian X 11.2
(Linux and Windows) | 27-May-21  | 31-May-25  | 31-May-29  | 31-May-33  |

Legend:

Old version

Older version, still maintained

Latest version

Latest preview version

Future release

### Ingres Release history

[edit]

Release  | General availability  | End of Enterprise Support  | End of Extended Support  | End of Obsolescence Support  | Notes

|
|
|
|
|

Old version, no longer maintained: Ingres 6.4  | September, 1991  | 30-Sep-01  | —  | 31-Dec-08  |
Old version, no longer maintained: OpenIngres 1.x & 2.x  | January, 1996  | September 31, 2000  | —  | 31-Dec-08 | It integrated an unstructured data type (audio, video, blob), temporary tables (in memory) and the Visual DBA administration suite
Old version, no longer maintained: Ingres II 2.0  | February, 1999  | 1-May-05  | 31-Dec-08 | 31-Dec-13  | Line locking, variable page size, massive loading, server level replication (the old system of capturing data modifications by rules has been abandoned).
Old version, no longer maintained: Ingres II 2.5  | July, 2001  | 31-Dec-07  | 31-Dec-12  | 31-Dec-17  | First Ingres version for Linux. This version also made it possible to fully exploit 64-bit architectures. Introduction of the JDBC driver.
Old version, no longer maintained: Ingres II 2.6  | May, 2002  | 31-Dec-09  | 31-Dec-14  | 31-Dec-19  | First enterprise-class DBMS to fully exploit the 64-bit architecture under Linux. Support for XML, Unicode and improvement and splitting of administration tools (Ingres Visual Manager, Ingres Performance Monitor, Ingres Import Assistant, Ingres Visual SQL, etc).
Old version, no longer maintained: Ingres R3  | November, 2004  | 31-Dec-07  | —  | —  | Computer Associates makes Ingres R3 open source under the CATOSL license. Support for partitioned tables, parallel query and a new data optimization algorithm.
Old version, no longer maintained: Ingres 2006 (9.0 & 9.1)  | March, 2007  | 31-Dec-11  | 31-Dec-16  | 31-Dec-21  | Entry of Ingres into the world of open source products (under GPL license). Stability, further enhanced functionality and performance, ease of installation. Release of IceBreaker BI.
Older version, yet still maintained: Ingres 9.2  | November, 2008  | 31-Dec-15  | 31-Dec-20  | 31-Dec-25  | Improved support for JDBC, .Net and PHP in terms of performance. Log shipping features and UTF-8 support.
Older version, yet still maintained: Ingres 10.0  | September, 2010  | 31-Dec-16  | 31-Dec-21  | 31-Dec-26  | The release contains a number of major enhancements that minimize application development time when migrating applications from other databases to Ingres. New features include support for multi-version concurrency control (MVCC), high-performing batched statement execution, full scalar subquery support, support for identifiers up to 256 characters long, and column-level data encryption. The release supports an automated, seamless migration from earlier versions of Ingres.
Older version, yet still maintained: Ingres 10S (10.1)  | May, 2012  | 31-May-17  | 31-May-22  | 31-May-27  | Includes comprehensive spatial support, allowing to extend location-based data through spatial-aware applications, avoiding complex add-ons and integrations with other databases, and no need to pay extra to access geospatial features.
Older version, yet still maintained: Ingres 10S (10.1) - VMS Itanium Only  | April, 2014  | 31-May-18  | 31-May-23 | 31-May-28 |
Older version, yet still maintained: Ingres 10.2  | 4-Sep-14  | 1-Sep-19  | 1-Sep-22  | 1-Sep-25  | New features include 2-D, 3-D and 4-D Spatial Data Types, Remote GCA, UTF-8 Transliteration, DBMS Level Authentication, IPV4 and IPV6 Data Types and Functions and Per-query Parallelism Level. Users can also take their first steps into Big Data Analytics by applying the new Windowing functions to their existing transactional data.
Older version, yet still maintained: Ingres 11.0 (Solaris SPARC, Solaris AMD, AIX and 32-bit Windows)  | 31-Mar-17  | 31-May-23  | 31-May-27  | 31-May-32  | Ingres 11 includes two significant additions for application integration and monitoring. IngresConnect provides an end-to-end solution for designing, deploying and managing data integration, and the Actian Enterprise Monitoring Appliance (EMA) can use Nagios compatible plug-ins now in Ingres to monitor Ingres environments.

Ingres 11 also contains many new geospatial, performance, ease-of-use and security features. A few of the highlights are: ArcGIS plug-in, query optimizer reuse heuristics, automatic log file rotation, IANA timezones, Y2K38 fix, blob encryption and AES password encryption.

Older version, yet still maintained: Ingres 11.0 (VMS Itanium and HP Itanium)  | 31-Mar-17  | 31-May-23  | 31-May-27  | (None offered, platform not supported by HPE after Dec 2028)  |
Current stable version: Ingres 11.2 (VMS Itanium and HP Itanium) | 6-May-22  | 31-Dec-25  | (None offered, platform not supported by HPE after Dec 2028)  | (None offered, platform not supported by HPE after Dec 2028)  |
Current stable version: Ingres 11.2 (Solaris SPARC, Solaris AMD, and AIX) | 6-May-22  | 31-May-27  | 31-May-32  | 31-May-37  | Ingres 11.2 contains many new management, development and security features. Ingres 11.2 introduces Workload Management Phase 1, JSON Support, Data Masking for sensitive data, Partition Management, Pivot Tables, and Encryption Initialization Vectors, among other changes.

Ingres 11.2 also contains a development release of SQL UDFs with development-only support.

Legend:

Old version

Older version, still maintained

Latest version

Latest preview version

Future release

With the announcement of Ingres 9.1 (Ingres 2006 release 2) on the VMS platform the support dates for VMS will now follow the normal Actian release dates as listed above with the following exceptions; dropping of the Alpha VMS 2.0 release has been announced and Enterprise Support ended on December 31, 2009 with Extended Support offered through December 31, 2013. All support for VAX VMS ended on December 31, 2008.[38]

## Features

[edit]

Major features as available in Actian Ingres 11.2:

* A broad subset of ANSI/ISO SQL-92, as well as extensions;
* Cross-platform support;
* ACID compliance;
* Stored procedures in both SQL and QUEL;
* Triggers;
* Cursors;
* Updatable views;
* Primary and secondary indexes;
* Foreign Keys, as well as constraints and indexes on them;
* Partitioned tables with pruning of partitions in optimizer;
* Query caching;
* Sub-SELECTs (i.e. nested SELECTs);
* Embedded SQL, statements that can be embedded in a host language such as C;
* Unicode support;
* Information schema through iidbdb catalog, the instance's "master database" catalog, which holds information on other databases in the instance, database locations, users, permits, etc. Each database within the instance will also hold data such as table column info in its system catalogs. There are numerous ways to access this data, for example via SQL or via a GUI interface such as Actian Director or Visual DBA (VDBA). Other command line utilities such as vwinfo and infodb will also give database and/or table column data;[39]
* Workload management, a set of SQL Mode options to control runtime behavior;
* Database replication support through Ingres Replicator, which can also be used with Enterprise Access products, enabling to replicate data to other databases: Oracle, MS SQL, IBM DB2, RMS, Oracle Rdb, DATACOM/DB, and IBM IMS;

## Architecture

[edit]

Ingres is a single-node relational database management system, and therefore it is "Share-Everything".

### Storage Architecture

[edit]

Ingres is a disk-oriented DBMS, and by default employ the n-ary storage model (NSM),[40] also known as a row-store.

However, Actian has incorporated columnar storage into its latest version of Ingres (Actian X) to improve its performance on OLAP tasks. Actian X has two storage engines, the traditional Ingres and X100, the same engine from Actian Vector.

Although it is currently branded as the "Actian X Hybrid Database", the term "Hybrid" refers to its capability of performing both OLTP and OLAP tasks by employing a hybrid storage model (i.e. both row and column), not that it has a hybrid storage architecture.[41]

Regarding the storage organization, Ingres supports Heap, Hash, ISAM and B-tree.[42]

### Indexes

[edit]

Ingres chooses ISAM (Index Sequential Access Method) as the index data structure by default, but also offers B+ Tree, Hash Table, and R-Tree as options. On Actian X, there is also two other options available only for X100 tables:[43]

* X100_IX: Default, creates a primary (clustered) index. Only one primary index per table is allowed.
* X100_SI: Creates a secondary index on additional columns in an X100 table. Can also be specified as VWSI. Secondary indexes are not supported for partitioned tables.

### Concurrency Control

[edit]

Ingres uses Multi-version Concurrency Control (MVCC), Deterministic Concurrency Control, and Two-Phase Locking (Deadlock Detection).[44]

### Isolation Levels

[edit]

Ingres supports four isolation levels, from favoring consistency to maximizing concurrency: Serializable, Repeatable Read, Read Committed. and Read Uncommitted, Serializable is the default isolation level and it provides the strongest consistency guarantee.[45]

### Joins

[edit]

Ingres supports joins with hash join, sort-merge join, and nested loop join algorithms. The query optimizer determines which type of join algorithm to use based on its analysis of the query. Nested-loop joins are most often seen on disjoint queries, where correlation variables and table names are arbitrarily used in random order. When there are no restrictions on either table in the join clause, and the rows being joined are spatially continuous, then the query optimizer is likely to choose sort-merge join or hash join.[46]

## Installation

[edit]

Ingres can be installed as a client (Client Installation) or as a server (Server Installation), the client does not have a database associated with it, but it allows you to access the database created in the server installation.

A typical site installs the Ingres client for workers on the computers that will interact with the Ingres server at the core of the site.

Note that the expression "instance" is synonymous with "installation".

An installation can be thought of as a collection of server processes, shared memory, and semaphores for inter-process communication, as well as disk files used for transaction processing and recovery in the event of a host or installation failure.

### Install ID

[edit]

An installation is often named by its installation ID. This identifier consists of two case-sensitive characters, starting with a letter. The default is II. The installation ID is used to calculate which ports the Ingres servers will listen on. For example, "II" indicates that the servers are listening on port 21064 and 7 ports after it.

Any host (machine or virtual machine) can have multiple installations of Ingres, but each installation must have a unique identifier to ensure that clients and components interact with the correct installation.

One installation can use multiple installation IDs. A classic example is when you need to run more than 8 processes on the server. Also, while Ingres database servers (iidbms) and Ingres communication servers (iigcc) conventionally use the same installation ID, there is no requirement to do so.

### Installation paths

[edit]

Some important paths must be assigned at the location where the installation was created. The paths will not change without reinstallation, so you should take care to choose them.

The paths are shown in the following table. Note that the "II_" prefix does not indicate that these paths are for the "II" installation. Each installation, regardless of its ID, will have its own set of these variables.

Name  | Purpose

|

II_SYSTEM  | Setup binary files, utilities, text files used for configuration, etc.
II_DATABASE  | Location of installation master data.
II_CHECKPOINT  | Database backup location.
II_JOURNAL  | Location where database installation transactions are logged. The logs use the recovery system to provide point-of-failure recovery. Can be used for audit purposes.
II_DUMP  | Location where "dump" installation files are stored. They can be generated during "online" database backups and [ what? ] to restore.
II_WORK  | Used to store work files generated by the server when querying the database.

### Databases

[edit]

An Ingres installation (or instance) can support multiple databases, each owned by any user known to the installation. The installation allows multiple databases to be accessed at the same time. The number of databases is a configurable value. Note that this simply limits the number of databases available at any one time and many more databases can be created.

When creating an Ingres server installation, the databases "iidbdb" and "imadb" will be created, owned by the user "$ingres". The iidbdb database, also known as the "Master Catalog database", contains many special tables to manage the installation itself. The imadb (Management Architecture database) database also includes registered objects used to manage the installation.

Of particular note is that databases are not pre-sized. Each database in the installation is allowed to grow in size as much as the free disk space allows.

## Data types

[edit]

Ingres supports:

* Common Data Types
* Integers (1 byte, 2 bytes, 4 bytes and 8 bytes)
* Floating point numbers (4 bytes, 8 bytes)
* Fixed Point Numbers
* Character type (fixed and variable length)
* Binary type (fixed and variable length)
* Date and time (ANSI date, time and timestamp)
* Unicode data types
* nchar
* nvarchar
* Types for Large Objects
* long varchar
* long byte
* Native types
* ingres date
* money
* Geospatial Data Types (version 10S and later)
* point, multipoint
* linestring, multilinestring
* polygon, multipolygon
* geometry, geometry collection

## Postgres

[edit]

Main article: PostgreSQL

The Postgres project was started in the mid 1980s to address limitations of existing database-management implementations of the relational model. Primary among these was their inability to let the user define new domains (or "types") which are combinations of simpler domains (see relational model for an explanation of the term "domain"). The project explored other ideas including the incorporation of write-once media (e.g., optical disks), the use of massive storage (e.g., never delete data), inferencing, and object-oriented data models. The implementation also experimented with new interfaces between the database and application programs (e.g., "portals", which are sometimes referred to as "fat cursors").[47]

The resulting project, named "Postgres", aimed at introducing the minimum number of features needed to add complete types support. These included the ability to define types, but also the ability to fully describe relationships - which up until this time had been widely used but maintained entirely by the user. In Postgres, the database "understood" relationships, and could retrieve information in related tables in a natural way using rules.

In the 1990s, Stonebraker started a new company to commercialize Postgres, under the name Illustra. The company and technology were later purchased by Informix Corporation.

## See also

[edit]

* Free and open-source software portal

* Applications-By-Forms
* Comparison of relational database management systems
* List of relational database management systems

## References

[edit]

1. ^ Actian Corporation (2023-03-14). "Ingres 11.2 Guides". actian.com. Retrieved 2023-04-10.
2. ^ "HCL Tech, PE firm to buy U.S. data management firm Actian". reuters.com. April 12, 2018.
3. ^ "Ingres is a feature rich and robust database (RDBMS)". github.com. November 5, 2019.
4. ^ a b c University of California, Berkeley Database Group. "Archive Software Projects". University INGRES project. Archived from the original on January 26, 2014. Retrieved 12 July 2013.
5. ^ a b J. Woodfill (1979). "INGRES Version 6.2 Reference Manual" (PDF). Archived from the original (PDF) on 2022-07-01. Retrieved 2022-06-02. "The INGRIS reference manual is subdivided into four parts: Quel describes the commands and features which are used inside of INGRES. Unix describes the ..."
6. ^ "RTI announces VAX, Unix Ingres". ComputerWorld. November 7, 1983. p. 63\. "For VAX-lls Running Unix, Relational Technology Offers Updated DBMS BERKELEY, Calif. — Relational Technology, Inc. (RTI) has announced the Ingres VAX ..."
7. ^ Pranskevichus, Elvis (9 May 2019). "We Can Do Better Than SQL". edgedb.com. EdgeDB Inc. house blog. Retrieved 29 November 2021.
8. ^ Chin, Cedric (7 October 2020). "A Short Story About SQL's Biggest Rival". holistics.io. Holistics Software house blog. Retrieved 29 November 2021.
9. ^ a b Joe Hellerstein; Anthony Joseph. "DBMS History". Archived from the original on May 27, 2006.
10. ^ "Ingres (Stonebraker)". britannica.com. "(In Michael Stonebraker) ...tenure at Berkeley, Postgres (Post INGRES) in 1986."
11. ^ a b L.A. Rowe (2012). "History of the Ingres Corporation". IEEE Annals of the History of Computing. 34 (4): 58–70. doi:10.1109/MAHC.2012.51. S2CID 16078334. "University INGRES had three client applications: the terminal monitor, EQUEL C, and GeoQUEL."
12. ^ The Rise of Relational Databases. 1999. doi:10.17226/6323. ISBN 978-0-309-06278-7. "In search of further support, Stonebraker approached the Defense Advanced Research Projects Agency (DARPA)""
13. ^ NSF Funding#s, over time= 0205445, 8715235, 0844480, 0848727, 9116860 "NSF Award Search: Award#9116860 - Design of ..." "DEC has provided the researchers funded under this grant with the equipment ..."
14. ^ The Rise of Relational Databases - Funding a Revolution. 1999. doi:10.17226/6323. ISBN 978-0-309-06278-7.
15. ^ "Capt. Horatio T.P. Webb MIS 4372 Database Alternatives". "Youseffi (at Tandem Computers) built a system that evolved into NonStop SQL. The Tandem database system was a re-implementation of the Ingres technology."
16. ^ Andrew Mendelsohn (2013). "The Oracle Story: 1984 – 2001". IEEE Annals of the History of Computing. 35 (2): 10–23. doi:10.1109/MAHC.2012.56. S2CID 17907189. "This article traces the development of the Oracle RDBMS through the mainframe, ... innovations that allowed Oracle to compete so successfully in the market"
17. ^ Council, National Research; Board, Computer Science Telecommunications; History, Committee on Innovations in Computing Communications: Lessons From (1999). Funding a Revolution: Government Support for Computing Research. ISBN 978-0309062787. "Robert Epstein, the chief programmer at Ingres in the 1970s, went on to co-found Britton-Lee Incorporated and then Sybase."
18. ^ "Eugene Wong". EECS at UC Berkeley. "Eugene Wong ... In 1980 he co-founded (with Michael Stonebraker and Lawrence A. Rowe) ... Relational Technology, Inc., later renamed the INGRES Corporation"
19. ^ "CA Takeover Leads to Egress At Ingres Corp". Newsday. June 30, 1994. p. 59\. Archived from the original on January 21, 2024. Retrieved January 21, 2024 - via Newspapers.com.
20. ^ "Technology". Los Angeles Times. June 30, 1994. Archived from the original on January 21, 2024. Retrieved January 21, 2024.
21. ^ "Ingres Database 9.3 Takes Aim At Competitors With Easy Migration Path". Press release. Ingres Corporation. October 7, 2009. Archived from the original on October 10, 2009. Retrieved December 5, 2013.
22. ^ "ESD - Electronic Software Distribution". esd.ingres.com. Archived from the original on 2009-12-15. Retrieved 2009-11-17.
23. ^ Icebreaker BI [https://web.archive.org/web/20100114002247/http://www.ingres.com/products/icebreaker-bi-appliance.php Archived 2010-01-14 at the Wayback Machine
24. ^ "Ingres breaks ice with JasperSoft". 2007-08-23. Retrieved 2023-05-13.
25. ^ "Ingres launches Icebreaker BI Appliance". 2007-08-22. Retrieved 2023-05-13.
26. ^ Ingres CAFÉ
27. ^ "Actian - Hybrid Data Management & Integration". Actian.
28. ^ "Open Source Boot Camp". Old web site. Archived from the original on April 7, 2008. Retrieved December 5, 2013.
29. ^ "Ingres Database 10 Pulls Out All Stops With Further Migration and Performance Enhancements". Press release. Ingres Corporation. October 12, 2010. Archived from the original on November 7, 2010. Retrieved December 5, 2013.
30. ^ "Ingres Database". Former download web page. Ingres Corporation. Archived from the original on September 23, 2010. Retrieved December 5, 2013.
31. ^ "CA Technologies sells last of Ingres stake". Silicon Valley Business Journal. November 9, 2010. Retrieved December 7, 2013.
32. ^ "Announcement under Regulation 30 (LODR)-Updates on Acquisition". bseindia.com. July 18, 2018.
33. ^ "Actian Hybrid Data Solutions Power the Digital Enterprise". www.businesswire.com. 2017-04-18.
34. ^ "Introducing Actian X – the new Ingres". April 27, 2017. Retrieved April 10, 2023.
35. ^ "Index of /Ingres".
36. ^ "ESD - Electronic Software Distribution".
37. ^ "Actian Communities". communities.actian.com.
38. ^ "Actian X and Ingres". communities.actian.org.
39. ^ "iidbdb Catalogs". Actian. 2023-03-14. Retrieved 16 June 2023.
40. ^ Arulraj, Joy; Pavlo, Andrew; Menon, Prashanth (June 2016). "Bridging the Archipelago between Row-Stores and Column-Stores for Hybrid Workloads" (PDF). db.cs.cmu.edu. Association for Computing Machinery. Retrieved June 16, 2023.
41. ^ "Actian X Hybrid Database" (PDF). Actian.
42. ^ "BaseChoosing Storage Structures for your Ingres Database". communities.actian.com.
43. ^ "Actian X 11.2 Documentation".
44. ^ "Database of Databases — Ingres". 27 June 2022.
45. ^ "Ingres".
46. ^ "Ingres".
47. ^ "sp_cursoroption (Transact-SQL)". 28 February 2023. "Since Transact-SQL positioned UPDATE/DELETE statements operate, by default, on the first row in a fat cursor, sp_cursor SETPOSITION should be used to position the cursor before issuing the positioned UPDATE/DELETE statement."

## External links

[edit]

* The Design and Implementation of INGRES
* Retrospection on a Database System
* Ingres FAQ (from 1997)
* Actian Corp.
* University INGRES, Version 8.9