11-14 April 2011
Radisson Blu Hotel Lietuva, Vilnius
Europe/Vilnius timezone

Managing a relational database schema using the Python API of CORAL

12 Apr 2011, 07:30
11h 30m
Radisson Blu Hotel Lietuva, Vilnius

Radisson Blu Hotel Lietuva, Vilnius

Konstitucijos pr. 20 LT - 09308 Vilnius, Lithuania
Demonstration Demonstration - Technology/Service Demonstrations

Speaker

Mr Alexander Loth (CERN)

Overview

The CORAL C++ software is widely used in the LHC Computing Grid for accessing the data stored by the LHC experiments using relational database technologies.

Impact

CORAL provides generic functionalities that do not specifically target the data models of high-energy physics experiments and could be used in any other scientific domain. In addition to its C++ API, CORAL also provides a Python API (PyCoral) which is particularly useful for fast prototyping of relational applications from an interactive shell.

Conclusions

In this demonstration, PyCoral will be used to show how CORAL allows users to create, populate and read relational tables. In particular, it will be shown how the same CORAL code can be used to store and retrieve relational data on the Grid using different backends, such as SQLite files, Oracle databases or the Frontier read-only servers and caches.

Description of the work

CORAL supports data persistency for several backends and deployment models, including local access to SQLite files and remote client access to Oracle and MySQL servers, either directly or through intermediate server/cache layers.
In this demonstration, PyCoral will be used to show how CORAL allows users to create, populate and read relational tables.

Primary authors

Presentation Materials