Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Supporting LCSH subject indexing with LOD in a Nigerian university library

Supporting LCSH subject indexing with LOD in a Nigerian university library

Navigating through the peculiar challenges of a third world country could be sort of an art, particularly towards producing quality work in heavily under-funded libraries. With limited financial resources and limited internet connectivity, the University of Ibadan (UI) Library has had to rely on the generosity of organizations, who provide datasets or metadata in various forms (e.g. LOD, MARC, SRU, etc.), to build tools that can support the classification and cataloguing of items especially those published in Nigeria. One of such is the creation of a Search tool using an LOD from the Library of Congress: the LC Subject Headings (LCSH) Dataset. The developers of the University’s Integrated Library System (UIILS) were able to use this dataset to create a Web Service within the UIILS that allows cataloguing staff search through the LCSH entries, even when there is a downtime internet connectivity and access to updated print copies are not possible. This search tool provides the staff with the Classification Number for an item based the subjects they search for. We'll walk through the processes involved from setting up the Apache Jena and Fuseki Server, to generating SPARQL queries from search parameters, processing of query responses, how those responses are displayed to cataloguing staff and how those responses can LINK to other queries.

Babarinde Odewumi

November 28, 2018

More Decks by Babarinde Odewumi

Other Decks in Technology


  1. Supporting LCSH subject indexing with LOD in a Nigerian University

    Library Odewumi Babarinde Ayodeji Abba & King Systems LLC [email protected] & Adetoun Adebisi Oyelude University of Ibadan Library Systems [email protected]; [email protected]
  2. Introduction - abbaandking.com Software Development Agency Based in Nigeria Specialization:

    Business Process Automation Est. 2013 Clients: Libraries, Schools, Small, Medium and Large Enterprises
  3. Library Clients We have a Library Management system called READABLE

    (readable.com.ng) used by. ➔ University Libraries E.g. University of Ibadan (also a legal deposit library), Crawford University, Niger Delta University, etc. ➔ Colleges & High Schools ➔ Public Libraries
  4. Subject Indexing Challenges ➔ No CIP Most Books published in

    Nigeria and a host of African countries don’t come with cataloguing in publication data ➔ Access to Updated LCSH Most Libraries are stuck with < 2010 versions (print version has been stopped) ➔ Remote LCSH Access Lack of Internet access restricts access to id.loc.gov (and this free service may also be unavailable)
  5. Setting up - Ubuntu Server 16.04 x64 - > 4GB

    RAM - >= 20GB HDD - Internet Connectivity for Downloads
  6. Installing dependencies - Open a terminal - sudo apt-get update

    -y - sudo apt-get install default-jre unzip
  7. Creating TDB Database - cd apache-jena-3.9.0/bin - ./tdbloader2 --loc /root/lcsh

    /root/authoritiessubjects.madsrdf.ttl where /root/lcsh is the location TDB database will be created This take a while depending on type of server used
  8. Set Environment Variables contd - where --loc=/root/lcsh is where the

    TDB is located and /lcsh is the endpoint for your SPARQL queries
  9. Load and Start Fuseki - cp fuseki.service /etc/systemd/system/ - sudo

    systemctl enable fuseki.service - sudo systemctl start fuseki.service
  10. Query (SPARQL) Prefix madsrdf: <http://www.loc.gov/mads/rdf/v1#> Select * where{ ?subject madsrdf:authoritativeLabel

    ?label Filter regex(?label, "algebra", "i") } order by asc (?label) Limit 1000
  11. Single Queries (SPARQL) Prefix madsrdf: <http://www.loc.gov/mads/rdf/v1#> Select * where{ <http://id.loc.gov/authorities/subjects/sh85082139>

    madsrdf:authoritativeLabel ?label } Prefix madsrdf: <http://www.loc.gov/mads/rdf/v1#> Select * where{ <http://id.loc.gov/authorities/subjects/sh85057512> madsrdf:authoritativeLabel ?label } ...