DOI: 10.17587/prin.7.408-413

Software Mechanisms for Scientometrical Data Aggregation Based on Ontological Representation of the Relational Database Structure

S. A. Afonin, serg@msu.ru, A. S. Kozitsyn, alexanderkz@mail.ru, D. A. Shachnev, mitya57@mitya57.me, Moscow State University, Moscow, 119991, Russian Federation

Corresponding author: Shachnev Dmitry A., Postgraduate Student, Moscow State University, Moscow, 119991, Russian Federation, e-mail: mitya57@mitya57.me

The article presents a mathematical model and a software implementation of the aggregator of scientometrical data which describes the results of individuals’ activities. The model is based on using the ontological structure of data categories and on summation of values of different parameters (indicators) which define various components of the activity measuring, for each of these categories. Based on calculation formulas the SQL queries to the relational database are built, which are used to fill the table with the activity results corresponding to the formula. The model can be used for finding the individuals or groups that have shown the best results in a certain area, and for collecting the statistics about the departments’ activities. As an example of database structure is used the structure of the ISTINA informational-analytical system (Intellectual System of Thematic Examination of Scientometrical data) which has been developed and successfully exploited for three years at Lomonosov Moscow State University. The data aggregation mechanisms have been successfully tested on that system.

Keywords: ontologies, Semantic Web, scientometrical data, SQL query generation, data aggregation

pp. 408–413

For citation:
Afonin S. A., Kozitsyn A. S., Shachnev D. A. Software Mechanisms for Scientometrical Data Aggregation Based on Ontological Representation of the Relational Database Structure, Programmnaya Ingeneria, 2016, vol. 7, no. 9, pp. 408—413.