Session Title

1
Reach Your Technical Peak 2004
2

• 10 Good Reasons to Upgrade to 10!

3
How About 10!
OUTPERFORM your current software BY 25 or more.
1
Access your data any way imaginable with new
PRODATASETS.
9
Now you can make CHANGES to your database ON THE
FLY.
2
Get up and running on OpenEdge 10 in LESS THAN AN
HOUR.
10
Achieve 24 x 7 AVAILABILITY even during routine
maintenance.
3
Now reach UNPRECEDENTED SCALABILITY up to 10,000
simultaneous users.
4
Gain user interface independence through COMPLETE
.NET SUPPORT.
5
Get on the Enterprise Service Bus for your
present and future INTEGRATION needs.
6
Capitalize on THE MOST OPEN development and
deployment environment around.
7
Leverage JMS, XML, AND WEB SERVICES without
leaving the OpenEdge platform.
8
4
Agenda

• History of Progress Releases
• 10 Reasons
• Summary

5
Where It All Began
Progress Software 1775
6
OK Not THAT Old ButJust How Old is Version 8?

• Or 6 7 for that matter?
• V9 was released when?
• What else was current way back then?

7
V6 -- 1990

• Fuzzy Checkpoints
• -spin
• PF Files

• USSR Communist party agrees to allow opposition
  political parties
• "The Bradys" return to TV for 6 episodes on CBS
  TV
• MS Sales 1B
• 10mhz 286 PS/1 2000
• NEC Laptop 850016mhz 386sx2MB RAM42MB
  disk(color)

8
V7 -- 1992

• President Bush apologizes for raising taxes after
  pledging not to
• Farm Aid V
• Voting begins on choice of Elvis postage stamps
• Microsoft announced Windows 3.1, upgrading
  Windows 3.0
• 66mhz PowerPC
• HP 9000 725 18,00050mhz PA RISC16mb RAM,
  512MB disk
• Thinkpad 700c 4,35025mhz 486sl4MB RAM120MB
  disk

• Jumpstart
• GUI
• -mmax

9
V7.3 -- 1995

• Persistent Procedures

• Dow Jones for 5th straight day of the week sets a
  new record (4430.59)
• US space probe Galileo begins orbiting Jupiter
• Los Angeles Rams announce that they are moving to
  St Louis
• Pentium Pro 200mhz
• DEC Alpha 300mhz

10
V8 -- 1996

• User Defined Functions
• VSTs
• Variable Block Sizes
• AppServer
• WebSpeed
• Fast Schema Change

• After 27 years, Betty Rubble debuts as a
  Flintstone vitamin
• Lisa Marie Presley filed for divorce from Michael
  Jackson in NY
• Linux 2.0

11
V9 -- 1999

• Pluto is once again the farthest planet from the
  sun in our solar system
• Judge Jackson declares MS is an abusive
  monopoly
• Control of Panamá Canal reverts to Panamá
• SCO IBM start working on Monterey
• Fujitsu Lifebook 2,600333mhz PII64MB
  RAM6.4GB disk

• Storage Areas
• Publish and Subscribe
• Dynamic Queries
• XML
• SQL-92

12
OpenEdge 10 -- 2004

• Conjunction of Sun, Mercury, Venus, Mars,
  Jupiter, Saturn Moon
• Dell Latitude 2,500Pentium M _at_ 1.2ghz640MB
  RAM40GB disk

• Advanced Storage Architecture 2 (ASA2)
• ProDataSet
• WebServices support
• New Data Types
• BLOB
• CLOB
• Datetime

13
Agenda

• History of Progress Releases
• 10 Reasons
• Summary

14
OUTPERFORM your current software BY 25 or more.
1

• ASA1
• Implemented in Progress Version 9
• Storage areas, ROWID is unique per area
• ASA2
• A brand new space allocation mechanism
• ROWID is unique per area and object block (new
  database object)
• OpenEdge 10 Database can have both objects
• ASA1 ASA2

ASA2
15
ASA I Storage Area
Type I Storage Area
extent 1 (fixed)
extent 2 (variable)
Area Control Object
Table 1 data
Table 2 data
Table 3 data
Table 4 data
Table 5 data
Table 6 data
16
ASA 1 Storage Area over time
Type I Storage Area
extent 1 (fixed)
extent 2 (variable)
Reserved Blocks
Table 1 data
Table 2 data
Table 3 data
Table 4 data
Table 5 data
Table 6 data
17
ASA II Storage Area with Clusters
Type II Storage Area
extent 1 (fixed)
extent 2 (variable)
Area Control Object
Table 1 data
Table 2 data
Table 3 data
Table 4 data
Table 5 data
Table 6 data
18
ASA Performance
19
Wheres The Proof?I Was Promised a Benchmark!
V8 Performance
V9 Performance
V10 Performance
20
Test Platform

• Mid Market Hardware
• Dell PowerEdge 6600
• 4x2Ghz Xeon w/HT
• 2GB RAM
• 6 disks
• Windows Server 2003
• Linux AS 2.1

21
The Database

• Sports2000 schema
• Randomly generated data
• Mix of Table Record sizes
• Some Scatter

22
Tuning Parameters

• Mostly Out of the Box
• Try not to make this a disk performance test.
• Basic Tuning
• -B
• -i
• Simple File Placement
• No Heroics

23
Benchmark Study Summary

• PACE Application, developed by Tom Bascom of
  Greenfield Technologies, Inc.
• Application purposed to simulate user workload
• 100 users
• Varying record read, create, update and delete
  rates

24
Benchmark Study Summary

• 2 sets of tests
• Compare Version 9.1D and OE10
• install the software and do not take advantage of
  new OE10 features
• Compare Version 9.1D and OE10
• taking advantage of new features

25
What a Performance Improvement!
26
Now you can make CHANGES to your database ON THE
FLY.
2

• Customers can operate 24x7 and still evolve their
  databases and applications
• Relaxed requirements for exclusive access to the
  database while adding objects
• New tables and associated table schema
• Fields
• Indexes
• Database triggers
• Sequences

Online DB Changes
27
Achieve 24 x 7 AVAILABILITY even during routine
maintenance
3

• Failover clusters integrated into 10.0B
• OpenEdge Enterprise RDBMS only
• No control code requirements
• Faster index rebuild
• Index Compaction

Clusters
28
ClusteringNow Part of the Enterprise DB!
29
Now Reach Unprecedented Scalability Up to 10,000
Simultaneous Users
4

• Progress AppServer is the key
• OpenEdge Adapter for SonicESB
• State-free

Appserver
30
The Application Server
Any client
OpenEdge Application Server
WebSpeed Transaction Server
Application Code
AppServer
Data
31
A Client With Most Language Enhancements Available
Application Server Process

• Executes OpenEdge 4GL procedures
• Application Server processes are reused
• Determined by AppServer operating mode

32
OpenEdge Adapter for Sonic ESB
Sonic Enterprise Service Bus (ESB)
OpenEdge Application Server/Enterprise
Service Container
WSA Engine
ESB Service
Client
BusinessLogic
JMS
HTTP/SOAP
33
Existing Session Managed Model
Operating Modes

• State-reset
• One client per Application Server process
• Session state is reset on disconnect
• State-aware
• One client per Application Server process
• Session state is maintained across connections
• Stateless
• Connection managed by AppServer Broker
• Many clients per application server process
• Context must be managed externally

34
New Kid On The BlockSession Free Model
Operating Mode

• State-free
• No connection maintained between client and
  AppServer process
• Pooled connections
• 4GL requests on the server handle
• Web service requests on the WSA
• Requests dispatched similar to stateless except
• Multiple requests from one client run in parallel
• Each request runs independently
• Context must be managed externally

35
State-free Operating Mode
AppServer
Application Server Processes
Client 1
Client 2
Application Broker
NameServer
Data
Client 3
Web Services Adapter
Client 4
36
Gain user interface independence through COMPLETE
.NET SUPPORT.
5

• .NET Open Client support for
• Windows forms (GUI)
• Web forms (ASP.NET)
• .NET
• Web services

.NET
37
OpenEdge .Net integration
.NET UI Integration
Client
OpenEdge Application Server

Open Client .NET Proxy
.NET Client App
App Object
Proc Object
Sub- AppObj

• ProxyGen Enhancements
• .NET Proxy Assembly
• Open Client interface for .NET

Database Server
38
Get on the Enterprise Service Bus for your
present and future INTEGRATION needs.
6

• This adapter puts OpenEdge applications on the
  Sonic ESB Services bus.
• Any application on the bus can access your
  OpenEdge application as a reusable service.

ESB Adapter
39
Distributed Process Framework

• Service
• Content based routing services
• Transformation services
• Custom services (OpenEdge Service)
• Process Itineraries
• Endpoints
• JMS Topics
• JMS Queues
• J2EE CA based connectors

40
Message Flow in a Process
Dispatcher trims Itinerary and creates Process
Context
Service Application
XQMessage(s)
Dispatcher
Service
Endpoint
Endpoint
LogicalConnection
LogicalConnection
Service acts on the message, only.
Multipart Message(JMS)
41
Services-oriented Architecture
Add New Web Standards-based Services

• Provides standards-based services interface
• Designed for distributed functionality
• Hides implementation details
• Enables reuse

Adapter
SCM
Integration Broker
CRM
Tracking Service
Adapter
Adapter
Adapter
Order Entry
ERP
CRM
SCM
Partner
Finance
Enterprise
42
ESB-enabling OpenEdge
ClientApplication
SOAP/HTTP

Enterprise Service Bus
AppServerProtocol
Put your app on the Bus!!
HTTP in
AppServer
43
Capitalize on THE MOST OPEN development and
deployment environment around.
7

• Platform Portability
• Support for Industry Standards
• Microsoft, LINUX, UNIX
• Single Set of Code
• .NET to J2EE and All Points In Between
• ODBC, JDBC, DataServers
• Improved SQL Performance
• Lock hint support
• Index hint support

Be Open!
44
Lock Hints Support

• Table-level locking hints
• To override current isolation level locking
  behavior by skipping locked records
• Can be found in
• WITH clause
• Restrictions on Locked hints
• SELECT statement only
• READ-COMMITTED isolation level only

45
Lock Hints Support Syntax

• Syntax
• SELECT column_list
• FROM table_list
• WHERE search_condition
• GROUP BY grouping_condition
• HAVING search_condition
• ORDER BY ordering_condition
• WITH locking_hints

46
Index Hint Support

• Index hints
• To overcome SQL92 optimization process limits
  when selecting indexes
• Restrictions on Index hints
• SELECT statement only

47
Index Hint Support

• Syntax
• SELECT column_list
• FROM table_list
• Where Table_list is
• table_name AS table_alias WITH
  (INDEX ( index_val ), ... )
• Example
• Select
• From pub.customer
• With (Index (countrypost))
• Order by country

48
Leverage JMS, XML, AND WEB SERVICES without
leaving the OpenEdge platform.
8

• Make your Progress business logic callable as a
  Web Service by trusted partners or the world

Web Services
49
Open Standards

• Web Services
• A set of standards that comprise a new platform
  for building distributed, interoperable
  applications
• OpenEdge Web Services utilizes W3C standards
• WSDL 1.1 (W3C Note defacto standard)
• SOAP 1.1 HTTP Binding
• 2001 XML Schema

50
OpenEdge 10Web Services Support

• All functionality merged into core products
• Open Client Toolkit
• Generation of Web Services files
• Web Services Adapter
• OpenEdge Application Server Enterprise
• OpenEdge Studio
• OpenEdge Development Server

51
Web Service Development
Open Client Toolkit ProxyGen generates a Web
service mapping file
AppServer Application
ProxyGen
WSM
Input
Output
Development
52
Web ServiceDeployment and Administration
3rd party components shown in red
WSDL
Web service mapping file is deployed using
Progress Explorer
Output
Web ServicesAdapter (WSA)
WebServerJSE
Admin Server
ProgressExplorer
SOAP/HTTP
Output
WSAD
Reads
WSM
Deployment/Admin
53
Web Service Runtime
WebServicesClient App
3rd party components shown in red
HTTP Request
Web ServicesAdapter (WSA)
WebServerJSE
AppServer
HTTP Response
AppServer Application
Reads
A Web service client is another Open Client
to the AppServer
WSAD
DB
Runtime
54
Access your data any way imaginable with new
PRODATASETS.
9

• In-memory data store
• Structure, relations and data can be passed using
  a single handle
• Pass by reference within a session
• Simplifies data encapsulation in a distributed
  environment

ProDataSets
55
ProDataSets

• The driving force in OpenEdge Applications

OpenEdgeBusiness Logic
OpenEdge.NET Interface
Purchase Order Business Logic
PurchaseOrderProxy
PO ProDataSet
HeaderData
DetailData
OtherData
WebClient / HTML User Interface
OpenEdge4GL Interface
Schema- holder
ADM or other 4GL/Web Interface
Jonas Grumby
OK
110 Desert Isle Path
Cancel
Minnow, HI
RDBMS
OpenEdgeWeb Services Interface
56
Get up and running on OpenEdge 10 in LESS THAN AN
HOUR.
10

• proutil mydb -C conv910
• Other conversion tools
• 83dbutils
• 91dbutils

V9 db ? OE10
57
Why Stop at 10?

• 4GL Client Enhancements
• Security

58
4GL Client Enhancements

• Calling a Web service from the Progress 4GL,
• similar to calling an AppServer procedure
• WSDL Analyzer helps with calling syntax
• Larger r-code segment support
• Additional Data Types (BLOB, CLOB, DATETIME,
  DATETIME-TZ
• Arrays as parameters

59
Security

• 10.0B introduces channel encryption between
  OpenEdge components (e.g., OE10 client to OE10
  AppServer using SSL)
• 4GL support for cryptographic operations
• DES, DES3, AES for encryption
• MD5, SHA for data integrity

60
Agenda

• History of Progress Releases
• 10 Reasons
• Summary

61
Whats Stopping You?Upgrade - Myths

• MYTH Upgrades require more resources.
• Truth Upgrades make better use of your existing
  resources.
• MYTH Newer releases are slower than older
  releases.
• Truth Upgrades perform better on identical
  hardware.

62
Whats Stopping You?Upgrade - Myths

• MYTH You must upgrade everything or nothing.
• Truth Some mixed configurations possible!
• Ex V9 Client to OE10 AppServer to V9 RDBMS

63
Upgrade Benefits

• Day-to-day Workload improvements.
• Maintenance Improvements.
• Conversion to larger block sizes and row per
  block settings can be very beneficial.
• Conversion to type 2 areas can be very
  beneficial.
• 4gl performance is getting a lot of attention.

64
Wrap-up

• Never underestimate the impact of cheap hardware!
• As a general rule the db is not your ultimate
  constraint.
• The most advantage comes from leveraging new
  features.
• There is a clear positive trend in the numbers!

65
Resources
PSDN Whitepapers OpenEdge 10 Benchmark
Results http//psdn.progress.com/library/whitepap
ers/benchmarks/docs/oe10a_rdbms_benchmark.pdf New
in 10.0B http//psdn.progress.com/library/whitep
apers/openedge10/docs/whats_new_100b.pdf Security
http//psdn.progress.com/library/whitepapers/ope
nedge10/docs/dataprivacywp.pdf Progress Users
Groups www.progress.com/napug
66
Training Opportunities
67
PSC Courses Available

• OpenEdge 10
• For Architects
• OpenEdge Reference Architecture Workshop
• Application Transformation Workshop
• For Developers
• Using ProDataSets
• XML Essentials
• 4GL Development with XML
• Opening 4GL Applications to Web Services Clients
• Consuming WebServices from OpenEdge 10

68
PSC Courses Available

• OpenEdge 10
• For Database Enthusiasts
• Database Performance Tuning
• Database Administration
• Database Internals for Trouble Shooting

69
PSC Courses Available

• Crystal Reports
• Crystal Reports (CBT)

70
(No Transcript)