Transcript Implementing_Quick_Search_UMDNJ

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 Website
http://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:UTF8&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 eresources
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,
[email protected], 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, [email protected], 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, [email protected], 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, [email protected], 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