| Table | Description |
|---|---|
| ITR_Chamber | This is the central table. It contains the physical chamber ID (i.e. which actual MSGC wafer is this), the chamber type and holds relations to ITR_Chip and ITR_nede |
| ITR_Chip | Elements include this chip's length of pipeline, and relations to noise, pedestal and channel status tables |
| ITR_Fed | Describes mapping of readout chips to FED boards. |
| ITR_FedSlb | Connection of FED to SHARC (Second Level Buffer) |
| ITR_nede | Essentially a copy of the ARTE NEDE bank. However, the two volumes used by ARTE to describe one chamber are merged into one table here. |
| ITR_nesl | A copy of the ARTE NEDE bank. |
| ITR_Geovers | The ARTE geometry version used to create this set of tables. |
A different set of tables should be updated automatically by a monitoring process:
| Table | Description |
|---|---|
| ITR_Chanstat | For each readout strip this table indicates whether the channel is OK, hot or dead. |
| ITR_Noise | The mean noise for each channel |
| ITR_Ped | Pedestal value for each channel |
The following table shows the "official" database versions together with the ARTE Geometry used to create the tables ITR_nede and ITR_nesl.
| Major | Minor | Geometry | Date | Remarks |
|---|---|---|---|---|
| 4 | 2 | 991325 | Latest geometry before completion of installation: all magnet chambers, stations 10 and 13 in PC area, station 14- in TC region | |
| 6 | 1 | 000810 | Full geometry after the Christmas shutdown 1999/2000: All magnet and pattern recognition stations inserted, MS14- in TC area | |
| 7 | 6 | 000812 | June 8, 2000 | Full geometry as above Chamber hardware names checked and corrected bug in chamber offset corrected (this only affected stereo layers) |
| 8 | 2 | 000812 | August 10, 2000 | Full geometry as above Included MS15- trigger test setup Again: chamber hardware names checked and corrected Some chips had wrong pipeline lengths in ITR/Chip |
Finally, there is the table ITR_Steering. All our software packages need some steering parameter, e.g. thresholds for the cluster finder, database versions, etc. This table holds all the necessary parameters for ITR_silraw, ITR_marvin, itrleda, itrdmon and itrrhp.
All database servers are write protected with a password to prevent accidental corruption of the data base. If you feel you need to write to the database, just ask Torsten or Wolfgang for the password.