Home » PANDA » PandaRoot » Meetings » database interfacing, 12/01/2012, 10:00, EVO
| database interfacing, 12/01/2012, 10:00, EVO [message #12876] |
Fri, 23 December 2011 10:58  |
Johan Messchendorp
Messages: 693
Registered: April 2007
Location: University of Groningen
|
first-grade participant |
From: *KVI.nl
|
|
Dear all,
Ok, just for the xmas/new year holidays... an announcement for an upcoming meeting, which you might want to put in your agenda if you are interested to join...
what: informative discussion on a common PANDA database interface, connecting the various test experiments, analysis and database.
when: 12th of January 2012, 10:00-12:00
where: EVO
Agenda follows later...
Happy holidays!
Johan.
|
|
|
|
| Re: database interfacing, 12/01/2012, 10:00, EVO [message #12886 is a reply to message #12876] |
Tue, 10 January 2012 23:38  |
Johan Messchendorp
Messages: 693
Registered: April 2007
Location: University of Groningen
|
first-grade participant |
From: *xs4all.nl
|
|
Dear all,
Happy new year to everyone!
As announced earlier, we will have an EVO meeting upcoming Thursday at 10. The meeting will be dedicated primarily to database interfacing. Here thetentative agenda points:
1. general announcements
- new external packages
- software training school
- .....
2. open forum items and analysis problems
3. Grid status (Kilian)
4. database interfacing
- fairroot activities (Denis)
- some ideas/wishes for PANDA (Malte)
- discussion
5. AOB
If you want to present something connected to the agendapoints, please let me or Stefano know.
Greets,
Johan
[Updated on: Wed, 11 January 2012 23:15] Report message to a moderator |
|
|
|
|
|
| coordinates... [message #12891 is a reply to message #12876] |
Wed, 11 January 2012 23:16 |
Johan Messchendorp
Messages: 693
Registered: April 2007
Location: University of Groningen
|
first-grade participant |
From: *xs4all.nl
|
|
Title: pandaroot
Description: pandaroot
Community: Panda
Meeting Access Information:
- Meeting URL
http://evo.caltech.edu/evoNext/koala.jnlp?meeting=M2MvMB2M2lDIDD999nDM92
- Phone Bridge
ID: 456 9372
Central European Time (+0100)
Start 2012-01-12 09:30
End 2012-01-12 13:00
Japan Standard Time (+0900)
Start 2012-01-12 17:30
End 2012-01-12 21:00
Eastern Standard Time (-0500)
Start 2012-01-12 03:30
End 2012-01-12 07:00
Pacific Standard Time (-0800)
Start 2012-01-12 00:30
End 2012-01-12 04:00
EVO Phone Bridge Telephone Numbers:
---------------
- USA (Caltech, Pasadena, CA)
+1 626 395 2112
- Switzerland (CERN, Geneva)
+41 22 76 71400
- Slovakia (UPJS, Kosice)
+421 55 234 2420
- Italy (INFN, several cities)
http://server10.infn.it/video/index.php?page=telephone_numbers
Enter '4000' to access the EVO bridge
- Germany (DESY, Hamburg)
+49 40 8998 1340
- USA (BNL, Upton, NY)
+1 631 344 6100
- United Kingdom (University of Manchester)
+44 161 306 6802
- Australia (ARCS)
+61
Adelaide 08 8463 1011
Brisbane 07 3139 0705
Canberra 02 6112 8742
Hobart 03 623 70281
Melbourne 03 8685 8362
Perth 08 6461 6718
Sydney 02 8212 4591
- Netherlands (Nikhef, Amsterdam)
+31 20 7165293
Dial '2' at the prompt
- Canada (TRIUMF, Vancouver)
+1 604 222 7700
- Czech Republic (CESNET, Prague)
+420 95 007 2386
- France (RAP, Paris)
+33 144 27 81 50
- Skype (tm) (World-wide)
evo.phone
See: http://evo.caltech.edu/evoGate/Documentation/extclient/skype/skype.html
---------------
|
|
|
|
|
|
| Summary database interface discussion [message #12902 is a reply to message #12876] |
Sun, 15 January 2012 16:55 |
Johan Messchendorp
Messages: 693
Registered: April 2007
Location: University of Groningen
|
first-grade participant |
From: *xs4all.nl
|
|
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 http://forum.gsi.de/index.php?t=tree&goto=12892&rid=981&S=8c 9512d91ec2f07bf29cb9476c59f005#msg_12892
- 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.
- 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.
- 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.
Greets,
Johan.
[Updated on: Sun, 15 January 2012 17:05] Report message to a moderator |
|
|
|
Goto Forum:
Current Time: Sat Nov 30 01:50:06 CET 2024
Total time taken to generate the page: 0.00758 seconds
|
GSI Forum
Search
Help
Members
Login
Home
