210 likes | 368 Views
Report on MTF properties for the HCC. Mike Koratzinos MPP, 16 July 2008. The story so far. The powering procedure documents specify a series of variables to be acquired, calculated and stored for every test procedure step. Storage is through MTF to a database
E N D
Report on MTF properties for the HCC Mike Koratzinos MPP, 16 July 2008
The story so far • The powering procedure documents specify a series of variables to be acquired, calculated and stored for every test procedure step. • Storage is through MTF to a database • These variables are acquired and/or calculated either online or offline • There are tens of thousands of variables to be stored
Example: RB PLI.A2 procedure …take one MPP powering procedure document: …chose a test… …and look at the variables to be stored in MTF… …And in MTF: https://edms.cern.ch/asbuilt/plsql/mtf_slot.slot_main_top?cookie=7645549&p_rec_type=P&p_rec_id=RB.A23
Example: RB PLI.A2 procedure …indeed, if we look in MTF:
The story so far II • These variables are called in MTF “Properties” = MTF-speak for a variable linked to a test and circuit. • Unfortunately, in standard MTF a new property value overwrites the previous one – there is no provision for different property values for different tests or different circuits. • A whole campaign was initiated to be able to store different instances of properties – MTF was ‘customized’ for Hardware Commissioning. • This ‘customization’ campaign has finished successfully • Therefore, for every test we can now find the values of all associated properties that were acquired during that specific test.
A brief timeline of the project • Many thanks to the main players: many people have been involved in this work: Sonia Mallon Amerigo, Rafal Lyzwa, Alvaro Marqueta Barbero, Markus Zerlauth, Odd Andreassen, … • MTF Versioning proposal dated 8 April 2008. • Design frozen 21 April 2008 (Sonia and Rafal) • Online since 28 April 2008 • Sequencer historic data for sector 56 imported between the 20 May 2008 and 26 May 2008, followed by PMA data • PMA data online since 27 May 2008
Main features of new ‘customized’ MTF • A series of properties is uniquely associated to a specific instance of a test. This was not possible in the previous version. • For each test performed and uploaded into MTF, space is created in MTF for all properties linked to that specific test. The area where HCC properties are stored is an external database table in MTF. • The values of the properties that are measured online are stored in the space that has been created for that test. • The rest of the properties (the offline properties) can be filled at a later stage. • Data of this external MTF table are visible using the standard MTF web interface.
Current status • External properties linked to HCC tests to date: more than 57,000 • Currently all online properties are routinely stored in MTF using an automatic ‘grabber’ that runs semi-online (3 hour delay) • Campaign to import ‘historic’ Sequencer and PMA data finished
How to look at these properties – from the Web …go to the MTF web interface… …Choose a circuit… …go to the Installation and Commissioning tab… …Choose a test…
Installation and Commissioning tab a PNO.c2 test on RD2.L8 Properties seen here are the real properties associated to this specific test
Some statistics… • There is another way to look at these properties: directly from the database (edms_hcjobs@edmsdb) • We have currently (at 12:30, 15 July 2008) 57218 properties linked to tests in MTF
Ownership • Each property is associated to an ‘owner’. • A property can be ‘online’ or ‘offline’ depending on if it is filled online or offline. • Online property owners are: Sequencer, PMA • Offline property owners are: MPP, QPS, QPS/EE. There is flexibility in the system so that a property can change owner in the future. This will not affect the ownership of properties up to that moment
How do stored data look like? • Data quality is good! • One can perform statistical tests with a single variable, with a single variable vs time, or even can perform correlations between two (or more) variables during the same test • Data is available in the MTF database – Ask me for a plot, or ask for an account and password or, if there is enough demand, we can build a customized web site.
Data quality • Data is all in a database and easily accessible for any type of analysis. So please use it! Example: what are the main statistical properties of the I_EARTH_PCC measurement? Does it change with time?
Next steps • Overall quality of data very impressive • Sequencer: more than 99.8% of filled properties • PMA: more than 97% of filled properties • MPP has about 2700 properties to fill • QPS has about 500 properties to fill • We can provide tools to ease the filling of properties (or even calculate properties) • Please do not forget that all these variables are stored following your request