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: Tue Nov 04 10:53:15 CET 2025 
 Total time taken to generate the page: 0.00823 seconds 
 |