Conception et optimisation d’une base de données relationnelle pour la configuration d’expériences HEP . Implementation and optimization of a relational database to configure and manage HEP equipment. Sections. Acknowledgments Abstract General introduction : context of the problem
Implementation and optimization of a relational database to configure and manage HEP equipment
1.1 HEP experiments : what are the main characteristics
1.2 Configuring Equipment of an experiment : what are the different steps? What are the specific concepts?
1.3 Need to use DB technology
1.4 Solutions in the past : ALEPH & DELPHI
1.5 Current possible solution : CMS & ATLAS
1.6 Use of conf DB in other fields
2.1 LHCb overview : Give the objectives, dataflow.
2.2 The detector : what are the different parts?
2.3 The online system: what is it?
2.4 LHCb Equipment management : what does it consist of?
2.5 Scope of investigation : what are the boundaries of my
2.6 Thesis objectives : what are my objectives?
3.1 DBMS : what is it? What are the different types?
3.2 ERM : what does it consist of?
3.3 SQL: what is it?
3.4 Oracle : how does it work?
3.5 PL/SQL : what is it?
3.6 Database interfaces: what are the different types?
4.1 Requirements. What are the requirements?
4.2 Use case 1 TFC. How will the TFC use CIC DB?
4.3 Use case 2 sub-detectors. How will the sub-detectors use CIC DB? (ones which are different from the TFC)
4.4 Use case 3 the DAQ. How will the DAQ use CIC DB?
4.5 Use case 4 Inventory and history. What do the different subsystems expect as information?
5.1 Introduction. Why did I choose the ERM?
5.2 Configuration representation. How did IT-JCOP represent configuration data?
5.3 Inventory and history design : How did I model this info?
5.4 Connectivity design. How did I model this info?
5.5 Routing tables and paths. How did I model paths using information from the CIC DB?
6.1 JCOP ConfDB tool : what are the features of this
6.2 A C-library to query connectivity & inventory data :
what are the different functions? How was it implemented?
6.3 CDBVis : What are the different features of this tool?
6.4 Security and concurrency and consistency. What about
security issues?How did I ensure consistency updates?
Are my queries safe enough when concurrent accesses?
6.1 Validity of the table schema (connectivity + inventory)
6.2 Benchmarks to test queries against a prototype of CIC DB (connectivity and inventory info). Simulation of multi-user environment (stress testing).
8.1 Project status : were the aims and objectives satisfied?
8.2 Future work : ?