Ingres

What Does Ingres Mean?

Ingres is a cross-platform, open-source database management system developed by Ingres Corporation, which supports enterprise-wide applications ranging from commercial databases to government databases.

Advertisements

Ingres is a fully transactional database management system the strictly follows the atomicity, consistency, isolation and durability (ACID) properties of relational databases. It has a scalable architecture with extensive platform and transaction support. It also supports audit capabilities and automated backup.

Techopedia Explains Ingres

Ingres’ history can be traced back to 1970s, when it was created as a research product at the University of California. The main benefits of Ingres are that it is scalable in terms of data growth, includes tight security features (including Sarbanes-Oxley) and the data involved can withstand failures.

The Ingres drivers create new layers or tables within an existing database instance. Each database is created on a data location known to the installation. An Ingres installation is a group of server processes and shared memory that works to enhance interprocess communication. Ingres is usually installed as a client or server installation. Clients by themselves have no databases, but can access databases on server installations. All installations are performed by privileged users and each installation supports many databases. Databases with multiple locations allow parallel backups and reduce backup time. Databases can be made private or public during creation.

Ingres backups can be performed online, where user activity is permitted on the database, or offline, where no user activity is permitted on the database.

Advertisements

Related Terms

Margaret Rouse
Technology Expert

Margaret is an award-winning technical writer and teacher known for her ability to explain complex technical subjects to a non-technical business audience. Over the past twenty years, her IT definitions have been published by Que in an encyclopedia of technology terms and cited in articles by the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine, and Discovery Magazine. She joined Techopedia in 2011. Margaret's idea of a fun day is helping IT and business professionals learn to speak each other’s highly specialized languages.