[Halld] Updated Translation Table

[Richard Jones]

Hello David,

What is this thing you call "the SQLite DB"? I know of a SQLite export of
the CCDB, and I have heard of a SQLite export of RCDB that might be
possible. Is this a third SQLite DB?

It sounds like you are describing a re-formatting of the TT xml file
contents as a relational database table, and then exporting this table to
SQLite? I have never heard of or worked with this relDB rendering of the TT
document. As someone who updates the TT record in ccdb from time to time,
it sounds like I need to know what you are talking about here. The xml
document is the only thing I have ever worked with. Is there a HOWTO on
this?

-Richard Jones

On Fri, Jan 4, 2019 at 1:52 PM David Lawrence <davidl at jlab.org> wrote:

> Hi All,
>
>   This is a head’s up that I just added a new translation table entry to
> the CCDB that includes
> all of the DIRC channels as provided by Justin. This is significant for a
> couple of reasons.
> One of them being that the DIRC increases the channel count from ~23k to
> ~37k.
>
> The other is that the procedure used to produce the XML file is somewhat
> new. It was generated
> from the SQLite DB file that has been updated to include run range
> information. The DB file
> was first updated by mining data from the CCDB, then the DIRC channels
> were added, then
> the XML file was generated and inserted into the CCDB. Note that ALL
> future changes to the TT
> should be done in the SQLite DB first and the XML then generated from
> that. Please contact me
> if you need help with this.
>
> Both Justin and I have done some testing and it seems the new TT does not
> break anything.
> It is marked as valid only for runs >=60000 in the CCDB so people
> generally will not be
> affected by it until they start processing files from the upcoming
> RunPeriod-2019-01 data set.
>
> Thanks to Justin for doing a lot of the heavy lifting on getting all of
> the DIRC channels into the tt.db
>
>
> Regards,
> -David
>
> -------------------------------------------------------------
> David Lawrence Ph.D.
> Staff Scientist, Thomas Jefferson National Accelerator Facility
> Newport News, VA
> davidl at jlab.org
> (757) 269-5567 W
> (757) 746-6697 C
>
>
>
> _______________________________________________
> Halld mailing list
> Halld at jlab.org
>
> https://urldefense.proofpoint.com/v2/url?u=https-3A__na01.safelinks.protection.outlook.com_-3Furl-3Dhttps-253A-252F-252Fmailman.jlab.org-252Fmailman-252Flistinfo-252Fhalld-26amp-3Bdata-3D02-257C01-257Crichard.t.jones-2540uconn.edu-257Cac29ab0e983643a6c7fc08d67275c837-257C17f1a87e2a254eaab9df9d439034b080-257C0-257C0-257C636822247531818362-26amp-3Bsdata-3DR2SZNOYc9Ab0VhYvZm-252Bs-252Flpt9AIFkNElJE2YbRVI33w-253D-26amp-3Breserved-3D0&d=DwIFaQ&c=lz9TcOasaINaaC3U7FbMev2lsutwpI4--09aP8Lu18s&r=Mwj7jqW_Gg8VvugDHdwA5w&m=1l9SXJy5CSSz5msqakIxtrGKs6tI84lyiWhJ8Dc8MVM&s=15oyQ5jMxZf3r2afyIpdp5FuYSciCRswihRuIXNTDa4&e= 
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/halld/attachments/20190104/f20885ee/attachment.html>