Transcript Efficient DSO (Days Sales Outstanding) Computing with

Grid programming with components:
an advanced COMPonent platform
for an effective invisible grid
Efficient DSO (Days Sales
Outstanding) Computing with Parallel
PL/SQL Databases
ATOS ORIGIN
21-oct-2008 – Sophia Antipolis, France
Fabio Tumiatti - [email protected]
Irati R. Saez de Urabain - [email protected]
© 2006 GridCOMP Grids Programming with components. An advanced component platform for an effective invisible grid
is a Specific Targeted Research Project supported by the IST programme of the European Commission (DG Information Society and Media, project n°034442)
Index
 Use Case summary
 UC Architecture
 Performance test
 Conclusions
Grid programming with components: an advanced COMPonent platform for an effective invisible grid
2
Use Case summary (1/3)
 Computing of DSO value
 The
DSO (Days Sales Outstanding) is the mean
time that clients delay to pay an invoice to Atos
 Information
is needed by several
internal departments as much
updated as possible
 Process
lasts about 4 hours to
complete (over 6.000 clients)
Grid programming with components: an advanced COMPonent platform for an effective invisible grid
3
Use Case summary (2/3)
 The DSO application is based on a
client/server application
A
Graphical User Interface

to input data or parameters
needed for the computation
 Some

to access the data stored in the
database and process them to
compute the results
 The

PL/SQL processes
database
to store the data
Grid programming with components: an advanced COMPonent platform for an effective invisible grid
4
Use Case summary (3/3)
 The PL/SQL code
 Heavy
processes written in PL/SQL (Oracle
Stored Procedures)
 Must avoid (or minimize at maximum) the
rewriting of PL/SQL procedures to avoid retesting the critical business code
 Split the PL/SQL code into independent subprograms

Read / Write / Compute
 Organize
the sub-programs between the master
and node databases
Grid programming with components: an advanced COMPonent platform for an effective invisible grid
5
Use Case Architecture (1/2)
User
Interface
1) Read
PL/SQL
DataBase
Engine
PL/SQL
Main
Program
3) Write
Data
Base
DBBB
2) Compute
Worker
1
DB
…
Worker
n
DB
Grid programming with components: an advanced COMPonent platform for an effective invisible grid
6
Use Case Architecture (2/2)
 Master database
 Oracle Standard Edition or Enterprise Edition
 store all data and the packages (functions)
 Node database
 Oracle Database 10g Express Edition (XE)


Free of charge
Limitations:





Memory:
only 1GB of RAM
CPU:
only use one CPU
Database: only a single XE can run
on any given computer
Disk space: a 4GB limit
store part of the PL/SQL code
and some data
Grid programming with components: an advanced COMPonent platform for an effective invisible grid
7
DB Structure
Analysis of
PL/SQL code distribution and DB Structure
to use in a Grid solution
Grid programming with components: an advanced COMPonent platform for an effective invisible grid
8
DB Structure (1/2)
Part of the code in the nodes
Grid programming with components: an advanced COMPonent platform for an effective invisible grid
9
DB Structure (2/2)
All code and main tables in the nodes
Grid programming with components: an advanced COMPonent platform for an effective invisible grid
10
GCM Components Architecture
Grid programming with components: an advanced COMPonent platform for an effective invisible grid
11
Graphical User Interface
Grid programming with components: an advanced COMPonent platform for an effective invisible grid
12
Performance Test - GRID5000
# Nodes / Time
1:20:00 AM
1:10:00 AM
hours
1:00:00 AM
12:50:00 AM
12:40:00 AM
12:30:00 AM
12:20:00 AM
12:10:00 AM
12:00:00 AM
0
5
10
15
20
25
nodes
30
35
Grid programming with components: an advanced COMPonent platform for an effective invisible grid
40
45
50
13
Conclusions
 Analyze the code:
 Right
distribution of the PL/SQL code between
the master DB and the nodes to use with GRID
 Need to avoid:
 Rewriting
the PL/SQL code
 Benefits:
 Reduce
execution time
 Maintain/reduce infrastructure costs
 Information updated more frequently
Grid programming with components: an advanced COMPonent platform for an effective invisible grid
14
Thanks for your attention!
Any question?
Grid programming with components: an advanced COMPonent platform for an effective invisible grid
15