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
