Eoug99

Eoug99 - CERN – European Laboratory for Particle Physics...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 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 CERN AIS Existing System EDH Electronic Document Handling lectronic ocument Completely developed ‘in-house’ – Originally in C and C++ Classical 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 Common Business Objects Objects CERN AIS EDH Purchase Order (1998) CERN AIS Documents transferred per year 300000 250000 200000 150000 Documents Authorisations 100000 50000 0 CERN AIS 92 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 Users Dear Derek Mathieson, &USERNAME, The document titled: Replacement Hard Disk &TITLE Roles Notification Services Engine Send Execution Respond Definition For 249 Swiss France isFrance is awaiting Administration &AMOUNT Swiss awaiting your approval.approval. your Forward To authorise the document click on this URL: Cancel Monitoring Query 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 Query Workflow Loader Workflow Definition Files Oracle Workflow Enabled Application CERN AIS Oracle server Workflow Development Development Client Client Source: Oracle Workflow Presentation (Oracle Open World 1998) Oracle Workflow Directory Services Notification Worklist Users Web Notification Worklist Roles Notification Services Engine Send Web Analysis Tools Mail Applications End-User CERN Client AIS Respond Definition Forward Administration Monitoring Query Oracle Application Server Execution Cancel Web Process Monitor Workflow Builder Query Workflow Loader Workflow Definition Files Notification Mailer Application Server Oracle Workflow Enabled Application Oracle server Workflow Development Development Client Client Source: Oracle Workflow Presentation (Oracle Open World 1998) Changes to Oracle Workflow Directory Services Users Roles Worklist CGI Worklist Adapter Notification Services Engine Document Objects Send PL/SQL - Java Interface User Interface Servlets Existing EDH CERN System AIS Respond Definition Administration Cancel Signature Adapter Execution Forward Sign Servlets Monitoring Query 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 Notification Services Engine Document Objects Send PL/SQL - Java Interface User Interface Servlets Existing EDH CERN System AIS Respond Definition Administration Cancel Signature Adapter Execution Forward Sign Servlets Monitoring Query 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 Notification Services Engine Document Objects Send PL/SQL - Java Bridge User Interface Servlets Existing EDH CERN System AIS Respond Definition Administration Cancel Signature Adapter Execution Forward Sign Servlets Monitoring Query Query Oracle Workflow Enabled Application Compatibility Layer Oracle server Java Bridge DBMS Pipe PL/SQL Workflow Workflow Application Application Java Document Java Objects Objects Oracle Data Base Java VM CERN AIS Oracle 8i Workflow Workflow Application Application Java VM Java Stored Java Procedures Procedures CERN AIS Oracle 8i Data Base Java VM Java Stored Java Procedures 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 Ja v a CERN AIS Deb Brid ing? ugg ge ? ? Thank You For More Information Browse to: http://edh.cern.ch/doc or Email: Derek.Mathieson@cern.ch CERN AIS ...
View Full Document

Ask a homework question - tutors are online