Login
Register
Ingres.comNavigation
Learn About
Developing With
Ingres Talk
Information
Toolbox
Views
Ingres DBMS Projects
From Ingres Community Wiki
This page provides a complete index (WIP :)) of all RDBMS related open source projects sponsored by Ingres Corp. If you are interested in joining any of these projects, please contact the project leaders. If you would like to start a new project, please contact Zelaine Fong.
If a project does not have a leader identified and you would like to lead the project, please contact Zelaine Fong.
All Ingres projects follow our Development Process. Please review the process, download the appropriate templates and get started. If you have suggestion or comments regarding the process and potential process improvements, please post them on the Contributors Forum. When submitting to the Ingres code base, please also adhere to the Rules of the road for contributing code to Ingres.
=Discussion 
=Planning 
=Design 
=Coding 
=Beta 
=Stable 
=Terminated
Contents |
Featured project
This project is focused on storing geometry and geography related data in Ingres databases. This includes supporting industry standard data types and functions. The project also includes support for desktop GIS and map rendoring software.
Ingres Projects
Completed Projects
| Project | Team Lead | Availability | |
|
| Table Procedure Enhancements. | Doug Inkster/ Fei Ge | Currently Available in Ingres 9.3 and Subversion main |
|
| Improved support for auto-increment/Identity Columns | Doug Inkster | Currently Available in Ingres 9.3 and Subversion main |
|
| bigint sequences | Doug Inkster | Currently Available in Ingres 9.3 and Subversion main |
|
| non-sequential sequences | Doug Inkster | Currently Available in Ingres 9.3 and Subversion main |
|
| Allow LIKE predicate for Long Objects | Ian Kirkham | Currently Available in Ingres 9.3 and Subversion main |
|
| Line numbering for error messages | Jon Jensen | Currently Available in Ingres 9.3 and Subversion main |
Projects In Progress
| Project | Team Lead | Availability | |
|
| Data at Rest Encryption | Mike Touloumtzis | Not Complete |
|
| Long Identifiers | Alison Stillway | Not Complete |
|
| Scalar Subqueries | Ian Kirkham | First phase available in http://code.ingres.com/ingres/main/src/ |
|
| Improved Tools | Roger Whitcomb | Not Complete |
|
| RCP Offline Redo Undo Error Handling | Alison Stilway | Currently Available in http://code.ingres.com/ingres/main/src/ |
|
| MVCC | Jon Jensen | Not Complete |
|
| SQL BOOLEAN type | Joe Abbate | Implementation |
|
| Rename tables and columns | Shubhagam Gupta | Planning |
|
| Batch Statement Execution Performance | Steve Ball | Not Complete |
|
| GREATEST and LEAST Scalar Functions | Ian Kirkham | Currently Available in http://code.ingres.com/ingres/main/src/ |
|
| Bulk Loading Projects | Karl Schendel | Not Complete |
|
| Large IN list performance | Ian Kirkham | Initial implementation complete |
Projects Awaiting Resources
| Project | Team Lead | Availability | |
|
| Efficient Storage of Varchars and LOBs | Steve Ball | Not Complete |
|
| Ingres 64-bit Port on Windows | Viktoriya Driker | Not Complete |
|
| Configurable Installer | Durwin Wright | Not Started |
|
| Potential Catalog Updates | Assorted | Not Complete |
|
| Nulls in unique columns | Not Started |
Projects Under Discussion
| Project | Team Lead | Availability | |
|
| XML Enhancements | Teresa King | |
|
| INTERSECT, EXCEPT (set operators) | Doug Inkster | |
|
| Silent install | Christine Normile |
Projects with Community Involvement
| Project | Leader(s) | |
|
| Allow table level inconsistency during crash recovery
rather than always forcing immediate full database inconsistency without completing recovery. Tables get marked logically and/or physically inconsistent. At end, DB is NOT marked inconsistent if all bad tables had save-until dates (see PSEUDOTEMPORARY). | Karl Schendel |
|
| PSEUDOTEMPORARY tables
Tables which are not sync'ed and permit failure during crash recovery without any db inconsistency. | Karl Schendel |
|
| Partitioned global temporary tables
Useful for managing large GTT's, or for inducing partition-compatible joins or aggs with other large tables. | Karl Schendel |
|
| MODIFY to TABLE_REPAIR
Extract that part of "modify to patch_table" that detects the FHDR so that it can be run separately. Intent is for relfhdr fixup after replacing a table file with (e.g.) a backup. | Karl Schendel |
|
| Build system improvements for better parameterization
including site specific (VERS) parameters / options capability. The key item here is to revise the VERS format and arrange for jam to read VERS before reading the platform Jamdefs. This allows VERS to control jam as well as controlling mkxxx shellscripts; this is essential to (e.g.) being able to turn on/off hybrids, etc. | Karl Schendel |
|
| Greater than 1k column capability selectable at build time
The main thing here is to change createdb to create catalog bitmaps as BYTE(n) instead of a series of named integer columns, makes it much much easier to vary the column max. | Karl Schendel |
|
| page compression
Operates at the DI level, largely invisible to higher layers except for syntax and page-compression catalog bits. | Karl Schendel |
|
| CHANGE_TRACKING tables
Any update to a change-tracked table causes its iirelation.relqid2 to be incremented at commit time. (Partition specific.) An external process can track and compare relqid2's to identify specific tables and/or partitions that changed. | Karl Schendel |
|
| Ingres Janitors Project A group of projects to extend and enhance Ingres. To find out more, please view our web site, check out our FEQ, visit us in the #ingres IRC channel, and talk with us to let us know the kinds of things you want to see in a best in class Open Source RDBMS. | Roy Hann |
|
| Debug Framework Debugging is often a time intensive process requiring lots of coordination between the end user, DBA's, system administrators and support personnel. A Debugging Framework could ease some of the issues involved by providing a standard collection of debug information that can be easily attached to support tickets. This project was supported by Google Summer of Code. A framework is being developed to execute a set of chosen executables and libraries in order to gather as much useful information as possible for debugging errors, while remaining as open and extensible as possible. | Anthony Stanisci |
|
| GeoSpatial This project involves updating the Ingres DBMS to support the Open Geospatial Consortium (OGC) Simple Feature Specification (SFS) for SQL. This involves new data types implementing shapes. It also involves functions for performing analysis and manipulating spatial data within the DBMS. This project involves code and participation from the Open Source Geospatial (OSGeo) community. To find out more, please view our web site, join our mailing list, visit us in the #ingres IRC channel, and talk with us to try out these new capabilities. | Andrew Ross |
|
| FOSSLC - The Free and Open Source Learning Centre (FOSSLC) is a non-profit organization driven by industry, academia, and community. It provides conferences, webcasts, online videos, and workshops teaching skills with open source software. FOSSLC is a neutral and friendly place to learn about open source development, the business of open source, and meet people from the open source community. Thank you Ingres for supporting FOSSLC! Read more about FOSSLC
. | FOSSLC Events Team |
|
| Performance Enhancements Our business partner, DATAllegro, is leading this project to improve or provide Hash join, sort performance, partitioned aggregates in Ingres 2006. | Karl Schendel |
|
| RD Tasks Task List from Development Summit, Dominican Republic 2008 | Christine Normile |
|
| Ingres CAFÉ In conjunction with Carleton University in Ottawa, Canada, Ingres is developing a Consolidated Application Foundation for Eclipse (Ingres CAFÉ). Ingres CAFÉ provides a complete development and deployment environment for Eclipse with a fully integrated enterprise strength Ingres RDBMS. This environment let's developers start coding with a single-click install and developers can easily move their applications into production. This project was supported by Talent First Network and Google Summer of Code. This project is currently dormant. | Samrat Dhillon Andrew Ross |
|
| Summer of Code - see a list of Google summer of code projects. | Andrew Ross |
|
| Media Wiki - A project for Media Wiki running on Ingres | |
|
| Project D - A fully compliant D language for Ingres (just like SQL and QUEL) | Doug Inkster |
|
| Check Digit Functions Functions to both generate and validate check digits on a string using a specified encoding scheme(Luhn, Verhoeff, ISBN etc) | Martin Bowes |
|
| OSX Installer Build a Mac OS/X Native Ingres Installer | Daryl Monge |
