CB = COOL Browser Support Tables in COMA (Conditions DB Management Metadata)

1. CB = COOL Browser Support Tables in COMA(Conditions DB Management Metadata) • All COMA tables start with prefix ‘COMA_’ • CB is my shortname for ‘Conditions Browser’ part of the COMA schema • Loading restrictions • Instances: COMP200, MONP200, OFLP200 • Not: TBDP200, CMCP200, PIXRUNCO, STRM200, TGC1, TMCP200, ALLP200, CORALDB2, MDT • Accounts: ATLAS_(COOLONL,COOLOFL)_* • Not: ATLAS_COOL_% (pre-July-2007) • Tags: locked tags • Not unlocked or partially locked tags (?) • CB_Nodes and CB_Folders table content might seem redundant … • Optimizes storage • Helps interfaces to reduce joins • Current Row counts: See blue boxes • COOL Accounts: OnOff_Schema/Instance • Example: COOLONL_SCT/COMP200

2. September 2011: COMA_CB + Andrea Formica’s Tag tables CB_SCHEMAS P – CBS_NAME CBS_SYSTEM CBS_DESC 19652 17 12 CB_INSTANCES P – CBI_NAME CBI_DESC 2 CB_ONOFFS P – CBO_NAME CBO_DESC CB_PAYLOADS P – CBP_INDEX FU – CBF_INDEX U – CBP_COLUMN CBP_TYPE CBP_DESC 1590 CB_NODES P – CBF_INDEX FU – CBO_NAME FU – CBS_NAME FU – CBI_NAME U – NODE_FULLPATH NODE_NAME NODE_ID NODE_PARENTID NODE_ISLEAF NODE_INSTIME LASTMOD_DATE CBF_MODIFY_DATE CBF_DESC CBF_TWIKI CB_FOLDERS PF – CBF_INDEX FU – CBO_NAME FU – CBS_NAME FU – CBI_NAME U – NODE_FULLPATH NODE_NAME NODE_DESCRIPTION FOLDER_VERSIONING CBF_NODE_PATH CBF_IOV_BASE CBF_ATT_TYPE CBF_CHAN_COUNT CBF_PAYLOAD_COUNT 2216 1590 CB_REFERENCES PF – CBF_INDEX FOLDER_IOVTABLENAME FOLDER_TAGTABLENAME FOLDER_IOV2TAGTABLENAME FOLDER_CHANNELTABLENAME 101865 GLOBAL_TAG2SYSTEM_TAG SYSTEM_TAG CLUSTER_NAME DB_NAME FOLDER_NAME SCHEMA_NAME GLOBAL_TAG_ID GLOBAL_TAG_INFO GLOBAL_TAG_INFO_ID STATUS_SINCE STATUS_UNTIL DEPLOYMENT_LOCATION STATUS_SUMMARY USED_FOR_TASK GLOBAL_TAG_ID GLOBAL_TAG GLOBAL_TAG_ID GLOBAL_TAG_DESCRIPTION GLOBAL_TAG_NAME GLOBAL_TAG_SYSTIME NEXTGLOBALTAG_GLOBAL_TAG_ID 493

3. October 2011: COOL_CB Conditions DB Management Metadata CB_SCHEMAS P – CBS_NAME CBS_SYSTEM CBS_DESC CB_ONOFFS P – CBO_NAME CBO_DESC CB_FTAGS P – CBFT_INDEX FU – CBF_INDEX U – TAG_NAME CB_GT_TO_FTS P – CBG2F_INDEX FU – CBGT_INDEX FU – CBFT_INDEX CB_INSTANCES P – CBI_NAME CBI_DESC CB_ALL_FTAGS P – CBFT_INDEX FU – CBF_INDEX U – TAG_NAME TAG_LOCK_STATUS TAG_DESCRIPTION SYS_INSTIME CBFT_INSTIME CBFT_ROWCOUNT CBFT_LAST_OBJTIME CBFT_SINCE_TIME CBFT_UNTIL_TIME CB_NODES P – CBF_INDEX FU – CBO_NAME FU – CBS_NAME FU – CBI_NAME U – NODE_FULLPATH NODE_NAME NODE_ID NODE_PARENTID NODE_ISLEAF NODE_INSTIME LASTMOD_DATE CBF_SCHEMA_NAME CBF_MODIFY_DATE CBF_DESC CBF_TWIKI CB_FOLDERS PF – CBF_INDEX FU – CBO_NAME FU – CBS_NAME FU – CBI_NAME U – NODE_FULLPATH NODE_NAME NODE_DESCRIPTION FOLDER_VERSIONING CBF_NODE_PATH CBF_IOV_BASE CBF_ATT_TYPE CBF_CHAN_COUNT CBF_PAYLOAD_COUNT CB_GTAGS P – CBGT_INDEX U – TAG_NAME TAG_LOCK_STATUS TAG_DESCRIPTION SYS_INSTIME CBGT_INSTIME CBGT_RANK GRAY tables Not filled yet ! CBAMI_GTAGS P – TAG_NAME IS_ACTIVE DATASET_COUNT DATE_FIRST_DATASET DATE_LAST_DATASET CB_GTAG_INFOS P – CBGTI_INDEX FU – TAG_NAME U – STATUS_SINCE STATUS_UNTIL STATUS_SUMMARY NEXTGTAG_ID USED_FOR_TASK DEPLOYMENT_LOCATION CB_PAYLOADS P – CBP_INDEX FU – CBF_INDEX U – CBP_COLUMN CBP_TYPE CBP_DESC CBAMI_GTAG_USES TAG_NAME Project_Name Run_Start Run_End AMITag_Array ? CB_REFERENCES PF – CBF_INDEX FOLDER_IOVTABLENAME FOLDER_TAGTABLENAME FOLDER_IOV2TAGTABLENAME FOLDER_CHANNELTABLENAME

4. November 2011: COOL_CB Conditions DB Management Metadata CB_Instances P – CBI_NAME CBI_DESC CB_Owner_Instances P – CBOI_INDEX U – OWNER_NAME FU – CBI_NAME F – CBO_NAME FI – CBS_NAME U – COOL_SCHEMA CB_GTAGS P – CBGT_INDEX U – TAG_NAME TAG_LOCK_STATUS TAG_DESCRIPTION SYS_INSTIME CBGT_INSTIME CBGT_RANK CB_GTag_Infos P – CBGTI_INDEX FU – TAG_NAME U – STATUS_SINCE STATUS_UNTIL STATUS_SUMMARY NEXTGTAG_ID USED_FOR_TASK Deployment_Location CB_GT_TO_OIS P – CBG2O_INDEX FU – CBGT_INDEX FU – CBOI_INDEX TAG_LOCK_STATUS TAG_DESCRIPTION SYS_INSTIME CB_Schemas P – CBS_NAME CBS_SYSTEM CBS_DESC CB_OnOffs P – CBO_NAME CBO_DESC CB_NODES P – CBF_INDEX FU – CBOI_INDEX U – NODE_FULLPATH I – NODE_NAME NODE_ID NODE_PARENTID NODE_ISLEAF NODE_INSTIME LASTMOD_DATE CBF_LASTMOD_DATE NODE_DESCRIPTION FOLDER_VERSIONING I – CBF_NODE_PATH CBF_IOV_BASE CBF_ATT_TYPE CBF_CHAN_COUNT CBF_PAYLOAD_COUNT • GRAY tables: • Not filled • Dashed tables: • Not created CB_PColumns P – CBP_INDEX FU – CBF_INDEX U – CBP_COLUMN CBP_TYPE CBP_DESC CB_GT_TO_FTS P – CBG2F_INDEX FU – CBGT_INDEX FU – CBFT_INDEX CBAMI_GTAGS P – TAG_NAME IS_ACTIVE DATASET_COUNT DATE_FIRST_DATASET DATE_LAST_DATASET CB_FTAGS P – CBFT_INDEX FU – CBF_INDEX U – TAG_NAME TAG_LOCK_STATUS TAG_DESCRIPTION SYS_INSTIME CBFT_INSTIME CBFT_NODE_ID CBFT_ROWCOUNT CBFT_LAST_OBJTIME CBFT_SINCE_TIME CBFT_UNTIL_TIME CB_REFERENCES PF – CBF_INDEX FOLDER_IOVTABLENAME FOLDER_TAGTABLENAME FOLDER_IOV2TAGTABLENAME FOLDER_CHANNELTABLENAME FOLDER_PAYLOAD_EXTREF CBAMI_GTAG_USES TAG_NAME Project_Name Run_Start Run_End AMITag_Array ?