The Configuration Database Project配置数据库的项目.pptVIP

LHCb Online Configuration Database Lana Abadie, CERN PhD student from University Pierre Marie Curie (Paris VI) , Laboratoire SAMOVAR CHEP04, Interlaken Objectives requirements Store information about all controllable devices their properties the links between them their hierarchy Keep necessary information for the ECS to configure equipment to operate the experiment to monitor the system Database design key issues schema completeness performance maintenance DATABASE SCHEMA Use cases Collect use cases : Given a VELO card, find a free readout supervisor and determine the routing table of the TFC switch List the keywords : device type, device, link, path... Define them: a link is a cable between a device output number and a device input number Find connections between keywords: a path is a sequence of links Entity relationship model DATABASE IMPLEMENTATION Implementation features Use of Oracle technology Use of ProC/C++ to access the database and C/C++ to encapsulate the SQL and PL/SQL statements to communicate with PVSS Use of JCOP configuration database tool Implementation of a tool (cdbVis) to edit and navigate through the database in Python Use of CVS to keep versions of projects and softwares Integration of theJCOP configuration database tool Joint Control Project: offers common tools and framework for PVSS Ensure compatibility between JCOP tables and LHCb tables Avoiding redundancy in the tables: JCOP tables contain device properties LHCb tables store connectivity and hierarchy information Adaptation of JCOP configuration database panels Communication : Ex. of concrete implementation : TFC system TFC requirements Conclusion Design schema for TFC and DAQ tables completed Production TFC control system (PVSS) now uses the configuration database Future work Table Design for LHCb other subdetectors Extension of the cdbVis functionalities Design an API to enable clients to interact with the database * LHCb configuration da