KID - Database-related modules

Description:

Read events from a list of YBOS files. The files get automatically recalled to a recall area before beeing passed to the application. The DB KID modules request one file at a time to the recall system, so it is perfectly safe to ask for a very long list of files.
Note: Only the files registered in the KLOE DB can be read using these modules.

Available modules:

dbraw - select a list of raw files
dbdatarec - select a list of datarec files
dbmc- select a list of Monte Carlo files
dbfile- select a file by name
db - select a list of files using a generic SQL query

dbraw

Description:

Select a list of raw files.

Syntax:

dbraw : query-string ? options

where:

query-string is the WHERE part of a SQL query to the logger.raw_data table. The files get ordered by (stream_id, run_nr, farm_id, gb_nr).
The most usefull fields are:

RUN_NR - run number (i.e. 8734)
FARM_ID - DAQ farm (i.e. 'f05')
RECEIVER_NR - receiver number (i.e. 1)
BUILDER_NR - builder number (i.e. 1)
STREAM_ID, STREAM_CODE - stream identifier, use one or the other.
Available streams:

Id Code Description

0 'ALL' All the data

11 'L3BHA' L3 Bhabha

13 'L3COS' L3 Cosmic Rays

14 'L3MIP' 3 Minimum Ionizing Particles
RECORDER_NR- recorder number (i.e. 1)
GB_NR- chunk number (i.e. 3)
FILENAME- file name (i.e. 'raw010678N_ALL_f06_1_1_1.002')
TSERVER_ID, FILESPACE_ID- tape server where the file is stored (i.e. 'f09',1)
SIZE- the size of the file (i.e. 536872960)
TOTAL_EVENTS- number of events in the file (i.e. 430786)
CREATION_TIME- when the file was created (i.e. '1999-04-21-07.40.00.827752')
CLOSURE_TIME- when the file was closed (i.e. '1999-04-21-07.41.11.253741')
NULL if the file is still open
ARCHIVED- archived flag (0=not archived, 1=archiving, 2=archived)
ANALYZED- version of the last datarec analyzis
NULL if not analyzed

Options are an optional list of URI options. (For details see the common options section.)

Id	Code	Description
0	'ALL'	All the data
11	'L3BHA'	L3 Bhabha
13	'L3COS'	L3 Cosmic Rays
14	'L3MIP'	3 Minimum Ionizing Particles

Examples:

dbraw:run_nr between 10000 and 10050 and stream_code='L3BHA'
dbraw:run_nr=12465 and stream_code='ALL'?respect_order=N&group_id=f09
dbraw:stream_code='L3COS' and tserver_id='f09'?group_id=USER

dbdatarec

Description:

Select a list of datarec files.

Syntax:

dbdatarec : query-string ? options

where:

query-string is the WHERE part of a SQL query to the logger.datarec_data table. The files get ordered by (stream_id, version, run_nr, offline_id, gb_nr).
The most usefull fields are:

RUN_NR - run number (i.e. 8734)
VERSION - Datarec version (i.e. 3)
OFFLINE_ID - Datarec farm (i.e. 's07')
DATAREC_NR - Datarec number (i.e. 54)

STREAM_ID, STREAM_CODE - stream identifier, use one or the other.
Available streams:

Id	Code	Description
22	'afilfo'	Raw Anti FILFO
7	'bha'	Bhabha (FILFO)
5	'clb'	Calibrations
8	'csm'	Cosmics (Chamb. calib.)
21	'filfo'	Raw FILFO
1	'kpm'	K⁺K^-
2	'ksl'	K⁰ ^-K⁰
4	'rad'	Radiative events
3	'rpi'	Ro Pi
25	'selcos'	Raw Selezione cosmici
9	'tmu'	Cosmics (Another method)
6	'ufo'	Unidentified

GB_NR- chunk number (i.e. 3)
FILENAME- file name (i.e. 'bha010678N_ALL_f06_1_1_1.002')
TSERVER_ID, FILESPACE_ID- tape server where the file is stored (i.e. 'f09',1)
SIZE- the size of the file (i.e. 536872960)
TOTAL_EVENTS- number of events in the file (i.e. 30786)
CREATION_TIME- when the file was created (i.e. '1999-04-21-07.40.00.827752')
CLOSURE_TIME- when the file was closed (i.e. '1999-04-21-07.41.11.253741')
NULL if the file is still open
ARCHIVED- archived flag (0=not archived, 1=archiving, 2=archived)
ANALYZED- version of the last datarec analyzis
NULL if not analyzed

Options are an optional list of URI options. (For details see the common options section.)

Examples:

dbdatarec:version=3 and run_nr between 10000 and 10050 and stream_code='rad'
dbdatarec:version=4 and run_nr=14311 and stream_code='bha'?RESPECT_ORDER=N&GROUP_ID=USER
dbdatarec:filename='ksl013739N_ALL_f06_1_1_1_3.000'?GROUP_ID=s11

dbmc

Description:

Select a list of Monte Carlo files.

Syntax:

dbmc : query-string ? options

where:

query-string is the WHERE part of a SQL query to the logger.mc_data table. The files get ordered by (MCCARD_ID,MCRUN_NR).
The most usefull fields are:

MCCARD_ID, MCCARD_CODE - card identifier, use one or the other.
Available cards:

Id Code Description

1 'all_phid' All physics
MCRUN_NR - MC run number related to the card (i.e. 3)
SEED_STREAM - Stream number (i.e. 3)
MC_VERSION - GEANFI version (i.e. 12)
MC_OFFLINE_ID - MC farm (i.e. 's07')
MC_START_TIME- when the event creation was started (i.e. '1999-04-21-07.40.00.827752')
MC_END_TIME- when the event generation was ended (i.e. '1999-04-21-07.41.11.253741')
DATAREC_VERSION - Datarec version (i.e. 3)
DATAREC_OFFLINE_ID - Datarec farm (i.e. 's07')
DATAREC_NR - Datarec number (i.e. 54)
FILENAME- file name (i.e. 'mc12.yb')
TSERVER_ID, FILESPACE_ID- tape server where the file is stored (i.e. 'f09',1)
SIZE- the size of the file (i.e. 536872960)
TOTAL_EVENTS- number of events in the file (i.e. 30786)
CREATION_TIME- when the file was created (i.e. '1999-04-21-07.40.00.827752')
CLOSURE_TIME- when the file was closed (i.e. '1999-04-21-07.41.11.253741')
NULL if the file is still open
ARCHIVED- archived flag (0=not archived, 1=archiving, 2=archived)
ANALYZED- version of the last datarec analyzis
NULL if not analyzed

Options are an optional list of URI options. (For details see the common options section.)

Id	Code	Description
1	'all_phid'	All physics

Examples:

dbmc:mccard_id=1 and mcrun_nr between 3 and 7
dbmc:mccard_code='all_phid' and run_nr=2?RESPECT_ORDER=N&GROUP_ID=USER
dbmc:MC_START_TIME>=TIMESTAMP('1999-12-23-00.00.00.000000') and MC_START_TIME<=TIMESTAMP('2000-01-05-23.59.59.999999')?GROUP_ID=s11

dbfile

Description:

Select a list of files based on their names.

Syntax:

dbfile : filename ? options

where:

filename is a file name specifier.

Several files can be selected using the wildcards:

% - skip any number of characters
_ - skip a single character

for example:

raw% matches raw345, raw and raw_333_55_678.000 but not rav345
bha_456 matches bha_456, bha0456 but not bha_456.000
%12_0% matches raw012407N_ALL_1_1_1.000, bha012909_1.001 and 12_000.yb but not raw012411N.001

Options are an optional list of URI options. (For details see the common options section.)

Examples:

dbfile:raw014166N_L3BHA_f04_1_1_1.000?GROUP_ID=USER
dbfile:bha%_3.%?respect_order=N
dbfile:ksl010214N_ALL_f05_1_1_1_2.003

db

Description:

Select a list of files using a generic SQL query.

Syntax:

db : query ? options

where:

query is a generic SQL query having the following output fields:

Position	Type	Description
0	Integer	File type 1 - raw 2 - datarec 3 - Monte Carlo
1	String	File name

Options are an optional list of URI options. (For details see the common options section.)

Examples:

db:select 1,filename from logger.raw_logger where run_nr=12432?RESPECT_ORDER=N&GROUP_ID=USER
db:select 2,filename from logger.datarec_logger where run_nr=14327 order by version DESC?RESPECT_ORDER=Y
db:select 1,filename from logger.raw_logger where closure_time is not NULL order by run_nr desc fetch first row only

Common options:

option	param. type	description
dbnode	string	Name of the DB machine. (i.e. fibm01). If not specified, the environment variable SQLREMOTENODE is used.
dbport	integer	Port on which the SQLr_selectd listens. If negative or not specified, the default port will be used.
report_on_change	one of: yes, Y, 1, true, T (default) no, N, 0, false, F	iff true, the module prints out a message string each time a file is open
respect_order	one of: yes, Y, 1, true, T (default) no, N, 0, false, F	if false, the files can be served to the application in any order (can be faster)
group_id	string	Id of the group; used primarely for the selection of the recall areas. The available groups are: USER (default) PROD - for production processes ONLY f09 f10 s11 s12 - for production processes ONLY

Send comments to: Igor Sfiligoi

Last modified: Tue Nov 28 09:35:52 MET