First Functionality - Update mezz number of chamber and problematic mezzanines

A first functionality of this database is the update of the number of Mezzanine cards each chamber has. This step is needed actually only once during the first setup of the project. But the same query is used to obtain the information concern the mezzanines that for various reasons are not readable or are damaged. This information is updated in the database by detector people that know about the problems of these electronic cards.

The sql query used inside PVSS to retrieve this data is the following:

"SELECT CSM,MASK FROM TABLE(atlas_conf_mdt.dcs_r.csm_mask())"

Second Functionality - Canbus node information

Another information stored in this database is the information of the canbus node each MDT chamber belongs to and the sequence on this chamber along this canbus line. This information is needed for the electronic view of the chambers, seating in the information panel of the chamber level as one can see in the chapter that refers about the Operation Interface. Again this step is needed actually only once during the first setup of the project.

The sql query used inside PVSS to retrieve this data is the following:

"SELECT CANBUS,CHANNEL,EMDT FROM TABLE(atlas_conf_mdt.canbus.get_canbus_for_mdt(NULL))"

Third Functionality - mapping of Mezz cards as we see them from the read out chamber side

A third information this database can provide is the information concerning the mapping of mezzanine cards as we physically see them from the read out side of the chambers. There are several rules for the numbering of mezzanine cards, the most important is that the card number 0 must be placed in the side and in the multilayer that is closer to the interaction point. On the other hand there are various exceptions in this rule but all of them stored properly in the database. As long as DCS has this information , can easily display them in a panel as really they should like in read out side, an information useful at least in the commissioning phase of the experiment. Again this information can be characterized quite static so the query is done once in the setup of the project.

The sql query used inside PVSS to retrieve this data is the following:

"SELECT CHAMBER,MULTILAYER,MEZZANINE,CSM FROM TABLE(atlas_conf_mdt.dcs_r.mezz_map())"

-- CharilaosTsarouchas - 20 Oct 2008