Olivier Francis Martin,

1
PIE project
Presentation
Oracle Developer Forum
How
Demo
PIE Team
Analysis tool
AS-DB
Experience
Q A
2
Introduction
3
Administrative Information Services
Presentation

• Financial applications
• Stock and assets management
• Human resources
• Electronic Document Handling
• Data warehousing tools...

How
Demo
Analysis tool
Experience
Q A
4
CERN Users management context
Presentation

• Several databases containing person related
  information
• gt Multiple data entry
• Bad follow-up of CERN users
• Different registration procedures
• No experiment view

How
Demo
Analysis tool
Experience
Q A
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
6
Data entry interface How
7
Technical choices
Presentation

• Component based model wrapping HR complex
  structure
• Client/server architecture (2-tiers)
• ClientJava Applets
• ORACLE JDBC thin driver to interface with
  ORACLEHR
• Server PL/SQL packages

How
Demo
Analysis tool
Experience
Q A
8
Layered approach
Screen layout
Presentation
Events
How
Client
Events and beans Processor
Beans
Demo
JDBC Layer (Java Business Object)
Analysis tool
High level APIs (Business object oriented)
Experience
Low level APIs (Table oriented)
Server
Q A
Database (OracleHR)
9
Layered approach Low level APIs
Presentation

• Encapsulate HR tables
• APIs per HR data table
• create
• update
• remove
• query
• Basic verifications

How
Demo
Analysis tool
Experience
Q A
10
Layered approach High level APIs
Presentation

• Procedural business object
• APIs per HR business object
• create
• update
• remove
• query
• fetch
• Verifications
• list of values
• enforces business rules
• enforces security rights

How
Demo
Analysis tool
Experience
Q A
11
Layered approach JDBC layer
Presentation

• Object oriented view
• Java object methods
• query
• constructor
• modifier
• destructor
• field methods
• Java item methods
• set,get, validate

How
Demo
Analysis tool
Experience
Q A
12
Layered approach the processor
Presentation
Screen layout
How
Event Monitor
Demo
Grid Monitor
Analysis tool
Generid grid
Experience
Q A
JDBC layer
13
Layered approach Screen layout
Presentation

• Graphical objects definition
• Link to underlying grids
• Refreshed by the GM
• Listened by the EM

How
Demo
Analysis tool
Experience
Q A
14
Development tools
Presentation
How
Demo
Analysis tool
Experience
Q A
15
Demo
16
Analysis tool
17
Architecture
Presentation
How
Demo
Analysis tool
Experience
Q A
18
Features

• 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.)

Presentation
How
Demo
Analysis tool
Experience
Q A
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
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
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

23
Questions Answers
24
Screen Layout
Grid Monitor
Event Monitor
JAVA Business objects