SOA for Database Professionals with Lucas Jellema 12th April 2010, Baden-Dättwil April 11, 2010

SOA is a hot topic and Oracle is pushing the BPEL Process Manager and in its wake the Enterprise Service Bus so forcefully that probably something is going on. However, many Oracle Database professionals are not really clear about what it is or what it means to them. Is BPEL a world apart from plain old PL/SQL programming? Is SOA irrelevant to database administrators, database designers and SQL programmers? Or should they care?

This seminar explains in a high level overview what the key SOA concepts are. It introduces WebServices and the key XML mechanisms, such as XSD, SOAP, WSDL and a touch of XPath and XSLT. It describes the respective roles of BPEL PM and the Enterprise Service Bus. It will then demonstrate how from PL/SQL programs - and even from SQL queries - SOA Services offered in BPEL or ESB can (and sometime meaningfully should) be leveraged, for example to perform operations across databases or even heterogeneous data stores.

We walk through a case of defining and publishing a service in a hospital that makes patient data available from the database to the SOA environment. All steps from defining the Service to actually publishing it and calling it from a BPEL process are discussed and demonstrated.

The seminar will spend quite some time on the ways the Oracle SOA Suite - both ESB and BPEL PM - can work with the Oracle Database through the Database Adapter. The session discusses some of the ways in which the database can contribute to the SOA. It also explains what can be gained from the SOA infrastructure: how services can be leveraged from the database. Even if there is not yet a SOA Suite implementation - some of the key SOA concepts can be applied for ‘normal’ database design and development, and we will discuss those in detail.
The seminar will have a large number of demonstrations - SQL and PL/SQL in SQL*Plus as well as JDeveloper and the runtime BPEL and ESB consoles.

Topics

* WebService fundamentals (some XML, XSD, WSDL and SOAP foundation)
* Accessing the Oracle Database from the SOA world
* SOA concepts applied to the world of Database Application development
* Implementing Services in the Database (inlcuding Native 11g WebServices)
* Leverage the world: Calling services from within the database
* Benefit from Java/JEE facilities
- Integrate with the world of SOA
- Access internet resources and services
- Chatting from the database

Official Website: http://cli.gs/dbtLn1