Transcript OpenROAD 6.2

Ingres & OpenROAD News
Prepared for The German IUA
Emma K McGrattan
SVP, Engineering
October 9th, 2012
1 of 9 1 of 9
© 2012 Actian Corporation
The following is intended to outline our general product
direction. It is intended for information purposes only,
and may not be incorporated into any contract. It is not a
commitment to deliver any material, code, or
functionality, and should not be relied upon in making
purchasing decisions.
The development, release, and timing of any features or
functionality described for Actian’s products remains at
the sole discretion of Actian.
© 2012 Actian Corporation
2
Ingres Products Roadmap
2012
2013
• Ingres 9.2 SP3
• Ingres 10S
The Spatial Release
• OpenROAD 6.0
The Transparent Unicode Release
• Actian Director Phase 1
• OpenROAD 5.1 SP1
• Actian Director Phase 2
• Enterprise Access 3.0
• Ingres 10S SP1
Spatial Enhancements & Sprint
• Ingres 9.2 SP4
• OpenROAD 6.2
Web Services & UI Updates
• Actian Director Phase 3
• Ingres 10.2
Enhanced Cloud and Mobile
* Products already delivered * In Development * Features to be finalized
© 2012 Actian Corporation
3
Latest Ingres Product Releases
Ingres 10S
Windows 32-bit
Linux 32 & 64-bit
Solaris SPARC
Ingres 9.2 SP3
Windows
Linux
Solaris SPARC
HP-UX
AIX
HP OpenVMS Itanium
OpenROAD 6.0
Windows 32-bit
OpenROAD 5.1SP1
Windows
Solaris SPARC
HP-UX
AIX
Linux
Ingres 10.1 GPL Community Edition
Updated to include UK AUA Code Sprint
Contributions
4
Ingres 10.0 New Features
DBMS Server Enhancements
Multi-version Concurrency Control
– Readers Don’t Block Writers
Column Level Encryption
Scalar Sub-queries
Long Identifiers
Renaming Tables and Columns
Bulk Loading Improvements
Batch Query Execution
Ingres for 64-bit Windows
© 2012 Actian Corporations
Slide 5
Ingres 10.0 Connectivity Features
Connectivity Enhancements
JDBC 4.0 Support
64-bit ODBC Driver
IngresType.IngresDate Parameter Type
in .NET Data Provider
Named Parameters in Parameterized
Queries in .NET Data Provider
Positional Parameter Support in Drivers
© 2012 Actian Corporation
Slide 6
Geospatial Technology
•Area of rapid growth and technology change.
•Metamorphism of maps into Enterprise IT
•Increasing ubiquity in consumer electronics
•Necessity to manage resources
•Growth opportunity for analytics
© 2012 Actian Corporation
Slide 7
Ingres Geospatial Benefits
Ingres Geospatial Benefits
All-in-one database for spatial and
business data
Collect, share and manage spatial data
throughout your organization
Connect from leading spatial
applications – ArcGIS desktop, FME.
Build and deliver modern spatial-aware
applications
The most cost-effective mission-critical
geospatial database offering
24x7x365 enterprise support
Confidential © 2012 Actian Corporation
8
Ingres 10S – The Spatial Release
DBMS Server Enhancements
Geospatial Data Types and Functions
GDAL/OGR Library
OGC Simple Features for SQL 1.1
New data types include
POINT
LINESTRING
POLYGON
MULTIPOINT
MULTILINESTRING
MULTIPOLYGON
GEOMETRYCOLLECTION
© 2012 Actian Corporation
Slide 9
Support for Industry Leading Spatial Tools
Esri’s ArcGIS for Desktop
Safe Software’s FME
GDAL/OGR library
GeoTools library
Quantum GIS
GeoServer
And more…
© 2012 Actian Corporation
Slide 10
Ingres 10S – More than just Spatial
DBMS Server Enhancements
Common Table Expressions
Multi-row INSERT
New SQL Compatibility Functions
New Location for Logs (Windows)
Log File Names can include PID & Date
SET SESSION COLLATION
© 2012 Actian Corporation
Slide 11
Ingres 10S Connectivity Enhancements
Connectivity Enhancements
ODBC Batch Execution – Execution of a
single query with arrays of parameters
JDBC getGeneratedKeys
Enhancement
.NET Data Provider support for
connection string brackets to allow the
provider to recognize both double
quotes and brackets for delimited
identifiers
.NET Data Provider support for batch
updates
© 2012 Actian Corporation
Slide 12
Actian Client Runtime
Includes
Ingres Net
ODBC Driver
JDBC Driver
Data Access Server
Compatible with
Ingres 10S, EA & EDBC
Vectorwise 2.5
Optionally create vnode(s) at end of
installation process
© 2012 Actian Corporation
13
Ingres 10S Next Step
R-tree indexing on spatial types
Performance Enhancements
Additional Spatial Functions
Official Certifications
OGC Completed
SAFE Software Completed
ESRI ArcGIS Desktop
…
Confidential © 2012 Actian Corporation
14
Beyond Ingres 10
OLTP & BI Hybrid
Further Cloud & Mobile Exploitation
Improved Compatibility
Enhanced Spatial Support
Improved Big-data Support
Autonomic Database Tuning
Task scheduling
© 2012 Actian Corporation
15
Actian Director Phase 1
Unified management of Ingres
and Vectorwise environments
on premise and in the cloud
Focus is on ease of use
Scripting capabilities to
automate administration tasks
Available for both Linux and
Windows
Familiar work-flows for new
Actian customers
Leverages web technologies
and social networks
© 2012 Actian Corporation
Slide 16
Actian Director Futures
Phase 2
Data Load Support
Profiling
Beyond 2012
Enhanced Cloud & Mobile
Exploitation
Query Tool Enhancements
Scheduling
Reporting
Server Monitoring
Server Configuration
© 2012 Actian Corporation
17
OpenROAD Product Roadmap Agenda
OpenROAD 5.1 Service Packs
OpenROAD 6.2 Web Services
+Updated Look & Feel
© 2012 Actian Corporation
OpenROAD 6.0 The Unicode Release
Beyond OpenROAD 6.2
18
OpenROAD Development Roadmap
OpenROAD 6.0
Transparent Unicode Support
Extends character set support to include multi-byte
and UTF8 character sets
Requires minimal changes to existing applications
New Location for Database Connection Profiles
OpenROAD Command Window
New data type support – nchar, nvarchar, integer8
New function support
New SQL Statement support
A Windows Only Release –
OpenROAD 6.2 will be cross-platform
© 2012 Actian Corporation
Slide 19
OpenROAD 6 in Action
© 2012 Actian Corporation
20
OpenROAD 6.2
Can build applications that are indistinguishable
from Java or .NET
Providing Developers the Ability to Improve the
Appearance of OpenROAD Applications &
Conform to GUI Standards
Painting Performance Improvements
Special effects
Rounded corners
Bitmap Transparency
Sprites
Opacity
Gradient Bitmaps
Rounded borders
Multi-Image Bitmaps
Microsoft 6 Common Controls (Windows Only)
© 2012 Actian Corporation
21
OpenROAD 6.2
Improved Deployment Options
Integrate Community Contributed LoadnRun
Incorporated improvements to integrated version based on experiences
Provide Compact Deployment Option
Improve integration with other languages
Integrate Community Contributed ProxyGen into OpenROAD
Generate proxies to classes, methods and procedures exposed by the
OpenROAD Server
Allow OpenROAD Server to be a provider of RESTful API services (XML or JSON)
Allow OpenROAD client to be a consumer of RESTful API services (XML or JSON)
Build on Ingres 10S
© 2012 Actian Corporation
Slide 22
OpenROAD 6.2 Effects
Previous effects
Microsoft Common
Controls 6
Transparent Bitmaps
© 2012 Actian Corporation
23
OpenROAD 6.2 – Bringing Apps up to Date
Existing Application
© 2012 Actian Corporation
Leveraging the OpenROAD 6.2 Features
Slide 24
OpenROAD Display Improvements
Rounded Borders
Multi-image
bitmaps
Tagged
Values
Generated
Application
Rounded Corners
Bitmap Gradients
© 2012 Actian Corporation
25
Beyond OpenROAD 6.2
OpenROAD Engine Work
OptionFields
Exploit Ingres 10.x
Features
Data Types
Functions
64-bit release
Lots of foundation work needed
© 2012 Actian Corporation
Slide 26
Enterprise Access 3.0
Improved SQL Statement Support
Formalize Outer Join Support
Derived Tables, also referred to as inline SELECTs, and
SELECT in a FROM clause
Correlated Update Support
Allow native SQL to be used for SELECTs (only)
SELECT queries without a FROM clause support (also
referred to as Tableless Select with Bind Parameters)
Improved Data Type Support
Updated LOB Support for Microsoft SQL Server
Decimal 39 Support
Bigint (Integer8) Support
Long Identifier Support
© 2012 Actian Corporation
27
Enterprise Access 3.0 (continued)
Usability Enhancements
Change default for load_table_qualifier to provide better out
of the box experience
Log gateway daemon listen address in server start-up
message in errlog.log
Security Enhancements
Support for Operating System Authenticated Groups in
Microsoft SQL Server and Active Directory
Windows UAC Support
Miscellaneous Enhancements
Improved Installer
Support for the latest DBMS releases
Based on Ingres 10S
© 2012 Actian Corporation
28
Thank You!
Any questions regarding the contents
of this presentation should be
addressed to:
[email protected]
© 2012 Actian Corporation
29
© 2012 Actian Corporation
Please Note
The preceding is intended to outline our general product
direction. It is intended for information purposes only,
and may not be incorporated into any contract. It is not a
commitment to deliver any material, code, or
functionality, and should not be relied upon in making
purchasing decisions.
The development, release, and timing of any features or
functionality described for Actian’s products remains at
the sole discretion of Actian.
Confidential © 2012 Actian Corporation
31
EDBC 2.4
Support for z/OS Common Storage Area Key
Support for the latest DBMS releases
Support for latest operating system releases
Confidential © 2012 Actian Corporation
32
OpenROAD 6.2
Providing Developers the Ability to Improve the Appearance of
OpenROAD Applications & Conform to GUI Standards
Feature enhancements
Exact width and height settings (including zero size) for TableFields
Bitmapped tabs (an additional TabBar style option)
Adjustable field-level margins for EntryFields
Extend the definition of an application, field, or class as much as you like, by
adding properties in the form of tag plus value. Tags are saved, inherited,
scoped just as properties are. (Tagged Values)
Rich TreeViewFields to support virtually all industry-standard features
Improve support for Microsoft Common Controls
Slide 33
OpenROAD 6.2
Providing Developers the Ability to Improve the Appearance of
OpenROAD Applications & Conform to GUI Standards
Code Generation
Frames / user classes
Special effects
Rounded corners / Bitmap Transparency / Sprites / Opacity
Deployment
LoadnRun
Built on Ingres 10S
Slide 34
OpenROAD 6.2
Community Collaboration via Sprint Projects
Breaking out of Tight Loops
Control the Display of Super Class Information for Attributes and Methods
Allow Property Inspector Frame to be Always on Top
New on Context Menu
Disable New toolbar button for active Components pane
Application name in title of Components portlet
Implement Sorting in Table Selection Frame
Check for empty database name before connecting to new database in Query tab
Color of Database and Table fields should indicate changeability when inserting
attributes from DB table
Enclose literal strings in quotes when assigning new values in Debugger
Improve file handling in workbench tools
Slide 35