Ingres
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
Return
to Relational Databases Home Page
Last Updated Sunday, January 31 2010 @ 10:21 AM EST
| 
