Lydia Pettis (convener)
Charlotte Whitt (minute taker)
|20||Demo Cornell Reports|
Lydia shows Annex Moves, moving books into long term storage (50% of the current reporting activities; 3 mill. books in the past 15 years, and expect to move 1 mill. books the next 5-8 years).
|Capture of screen dumps|
|10||Presentation - Reporting Database|
Nassib Nassar (Index Data) presents IndexData's approach to the Reporting Service.
FOLIO will have a reporting service separate from modules that actually provide data. Data for reporting will be accessed by a report generating tool. This tool will have direct access to a database schema.
FOLIO generally reduces the dependeny on a database schema, but in reporting there is no way of getting around this.
1st approach: replicate the operational database; operational database = "aggregates", a collection of databases
2nd approach: make two distinct databaes. 1. operational database 2. distcinct database for reporting, "data warehouse"
IndexData favors the data warehouse approach, they want to have two different schemas.
1st approach has points of failure, for example if operational database schema is changed.
Reporting database is going to look quite diffenrent from the operational database.
|20||Discussion re: Rpt DB|
Ann has two remarks:
A solution for "1." would be to replicate the reporting database.
"2." : the operational database does not only store data which are interesting for reporting (e.g. administrative metadata to the data sets).
Lydia: it is not unusual, in annex reports, to selec bibs and items. One of the specifications might be: Has this item circulated within the last 7 years ? I.e., it is not unusual to cross moduls, i.e. cataloging data and circulation data. It is not clear to Lydia what "aggregating" the data means (in Nassibs talk).
Nassib: Aggregation = Pulling the data form the different modules into a single (relational) database. But the tables in a relational database are virtually independent. Nassib will not use the term "aggregation" for this anymore.
Lydia: All the holdings should be pulled over to the reporting database.
|5||Planning for next sessioin|
20 minutes Reporting Demo by Ann Highsmith.
Lydia retires within the next weeks, we are looking for a convener until Cornell hires someone to replace Lydia (also as a convener).