Embedded Files
Background
Background
For a long time, we never bothered to remove PDA records from the catalog when we received a license for the title from a vendor other than our PDA vendor, YBP. For example, if we received the title from Project MUSE, we might never realize that we also have a PDA record for the same title. This creates a duplicate record in the catalog and display. It can also result in wasted funds. The reasons for eschewing the search for duplicate records are that:
We don't spend so much on the PDA program that we were worried about the avoidable costs
Identifying the titles loaded in batches from vendors would be very time consuming given the cost savings.
New Tools
New Tools
With a better understanding of the data warehouse, we may have come up with a relatively cheap solution to the potential problems described above. By querying the data warehouse for PDA titles that have a corresponding licensed title, based on a matching ISBN, we may be able to reduce the costs of manually identifying the PDA records for licensed titles.
The Query
The Query
The query should be run against the data warehouse:
SELECT distinct a.BIB_DOC
, b.DISPLAY_TITLE
,i2.BIB_DOC_NUM, i2.ISBN, d2.DISPLAY_TITLE
FROM SB.AL_KEY_LINKS a
join SB.AL_TITLES b on a.BIB_DOC = b.BIB_DOC_NUM
join SB.AL_HOL_LOCN c on c.HOL_DOC_NUM = a.HOL_DOC
join SB.AL_ISBN i on a.BIB_DOC = i.BIB_DOC_NUM
join (
SB.AL_ISBN i2
join SB.AL_KEY_LINKS a2 on i2.BIB_DOC_NUM = a2.BIB_DOC
join SB.AL_HOL_LOCN c2 on c2.HOL_DOC_NUM = a2.HOL_DOC and c2.SUB_LIB = 'FAUER'
)on i2.ISBN = i.ISBN and i.BIB_DOC_NUM != i2.BIB_DOC_NUM
join SB.AL_TITLES d2 on i2.BIB_DOC_NUM = d2.BIB_DOC_NUM
where a.INST = 'FA'
and c.SUB_LIB in ('FADDA')
The Query Translated
The Query Translated
Select all Aleph Bib records where the sublibrary is FADDA.
Select all Aleph Bib records where the sublibrary is FAUER
Return any cases where the ISBN from the FADDA record is found in the FAUER records.
As a note, there were no DDA records without at least 1 ISBN.
Removal of DDA Records
Removal of DDA Records
Following verification of the matching criteria, records may be removed from the DDA records by using an Item-11 procedure.
Removed files will be placed in Z:\GenLoad\PDA Deduplication (\\lib-fs-2k12\libshare$\TECHSTAFF\Genload\PDA Deduplication)
Page updated
Report abuse