1 / 29

Implementing Oracle Workflow

Implementing Oracle Workflow. Derek Mathieson CERN - Switzerland. Outline. CERN Oracle Workflow What Changes we Made Oracle 8 i Going Production Conclusion. CERN. World’s Leading Particle Physics Research Laboratory 3000 Staff 6500 visiting scientists

Download Presentation

Implementing Oracle Workflow

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Implementing Oracle Workflow Derek Mathieson CERN - Switzerland

  2. Outline • CERN • Oracle Workflow • What Changes we Made • Oracle 8i • Going Production • Conclusion

  3. CERN World’s Leading Particle Physics Research Laboratory • 3000 Staff • 6500 visiting scientists • Annual budget of 1000 million CHF( 630 million)

  4. Why does CERN need Workflow?

  5. Nationality distribution of CERN Users on 1/1/98

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

  7. Web Architecture 1996

  8. Existing System User Interface Servlet Document Object Common Business Objects Java VM Oracle DB Java Application

  9. EDH Purchase Order (1998)

  10. Documents transferred per year

  11. Need for Change Existing Workflow Engine • No graphical interface • Difficult to maintain A New Workflow Engine • Flexible • Graphical • Reliable

  12. Workflow Integration Corporate Database Receiver Systems HumanResources Document Database OrganicStructure OfficeLocations Absences Purchasing Supervisors Payroll Workflow Engine OrderAmount TechnicalContact

  13. Oracle Workflow Dear &USERNAME, The document titled: &TITLE For &AMOUNT Swiss France is awaiting your approval. To authorise the document click on this URL: https://edh.cern.ch/Document/&DOCNUM Dear Derek Mathieson, The document titled: Replacement Hard Disk For 249 Swiss France is awaiting your approval. To authorise the document click on this URL: https://edh.cern.ch/Document/604398 Send Execution Respond Definition Forward Administration Cancel Monitoring Query Query Directory Services Users Roles NotificationServices Engine Oracle WorkflowEnabled Application Oracle server Source: Oracle Workflow Presentation (Oracle Open World 1998)

  14. Oracle Workflow Workflow Builder Send Execution Respond Workflow Loader Definition Forward Administration Cancel Monitoring Query Query Workflow Definition Files Workflow Development Client Directory Services Users Roles NotificationServices Engine Oracle WorkflowEnabled Application Oracle server Source: Oracle Workflow Presentation (Oracle Open World 1998)

  15. Oracle Workflow Notification Worklist Notification Worklist Web Notification Worklist Web Notification Worklist Workflow Builder Oracle Application Server Oracle Application Server Send Execution Web Process Monitor Web Process Monitor Respond Workflow Loader Definition Forward Administration Cancel Monitoring Web Analysis Tools Web Analysis Tools Query Query Workflow Definition Files Mail Applications Notification Mailer Mail Applications Workflow Development Client End-User Client Application Server End-User Client Application Server Directory Services Users Roles NotificationServices Engine Oracle WorkflowEnabled Application Oracle server Source: Oracle Workflow Presentation (Oracle Open World 1998)

  16. Changes to Oracle Workflow Worklist CGI WorklistAdapter SignServlets SignatureAdapter Execution Definition Administration DocumentObjects Monitoring PL/SQL - JavaInterface Query User InterfaceServlets Existing EDHSystem CompatibilityLayer Directory Services Users Roles NotificationServices Engine Send Respond Forward Cancel Query Oracle WorkflowEnabled Application Oracle server

  17. EDH Worklist

  18. Changes to Oracle Workflow Worklist CGI WorklistAdapter SignServlets SignatureAdapter Execution Definition Administration DocumentObjects Monitoring PL/SQL - JavaInterface Query User InterfaceServlets Existing EDHSystem CompatibilityLayer Directory Services Users Roles NotificationServices Engine Send Respond Forward Cancel Query Oracle WorkflowEnabled Application Oracle server

  19. Signature Servlet

  20. Changes to Oracle Workflow Worklist CGI WorklistAdapter SignServlets SignatureAdapter Execution Definition Administration DocumentObjects Monitoring PL/SQL - JavaBridge Query User InterfaceServlets Existing EDHSystem CompatibilityLayer Directory Services Users Roles NotificationServices Engine Send Respond Forward Cancel Query Oracle WorkflowEnabled Application Oracle server

  21. Java Bridge DBMS Pipe Java VM Java Document Objects Java Document Objects PL/SQLWorkflow Application OracleData Base

  22. Oracle 8i Java VM Java VM Java Stored Procedures Java Stored Procedures Workflow Application Oracle 8iData Base

  23. Oracle 8i • Same Transaction • Fast • No Separate Process • Difficult Debugging

  24. Other Changes: Parallel Branches SL-BI AS-SU AS-SU Purchase Order Financial Approval Safety Approval Creator Check Financial Approval ü &

  25. 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!

  26. Conclusion : Workflow Productivity Gain Electronic Forms Paper Forms

  27. Conclusion : Oracle Workflow ? 8i Debugging? ? Java Bridge? • Flexible architecture • Good Process Designer • Limited to a PL/SQL interface

  28. Thank You For More Information Browse to:http://edh.cern.ch/doc or Email:Derek.Mathieson@cern.ch

More Related