GSI Forum
GSI Helmholtzzentrum für Schwerionenforschung

Home » PANDA » PandaRoot » Meetings » database interfacing, 12/01/2012, 10:00, EVO
Summary database interface discussion [message #12902 is a reply to message #12876] Sun, 15 January 2012 16:55 Go to previous message
Johan Messchendorp is currently offline  Johan Messchendorp
Messages: 693
Registered: April 2007
Location: University of Groningen
first-grade participant

From: *
Dear all,

Please find below a few points that would summarize the database interface discussion and presentations from our last meeting. The slides of the presentations can be found at 9512d91ec2f07bf29cb9476c59f005#msg_12892

  1. Fairroot Database Interface (Denis Bertini)
    • The GSI-IT (Denis Bertini) together with KVI (Mohammad Babai) are presently working on setting up a database interconnection integrated within the fairroot framework, which is the basis for pandaroot. It adds on to the existing runtime database interface.
    • The work is embedded in an EU project and focusses on various experiments such as R3B and Panda.
    • Their interface exploits the TSQLserver of ROOT which would allow to communicate with various database implementations such as MySQL, Oracle, PostGre, etc.
    • Key features are: 1) multiple connections; 2) version management; 3) IO using generic containers.
    • The work is still in progress. Updates are regularly submitted to svn and people are welcomed to start using it for debugging etc.
  2. LibEnvDB: independent library developed at Bochum (Malte Albrecht)
    • The Bochum group (Malte Albrecht, Florian Feldbauer, Matthias Steinke) has started at the end of last year to implement a easy-to-use database interface to access archived environmental data.
    • Their focus was to provide a light-weighted interface for the ongoing beam test experiment for the EMC endcap with minimum dependencies.
    • The work focusses on the interface to the user part and less on the actual database implementation.
    • The software is provided as an external library which can be used using wrapper or adapter within pandaroot.
  3. The outcome of the discussion
    • Both activities were very much appreciated by those involved in the discussion.
    • While the fairroot database interface is still in a development phase for SQL-related parts, the need for a light-weighted library for the short-term Panda activities is extremely important and essential to support the presently ongoing small-scale prototype experiments.
    • On the long term, the usage of a database interface within fairroot is considered as the standard to aim for.
    • The actual database choice (oracle, mysql?) is still not clear, however, we are convinced that the TSQLserver, continuously maintained by ROOT, will be able to do that job for Panda (and other FAIR experiments).
    • Eventually, we should try to get all the features, we like to see, embedded in fairroot framework. A migration of the work done in Bochum is, therefore, strongly encouraged.



[Updated on: Sun, 15 January 2012 17:05]

Report message to a moderator

Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: DPG meeting, deadline abstracts 15th of December
Next Topic: Next pandaroot meeting, Monday 23th of Jan. @ 10:00
Goto Forum:

Current Time: Mon Apr 22 07:46:32 CEST 2024

Total time taken to generate the page: 0.00850 seconds