ALEPH Data Model

ADAMO DDL Subschemas

ADBSGEOM

'Contains the definitions of the entity sets and relations which are general for the whole ALEPH Detector Description System (ADDS)'

AdbsDOCU

'Description of Adbs documentation tables containing information used for documentation purpose only'

BANKDOCU

'Description of tables containing information for non-Database tables used for documentation purpose only'

BOSKEY

'KEY for BOS GAF'

BcalJULBanks

'Description of JULIA banks containing Bcal data'

BcalRunConsts

'Description of Data Base banks containing Bcal data'

BomJULBanks

'BOM Julia banks'

BomONLBanks

'BOM raw data banks'

BomOffConsts

'BOM Offline Constants'

CaloOffConsts

'Description of Calobject constant banks'

CaloRunConsts

'Description of Calorimeters (EC and LC) Run constants'

CobjJULBanks

'Description of CalObject banks'

CobjPOTBanks

'Description of CalObject banks'

DafBOOKkeeping

' DAF book keeping banks'

ECALGEOM

'Description of the geometry of the read-out of the electromagnetic calorimeter'

ECALVOLUMES

' Description of the volumes used in the tracking geometry of the electromagnetic calorimeter. Description of the structure of the volume types. The relationships can be created at initialisation in an automatic way'

EcalCalConsts

'Description of EC calibration constants per module'

EcalDefects

'Description of EC defects '

EcalGALBanks

EcalJULBanks

'Description of EC banks'

EcalOffConsts

'E/GAMMA RECONSTRUCTION CONSTANTS'

EcalPOTBanks

EcalRAWBanks

EcalRUNConsts

'Description of Ecal RUN Constants '

EcalSLOWControl

EflowJULPOTBanks

'Description of EFLOW banks'

EflowOffConsts

'Constants used in the Eflow code'

EflowRunConsts

'Run Constants used in the Eflow code'

EgamOffConsts

'Gammas analysis banks'

ElecOffConsts

' Parameters for ELectron IDENTification'

ElidJULPOTBanks

EobjJULBanks

'Description of EcObject banks'

EobjPOTBanks

'Description of Electromagnetic CalObject banks'

EventKINGALBanks

'Event generator interface banks'

FXXX

'Description of FXXX DST output banks'

FitOffConsts

'Description of Fitting constants banks'

GeneralAttribute

'Contains the definitions of the attributes which are general for the whole ALEPH Detector Description System (ADDS)'

HCALGEOM

'HCAL part of the ALEPH Detector Description System'

HcalCalConsts

'HCAL Towers Calibration constants'

HcalCalRunConsts

'HCAL Towers Calibration constants (RUN dependent)'

HcalDefects

'HCAL Dead Channels banks'

HcalGALBanks

'Description of HCAL GALEPH banks'

HcalJULBanks

'Description of HCAL JULIA banks'

HcalONLBanks

'Unforseen HCAL raw data banks'

HcalOffConsts

'HCAL constants used in offline programs'

HcalRAWBanks

'Description of HCAL Raw data banks'

HcalSLOWControl

'HCAL Slow Control Banks'

HobjPOTBanks

'Description of Hadronic CalObject banks'

ITCGEOM

'ITC part of the ALEPH Detector Description. Contains only banks whose contents are fixed or whose contents are derived from offline calibration (periodic changes).'

InternalBOOKkeep

' Internal Book keeping production banks'

InternalGALBanks

'Internal GALEPH banks'

InternalJULBanks

'Internal JULIA banks'

ItcEventRecord

'ITC Raw Data Event Record banks'

ItcGalephBanks

ItcJuliaBanks

'ITC JULIA banks'

ItcOffConsts

'ITC constants used in offline SW. Some of these banks may be updated periodically to reflect changes in running conditions etc. which affect the ITC.'

ItcPOTBanks

'ITC POT banks'

ItcRunConsts

'ITC constants which come from the Online in the Run record of the data and are to be used in the reconstruction of the data.'

ItcRunRecord

'ITC Raw Data Run Record. ITC calibration constants (for front-end and trigger) which may be present in some Run records.'

ItcSlowControl

'ITC Slow Control Record. Some or all of these banks may appear in Slow control records interspersed between the event records. There are 4 different bank names but the content is essentially the same for all of them. Each bank consists of a standard ALEPH header followed by a variable number of information blocks, one block per group of hardware. The number of information blocks appearing in each bank is not fixed, neither is the order in which they appear. Due to the structure of the banks the ALEPH 2 word header defines all the banks to have only one column. The number of rows is the sum of the sizes of all blocks present. The content of the blocks is described elsewhere.'

JULOFFrunsummary

'Description of run summaries: FALCON results are kept into JSUM which is written on POT,DST,MDST'

JULPOTFitTrack

'Description of global TPC+ITC+VDET banks for fitted tracks'

JULSkelConsts

'JULIA skeleton Constants'

LCALGEOM

'LCAL part of the ALEPH Detector Description'

LUMINOSITY

'Description of banks used for luminosity calculation'

LcalGALBanks

' Lcal banks used in GALEPH only'

LcalJULBanks

'Description of Lcal banks used in JULIA'

LcalOffConsts

'Constants used in the Lcal code'

LcalPOTBanks

'Description of Lcal banks on POT/DST'

LcalRAWBanks

'Description of LCAL Raw data banks '

LepTABle

'LEP tables'

LepstatONLBanks

MUONEfficiency

'Descripton of HCAL and MUON tube efficiency banks'

MUONGEOM

'MUON part of the ALEPH Detector Description'

McOffConsts

'Contains the constants used in the MC program'

MiniDSTBanks

MuonDefects

'Description of MU chamber defects '

MuonRAWGALJULPOT

ONLINE

'Gives a single view of the complete detector. 25-OCT-1988 Changes to rationalise our method of dealing with the ROC-Slot relationships. Slots are now in linked lists. These lists have a 1 to "n" relationship to a ROC. Thus: 1 Slot can have 1 ROC associated with it, 1 Slot can have "n" ROCs associated with it, n Slots can have 1 ROC associated to them, n Slots can have n ROCs associated to them. 15-NOV-1989 Changes to describe detectors with one ROC per subcomponent / component. n Slots can have 0 ROCs associated with it - then use subcomp or component ROC. 1-APR-1989 Added FB column as index to first Fastbus Segment in Fastbus Database. 17-JUL-1989 Relationship to ADBS Geometry database changes as MUON ESET is superseded by MUOG, MSCO by MGSC. 31-AUG-1989 Change OCOM and OSLO sizes. 21-MAY-1990 Update links to VDET description. 14-MAR-1991 Relationship OCOM -> VEDE changed to OCOM -> VCOD VEDE is obsolete. '

ONLINEXTRA

'ONLINE Extra tables not in ADBS YET'

PMGEOM

'Geometrical description of the Passive Material like beam pipe, coil etc'

ProgDOCU

'Description of PROGram documentation tables containing information used for documentation purpose only'

SATRCAL

'Description of BOS banks for the calibration of the Small Angle Tracking Device data (non-database banks)'

SATRGEOM

'SATR part of the ALEPH detector description'

SATRMC

'Description of BOS banks for the Small Angle Tracking Device MC data'

SATRNONTABL

'Description of non-tabular SATR banks '

SATRPOT

'Description of BOS banks used for the SATR part of the POT'

SATRREC

'Description of BOS banks for the Reconstruction for the Small Angle Tracking Device'

SCALGEOM

'SCAL Detector GEOMetry Description'

SatrOffConsts

'Description of BOS banks for calibration constants and cuts for the Small Angle Tracking Device'

ScalDefects

'Defects identified in Scal '

ScalGALBanks

' Scal banks used in GALEPH only'

ScalJULBanks

'Description of JULIA Sical banks'

ScalLUMI

'Description of Scal LUMINOSITY info '

ScalOffConsts

'Constants used in the Sical code'

ScalRAWBanks

'SCAL Detector RAW DATA banks Description'

ScalRUNConsts

'Description of Scal RUN Constants '

ScalSLOWControl

'SCAL Detector SLOW control banks Description'

StatusGALBanks

'GALEPH status banks'

StatusJULBanks

StatusOFFLBanks

StatusRAWBanks

TPCGEOM

'TPC part of the ALEPH Detector Description'

TPCSIM

TRIGGERLEVEL2

'Event record from the Trigger Level 2 of the Aleph detector.'

TRIGGERLEVEL3

'Event record from the Trigger Level 3 of the Aleph detector.'

TRIGGERRDOUTLVL1

'Event record from the Trigger Level 1/2 of the Aleph detector.'

TRIGGERSUMMARY

'Contains trigger run summary banks'

TpcGALBanks

'Description of TPC simulation banks'

TpcJULBanks

'Description of TPC reconstruction banks'

TpcLaserCal

'Contains the measurements of the laser deflection angles in TPC sides A and B (error of 0.01 degree) and the results of the laser calibration runs'

TpcONLBanks

'Description of TPC online banks'

TpcOffConsts

'Description of TPC constants banks'

TpcPOTBanks

'Description of TPC production output banks'

TpcRAWBanks

'Description of TPC raw data banks'

TpcRunConsts

'Description of TPC online data base banks'

TpcSLOWBanks

'Description of TPC slow control banks'

VDETGEOM

'VDET part of the ALEPH Detector Description'

VdetEVEntBanks

'VDET event record banks written to raw data'

VdetGALBanks

'VDET banks produced by GALEPH'

VdetJULBanks

'VDET banks used internally in JULIA'

VdetONLBanks

'VDET banks internal to the online system'

VdetOffConsts

'Banks for VDET hit reconstruction and track refitting'

VdetPOTBanks

'VDET banks written to POT,DST'

VdetRUNBanks

'VDET run record banks written to raw data'

X1AdcCal

'Calibration constants for the ADCs in the trigger system.'

X1RUNTriggerType

'A database for storing trigger setup information.'

X1TriggerDef

'definition of the logical functions to verify the 32 trigger bit \ mask from the fastbus register bit pattern.'

YTOPRunConsts

YV0OffConsts

'Description of V0 VERTEX fit constants banks'

YtopJULPOTBanks

'Description of parameters and banks used in YTOPOL package'

YtrackDALIBanks

'Description of neutral or charged track to secondary vertex calculated in DALI'

Yv0JULBanks

'Description of V0 VERTEX fit output banks'

Yv0POTBanks

'Description of V0 VERTEX fit P.O.T banks'

YvertexJULBanks

'Description of VERTEX fit output banks'

YvertexPOTBanks

'Description of vertex banks for POT'