Difference between revisions of "RCDB"

From HallCWiki
Jump to navigationJump to search
(Created page with "= General Information = * HallC RCDB Home: https://hallcweb.jlab.org/rcdb HallC Run database stores run related information using mysql database and the RCDB. It utilizes exi...")
 
Line 11: Line 11:
  
 
They are also replicated from cdaqdb1 to hallcdb. The RCDB process runs on the read-only copy from hallcdb.
 
They are also replicated from cdaqdb1 to hallcdb. The RCDB process runs on the read-only copy from hallcdb.
 +
 +
The master database should be only accessed when adding new entries, at the start/end of run, for example. This is done automatically by running python scripts. The connection string is set to the master database by default on cdaq machines in order to fill run conditions to the DB.
  
 
== Git repositories ==  
 
== Git repositories ==  
Line 16: Line 18:
 
* HallC scripts: https://github.com/JeffersonLab/hallcdb
 
* HallC scripts: https://github.com/JeffersonLab/hallcdb
 
* PREX/CREX (some example scripts might be still useful): https://github.com/JeffersonLab/pvdb
 
* PREX/CREX (some example scripts might be still useful): https://github.com/JeffersonLab/pvdb
 +
 +
= Instruction for general users and analyzers =

Revision as of 02:44, 28 September 2023

General Information

HallC Run database stores run related information using mysql database and the RCDB. It utilizes existing RCDB framework, that was initially developed and used for Hall D, for data management, parser, logging and etc. While we keep the same database schema from the rcdb, we cam also add experiment specific conditions. For the full list of conditions, see https://hallcweb.jlab.org/rcdb/conditions/.

databases and server information

The master database server is running on cdaqdb1. There are currently 3 databases:

  • c-rcdb: HallC database for RCDB
  • a-rcdb: used for PREX/CREX experiment in Hall A
  • rcdb: used for test

They are also replicated from cdaqdb1 to hallcdb. The RCDB process runs on the read-only copy from hallcdb.

The master database should be only accessed when adding new entries, at the start/end of run, for example. This is done automatically by running python scripts. The connection string is set to the master database by default on cdaq machines in order to fill run conditions to the DB.

Git repositories

Instruction for general users and analyzers