Metadb is a new reporting database architecture that will eventually replace the Library Data Platform (LDP) software used by FOLIO project participants for reporting on FOLIO data. Metadb is now in beta release.
Benefits
Data updates
The Metadb will provide near real time data via continuous data streams from the FOLIO application server to FOLIO reporting users. By comparison, the LDP software provides reporting users with a copy of yesterday's data from the FOLIO application server. Metadb also will be easier for query developers to use because most data coming from the FOLIO system via data arrays will be broken out into data columns Metadb will provide continuous data updates from the FOLIO application server. This will provider reporting users with access to real-time FOLIO data.
Multiple Data Sources
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.
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
...