Ingres – enterprise relational database management system

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.

Support: Documentation
Developer: Actian Corporation
License: GNU GPL

Return to Relational Databases Home Page

Read our complete collection of recommended free and open source software. The collection covers all categories of software.
Share this article

Share your Thoughts

This site uses Akismet to reduce spam. Learn how your comment data is processed.