An integrated Web‐based ILL system for Singapore libraries

Schubert Foo, Ee‐Peng Lim

TL;DR

This paper introduces an integrated Web-based Inter-Library Loan (ILL) system designed to replace manual processes in Singaporean libraries. By leveraging a client-server architecture and Java, the system streamlines ILL requests, reduces administrative overhead, and improves efficiency for both users and librarians.

What Problem Does This Paper Address?

Libraries offer Inter-Library Loan (ILL) services to allow users access to resources beyond their own collections. Traditionally, this process in Singapore relied heavily on manual, paper-based systems. These systems were labor-intensive, prone to errors, and inefficient, especially as demand increased. The core problem was the lack of a unified, automated, and accessible system that could handle the complexities of ILL requests across multiple participating libraries, leading to delays, miscommunication, and significant administrative burden.

Methods

The proposed solution is an integrated Web-based ILL system built on a client-server architecture. Key technical aspects include:

  • Web-based Interface: Users and librarians interact with the system through standard web browsers, eliminating the need for specialized software or dedicated access points.
  • Client-Server Architecture: This allows for distributed access and processing. Each participating library hosts its own server, which communicates with others.
  • Java Development Platform: Chosen for its platform independence and suitability for web applications.
  • Database Design: Two separate databases, InILLDB (Incoming ILL) and OutILLDB (Outgoing ILL), are used at each library to clearly distinguish roles and improve efficiency. This is a novel approach to managing the dual nature of ILL (borrowing and lending).
  • Communication Processor: Facilitates direct communication and database updates between participating libraries.
  • Module Structure: The system is organized into distinct modules for users (e.g., About ILL, ILL Book Request, Status Request) and librarians (e.g., Process Membership Requests, Process Outgoing ILL Requests, Process Incoming ILL Requests), providing role-based access and functionality.
  • Status Flag: A mechanism to track the progress of an ILL request through various stages.

Datasets

Not discussed in the paper. The system relies on existing library catalogs and union databases (like SILAS) for information retrieval, but no specific datasets were used for training or evaluation in the context of this paper.

Key Insights and Ideas

  • Web as a Unifier: The paper highlights the power of the web to break down traditional access barriers, making ILL services accessible to a wider user base without requiring specialized client software.
  • Decentralized but Integrated: The client-server model with separate databases at each library allows for local control and maintenance while enabling seamless inter-library communication and data sharing.
  • Role Separation for Efficiency: The distinct InILLDB and OutILLDB databases are a clever design choice that simplifies data management and improves the speed and maintainability of the system.
  • Minimizing Human Error and Effort: Automating form-filling, status tracking, and communication significantly reduces the potential for human error and frees up librarian time for more complex tasks.
  • De Facto Standards: The reliance on standard SQL APIs for database interaction makes the system adaptable and allows for potential future upgrades to more robust database engines without extensive code rewrites.

Key Results

The paper describes the system's design and implementation, emphasizing its potential advantages rather than presenting quantitative results from a pilot study. The key qualitative findings and expected benefits include:

  • Elimination of Paperwork: Form-filling and manual documentation are completely removed.
  • Improved Speed and Access: Direct database updates and web accessibility speed up the ILL process and make it easier for users to submit and track requests.
  • Enhanced Data Integrity: Electronic handling reduces errors associated with manual data entry.
  • Simplified Status Tracking: Users and librarians can easily monitor the progress of requests.
  • Instantaneous Reporting: Supports real-time status and statistical reporting.
  • Reduced Administrative Overhead: Minimizes human resource requirements.

Limitations and Future Work

  • Pilot Phase: The system was initially intended for a pilot run and further evaluation at NTU and NIE libraries. The paper suggests that feedback from this pilot and other participating libraries will inform the development of a production version.
  • Integration with Bibliographic Searches: Future work could integrate bibliographic search results directly with ILL requests to further minimize user input and errors.
  • Automated Lending Library Selection: The system could be enhanced to automatically check union catalogs and library holdings to suggest a list of lending libraries for librarian selection.
  • Automatic Notification: Implementing an automatic electronic mailing facility to inform requesters of request outcomes more quickly is a suggested enhancement.

Summary updated

Abstract

The paper proposes an integrated Web‐based inter‐library loan (ILL) system to replace and enhance the existing manual‐based ILL system used by Singapore libraries. It describes the system requirements that must be supported in order to make it a viable and acceptable solution to all participating libraries. Subsequently, it presents the client‐server Web‐based system architecture, database design and Java development platform that are used to implement the system. The new system exhibits a host of advantages over the manual system including the minimising of human resource by eliminating form‐filling and other forms of paper work completely, improving the access and speed of the ILL process by allowing participating libraries to update each other’s databases directly, ensuring data integrity, simplifying status tracking and supporting instantaneous status and statistical reporting.
BibTeX
@inproceedings{foo1998integrated,
  author = {Schubert Foo and Ee‐Peng Lim},
  title = {{An integrated Web‐based ILL system for Singapore libraries}},
  booktitle = {Interlending},
  year = {1998},
  doi = {10.1108/02641619810369644},
}
Figure