SFX Database Structure SFX Training 2005 The Flow
SFX Database Structure SFX Training, 2005
The Flow of an SFX Request Generic. Request Object Open. URL Source Key: 1234 -5678 … SFX KB … thresholds checked metadata "container" SFX Menu Service 1 Service 2 Target Parser URL 2
SFX Database 3
Sources • Where a user is coming from, beginning a search • Examples: • A&I database • OPAC • Online journal • Sources must be Open. URL-enabled! • Librarians work with Sources available in their own library environments; can decide what Services would be most desired by users 4
Targets and Target Services • Where a user “lands” • Services are the “facilities”: • A ‘get. Author’ service would run a search on an author’s name • A ‘get. Full. Txt’ service would link to the full text of a particular article from a Target publisher • A ‘get. Holding’ service would link to a record in a library catalog • Targets must have a link-to syntax that supports the Service 5
Service links between Sources and Targets SOURCES TARGETS EBSCO A. S. P. provides: get. Full. Txt, get. TOC CSA requests: get. Full. Txt get. TOC get. Holding get. Document. Delivery get. Abstract get. Web. Search get. Reference get. Cited. Journal etc… Library Catalog provides: get. Holding JSTOR A&S I provides: get. Full. Txt Source Services link to Target Services = conceptual links that will be presented in SFX Menu if certain requirements (Thresholds) are met …. Oxford U. Press provides: get. Full. Txt, get. Abstract WWW Search Engines provides: get. Web. Search Ref. Works provides: get. Reference 6
Database Tables SOURCE TARGET SOURCE SERVICE TARGET SERVICE OBJECT PORTFOLIO 7
Objects • The OBJECT table stores objects and information about objects • • • Title ISSN/E-ISSN CODEN Abbreviated titles (alternate) Object type Related objects (title or ISSN change) • Three types of objects are defined in the SFX database: • Journals • Books • Preprints 8
Object Portfolios • The OBJECT PORTFOLIO tables stores information to connect TARGET SERVICES and OBJECTs • For example, this table indicates which journals are available from the Cambridge University Press collection, or from JSTOR Arts & Sciences 1 collection 9
Database Tables TARGE T TARGET SERVICE OBJECT PORTFOLIO OBJEC T TARGET TABLE TARGET: CAMBRIDGE_UNIVERSITY_PRESS AVAILABILITY: ACTIVE TARGET SERVICE TABLE TARGET: CAMBRIDGE_UNIVERSITY_PRESS SERVICE: get. Full. Txt OBJECT LOOKUP: Y AVAILABILITY: ACTIVE OBJECT PORTFOLIO TABLE TARGET: CAMBRIDGE_UNIVERSITY_PRESS SERVICE: get. Full. Txt ISSN: 0014 -4797 THRESHOLD: $obj->parsed. Date(">=", 1997, 33, 1) AVAILABILITY: ACTIVE OBJECT TABLE ISSN: 0014 -4797 TITLE: Experimental agriculture @ABBREV TITLE: EXP AGRIC CODEN: EXAGAL EISSN: 1469 -4441 10
Object Lookup [set at Target Service] YES • • • Is used when objects need to be attached to a particular target service The Target Service will show up on the SFX Menu screen only if the information you start from is part of the Object Portfolio of that Target Service Is mainly used for get. Full. Txt Target Services NO • • • Is used when no objects need to be attached to a particular target service The Target Service will show up on the SFX Menu screen, regardless of the object with which you start Is used for more general, “searchoriented” Target Services, such as get. Holding or get. Web. Search 11
Object Lookup http: //sfx. university. edu/library? genre=article&issn=0006 -3444 &date=1992&volume=79&issue=3&spage=463 JSTOR_ARTS_AND_SCIENCES_1 get. Full. Txt 0003 -1224 American Sociological Review $obj->parsed. Date(">=", 1936, undef) && $obj->parsed. Date("<=", 2001, undef) JSTOR_ARTS_AND_SCIENCES_1 get. Full. Txt 0003 -486 X Annals of Mathematics $obj->parsed. Date(">=", 1884, undef) && $obj->parsed. Date("<=", 1998, undef) JSTOR_ARTS_AND_SCIENCES_1 get. Full. Txt 0006 -3444 Biometrika $obj->parsed. Date(">=", 1901, undef) && $obj->parsed. Date("<=", 1998, undef) JSTOR_ARTS_AND_SCIENCES_1 get. Full. Txt 0011 -3204 Current anthropology $obj->parsed. Date(">=", 1959, undef) OXFORD_UNIVERSITY_PRESS get. Full. Txt 0004 -8402 $obj->parsed. Date(">=", 2001, 79, 1) OXFORD_UNIVERSITY_PRESS get. Full. Txt 0006 -3444 $obj->parsed. Date(">=", 1999, 86, 1) OXFORD_UNIVERSITY_PRESS get. Full. Txt 0006 -8950 $obj->parsed. Date(">=", 1997, 120, 1) OXFORD_UNIVERSITY_PRESS get. Full. Txt 0007 -0882 $obj->parsed. Date(">=", 1998, 49, 4) Australasian Journal of Philosophy Biometrika Brain The British journal for the philosophy of science EBSCO_ACADEMIC_SEARCH_PREMIER get. Full. Txt 0001 -2475 Asha $obj->parsed. Date(">=", 1994, undef) && $obj->parsed. Date("<=", 1999, undef) EBSCO_ACADEMIC_SEARCH_PREMIER get. Full. Txt 0001 -2610 Planning $obj->parsed. Date(">=", 1993, undef) EBSCO_ACADEMIC_SEARCH_PREMIER get. Full. Txt 0001 -2815 Tissue antigens $obj->parsed. Date(">=", 1999, undef) && $obj->timediff('>', '1 y') 12
Thresholds • Rules or conditions set on database items; found on TARGETs, TARGET SERVICEs, or OBJECT PORTFOLIOs • Used to fine-tune SFX services that appear on SFX Menu • Data in SFX requests must match the rule in order for the item to appear on the SFX Menu • Written as Perl statements; can use Boolean to stack them (AND, OR( • Threshold Composer to help 13
Threshold Types • parsed. Date method $obj->parsed. Date(">=", 1994, 2, 1) && $obj->parsed. Date("<=", 1998, 6, 12) • Moving wall threshold $obj->timediff(">", "1 y") • currtime method $obj->currtime("<", "06 -30 -2004") • need. Attribute method $obj->need('@auth. Last') • Authentication threshold $obj->need('Institute', 'eq', 'MEDICAL') • plug. In threshold $obj->plug. In(z 3950_lookup) 14
Threshold Types • Global thresholds • • Supplied by Ex Libris Used as default Active if no local thresholds are used Updated automatically • Local thresholds • • Specified by the institution Reflect local conditions Override global thresholds Not changed during the update procedure 15
Thresholds • Combining global and local thresholds: • global threshold: $obj->parsed. Date(">=", 1994, 26, 1) • local threshold: GLOBAL && $obj->need("Institute", "eq", "MEDICAL") • result: $obj->parsed. Date(">=", 1994, 26, 1) && $obj->need("Institute", "eq", "MEDICAL") 16
Threshold Check - Date http: //sfx. university. edu/library? genre=article&issn=0006 -3444 &date=1992&volume=79&issue=3&spage=463 JSTOR_ARTS_AND_SCIENCES_1 get. Full. Txt 0003 -1224 American Sociological Review $obj->parsed. Date(">=", 1936, undef) && $obj->parsed. Date("<=", 2001, undef) JSTOR_ARTS_AND_SCIENCES_1 get. Full. Txt 0003 -486 X Annals of Mathematics $obj->parsed. Date(">=", 1884, undef) && $obj->parsed. Date("<=", 1998, undef) JSTOR_ARTS_AND_SCIENCES_1 get. Full. Txt 0006 -3444 Biometrika $obj->parsed. Date(">=", 1901, undef) && $obj->parsed. Date("<=", 1998, undef) JSTOR_ARTS_AND_SCIENCES_1 get. Full. Txt 0011 -3204 Current anthropology $obj->parsed. Date(">=", 1959, undef) OXFORD_UNIVERSITY_PRESS get. Full. Txt 0004 -8402 $obj->parsed. Date(">=", 2001, 79, 1) OXFORD_UNIVERSITY_PRESS get. Full. Txt 0006 -3444 $obj->parsed. Date(">=", 1999, 86, 1) OXFORD_UNIVERSITY_PRESS get. Full. Txt 0006 -8950 $obj->parsed. Date(">=", 1997, 120, 1) OXFORD_UNIVERSITY_PRESS get. Full. Txt 0007 -0882 $obj->parsed. Date(">=", 1998, 49, 4 Australasian Journal of Philosophy Biometrika Brain The British journal for the philosophy of science 17
Threshold Check - Date http: //sfx. university. edu/library? genre=article&issn=0006 -3444 &date=2000&volume=87&issue=3&spage=527 JSTOR_ARTS_AND_SCIENCES_1 get. Full. Txt 0003 -1224 American Sociological Review $obj->parsed. Date(">=", 1936, undef) && $obj->parsed. Date("<=", 2001, undef) JSTOR_ARTS_AND_SCIENCES_1 get. Full. Txt 0003 -486 X Annals of Mathematics $obj->parsed. Date(">=", 1884, undef) && $obj->parsed. Date("<=", 1998, undef) JSTOR_ARTS_AND_SCIENCES_1 get. Full. Txt 0006 -3444 Biometrika $obj->parsed. Date(">=", 1901, undef) && $obj->parsed. Date("<=", 1998, undef) JSTOR_ARTS_AND_SCIENCES_1 get. Full. Txt 0011 -3204 Current anthropology $obj->parsed. Date(">=", 1959, undef) OXFORD_UNIVERSITY_PRESS get. Full. Txt 0004 -8402 $obj->parsed. Date(">=", 2001, 79, 1) OXFORD_UNIVERSITY_PRESS get. Full. Txt 0006 -3444 $obj->parsed. Date(">=", 1999, 86, 1) OXFORD_UNIVERSITY_PRESS get. Full. Txt 0006 -8950 $obj->parsed. Date(">=", 1997, 120, 1) OXFORD_UNIVERSITY_PRESS get. Full. Txt 0007 -0882 $obj->parsed. Date(">=", 1998, 49, 4 Australasian Journal of Philosophy Biometrika Brain The British journal for the philosophy of science 18
www. exlibrisgroup. com/sfx. htm sfx_help@exlibris-usa. com
- Slides: 19