Database meeting 2023-02-01

Fritz Mueller:

• generator power at Summit due to power line maintenance from the "mainland" to Summit
• no major news from TCAM; everyone is getting ready for joined operations review (SLAC, end of February); A chance of Qserv demo (via notebooks)
• DP03 is gaining more attention on DMLT (it's now on the weekly agenda) 
• DP03 won't be ingested into Qserv. This is the Solar System catalog.

Colin Slater :

• no formal requirements document yet for DP03 from GPDF

Fritz Mueller on the baseline ("aspirational") schema changes:

• the current version doesn't correspond to the pipeline reality
• many view the schema from the pipeline perspective and find some aspects of the schema confusing
• it's useful for us (the DAX team) to have some reference documents even though they may not be fully compatible with the ongoing data model of the pipeline
• no schema browser exists yet for the "aspirational") schema

Colin Slater (to continue on the subject)

• the situation has changed significantly over the last 2 years
• before DP02 no tables were generated, and other tables looked differently; now the DP02 covers ~90% of the baseline schema; there will be differences in the number of columns, column names, and data types 

Fritz Mueller: reasons, solution, lessons?

John Gates: Any further progress? 

Fritz Mueller: Are we going to deploy and test the new Qserv release 2023.1.1-rc2  at IDF this week? 

Fabrice Jammes