From Ingres Community Wiki

This page will provide you with information to help you learn about the Ingres DBMS and application development environments. The goal is to help you become proficient in administering, using, and developing applications using Ingres as your DBMS.

Overview

Ingres (pronounced /iŋ-grεs'/) is a commercially supported, open-source relational database management system. Ingres was first created as a research project at the University of California, Berkeley starting in the early 1970s and ending in the early 1980s. Two scientists at Berkeley, Michael Stonebraker and Eugene Wong, became interested in the concept after reading Codd's System R papers from IBM, and decided to start a relational database research project of their own. They had already raised money for researching a geographic database system for Berkeley's economics group, which they called Ingres, for INteractive Graphics REtrieval System. The original code, like that from other projects at Berkeley, was available at minimal cost under a version of the BSD license. Since the mid-1980s, Ingres had spawned a number of commercial database applications, including Sybase, Microsoft SQL Server, NonStop SQL and a number of others. Postgres (Post Ingres), a project which started in the mid-1980s, later evolved into PostgreSQL. In 2005, Ingres Corporation was formed to make Ingres available as an Open Source product.

Architecture

Ingres Architecture Overview

Overview of the Ingres Source Code

• Source Code Architecture
• Ingres Catalogs
• Adding New Functions to the Ingres Relational Database Management System

Common Infrastructure Specifications

Components shared across the Ingres Product Family

• Ingres Compatability Library (CL)
• Abstract Data Facility
• General Communications API (GCA)/General Communications Facility(GCF) API External Interface Specification

RDBMS Specifications

Ingres Database

• A Short Excursion Through The Ingres Back-End
• Query Execution Facility
• Optimizer Facility
• R-Tree: A Geospatial Index for Ingres
• High Availability Option for Windows Clusters

Protocol Specifications

• GCM Specification - Underlying Management Protocol for Ingres Management Facility (IMF)
• Data Access Messaging Protocol Specification - Protocol used between JDBC/.NET DP and Data Access Server (DAS)

Additional Information

• Additional Ingres Specifications available here.
• Still Confused about the Ingres Architecture - ask at Contributor's Forum

Application Development

Application Development Resources

• OpenROAD Development with Ingres
• Java Development with Ingres
• ODBC Development with Ingres
• .Net/C# Development with Ingres
• PHP Development with Ingres
• Python Development with Ingres
• Ruby Development with Ingres
• OpenAPI Development with Ingres
• Using JBoss with Ingres

Contribute to Ingres

Engineering Resources

• Complete an Ingres Contribution Agreement
• Become Familiar with the Ingres DBMS Code by Browsing the code or Getting the Code
• Source code index and cross reference
• Pulled the Code and Ready to Build Ingres
• Build Ingres from the Subversion Repository check out Community Build Page
• Looking for the latest Ingres Source code in a Tar Format
• Look to build Ingres using an IDE check out Developing Ingres With Eclipse CDT
• Need assistance with building Ingres - ask at Contributor's Forum
• Review Ingres Specifications at Ingres Specifications or Specification Category List
• Ready to Make Code Changes
  • Please review the Development Process
  • Adhere to the rules of the road for contributing code to Ingres
  • Become familiar with the Ingres C Coding Standard
  • Become generally familiar with Ingres through Random Ingres Coding Thoughts
  • Download the appropriate templates here
  • Find existing project - Note: All Ingres projects follow our processes
• Need assistance with a contribution - ask at Contributor's Forum
• If you have suggestion or comments regarding the process and potential process improvements, please post them on the Contributors Forum

Articles

Articles dealing with the Ingres Technologies can be found at Articles

• Historical whos who

Examples

Useful Example Code for accessing the Ingres database or Scripts for database administration can be found at Code Samples.

Presentations

Here are links to webinars that have been previously given. You can download the presentations and webinar replays. Note that replaying any of the webinars requires that you first install the WebEx ARF media player. Of course, you need Adobe Acrobat Reader for PDF files and InfoZip is a nice open source utility for handling ZIP files.

• Ingres Open Source Community

• Ingres 2006 Release 3 and Beyond (VIP Webinar). This webinar describes the latest enhancements to the Ingres database and provides an overview of features planned for future releases . You can download the [1] and and replay the Ingres 2006 Release 3 and Beyond

• VIP Webinar Archive

Here are links to webinars that have been previously given. You can download the presentations and webinar replays. Note that replaying any of the webinars requires that you first install the WebEx ARF media player. Of course, you need Adobe Acrobat Reader for PDF files and InfoZip is a nice open source utility for handling ZIP files.

Additional presentations are available at On Demand Webcasts

General

Getting Started with Ingres	How to create an Ingres Database	How to Import your Data
How to manage Ingres	How to Back up you Data	Disk Configuration with Ingres
OpenROAD Meets Open Source OpenROAD OpenSource presentation by David Tondreau given at the 2008 Ingres Global Partner Conference in Prague, Czech Republic.	OpenROAD Community Process OpenROAD Community Process presentation by David Tondreau given at the 2008 Engineering Summit in Punta Cana, Dominican Republic.	Ingres Open Source Community Ingres Open Source Community presentation by Andrew Ross given as a VIP Webcast in March, 2008.
Connecting with Ingres Architecture (VIP Webinar). Would you like to understand how Enterprise Access, Star, Ingres, Ingres Net, OpenROAD, and all the other Ingres product offerings fit together? Do you want to figure out which drivers to use, how to interface the various components, and take advantage of Ingres RDBMS within your solution? PDF AVI	Migrating to IPv6 with Ingres. IPv6 (Internet Protocol version 6) is the new network standard for communications that is gradually replacing the current IPv4 standard. Ingres 2006 r2 implements IPv6 in a way that should enable you to migrate easily to the new standard. This session will cover how IPv6 is implemented in Ingres, issues you might run into, and what configuration options are available. PDF ARF	Integrating Ingres into a Distributed Multi-DataBase Environment (VIP Webinar) Users of Ingres are generally familiar with its distributed client-server architecture. But did you know that it can also interact transparently with other, non-Ingres databases on various platforms including the mainframe? This session will demonstrate how the Ingres family of products (Ingres, Enterprise Access and EDBC) can be used in conjunction with Ingres/Star to tie various databases in an enterprise into a single logical view to the users and applications. The session includes an actual customer case study. ARF
Connectivity Performance Improvements Today, Tomorrow and the Future (Presented at the 2010 UKIUA.) The session will attempt to uncover some hidden gems you may not be aware of regarding Ingres Net (Windows) and ODBC performance improvements available today in Ingres 9.3.x. Ingres 10 introduces additional features that will continue to improve performance. The future will likely bring even more performance improvements as the Connectivity team works closer with the DBMS team to implement features in the DBMS to remove some workarounds in the drivers and address issues arising from POCs. PDF

Ingres DBMS Presentations

How MVCC works and why you should use it UKIUA 2010 Presentation by Karl Schendel	Multi-version concurrency control v2 UKUIA 2010 Presentation by Adrian Hudnott

Ingres Vectorwise

Installing IVW	Set up a DBT-3 benchmark against IVW	Demo of IVW against another RDBMS (El Caro)
Ingres-VectorWise-Demo Demo using analytics against IVW

OpenROAD

OpenROAD Meets Open Source OpenROAD OpenSource presentation by David Tondreau given at the 2008 Ingres Global Partner Conference in Prague, Czech Republic.

OpenROAD Community Process OpenROAD Community Process presentation by David Tondreau given at the 2008 Engineering Summit in Punta Cana, Dominican Republic.

JDBC

Configuring an Application Server with Ingres (VIP Webinar). This webinar describes how to configure a J2EE Application Server with Ingres. DOWNLOAD ZIP	Comparing INGRES-based data-access logic	Spring with JPA Session (VIP Webinar). The Java Persistence API was introduced to simplify Java applications that use data persistence. The aim of Spring, the leading full-stack Java/JEE application framework, is to make enterprise Java easier to use and promote good programming practice. By offering comprehensive support for JPA, Spring provides a compelling programming model for modern enterprise Java. This webinar helps you to explore building enterprise applications with Spring on an Ingres database, learn about dependency injection and amaze your friends and colleagues with load-time weaving. PDF DOWNLOAD
Building Web Applications using the Ingres JBoss Stack A step-by-step guide to quickly and efficiently building Web 2.0 applications using Seam 2.0 , JBoss and INGRES	Développer avec Ingres sous Debian (Developing against Ingres on Debian) What's needed to get started (in French, en Français)

PHP

Getting Started with Ingres and PHP. From downloading the source code to building the Ingres PECL extension, this session covers what is needed to get started with Ingres and PHP. DOWNLOAD Webex Recording

How to Contribute Changes to the PHP Driver The first steps for those wanting to help any open source project can be quite difficult. From reporting bugs, submitting fixes or new functionality, this presentation outlines the requirements for someone looking to provide assistance with the Ingres PECL extension. DOWNLOAD Webex Recording

Développer avec Ingres sous Debian (Developing against Ingres on Debian) What's needed to get started (in French, en Français)

.NET

Ingres with MS .NET and C# (VIP Webinar). Do you develop in the Microsoft .NET Framework with C# programming language? You will learn the capabilities of the new .NET Framework 2.0 data adapter and take a tour of the new C# demonstration program included with Ingres 2006 Release 2. (9.1.1) ARF

Ingres Workshops

Find out how to use ingres, with our series of simple easy-to-follow workshops. Each workshop contains step-by-step guides, with sample screenshots and explanatory text.
Follow the workshops in a series and soon you will be able to download, install, connect, build databases and load your data.
Other workshops explain more advanced concepts (backup and restore), connectivity, OpenROAD.

Installation Workshops

[edit] Install Ingres Server Ingres can be installed on a variety of operating systems. The server can be installed using GUI or character-based tools: Install Ingres Server on Windows Install Ingres on Linux Using RPM Install Ingres Server on Linux/Unix using ingres_express_install.sh (Non-RPM Method) Install Ingres Server on Linux/Unix using install.sh (Non-RPM Method) [edit] Install Ingres VectorWise Install Ingres VectorWise RPM Install Ingres VectorWise Install IVW - Watch movie [edit] Ingres SUSE Studio Appliance Create an Ingres SUSE Studio Appliance

[edit] Install Ingres Client The Ingres server can handle connections from proprietary Ingres clients and also from 3rd party clients: Install Ingres Client on Windows How to Set up SQuirreL SQL Client with Ingres - Example of a Java client. Install Ingres Database Workbench - Eclipse-based database management tool. Install OpenROAD Object-oriented GUI development environment

Ingres VectorWise Workshops

Ingres VectorWise is the next generation of analytic database technology. Ingres VectorWise unlocks the power of modern commodity CPUs with a revolutionary database engine that uses vector-based processing and on-chip memory to provide dramatic performance gains over other databases.
More technical articles are available from our Knowledge Base.
Ingres VectorWise is available from pre-built Ingres VectorWise Amazon EC2 Images.
Ingres VectorWise can also be manually installed. Step-by-step workshops are listed below.

[edit] Install Ingres VectorWise Install Ingres VectorWise RPM Install Ingres VectorWise Install IVW - Watch movie [edit] Create an Ingres VectorWise Database Create an Ingres VectorWise Database [edit] Loading Data Into Ingres VectorWise Create an Ingres VectorWise Table Load Data Into an Ingres VectorWise Table, using copy

[edit] Benchmarking Ingres VectorWise Step 1 Download and Install the DBT3 Benchmark Step 2 Run DBT3 Benchmark Against Ingres VectorWise Benchmarking IVW - Watch movie

Connectivity Workshops

[edit] Connect Client to Ingres Server Using Ingres Net Create an Ingres Client Connection using the Ingres Visual Network Utility Create an Ingres Client Connection in Batch Mode

[edit] Connect Client to Ingres Server using JDBC Connect IDW to Ingres Connect SquirrelSQL to Ingres

Ingres Query Execution Plans

• Import cities CSV file using Ingres Import Assistant
• Generate QEP, Add a Key and Add Statistics
• Generate QEP, Add Secondary Index and Add Statistics
• Generate QEP, Add Two Secondary Indexes and Add Statistics

Users and Groups Workshops

[edit] Users Create an Ingres User, using VisualDBA Create an Ingres User, using accessdb Create an Ingres User, using SQL

[edit] Groups Create a new Group using VDBA Create a New Group using SQL [edit] Users and Groups Assign an Existing User to an Existing Group using SQL Assign Multiple Users to an Existing Group using SQL

Locations Workshops

[edit] Create Data Location Ingres supports multiple Data locations, ensuring that your database is easily scalable. Create New Ingres Data Location, using VDBA Create New Ingres Data Location, using accessdb Create New Ingres Data Location, using SQL

[edit] Using Data Locations A new Ingres Data Location can be added to an existing database and it can also be used as the default for a new database. [edit] Extend an Existing Database Add Data Location to a Database, using VDBA Add Data Location to a Database, using accessdb Add Data Location to a Database, using SQL [edit] Creating New Database With Alternative Location Create Database With Alternative Locations, using VDBA Create Database with Alternative Locations, using createdb [edit] Using Database Locations in Tables Use a Different Data Location for an Existing Table, using VDBA Create an Ingres Table With Multiple Locations, using VDBA

Creation Workshops

[edit] Create an Ingres Database Create an Ingres database Using VisualDBA Create an Ingres Database Using createdb Create and Populate Ingres Demo Database Create a Star Distributed database Using VDBA [edit] Create an Ingres VectorWise Database Create an Ingres VectorWise Database [edit] Create an Ingres Table Create an Ingres Table Using VisualSQL Create an Ingres Table Using VisualDBA Create an Ingres Table With Multiple Locations Using VisualDBA Create an Ingres Table Using SQL

[edit] Import Data Into Ingres How to Import Data - Watch video [edit] GUI Ingres Import Assistant Import Countries CSV File using Ingres Import Assistant Import Cities CSV File using Ingres Import Assistant [edit] SQL copy Command Import Countries CSV File into Ingres, using SQL Copy Part CSV File into Ingres, using SQL

Ingres Database Backup and Restore Workshops

[edit] Backup Ingres Database An Ingres database can be backed up online or offline. A database backup can be static or dynamic. The backup can be performed by GUI tools (eg Visual DBA) and operating system commands. Ingres Static Database Backup and Restore Using VDBA Ingres Database Backup Using ckpdb Ingres Dynamic Database Backup Using VDBA How to Backup and Restore - watch video

[edit] Restore Ingres Database An Ingres database can be recovered using GUI tools (eg Visual DBA, Ingres Journal Analyzer) and operating system commands. The database restoration can be performed against a static backup. The database can be dynamically restored if the backup was also journalled. Restore Ingres Database Using VDBA Restore Ingres Database Using rollforwarddb Restore Database Using Ingres Journal Analyzer

OpenROAD Workshops

[edit] OpenROAD Install Install OpenROAD on Windows Create a development database to be used by Empire Workbench

[edit] OpenROAD Development Workshops Create a Hello World OpenROAD Application Create an OpenROAD Application To Retrieve Data Create an OpenROAD Application With a Search Field

Ingres Database Workbench Workshops

[edit] Installing IDW How To Install IDW Connect IDW to an Ingres Server

[edit] IDW Management Tools Examine a Database Using IDW Use IDW SQL Workbench Manage DB Procs Using IDW