Home | About

Data Management Common Components

4 Common Components have currently been identified, along with the related common technical requirements. They cover a number of areas within data management and aim to extend the existing middleware to better support the needs of business. They are:

OGSA-DAI Trigger Mechanism

A component which allows an OGSA-DAI workflow to be executed when a row is inserted/updated/deleted from an SQL database. The solution will be built using OGSA-DAI 3.0, SQL Triggers, User Defined Database Functions and Web Services. Some aspects of the solution are database specific and the initial component will work with MySQL. It will be possible to extend the solution to further database vendors’ products.

Data Source Publisher

Mechanism to allow publishing of data sources using OGSA-DAI. It installs OGSA-DAI and your chosen set of prerequisites. It then configures the middleware to set up an OGSA-DAI resource given the data source details, publishes the database through OGSA-DAI web services, and automates the process so that it can be repeated easily for installation on many machines.

Multi-database JDBC Driver

The goal of this component is to create a JDBC driver which appears to be a single database. It internally supports a federation of databases using OGSA-DAI and presents them as one. It is intended to make it easy to convert an application which uses one database into one which supports a number of databases while hiding the complexity of data federation from the application. The user application does not need to know that there are multiple databases at all.

SQL Views Component

This component depends upon an investigation from the NextGrid project which is currently being analyzed. It will most likely involve work to improve OGSA-DAI’s abilities to translate between data held in databases using different schemas. Some work has already been done in this area and the solution may related to OGSA-DQP.