Ingres – enterprise relational database management system

Last Updated on February 28, 2024

Ingres is a commercially supported, open-source SQL relational database management system intended to support large commercial and government applications.

It is a database that combines the flexibility of open source with the business class availability and reliability of commercial DBMS platforms.

Originally funded by U.S. defense agency and the National Science Foundation, Ingres has been leading the industry with innovative technology for decades and helping manage the most demanding enterprise applications of Fortune 500 companies. Core Ingres technology forms the foundation, not only for Ingres Database, but numerous other industry-leading RDBMS systems as well.

Ingres reduces the complexity, time, database administrator (DBA) skills and cost associated with database management by helping to eliminate, simplify and automate many tasks traditionally associated with maintaining an enterprise-class database.

Features include:

• Fully transactional DBMS.
• Provides easy migration from MySQL and proprietary databases such as Oracle, SQL Server and Sybase.
• ACID.
• Referential integrity.
• Transactions.
• Unicode.
• SQL and QUEL.
• Unlimited database & table size.
• Temporary tables.
• Indexes:
  • R-/R+ tree.
  • Hash.
  • Expression.
  • Bitmap.
• Database capabilities:
  • Union.
  • Inner joins.
  • Outer joins.
  • Inner selects.
  • Merge joins.
  • Blobs and Clobs.
• Objects:
  • Data Domain.
  • Cursor.
  • Trigger.
  • Function.
  • Procedure.
  • External routine.
• Partition methods:
  • Range.
  • Hash.
  • Composite (Range & Hash).
  • List.
• Data types:
  • Conventional data types such as integers, floats, characters and binary.
  • Unicode with types nchar and nvarchar.
  • Large objects with long varchar and long byte.
  • Funky types such as decimal, ansi data, ingres date, and money.
• 1024 columns.
• 256KB maximum row size.

Website: www.actian.com
Support:
Developer: Actian Corporation
License: GNU GPL

Return to Relational Databases Home Page

Explore Linux
	Best Free and Open Source Software - A huge collection of recommended free and open source software covering every major category.
	In-depth Linux Software Reviews - Detailed assessments of Linux software covering features, usability and overall quality.
	The Big List of Active Linux Distros - An extensive collection of actively developed Linux distributions.
	Open Source Alternatives - Alternatives to software and services from Google, Microsoft, Apple, Adobe, IBM, Autodesk, Oracle and others.
	Essential Linux System Tools - Indispensable utilities for monitoring, maintaining and managing Linux systems.
	Linux Productivity Tools - Useful utilities for improving productivity and streamlining everyday tasks.
	Alternatives to Popular CLI Tools - Modern alternatives to familiar command-line utilities supplied with Linux systems.
	Awesome Free Linux Game Tools - Tools, utilities and companion software that improve gaming on Linux.
	Machine Learning on Linux - Machine learning and deep learning software, self-hosted applications and practical tools.
	Saving Money with Linux - Practical ways to reduce electricity consumption and lower computing costs with Linux.
	Linux Candy - Fun, entertaining and sometimes delightfully quirky software from the lighter side of Linux.