1 / 19

SFX Database Structure

Learn about SFX request flow, services, thresholds, and link syntax in SFX Database. Explore Objects, Portfolios, and Source-Target relationships for efficient library resource management.

oneal
Download Presentation

SFX Database Structure

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SFX Database Structure SFX Training, 2005

  2. Key:1234-5678 SFX Menu Service 1 Service 2 The Flow of an SFX Request GenericRequest Object Source … OpenURL metadata "container" Target Parser SFX KB … thresholds checked URL

  3. SFX Database

  4. Sources • Where a user is coming from, beginning a search • Examples: • A&I database • OPAC • Online journal • Sources must be OpenURL-enabled! • Librarians work with Sources available in their own library environments; can decide what Services would be most desired by users

  5. Targets and Target Services • Where a user “lands” • Services are the “facilities”: • A ‘getAuthor’ service would run a search on an author’s name • A ‘getFullTxt’ service would link to the full text of a particular article from a Target publisher • A ‘getHolding’ service would link to a record in a library catalog • Targets must have a link-to syntax that supports the Service

  6. TARGETS EBSCO A.S.P. provides: getFullTxt, getTOC Library Catalog provides: getHolding JSTOR A&S I provides: getFullTxt Oxford U. Press provides: getFullTxt, getAbstract WWW Search Engines provides: getWebSearch RefWorks provides: getReference Service links between Sources and Targets SOURCES CSA requests: getFullTxt getTOC getHolding getDocumentDelivery getAbstract getWebSearch getReference getCitedJournal etc… Source Services link to Target Services = conceptual links that will be presented in SFX Menu if certain requirements (Thresholds) are met ….

  7. Database Tables SOURCE TARGET OBJECT SOURCESERVICE TARGETSERVICE OBJECT PORTFOLIO

  8. 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

  9. 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

  10. Database Tables TARGET TABLE TARGET: CAMBRIDGE_UNIVERSITY_PRESS AVAILABILITY: ACTIVE TARGET TARGET SERVICE TABLE TARGET: CAMBRIDGE_UNIVERSITY_PRESS SERVICE: getFullTxt OBJECT LOOKUP: Y AVAILABILITY: ACTIVE TARGET SERVICE OBJECT PORTFOLIO TABLE TARGET: CAMBRIDGE_UNIVERSITY_PRESS SERVICE: getFullTxt ISSN: 0014-4797 THRESHOLD: $obj->parsedDate(">=",1997,33,1) AVAILABILITY: ACTIVE OBJECT PORTFOLIO OBJECT TABLE ISSN: 0014-4797 TITLE: Experimental agriculture @ABBREV TITLE: EXP AGRIC CODEN: EXAGAL EISSN: 1469-4441 OBJECT

  11. Object Lookup Object Lookup[set at Target Service] • 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 ofthe object with which you start • Is used for more general, “search-oriented” Target Services, such asgetHolding or getWebSearch • 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 ofthe Object Portfolio of that Target Service • Is mainly used for getFullTxt Target Services

  12. 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 getFullTxt 0003-1224 American Sociological Review $obj->parsedDate(">=",1936,undef,undef) && $obj->parsedDate("<=",2001,undef,undef) JSTOR_ARTS_AND_SCIENCES_1 getFullTxt 0003-486X Annals of Mathematics $obj->parsedDate(">=",1884,undef,undef) && $obj->parsedDate("<=",1998,undef,undef) JSTOR_ARTS_AND_SCIENCES_1 getFullTxt 0006-3444 Biometrika $obj->parsedDate(">=",1901,undef,undef) && $obj->parsedDate("<=",1998,undef,undef) JSTOR_ARTS_AND_SCIENCES_1 getFullTxt 0011-3204 Current anthropology $obj->parsedDate(">=",1959,undef,undef) OXFORD_UNIVERSITY_PRESS getFullTxt 0004-8402 Australasian Journal of Philosophy $obj->parsedDate(">=",2001,79,1) OXFORD_UNIVERSITY_PRESS getFullTxt 0006-3444 Biometrika $obj->parsedDate(">=",1999,86,1) OXFORD_UNIVERSITY_PRESS getFullTxt 0006-8950 Brain $obj->parsedDate(">=",1997,120,1) OXFORD_UNIVERSITY_PRESS getFullTxt 0007-0882 The British journal for the philosophy of science $obj->parsedDate(">=",1998,49,4) EBSCO_ACADEMIC_SEARCH_PREMIER getFullTxt 0001-2475 Asha $obj->parsedDate(">=",1994,undef,undef) && $obj->parsedDate("<=",1999,undef,undef) EBSCO_ACADEMIC_SEARCH_PREMIER getFullTxt 0001-2610 Planning $obj->parsedDate(">=",1993,undef,undef) EBSCO_ACADEMIC_SEARCH_PREMIER getFullTxt 0001-2815 Tissue antigens $obj->parsedDate(">=",1999,undef,undef) && $obj->timediff('>','1y')

  13. 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

  14. Threshold Types • parsedDate method • Moving wall threshold • currtime method • needAttribute method • Authentication threshold • plugIn threshold $obj->parsedDate(">=",1994,2,1) && $obj->parsedDate("<=",1998,6,12) $obj->timediff(">","1y") $obj->currtime("<","06-30-2004") $obj->need('@authLast') $obj->need('Institute','eq','MEDICAL') $obj->plugIn(z3950_lookup)

  15. 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

  16. Thresholds • Combining global and local thresholds: • global threshold: $obj->parsedDate(">=",1994,26,1) • local threshold: GLOBAL && $obj->need("Institute","eq","MEDICAL") • result: $obj->parsedDate(">=",1994,26,1) && $obj->need("Institute","eq","MEDICAL")

  17. 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 getFullTxt 0003-1224 American Sociological Review $obj->parsedDate(">=",1936,undef,undef) && $obj->parsedDate("<=",2001,undef,undef) JSTOR_ARTS_AND_SCIENCES_1 getFullTxt 0003-486X Annals of Mathematics $obj->parsedDate(">=",1884,undef,undef) && $obj->parsedDate("<=",1998,undef,undef) JSTOR_ARTS_AND_SCIENCES_1 getFullTxt 0006-3444 Biometrika $obj->parsedDate(">=",1901,undef,undef) && $obj->parsedDate("<=",1998,undef,undef) JSTOR_ARTS_AND_SCIENCES_1 getFullTxt 0011-3204 Current anthropology $obj->parsedDate(">=",1959,undef,undef) OXFORD_UNIVERSITY_PRESS getFullTxt 0004-8402 Australasian Journal of Philosophy $obj->parsedDate(">=",2001,79,1) OXFORD_UNIVERSITY_PRESS getFullTxt 0006-3444 Biometrika $obj->parsedDate(">=",1999,86,1) OXFORD_UNIVERSITY_PRESS getFullTxt 0006-8950 Brain $obj->parsedDate(">=",1997,120,1) OXFORD_UNIVERSITY_PRESS getFullTxt 0007-0882 The British journal for the philosophy of science $obj->parsedDate(">=",1998,49,4

  18. 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 getFullTxt 0003-1224 American Sociological Review $obj->parsedDate(">=",1936,undef,undef) && $obj->parsedDate("<=",2001,undef,undef) JSTOR_ARTS_AND_SCIENCES_1 getFullTxt 0003-486X Annals of Mathematics $obj->parsedDate(">=",1884,undef,undef) && $obj->parsedDate("<=",1998,undef,undef) JSTOR_ARTS_AND_SCIENCES_1 getFullTxt 0006-3444 Biometrika $obj->parsedDate(">=",1901,undef,undef) && $obj->parsedDate("<=",1998,undef,undef) JSTOR_ARTS_AND_SCIENCES_1 getFullTxt 0011-3204 Current anthropology $obj->parsedDate(">=",1959,undef,undef) OXFORD_UNIVERSITY_PRESS getFullTxt 0004-8402 Australasian Journal of Philosophy $obj->parsedDate(">=",2001,79,1) OXFORD_UNIVERSITY_PRESS getFullTxt 0006-3444 Biometrika $obj->parsedDate(">=",1999,86,1) OXFORD_UNIVERSITY_PRESS getFullTxt 0006-8950 Brain $obj->parsedDate(">=",1997,120,1) OXFORD_UNIVERSITY_PRESS getFullTxt 0007-0882 The British journal for the philosophy of science $obj->parsedDate(">=",1998,49,4

  19. www.exlibrisgroup.com/sfx.htm sfx_help@exlibris-usa.com

More Related