2.1.
Architecture
Up one level
Overview
The GRIA OGSA-DAI service makes use of three resource types as shown in the diagram below.
Data Resources
The data resource is responsible for storing information about the database that is being accessed. For the default back-ends of MySQL and PostgreSQL this information is in the form of a JDBC URL, such as:
jdbc:mysql://localhost/database
Database resources can be created by either the service provider or users, depending on the access control restrictions that are in place.
Role Resources
A role resource represents the login information for a user in the database (e.g. a username and password combination). In the GRIA OGSA-DAI service different roles can be made visible to different users in order to control who can perform certain operations on the database.
Roles can be created by the service provider and users when connecting an existing database to the OGSA-DAI service. For MySQL and PostgreSQL, when creating a new database the service automatically creates three roles representing RDBMS users with different permissions on that database.
Subscription Resources
Users can open subscriptions to roles which have been made visible to them. Having a subscription allows the user to execute queries on the database.
