OCLC Connexion Derived Search

To: Technical Services Staff
From: Steven Arakawa
Date: (Apr. 19 2005 creation date/ 04/28/2005 12:18 PM revision date)

Basic derived sequences (roughly in order of usefulness for retrieving specific records)

title: 3,2,2,1 <CAUTION: the title derive search only searches the title proper $a; unless the cataloging library has cheated, entering parts of $b will result in no hits>

name/title: 4,4

personal name: 4,3,1 <include the 2nd comma even if there is no middle name>

corporate name: =4,3,1 <stop-words must not be included & corporate names have many; refer to Connexion help>

Use a slash (/) to qualify by format and date for greater precision. The slash qualifiers are always entered last. You can use only one slash qualifier per type, i.e. you can qualify ... /bks/1990 but not ... bks/vis/1990.

To search for Patrick O'Brian's novel Master and commander, published 1990.

obri,mast/bks/1990 <author/title search qualified by format & precise year>

To search for videos of Master and commander, released after 2000.

mas,an,co,/vis/200? <title search qualified by format & truncated year>

Note that even if there is no final element in a derived search, you still need to include the comma. Format types are: bks, com <computer files>, map, mix <mixed materials>, sco, ser, rec, vis. You cannot combine the guided search qualifiers with command line searches, i.e. you cannot use obri,mast at the Command Line level & select Books and 1990 in the Keyword/Numeric search section to qualify the search.

If you're a really hardcore OCLC searcher, you can combine derived searches. When combining derived searches, you must include the derived searching index labels. CAUTION: the labels were changed with version 1.3. The new labels are in the Client Connexion Help and a PDF document on the web (see RELATED DOCUMENTS).

pd: obri,pat, and td: mas,an,co,/bks/1990

or with an additional language qualifier:

pd: obri,pat, and td: mas,an,co, and la:english/bks/1990

You're more likely to use the combined search to retrieve serial records where the initial title word is generic and isn't a stopword.

TIP: the equal sign (=) that normally precedes the derive search for corporate names is not included when indexing labels are used.

To search for the serial Bulletin of the Battle Creek Sanitarium and Hospital Clinic (issuing body Battle Creek Sanitarium and Hospital Clinic), a combined derive search qualified by format looks like this:

cd:batt,cre,s and td:bul,of,th,b/ser
NOT cd:=batt,cre,s and td:bul,of,th,b/ser

However, a keyword search qualified by the serial format would work just as well.

EXAMPLES

Title Derived (3,2,21). No minimum key. For Keyword, you must select the Title Derived (td:) index from the list

To find: Command Line Keyword Index is:
Title Derived (td:)

Jiwa Islam : organ Gerakan Pemuda Islam Indonesia. 1999. <subtitle cannot be used in a derived title search; all 3 commas must be entered even if the title is less than 4 words>
jiw,is,,/1999

Qualify if the title is short to increase precision
jiw,is,,
AND YEARS
1999

Attack! [videorecording]. c2003. <DVD of a 1956 motion picture; previously released on VHS> att,,,/vis/2003

(retrieves record for DVD & one other 2003 DVD: Attention)
att,,,
AND FORMAT
Visual Materials
AND YEARS
2003

The best 10 minutes of your life.
<initial article is not included in the derived search> bes,10,mi,o
bes,10,mi,o

Symposium on the aging agenda for the 103rd Congress ... 1993. <compare the corp/conf derived search example Symposium on a New International Order; no stop words in title derives> sym,on,th,a/1993

sym,on,th,a
AND YEARS
1993

Corporate/Conference Derived (4,3,1). For Keyword, you must select the Corp/Conf Derived (cd:) index from the list. All of the corporate name examples are from the OCLC documentation.

To find: Command Line Keyword Index is:
Corp/Conf Derived (cd:)

Hershey Foods Corporation
=hers,foo,c
OR
cd:hers,foo,c
hers,foo,c

American Rock Garden Society
["American" is a stop word if it is the 1st word of the title] =rock,gar,s
OR
cd:rock,gar,s rock,gar,s

Adrian College =adri,col,
OR
cd:adri,col, adri,col

Symposium on a New International Order <"symposium," "on," and "a" at the beginning of a corp/conf name are all stop words> =new,int,o
OR
cd:new,int,o new,int,o

Name/Title Derived (4,4). For Keyword, you must select the Name/Title Derived (cd:) index from the list

To find: Command Line Keyword Index is:
Name/Title Derived (nd:)

Trollope, Anthony. He knew he was right. 1974.
trol,he/1974

trol,he
AND YEARS
1974

Persichetti, Vincent. Fanfare for two trumpets. <musical score> pers,fanf/sco
pers/fanf
AND FORMAT
Musical Scores

Feidelson, Charles. Symbolism and American literature. (To view all editions in WorldCat) feid,symb
feid,symb

Personal Name Derived (4,3,1). For Keyword, you must select the Personal Name Derived (pd:) index from the list. The maximum retrieval allowed is apparently ca. 1500.

To find: Command Line Keyword Index is:
Personal Name Derived (pd:)

Madonna, 1958-
mado,^,^

mado,^,^

Lloyd Webber, Andrew, 1948- lloy,and,^
lloy,and,^

McCauley, Rebecca Joan, 1952
<if the name begins with Mc or Mac followed by an uppercase letter, type m & omit c or ac>
mcau,reb,j
mcau,reb,j

"Big names" should be used in combined derived searches (see the next section) or with a qualifier to maximize precision.

Combined derived searches. For Keyword, you must select the Personal Name Derived (pd:) index from the list. Keyword (non-derived) indexes are probably easier to use unless you have an OCLC background.

To find: Command Line Keyword Index is:

Madonna, 1958- . The English roses.
pd:mado,^,^ and td:eng,ro,,
<for combined derived searches at the Command Line, index label is required>

Index:
Personal Name Derived (pd:) mado,^,^
AND Index:
Title derived (td:)
eng,ro,,

Lloyd Webber, Andrew, 1948-. Andrew Lloyd Webber showstoppers : playalong for clarinet. <musical score> pd:lloy,and,^ and td:and,ll,we,s/sco Index:
Personal Name Derived (pd:)
lloy,and,^
AND Index:
Title Derived (td:) ll,we,s
AND Format
Musical Scores

Connecticut Agricultural Experiment Station. Bulletin of the Tobacco Experiment Station. <serial; no ISSN> cd:agri,exp,s and td:bul,of,th,t/ser
<Connecticut is a stop word at the beginning of a Corp/Conf Derived search> Index:
Corp/Conf Name Derived (cd:)
agri,exp,s
AND Index:
Title Derived (td:) bul,of,th,t
AND Format
Serials

RELATED DOCUMENTS

OCLC Connexion Basics

OCLC Connexion Keyword Searching Examples

[TOC] | Cataloging at Yale | [TOOLS]

NOTE: Examples require LucidaSansRLG font to be viewed correctly on web browser.
Copyright © 2005 Yale University Library
Contact: steven.arakawa@yale.edu
Last updated: < 28-Apr-2005 12:18 PM -->
URL:http://www.library.yale.edu/cataloging/Orbis2Manual/connexionexamplesderives.htm