Download
project progress tracking application n.
Skip this Video
Loading SlideShow in 5 Seconds..
Project Progress Tracking Application PowerPoint Presentation
Download Presentation
Project Progress Tracking Application

Project Progress Tracking Application

232 Views Download Presentation
Download Presentation

Project Progress Tracking Application

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Project Progress Tracking Application CERN Oracle Desktop ForumJurgen De Jonghe / AS-IDS CERN Oracle Desktop Forum, Jurgen De Jonghe

  2. Project Progress Tracking • Easy browsing of all tasks. • Automatic request for progress reporting. • Uniform Reports available in a central location. • Management at all levels can follow up what is happening, trends... • Users kept informed pro-actively • Data is validated: PBS, Contracts… CERN Oracle Desktop Forum, Jurgen De Jonghe

  3. Interaction Two main interfaces: • E-mail:Progress Reports, Notification • Web:All functionality • Export: • Excel, Ms Project • Import: • Excel, readable formats … XML CERN Oracle Desktop Forum, Jurgen De Jonghe

  4. Some History • V1: • Oct ‘98: Request from ATLAS • Apr ‘99: Production Start • May ’99: Request from CMS • V2: • Dec ’01: Request from LHC project • Mar ’02: Contract Tracking • Oct ’02: EVM CERN Oracle Desktop Forum, Jurgen De Jonghe

  5. V1 Development Tools • Designer 2.1.2 (ER + Design Editor) • RAD • Reuse • Admin Screens (Application and Project) • End-User Screens • Large Development Teams CERN Oracle Desktop Forum, Jurgen De Jonghe

  6. V1 Screens CERN Oracle Desktop Forum, Jurgen De Jonghe

  7. V2 • Oracle 9i Release 2 DB • Oracle 9i Application Server (9.0.2) • Oracle 9i JDeveloper CERN Oracle Desktop Forum, Jurgen De Jonghe

  8. Model-View-Controller • aims: • separate design concerns (data persistence and behavior, presentation, and control) • decrease code duplication • centralize control of application facilities as security, logging, and screen flow • scales better ! CERN Oracle Desktop Forum, Jurgen De Jonghe

  9. MVC cont’d • benefits: • make the application more easily modifiable, maintainable • developers with different skill sets • new data sources are easy to add (adaptors) • new client types are easy to add CERN Oracle Desktop Forum, Jurgen De Jonghe

  10. Struts CERN Oracle Desktop Forum, Jurgen De Jonghe

  11. Model Business Components for Java (BC4J) PL/SQL . Audit. Tracking. Breakdown ViewObject Entity + Business Rules CERN Oracle Desktop Forum, Jurgen De Jonghe

  12. BC4J Strengths • Integrated in Jdeveloper • Creation from existing data model • Testing • UML • +Struts • Easy generation of web pages • Access to SQL (if you want) • Deployment options (EJB!) CERN Oracle Desktop Forum, Jurgen De Jonghe

  13. BC4J weaknesses • inheritance problems • many-to-many relationships • lack of documentation, samples • lack of repository • [taglibrary] CERN Oracle Desktop Forum, Jurgen De Jonghe

  14. Struts - BC4J integration • Generates web app based on existing Business Components • Standard actions implemented using Struts framework • Struts version of the BC4J Data Tags • No need to include event handling in each BC4J JSP • Uses a single, easy to localize .properties file for message strings CERN Oracle Desktop Forum, Jurgen De Jonghe

  15. JHeadstart • Declarative (4GL-like) building of J2EE applications: • Oracle9iAS MVC Framework • BC4J • UIX • Application Generator • driven from XML meta-data created w JDeveloper wizards • Designer Generator • from Forms/Designer to Java/J2EE • meta-data in Designer Repository transformed into XML meta-data format for Application Generator. CERN Oracle Desktop Forum, Jurgen De Jonghe

  16. XML: Description of Model • Definition of ER model in XML • generate PL/SQL packages • generate Business Components • storage parameters • indexes etc. CERN Oracle Desktop Forum, Jurgen De Jonghe

  17. XML: Pipeline • XSQL generator • XSL-Transformations • Validation (Domain, Schema..) • BC4J, Excel serializer • BC4J generator CERN Oracle Desktop Forum, Jurgen De Jonghe

  18. XML Pipeline CERN Oracle Desktop Forum, Jurgen De Jonghe

  19. XML: aisEvent System AIS applications send XML messages on important events Interested parties can listen via Xpath expressions ü Event Bus Institute Responsible(all reports for Lebedev) Project Leader (all delays > 10%) Resource Coord(all expenditures >MoU) CERN Oracle Desktop Forum, Jurgen De Jonghe