Status of the HYDRA Oracle interface

by Ilse Koenig, GSI Feb 22, 2002

The following report gives an actual overview of the Oracle interface for all parameter containers in the analysis, which are initialized from an external source.
The goal is to have in some weeks from now a working interface for all parameters. A lot of development is still needed and then is has to be filled continuously.

Description of the table columns:

Container Class Class in the corresponding library holding the parameters

Code Status Shows, if the code of the parameter container is stable or if it will change within the next weeks. The development of an Oracle interface may have higher priority for containers, which will most probably not change.

Tables and Read Interface Shows, if already Oracle tables for the data and a read interface to the analysis exist

Write Interface Shows the kind of write interface for existing tables

Oracle Development By Person responsible for the Oracle development (server and client side applications)

Data By Person responsible for the data.
In case, this person will not also do the filling in Oracle, he or she should inform the responsible person immediatly about new production parameters.

Filling By Person responsible for the filling of the Oracle tables

Filling Status Beamtime Nov2001 Comparison of the data read from Oracle with the data in a ROOT file used for the analysis of beamtime 2001.
Some tables contain also data for former beamtimes. Many already existing tables were never continuously maintained and without a decent comparison with parameter ROOT files used for DST production, initialization from Oracle for former beamtimes will not get reliable results.

Persons with names in green have provided the data in the past and in most cases have also done the filling. These responsibilities are preliminary and may change.

Parameter containers in libBase

Container Class	Code Status	Tables and Read Interface	Write Interface	Oracle Development By	Data By	Filling By	Filling Status Beamtime Nov2001
HSpecGeomPar	stable	tables exist partially, but not yet the read interface. Needs special development for the target	maybe partly (target positions) filled via the analysis + script/GUI	Ilse Koenig	?	Ilse Koenig	-

Parameter containers in libRich

Container Class	Code Status	Tables and Read Interface	Write Interface	Oracle Development By	Data By	Filling By	Filling Status Nov01
HRichAnalysisPar	stable	exists	filled via the analysis + WebDB	Ilse Koenig	Laura Fabbietti	Laura Fabbietti	complete
HRichCalPar	stable	exists	filled via the analysis + script	T.Eberl	Thomas Eberl	Thomas Eberl	-
HRichDigitisationPar	stable	exists	filled via the analysis + WebDB	Ilse Koenig	Laura Fabbietti	Laura Fabbietti	complete
HRichGeometryPar	stable	exists	filled once via perl script	T.Eberl	Thomas Eberl	Thomas Eberl	complete
HRichMappingPar	stable	exists	filled once via perl script	T.Eberl	Thomas Eberl	Thomas Eberl	complete
HRichCorrelatorPar	needs to be updated	exists	filled via the analysis + WebDB	Ilse Koenig	Laura Fabbietti	Laura Fabbietti	complete only for real data

Parameter containers in libTof

Container Class	Code Status	Tables and Read Interface	Write Interface	Oracle Development By	Data By	Filling By	Filling Status Nov01
HTofCalPar	will change (additional ADC parameters)	exist, but need modifications	filled via the analysis + script, GUI partially exists	Ilse Koenig	Pavel Tlusty	Pavel Tlusty	-
HTofDigiPar	stable	-	-	Ilse Koenig	Dusan Zovinec	Dusan Zovinec	-
HTofGeomPar	stable	exist for ideal geometry, but needs new development for alignment	needs new development for alignment	Ilse Koenig	?	Ilse Koenig	ideal geometry only
HTofLookup	stable	exists	sql	Ilse Koenig	Pavel Tlusty	?	version not actual
HTofClusterFPar	May use interface for conditions (read, write + GUI exist)			Ilse Koenig	Dusan Zovinec	Dusan Zovinec	-

Parameter containers in libStart

Container Class	Code Status	Tables and Read Interface	Write Interface	Oracle Development By	Data By	Filling By	Filling Status Nov01
HStartCalPar	stable	exist	filled via the analysis + script	Ilse Koenig	Pavel Tlusty	Pavel Tlusty	-
HTofGeomPar	stable	exist for ideal geometry, but needs new development for alignment	needs new development for alignment	Ilse Koenig	?	Ilse Koenig	ideal geometry only
HStartLookup	stable	exists	sql	Ilse Koenig	?	?	not yet checked
HStartSelfCoPar	stable	-	-	Ilse Koenig	?	?	-

Parameter containers in libTofino

Container Class	Code Status	Tables and Read Interface	Write Interface	Oracle Development By	Data By	Filling By	Filling Status Nov01
HTofinoCalPar	?	-	-	Ilse Koenig ?	?	?	-
HTofinoGeomPar	stable	exist for ideal geometry, but needs new development for alignment	needs new development for alignment	Ilse Koenig	?	Ilse Koenig	ideal geometry only
HTofinoLookup	stable	exists	sql	Ilse Koenig	?	?	version not actual
HTofinoShowerMap	?	-	-	Ilse Koenig ?	?	?	-

Parameter containers in libShower

Container Class	Code Status	Tables and Read Interface	Write Interface	Oracle Development By	Filling Status Nov01
HShowerCalPar	stable	Test version exist	Test version exist	Tomasz Wojcik	-
HShowerDigiDetPar	?	-	-	Tomasz Wojcik	-
HShowerGeometry	?	-	-	Tomasz Wojcik	-
HShowerHist	?	-	-	Tomasz Wojcik	-
HShowerHitFPar	?	-	-	Tomasz Wojcik	-
HShowerUnpackParam	stable	Test version exist	Test version exist	Tomasz Wojcik	-

Parameter containers in libMdc

Container Class	Code Status	Tables and Read Interface	Write Interface	Oracle Development By	Data By	Filling By	Filling Status Nov01 (end of beamtime)
HMdcGeomStruct	stable	exist	sql			Joachim Stroth	complete
HMdcRawStruct	stable	exist	sql			Joachim Stroth	complete
HMdcMboReadout	stable	exist	sql			Joachim Stroth	complete
HMdcLookupGeom	stable	exist	sql			Joachim Stroth	partially wrong
HMdcCalParRaw	stable	exists	filled via the analysis + script		?	?	-
HMdcLayerGeomPar	stable	exist	sql		?	?	Layer thickness for one Dubna chamber wrong
HMdcGeomPar	stable	exist for ideal geometry, but needs new development for alignment	needs new development for alignment	Ilse Koenig	?	Ilse Koenig	ideal geometry only Problem with geometry of Dubna chambers: Layer thickness slightly different from cell thickness in HMdcLayerGeomPar
HMdcDigitPar	will change (most data elements are not used anymore in the digitizer)	exist	filled via the analysis + script	?	?	?	not complete
HMdcCal2Par	will change	-	-	?	?	?	-
HMdcCal2ParSim	?	-	-	?	?	?	-
HMdcCellEff	stable	-	-	?	?	?	-
HMdcTimeCut	stable	-	-	?	?	?	-

Parameter containers in libMdcTrackD

Container Class	Code Status	Tables and Read Interface	Write Interface	Oracle Development By	Data By	Filling By	Filling Status Nov01
HMdcTrackFitPar	? Contains drift velocities	-	-	?	Vladimir Pechenov	?	-

Parameter containers in libMdcTrackS

Container Class	Code Status	Tables and Read Interface	Write Interface	Oracle Development By	Data By	Filling By	Filling Status Nov01
HMdcHitFPar	?	-	-	?	?	?	-
HMdcSegmentFPar	?	-	-	?	?	?	-

The parameter containers MdcLeverArmGeometry, MdcModuleGeometry and MdcTargetGeometry can be filled in the analysis from the containers SpecGeomPar and MdcGeomPar and do not need an Oracle interface.

Parameter containers in libKick

Container Class	Code Status	Tables and Read Interface	Write Interface	Oracle Development By	Data By	Filling By	Filling Status Nov01
HKickPlane	stable ?	-	-	?	Manuel Sanchez	?	-
HKickTrackFPar	May use interface for conditions (read, write + GUI exist)			?	Manuel Sanchez	?	-

Container Class	Class in the corresponding library holding the parameters
Code Status	Shows, if the code of the parameter container is stable or if it will change within the next weeks. The development of an Oracle interface may have higher priority for containers, which will most probably not change.
Tables and Read Interface	Shows, if already Oracle tables for the data and a read interface to the analysis exist
Write Interface	Shows the kind of write interface for existing tables
Oracle Development By	Person responsible for the Oracle development (server and client side applications)
Data By	Person responsible for the data. In case, this person will not also do the filling in Oracle, he or she should inform the responsible person immediatly about new production parameters.
Filling By	Person responsible for the filling of the Oracle tables
Filling Status Beamtime Nov2001	Comparison of the data read from Oracle with the data in a ROOT file used for the analysis of beamtime 2001. Some tables contain also data for former beamtimes. Many already existing tables were never continuously maintained and without a decent comparison with parameter ROOT files used for DST production, initialization from Oracle for former beamtimes will not get reliable results.