Ingres Community Forums Login Register Ingres.com  

Ingres Community Wiki

Navigation
Learn About
Developing With
Ingres Talk
Information
Toolbox

Ingres DBMS Projects

From Ingres Community Wiki

Jump to: navigation, search
Image:ORBarProjects.png

                                                                                                                                                                                                     

                                                                                                                                                                                                     

                                                                                                                                                                                                     

                                                                                                                                                                                                     

Ingres Database
|
the enterprise open source relational database
Projects



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.



Image:announce_discuss.png=Discussion Image:announce_planning.png=Planning Image:announce_design.png=Design Image:announce_develop.png=Coding Image:announce_beta.png=Beta Image:announce_release.png=Stable Image:announce_terminate.png=Terminated

Contents

Featured project

Ingres Geospatial 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.

Learn more...

Ingres Projects

Completed Projects

Project Team Lead Availability
Image:announce_release.png Table Procedure Enhancements. Doug Inkster/ Fei Ge Currently Available in Ingres 9.3 and Subversion main
Image:announce_release.png Improved support for auto-increment/Identity Columns Doug Inkster Currently Available in Ingres 9.3 and Subversion main
Image:announce_release.png bigint sequences Doug Inkster Currently Available in Ingres 9.3 and Subversion main
Image:announce_release.png non-sequential sequences Doug Inkster Currently Available in Ingres 9.3 and Subversion main
Image:announce_release.png Allow LIKE predicate for Long Objects Ian Kirkham Currently Available in Ingres 9.3 and Subversion main
Image:announce_release.png Line numbering for error messages Jon Jensen Currently Available in Ingres 9.3 and Subversion main

Projects In Progress

Project Team Lead Availability
Image:announce_develop.png Data at Rest Encryption Mike Touloumtzis Not Complete
Image:announce_design.png Long Identifiers Alison Stillway Not Complete
Image:announce_design.png Scalar Subqueries Ian Kirkham First phase available in http://code.ingres.com/ingres/main/src/
Image:announce_design.png Improved Tools Roger Whitcomb Not Complete
Image:announce_design.png RCP Offline Redo Undo Error Handling Alison Stilway Currently Available in http://code.ingres.com/ingres/main/src/
Image:announce_design.png MVCC Jon Jensen Not Complete
Image:announce_develop.png SQL BOOLEAN type Joe Abbate Implementation
Image:announce_design.png Rename tables and columns Shubhagam Gupta Planning
Image:announce_design.png Batch Statement Execution Performance Steve Ball Not Complete
Image:announce_design.png GREATEST and LEAST Scalar Functions Ian Kirkham Currently Available in http://code.ingres.com/ingres/main/src/
Image:announce_design.png Bulk Loading Projects Karl Schendel Not Complete
Image:announce_design.png Large IN list performance Ian Kirkham Initial implementation complete

Projects Awaiting Resources

Project Team Lead Availability
Image:announce_planning.png Efficient Storage of Varchars and LOBs Steve Ball Not Complete
Image:announce_design.png Ingres 64-bit Port on Windows Viktoriya Driker Not Complete
Image:announce_planning.png Configurable Installer Durwin Wright Not Started
Image:announce_design.png Potential Catalog Updates Assorted Not Complete
Image:announce_design.png Nulls in unique columns Not Started

Projects Under Discussion

Project Team Lead Availability
Image:announce_discuss.png XML Enhancements Teresa King
Image:announce_discuss.png INTERSECT, EXCEPT (set operators) Doug Inkster
Image:announce_discuss.png Silent install Christine Normile

Projects with Community Involvement

Project Leader(s)
Image:announce_design.png 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
Image:announce_design.png PSEUDOTEMPORARY tables

Tables which are not sync'ed and permit failure during crash recovery without any db inconsistency.

Karl Schendel
Image:announce_design.png Partitioned global temporary tables

Useful for managing large GTT's, or for inducing partition-compatible joins or aggs with other large tables.

Karl Schendel
Image:announce_design.png 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
Image:announce_beta.png 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
Image:announce_design.png 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
Image:announce_design.png page compression

Operates at the DI level, largely invisible to higher layers except for syntax and page-compression catalog bits.

Karl Schendel
Image:announce_design.png 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
Image:announce_develop.png 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
Image:announce_design.png 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
Image:announce_design.png 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
Image:announce_release.png 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
Image:announce_develop.png 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
Image:announce_develop.png RD Tasks
Task List from Development Summit, Dominican Republic 2008
Christine Normile
Image:announce_develop.png 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
Image:announce_design.png Summer of Code - see a list of Google summer of code projects.
Andrew Ross
Image:announce_design.png Media Wiki - A project for Media Wiki running on Ingres
Image:announce_develop.png Project D - A fully compliant D language for Ingres (just like SQL and QUEL)
Doug Inkster
Image:announce_develop.png 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
Image:announce_develop.png OSX Installer
Build a Mac OS/X Native Ingres Installer
Daryl Monge
Personal tools
© 2009 Ingres Corporation. All Rights Reserved