Transcript Ingres and OpenROAD Status and Plans
Ingres & OpenROAD Current Status & Future Plans
Emma McGrattan September 2011
Ingres DBMS Status
Ingres 10 Availability
– Linux x86 32/64 – Windows 32/64 – Solaris SPARC 32/64 – HP-UX RISC 10.0.1 Service Pack now in the planning stages
Ingres 9.2.3 Services Packs
– Prepared for QA Confidential — © 2011 Ingres Corporation Slide 2
Beyond Ingres 10
Geospatial Management Toolset Big data Cloud deployment Usability/Migration Sprint contributions
Confidential — © 2011 Ingres Corporation Slide 3
Geospatial Technology Geospatial
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 Confidential — © 2011 Ingres Corporation Slide 4
Open Source Geospatial Foundation Non profit founded in 2006 to:
“support and promote the collaborative development of open geospatial technologies and data” Over 440 committers and 7.7M Lines of code Confidential — © 2011 Ingres Corporation Slide 5
ESRI ArcMap Tool Illustrating Cities of Canada
Confidential — © 2011 Ingres Corporation Slide 6
..and now to view snowfall
Confidential — © 2011 Ingres Corporation Slide 7
Browsing Ingres Spatial Data via ArcEditor
Confidential — © 2011 Ingres Corporation Slide 8
The data behind the map
Confidential — © 2011 Ingres Corporation Slide 9
Management Toolset
10
Create a Database
Confidential — © 2011 Ingres Corporation Slide 11
Server Connection
Confidential — © 2011 Ingres Corporation Slide 12
Explorer
Confidential — © 2011 Ingres Corporation Slide 13
Create User
Confidential — © 2011 Ingres Corporation Slide 14
Usability/Migration
Usability improvements
– ODBC client package – Character set migration
Roadmap
– More operations spanning both Ingres & VW types – Lightweight client (e.g. no GCA) – Client/server transliteration – Transport compression – More SQL compatibility Confidential — © 2011 Ingres Corporation Slide 15
OpenROAD Current Status
OpenROAD 2006
– Terminal release for HP Tru64 – Enterprise support ends December 31 st , 2011 2013
OpenROAD 5.1 is the most current release
– GA platforms • Windows, AIX, Solaris, HP-UX – QA team is testing • Linux
OpenROAD 6.0 is now with QA
Confidential — © 2011 Ingres Corporation Slide 16
OpenROAD Development Roadmap (6-9 months out)
OpenROAD 6.0
– Plans are for Windows only – Superset of OpenROAD 5.1
– Primary differences are • Built against Ingres 9.2
• Transparent Unicode Support – QA going as expected Confidential — © 2011 Ingres Corporation Slide 17
OpenROAD Development Roadmap (1-2 years out)
Providing developers the ability to improve appearance of applications
– Code Generation • Frames / user classes – Special effects • Rounded corners / Transparency / Sprites – Tablefields • Exact height and width – Deployment • LoadnRun contribution Confidential — © 2011 Ingres Corporation Slide 18
OpenROAD Development Roadmap (1-2 yrs)
Current Bitmap, Transparent, Rounded Confidential — © 2011 Ingres Corporation Slide 19
Longer Term OpenROAD Development Roadmap
OpenROAD Engine Work
– TreeviewFields – OptionFields
Built against Ingres 10.x
Exploit Ingres 10.x
– Features – Datatypes
64 bit release
– Lots of foundation work needed Confidential — © 2011 Ingres Corporation Slide 20
Dankeschön!
UK IUA Code Sprint Contributions
Confidential — © 2011 Ingres Corporation Slide 22
Interoperability & Migrations
Row value constructors
Multi-row inserts
DECODE() REPEAT() RAND() & SRAND()
Confidential — © 2011 Ingres Corporation Slide 23
Row Value Constructors and Multi-Row Inserts
Row value constructors Improved efficiency and performance Example Multi-Row Insert INSERT INTO Orders (OrderNo, ItemNo, Qty, UnitPrice) VALUES (1200, 23478, 10, 30.00), (1200, 15453, 4, 23.00), (1200, 14545, 1, 89.00)
Confidential — © 2011 Ingres Corporation Slide 24
DECODE() function Syntax: decode( expression , search , result [, search , result]... [, default] )
expression
is the value to compare.
search
is the value that is compared against
expression
.
result
is the value returned, if
expression
is equal to
search
.
default
is optional. If no matches are found, the decode will return
default
. If
default
is omitted, then the decode statement will return null (if no matches are found).
Confidential — © 2011 Ingres Corporation Slide 25
DECODE() Example SELECT supplier_name, decode(supplier_id,10000, 'IBM', 10001, 'Microsoft', 10002, 'Hewlett Packard', 'Gateway') result FROM suppliers;
Confidential — © 2011 Ingres Corporation Slide 26
REPEAT() function Syntax: repeat (expr,n)
expr
An expression that specifies the string to be repeated.
n
specifies the number of times to repeat the string.
Example: REPEAT('REPEAT THIS', 5) 'REPEAT THISREPEAT THISREPEAT THISREPEAT THISREPEAT THIS’ Synonym: replicate (expr,n)
Confidential — © 2011 Ingres Corporation Slide 27
RAND() and SRAND()
rand([seed])
– seed is an integer that gives the seed value. If seed is not specified, it assigns a seed value at random. For a specified seed value, the result returned is always the same.
– Returns random float value between 0 and 1
srand(int)
– Sets the starting point for generating a series of pseudorandom values Confidential — © 2011 Ingres Corporation Slide 28
Usability – Loyal Ingres Users
Terminal Monitor Formatting Enhancements Availability of last recorded query start time and session start time in IIMONINTOR II_GCD_LOG support for %p – the process id; %d – the date alterdb –readonly | -readwrite relocateckp - restore checkpoint to another database, potentially in another Ingres instance
Confidential — © 2011 Ingres Corporation Slide 29
Usability – Loyal Ingres Users
Ability to turn on SC924 via config.dat and to switch on a stackdump when it is triggered
Audit log maintenance script to prevent disk full problems
infodb –database – display a list of databases
Confidential — © 2011 Ingres Corporation Slide 30
Service Desk Enhancement Request 150914
Check for empty database name before connecting to new database in Query tab Complete Slide 31
Service Desk Enhancement Request 118655
Change BgColor of ‘Database’ and ‘Table or View’ entry fields in the dialog titled ‘Select a Database Table’ to indicate that you can type into these fields.
Complete Slide 32
Service Desk Enhancement Request 118656
Implement sorting by clicking on a ‘Table Selection:’ frame’s header column to order the rows in the display table. Please implement two levels of ordering.
Complete Slide 33
Service Desk Enhancement Request 150994
When suggesting a string value for assignment to a variable in the debugger please enclose in single quotes Complete Slide 34
Service Desk Enhancement Request 123158
It would be nice to have an option like 'always on top' for the property inspector.
Complete Slide 35
Service Desk Enhancement Request 116927
It should be possible to create a new application or component when right clicking in the applications or components pane. Currently the option 'new' is not available on the menus opened by right mouse click.
Complete Slide 36
Service Desk Enhancement Request 116927
It should be possible to create a new application or component when right clicking in the applications or components pane. Currently the option 'new' is not available on the menus opened by right mouse click.
Complete Slide 37
Service Desk Enhancement Request 116927
It should be possible to create a new application or component when right clicking in the applications or components pane. Currently the option 'new' is not available on the menus opened by right mouse click.
Complete Slide 38
Service Desk Enhancement Request 116925
When you click on the components pane and then click on the 'new' button, a popup for creating a new application gets opened. Confidential — © 2011 Ingres Corporation Slide 39
Service Desk Enhancement Request 116925
The customer expects to create a new component. Either the 'new' button should be dimmed, when the components pane is activated or when clicking the 'new' button you should get a list of possible components to create Complete Confidential — © 2011 Ingres Corporation Slide 40
Dankeschön!