Ingres 2006 (Release 1) - GIUA

cabbagepatchtapeInternet and Web Development

Feb 5, 2013 (4 years and 7 months ago)

130 views

Status & Plans


New Features

April 2008

20. German Ingres User
Association

Kassel 2008

For information contact

Product Marketing at products@ingres.com




This presentation contains forward
-
looking statements that are based on
management’s expectations, estimates, projections and assumptions.
Forward
-
looking statements are made pursuant to the safe harbor
provisions of the Private Securities Litigation Reform Act of 1995, as
amended. These statements are not guarantees of future performance
or functionality and involve certain risks and uncertainties, which are
difficult to predict. Therefore, actual future functionality, features, results
and trends may differ materially from what is forecast in forward
-
looking
statements due to a variety of factors.

German Ingres User Association


© Ingres 2008

Slide
2

2007 Year in Review

Focus on ease of use, interoperability

German Ingres User Association


© Ingres 2008

Slide
3

2007
-

A Year In Review


Icebreaker BI
Appliance


Salesforce.com
Appliance


Eclipse DTP Bundle
& Live CD


Business Objects
Crystal Decisions
Professional

Appliances and

Bundles

Focused on



SIMPLICITY & USABILITY


Hibernate/JBOSS


JasperSoft


Pentaho


Business Objects


Talend Open Studio


Quest Toad


Eclipse, Laszlo, Rails

Certifications

Focused On


NEW

OPPORTUNITIES

German Ingres User Association


© Ingres 2008

Slide
4

Building on the Appliance Platform

German Ingres User Association


© Ingres 2008

Slide
5

Linux

Ingres 2006

Apache/Tomcat

Java

Icebreaker Appliance

Your Application

Linux

Ingres 2006

Apache/Tomcat

Java

Maintenance

Your Application


Ingres DBMS with Linux


Single stream


Lower cost


Setup


Deployment


Maintenance


Validated updates


Standard configuration

= consistent service


Your Application too

Ingres Icebreaker

BI Appliance

JasperETL


Full Featured BI Suite


Reporting, Analytics, Data
Integration, Database, Operating
System


40% Faster


Simpler Patching


75% Lower implementation costs


One Vendor for Support


Target Mid
-
Market BI


Salesforce.com Solution


SaaS Reporting/Integration Hub

Linux

Java

Apache/Tomcat

Ingres 2006


JasperAnalysis

JasperServer

Jasper Studio


Ingres

Icebreaker




JasperSoft BI

Suite

German Ingres User Association



© Ingres 2008

Slide
6

Business Intelligence Appliance

Ingres 2006 r1

Ingres 2006 (Release 1)

Ingres 2006 (Release 1) DBA Features


Parallel Query


Key Range Table Partitions


Availability


Database location delete


Kill the query not the session


Report
-
Writer Numeric overflow


Instance “Default Lock Level”


Column level collation

German Ingres User Association


© Ingres 2008

Slide
8

Ingres 2006 (Release 1) Developer Features


Automatic Sequence Number Generation


No Wait for Lock Requests


New data
-
types


Complex Query Optimization




German Ingres User Association


© Ingres 2008

Slide
9

Ingres 2006 (Release 1) Enhancements


Raised Limits


Log Full Enhancements


Internationalization


Unicode


( SBCS || DBCS ) && Unicode


German Ingres User Association


© Ingres 2008

Slide
10

Ingres 2006 (Release 1) Connectivity


Data Access Server (DAS)


.NET Data Provider


JDBC Driver


.NET & Co.


Native .Net Data Provider


Visual Studio .NET Integration


ODBC Call
-
level Interface (CLI)


Java


JDBC 3.0 API

Pure Java Driver


JBOSS


WebSphere


WebLogic

German Ingres User Association


© Ingres 2008

Slide
11

Ingres 2006 (Release 1) VDBA Enhancements


Schema Differences


Configuration Differences


Export Assistant


XML


German Ingres User Association


© Ingres 2008

Slide
12

Ingres 2006 r1

Ingres 2006 Release 2

Ingres 2006 Release 2 First Impressions…


Simplified Installers Linux, Windows

German Ingres User Association


© Ingres 2008

Slide
14

Ingres 2006 Release 2 First Impressions


Demonstration Database


Demonstration Application: “Ingres Frequent Flyer” / “Airline”

C#

German Ingres User Association


© Ingres 2008

Slide
15

Ingres 2006 Release 2 DBMS Features


Derived Tables


SELECT in FROM clause


ANSI DATE and TIME types


BEFORE trigger


Surrogate Keys


Auto incrementing columns


Prepared statement information


DESCRIBE INPUT


Temporary table enhancements

German Ingres User Association


© Ingres 2008

Slide
16

Ingres 2006 Release 2 Connectivity


IPv6 protocol support


JDBC


Full XA compliance


Parameter meta
-
data support


J2SE 5.0 support (excluding RowSets)


.NET


VS 2005 Server Explorer Integration


ODBC


ODBC 3.x


PHP 5


German Ingres User Association


© Ingres 2008

Slide
17

Ingres 2006 Release 2 Eclipse DTP

German Ingres User Association


© Ingres 2008

Slide
18

2007


A Year in Review

Simplified Installation

Demonstration Applications

Improved DBA Tools

Third Party Integration

Usability


German Ingres User Association


© Ingres 2008

Slide
19

Ingres Product Roadmap


Business Focus


Marketing Focus


Engineering Focus


Partners & Community


http://community.ingres.com


Major Technology Investments


Multi
-
version Concurrency Control


Open Spatial


OpenROAD Open Source


Column
-
based Storage Under Consideration

German Ingres User Association


© Ingres 2008

Slide
20

Community Contributions…

Hash join, sort performance, partitioned
aggregates

Virtualized Ingres Development Environment

Open Source collaborative development stack

Tutorial D

Source Control integration

Source

Contributor

Contribution

DATAllegro

Carleton University

Warwick University

Lufthansa

Carleton University

Academia

Corporate

Academia

Corporate

Unicode

Carleton University

Academia

Corporate

German Ingres User Association


© Ingres 2008

Slide
21

Community Contributions

Column Based Encryption

Auto Tuning


observation and analysis of query
execution plans to drive index advisor, statistics
updating, prioritized admin tasks

Rapid Eclipse application development with single
click updates

Source

Contributor

Contribution

Oxford University,


ICLP

Ilmenau University,

Germany

Carleton University

Academia

Corporate,

Academia

Academia

Web
-
based DBA Toolset

Eclipse Software

Open Source

Community

German Ingres User Association


© Ingres 2008

Slide
22

Developer Productivity

JDBC 3.0

NET Framework 2.0

NET Framework 3.0

Rails 1.2.3+

PHP Data Objects

(PDO)

Eclipse

Ingres CAFÉ

Ingres DTP

J2EE App Servers

Visual Studio 2005

Integrated add
-
ins

database designers

Ruby on Rails

framework

Rapid web application

development and

deployment

Zend

Zend Framework

support

.Net

Ruby

PHP

Java


Support for most popular languages and environments


German Ingres User Association


© Ingres 2008

Slide
23

Status & Plans


New Features

April 2008

20. German Ingres User Association

Kassel 2008

Ingres 2006 r1

Ingres 2006 Release 3

Ingres 2006 Release 3 DBMS Features


Scrollable cursor enhancements


Large Object Locators


UTF
-
8 Character Set


Improved DBMS defaults


Automatic storage structure for new tables


Must be enabled


New SQL functions: 16 added


Incremental rollforwarddb


Exception handling improved


Data Type improvements

German Ingres User Association


© Ingres 2008

Slide
26

Ingres 2006 Release 3 Supportability


Recovery tool logging


Cursor definition text visible


iimonitor


ipm


Terminated programs: Server type reporting


German Ingres User Association


© Ingres 2008

Slide
27

Ingres 2006 Release 3 Connectivity


Scrollable Cursors in JDBC and OpenAPI


LOB Locator Support in JDBC and OpenAPI


ODBC CLI Connection Pooling


Unix


VMS


.NET Data Provider Enhancements


User credentials on connection


Visual Studio integration


Network Communications Performance


German Ingres User Association


© Ingres 2008

Slide
28

Ingres Partner Summit


© Ingres 2008

Slide
29

Timeline and Platform Support

Ingres

German Ingres User Association


© Ingres 2008

Slide
29

2009

Ingres Roadmap

2008

2010

2011

2007

2008

2009

2010

2011

Notes:


This slide contains future
-
looking statements


2007

Ingres Icebreaker
Ingres 2006 Release 3
Ingres Service Network
Ingres 2006 Release 4 -
Liferay Update
Ingres 2006 Release 4 -
Hibernate Update
Ingres 2006 Release 4 -
Services Update
Ingres 2006 Release 4 -
Spatial Update
Ingres v10
Ingres vNext

Ingres Icebreaker BI
Ingres Icebreaker Alfresco
Internationalization
Enhanced Java Development
Availability
Manageability
ISV Support
Improved Performance
Ingres Icebreaker Portal
Expanded .Net Support
Ingres Icebreaker Developer
Proactive Services
No Tools Required
Administration
Location Based Services
MVCC
Improved Scalability
Driven by customer and Partner
Requirements
German Ingres User Association


© Ingres 2008

Slide
30

Extensive Platform Support

Operating
System

Versions


Hardware

Linux

Distribution

Base Kernel

GLibC

Compiler

RHEL 4

2.6.9

2.3.4

3.4.5

Intel® x86

RHEL 5

2.6.18

2.5

4.1.1

SuSe 10

2.6.16

2.4
-
31

4.1.0

Ubuntu

2.6.15

2.3.6

4.0.3

RHEL 4

2.6.9

2.3.4

3.4.5

x86_64 (EM64T/AMD64)

RHEL 5

2.6.18

2.5

4.1.1

SuSe 10

2.6.16

2.4
-
31

4.1.0

Ubuntu

2.6.15

2.3.6

4.0.3

RHEL 3

2.4.21

2.3.4

3.4.5

Itanium

RHEL 4

2.6.9

2.3.4

3.4.5

SuSe 9

2.6.5

2.3.3

3.3.3

HP
-
UX

11.23, 11.31

PA RISC or Itanium

HP Tru64

5.1b

Alpha

HP VMS

8.2 or 8.3

Alpha

IBM AIX

5L 5.3 or 6.1

PowerPC

MS Windows

Vista, Server 2008, Server 2005, XP

Intel® x86, x86_64(EM64T/
AMD64)

Sun Solaris

9,10

Sparc or Intel® x86

German Ingres User Association


© Ingres 2008

Slide
31

Ingres 2006 r1


Ingres OpenROAD

The fastest way to build Ingres applications

Ingres OpenROAD Short
-
Term…


OpenROAD 4.1 Service Pack 4


OpenROAD 2006 Service Pack 1


XML infrastructure
(Partner)


Transparency
(Partner)


Transparent Unicode
(Partner)


OpenROAD Server Mainsoft Dependency

German Ingres User Association


© Ingres 2008

Slide
33

Ingres OpenROAD Short
-
Term


Open Source OpenROAD


Transformation


IDE enhancements


MSI installer


eClient Ingres/Net

German Ingres User Association


© Ingres 2008

Slide
34

Ingres OpenROAD Uncommitted Long
-
Term


Interoperability


IDE integration


Consume Java and .Net


DBMS Integration


Zero Footprint Thin Client


German Ingres User Association


© Ingres 2008

Slide
35

Open Source OpenROAD: Empire Projects


E
nhanced
M
ulti
-
P
latform
I
nterpreted
R
untime
E
ngine


Open source version of OpenROAD


The Empire code line:


New OpenROAD development occurs here


Community involvement


Community contributions


Stable features are cross
-
integrated into OpenROAD


Placed through rigorous QA


Certified & supported

Ingres Partner Summit


© Ingres 2008

Slide
36

Empire Projects


Empire Development


Current OpenROAD 2006 4GL libraries and visual tools


Empire Libraries


New foundation for a new version of the visual tools


Empire Workbench


Next version of OpenROAD development environment



Empire Administrator


Next version of OpenROAD server admin. environment

Ingres Partner Summit


© Ingres 2008

Slide
37

Released OpenROAD Community Projects


OpenROAD Frequent Flyer Demo


Data Access Object Generator (DAOGen)


Proxy Generator (ProxyGen)


Test Harness User
-
interface Generator (THUG)



Ingres Partner Summit


© Ingres 2008

Slide
38

OpenROAD Frequent Flyer Demo

Ingres Partner Summit


© Ingres 2008

Slide
39

Data Access Object Generator (DAOGen)

User Interface

Database

Web Server

Java

Application

Server

Proxy Generator (ProxyGen)


Code generation


Java proxies


User classes and
procedures


OpenROAD
Server


Simple and easy
to use GUI

Ingres Partner Summit


© Ingres 2008

Slide
41

Test Harness User
-
interface Generator (THUG)

Ingres Partner Summit


© Ingres 2008

Slide
42


Simple testing


OpenROAD
Server


List SCPs



Parameter
values


Results


New Ingres OpenROAD community web site


It’s valuable:


Leverage the knowledge and work
of others


Accelerate your own development


Directly influence the future of
OpenROAD


It’s easy:


Many opportunities to fit any skill


Design, develop, test, document,
share, evangelize, etc…


See
http://community.ingres.com/wiki/M
embership

Ingres Partner Summit


© Ingres 2008

Slide
43

German Ingres User Association


© Ingres 2008

Slide
44

Engineering, SVP

Emma.McGrattan@Ingres.com

Product Marketing VP

Deb.Woods@Ingres.com

Business Development VP

Fred.Gallagher@ingres.com

WW Sales & Services, EVP

Steve.Shine@ingres.com

Services SVP

Michael.Lochead@ingres.com

Support VP

Pamela.Fowler@ingres.com

Ingres Contacts

German Ingres User Association


© Ingres 2008

Slide
45

For information contact

Product Marketing at products@ingres.com

German Ingres User Association


© Ingres 2008

Slide
46