Warning, /RecoLuminosity/LumiDB/doc/lumidbschema.txt is written in an unsupported language. File is not indexed.
0001 Indices:
0002 create index hlt_runnum on hlt(runnum);
0003 create index hlt_cmslsnum on hlt(cmslsnum asc);
0004 create index trg_runnum on trg(runnum);
0005 create index trg_cmslsnum on trg(cmslsnum asc);
0006 create index lumisummary_runnum on lumisummary(runnum);
0007 create index lumisummary_cmslsnum on lumisummary(cmslsnum asc);
0008 create index lumisummary_lumiversion on lumisummary(lumiversion);
0009 create index cmsrunsummary_fillnum on cmsrunsummary(fillnum asc);
0010 create index cmsrunsummary_hltkey on cmsrunsummary(hltkey);
0011
0012 alter table CMSRUNSUMMARY add ("STARTTIME" timestamp(6) );
0013 alter table CMSRUNSUMMARY add ("STOPTIME" timestamp(6) );
0014
0015 alter table LUMIDETAIL drop constraint DETAILSOURCE;
0016 alter table LUMIDETAIL add (constraint DETAILSOURCE foreign key (LUMISUMMARY_ID) references LUMISUMMARY (LUMISUMMARY_ID) ON DELETE CASCADE);
0017
0018
0019 Glossary: FK=Foreign Key, PK=Primary Key
0020 lumiversion represents each lumi (re)processing
0021 ========
0022 table a: LUMIVALIDATION
0023 columns: runnum(uint32,PK), NOT NULL
0024 cmslsnum(uint32,PK), NOT NULL
0025 flag(string), NOT NULL (28)
0026 comment(string), NOT NULL (1024)
0027
0028 ========
0029 table 1: CMSRUNSUMMARY
0030 columns: runnum(uint32,PK), NOT NULL
0031 fillnum(uint32)
0032 sequence(string), NOT NULL 56
0033 hltkey(string), NOT NULL 128
0034 l1key(string), 128
0035 fillscheme(string), 128,
0036 ncollidingbunches (uint32),
0037 startime(timestamp(6)) ,
0038 stoptime(timestamp(6))
0039
0040 =======
0041 table 2: LUMISUMMARY (insert one row per run+lumiLS+lumiversion from LUMI_RAW file)
0042 columns:
0043 lumisummary_id(uint64, PK) NOT NULL
0044 runnum(uint32), NOT NULL range index
0045 cmslsnum(uint32),
0046 lumilsnum(uint32), NOT NULL
0047 lumiversion(string), NOT NULL 28
0048 dtnorm(float), NOT NULL
0049 lhcnorm(float), NOT NULL
0050 instlumi(float), NOT NULL
0051 instlumierror(float), NOT NULL
0052 instlumiquality(short), NOT NULL
0053 cmsalive(short), NOT NULL
0054 startorbit(uint32), NOT NULL
0055 numorbit(uint32), NOT NULL
0056 lumisectionquality(short) NOT NULL // use max 3 bits [HLX,HF,BRAN]
0057 beamenergy(float) NOT NULL
0058 beamstatus(string) NOT NULL 56
0059 cmsbxindexblob(blob)
0060 beamintensityblob_1(blob)
0061 beamintensityblob_2(blob)
0062 ======
0063 table 3: LUMIDETAIL (insert 1 rows per run+lumiLS+lumiversion+algorithm from LUMI_RAW file)
0064 columns:
0065 lumidetail_id(uint64, PK) NOT NULL
0066 lumisummary_id(FK refers to LUMISUMMARY.lumisummary_id), NOT NULL
0067 bxlumivalue(blob),//blob of float NOT NULL
0068 bxlumierror(blob), //blob of float NOT NULL
0069 bxlumiquality(blob), //blob of short NOT NULL
0070 algoname(string), //occ1,occ2,et,bran (28) NOT NULL
0071
0072 ======
0073 table 4: TRG (insert 192 rows per run+cmsls/populate from GT-DB)
0074 columns:
0075 trg_id(uint64, PK), NOT NULL
0076 runnum(uint32), NOT NULL range index
0077 cmslsnum(uint32), NOT NULL
0078 //lumi section id taken by cmsdaq,count from 1
0079 bitnum(uint32), NOT NULL //range : 0-127 algo;128-192 tech
0080 bitname(string), NOT NULL 128
0081 trgcount(uint32), NOT NULL
0082 deadtime(uint64), NOT NULL //deadtimebeamactive
0083 prescale(uint32), NOT NULL
0084
0085 alter table trg add constraint trg_unique UNIQUE( runnum,cmslsnum,bitnum) deferrable initially deferred NOVALIDATE;
0086 alter table trg enable NOVALIDATE constraint trg_unique;
0087 ======
0088 table 5: HLT (insert n-hltpath rows per run+cmsls/populate from RunInfo-HLT)
0089 hlt_id(uint64, PK), NOT NULL
0090 runnum(uint32), NOT NULL range index
0091 cmslsnum(uint32), NOT NULL
0092 pathname(string), NOT NULL 256
0093 inputcount(uint32), NOT NULL
0094 acceptcount(uint32), NOT NULL
0095 prescale(uint32) NOT NULL
0096
0097 ======
0098 table 6: TRGHLTMAP (insert 1 row per hltpath-l1seed / populated from ConfDB+L1Seed expression parser)
0099 hltkey(string), NOT NULL 128
0100 hltpathname(string), NOT NULL 256
0101 l1seed(string) NOT NULL 1024
0102
0103 ======
0104 table 7: FILLSCHEME (insert 1 row per fillscheme)
0105 fillscheme_id(uint64), NOT NULL PK
0106 fillschemepattern(string), NOT NULL (128)
0107 correctionfactor(float), NOT NULL
0108
0109 ====== other helper id tables======
0110 lumisummary_id, NEXTID (uint64,PK)
0111 lumidetail_id, NEXTID (uint64,PK),
0112 hlt_id, NEXTID (uint64),
0113 trg_id, NEXTID (uint64)
0114 fillscheme_id, NEXTID (uint64)
0115
0116 From LumiProducer, we query lumisummary,lumidetail,trg,hlt data in 100 LS(tunable parameter) batch into memory in one DB connection then close the connection. When a new LS is requested, we open a new DB connection asking for this LS+100 into memory.
0117