Here are a series of data checks between the LDP and Metadb to verify the accuracy of Metadb data after the February 7-9 software updates
| Date | Test | LDP Results | Metadb Results | Notes | Tester |
|---|---|---|---|---|---|
|
|
| Never mind - sorry. I'm getting the same results now, so maybe I did something wrong yesterday. | ||
| 2/10/25 | instance_hrid rows created in the MARC table | 706907713 srs_marctab | 706873319 folio_source_record.marc__t | Natalya | |
| 2/11/25 | instance_hrid rows created in the MARC table | 706928287 srs_marctab | 706930661 marc__t | the difference is larger than expected for number of lines per records added; 2374 lines for 12 records | Natalya |
| 02/11/25 | Number of records created on 02/10/25 | 296 | 308 | Natalya | |
| 02/11/25 | Number of instance_ids | 10 941 477 srs_records | 10 941 510 folio_source_record.records_lb | Natalya | |
| 2/14/25 | Sharon | ||||
| 2/12/25 | instances, holdings, loans, items | 11057387instances 11888237holdings 788550 loans 9830875 items | 11057411 instances 11888244 holdings 788691 loans 9830964 items | Sharon | |
| 2/12/25 | marc records | 22512156 srs_marc ids 706941483 srs_marc_tab instances 11002150 srs_marc_tab 001 11002150 srs_marc_tab 999i 11002150 srs_records instances | 22513863 srs_marc ids 706943858 srs_marc_tab instances 11002177 srs_marc_tab 001 11002177 srs_marc_tab 999i 11002165 srs_records instances | Sharon | |
| 2/11/25 | instances, holdings, loans, items | 11057210 instances 11887996 holdings 787110 loans 9830540 items | 11057224 instances 11887999 holdings 787291 loans 9830547 items | metadb counts slightly higher | Sharon |
| 2/11/25 | marc records | 22511684 srs_marc ids 706928287 srs_marc_tab instances 11002043 srs_marc_tab 001 11002043 srs_marc_tab 999i 11002043 srs_records instances | 22513379 srs_marc ids 706930661 srs_marc_tab instances 11002068 srs_marc_tab 001 11002068 srs_marc_tab 999i 11002052 srs_records instances | metadb counts slightly higher | |
| 2/10/25 | Count of pol_ids from primary tables, 1-15-25 through 2-9-25 LDP: po-lines Metadb: folio_orders.po_line | 1,387 | 1,387 | Joanne | |
| 2/10/25 | Count of item_ids from primary tables, 1-15-25 through 2-9-25. LDP: inventory_items Metadb: folio_inventory.item | 8,953 | 8,927 | LDP count is higher. Maybe items were deleted today that had previously been created before today? | Joanne |
| 2/10/25 | Count of loan_ids from primary tables 1-15-25 through 2-9-25 LDP: circulation_loans Metadb: folio_circulation.loan | 21,725 | 21,693 with "date"; 21,727 with "timestamptz" | Total of loan_ids change for Metadb when casting the date as "timestamptz." Date types don't make a difference in the totals for LDP. | Joanne |
| 2/10/25 | Count of holdings_ids from derived tables, created 1-15-25 through 2-9-25 LDP: folio_reporting.holdings_ext metadb: folio_derived.holdings_ext | 14,206 | 12,565 | LDP greater. Metadb is missing counts for 2-4-25 through 2-9-25 inclusive in the sample date range; there may be other gaps | Joanne |
| 2/10/25 | Count of holdings_id from primary tables, 1-15-25 through 2-9-25 LDP: inventory_holdings Metadb: folio_inventory.holdings_record | 14,206 | 14,206 | They match in the primary tables, with date fields cast as "date" | Joanne |
| 2/14/25 | Count instance_ids created 1-15-25 through 2-12-25 instance__t instance_ext | 17,422 inventory_instances (using "timestamptz" or "date") 17,422 instance_ext (using "timestamptz" or "date") | 17,422 instance__t (using "timestamptz" or "date") 17,422 instance_ext (using "timestamptz" or "date") | Joanne | |
| 2/11/25 | See Comparison of CR243 and MCR243 | See Comparison of CR243 and MCR243 | Sharon |
Lessons Learned and Notes:
-run tests and document results prior to system updates, then run same tests again and compare results
-compare saved results of reports run previously, but with same date ranges to capture results
Current Issues:
-holdings_ext has not been updated since February 3rd;