250 likes | 363 Views
Implementing Quick Search in the Newly Designed Library Website to Meet Users’ Needs. Fengzhi Fan, Systems Librarian Yingting Zhang, Information & Education Librarian Robert Cupryk, Information & Education Librarian Kerry O’Rourke, Campus Library Director,
E N D
Implementing Quick Search in the Newly Designed Library Website to Meet Users’ Needs Fengzhi Fan, Systems Librarian Yingting Zhang, Information & Education Librarian Robert Cupryk, Information & Education Librarian Kerry O’Rourke, Campus Library Director, UMDNJ - Robert Wood Johnson Library of the Health Sciences NJLA, April 27, 2010 UMDNJ – RWJ Library of the Health Sciences – http://libraries.umdnj.edu/rwjlbweb
Introduction – Focus groups Focus Groups with Students: • Comments & suggestions on old website • Ideas for better features on new website • Sample features presented for review • Single search box was favored • Capability to search PubMed from homepage UMDNJ – RWJ Library of the Health Sciences – http://libraries.umdnj.edu/rwjlbweb
Outcome of Focus Groups Based on focus groups’ results, a quick search feature was developed: • in early 2009 • in house by library staff • implemented in our newly designed website • enabling students to perform quick search in PubMed, CINAHL, and our e-resources collection directly from library’s homepage: http://libraries.umdnj.edu/rwjlbweb • goal accomplished without any additional funding UMDNJ – RWJ Library of the Health Sciences – http://libraries.umdnj.edu/rwjlbweb
RWJ Library Old Website UMDNJ – RWJ Library of the Health Sciences – http://libraries.umdnj.edu/rwjlbweb
A Glance at UMDNJ – RWJ Library Websitehttp://libraries.umdnj.edu/rwjlbweb/ UMDNJ – RWJ Library of the Health Sciences – http://libraries.umdnj.edu/rwjlbweb
A Closer Look at the Quick Search Box The first quick search box is an embedded search script which provides a direct search against selected databases such as PubMed and CINAHL. In the example below PubMed was chosen. UMDNJ – RWJ Library of the Health Sciences – http://libraries.umdnj.edu/rwjlbweb
PubMed Search Example / Demo UMDNJ – RWJ Library of the Health Sciences – http://libraries.umdnj.edu/rwjlbweb
PubMed Search Results UMDNJ – RWJ Library of the Health Sciences – http://libraries.umdnj.edu/rwjlbweb
PubMed Search Results UMDNJ – RWJ Library of the Health Sciences – http://libraries.umdnj.edu/rwjlbweb
PubMed Search Results Finding Full Text Article UMDNJ – RWJ Library of the Health Sciences – http://libraries.umdnj.edu/rwjlbweb
Embedded Search Script Redirect.cgi is a simple perl script which provides a direct search against PubMed & CINAHL. PubMed parser: my $URL = "http://www.ncbi.nlm.nih.gov/entrez?holding=njunjnlib&otool=njunjnlib&dr=Abstract&term=$strTitle"; print "<script type='text/javascript'>"; print "window.location='$URL'"; print "</script>"; CINAHL parser: my $URL = "http://search.epnet.com/direct.asp?db=cin20&fquery=$strTitle&scope=site"; print "<script type='text/javascript'>"; print "window.location='$URL'"; print "</script>"; Other parsers could include: Voyager, Medline, AccessMedicine, MDConsult, ASP, etc. UMDNJ Office of Advancement and Communications
Finding an E-Resource The second search box is a database-driven search program, capable of searching the UMDNJ e-resource collection including e-journals, e-books, databases, and subject toolkits. A limited subject search is available for e-books and databases. The collection can also be browsed by alphabet. For e-journals, data is loaded from the SFX server. For e-books and databases, data is imported from a flat table maintained by our e-resources staff. Various web/database technologies were utilized including MySQL, MS Access, Perl, and PHP. UMDNJ – RWJ Library of the Health Sciences – http://libraries.umdnj.edu/rwjlbweb
E-Resource Search Example / Demo UMDNJ – RWJ Library of the Health Sciences – http://libraries.umdnj.edu/rwjlbweb
E-Resource Search Example UMDNJ – RWJ Library of the Health Sciences – http://libraries.umdnj.edu/rwjlbweb
Database-Driven Search Program qsearch.php is a php script which provides search for e-books, e-journals, e-databases & toolkits titles. Example SQL query to find e-books by title and subject in MS Access: $sqlquery = "SELECT DISTINCT title, url, database, cgi FROM jinput WHERE type = 'ebook' AND title LIKE '%$keywords%' UNION SELECT DISTINCT title, url, database, cgi FROM jinput WHERE cgi IN (SELECT cgi FROM ebook_subject_link WHERE subject_id = (SELECT subject_id FROM ebook_subject WHERE subject = '$keywords'))"; PHP code to display the search result: while(!$objrs->EOF) { $title = $objrs->Fields(0); $url = $objrs->Fields(1); $database = $objrs->Fields(2); $cgi = $objrs->Fields(3); $realUrl = $realUrl = "<li><a href=\"http://www.umdnj.edu/cgi-bin/libjournal/" . $cgi->value . "\" target='_blank'\""; print("" . $realUrl . ">" . $title->value . "</a> - E-book from " . $database->value . "</li><br>"); UMDNJ – RWJ Library of the Health Sciences – http://libraries.umdnj.edu/rwjlbweb
Database-Driven Search Program Example sql query to find e-journals by title in MySQL: $query = "SELECT A.TITLE_NORMALIZED, F.THRESHOLD_GLOBAL, S.ISSN_ID, F.THRESHOLD, A.OBJECT_ID, MIN(SUBSTRING(F.THRESHOLD_GLOBAL, 23, 5)) AS HOLDING FROM AZ_TITLE A, AZ_FILTER F, AZ_LETTER_GROUP L, ISSN S WHERE A.OBJECT_ID = F.OBJECT_ID AND A.OBJECT_ID = S.OBJECT_ID AND L.AZ_LETTER_GROUP_ID = A.AZ_LETTER_GROUP_ID AND A.TITLE_NORMALIZED LIKE '%$keywords%' GROUP BY A.OBJECT_ID ORDER BY A.AZ_TITLE_ORDER"; UMDNJ – RWJ Library of the Health Sciences – http://libraries.umdnj.edu/rwjlbweb
Database-Driven Search Program PHP code to display the e-journal search result: //format sql result for display $title = ""; $sub_id = ""; $holding = ""; $sfxlink1 = ""; $sfxlink2 = ""; $beginning = "http://sfx.umdnj.edu/sfxlcl3?url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&ctx_enc=info:ofi/enc:UTF-8&ctx_ver=Z39.88-2004&rfr_id=info:sid/sfxit.com:azlist&sfx.ignore_date_threshold=1&rft.object_id="; $ending = "&svc.holdings=yes&svc.fulltext=yes"; while($record = mysql_fetch_object($result)) { $title = "$record->TITLE_NORMALIZED"; $sub_id = "$record->ISSN_ID"; $holding = "$record->HOLDING"; $object = "$record->OBJECT_ID"; $sfxlink1 = $beginning . $object . $ending; $sfxlink2 = "<li><a href='$sfxlink1' target='_blank'>$title</a> - ISSN - $sub_id - full text available from $holding</li><br>"; echo $sfxlink2; } UMDNJ – RWJ Library of the Health Sciences – http://libraries.umdnj.edu/rwjlbweb
Benefits of Quick Search to UMDNJ Library Users • The Quick Search function provides a more convenient and efficient means for our users to search key biomedical databases. • Provides one-stop searching of UMDNJ e-resource titles. • The e-journal listing on the local server backs up the A-Z journal data in our link resolver and increases search speed. UMDNJ – RWJ Library of the Health Sciences – http://libraries.umdnj.edu/rwjlbweb
Benefits of Quick Search to Information Community • This feature was subsequently adopted by all UMDNJ campus libraries. • It can be shared with and customized by other interested libraries UMDNJ – RWJ Library of the Health Sciences – http://libraries.umdnj.edu/rwjlbweb
Quick Search Adopted by Other Libraries UMDNJ – RWJ Library of the Health Sciences – http://libraries.umdnj.edu/rwjlbweb
Impact on Library Operations • Implementation of Quick Search demonstrated that we heard our users’ concerns and responded to their needs effectively. • Equally important we were able to accomplish the goal without any additional funding. This is particularly significant in today’s economic downturn. UMDNJ – RWJ Library of the Health Sciences – http://libraries.umdnj.edu/rwjlbweb
Impact on Library/Librarians in the Academic Setting • Provides convenient one-stop search for PubMed & CINAHL • Directs users to the UMDNJ-specific PubMed link • Maximizes utilization of UMDNJ’s e-resources UMDNJ – RWJ Library of the Health Sciences – http://libraries.umdnj.edu/rwjlbweb
PubMed Search Results UMDNJ – RWJ Library of the Health Sciences – http://libraries.umdnj.edu/rwjlbweb
Members of the RWJ Library’s Website Development Team • Fengzhi Fan: Systems Librarian, UMDNJ - Robert Wood Johnson Library of the Health Sciences, 1 RWJ Place, PO Box 19, New Brunswick, NJ 08903, fanfe@umdnj.edu, 732-235-7605. • Yingting Zhang: Information & Education Librarian, UMDNJ - Robert Wood Johnson Library of the Health Sciences, 1 RWJ Place, PO Box 19, New Brunswick, NJ 08903, yzhang@umdnj.edu, 732-235-7604. • Robert Cupryk: Information & Education Librarian, UMDNJ - Robert Wood Johnson Library of the Health Sciences, 1 RWJ Place, PO Box 19, New Brunswick, NJ 08903, cupryk@umdnj.edu, 732-235-7604. • Kerry O’Rourke: Campus Library Director, UMDNJ - Robert Wood Johnson Library of the Health Sciences, 1 RWJ Place, PO Box 19, New Brunswick, NJ 08903, orourke@umdnj.edu, 732-235-7606. UMDNJ – RWJ Library of the Health Sciences – http://libraries.umdnj.edu/rwjlbweb
Thank You! UMDNJ – RWJ Library of the Health Sciences – http://libraries.umdnj.edu/rwjlbweb