Page History

The FOLIO (Future of Libraries is Open) library system provides support for transactional data entry, storage, and usage to staff members in the Cornell Library. Functional data areas for the data include accounting, circulation, cataloging, acquisitions, collection development, and collection management. Reporting services for that data are providing through the FOLIO LDP (Library Data Platform) reporting databaseMetadb reporting database. Metadb software is developed by Index Data and supported by the Open Library Foundation. Reporting users may access data by running SQL queries using DBeaver, interacting with Tableau data visualizations, and downloading data directly from the transactional FOLIO application system. The Reporting Team provides support to library staff by creating and maintaining a library of SQL queries, automated reports, and data visualizations through Tableau on Cornell's Tableau server. 

...

FOLIO data in the Metadb reporting database are somewhat normalized. Some of the data is left untransformed in data arrays and must be extracted using specific JSON extract data functions in SQL. Queries against data in the Metadb reporting database have many joins because there are many tables. The FOLIO Reporting SIG has created derived tables to make it easier to report on collections of related data. It also helps to create indexes on tables that are filtered within queries.

Image Modified