Conception et optimisation d’une base de données relationnelle pour la configuration d’expérie...
Download
1 / 10

Implementation and optimization of a relational database to configure and manage HEP equipment - PowerPoint PPT Presentation


  • 109 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Implementation and optimization of a relational database to configure and manage HEP equipment' - johnna


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Implementation and optimization of a relational database to configure and manage hep equipment

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

Lana Abadie


Sections
Sections relationnelle pour la configuration d’expériences HEP

  • Acknowledgments

  • Abstract

  • General introduction : context of the problem

  • State of the art

  • LHCb experiment

  • Introduction to databases

  • Requirements and use cases

  • Data table schema

  • Integration in the LHCb environment

  • Validation

  • Conclusions

  • Bibliography

  • French summary

  • annexes

Lana Abadie


1 state of the art
1) State of the art relationnelle pour la configuration d’expériences HEP

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

Lana Abadie


2 lhcb experiment
2) LHCb experiment relationnelle pour la configuration d’expériences HEP

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

work?

2.6 Thesis objectives : what are my objectives?

Lana Abadie


3 introduction to databases
3) Introduction to databases relationnelle pour la configuration d’expériences HEP

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?

Lana Abadie


4 requirements and use cases
4) Requirements and use cases relationnelle pour la configuration d’expériences HEP

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?

4.6 Conclusion

Lana Abadie


5 data table schema
5) Data table schema relationnelle pour la configuration d’expériences HEP

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?

5.6 Conclusion

Lana Abadie


6 integration in the lhcb environment
6) Integration in the LHCb environment relationnelle pour la configuration d’expériences HEP

6.1 JCOP ConfDB tool : what are the features of this

tool?

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.6 Conclusion

Lana Abadie


7 validation
7) Validation relationnelle pour la configuration d’expériences HEP

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).

Lana Abadie


8 conclusions
8) Conclusions relationnelle pour la configuration d’expériences HEP

8.1 Project status : were the aims and objectives satisfied?

8.2 Future work : ?

Lana Abadie