1 / 24

Oracle Developer Forum

PIE project. Presentation. Oracle Developer Forum. How. Demo. PIE Team. Analysis tool. AS-DB. Experience. Q & A. Introduction. Administrative Information Services. Financial applications Stock and assets management Human resources Electronic Document Handling

shika
Download Presentation

Oracle Developer Forum

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. PIE project Presentation Oracle Developer Forum How Demo PIE Team Analysis tool AS-DB Experience Q & A Olivier Francis Martin, Isabel Fernandez.Gonzalez

  2. Introduction

  3. Administrative Information Services • Financial applications • Stock and assets management • Human resources • Electronic Document Handling • Data warehousing tools... Presentation How Demo Analysis tool Experience Q & A Olivier Francis Martin, Isabel Fernandez.Gonzalez

  4. CERN Users management : context • Several databases containing person related information: => Multiple data entry • Bad follow-up of CERN users • Different registration procedures • No experiment view Presentation How Demo Analysis tool Experience Q & A Olivier Francis Martin, Isabel Fernandez.Gonzalez

  5. PIE PROJECT • Stands for : Person Institutes & Experiments • Single source database • Uniform procedures and workflow • Web based data entry Interface • Web based analysis tools • Web publishing (physic dictionary) Presentation How Demo Analysis tool Experience Q & A Olivier Francis Martin, Isabel Fernandez.Gonzalez

  6. Data entry interface : How

  7. Technical choices • Component based model wrapping HR complex structure • Client/server architecture (2-tiers) • Client:Java Applets • ORACLE* JDBC thin driver to interface with ORACLE*HR • Server: PL/SQL packages Presentation How Demo Analysis tool Experience Q & A Olivier Francis Martin, Isabel Fernandez.Gonzalez

  8. Layered approach Presentation Screen layout Events How Client Events and beans Processor Beans Demo JDBC Layer (Java BusinessObject) Analysis tool High level API’s (Business object oriented) Experience Low level API’s (Table oriented) Server Q & A Database (Oracle*HR) Olivier Francis Martin, Isabel Fernandez.Gonzalez

  9. Layered approach :Low level APIs • Encapsulate HR tables • API’s per HR data table: • create • update • remove • query • Basic verifications Presentation How Demo Analysis tool Experience Q & A Olivier Francis Martin, Isabel Fernandez.Gonzalez

  10. Layered approach :High level APIs • Procedural business object • API’s per HR business object: • create • update • remove • query • fetch • Verifications: • list of values • enforces business rules • enforces security rights Presentation How Demo Analysis tool Experience Q & A Olivier Francis Martin, Isabel Fernandez.Gonzalez

  11. Layered approach :JDBC layer • Object oriented view • Java object methods: • query • constructor • modifier • destructor • field methods • Java item methods • set,get, validate Presentation How Demo Analysis tool Experience Q & A Olivier Francis Martin, Isabel Fernandez.Gonzalez

  12. Layered approach :the processor Presentation Screen layout How Event Monitor Demo Grid Monitor Analysis tool Generid grid Experience Q & A JDBC layer Olivier Francis Martin, Isabel Fernandez.Gonzalez

  13. Layered approach :Screen layout • Graphical objects definition • Link to underlying grids • Refreshed by the GM • Listened by the EM Presentation How Demo Analysis tool Experience Q & A Olivier Francis Martin, Isabel Fernandez.Gonzalez

  14. From template Events Generic (write once) Design tool (Home made) Beans Generated By hand... Development tools Presentation How Demo Analysis tool Experience Q & A Olivier Francis Martin, Isabel Fernandez.Gonzalez

  15. Demo

  16. Analysis tool

  17. Application Server Multi-dimensional Database Client Browser https JDBC (Oracle Thin) HTML +JavaScript JAVA Servlets RDBMS ORACLE Architecture Presentation How Demo Analysis tool Experience Q & A Olivier Francis Martin, Isabel Fernandez.Gonzalez

  18. Outputs : in formated text files, HTML and EXCEL spreadsheets Multi-dimensional analysis (“Pivot tables”) Storage of personal queries/report Reusable components : SQL queries and layout definition isolated from the code Charts (NetCharts from Visual Mining Inc.) Features Presentation How Demo Analysis tool Experience Q & A Olivier Francis Martin, Isabel Fernandez.Gonzalez

  19. Our experience

  20. Java in the client • Language Simple and intuitive (versus C++) • Portability : Not yet 100%. • Some basic problems on macs. • Performances : acceptable but slower than more traditional architectures. • Better with MSIE JVM • Stability : average. • Memory leaks with Netscape 4.0 • Loading time • Use of bean techniques highly reduces size of code • Archive file reduce network trafic Presentation How Demo Analysis tool Experience Q & A Olivier Francis Martin, Isabel Fernandez.Gonzalez

  21. Comparison of WWW technologies Servlets Applets Designer Presentation Client size Portability How Stability Interactivity Demo Extensibility Devpt. tools Analysis tool Devpt. cost O Experience Performance Robust, form-based applications Very interactive & data intensive applications RAD, new applications Recommended use Q & A Olivier Francis Martin, Isabel Fernandez.Gonzalez

  22. Greetings • The following persons have been working for the PIE project : • Francois Briard • Jose Galvez Altamirano • Isabel Fernandez Gonzalez • Reinoud Martens • Olivier Francis Martin • Clive Pauley • Jean-Francois Perrin • Yann Rioualen • Fabien Roy • Jesus Roman Ruiz del Moral • Anna Suwalska Olivier Francis Martin, Isabel Fernandez.Gonzalez

  23. Questions & Answers

  24. Generic grid Screen Layout Event Monitor Grid Monitor JAVA Business objects Olivier Francis Martin, Isabel Fernandez.Gonzalez

More Related