Tuesday 1 May 2007

01 May 2007 - PROJECT REPORT DOCUMENT

Empirical Study of the Dehydration Feature of Oracle BPEL Manager with open source databases.

Author:   Panos Bairaktaris


Project proposer: Dr. Peter Popov
Course title:         BSc Computer Science
Supervisor:           Dr. Peter Popov, Senior Lecturer in Computing

INTRODUCTION
In computing, BPEL (Business Process Execution Language), is a business process language, serialized in XML which defines a notation for specifying business process behaviour based on Web Services. It aims to allow existing web services to be orchestrated into composite services, focussing on business process logic.

The Oracle BPEL Process Manager is a run-time environment for BPEL processes.  It executes standard BPEL processes and provides a Dehydration capability so that the state of long-running flows is automatically maintained in a database, enabling clustering for both fail-over and scalability purposes. In order to provide this capability, an Oracle Database or an Oracle Application Server is required as a dehydration store for Oracle BPEL Manager in MS Windows operating systems.

Description of the underlying computing-related problem
This project will adhere to the fact that at this time, non-Oracle databases are not supported as Oracle BPEL Process dehydration stores. In Oracle BPEL Process Manager Installation Guide, it is stated[1] that   At this time, non-Oracle databases are not supported as Oracle BPEL Process Manager dehydration stores. This installation option is reserved for future use.”
The following table describes the databases that are officially supported from Oracle:


     Oracle Database Lite
     Oracle Database 10g
     Oracle9i Database release 9.2.0.5.0 or later
     MSSQL Server

Scope of the project
The project will explore the underlying technology of Oracle's BPEL Server by creating and deploying several BPEL processes. BPEL's dehydration feature will be activated within OracleLite environment and its mechanics will be investigated with a view to test the possibility of integration of Oracle's BPEL Process Manager with an existing open-source database.

Project problem and objectives
When all of the above have completed successfully, the project shall investigate the possibility
of integration of the Oracle's BPEL Process Manager with an existing open-source database and in particular Fyracle. The
specific database is a special version of the open source Firebird database, and is chosen as it supports Oracle PL/SQL syntax, in order to ease porting of Oracle applications
to open source4.
Finally, the project shall set the foundations of further exploration of the BPEL technology and    its integration with the open-source community.

Definition of project hypotheses/questions
The project shall give answers to the following question :

Will the dehydration feature of Oracle BPEL Process Manager work with an open-source  database?