|
Skim1 Msql Tables
|
|
All Skim1 processes log and/or query information to/from a client-server Msql
database located on Windom (the CU-HEP server).
The Skim1 database is organized in 5 tables, corresponding to the different
stages of data processing and size of data units:
INPUT TAPE TABLE
- ENTRY: input data tape (=run)
- KEY FIELD: tapeName = runNumber
INPUT FILE TABLE
- ENTRY: input data file
- KEY FIELD: fileName = runNumber.fileNumber
- NOTE: typically, every input run contains 28-30 input files
OUTPUT FILE TABLE
- ENTRY: output data subfile
- KEY FIELD: fileName = runNumber.fileNumber.streamNumber
- NOTE: every input file generates 6 output subfiles, one per output stream
OUTPUT TAPE TABLE
- ENTRY: output data file
- KEY FIELD: tapeName = runNumber.streamNumber
- NOTE: an output data file is the sum of all the output subfiles
for a given input run to a specific output stream (i.e. typically
there is an output data file for any 28-30 output subfiles)
SKIM TAPE TABLE
- ENTRY: skim data tape
- KEY FIELD: tapeName = tapeLabel
- NOTE: a skim tape contains 10 to 20 output files of a specific
output stream