APPLICATION OF WEB SERVICES BASED ON SITUATION-ORIENTED DATABASE FOR MONITORING THE VIEWING OF THE EDUCATIONAL VIDEO-CONTENT

UDC 004.65
DOI:10.26102/2310-6018/2019.26.3.031

V.V. Mironov, A.S. Gusarenko, N.I. Yusupova


This article discusses the task of monitoring student views of educational videos hosted on YouTube video hosting. A solution to this problem is proposed based on the control and analysis of comments posted by students during viewing. The organization of this process is discussed, as well as the functionality of the video viewing monitoring subsystem, which provides for the collection and analysis of student comments, as part of the university educational system. The structure of a relational database for the accumulation of information about video views is considered. Examples of analytical reports on watching videos aimed at students and teachers are given. To fill the relational data warehouse (ETL process), as well as to generate analytical reports on video viewing, a situation-oriented database (SODB) is used. The SODB capabilities for organizing micro-services using the example of heterogeneous data management, which are extracted from the YouTube API and the database of the educational system storage, are demonstrated and then placed in a relational database based on the concept of virtual documents displayed on heterogeneous data sources. This implementation is explained when mapping virtual documents to web services such as the YouTube API. A set of REST-services is developed that is developed on the base of SODB to solve the task of monitoring views. The universality and simplicity of the hierarchical situational model of the SODB is noted both when defining web services and when managing them. The practical implementation of the subsystem for monitoring the views of educational videos on the PHP platform is described.

Keywords: educational videos, monitoring views, YouTube API, ETL-process, analytical reports, integration heterogeneous data, situation-oriented databases, REST-services, microservices.

Full text:
MironovSoavtori_3_19_1.pdf