Page Comparison

Attendance & Notes

• Today's attendance-taker: Linda Miller
• Today's note-takers:  Team Leads for project updates

Project updates

The Reporting SIG is using small working groups to address priorities and complete our work.  Each week, we will provide updates to the Reporting SIG from these various reporting-related groups and efforts. Please include updates on specific JIRA issues for prototype or query development workflow. Do we need to create any additional JIRA tickets?

Community & Coordination: 

• working on reporting survey

News from the LDP Project:

• no updates

FOLIO Reporting development:

1. Reporting reference environment: folio_release is now deprecated because the FOLIO source does not appear to be maintained at present.  Please use switch to using folio_snapshot instead when convenient (not urgent).
2. Reviewing approaches to query factoring
   
   1. Pre-computing joins
   2. Pre-computing "with" clauses (aka CTEs or common table expressions)
   3. Combining "with" clauses that use the same table
   4. Preparing intermediate/derived tables
      1. Adding the local schema to the search path (optional)
      2. Creating indexes
      3. Vacuuming and analyzing
   5. Beginning to think about defining commonly useful derived tables (after Forum)
      1. Commonly used JSON fields not currently available in relational attributes
      2. Commonly used denormalizing joins
      3. Other commonly used joins or data extraction
   6. Automatic regeneration of tables
   7. Creating subsets of large data

Reporting Data Privacy Working Group:

• active borrowers count increment

RA/UM Working Group

• ?

MM Working Group

• for latest updates, see RM Prototype and Query Development Status

ERM Working Group

• for latest updates, see ERM Prototype and Query Development Status