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. 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.
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.
Read More »