Ingres 2006 New Features
Roy Hann, first presented at UK IUA Spring Conference, London, 2007

In this presentation we review some of the new features introduced in Ingres 2006 and Ingres 2006 Release 2.  Highlights of these releases include: extensive use of parallelism in query execution; rule-based table partitioning; sequences; new data types; connectivity improvements and new drivers; more complex queries; "before" rules; secondary indices for session global temporary tables; derived tables in the FROM clause, and many more.

The presentation is in the form of 48 Microsoft PowerPoint 2000 slides.  The download also includes a PDF file containing a diagram of the syntax for partitioning tables.  The files are zipped to 221kb.

Topics

>> About GPL and what it does and doesn't permit
>> Rule-based partitioning as a magic bullet
>> Parallel query execution and how to turn it on
>> Calling row-producing procedures
>> tinyint, bigint and the ANSI/ISO date/time types
>> Getting derived tables to work and where you can use them