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.
To see the planned Roadmap for the next Ingres release see Ingres Roadmap.
=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 DBMS Projects
Completed Projects
Projects completed in the 9.3 release are described at http://community.ingres.com/wiki/Ingres_Roadmap/9.3
Projects completed in the 9.3.1 release are described at http://community.ingres.com/wiki/Ingres_Roadmap/9.3.1
Projects In Progress
For projects currently planned for Ingres 10, see http://community.ingres.com/wiki/Ingres_Roadmap/10#10.0_Projects_In_Process.
Projects Under Discussion
See http://community.ingres.com/wiki/Ingres_Roadmap/10.x#10.x_Projects_Under_Consideration
Projects with Community Involvement
| Project | Leader(s) | Availability | |
|
| copydb nologging The ability to have copydb/unloaddb generate a "set nologging" statement in the copy.in script. | Paul Mason | Currently available in community edition builds of Ingres 10 |
|
| 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 | Currently available in community edition builds of Ingres 10 |
|
| 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 | Currently available in community edition builds of Ingres 10 |
|
| 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 | Currently available in community edition builds of Ingres 10 |
|
| Soundex_dm An implementation of the Daitch-Mokotoff Soundex algorithm | Martin Bowes | Available, starting in community edition build 125 of Ingres 10 |
|
| Must Log DB Menu in CBF DBMS Configuration Extends cbf so you can specify that logging cannot be disabled on a database | Alex Hanshaw | Currently available in community edition builds of Ingres 10 |
|
| Enable History Recall Feature By Default Enables the history recall feature in terminal monitor, by default, on UNIX platforms | Jay Hankinson | Available, starting in community edition build 123 of Ingres 10 |
|
| 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 | |
|
| 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 | |
|
| 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 | |
|
| OSX Installer Build a Mac OS/X Native Ingres Installer | Daryl Monge | |
|
| letter abbreviations for integers The Ability to abbreviate integer values with "standard" letters such as "K" or "M"; for example, this would allow the representation of "2048" using "2K" in page size stipulation and other integer constants. | Martin Bowes | |
|
| Session wide SQL variables Provide the ability to declare and use 'session' variables in SQL sessions so that for instance: results could be passed from one statement and used as input to another. This would lever the existing syntax for host variables in the DBMS where presently interactive or script use has no meaning for them. | Ian Kirkham | |
|
| Array datatypes in DBprocs Support simple arrays of primitive types in database procedures. | Ian Kirkham | |
|
| Associative Arrays in DBprocs Support hash access arrays of primitive types in database procedures that can be indexed via arbitrary types. | Ian Kirkham |
