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

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.

1. Poche E. et al. Analyzing User Comments on YouTube Coding Tutorial Videos. In: IEEE International Conference on Program Comprehension. 2017. P. 196–206.

2. Shoufan A. Estimating the cognitive value of YouTube’s educational videos: A learning analytics approach. Computers in Human Behavior. 2019. Vol. 92. P. 450–458.

3. Silva H., Azevedo I. Instructional videos and others on Youtube: Similarities and differences in comments. In: CSEDU 2017 - Proceedings of the 9th International Conference on Computer Supported Education. 2017. Vol. 1. P. 418–425.

4. Lee C.S. et al. Making sense of comments on YouTube educational videos: A self-directed learning perspective. Online Information Review. 2017. Vol. 41, № 5. P. 611–625.

5. Saurabh S., Gautam S. Modelling and statistical analysis of YouTube’s educational videos: A channel Owner’s perspective. Computers and Education. 2019. Vol. 128. P. 145–158.

6. Mitrovic A. et al. Reflective experiential learning: Using active video watching for soft skills training. In: ICCE 2016 - 24th International Conference on Computers in Education: Think Global Act Local - Main Conference Proceedings. 2016. P. 192–201.

7. Mironov V. V., Gusarenko A. S., Yusupova N. I. Stream handling large volume documents in situationally-oriented databases. In: International Scientific Journal INDUSTRY 4.0. Scientific Technical Union of Mechanical Engineering “INDUSTRY 4.0.” 2018. Vol. 3, № 5. P. 240–244.

8. Mironov V.V., Gusarenko A.S., Yusupova N.I. Integration of Virtual Multidocument Mappings into Real Data Sources in Situational-Oriented Databases. Applied Informatics. 2018. Vol. 13, № 3(75). P. 47–60.

9. Mironov V.V., Gusarenko A.S., Yusupova N.I. Structuring virtual multidocuments in situationally-oriented databases by means of entry-elements. SPIIRAS Proceedings. 2017. Vol. 4, № 53. P. 225–242.

10. Mironov V.V., Gusarenko A.S., Yusupova N.I. Displaying virtual XMLdocuments on MySQL tables in the situation-oriented databases, “distributed approach”. Journal of Information Technologies and Computing Systems. 2017. № 1. P. 77–89.

11. Mironov V.V., Gusarenko A.S., Yusupova N.I. The Invariance of The Virtual Data in The Situationally Oriented Database When Displayed on Heterogeneous Data Storages. Herald of Computer and Information Technologies. 2017. № 1(151). P. 29–36.

12. Mironov V.V., Gusarenko A.S., Yusupova N.I. Situation-Oriented Databases: Current State and Prospects for Research. Vestnik UGATU. 2015. Vol. 19, № 2 (68). P. 188–199.

13. Mironov V.V., Gusarenko A.S. Using of RESTful-Services in SituationallyOriented Databases. Vestnik UGATU. 2015. Vol. 19, № 1 (67). P. 232–239.

14. What’s a (micro)service – part 1?, http://chrisrichardson.net/post/microservices/general/2019/02/16/whats-aservice-part-1.html, last accessed 06/05/2019.

15. What are microservices?, http://microservices.io/index.html, last accessed 06/05/2019.

16. Microservices Pattern: Microservice Architecture pattern, http://microservices.io/patterns/microservices.html, last accessed 06/05/2019.

17. Microservices Pattern: A pattern language for microservices, http://microservices.io/patterns/, last accessed accessed: 06/05/2019.

18. Dixon D. PHP Microservices — Creating A Basic Restful Crud API, https://medium.com/helium-mvc/php-microservices-creating-a-basic-restfulcrud-api-dabb1a1941a5, last accessed 06/05/2019.

19. Wang F.-J., Fahmi F. Constructing a service software with microservices. In: Proceedings - 2018 IEEE World Congress on Services, SERVICES 2018. 2018. P. 33–34.

20. Villaça L.H.N., Azevedo L.G., Baio F. Query strategies on polyglot persistence in microservices. In: Proceedings of the ACM Symposium on Applied Computing. 2018. P. 1725–1732.

21. Dragoni N. et al. Microservices: How to make your application scale // Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics). 2018. Vol. 10742 LNCS. P. 95–104.

22. Donham J. A domain-specific language for microservices. In: Scala 2018 - Proceedings of the 9th ACM SIGPLAN International Symposium on Scala, co-located with ICFP 2018. 2018. P. 2–12.

23. Cavallari M., Tornieri F. Information systems architecture and organization in the Era of MicroServices. Lecture Notes in Information Systems and Organisation. 2018. Vol. 24. P. 165–177.

24. Petrasch R. Model-based engineering for microservice architectures using Enterprise Integration Patterns for inter-service communication. In: Proceedings of the 2017 14th International Joint Conference on Computer Science and Software Engineering, JCSSE 2017 2017.