2017-09-25 - Reporting SIG Notes

5

Welcome

Ingolf

5

Introductions

Ingolf

Welcome to new member John McDonald

John is the new EBSCO Director of Product Management, Analytics & Assessment

20

Summary on Developers' Meeting

@Peter Murray

Peter reports from developers' meeting in Montreal Sept 18-20 (Slides)

Organization of Development:

Recap of operational goals:

• UX process to capture and distill library requirements

• Implement V1; core library functionality

• Construct an extensible platform that 3rd parties can use

• development is not really an agile project, as developers work from a distance

• Main Responsible Persons are: @Jakub Skoczen (Development Lead), @Cate Boerema (Deactivated) (Product Owner), @Filip Jakobsen (User Experience Lead)

• There are 2 development phases:

1. Rough-In (phase 1)

2. Refinement Phase

• User-Apps has gone through the Rough-In phase and will be the first App to go through the Refinement phase.

• Relevant documents / plans and responsible persons: V1 Scope Spreadsheet (@Hkaplanian), UX design (@Filip Jakobsen)

• Product owners then create manageable User Stories. Issues on https://folio-org.atlassian.net .

• Feedback / discussion in the Sprint Reviews (Recording of last sprint review: https://drive.google.com/file/d/0B7-0x1EqPZQKdkgxVGJHN19Semc/view)

• User Acceptance Testing by the SIGs hasn't started yet

FOLIO-UX-Update (Filip): CSS Layers (skeletal styling - host scheme - end user scheme), Preferences (tenant preferences, end user preferences)

• User Experience Documentation

• Resource Management (see slides)
  
  
  

• Dev Ops - next steps

• Define preliminary test infrastructure

• Document initial performance goals/expectations

• Define data migration requirements

• Create toolkits for library profiling, data migration

• Load real library user data

• Define external integration requirements
  ==> Looking for more participants in the Dev Ops & Management SIG, Systems Operations and Management SIG Home , People from OLE institutions.

20

RDBS Database model for reporting

Ingolf

I presented my first sketch of an RDBS database model. The model is designed using MySQL Workbench. It is desirable to have a more social software tool to be able to design the database model in an agile way. I tried with https://www.genmymodel.com/, but the free version is to small (doesn't capture enough data).

The model consists of a set of database tables. The tables are related to each other by 1:N - relationships or 1:1-relationships. These relationships can be mandatory or optional. Each database table consists of a set of datafields. The datafields at least have a name and a data type.

My target was to inlucde any data field which appears in the Reporting SIG Master Spreadsheet (https://drive.google.com/open?id=1svUM74Dkg4KvTXLzKZK_2k_SxeukX-87NnYf8CaTrYQ) in this model - and of course the model must be enlarged to include ANY field which we will ever need in reporting!

I put comments from the Master Spreadsheet to this model. The comments can appear at the table level and at the field level. I also put the IDs of the reports that use this field for some fields (where the usage of the field is not clear).

The outcome reminds me of the relational database model used in Kuali OLE - not surprisingly.

I haven't finished with the model yet, i.e. didn't go through the whole Master Spreadsheet, I will do so.

I will put the model - exported as PDF files - into the Reporting SIG Google Drive folder.

Comments from the group:

• (Peter) : presenting bibliographic records as MARC records is too restricted, this must be generalized and be replaced by Codex objects.

• there should be more emphasize on electronic resources, which should manifest itself in the design of the model

• there is not yet a Product Owner for Reporting