OpenEdge 10 Is Ready Are you

1
OpenEdge 10 Is ReadyAre you?
2
We Talked About The Guiding Principles of
OpenEdge 10
Applications are a collection of software
components that reflect the actual business
processes
3
The Herald of What Was to Come
The Foundation for All OpenEdge 10 Releases
3 Strategic Elements
SOAEnabled
.NET API
ProDataSet
ESB AdapterWeb Services
4
We Gave You 10 Great Reasons to Move to OE10
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
5
OUTPERFORM your current software BY 25 or more.
1
ASA2

• 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

6
Type II Area Block Clusters

• Block Cluster
• Fixed size for area
• 8, 64, or 512 adjacent blocks
• Unit of space allocation for objects
• Configured in .st file
• All blocks in cluster belong to same object

7
Type II Area Objects
(tables, indexes, lobs, area control)

A database object made up of one or more block
clusters
8
Great Idea!But You Had Questions

• Is there an advantage to using ASA2 for a table
  when I have it within ASA1?
• ASA2 allocates space very differently, so dynamic
  tables will benefit greatly.
• Can I prorest into a Type II Storage Area?
• No, prorest cannot be used to restore tables in
  ASA1 into the new ASA2.

9
Now you can make CHANGES to your database ON THE
FLY.
2
Online DB Changes

• 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

10
Great Idea!But You Had Questions

• How do I make online schema changes to the
  Database?
• (P79975) GUI dictionary or the load definition
  utility in the Data Admin/Character Dictionary.
• Is it possible to make online field and index
  changes to an existing table?
• (P97492) This is not possible, yet. It is on the
  DB roadmap for OpenEdge. (Next Slide Please!)

11
High Availability DB Roadmap
On line schema changes

• Phase 1 schema versioning, index crcs (done)
• Phase 2 OE SQL schema lock only in transaction
  (done)
• Phase 3 Add table sequences online (done)
• Phase 4 Add inactive index
• Activate index online w/fast fill
• Add new field
• Deactivate index on-line
• Phase 5 Fine-grained schema locks
• Automatic de-escalation and escalation
• Phase 6 Delete table, index online
• Phase 7 Change table online

12
Achieve 24 x 7 AVAILABILITY even during routine
maintenance
3
Clusters

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

13
Great Idea!But You Had Questions

• Can an index rebuild be run for just one table?
• (P81553) Yes. You will need to know the index
  names for that particular table.
• When should indexes be rebuilt?
• (20317) index rebuild after
• A bulk load.
• Manual deactivation of all indexes before a Data
  Dictionary load with previously dumped activated
  index tables.
• A binary dump and load (9.1A and earlier)
• After changing the DataBase Collation Table
• After changind the Word-Break Table

14
Now Reach Unprecedented Scalability Up to 10,000
Simultaneous Users
4
Appserver

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

15
Great Idea!But You Had Questions

• Can a version 9 Client connect to OpenEdge 10
  AppServer?
• (P50076) Yes. Version 9.1D or later clients can
  connect to OpenEdge 10 AppServer.
• What is meant by state-free AppServer operation
  mode?
• (P101397) This refers to the lack of any context
  maintained by AppServer sessions between client
  requests.

16
Gain user interface independence through COMPLETE
.NET SUPPORT.
5
.NET

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

17
Great Idea!But You Had Questions

• Is the .Net Open Client supported with Dynamics?
• No, not yet.
• Is the ProDataSet support restricted to .Net Open
  Client?
• (P98360) The ProDataSet is supported by the
  Progress 4GL itself. A ProDataSet can also be
  passed from Progress to any .Net applications
  (C, VB.Net, ASP.Net,...).

18
Get on the Enterprise Service Bus for your
present and future INTEGRATION needs.
6
ESB Adapter

• 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.

19
Great Idea!But You Had Questions

• Does Sonic ESB Adapter also include Sonic MQ
  adapter?
• The SonicMQ adapter and the ESB Adapter are two
  different products.
• Is the SonicMQ Adapter installed with a Client
  Networking license in OE 10?
• (P81235) The Open Edge Adapter for SonicMQ is a
  recommended component of the Client Networking
  installation.

20
Capitalize on THE MOST OPEN development and
deployment environment around.
7
Be Open!

• 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

21
Great Idea!But You Had Questions

• Is encrypted source code portable across
  platforms?
• Yes, like unencrypted source, encrypted source is
  completely portable across platforms and user
  interfaces.
• On which versions of the Linux Operating System
  is OpenEdge 10.0x certified? (P63174)
• Red Hat Enterprise Linux AS/WS/ES 2.1
• Red Hat Enterprise Linux AS/WS/ES 3.0
• SUSE Linux Enterprise 8
• TurboLinux Enterprise 8

22
Leverage JMS, XML, AND WEB SERVICES without
leaving the OpenEdge platform.
8
Web Services

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

23
Great Idea!But You Had Questions

• Can I access a web service from within a 4GL
  procedure?
• Yes. OpenEdge 10 has native 4GL support for this.
  Detailed information, can be found in the
  OpenEdge 10 documentation.
• Are ProDataSets supported with Web Services?
• ProDataSets are not supported with Web Services
  In or Out, yet.

24
Access your data any way imaginable with new
PRODATASETS.
9
ProData Sets

• 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

25
Great Idea!But You Had Questions

• What are the benefits of ProDataSets? (P68764)
• Define a structure that represent normalized and
  organized tables, regardless of the external
  structure of the DataBase.
• Treat data combined from different data sources
  as single objects.
• Filled automatically from a variety of data
  sources and can write changes back to multiple
  data sources.
• Automatically capture modifications, additions
  and relationship to the data through before-image
  tables.
• Can be passed as a set of inter-related data as a
  single parameter from one procedure to another.
• Map closely to the ADO.NET for standard data
  access
• Trigger events during their life cycle.

26
Get up and running on OpenEdge 10 in LESS THAN AN
HOUR.
10
V9 to OE10

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

27
Great Idea!But You Had Questions

• What should I consider after converting? (P50262)
• First, make a backup of your V9 database.
• Plan Storage Areas.
• Run "proutil ltdbgt -C tabanalys" to determine the
  average size of the records in each table.
• Areas are added to an existing database using
  "prostrct add ltdbgt ltdb.stgt.
• Use the "-C mvsch" option with proutil to reduce
  the schema area to a minimal size.
• Lastly, first make a backup of your V9 database

28
But Then, 10.0B Was Just An Infant
10.0B
29
One Focus of 10.0B Was Security
Your Stuff
30
Why Security?Everyones Looking At Security
Percentage of IT budget spend on security
31
Why Security?And They Want In House
Percentage of security function outsourced
32
Is the Security Threat Real?

• 2004 FBI report on Cybercrime
• 70 reported intrusions by outside independents
• 66 reported break-ins by internal company
  employees
• 51 reported publicity from security issues would
  hurt stock/image
• 48 did not report security intrusions

33
Security Threat, Very Real
Dollar amount of losses by type
34
Security Before 10.0B

• Compile time security
• DBAUTHKEY        encrypted r-code        CRC/tim
  e-stamped r-code        RDBMS authorization     
     Schema security
• Runtime security        ENCODE        EXPORT

35
What Does 10.0B Provide?

• SSL Encrypted Channels
• Secure Socket Layer
• Securing all the pipes that connect components
  together
• Cryptographic Functions
• ENCRYPT and DECRYPT support
• Securing the data inside the pipes
• Message Digests functions
• MD5-DIGEST
• SHA1-DIGEST
• Base64 functions
• BASE64-ENCODE
• BASE64-DECODE

36
SSL Encrypted Channels
WebSpeed Broker
Web Browser
Web Server
WebSpeed Messenger
WebSpeed Agents
NameServer
.NET/Java Open Client
WebClient
3rd Party Database
OpenEdge DataServers
AppServer Internet Adapter
Java Servlet Engine
AppServer Broker
AppServer Processes
Web Services Adapter
OpenEdge Database
Web Services
4GL Client
3Rd Party Web Service
OpenEdge 10.0B
Sockets
Sonic ESB Adapter
Sonic ESB
SonicMQ
SonicMQ Adapter
OpenEdge SQL Client
3rd Party Products
37
Using Cryptography to Secure the Data in the
Database
WebSpeed Broker
Web Browser
Web Server
WebSpeed Messenger
WebSpeed Agents
NameServer
.NET\Java Open Client
WebClient
3rd Party Database
OpenEdge DataServers
AppServer Internet Adapter
Java Servlet Engine
AppServer Broker
AppServer Processes
Web Services Adapter
OpenEdge Database
Web Services
4GL Client
3Rd Party Web Service
OpenEdge 10.0B
Sockets
Sonic ESB Adapter
Sonic ESB
SonicMQ
SonicMQ Adapter
OpenEdge SQL Client
3rd Party Products
38
But Not Only SecurityOE10 Development
ProData Sets
OpenEdge Studio

• The AppBuilder has a new utility for maintaining
  temp-tables.
• The OpenEdge Studio tools and methodologies
  support the OE 10 data types BLOB, CLOB,
  datetime, and datetime-tz.
• You can now specify a PASSWORD-FIELD attribute
  for fill-in fields.

• ProDataSet as a parameter.
• SYNCHRONIZE event
• COPY-DATASET method
• ROW-STATE. Additional functions ROW-ERROR,
  ROW-REJECTED, and DATA-SOURCE-MODIFIED.

39
OE10 Development
Open Client
Progress Dynamics

• Progress Dynamics supports Mozilla browser.
• Treeviews available for Progress Dynamics Web.
• AppBuilder utility builds temp-tables based on
  repository entities.
• HTML XML print preview options.
• Fields in dynamic objects performance enhanced.

• .NET support HTTP and HTTPS.
• .NET and Java supports OE 10 data types.
• .NET and Java Clients NO-SCHEMA-MARSHALL
  attribute
• .NET and Java Open Clients can now operate in a
  session-free model.

40
OE10 Development
Diagnostics
Progress 4GL

• ProDataSets and arrays as parameters.
• Browse widget supports mouse-wheel scrolling.
• COPY-TEMPTABLE
• Arrays supported as parameters to DLLs.
• TRIM PUT-STRING support LONGCHAR CLOB data
  types.

• Log file includes filename file ID
• Debugger allows a watchpoint optional
  condition.
• Attach Attachable Debugger to process regardless
  of mode or client.

41
OE10 Deployment
OpenEdge App Server
WebClient

• A new tool for modifying locator definitions in
  the prowcapc file supports customizing
  information for WebClient deployment sites.
• Other features discussed in this presentation
  also benefit WebClient applications.

• AIA supports session-free applications running
  over HTTP to better support a common Internet
  application design that is not connection-oriented
  .
• AIA has eliminated the use of native libraries so
  that AIA and WSA use the same JSE, simplifying
  deployment.

42
OE10 Deployment
OpenEdge Data Servers
OpenEdge RDBMS

• Higher concurrency index lock protocol
• I/O improvements to lower checkpoint cost
• Faster temp-tables
• Index rebuild
• Improved performance
• Administrative utilities performance through
  efficient of the ASA II introduced in OE 10.0A

• OEDS for ODBC utilities better support accessing
  schema information in DB2/400 libraries.
• OEDS for MS SQL Srvr uses connection pooling.
• OEDS for MS SQL Server applications support
  firehose fast-forward cursors.

43
More Platforms!
OpenEdge 10.0B now supports these platforms

• AIX 5L v5.2 for Power 64-bit kernel
• SCO UnixWare
• HP-UX Itanium.

44
Platforms
32-Bit Platforms
45
Platforms
64-Bit Platforms
46
Sneak Peak at 10.1SSSHHHH.
10.1
47
What You Ask Us For
The 1 Request from Partners Worldwide
Make It Easier To Enhance My Application.
- Everyone
48
OE10 Family

• OpenEdge Release 10 Product Family is being
  delivered in a three phase approach
• Foundation (Make it Possible)
• Fundamentals (Make it Easy)
• Fulfillment (Make it Automatic)
• The major initiative for the 10.1A release is to
  improve productivity by making it easy for
  OpenEdge Customers to use the OpenEdge Product.
  The themes for 10.1A focus on two major
  initiatives
• Simplicity
• productivity

49
OpenEdge 10.0 Emphasis on Capability
50
OpenEdge 10.1x Emphasis on Productivity
51
Core Services for Business Applications

• Rich functionality
• Highly extensible
• Auditing, Context Management, Security

52
Language Productivity 4GL Object-Oriented
Extensions
ltltclassgtgt Business Entity FetchWhere(Context,
DataSet) SaveChanges(DataSet)
ltltinterfacegtgt Customer GetName() char
Inherits
Implements
Partner Discount (Rate, Amount)Decimal
GetName()char
ltltclassgtgt Partner Discount (Rate,Amt)Decimal
GetName()char

• O-O concepts (inheritance and overriding) promote
  modularity and reuse
• Strong typing improves productivity and
  maintainability
• Simple extensions to 4GL syntax for easy addition
  to existing application

53
The New OpenEdge IDE
Simplifies Design, Development, Testing, and
Deployment

• Architecture-centric design center
• Puts all tools within easy reach
• Automates many of the common tasks

54
Questions?
Thank You!
55
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
56
(No Transcript)