OGSA-DAI Tutorial

llOGSA-DAI Tutorial NGS Induction Event,Guy Warner, NeSC Training Team This OGSA-DAI tutorial has two aims: to show how access to multiple databases simultaneously is aided by the use of OGSA-DAI. to show how to use the OGSA-DAI client toolkit to access a data source and perform multiple actions on the data before retrieving the results.Accessing Multiple Databases Initially a database that is running on the host "kesselman" is accessed. This database contains a table called stafflist, a list of fictional staff and their staff identity numbers. A copy of OGSA-DAI has been installed and configured to access this database. OGSA-DAI in turn is using Apache Tomcat as the means of exposing the service on to the internet. The database is running under PostgreSQL. A second database will then be accessed at the same time as the first database. This database is running on the host "foster". The database this time has a different schema to the database on "kesselman". This database contains a table called littleblackbook, an example address book with (again somewhat) fictional entries. In fact there is also a third database, again hosted on "foster" that will be used for writing any temporary tables needed to and hence this may be viewed as scratch space. This is just to avoid the need to write tables in the main two databases. The first aim of the tutorial is to perform a comparison of both of these main two databases. The tutorial will then ...