LIS Notes # 02 - AI Tools for Literature Review

There are several AI tools available for conducting a literature review, helping with research discovery, summarization, citation management, and analysis. Here are some of the best AI-powered tools:

1. Research Discovery & Paper Search

  • Semantic Scholar – Uses AI to find relevant academic papers.
  • Elicit – AI-powered search for extracting key insights from research papers.
  • Connected Papers – Helps visualize connections between research papers.
  • Scite – Shows how papers cite each other (supporting, contrasting, or mentioning).

2. AI Summarization & Reading Assistance

  • ChatPDF – Allows interaction with PDFs and summarizes key points.
  • Scholarcy – Summarizes long research papers into key insights.
  • QuillBot – AI-powered paraphrasing and summarization tool.

3. Citation Management

  • Zotero – AI-assisted reference management.
  • Mendeley – Organizes and manages research citations.
  • EndNote – Helps with citation generation and reference management.

4. Writing & AI Assistance

  • Grammarly – AI-powered writing and grammar correction.
  • Trinka AI – AI for academic writing and language improvement.
  • Jenni AI – Assists in drafting and structuring research papers.

[Koha-bugs] [Bug 34276] upgrading 23.05 to 23.11

Got a problem while upgrading Koha database from 23.05 to 23.11.....

 

While upgrading it shows the above error

Solution: 

1. Login to MySQL with root 

mysql -u root -p

[enter password]

2. Choose the database 

use koha_library;

3. Execute the below SYNTAX

SELECT RefCons.constraint_schema, RefCons.table_name,
RefCons.referenced_table_name, RefCons.constraint_name, KeyCol.column_name
FROM information_schema.referential_constraints RefCons
JOIN information_schema.key_column_usage KeyCol ON RefCons.constraint_schema =
KeyCol.table_schema
     AND RefCons.table_name = KeyCol.table_name
     AND RefCons.constraint_name = KeyCol.constraint_name
WHERE RefCons.constraint_schema = 'koha_nit';
 
[replace koha_nit with your database name]

4. Locate illrequests_ibfk_1
It may not be available and while dropping the above, it may not allow. 
5. Execute the following syntax to solve the problem
ALTER TABLE illrequests DROP FOREIGN KEY illrequests_ibfk_2; 
ALTER TABLE illrequests DROP KEY illrequests_bibfk;

6. Exit from MySQL database.  
7. Now execute the below syntaxt to upgrade database from root. 
koha-upgrade-schema nit [replace nit with your database name] 
 
It will upgrade your database!
 
Enjoy !
 
Thanks 
DP Tripathi 
 
 
 

LIS Notes# 01 - Difference between COUNTER and SUSHI

COUNTER and SUSHI are related standards in the context of managing and reporting usage statistics for electronic resources, commonly used in libraries, publishers, and institutions. Here's what they mean:

COUNTER (Counting Online Usage of Networked Electronic Resources):

  • COUNTER is a standard for measuring the usage of electronic resources like e-journals, e-books, databases, and other digital content.
  • It ensures that usage statistics are consistent, credible, and comparable across publishers and platforms.
  • COUNTER reports provide key metrics, such as:
    • Total item requests (e.g., downloads or views of articles or chapters).
    • Searches within a platform or specific resource.
    • Access denials due to lack of subscription or permissions.
  • The latest version of the standard is COUNTER Release 5, which simplifies and unifies reporting formats compared to earlier releases.

SUSHI (Standardized Usage Statistics Harvesting Initiative):

  • SUSHI is a protocol designed to automate the retrieval of COUNTER usage reports.
  • It uses a machine-to-machine API, making it easier for libraries and institutions to collect usage data from multiple vendors without manual downloading.
  • SUSHI works by enabling systems (like library management software) to directly connect with publishers' platforms and retrieve COUNTER-compliant usage reports.
  • This automation saves time and ensures timely and accurate data collection.

How They Work Together:

  • COUNTER provides the framework for what data to collect and how to present it.
  • SUSHI provides the mechanism for libraries to retrieve COUNTER reports efficiently.

These standards help libraries justify the cost of subscriptions, analyze resource usage, and make data-driven decisions about their collections.

Online Library Internship - Library & Information Science


Librarian Guide introduces one month Online Library Internship for the students who have completed MLISc or pursuing. This internship will provide an opportunity to the students to learn about the library procedures to manage housekeeping operations and also about the different library technologies being used worldwide. 

The interested students may register for this internship provided they have completed the MLISc during 2022 - 2024 or pursuing the same in the current academic year. 

The internship will include the following: 

a. Acquisition - Complete Book Purchase Process

b. Technical Processing - Classification & Cataloguing

c. Circulation & Patron Management

d. Serial Control & E-Resource Management 

e. Library Technologies such as Koha, DSpace, Joomla, WordPress etc. 

f. Stack Management

h. Other important work of Library

This internship will be in the ONLINE mode and only for one month and will be conduced only from Monday to Friday. 

Dates : June 01 - 30, 2024

Timing : 8:00 pm - 9:30 pm

Link to Join : Will be shared to the registered participants only 

Seats : Total 100

Selection : The candidates will be selected based on their marksheet or the eligibility criteria fixed by the selection committee. 

Registration Fee : There is no registration fee for this online internship. 

Registration Link : https://forms.gle/PbeuTHEriUgmM3WG6 

If you have any query / concern, you may please write to librarianguide@gmail.com

After successful completion of Internship, an online exam will be conducted. The successful candidates will be issued e-certificate. 


Pragya Tripathi
Librarian Guide