William's Ingres Database Reference

Welcome to William's Ingres Database Reference

Last Updated: October 16, 2009 (into its 14th year :)

Current Releases: Advantage Ingres 2.6
and Ingres 2006 Business OpenSource! (formerly r3)

Computer Associates (CA) have divested Ingres to Ingres Corporation! Read the Press Release & the Support Release.

Ingres Corporation have released the Ingres 2006 version of the Ingres Database (RDBMS) as Business OpenSource!
Read the Press Release & download files here.

Ingres Index

Ingres Articles
Ingres FAQs
Ingres Links
Ingres Migration Guides
Ingres Newsgroup
Ingres Newsletters
Ingres Question & Answer
Ingres Technotes
Ingres Users Groups
My Ingres Environment
Recent Updates
Search the Ingres Q & A
Subscribe to Info-Ingres newsgroup
Third Party Vendors/Products

Ingres Links

Ingres Corporation - new Home of Ingres
Ingres Corporation - FAQs
Ingres Education
Ingres Electronic Software Downloads
Ingres 2006
Ingres 2006 Documentation
Ingres 2006 Downloads
Ingres 2006 White Papers
Ingres Service Desk replaces SupportConnect

CA - Computer Associates Major client of Ingres Corporation

CA Ingres, Operations Management
Database Patches for Ingres r3 ftp site
Database Patches for Ingres prior to r3 ftp site
CA Ingres Newsletter E-News Archive
CA Open Forums
CA Posters
CA Products
CA SupportConnect
CA World
Comprehensive Consulting Solutions (whitepapers)
DBD driver for Ingres in Perl
Ingperl - Perl access
Ingres Alchemy
Ingres Database Wikipedia style entry
Ingres FAQs
Ingres Training Materials
Linux - Ingres II HowTo
OpenRoad SIG (NAIUA)
OpenRoad Users Mailing List

Third Party Vendors/Products

CACI Upfront
Comprehensive Consulting Solutions with Ingres training (r3) & remote DBA support
Database Management Technology with Ingres training
DB Analyzer
High Volume Replicator
IRule by BlueOffice
KB Computer Associates
Luminary Solutions
Mentora
Openlink Software
Prophecy
Rational Commerce with Ingres training
Sandyx Systems
Software Innovations - Patrol for CA-Ingres
The SQL Guide to Ingres book by Rick van der Lars

To William's HotList

To William's Home Page

To Google News search for previous Ingres news articles

Have an Ingres Question ?

   Please try to:
   a) Search or browse this site first.
   b) Search at CA Technical Support.
   c) Search Google News:    d) Post to comp.databases.ingres newsgroup or the Info-Ingres mail list.
   e) Send email to me.

hits on Ingres Reference since September 1995.

My humble thanks to all the supporters of Ingres over the years and a big thank you to CA and Ingres Corporation for their terrific support!

My Ingres Database Reference page has been active for over a decade and still going strong :->

Alternatively, you can peruse my Ingres Question & Answer page.

Ingres User Groups

Australian & New Zealand Ingres Users
Netherlands Ingres Users
North American Ingres Users
United Kingdom Ingres Users

To understand some of the international websites, try an Online Translator

Ingres Newsgroup

Comp.databases.ingres

Ingres Environment at the University of Melbourne

At Melbourne University we are using OpenIngres 1.2 for our three main administration systems: Student Administration, Payroll and Finance. There have been a large number of patches for our Dec Alpha version of Ingres, so keeping up-to-date is important! We had previously been using Ingres 6.4/05-06 for a number of years. An upgrade to Ingres II has been completed in 2001 and then a subsequent upgrade to Ingres 2.6 in 2005.

Our three development teams program in 4GL and Embedded SQLC. Personally, I have been using Ingres since 1991 as both a developer and a DBA. I also do Ingres DBA consulting for other University affiliates such as the Australian Music Examination Board (Vic).

User access to our Ingres systems consist of SSH terminal connections using Teraterm, WinQVT (both PC clients) or MacSSH, NiftyTelnet (Mac equivalents). Ingres keymappings can be tricky but not as difficult as configuring sendmail!

In recent times, we have opened up access to our Ingres databases via ODBC for the Unicard Student Cards system and via JDBC for the Oracle Portal using Toplink.

Some of our clients use BI/Query from Hummingbird for generating adhoc SQL queries and reports with Ingres (BI/Query used to be called GQL when it was owned by Andyne). For the security conscious (ie not ODBC), I have successfully run BI/Query and GQL over an SSH tunnel connection.

We also use other Ingres-access tools like Gentium by Planning Sciences for data warehousing.

Update: Melbourne University has replaced the administration systems for Finance, HR and Research) with Oracle Apps at a project cost of 42+ million AUS. In comparison, the current Ingres systems they replace were developed in-house at an estimated development cost of just 4 million (AUS) during a 10-15 year lifetime.

Update #2: A new .NET/Oracle implementation of the Student System (StudentOne) from TechnologyOne has been evaluated and is due to be implemented at the University of Melbourne by May 2008 with a project budget of 23.1 million dollars! The recurrent costs are 4.477 million dollars and a half-yearly maintenance fee of $553,000 dollars! Source: MU Council Minutes, November 2006, Section 14.2

Update #3: The existing Merlin system is in its fourteenth year of reliable service and has been upgraded to new Sun V890 hardware in conjunction with Solaris 10 zones. Most of our current processes are running two to three times quicker than previously, eg Admin_Stats processing has gone from two hours & 30 minutes to just 32 minutes! The database setup is Ingres 2.6/0305 with JDBC/ODBC enabled. We have worked through a number of bugs and are now running patch 12843 on our DR/test/production environments.

Update #4: The Technology One implementation for a new Student System has been delayed by three months until at least September 2008 due to prototypes lacking required functionality and not being delivered according to schedule.

Update #5: The Technology One implementation has been delayed again until at least 2009! If only Merlin had been enabled with some front-end GUI web forms, this might have saved the Uni 20-odd million dollars in the short term at least :)

Recent Updates to Ingres Database Reference

16 Oct 09: Added The SQL Guide to Ingres book link (via Amazon)
6 Apr 09: Added Ingres Electronic Software Distribution link
11 Mar 09: Updated Ingres Database -- wikipedia
10 Mar 09: Added Ingres Alchemy
3 Feb 09: Update Ingres ServiceDesk link
...
15 Sep 95: Ingres Reference Created!