Joint program processing of heterogeneous design documents in educational IT design

А. S. Gusarenko

Информационные технологии интеллектуальной поддержки принятия решений, Информационные технологии интеллектуальной поддержки принятия решений 2024

А. S. Gusarenko

Изменена: 2025-02-28

Аннотация

The article discusses the issues heterogeneous design documents processing and automated design system data in the field of information technology. Collaboration aspects between teachers, consultants and students in the role of performers are discussed. The main processed data categories are identified, such as office documents, marked-up text, letters, messages, and databases. The data processing features for typical functions of educational design are analyzed. Processing heterogeneous data technological aspects are considered: the document formats variety, local and remote sources and data receivers, format-oriented processing tools, access methods to files, archives, web services and DBMS are analyzed. A document processing generalized model is constructed using format-oriented objects, as well as a conceptual model of the data involved in processing. It is concluded that to reduce labor intensity, the developer needs a new data abstraction layer, called virtual documents.

Ключевые слова

instructional design; external data model; heterogeneous data integration; docx; xlsx; vsdx; NoSQL; SQL.

Литература

1. UUNiT. Course project "Databases". Department of Automated Control Systems: website [Online]. Available: http://hsm.ugatu.su/artem/dbproj/ (Accessed July, 11.2024) (In Russian).

2. Klimova A. V., Kovtunenko A. S., Parfenov D. V. “Curriculum development using RDF-storage technology” // SIIT, 2022, vol. 4, no. 2 (9), pp. 49-55. (In Russian). EDN: QMYQDT.

3. Gusarenko A. S. "Situation-oriented databases: processing heterogeneous documents of microservices in a document based storage" // MOIT, 2022, vol. 10, no. 4, pp. 1-16. (In Russian). EDN: XPOGWA. DOI: 10.26102/2310-6018/2022.39.4.003.

4. Shoufan A. Estimating the cognitive value of YouTube’s educational videos: A learning analytics approach // Computers in Human Behavior. 2019. Vol. 92. Pp. 450-458. DOI: 10.1016/j.chb.2018.03.036.

5. Mironov V. V., Gusarenko A. S., Yusupova N. I. "Situation-oriented databases: processing office documents" // MOIT, 2022, vol. 10, no. 2, pp. 1-16. (In Russian). EDN: WXTJMP.

6. Mironov V. V., Gusarenko A. S., Tuguzbaev G. A. “Personalization of graphic design documents in educational design: functional model of the conceptual level” // Ontology of Designing, 2023, vol. 13, no. 3(49), pp. 333-351. (In Russian). EDN: GEPSYX.

7. ECMA-376 [Online]. Available: https://ecmainternational.org/publications-andstandards/standards/ecma-376/ (Accessed July, 11.2024).

8. Mironov V., Gusarenko A., Yusupova N. RESTful web services development in situation-oriented databases // Proc. 8th Scientific Conference on Information Technologies for Intelligent Decision Making Support (ITIDS’2020). Atlantis Press. 2020. Рp. 1-6. DOI: 10.2991/assehr.k.201029.001.

9. Gajnullin R. F., Bragin D. G. “Diagramming Language Analyzer for Microsoft Visio” // Information Technologies, no. 6. 2013. pp. 18–21. (In Russian). EDN: OLXSFV.

10. Guo W. et al. Information hiding in OOXML format data based on the splitting of text elements // Proc. 2019 IEEE International Conference on Intelligence and Security Informatics. 2019. Рp. 188-190. DOI: 10.1109/ISI.2019.8823564.

11. Ensign C. OpenDocument V1.3 OASIS Standard published [Online]. Available: https://www.oasisopen.org/2021/ 06/16/ opendocument-v1-3-oasisstandard-published/ (Accessed July, 11.2024).

12. PHP: Database Extensions – Manual [Online]. URL: https://www.php.net/manual/en/refs.database.php (Accessed July, 11.2024).

13. Document Object Model (DOM) Level 1 Specification [Online]. Available: https://www.w3.org/TR/RECDOM-Level-1/ (Accessed May, 17.2020).

14. Mironov V. V., Gusarenko A. S, Yusupova N. I., "Monitoring youtube video views in the educational environment based on situation-oriented database and RESTful web services" // SIIT, 2021, vol. 3, no. 1 (5), pp. 39-49. (In Russian). EDN: JWDKZZ.

15. Mironov V. V.,Gusarenko A. S., Yusupova N. I. "Displaying virtual XML-documents on MySQL tables in the situation-oriented databases,"distributed" approach" // Journal of Information Technologies and Computing Systems, 2022, vol. 10, no. 2, pp. 77-89. (In Russian). EDN: YKJYOD.

16. Hou X. et al. Comparison of word processing document format in OOXML and ODF // Proc. 6th International Conference on Semantics, Knowledge and Grid. 2010. Рp. 297-300. DOI: 10.1109/SKG.2010.44.

17. Mironov V. V., Gusarenko A. S., Yusupova N. I. "Structuring virtual multi-documents in situationallyoriented databases by means of entry-elements" // Trudy SPIIRAN, 2017, no. 4 (53), pp. 255-240. (In Russian). EDN: YUJGDH.

18. Mironov V. V., Gusarenko A. S., Yusupova N. I. “Situation-oriented databases: integration of XML data with a relational DBMS” // Control Systems and Information Technology, no. 1(151), 2017, pp. 48–56. (In Russian). EDN: WITPMN.

19. Mironov V. V., Gusarenko A. S., Yusupova N. I. “Invariance of the virtual data” // Herald of Computer and Information Technologies, no. 1(151), 2017, pp. 29–36. (In Russian). EDN: XQORHR.

20. Mironov V. V., Gusarenko A. S., Tuguzbaev G. A. // Informatika i Avtomatizatsiya, 2021, vol. 20, no. 4, pp. 940-970. (In Russian). EDN: YNTPOZ.