William's Ingres Database Reference

Welcome to William's Ingres Database Reference

Last Updated: December 14, 2007 (into its 12th 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 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 FAQs
Ingres Training Materials
Ingres - Wikipedia
Linux - Installing Ingres II
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

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 more than 10 years and is 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 service and has been upgraded to new Sun V890 hardware in conjunction with Solaris 10 zones. Most of our existing 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 patch 11090 with JDBC/ODBC connectivity. We have worked through a number of bugs and are now running patch 12527 on Production.

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.

Recent Updates to Ingres Database Reference

14 Dec 07: Update #4 - Technology One implementation delayed by 3 months
13 Dec 07: Update #3 - new Sun hardware for Merlin at Melbourne Uni
6 Jan 07: Added Ingres - Wikipedia entry
18 Dec 06: Ingres Education link
18 Dec 06: Melbourne Uni update #3 - Student System evaluation
22 Jul 06: Updated ftp link for Ingres r3 patches
21 Jul 06: Updated ftp link for Ingres pre-r3 patches
14 Mar 06: Updated Ingres ODBC 2.8 driver link for Windows
21 Feb 06: Ingres 2006 Downloads, Documentation, White Paper Links
10 Feb 06: Added OpenROAD users mailing link
7 Feb 06: Ingres Service Desk now replaces SupportConnect
9 Nov 05: Ingres Support Release
9 Nov 05: CA divests Ingres to Ingres Corporation!!
28 Oct 05: Update Comprehensive Solutions - thanks Chip!
...
15 Sep 95: Ingres Reference Created!