Bibliometric data calculation for evaluating the academic work of an Institution

Bootcamp Organizes: Dimitrios Kouis, George Veranis, Vasilis Kalavrouziotis

Audience: People interested in metrics and especially in citation analysis and bibliometrics, library data, assessment methods, data processing.

Expertise: To be able to understand coding in C#, Visual studio and writing SQL queries in MySQL or other relational databases.

Required: Laptop with at least: Visual Studio (presentation will run on Visual Studio Community 2015 version), MySQL client and WAMP or LAMP or MAMP.

Programming Experience: Visual studio, C#, MySQL & SQL


The huge amount of documents available through the internet gives great possibilities to apply bibliometrics within the framework of the librarians’ daily work. Different bibliographic databases register daily thousands of references to literature in almost any subject field. Bibliometric studies can be based on index terms, words in the titles of documents, authors, sources or geographical or time distributions.
Bibliometrics can be defined as the statistical analysis of bibliographic data. Traditionally, bibliometrics has focused on the quantitative analysis of citations and citation counts. Sometimes bibliographic data refer to an author’s number of publications, author’s number of citations per publication, value of H-index and other bibliographic indices. These types of data can be retrieved from bibliographic services such as Scopus, Science Direct, etc. Scopus has even developed an API for Scopus subscribers. The Scopus APIs expose curated abstracts and citation data from all scholarly journals indexed by Scopus, Elsevier's abstract and citation database.
Bibliometrics can be categorized into qualitative and quantitative metrics. These metrics are important:
  • For measuring patterns of authorship, publications and the use of the literature,
  • For evaluating impact of individuals, groups, departments and institutes
  • For measuring by author (calculation of H Index) or by publication (calculation of Journal Impact factor)
Some of the uses of bibliometrics are for University Rankings, Assessment of career for university professors (tenure track), Research Assessment, Performance Assessment, Research Funders, Research Management, Benchmarking and CVs.
Institutions benefit from the use of bibliometrics. Bibliometric analysis can be used to help identify an institution's research strengths, to benchmark its performance, and to inform research strategy development. The use of bibliometrics in the assessment of research performance is, however, not without its controversies
Research productivity and quality: Publishing activities analysis can be used to measure research productivity (number of publications) and, by combining it with for example Publication ratings (impact factor), also quality of research. Publishing activities analyses mainly focus on research productivity, so the statistics are based on the number of publications.
Research impact and visibility: citation analyses: Citation analysis can be used to measure research impact and visibility. Citations are being considered as a form of peer review. Using citations as a measure of impact means measuring how much other researchers are using the research output of a certain unit as source material in their own research. Citation analysis can be used to compare the quality of research of a department to the international level.
Other uses include, Cooperation and networking: Which researchers/organizations/countries are publishing together. Scientific publication practices: Which researchers and which organization cite whom and where and when
In this bootcamp, we will develop, a C# program for retrieving bibliographic data using the Scopus API. Then the retrieved data will be saved into a local database. We will introduce how the Scopus API works and create tools that will be used for bibliographic data manipulation. For implementation you will be able to use either sample input data (from National Technical University of Athens), or data from your own academic institution.
With the data retrieval and input to the MySQL database, we will create the appropriate SQL queries needed for determining the bibliometric measurements.