Cheng Library information on demand

1
Cheng Libraryinformation on demand

• David and Lorraine Cheng Library William
  Paterson University of New Jersey

2
The Problem(s)

• Publically accessible Library information limited
  to OPAC search results.
• Custom queries possible, but the information is
  static and of limited value to the Librarys
  external users.
• Voyager server needs to remain in a protected
  area of the network houses users personal
  information.
• Todays users expect availability of rich data,
  yet we have no mechanism to provide it.

3
The Objective(s)

• To make a larger amount of information, from a
  greater number of sources, available to
• Internal users library staff
• Campus users students, faculty, university
  staff
• Public users
• Queries against other systems to run
  interactively, using ColdFusion, PHP and other
  dynamic tools.
• Maintain ILS security and university server
  standards.
• Allow users to determine and obtain data on
  demand.

4
The Players

• Kurt Wagner Head of Library Information Systems
• Ray Schwartz Systems Specialist Librarian
• Mark Sandford Special Formats Cataloger
• Tony Joachim Reference Librarian
• James DeRose ILS Server System Administrator
• WPUNJ Information Systems staff

5
Kurt Wagner

• At Cheng Library since 1994.
• Primary Library liaison with othercampus IT
  groups,
• Previous successes with collaborative projects
• Print management
• Wireless laptop loaner program
• Proxy server
• Interested in
• Ubiquitous access to information all users

6
The Collaboration

• The Library, along with other campus units
  Instruction Research Technology (academic
  computing), and Information Systems have worked
  collaboratively on several projects
• Configuring, deploying and maintaining
  circulating wireless laptops
• Print management
• Proxy server
• We have seen that on several occasions IS lacks
  the Librarys skill in customer service.

7
Ray Schwartz

• At Cheng Library since 2004.
• Lead analyst of data from Voyagerand other
  library-related systems
• Interested in
• Providing library staff withinteractive and
  on-demand information access.
• Establishment of data farm.
• Ongoing mining of data to assist in strategic
  decisionmaking.

8
Data Mining and Data Warehousing

• Extracting data from legacy systems and other
  resources
• cleaning, scrubbing and preparing data for
  decision support
• maintaining data in appropriate data stores
• accessing and analysing data using a variety of
  end user tools
• and mining data for significant relationships.

• Chaffey, D., Mayer, R., Johnston, K.,
  Ellis-Chadwick, F. (2002). Internet Marketing
  Strategy, Implementation and Practice (2nd ed.).
  Financial Times/ Prentice Hall.

9
Our Goal
The primary purpose of these efforts is to
provide easy access to specifically prepared data
that can be used with decision support
applications such as management reports, queries,
decision support systems, executive information
systems and data mining.

• Chaffey, D., Mayer, R., Johnston, K.,
  Ellis-Chadwick, F. (2002). Internet Marketing
  Strategy, Implementation and Practice (2nd ed.).
  Financial Times/ Prentice Hall.

10
Our Systems

• Voyager ILS Server
• Shared Application Server
• Clio ILL Software
• EZProxy Server
• Banner University ERP
• University Networked Drive K
• University Email Server
• University Web Server

11
Groups and Services

• Major
• Status
• Undergrad or Grad
• Faculty, Adjunct Faculty or Staff
• Department
• College
• Degree
• No. of Credits
• Year of Study
• Campus Location

• Circulation
• Books
• Media
• Reserve
• By Fund Code
• Location
• ILL / Document Delivery
• Databases
• Library Web Pages
• Subject Area Resource Guides
• Reference Requests
• Catalog
• Other Vendor Services
• Serials Solutions

12
History Department - 12 months - Feb. 2008
13
One of Our Projects

• Mining EZProxy logfiles and linking to patron
  statistical categories from the Voyager Patron
  Database
• What majors and departments are accessing which
  database services?
• What majors and departments are accessing the ILL
  services?

14
Privacy Issues

• EZProxy transactions would be stored in one table
  with patron statistical categories, but without
  the user ID.
• User ID s would be stored in another table with
  counts for each service divided by academic year.
• Logs are collected monthly and loaded and deleted
  monthly.

15
Reporting and Standards

• Reporting
• emailed periodically - e.g., daily dossiers,
  and other event triggered reports.
• On demand, via email, web pages or a printer.
• Standards
• Share data for comparative research.
• Groups of libraries and consortia

16
Mark Sandford

• At Cheng Library since 2006.
• Cataloger and departmental technology
  specialist.
• Interested in
• Use of web authoring andapplications to enhance
  bibliographic control and access.
• Enhancing public access to catalog records.
• Next-generation discovery tools VUFind.

17
Moving beyond the OPAC

• Users expressed a desire for searching specific
  types of materials in the collection
• Leisure Lounge Popular fiction and
  non-fiction from McNaughton were hard to find in
  the catalog
• https//liberty.wpunj.edu/library/leisurelounge/
• Video Subject Guide replaces an old print guide
  no longer updated. Voyager has no way to limit
  Subject Browse.
• https//liberty.wpunj.edu/library/videoguide/index
  .cfm
• Voyagers Webvoyage OPAC lacks many features
  todays users want
• VUFind is an open source OPAC replacement that
  interfaces with the catalog
• http//libtest.wpunj.edu/library/vufind/

18
Tony Joachim

• At Cheng Library since 2006
• Lead public access web developer
• Interested in
• Using cutting edge tools to improve the
  Librarys web presence.
• Creating dynamic and database driven web tools.
• Creating interactive and user editable web
  content.

19
Cheng Library Website

• Static pages based ona common template.
• Updates are performed bya small group of staff
• Technical expertise
• Web access rights
• Issues
• Labor Intensive Editing
• Time Consuming
• Inconsistencies

20
Dynamic Web Pages

• Publicly accessible, database-driven content
  pages
• ColdFusion Microsoft Access
• Curriculum Materials Center
• Developed a single page in place of 30
• Consistency of content across pages
• Dynamically Generated

21
Administrative Interfaces

• Administrative Web forms allow departmental
  staff to easily update content.
• Secure
• Password Protection
• IP restricted
• Staff empowerment
• Instant updates to live pages

22
Administrative Interfaces
23
Other Projects

• Completed
• Library Database List
• Public Pages Interface
• Liaison Directory
• Future Projects
• Full Course Resources Interface
• Full Staff Directory

24
James DeRose

• At Cheng Library since 1998.
• Primary technical contact forLibrarys
  Sun/Solaris Voyager server
• Interested in
• Proactive and participative server
  administration
• Providing and maintaining technological
  infrastructure to meet users needs
• Good coffee

25
Requirements

• Keep user data secure
• Available both on and off campus
• Conform to campus IS standards
• Keep Information Systems involved and in the loop

26
The Plan
27
The Plan
28
Campus Information Systems

• Centralized server farm
• Handles all web traffic
• Provides space for the Librarys ILS server, and
  the Library providesall additional
  administration.
• Staff provides server administration, network,
  hardware and security (firewall, etc) support.

29
The Discussion

• Physical Server Liberty
• Disposition of responsibilities
• Communication
• Liberty-l listserv
• Liberty wiki

30
Liberty Application Server

• Library Databases page
• https//liberty.wpunj.edu/library/ERClist/erclist.
  cfm
• Subject Guide to the Cheng Librarys Video
  Collection
• https//liberty.wpunj.edu/library/videoguide/
• Leisure Lounge Collection
• https//liberty.wpunj.edu/library/leisurelounge/
• Lesson Plans and Resources By Subject
• https//liberty.wpunj.edu/library/currmats/topic_l
  ist.cfm
• Resource Management Reports (internal use only)
• http//libtest/library/rmforms.cfm
• Lending Services Reports (internal use only)
• http//libtest/library/circulation/lsdeptreports.c
  fm

31
Conclusion

• We feel that we now have the platform and
  mechanism to deliver a great variety of
  interactive content to our users.
• Please direct any questions or comments to
• Kurt Wagner, wagnerk_at_wpunj.edu 973-720-2285
• Ray Schwartz, schwartzr2_at_wpunj.edu 973-720-3192
• Mark Sandford, sandfordm1_at_wpunj.edu
  973-720-2437
• Tony Joachim, joachima1_at_wpunj.edu 973-720-3665
• James DeRose, derosej_at_wpunj.edu 973-720-3193
• Thank You!