Transcript Implementing Oracle Workflow - AIS

CERN – European Laboratory for Particle Physics
Administrative Information Services
Implementing Oracle Workflow
Derek Mathieson
CERN - Switzerland
Outline
CERN
 Oracle Workflow
 What Changes we Made
 Oracle 8i
 Going Production
 Conclusion

CERN
AIS
CERN
World’s Leading Particle Physics
Research Laboratory
3000 Staff
 6500 visiting scientists
 Annual budget of 1000 million CHF
( 630 million)

CERN
AIS
Why does CERN
need Workflow?
Nationality distribution of CERN Users on 1/1/98
CERN
AIS
Existing System
EDH
Electronic Document Handling

Completely developed ‘in-house’
– Originally in C and C++

Classical Client / Server Architecture

Process 150,000 documents per year
CERN
AIS
Web Architecture 1996
CERN
AIS
Existing System
Java VM
Oracle DB
Java Application
User Interface
Servlet
Document Object
Common
Business
Objects
CERN
AIS
EDH Purchase Order (1998)
CERN
AIS
Documents transferred per year
300000
250000
200000
150000
Documents
Authorisations
100000
50000
0
92
CERN
AIS
93
94
95
96
97
98
Need for Change
Existing Workflow Engine
– No graphical interface
– Difficult to maintain
A New Workflow Engine
– Flexible
– Graphical
– Reliable
CERN
AIS
Workflow Integration
Corporate
Database
Purchasing
Absences
Supervisors
Human
Resources
Order
Technical
Amount
Contact
CERN
AIS
Organic
Office
Structure
Locations
Workflow
Engine
Document
Database
Receiver
Systems
Payroll
Oracle Workflow
Directory Services
Dear Derek
&USERNAME,
Mathieson,
The document titled:
Replacement
&TITLE
Hard Disk
Users
Roles
Notification
Services
Engine
Send
Execution
Respond
Definition
For 249
&AMOUNT
Swiss France
SwissisFrance
awaiting
your approval.
your approval.
Forwardis awaiting
Administration
To authorise the document click on this URL:
Cancel
Monitoring
https://edh.cern.ch/Document/604398
https://edh.cern.ch/Document/&DOCNUM
Query
Query
Oracle Workflow
Enabled Application
CERN
Oracle server
AIS
Source: Oracle Workflow Presentation (Oracle Open World 1998)
Oracle Workflow
Directory Services
Users
Roles
Notification
Services
Engine
Send
Execution
Respond
Definition
Forward
Administration
Cancel
Monitoring
Query
Query
Workflow
Builder
Workflow
Loader
Workflow
Definition
Files
Oracle Workflow
Enabled Application
CERN
AIS
Oracle server
Workflow
Development
Client
Source: Oracle Workflow Presentation (Oracle Open World 1998)
Oracle Workflow
Directory Services
Notification
Worklist
Users
Roles
Web
Notification
Worklist
Notification
Services
Engine
Web
Process
Monitor
Oracle
Application
Server
Web
Analysis
Tools
Mail
Applications
End-User
CERN
Client
AIS
Send
Execution
Respond
Definition
Forward
Administration
Cancel
Monitoring
Query
Query
Workflow
Builder
Workflow
Loader
Workflow
Definition
Files
Notification
Mailer
Application
Server
Oracle Workflow
Enabled Application
Oracle server
Workflow
Development
Client
Source: Oracle Workflow Presentation (Oracle Open World 1998)
Changes to Oracle Workflow
Directory Services
Users
Roles
Notification
Services
Engine
Worklist CGI
Worklist
Adapter
Sign
Servlets
Document
Objects
Signature
Adapter
PL/SQL - Java
Interface
User Interface
Servlets
Existing EDH
CERN
System
AIS
Send
Execution
Respond
Definition
Forward
Administration
Cancel
Monitoring
Query
Query
Oracle Workflow
Enabled Application
Compatibility
Layer
Oracle server
EDH Worklist
CERN
AIS
Changes to Oracle Workflow
Directory Services
Users
Roles
Notification
Services
Engine
Worklist CGI
Worklist
Adapter
Sign
Servlets
Document
Objects
Signature
Adapter
PL/SQL - Java
Interface
User Interface
Servlets
Existing EDH
CERN
System
AIS
Send
Execution
Respond
Definition
Forward
Administration
Cancel
Monitoring
Query
Query
Oracle Workflow
Enabled Application
Compatibility
Layer
Oracle server
Signature Servlet
CERN
AIS
Changes to Oracle Workflow
Directory Services
Users
Roles
Notification
Services
Engine
Worklist CGI
Worklist
Adapter
Sign
Servlets
Document
Objects
Signature
Adapter
PL/SQL - Java
Bridge
User Interface
Servlets
Existing EDH
CERN
System
AIS
Send
Execution
Respond
Definition
Forward
Administration
Cancel
Monitoring
Query
Query
Oracle Workflow
Enabled Application
Compatibility
Layer
Oracle server
Java Bridge
DBMS Pipe
PL/SQL
Workflow
Application
Java Document
Objects
Oracle
Data Base
Java VM
CERN
AIS
Oracle 8i
Workflow
Application
Java VM
Java Stored
Procedures
CERN
AIS
Oracle 8i
Data Base
Java VM
Java Stored
Procedures
Oracle 8i
Same Transaction
Fast
No Separate Process
 Difficult Debugging
CERN
AIS
Other Changes: Parallel Branches
SL-BI
AS-SU
AS-SU
Financial Approval
Creator Check

CERN
AIS
Safety Approval
Financial Approval
&
Going Production
Parallel with existing system
 Then a single document type
 Then full production

Questions:
 Is it fast enough?
 Will Java be stable?
We will find out this summer!
CERN
AIS
Conclusion : Workflow
Productivity Gain
140000
Documents
120000
Electronic Forms
100000
80000
Paper Forms
60000
40000
20000
0
0
CERN
AIS
2
4
6
8 10 12 14 16 18 20 22 24 26 28 30
Days
Conclusion : Oracle Workflow
Flexible architecture
 Good Process Designer


Limited to a PL/SQL interface
8i
CERN
AIS
Thank You
For More Information
Browse to:
http://edh.cern.ch/doc
or Email:
[email protected]
CERN
AIS