Page Comparison

...

The following SQL queries files are used for report generation in case of Initial Matching

View filenameTitle_Exception_Report_Query.sql

...

Ongoing Matching Algorithm

The Tables involved in Initial ongoing Matching Algorithm :

1. REPORT_T
2. REPORT_DATA_T

The following steps are involved in the Initial ongoing Matching Algorithm,

1. The first step is to fetch all the bibs that have been updated based on the last updated date in the bib from Solr.
2. The matchpoints of these bibs namely, ISBN, ISSN, LCCN, OCLC, are extracted and used in Solr query to find duplicates among the existing SCSB records.
3. On successful matching, the records (original as well as duplicates) are recorded in the REPORT_T and REPORT_DATA _T tables.
4. The items of the bibs are fetched from the DB. The use restriction of the items and a flag, INITIAL_MATCHING_DATE in the ITEM_T table are verified.
5. If the use restrictions are different, then the item having the least use restriction will remain ‘Shared’ and the rest would be marked as ‘Open’ for Monographs. In case of serials or MVM, all items’ CGD will be marked as ‘Open’.
6. If the use restrictions are same, then the item with date in the INITIAL_MATCHING_DATE column will be retained as ‘Shared’ and the other will be marked ‘Open’. If the INITIAL_MATCHING_DATE is empty, then the item which entered first (based on the CREATED_DATE column of ITEM_T table) is retained as ‘Shared’ and the rest are marked ‘Open’ for Monograph.
7. In case of Serials and MVMs, all the items’ CGD are marked as ‘Open’.
8. Finally, the reports are generated in the configured FTP location (/share/recap/matching-reports/prod).

...