WorldCat Availbilty Query service Overview

The WorldCat Availability Query Service (AQ) works with PIR to provide holdings and availability information to the Request service to identify possible UC lenders. This is parallel to the Holdings and availability information current Melvyl supplies to the Request service. RSC-IAG asked to CDL to document this process. The information is intended for use by ILL staff and interested public services staff.

The AQ service provides holdings and availability information for Requests generated from a record in Next Generation Melvyl (NGM) and for requests generated from the special UC Order function in PubMed and requests generated in UC-eLinks/Citation Linker. The document presents two scenarios:

  • Requesting an item from NGM
  • Requesting an item via UC-eLinks

Instructions on how to view the information passed to Request in the OpenURL from NGM or UC-eLinks are included to aid in understanding why some bibliographic information may not be passed into VDX.

Scenario one: User makes a request from Next Generation Melvyl (NGM)

User makes a request from an NGM record.

NGM (aka WorldCat Local) sends OpenURL v 1.0 containing the bibliographic data, including the OCLC number for the record to Request, along with the UC campus identifiers indicating campus holdings in the record.

The example used throughout this document is the item

Author: / Kiley, Michael T.
Title: / How should unemployment benefits respond to the business cycle? [electronic resource] / Michael T. Kiley.
Publisher: / Washington, D.C. : Federal Reserve Board, [2003]
Format: / Book; Government Document; Online
Series: / Finance and economics discussion series ; 2003-01

Request User Interface

Request parses the OpenURL into the component bibliographic fields for user review (see Appendix I); collects enduser account information and passes this to PIR Authentication Service (PIRAuth.) This parallels the process used in current Melvyl.

After PIRAuth validates the user, Request checks the SFX database for both CDL (systemwide licensed) and the user’s home campus (from the Request form)licensed econtent to determine if an electronic copy of the item may be available.

If SFX responds with the information indicating the item may be available electronically, then the user is offered a link to the electronic version. If user chooses electronic version, the Request session ends, if user continues with Request the Request is passed to PIR

Request/PIR Processing

The Request service PIR program queries the NGM AQ service for UC holdings using the OCLC number passed in the OpenURL from NGM and UC the campus Identifiers

If UC holdings are returneD

PIR goes through the standard routine of load balancing and creating a rota. The request is then sent to VDX.

Note: AQ only returns holdings for the original OCLC number. Although there may be additional UC holdings for the same item attached to a different OCLC number. These other UC holdings will not be attached. [1]

If no UC holdings are returned

PIR drops the OCLC number, and resends the query and AQ looks for a match using data from the OpenURL, e.g., ISSN or ISBN, or title of whole item. (This is done in case the user began from a non-UC record in order to look for UC holdings for the item.)

NGM AQ service Processing for NGM items

Step one: the OCLC number passed to Request has UC holdings

All requests from NGM have OCLC numbers. Requests that do not originate in NGM (with the exception of current Melvyl and some FirstSearch databases) do not have OCLC numbers, such as Scenario Two

If the OCLC number passed to Request does not have UC holdings attached, go to Step 2

If the OCLC number passed to Request has UC holdings attached, go to Step 4

Step two: the OCLC number passed to Request has no UC holdings use ISxN

PIR drops the OCLC number and sends the ISSN or ISBN (ISxN) from the OpenURL (this is parallel to the steps used for items from UC-eLinks) to look for a record with UC holdings. (

ISSN matching

ISSN subfield rules follow UC-eLinks rules, i.e., matches are made only to the active ISSN e.g., 022 $a[2], not subfields containing incorrect (022 $y or canceled (022 $z) ISSNs. The fields used for matching are: 022$a; 440$ ; 490$x; 830$x

ISBN matching

ISBN subfield rules follow UC-eLinks rules, i.e., matches are made only to the active ISBN e.g., 020 $a,and not to subfields containing incorrect or canceled ISBN.

OCLC will match on both ISBN and ISBN 13; OCLC match algorithm prefers ISBN 13 and sends this in the OpenURL. PIR will check using ISBN 10 if no results from ISBN 13.

Note: These are same data elements current Melvyl used to match on items coming from Request.

If the OpenURL does not contain a standard number (ISSN OR ISBN), then go to step 3;

If an ISxN match is made, go to step 4.

Step three: check for holdings matching On the item title

Search for a title match using the contents of the jtitle (journal title) or btitle (book title) of the OpenURL

Match the item “title” (jtitle for journals, btitle for books) in the OpenURL to the 245$a (title) or 246$a (variant title) or 773 $t(host item title) in NGM. Title match it is made title keyword; not a left anchored title phrase. This is not the same title match used in current Melvyl. Current Melvyl uses a left anchored phrase title match.

If a match is made, go to Step 4

If a match is not made, skip Step 4, send item to VDX marked for home campus ILL staff review

Step Four Check for monographic series indicators

Once a match is made to an NGM record, the NGM matching service looks for a monographic series indicator (MARC 008/21 =m)

  • if there is no mono-series indicator, then the holdings for the matched record(s) are sent to PIR
  • if there is a mono-series indicator, then NGM runs the routine for Monographic Series holdings

starting from a Serial record for an item in a monographic series

If ISSN present: ISSN from 022$a plusthe volume number from the 440$v 830$v or 490$v volume

  • Use the contents of the 022$a in the serial to match to the 440$x, 830$x or 490$x (in this order) of the monographic record

If no ISSN present: Use title plus volume from the 440$v 830$v or 490$v volume

  • AQ uses the title 245$a, or 245$a$b in serial item to match to the title 440$a, 830$a, or 490$a in the series title. If no 245 or 246 the 210 $a (abbreviated title) if present is used for matching

starting from a Monograph record with a series tracing

  • ISSN for the series in the 440$x, 830$x or 490$x (in this order) is used for matching to the serial record’s ISSN in the 022$a
  • If no ISSN, the series title in the 440$a, 830$a or 490$a is used to match to the serial record’s title in the 245$a ( whole item title) or the 246 $a (whole item variant title)

Note: OCLC will match on truncated titles or titles that differ by a single word. This may cause incorrect matches.

If UC holdings are found for a mono-series match:

  • Holdings and OCLC number(s) are passed to PIR. PIR handles load balancing; creates the rota; and sends the request to VDX.

If UC holdings are notfound for a mono series match

  • PIR sends the item to VDX with matches to the original item (if any) or sends an empty Rota to VDX.

Request/PIR/VDX and the WorldCat Availability Query Service3Feb2011saw; last update 1March12011saw1

Scenario 2: User makes a request via UC-eLinks from a licensed database

UC-eLinks sends an OpenURL v 0.1 containing the bibliographic data to Request.

Request User Interface

Request parses the OpenURL into the component bibliographic fields for user review; collects enduser account information and passes this to PIR Authentication Service (PIRAuth) and PIRAuth validates the user against home campus patron database.

Request checks the SFX database for CDL and user’s home campus to check if an electronic copy of the item may be available. If SFX responds with the information indicating the item may be available electronically, then the user is offered a link to the electronic version. If user chooses electronic version; Request session ends. if User continues the request is passed to PIR.

Request/PIR Processing

PIR converts the OpenURL v 0.1 to OpenURL v 1.0.for NGM processing and then PIR passes the OpenURL v 1.0 to the NGM AQ/Fulfillment server.

The bibliographic information in the OpenURL is the only information Request has to pass to VDX

NGM AQ service Processing for items from Article databases

PIR sends the OpenURL from UC-eLinks to the AQ service.AQ passes the information to the OCLC’s Best Match service (OU Match), which returns holdings to AQ which then checks for availability and returns information to PIR

Step one: the OpenURL contains an OCLC number

Requests that originate in of current Melvyl and some FirstSearch databases have OCLC numbers passed in the OpenURL. The best match service uses the OCLC number from the OpenURL to find a match in NGM.

If the OCLC number passed to Request matches an item with no UC holdings attached, go to Step 2

If the OCLC number passed to Request matches an item with UC holdings attached, go to Step 4

Step two: No OCLC number passed to RequesT, Check for UC holdings using ISxN

ISSN matching is done against the 022 $a in the OCLC record; ISBN matching is done against the 020$a in the OCLC record.

This is parallel to the process used when an item from WorldCat has no UC holdings, and PIR sends a second query using the bib information, but dropping the OpenURL and to the process used when holdings were obtained from current Melvyl.

If the OpenURL does not contain a standard number (ISSN OR ISBN), then go to Step 3, if match go to Step 4.

Step THREE: If no ISxN in record then the check for match to whole item title

Search for a title match using the contents of the jtitle (journal title) or btitle (book title) of the OpenURL

Match the item “title” (jtitle for journals, btitle for books) in the OpenURL to the 245$a (title) or 246$a (variant title) in NGM

OCLC will match on truncated titles or titles that differ by a single word. This may cause incorrect matches.

Check the NGM matched record for the MARC indicator for mono-series go in Step 3.

Step Three Check for monographic series indicator 1

Once a match is made to an NGM record, the NGM matching service looks for a monographic series indicator (MARC 008/21=m)

  • if there is no indicator, then the holdings for the matched record(s) are sent to PIR
  • if there is the mono-series indicator then NGM runs the routine for Monographic Series holdings

starting from a Matched SERIAL record for an item withAMono-series indicator

Fields used for matching:

ISSN from 022$a plus volume number from the 440$v 830$v or 490$v volume or

  • Use the contents of the 022$a in the serial to match to the 440$x, 830$x or 490$x (in this order) of the monographic record

If no ISSN Title plus volume from the 440$v 830$v or 490$v volume

  • AQ uses the title 245$a, or 245$a$b in serial item to match to the title 440$a, 830$a, or 490$a in the series title. If no 245 or 246 the 210 $a (abbreviated title) if present is used for matching

starting from a Monograph record with a Mono-series indicator

  • ISSN for the series in the 440$x, 830$x or 490$x (in this order) is used for matching to the serial record’s ISSN in the 022$a
  • If no ISSN the series title in the 440$a, 830$a or 490$a is used to match to the serial record’s title in the 245$a ( whole item title) or the 246 $a (whole item variant title)
  • 440$v 830$v or 490$v is volume number this is not used for matching

Note: OCLC will match on truncated titles or titles that differ by a single word. THis may cause incorrect matches.

If UC holdings are found for a mono-series match:

  • Holdings and OCLC number(s) are passed to PIR. PIR handles load balancing; creates the rota; and sends the request to VDX.

If UC holdings are notfound for a mono series match

  • PIR sends the item to VDX with matches to the original item (if any) or sends an empty Rota to VDX.

Request/PIR/VDX and the WorldCat Availability Query Service3Feb2011saw; last update 1March12011saw1

Appendix I Interpreting OpenURLs

The bibliographic data in the OpenURL is the only data included in the VDX record.

The quality of the OpenURL determines the quality of the VDX bibliographic record.

This section shows how to identify the key information in an OpenURL sent to Request from NGM or from an article database via UC-eLinks.

Two examples for the same item follow one from an NGM record and one for the same item in an A&I database. The item is part of a monographic series.

NGM Record for a volume in a monographic series

Sample OpenURL Sent to Request by WCL for Item in monoseries

The OpenURL contains all of the information sent to the Request service. Request passes all of this information to VDX. You can copy the OpenURL from the navigation box of the Request form page and paste it into a Word document to see the bibliographic information being passed from the catalog.

To make the OpenURL easier to read: Paste the OpenURL from the navigation box on the Request form page into MS Word. Replace the ampersand (&) with ^p&

rfr_id=info%3Asid%2Fmelvyl.worldcat.org%3Aworldcat

rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook

req_dat=%3Csessionid%3E

rfe_dat=%3Caccessionnumber%3E52225529%3C%2Faccessionnumber%3E

rft_id=info%3Aoclcnum%2F52225529

rft.aulast=Kiley

rft.aufirst=Michael

rft.auinitm=T

rft.btitle=How+should+unemployment+benefits+respond+to+the+business+cycle%3F

rft.date=2003

rft.aucorp=Board+of+Governors+of+the+Federal+Reserve+System+%28U.S.%29

rft.place=Washington++D.C.

rft.pub=Divisions+of+Research+%26+Statistics+and+Monetary+Affairs++Federal+Reserve+Board

rft.genre=book

rft.identifier=HD7095.U5+K56+2003

req_id=info%3Arfa%2Foclc%2FInstitutions%2F5683

OCLC passed this Item to Request as a book. the series information is not included in the OpenURL.

VDX record

Windows

--snip---

Rota is populated

Web

--snip---

EBSCOHost Business Source Complete database

Looking for the same item in a licensed database

EBSCOHost Business Source Complete passed this as an article with the series title in the OpenURL.

atitle=How%20Should%20Unemployment%20Benefits%20Respond%20to%20the%20Business%20Cycle%3F&spage=1&genre=article&day=1&epage=30&pages=1-30&title=Working+Papers+-+US+Federal+Reserve+Board%27s+Finance+and+Economic+Discussion+Series&year=2003&date=20030101&pid=institute%3DUCOP

To make the OpenURL easier to read: Paste the OpenURL from the navigation box on the Request form page into MS Word. Replace the ampersand (&) with ^p&

The OpenURL passed from UC-eLinks to Request

&xxx=yyy

&sid=UCLinks-EBSCO%3Abth

&aulast=Kiley

&month=1

&atitle=How%20Should%20Unemployment%20Benefits%20Respond%20to%20the%20Business%20Cycle%3F

&spage=1

&genre=article

&day=1

&epage=30

&pages=1-30

&title=Working+Papers+-+US+Federal+Reserve+Board%27s+Finance+and+Economic+Discussion+Series

&year=2003

&date=20030101

&pid=institute%3DUCOP

VDX record

Windows

--snip---

Rota is empty

Web

Change from OTHER TO “Part of Book” to see details

Request/PIR/VDX and the WorldCat Availability Query Service3Feb2011saw; last update 1March12011saw1

[1] This is often the reason an ILL Request comes in for an item held at the home campus. The home campus holdings are on a different OCLC record.

[2] Explanations of MARC fields can be found at the Library of Congress Marc 21 site