DEV-1: OpenEdge

1
DEV-1 OpenEdge 10.1B Overview
Drew McCarthy
Principal Product Manager, Progress OpenEdge
2
OpenEdge 10.1B Agenda

• Introduction
• Goals
• OpenEdge Focus
• OpenEdge 10.1B
• Release focus
• Why 10.1B?
• Key product highlights (not an exhaustive list)
• The word on the street
• QA

3
OpenEdge 10.1B - Goals

• Goals of this talk
• Give you a sense of where 10.1B fits in the 10.X
  family
• Examine the high level themes
• Review some important features at a high level
• Introduce numerous topics presented in other
  talks
• Get you interested in trying and moving to 10.1B

4
What version are you on?

• Quick Quiz
• How many here have applications deployed on V9?
• If you are on 9 what are you currently developing
  on?
• How about applications deployed on OpenEdge 10?
• 10.0A or B
• 10.1A
• 10.1B

5
OpenEdge Platform Meeting the needs of the
entire enterprise

• Improve business processes
• Improve revenue streams
• Decrease cost of business
• Comply with regulations

• Deploy the applications with a minimum of cost
• Maintain applications in production with fewer
  resources and greater uptime

• Constraints on human resource, time and budget
• Develop new functionality

6
OpenEdge, Maintaining The Focus On
Service-Oriented Architecture
7
OpenEdge Scales for Tomorrows Needs
Some Examples
Tenure withProgress
Customers
gt14 years
gt14 years
gt15 years
gt10 years
gt15 years
gt15 years
Carrier Logistics
gt20 years
8
Characteristics of our Enterprise-Sized Customer

• Over 1 Billion in total revenue

Many have been part of the Progress family for
over a decade have Grown, Grown, GROWN!
Their data is swiftly growing they cant afford
to have limitations
They require true enterprise scalability
9
10.1B Offers Many Other Attractions

• Continuing improvements to
• OpenEdge SQL
• DataServers
• ABL and OO extensions
• OpenEdge Architect
• OpenEdge AppBuilder
• ADM2 and Progress Dynamics
• Adapters for Sonic
• Platforms/Install
• Application servers
• Online maintenance tools
• Open Client
• And743 customer bugs

10
10.1B RDBMS

• OpenEdge 10.1B release focuses on Enterprise
  customers by providing
• Enhanced support for 24 X 365 production
  environments
• Enhanced enterprise data storage to accommodate
  large numbers of transactions and high volumes of
  audit records.
• Prior to 10.1B, OpenEdge had a limit of
  approximately 2 billion rows per storage area
  (due to 32-bit dbkeys).
• Release 10.1B drastically increased the limit
  size and thereby improved production system
  scalability and manageability.

11
10.1B The Enterprise Release
Removing the Limits

• Very Large Database Support
• 64 bit features
• More storage areas memory
• User Activity Insight
• New VSTs
• Ongoing online maintenance improvements
• Enable AI online

12
10.1B RDBMS

• Large Database Support
• Addressable rows in a Type II storage area
  increased to more than 9 quintillion.
  (9,000,000,000,000,000,000)
• Support added for
• 64-bit datatype
• 64-bit sequences
• 64-bit dbkeys
• Number of storage areas available increased to
  32,000 (vs. 1000)

13
OpenEdge 10.1B RDBMS

• Shared memory allocation enhancement
• Bigger buffer pool. Bigger DBs stored in memory
• Better performance
• Increased index key width
• Multi-byte Unicode character deployments will
  greatly benefit
• RDBMS maximum theoretical size of 32 exabytes
• 5 exabytes of data approximately equals all words
  ever spoken by human beings
• (Wikipedia 05/07)

14
10.1B RDBMS Uptime, Online

• User-based I/O monitoring
• Previously only total user I/O or total I/O per
  table or index
• Now monitor I/O on a per-user per-table basis
• Help identify bottlenecks and see how users are
  affecting the system
• More things online. 24x7
• Turn on AI online

15
10.1B OpenEdge SQL

• Limit Result set
• Limit the number of rows return
• Performance boost for large tables
• Availability features
• Online schema statements.

16
OpenEdge SQL Wide Table Support

• Access limit was 500 column/fields

17
OpenEdge SQL Wide Table Support

• Limit is now 5000 column/fields
• Matches the ABL

...







18
Multi-Database Query

• Multi-db query
• No more client side joins!

SQL Client
ODBC / JDBC
Host
OE SQL Server
Auxiliaries
Primary
19
10.1B DataServer

• SQLServer and Oracle support for
• 64-bit integer data type, INT64
• 64-bit ROWID/RECID
• 64-bit sequences
• Big integer support in stored procedures
• Large key entries

20
10.1B ABL

• Support 64-bit integer data type, INT64
• The range for an INTEGER type is
• -231 to 231 
• or -2 gig to 2 gig
• or -2147483648 to 2147483647
• The range for an INT64 type is
• -263 to 263
• -9223372036854775808 to 9223372036854775807

21
10.1B ABL

• Support 64-bit integer data type, INT64 (cont.)
• 64-bit ROWID/RECID
• 64-bit sequences
• Large key entries.
• Updated Data Dictionary, Utilities.

22
10.1B ABL

• Method and constructor overloading
• Can have the same name with different parameters
• Can overload (reuse) the method names
• Class Properties
• Data members plus built in getters and setters
• Simplifies references to the values
• Returning ERROR from methods and constructors
• Can invoke the RETURN ERROR statement along with
  an optional string return value
• Package Namespaces

23
10.1B ABL

• Compiler output XREF in XML
• GUI improvements
• Data browse view-as
• Sort-arrows
• Support for High Resolution Displays
• SAX-ATTRIBUTE Object

24
10.1B OpenEdge Architect
OpenEdge Architect enhancements in 10.1B

• Database Connection Unification
• New ABL Debugger
• Object-oriented ABL Extensions
• Customization Editor
• Other Enhancements

25
Database Connection Unification
Simplify database connectivity in OpenEdge Make
it easier to reuse connections
26
10.1B Architect
New ABL Debugger

• Uses and integrates with Eclipse Debug Framework
• Can have multiple debug sessions at the same time
• Code editing can be performed while debugging
• Inspection of complex objects is simplified using
  a consolidated view

27
Expose OO through OpenEdge Architect

• Improved class wizard
• Overriding methods
• Adding constructors from super class
• Properties

28
Customization Editor

• Customize development environment
• Add actions to a menu or toolbar
• Specify a template for creating a file
• Specify a template that overrides an OpenEdge
  Architect supplied template

29
Other Enhancements in Architect...

• Eclipse 3.2
• Cheat Sheets
• Source directory support
• Progress Dynamics Integration
• 64-bit support
• Hover on Run
• Outline view changes
• New OpenEdge Architect Icon
• Installation directory structure change
• Project Property sheet changes
• Workspace preference changes
• Removal of linked resources directory

30
10.1B AppBuilder

• New INT64 support
• AppBuilder support for
• Browser column VIEW-AS functionality
• Browser column sort indicators
• Procedure Editor support for OO enhancements

31
ADM2 and Progress Dynamics

• API enabled for automated deployment of Dynamics
• INT64 Support
• Browse VIEW-AS and SORT

32
10.1B Platforms/Install

• Support for Linux PowerPC
• .NET Open Client now supports the .NET 2.0
  Framework
• Use of Default Settings from a Previous
  Installation

33
Choosing Default Values from a Previous
Installation
34
10.1B Installation

• Streamlined Installation Flow
• Updated Installation Screens
• Options to skip Sonic, WebSpeed, Progress
  Dynamics
• Online help during installation
• Shared Network Install
• Netsetup enhanced to use UNC pathnames
• \\server name\shared-resource-pathname
• Easier than using mapped drives
• Mapped drives still supported

35
10.1B Installation

• Embeddable OpenEdge Installation
• Silent install response file
• Add version and annotations, remove unnecessary
  entries.
• Silent Uninstall on UNIX
• Helps remove third party products (ESB)

36
10.1B Installation

• License Update Utility Enhancements
• No need to reinstall to
• Add components and subcomponents to existing
  installation
• Apply new serial number and control codes, e.g.
• Apply renewal PSDN subscription
• Change Eval licenses (apply new expiration or
  convert to full license)

37
10.1B Installation

• Minimizing Disk Space
• OpenEdge media uses a new compression algorithm
  that saves up to 100Mb vs. Progress V9
• Much faster installation
• Smaller kits
• Custom Install
• On a product by product basis, the Custom Install
  
• Installs Mandatory and Recommended components and
  subcomponents (default)
• Allows you to selectively install the Recommended
  and Optional Components and Subcomponents you
  want

38
10.1B Other features

• AppServer
• Enhanced user-defined returns on connect
• User-defined lifespans
• Open Client
• ProxyGen enhancements for Web services, .NET, ESB
• Support of INT64 data type
• Java and.NET Open Clients, Web Services
• .NET - Define Namespaces

39
10.1B Other features

• Adapters for Sonic
• Support for platform enhancements (e.g. INT64)
• Support for SonicFS (replaces DSData)

40
How Does OpenEdge 10.1B Deliver
Enhancement for Development
Benefits

• De facto standard for IDEs offering a modern,
  standards-based, familiar and extensible
  development platform

Based on Eclipse 3.2
Native 64 bit r -code

• Build high performing, scalable business
  applications to run on lightening fast
  platformsthe PowerPC

Enhanced object oriented capabilities

• Improves development code reuse, developer
  productivity, and better interoperability with
  .NET and Java applications

• Improves the look feel, usability, and user
  adoption of an OpenEdge application

Support for 32 bit resolution display

• Generate richer queries by seamlessly connecting
  to multiple auxiliary data catalogs simultaneously

Database connection unification via ABL SQL

• Increase developer productivity by debugging
  multiple projects and/or instances of a project
  simultaneously

Enhanced debugging

• Removes confusion of new install settings by
  reusing the previous default setting

Straight forward upgrade install
41
How Does OpenEdge 10.1B Deliver
Deployment Enhancements
BenefitsSupport of large scale data management

• Large table support assures users their
  enterprise-sized data will always be available
  and accessible
• Reduced application downtime, higher
  availability, and increased scalability
• Store huge datasets in cached memory increasing
  system transaction processing and performance
• Helps international enterprises with their global
  competitive edge by supporting multi-byte Unicode
  characters

OpenEdge DataServer utilities enhanced to support
64 bit capabilities
Optimized to run on the Linux Power PC

• Enhanced platform support to run memory
  intensive business applications
• Seamlessly leverage disparate data sources across
  an extended enterprise

Support for large key entries
Enhanced shared memory segment size
Increased RDBMS storage areas to 32,000
42
What are Customers Saying About OpenEdge10.1B?
43
Progress Software
Develop, Deploy, Integrate Manage
We simplify the job of creating the worlds best
business applications.
44
For More Information, go to

• PSDN
• http//www.psdn.com/library/kbcategory.jspa?catego
  ryID459 OpenEdge Release 10.1B Product
  Documentation
• http//www.psdn.com/library/kbcategory.jspa?catego
  ryID460Title Getting Started

45
Relevant Exchange Sessions

• DB-10 Whats New in OpenEdge 10.1B RDBMS
• DEV-3 Getting Started with OpenEdge Architect
• DEV-6 Getting Started with Object-oriented
  Programming
• DEV-12 Object-oriented Programming in the
  OpenEdge ABL
• DEV-20 Using Classes and Procedures in OpenEdge
  10.1B
• COMP-10 OpenEdge Management Replication
  Divide et impera!
• Roadmap/Info Exchanges

46
Questions?