(DRAFT)
Metadb is a new streaming data integration platform that will eventually replace the Library Data Platform (LDP 1.x) software used by FOLIO project participants for reporting on FOLIO data. Metadb is still under development. Some institutions are running early versions of Metadb for testing purposes.
Data updates
The LDP software provides reporting users with a copy of yesterday's data from the FOLIO application server. Metadb will provide streaming data updates from the FOLIO application server. This will provide reporting users with access to live FOLIO data in real time instead of yesterday's data.
Multiple Data Sources
Metadb is designed to be a general purpose data integration platform.
Report Development
Building report queries using the LDP software requires extracting some of the data from data arrays. By design, Metadb tables have data arrays broken out into columns, making it easier for query developers to use.
Special Features
Both LDP 1.x and Metadb include special features of interest to library reporting users. The ldpmarc tool currently converts SRS/MARC records from JSON to a tabular format for LDP 1.x. The ldpmarc tool will be ported to support Metadb. The LDP app provides a FOLIO interface for interacting with an LDP database. The Query builder in the LDP app allows you to build a simple query without using SQL with the option to save it for later use.
Borrow Direct move from Relais to Reshare
Cornell's Borrow Direct service is in the process of moving from Relais to Reshare. Institutions that participate in Reshare are running Metadb.
Resources
- (draft) Metadb documentation is available here: https://d1f3dtrg62pav.cloudfront.net/doc/
- Metadb-based query development for FOLIO: https://github.com/folio-org/folio-analytics/tree/main/sql_metadb
- https://github.com/metadb-project/metadb