Attendees: Serge, Daniel, Douglas, Jacek

db reviews will be renamed to:
  - "physical schema" --> "data products", it'll
    be project wide, not just dm-wide
  - "logical schema & qserv" --> "database architecture"


larger telecon (with KT, in2p3) planned for next
3rd week of each month), so Thu next week at 12pm pdt


need to update schema browser (add W13 schema)


Steve B. mentioned hyper-supreme-cam might be interested
in getting advice with db
  - they have plans to go up to 60 TB
  - 1h-oncePerMonth-level interactions would surely
    be useful for both sides


metadata (Jacek)
  - in-memory cache structures implemented, waiting
    for review
  - isRefMatch table flag implemented
  - ~2 more weeks to finish the work on integrating
    metadata into qserv, depends on interruptions
  - mention to in2p3 team that their ticket 2014 has
    been reviewed


Serge wrapping up work on partitioner tomorrow
  - then 1, max 2 weeks to wrap up work on duplicator


planning discussion
  - qserv needs to be modified to support refmatch
     - 2 weeks to implement using the old parser
     - or ~1/2 week using the (yet-unfinished) new parser
  - 2-3 weeks to finish the new parser
  - Serge can do the ref match plugging into qserv
    instead of work on thread scheduling
  - thread scheduling work touches the same code
    as shared scans
  --> revisit schedule for Serge next week


Daniel
  - done with exportpath, reviewed, merged,
    finishing documentation
  - back to writing parser (table aliasing)


Douglas:
  - w13 on lsst-db2, 2 installs (full, 1K objects) completed
     - proxy ports: 4040, 5040
  - had issues with how views were dumped
  - non-materialized views, especially if they have
    joins behind will be nontrivial to support in qserv
    --> avoid, or it will delay implementing core of qserv!
    --> and ask mysql gurus about potential issues
        related to views in mysql [Jacek]
  - test setup on yillies will be completed
    by beginning of next week

Jacek

########################################################################
Use REPLY-ALL to reply to list

To unsubscribe from the QSERV-L list, click the following link:
https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1