CERN European Laboratory for Particle Physics Administrative Information
CERN – European Laboratory for Particle Physics Administrative Information Services Implementing Oracle Workflow Derek Mathieson CERN - Switzerland
Outline l CERN l Oracle Workflow l What Changes we Made l Oracle 8 i l Going Production l Conclusion CERN AIS
CERN World’s Leading Particle Physics Research Laboratory l 3000 Staff l 6500 visiting scientists l 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 l Completely developed ‘in-house’ – Originally in C and C++ l Classical l Process CERN AIS Client / Server Architecture 150, 000 documents per year
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 CERN AIS
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 Swissis France awaiting your approval. Forwardis awaiting Administration To authorise the document click on this URL: Cancel Monitoring Query https: //edh. cern. ch/Document/604398 https: //edh. cern. ch/Document/&DOCNUM 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 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 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 Oracle Workflow Enabled Application Compatibility Layer Oracle server
EDH Worklist CERN AIS
Changes to Oracle Workflow Directory Services Users Roles Worklist CGI Worklist Adapter Sign Servlets Document Objects Signature Adapter PL/SQL - Java Interface User Interface Servlets Existing EDH CERN System AIS Notification Services Engine Send Execution Respond Definition Forward Administration Cancel Monitoring Query Oracle Workflow Enabled Application Compatibility Layer Oracle server
Signature Servlet CERN AIS
Changes to Oracle Workflow Directory Services Users Roles Worklist CGI Worklist Adapter Sign Servlets Document Objects Signature Adapter PL/SQL - Java Bridge User Interface Servlets Existing EDH CERN System AIS Notification Services Engine Send Execution Respond Definition Forward Administration Cancel Monitoring 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 8 i Workflow Application Java VM Java Stored Procedures CERN AIS Oracle 8 i Data Base Java VM Java Stored Procedures
Oracle 8 i ü Same Transaction ü Fast ü No Separate Process û Difficult Debugging CERN AIS
Other Changes: Parallel Branches SL-BI AS-SU Financial Approval Creator Check ü CERN AIS Safety Approval Financial Approval &
Going Production l Parallel with existing system l Then a single document type l Then full production Questions: l Is it fast enough? l Will Java be stable? We will find out this summer! CERN AIS
Conclusion : Workflow Productivity Gain Electronic Forms Paper Forms CERN AIS
Conclusion : Oracle Workflow l Flexible architecture l Good Process Designer l Limited to a PL/SQL interface ? 8 i Java CERN AIS ? g n i ugg Deb Brid ge? ?
Thank You For More Information Browse to: http: //edh. cern. ch/doc or Email: Derek. Mathieson@cern. ch CERN AIS
- Slides: 29